The Data Model Resource Book, Volume 1

CHAPTER14Additional Star Schema Designs

This chapter provides some additional star schema designs for common functions of the organization, such as inventory management analysis, purchase order analysis, logistics/shipment analysis, work effort analysis, and financial analysis.

Each of the Universal Data Model chapters (Chapters 3 through 9) have corresponding data analysis or star schema designs that can help analyze data. Chapter 2, which covers parties, provides constructs that are used in many of the star schemas such as CUSTOMER, SUPPLIER, INTERNAL ORGANIZATION, FACILITY, and so on. The following illustrates the corresponding data model chapter for the star schemas defined in this chapter.

Chapter 3, which includes inventory management models, corresponds to the inventory management star schema of this chapter.

Chapter 4, which includes purchase order and purchase order item models, corresponds to the purchase order star schema of this chapter.

Chapter 5, which includes shipment models, corresponds to the shipment star schema of this chapter.

Chapter 6, which includes work effort models, corresponds to the work effort star schema of this chapter.

Chapter 7, which includes invoicing models, corresponds to the customer invoices star schemas in chapter 12, Figures 12.1-12.4.

Chapter 8, which includes accounting and budgeting models, corresponds to the financial analysis star schema of this chapter.

Chapter 9, which includes human resources models, corresponds to the human resources ...