A study on workload-aware wavelet synopses for point and range-sum queries

In this paper we perform an extensive theoretical and experimental study on common synopsis construction algorithms, with emphasis on wavelet based techniques, that take under consideration query workload statistics. Our goal is to compare, “expensive” quadratic time algorithms with “cheap” near-linear time algorithms, particularly when the latter are not optimal and/or not workload-aware for the problem at hand. Further, we present the first known algorithm for constructing wavelet synopses for a special class of range-sum query workloads. Our experimental results, clearly justify the necessity for designing workload-aware algorithms, especially in the case of range-sum queries. Categories and Subject Descriptors H.2.7b [Database Managment]: Data Warehouse and Repository General Terms Algorithms, Experimentation Keywords OLAP, wavelet, synopsis, workload-aware

• Type: Conference
• Year: 2006
• Where: DOLAP
• Authors: Michael Mathioudakis, Dimitris Sacharidis, Timos K. Sellis
• Keywords: DOLAP 2006, Information Management, Query Workloads, Synopsis Construction Algorithms, Time Algorithms