Tag: denormalization

Pro Members SQL Server Standard Members

Understanding Data Normalization

by

Understanding Data Normalization Author: Basit A. Farooq Introduction Normalization, which is the key part of the OLTP databases logical design process, is a design requirement for OLTP databases. Normalization refers to a process used to design relational database tables. Its objectives include minimizing the duplication of information within OLTP databases, as well as reducing the overall size of databases and...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
DB2 Pro Members Standard Members

Materialized Query Tables…and the Death of Denormalization?

by

Materialized Query Tables…and the Death of Denormalization? By Craig S. Mullins Materialized Query Tables, or MQTs, are provided by many relational database systems as a means of speeding up access to static data. You also may know them as Automatic Summary Tables, or ASTs, but regardless of the name, the functionality is basically the same. Though not exclusively for data...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →