Current Slide

Small screen detected. You are viewing the mobile version of SlideWiki. If you wish to edit slides you will need to use a larger device.

OLAP Server Architectures

  • Relational OLAP (ROLAP)
    • Use relational or extended-relational DBMS to store and manage warehouse data and OLAP middle ware
    • Include optimization of DBMS backend, implementation of aggregation navigation logic, and additional tools and services
    • Greater scalability
  • Multidimensional OLAP (MOLAP)
    • Sparse array-based multidimensional storage engine
    • Fast indexing to pre-computed summarized data
  • Hybrid OLAP (HOLAP) (e.g., Microsoft SQLServer)
    • Flexibility, e.g., low level: relational, high-level: array
  • Specialized SQL servers (e.g., Redbricks)
    • Specialized support for SQL queries over star/snowflake schemas

Speaker notes:

Content Tools

Sources

There are currently no sources for this slide.