Running head: DATA WAREHOUSE DESIGNData Warehouse Design: A Case Study of CarHireOZName of the StudentName of the University
DATA WAREHOUSE DESIGN2Table of Contents1. Data Warehouse Bus Matrix:.......................................................................................................32. Star Schema for the Data Marts:..................................................................................................42.1 Rental and Sales:........................................................................................................................42.2 Advertisement_Commercials:...................................................................................................53. Fact Table, Granularity and Justification against Granularity:....................................................64. Justification and Attribute Hierarchy of the Dimension Tables:.................................................85. Data Warehouse Design Features:.............................................................................................136. Identification of Fields:..............................................................................................................14Bibliography:.................................................................................................................................17
DATA WAREHOUSE DESIGN31. Data Warehouse Bus Matrix:BusinessprocessesDimensionsVEHICLE_TYPE_DIMENSIONVEHICLE_DIMENSIONCUSTOMER_DIMENSIONMEMBER_CLASS_DIMENSIONBOOKING_DIMENSIONDRIVER_DIMENSIONCONTRACTS_DIMENSIONRETURN_PROTOCOL_DIMENSIONDATE_DIMENSIONPRODUCT_PROMOTION_DIMENSIONITEM_DIMENSIONSTORES_DIMENSIONMEDIA_COMPANY_DIMENSIONRental and SalesXXXXXXXXXXAdvertisement_CommercialsXXXXXXXX
DATA WAREHOUSE DESIGN42. Star Schema for the Data Marts:2.1 Rental and Sales:
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Data Warehouse Design and Implementationlg...
|17
|1547
|286
Data Warehouse Design: A Case Study of CarHireOZlg...
|14
|1757
|178
Data Warehouse Design : Case Studylg...
|16
|1486
|61
Data Warehouse Design - PDFlg...
|16
|1079
|172
Data Warehouse Design: A Case Study of Chemist Warehouselg...