Query Rewriting Based on Meta-Granular Aggregation
Analytical database queries are exceptionally time consuming. Decision support systems employ various execution techniques in order to accelerate such queries and reduce their resource consumption. Probably the most important of them consists in materialization of partial results. However, any introduction of additional derived objects into the database schema increases the cost of software development, since programmers must take care of their usage and synchronization. In this paper, the authors propose novel query rewriting methods that build queries using partial aggregations materialized in additional tables. These methods are based on the concept of meta-granules that represent the information on grouping and used aggregations.