Friday, October 9, 2009
Normalization:
Database normalization is a design technique for structuring relational database tables.Highly normalized data reduces the data duplication. Redundant data is removed by the process of normalization.Normalization requires more tables and joins.
Denormalization:
De normalization is the process of attempting to optimize the performance of a data base by adding redundant data. Instead of joining several tables (Which affects the performance) to get a common information, just place some repeated values in the table is the use of de normalization
Surrogate Key
Surrogate key is a unique identifier. It is used to identify each row of a table uniquely. It also helps to track slowly changing dimensions. It replaces all natural keys. Surrogate keys are system generated keys, they are not derived from any data sources.
Subscribe to:
Comments (Atom)
