Data Warehousing >
Concepts
Several concepts are of particular importance to data warehousing. They are
discussed in detail in this section.
Dimensional Data Model: Dimensional data model is commonly used in data
warehousing systems. This section describes this modeling technique.
Slowly Changing Dimension: This is a common issue facing data warehousing
practioners. This section explains the problem, and describes the three
ways of handling this problem with examples.
Conceptual, Logical, and Physical Data Model: Different levels of abstraction
for a data model. This section explains their differences and lists the
steps for constructing each.
What is OLAP: Definition of OLAP.
MOLAP, ROLAP, and HOLAP: What are these different types of OLAP technology? This section discusses how they are
different from the other, and the advantages and disadvantages of each.
Bill Inmon vs. Ralph Kimball: These two data warehousing heavyweights
have a different view of the role between data warehouse and data mart.
|