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