1 / 17

Data Warehouse

Data Warehouse. Week 8 Introduction of Data Warehouse Multidimensional Analysis: OLAP. Data Warehouse. Integrated, Subject-Oriented, Time-Variant, Nonvolatile database that provides support for decision making. Characteristics of Data Warehouse. Integrated Centralized

hansel
Download Presentation

Data Warehouse

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 Warehouse Week 8 Introduction of Data Warehouse Multidimensional Analysis: OLAP Fox MIS Spring 2011

  2. Data Warehouse • Integrated, Subject-Oriented, Time-Variant, Nonvolatile database that provides support for decision making

  3. Characteristics of Data Warehouse • Integrated • Centralized • Holds data retrieved from entire organization • Time Variant • Flow of data through time • Projected data • Non-Volatile • Data never removed • Always growing • Subject-Oriented • Optimized to give answers to diverse questions • Used by all functional areas

  4. Multidimensional Analysis:OLAP (Online Analytical Processing)

  5. Online Analytical Processing (OLAP) • Advanced data analysis environment • Supports decision making, business modeling, and operations research activities • Characteristics of OLAP • Use multidimensional data analysis techniques • Provide advanced database support • Provide easy-to-use end-user interfaces • Support client/server architecture

  6. Example: Sales

  7. Multidimensional View of Sales • Multidimensional analysis involves viewing data simultaneously categorized along potentially many dimensions

  8. OLAP Server with Multidimensional Data Store Arrangement

  9. Simple OLAP

  10. Slice and Dice

  11. Pivoting

  12. OLAB Cube Example

  13. OLAP Screen Example

  14. OLAP Screen Example

  15. Data Warehouse Modeling: Star Schema • Data-modeling technique • Also called star-join schema, data cube, or multi-dimensional schema • The simplest style of data warehouse schema. • The star schema consists of one or more fact tables referencing any number of dimension tables • Maps multidimensional decision support into relational database • Yield model for multidimensional data analysis while preserving relational structure of operational DB • Facts • The fact table holds the main data. It includes a large amount of aggregated data, such as price and units sold • Dimensions • Dimension tables, which are usually smaller than fact tables, include the attributes that describe the facts. • Attributes

  16. Star Schema for Sales

  17. Data Warehouse Implementation Road Map

More Related