• 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