Monthly Archives: December 2012

Denormalization

In a relational database, denormalization is an approach to speeding up read performance (data retrieval) in which the administrator selectively adds back specific instances of redundant data after the data structure has been normalized. A denormalised data model is not … Continue reading

Posted in RDBMS concepts | Leave a comment

Normalization

Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only … Continue reading

Posted in RDBMS concepts | Leave a comment

SQL Commands

SQL commands are instructions used to communicate with the database to perform specific task that work with data. There are 4 types of SQL Commands as follows: Data Definition Language (DDL) – DDL commands are used for creating, modifying, and … Continue reading

Posted in SQL | Leave a comment