• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Leveraging the Power of OLAP... > Introduction to Data Warehouses and ...

Introduction to Data Warehouses and OLAP Cubes

You will want to be familiar with what OLAP cubes are so that you can make full use of them. You can trace how operational data becomes an OLAP cube in this section.

Operational Data

A traditional Online Transaction Processing (OLTP) database such as Access or SQL Server will store data across several related tables. In the convenience store chain, the cash registers might store data in tables called Customers, Orders, Order Details, and Products. Figure 10.1 shows the table structure for the cash register.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint