Deductive Data Warehouses and Aggregate (Derived) Tables

Abstract- 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 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