Saturday, October 20, 2012

Dimensional Data Mode

Saturday, October 20, 2012
            Dimensional data model is most often used in data warehousing systems. This is different from the 3rd normal form, commonly us...

Junk Dimension

Saturday, October 20, 2012
In data warehouse design, frequently we run into a situation where there are yes/no indicator fields in the source system. Through busines...

MOLAP, ROLAP, And HOLAP

Saturday, October 20, 2012
           In the OLAP world, there are mainly two different types: Multidimensional OLAP (MOLAP) and Relational OLAP (ROLAP). Hybrid OLAP...

What Is OLAP

Saturday, October 20, 2012
                   OLAP stands for On-Line Analytical Processing. The first attempt to provide a definition to OLAP was by Dr. Codd, who...

Data Integrity

Saturday, October 20, 2012
Data integrity refers to the validity of data, meaning data is consistent and correct. In the data warehousing field, we frequently hear ...