Dimensional Model of the sales

Home | Previous Page | Next Page Appendix B. The sales_demo and superstores_demo Databases > The sales_demo Database (XPS) >

Dimensional Model of the sales_demo Database

Figure 15 gives an overview of the tables in the sales_demo database.

Figure 15. The sales_demo Dimensional Data Model

Begin figure description. Labelled rectangles depict five tables and their column names. One fact table ("sales") is linked by foreign keys to four dimension tables ("product," "geography," "time," and "customer"). End figure description

For information on how to create and populate the sales_demo database, see the IBM Informix: DB–Access User's Guide. For information on how to design and implement dimensional databases, see the IBM Informix: Database Design and Implementation Guide. For information on the stores_demo database, see Appendix A. The stores_demo Database

The next section describes the schema of these five tables, and identifies the column in the fact table that logically associates each dimension table to the fact table.