Title :
Customized answers to summary queries via aggregate views
Author :
Malvestuto, Francesco M. ; Pourabbas, Elaheh
Author_Institution :
Dept. of Comput. Sci., La Sapienza Univ. of Rome, Italy
Abstract :
Statistical users typically require summary tables and want fast and accurate answers to their queries. Usually, the query system keeps materialized aggregate views to speed up the evaluation of summary queries. If the summary table on the variable of interest to a statistical user is not derivable from the set of materialized aggregate views, the answer to his query will consist of an estimate and, if the user is a domain expert, he would like to participate in the estimation process. Therefore, he should be left the possibility of "tuning" the response to an auxiliary variable, for which either there is a materialized aggregate view or aggregate data can be externally provided by the user himself In this framework, we solve the computational problems related to the estimation of summary queries, and propose efficient algorithms which make use of notions and techniques developed in the theory of acyclic database schemes.
Keywords :
data analysis; data mining; query processing; statistical databases; acyclic database schemes; aggregate views; customized answers; data aggregation; domain expert; estimation process; on-line analytical processing; query processing; statistical users; summary queries; summary tables; Aggregates; Computer science; Councils; Databases; Delay; Multidimensional systems; Performance evaluation; Query processing; Throughput; Time measurement;
Conference_Titel :
Scientific and Statistical Database Management, 2004. Proceedings. 16th International Conference on
Print_ISBN :
0-7695-2146-0
DOI :
10.1109/SSDM.2004.1311211