MMDW: A Multi-dimensional and Multi-granular Schema for Data Warehousing

Publikation: Bidrag til bog/antologi/rapportBidrag til bog/antologi

Abstract

With the emergence of modern database technologies, the
concept of multi-granular data warehousing, which stores data at multiple levels of granularity has become important. In order to store multigranular data, the existing data warehousing schemas, such as star and snowflake are unable to provide support, for the reason that they are designed to store data at a single level of granularity. In this paper, we present a multi-dimensional and multi-granular data warehousing schema (MMDW). MMDW is based on Relational OLAP (ROLAP) and uses a RDBMS to manage new and old (aggregated) data by means of an extended star schema. In contrast to traditional ROLAP, MMDW also allows pre-computation and storage of data at multiple levels of granularity. Furthermore, MMDW is evaluated based on a real world case study and results show that MMDW performs well in terms of aggregation query speed, aggregation query complexity as well as storage used and compares favorably with standard star schema.
OriginalsprogEngelsk
TitelAdvances in Knowledge-Based and Intelligent Information and Engineering Systems (KES 2012)
RedaktørerManuel Grana, Carlos Toro, Jorge Posada, Robert Howlett
Antal sider10
Udgivelses stedSpain
ForlagIOS Press
Publikationsdatosep. 2012
Sider1211 - 1220
ISBN (Trykt)978-1-61499-104-5
ISBN (Elektronisk)978-1-61499-105-2
StatusUdgivet - sep. 2012
NavnFrontiers in Artificial Intelligence and Applications
Vol/bind243

Citationsformater

Iftikhar, N. (2012). MMDW: A Multi-dimensional and Multi-granular Schema for Data Warehousing. I M. Grana, C. Toro, J. Posada, & R. Howlett (red.), Advances in Knowledge-Based and Intelligent Information and Engineering Systems (KES 2012) (s. 1211 - 1220). IOS Press. Frontiers in Artificial Intelligence and Applications, Bind. 243