A genetic approach for materialised skyline views selection problem. (2016)

• Record Type: Journal Article
• Authors: Brahimi, Samiha; Kholladi, Mohamed-Khireddine
• Is Part Of: International journal of data mining, modelling and management. Volume 8:Number 3(2016)
• Page Start: 223
• Page End: 243
• Publication Date: 2016
• Subjects: skyline queries -- skycube -- materialisation of views -- cost reducing -- genetic algorithms -- data mining -- Orion -- Top-Sky -- view selection -- OLAP queries; Data mining -- Periodicals; Information science -- Periodicals; Databases -- Periodicals; 005.7
• Languages: English
• ISSNs: 1759-1163

Abstract

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.