Benefits of Normalization

The normalization of a database provides a schema of relationships (tables) that makes the users requests in order to access the tables of the database as well as the administrator (DBA) efforts for the overall management of every entity (object) in the database.

On the other hand through normalization we achieve reduction of data redundancy which simplifies data structures and conserves disk space. Thus, the possibility to have inconsistent data is minimized because duplicate data is minimized. It is much easier to manage small tables that have been created by the normalization process than to modify big tables that hold all the vital data in the database. Under a normalized schema of tables that is contained by small tables we obtain more flexibility to retrieve the structure of the database. Additionally, we can control the security of a database when it is normalized. Security takes place in connection with the Database Administrator (DBA) who is responsible to give access rights and privileges to certain users. So, the better handling on database security demands the database to be normalized. When normalization has occurred we have data integrity which is the assurance of consistent and accurate data within a database. In terms of database performance, normalization brings a disadvantage that is the database performance reduction.   This occurs because we need more input/output (I/O) processing, CPU usage and memory usage in order to handle SQL queries for a normalized database with many small tables which are associated with primary and foreign keys. But you can solve this problem implementing software techniques or methodologies that try to reduce the Database Server response time and achieve better database performance. For this critical matter that concerns the Database Driven Site Optimization we have developed our own Session Scripting Programming (SSP) methodology as a Server scripting programming approach that optimizes the Web Server performance completely.