1 / 7

Kinds of OLAP

willow-roy
Download Presentation

Kinds of OLAP

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. Online analytical processing (OLAP) is a category of software technology that enables analysts, managers, and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information that has been transformed from raw data to reflect the real dimensionality of the enterprise as understood by the user.

  2. Kinds of OLAP • ROLAP- relational OLAP using relational databases; a star schema is used • MOLAP- multidimensional OLAP using multidimensional databases • DOLAP- desktop OLAP • Other variations

  3. An automobile marketer wants to improve business activity. Therefore he wants to view sales figures from different perspectives. The Story • Sales by model • Sales by dealership • Sales by color • Sales over time • etc. The Data Needs What is the trend in sales volumes over a period of time for a specific model and color across a specific group of dealerships ? A Question Example: Olap Usage of an Automobile Marketer

  4. Example: The Multidimensional View of the Data Sales Volumes Van MOD E L Coupe Smith Sedan Clyde Miller Blue Red White DEALERSHIP COLOR

  5. Coupe Clyde Blue White “Sliced and Diced“ Data OLAP Features: “Slicing and Dicing“ the Data Choosing a range out of each dimension: • Color: Blue and White • Model: Coupe only • Dealership: Clyde only Sales Volumes Van MOD E L Coupe Smith Sedan Clyde Miller Blue Red White DEALERSHIP COLOR

  6. View of the Product Manager View of the Account Manager Sales Volumes Rotate the data cube by 90° Van MOD E L Coupe Sedan Miller Smith Clyde DEALERSHIP OLAP Features: Rotating the Data Different users will require different views of the multidimensional cube – OLAP allows easy rotation of data Sales Volumes Van MOD E L Coupe Sedan Blue Red White COLOR

  7. OLAP Features: Drill-Down and Roll-Up Data can be disaggregated and aggregated along a dimension according to their natural hierarchy Sales Volumes by Organization Dimension- three level hierarchy - Roll-Up Georgia State Region Atlanta Athens Dealership Miller Smith Clyde Lucas Gleason Drill-Down

More Related