Deductive Data Warehouses and Aggregate (Derived) Tables

In one of our previous papers, the idea of deduc- tive data warehouses has been introduced. It was shown how to use Datalog rules to perform Online Analytical P rocessing (OLAP) analysis on data. In this paper, we show how to use Datalog rules to specify the data warehouse model ( data mart) as well as how to add rules that produce aggr egate and derived tables that are normally used to speed up t he process of retrieving data. Since it is good to have aggreg ate and derived tables (to speed up queries), the main draw back is that they require extra storage. Consequently implicit defini- tion of such tables may seem interesting.

[1]  Bernd Neumayr,et al.  Towards ontology-based OLAP: datalog-based reasoning over multidimensional ontologies , 2012, DOLAP '12.

[2]  Paulraj Ponniah,et al.  Data warehousing fundamentals : a comprehensive guide for IT professionals , 2001 .

[3]  Ralph Kimball,et al.  The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data , 2004 .

[4]  Ibm Redbooks.  Data Modeling Techniques for Data Warehousing , 1998 .

[5]  John V. Harrison,et al.  Maintenance of Materialized Views in a Deductive Database: An Update Propagation Approach , 1992, Workshop on Deductive Databases, JICSLP.

[6]  Christopher Adamson.  Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance , 2006 .

[7]  Matija Novak,et al.  Prototype of a Web ETL Tool , 2014 .

[8]  Kornelije Rabuzin.  Deductive Data Warehouses , 2014, Int. J. Data Warehous. Min..

[9]  Chuck Ballard,et al.  Data Modeling Techniques for Data Warehousing , 1999 .

[10]  David Taniar,et al.  Mining Association Rules in Data Warehouses , 2005, Int. J. Data Warehous. Min..

[11]  Patrick Marcel,et al.  Summarizing and Querying Logs of OLAP Queries , 2011, EGC.

[12]  Jean-François Boulicaut,et al.  Query-Driven Knowledge Discovery via OLAP manipulations , 2001, BDA.

[13]  Mirko Maleković,et al.  Using Deductive Data Warehouses to Analyze Data , 2014 .

[14]  Fon Silvers.  Building and Maintaining a Data Warehouse , 2008 .

[15]  W. H. Inmon,et al.  Building the Data Warehouse,3rd Edition , 2002 .