DocumentCode :
2677138
Title :
Fast approximate query answering using precomputed statistics
Author :
Poosala, Viswanath ; Ganti, Venkatesh
Author_Institution :
AT&T Bell Labs., Murray Hill, NJ, USA
fYear :
1999
fDate :
23-26 Mar 1999
Firstpage :
252
Abstract :
Summary form only given. The last few years have witnessed a significant increase in the use of databases for complex data analysis (OLAP) applications. These applications often require very quick responses from the DBMS. However, they also involve complex queries on large volumes of data. Despite significant improvement in database support for OLAP over the last few years, most DBMSs still fall short of providing quick enough responses. We present a novel solution to this problem: we use small amounts of precomputed summary statistics of the data to answer the queries quickly, albeit approximately. Our hypothesis is that many OLAP applications can tolerate approximations in query results in return for huge response time reductions. The work is part of our efforts to build an efficient data analysis system called AQUA. We describe some of the technical problems addressed in this effort
Keywords :
data mining; query processing; statistics; very large databases; AQUA; OLAP applications; complex data analysis; complex queries; data analysis system; database support; databases; fast approximate query answering; precomputed statistics; query results; quick responses; response time reductions; technical problems; Aggregates; Application software; Data analysis; Databases; Delay; Histograms; Multidimensional systems; Statistics; Upper bound; Writing;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Data Engineering, 1999. Proceedings., 15th International Conference on
Conference_Location :
Sydney, NSW
ISSN :
1063-6382
Print_ISBN :
0-7695-0071-4
Type :
conf
DOI :
10.1109/ICDE.1999.754932
Filename :
754932
Link To Document :
بازگشت