1 / 11

Online Analytical Processing (OLAP)

Dive into Online Analytical Processing (OLAP) to uncover how multidimensional data is collected, stored, and analyzed for insight. Explore OLAP's features, benefits, and three storage methods.

christopherflores
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. Online Analytical Processing (OLAP) Anjali Gupta Mithun Arora Aameek Singh Kranthi Kumar

  2. Introduction OLAP designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.

  3. RDBMS

  4. Table Extension…

  5. Why RDBMS fails … • 2-D Structure • Multiple Joins and Poor Performance • Denormalized Databases Drain Performance & Resources

  6. Enter OLAP !

  7. Consolidation • Pre-aggregation of all logical subtotals and totals • Pre-compute totals by each possible subset in the set of dimensions

  8. Basic Concepts • Dimensions • Measures • Positions • Hierarchies • Schemas - Star & Snowflake

  9. More Features… • Formulae Calculations on the fly • Drill Down & Roll Up Navigation through levels of detail • Slicing & Dicing • Pivot / Rotate Change Dimensional Orientation

  10. Different forms of OLAP Three ways of storing data: • Multidimensional OLAP (MOLAP) Best Query Performance • Relational OLAP (ROLAP) Ideal for large databases • Hybrid OLAP (HOLAP) Best of both worlds!

  11.  thank you 

More Related