Home // ICCGI 2014, The Ninth International Multi-Conference on Computing in the Global Information Technology // View article

Deductive Data Warehouses and Aggregate (Derived) Tables

Authors:
Kornelije Rabuzin
Mirko Malekovic
Mirko Cubrilo

Keywords: data warehouse; deductive data warehouse; Datalog; aggregate tables; derived tables; data mart.

Abstract:
In one of our previous papers, the idea of deductive data warehouses has been introduced. It was shown how to use Datalog rules to perform Online Analytical Processing (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 aggregate and derived tables that are normally used to speed up the process of retrieving data. Since it is good to have aggregate and derived tables (to speed up queries), the main drawback is that they require extra storage. Consequently implicit defini-tion of such tables may seem interesting.

Pages: 72 to 77

Copyright: Copyright (c) IARIA, 2014

Publication date: June 22, 2014

Published in: conference

ISSN: 2308-4529

ISBN: 978-1-61208-346-9

Location: Seville, Spain

Dates: from June 22, 2014 to June 26, 2014