1 / 15

Data Warehousing DATA CUBES

Data Warehousing DATA CUBES. Instructor: Peter Rawsthorne. The Data Warehouse Architecture. Organizationally structured Departmentally structured Individually structured. Other names. Sources of OLAP data.

carsyn
Download Presentation

Data Warehousing DATA CUBES

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data WarehousingDATA CUBES Instructor: Peter Rawsthorne

  2. The Data Warehouse Architecture • Organizationally structured • Departmentally structured • Individually structured

  3. Other names

  4. Sources of OLAP data • The OLAP level of data originates from the organizationally structured level of data in the data warehouse. This detailed, historical data is the heart of the data warehouse and forms a perfect foundation for the OLAP level of data.

  5. Differences between OLAP and DWHS

  6. Departmental Customizations

  7. Slice and Dice

  8. INDEXING • there may be thirty or forty indexes in the OLAP environment. • while there may be as few as two or three indexes in the detailed environment.

  9. Analysis

  10. Explorers and Farmers

  11. Drill Down

  12. OLAP META data • descriptive information about what is in the OLAP environment: • content, • structure • definition, etc.; • the source of the data • the business and technical name of the data; • a description of the summarization, subset, superset … • the data’s journey into the OLAP environment; • metrics that describe the data • scheduling information, describing data population; • modeling information, describing how the data in the OLAP environment relates to the corporate data model

  13. Physical Design of OLAP

  14. External Data External data can come from any number of sources. It may be fed directly into the OLAP environment or may be fed into the organizationally structured environment where it can then be passes along to the OLAP environment.

  15. Shifts the workload

More Related