Designing and using views to improve performance of aggregate queries (Extended abstract)

Lecture Notes in Computer Science

Volumn 3453, Issue , 2005, Pages 548-554

  Afrati, Foto ^a   Chirkova, Rada ^b   Gupta, Shalu ^b   Loftis, Charles ^b  

^a NATIONAL TECHNICAL UNIVERSITY OF ATHENS   (Greece)

^b North Carolina State University   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

AUTOMATION; COMPUTER AIDED DESIGN; COMPUTER ARCHITECTURE; DATA REDUCTION;

DATA-INTENSIVE SYSTEMS; QUERY REWRITING TECHNIQUES; SYSTEM ARCHITECTURE; VIEW SELECTION TECHNIQUES;

QUERY LANGUAGES;

EID: 24644513054     PISSN: 03029743     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1007/11408079_48     Document Type: Conference Paper

References (22)

1. Afrati, F., Chirkova, R. Selecting and using views to compute aggregate queries. In: Proceedings of ICDT (2005)
2. Cohen, S., Nutt, W., Serebrenik, A. Rewriting aggregate queries using views. In: Proceedings of PODS (1999) 155-166
3. Harinarayan, V., Rajaraman, A., Ullman, J. Implementing data cubes efficiently. In: Proc. SIGMOD (1996) 205-216
4. Shasha, D., Bonnet, P. Database Tuning: Principles, Experiments, and Troubleshooting Techniques. Morgan Kaufmann (2002) http://www.distlab.dk/dbtune/ .
5. Microsoft Research AutoAdmin Project: Self-Tuning and Self-Administering Databases, (http://research.microsoft. com/dmx/autoadmin/default.asp)
6. IBM Autonomie Computing, (http://www.research.ibm.com/autonomic/)
7. Afrati, F., Chirkova, R., Gupta, S., Loftis, C. Designing and Using Views to Improve Performance of Aggregate Queries. Technical Report NCSU CSC TR-2004-26, http: //www4. ncsu. edu/~rychirko/Papers/techReport090904. pdf (2004)
8. Chirkova, R., Gupta, S., Kim, K.H., Sandhu, S. Extensible framework for query-performance enhancement by tuning. Code downloads and documentation are available from http://research.csc.ncsu.edu/selftune/ (2004)
9. Chirkova, R., Halevy, A., Suciu, D. A formal perspective on the view selection problem. VLDB Journal 11 (2002) 216-237
10. Agrawal, S., Chaudhuri, S., Narasayya, V. Automated selection of materialized views and indexes in SQL databases. In: Proceedings of VLDB (2000) 496-505
11. Gupta, H., Harinarayan, V., Rajaraman, A., Ullman, J. Index selection for OLAP. In: Proceedings of ICDE (1997) 208-219
12. Shukla, A., Deshpande, P., Naughton, J. Materialized view selection for multidimensional datasets. In: Proceedings of VLDB (1998) 488-499
13. Halevy, A.Y. Answering queries using views: A survey. VLDB Journal 10 (2001) 270-294
14. Chaudhuri, S., Krishnamurthy, R., Potamianos, S., Shim, K. Optimizing queries with materialized views. In: Proceedings of the Eleventh International Conference on Data Engineering (ICDE) (1995) 190-200
15. Widom, J. Research problems in data warehousing. In: Proceedings of CIKM (1995)
16. Gray, J., Chaudhuri, S., Bosworth, A., Layman, A., Reichart, D., Venkatrao, M. - Data cube: A relational aggregation operator generalizing Group-by, Cross-Tab, and Sub Totals. Data Mining and Knowledge Discovery 1 (1997) 29-53
17. Chaudhuri, S., Dayal, U. An overview of data warehousing and OLAP technology. SIGMOD Record 26 (1997) 65-74
18. Agarwal, S., Agrawal, R., Deshpande, P., Gupta, A., Naughton, J., Ramakrishnan, R., Sarawagi, S. On the computation of multidimensional aggregates. In: Proceedings of VLDB (1996) 506-521
19. Gupta, A., Harinarayan, V., Quass, D. Aggregate-query processing in data warehousing environments. In: Proceedings of VLDB (1995) 358-369
20. Srivastava, D., Dar, S., Jagadish, H., Levy, A. Answering queries with aggregation using views. In: Proc. VLDB (1996) 318-329
21. PostgreSQL (Open source database-management system) http://www. postgresql.org/.
22. TPC-H: TPC Benchmark H (Decision Support). (Available from http://www.tpc.org/tpch/spec/tpch2.1.0.pdf)