1 / 15

Online Analytical Processing (OLAP)

Enterprise Resource P lanning. Online Analytical Processing (OLAP) . What is OLAP?. Basic idea : converting data into information that decision makers need. Concept: Used to analyze data by multiple dimension in a structure called data cube. Data cube structure:. History:.

nelson
Download Presentation

Online Analytical Processing (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. Enterprise Resource Planning Online Analytical Processing (OLAP)

  2. What is OLAP? • Basic idea: converting data into information that decision makers need. • Concept: Used to analyze data by multiple dimension in a structure called data cube.

  3. Data cube structure:

  4. History: • In 1993, E. F. Codd came up with the term online analytical processing (OLAP)and proposed 12 criteria to define an OLAP database. • The term OLAP seems perfect to describe databases designed to facilitate decision making (analysis) in an organization.

  5. Purpose of OLAP: • To derive summarized information from large volume database. • To generate automated reports for human view.

  6. OLAP Implementation: • Multidimensional OLAP (MOLAP) • Relational OLAP (ROLAP) • Hybrid OLAP (HOLAP)

  7. Multidimensional OLAP (MOLAP): • The database is stored in a special, usually proprietary, structure that is optimized for multidimensional analysis • Advantages: Very fast query response time because data is mostly pre-calculated • Disadvantages: Practical limit on the size because the time taken to calculate the database and the space required to hold these pre-calculated values

  8. Relational OLAP (ROLAP): • The database is a standard relational database and the database model is a multidimensional model, often referred to as a star or snowflake model or schema • Advantage: More scalable solution • Disadvantage: Performance of the queries will be largely governed by the complexity of the SQL and the number and size of the tables being joined in the query

  9. Hybrid OLAP (HOLAP): • A hybrid of ROLAP and MOLAP • Can be thought of as a virtual database whereby the higher levels of the database are implemented as MOLAP and the lower levels of the database as ROLAP

  10. Why need OLAP over Relational Database I: • Consistently fast response • OLAP obtains a consistently fast response is by pre-storing calculated values

  11. Why need OLAP over Relational Database II • Metadata-based queries • SQL was developed primarily for transaction systems, not for reporting applications

  12. Why need OLAP over Relational Database III • Spreadsheet-style formulas • Design the data structure with users in mind • Spreadsheets are key components of business management because they are intuitive to create

  13. Benefits of OLAP: • Increase the productivity of business managers, developers and whole organizations • High flexibility • Effective decision making

  14. Thank You

More Related