Answering Complex SQL Queries Using Automatic Summary Tables

SIGMOD 2000 - Proceedings of the 2000 ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2000, Pages 105-116

  Zaharioudakis, Markos ^a   Cochrane, Roberta ^a   Lapis, George ^a   Pirahesh, Hamid ^a   Urata, Monica ^a  

^a IBM ALMADEN RESEARCH CENTER   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

DATABASE SYSTEMS; DECISION SUPPORT SYSTEMS; INFORMATION SYSTEMS; INFORMATION USE;

ACCEPTABLE PERFORMANCE; ARITHMETIC OPERATIONS; DECISION SUPPORT QUERY; MATERIALIZED VIEW; MULTIPLE DIMENSIONS; NOVEL ALGORITHM; SQL QUERY; SUB-QUERIES; SUMMARY TABLES; USER DEFINED FUNCTIONS;

QUERY PROCESSING;

EID: 85134750167     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/342009.335390     Document Type: Conference Paper

References (13)

1. th VLDB Conf., New York, NY, 1998.
2. th Data Engineering Conf., Taipei, 1995.
3. S. Cohen, W. Nutt, A. Serebrenik, “Rewriting Aggregate Queries Using Views”, Proc. of the ACM-PODS Conf., Philadelphia, PA, 1999.
4. th Data Engineering Conf., 1996.
5. S. Grumbach, M. Rafanelli, L. Tininini, “Querying Aggregate Data”, Proc. of the ACM-PODS Conf., Philadelphia, PA, 1999.
6. th VLDB Conf., Zurich, Switzerland, 1995.
7. V. Harinarayan, A. Rajaraman, J. D. Ullman, “Implementing Data Cubes Efficiently”, Proc. of the ACM-SIGMOD Conf., Montreal, Canada, 1996.
8. A. Y. Levy, A. O. Mendelzon, Y. Sagiv, D. Srivastava, “Answering queries using views”, Proc. of the ACM-PODS Conf., San Jose, CA, 1995.
9. J. Melton (ed.), “Final Committee Draft - Database Language SQL - Part 2: Foundation (SQL/Foundation)”, H2-98-519/DBL FRA-017, 1998.
10. I. S. Mumick, D. Quass, B. S. Mumick, “Maintenance of Data Cubes and Summary Tables in a Warehouse”, Proc. Of the ACM-SIGMOD Conf., Tuscon, AZ, 1997
11. W. Nutt, Y. Sagiv, S. Shurin, “Deciding equivalence among aggregate queries”, Proc. of the ACM-PODS Conf., Seattle, WA, 1998.
12. nd VLDB Conf., Mumbai, India, 1996.
13. Zaharioudakis, R. Cochrane, G. Lapis, H. Pirahesh, M. Urata, “Answering Complex SQL Queries Using Automated Summary Tables”, available upon request from the authors.