A genetic approach for materialised skyline views selection problem

The materialisation of views has been one of the most successful techniques in optimising OLAP queries. In this context, many works have been conducted aiming either at studying the relationships between the views or at solving the materialised views selection problem. For skyline queries, researchers investigated only the first phase of the materialisation whereas the second phase which is the materialised skyline views selection problem has never been studied because of the difficulty of creating a cost model. In this paper, we propose a genetic method for the materialised skyline views selection problem. In order to reduce the high cost produced by evaluating the skycube all over the selection process, we propose a time reducing heuristic called OnceVisited which avoids the computation of the same query from the same views many times. The conducted experiments have proven the efficiency of the genetic approach since high quality solutions have been found. In addition, the proposed time reducing heuristic OnceVisited has been shown to be very efficient.

• skyline queries
• view selection
• genetic algorithm
• query cost reduction

• Advanced Database Systems and Queries
• Data Management and Algorithms
• Big Data and Business Intelligence
• skyline queries
• view selection
• genetic algorithm
• query cost reduction
• Computer Networks and Communications
• Signal Processing
• Management Information Systems
• Computer Science
• Business, Management and Accounting