Basics: Dimensional Models

• Reporting DATABASE Training:

• • Relational AND Dimensional Databases
  • Relational = ODS or Data Warehouse
  • Dimensional = Reporting Applications

• OLAP

• • OnLine Analytical Processing
  • IDEAL MODEL FOR:
  • • Few Users, Huge Amounts of Data
    • Aggregates, slice and dice (sales by about 100 different qualifiers)
    • Ie, What is the proportion of ATM withdrawals that occur within 1 mile of the persons primary address?
  • BAD MODEL FOR:
  • • Running your applications