What is the definition of normalized and denormalized view and what are the differences between them
Normalization is the process of removing redundancies.Denormalization is the process of allowing redundancies.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Describe the differences between XML and HTML? 23.12.08
t's amazing how many developers claim to be proficient programming with XML, yet do not understand the basic differences between XML and HTML. Anyone with a fun...What is Siebel Admin Mode View? How to Create this? 03.11.08
Admin Mode property set to TRUE in View object definition. Admin Mode view overrides the property of Business component. This view allow the user to do u...How do you specify a view to be displayed as aggregate view in Siebel 7.7 03.11.08
when adding view to screen specify the type as aggregate view.But Before that you should create the parent category.then add this parent category to aggrega...What is the definition of normalized and denormalized view and what are the differences between them ? 23.09.08
I would like to add one more pt. here, as OLTP is in Normalized form, more no. of tables are scanned or referred for a single query, as through primary key and...What is the main differnce between schema in RDBMS and schemas in DataWarehouse? 19.09.08
RDBMS Schema * Used for OLTP systems * Traditional and old schema * Normalized * Difficult to understand and navigate * Cannot solve extract and complex pr...If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone? 01.04.08
No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same...What is normalization 11.03.06
The process of removing redundancy by modularizing, as with subroutines, and of removing superfluous differences by reducing them to a common denominator. For e...What is VDL (View Definition Language)? 11.03.06
It specifies user views and their mappings to the conceptual schema....Define SQL and state the differences between SQL and other conventional programming Languages 08.03.06
SQL is a nonprocedural language that is designed specifically for data access operations on normalized relational database structures. The primary difference be...What is a view? How it is related to data independence? 08.03.06
A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying bas...