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

Research output: Chapter in Book/Report/Conference proceedingContribution to book/anthology

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.
Original languageEnglish
Title of host publicationAdvances in Knowledge-Based and Intelligent Information and Engineering Systems (KES 2012)
EditorsManuel Grana, Carlos Toro, Jorge Posada, Robert Howlett
Number of pages10
Place of PublicationSpain
PublisherIOS Press
Publication dateSep 2012
Pages1211 - 1220
ISBN (Print)978-1-61499-104-5
ISBN (Electronic)978-1-61499-105-2
Publication statusPublished - Sep 2012
SeriesFrontiers in Artificial Intelligence and Applications
Volume243

Cite this

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