Automated selection of materialized views and indexes for SQL databases

Proceedings of the 26th International Conference on Very Large Data Bases, VLDB'00

Volumn , Issue , 2000, Pages 496-505

  Agrawal, Sanjay ^a   Chaudhuri, Surajit ^a   Narasayya, Vivek ^a  

^a MICROSOFT RESEARCH   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

AUTOMATED SELECTION; END-TO-END SOLUTIONS; EXPERIMENTAL EVALUATION; MATERIALIZED VIEW; MICROSOFT; NON-TRIVIAL TASKS; SQL DATABASE; VIEW SELECTION;

DATABASE SYSTEMS; DIGITAL STORAGE;

STRENGTH OF MATERIALS;

EID: 0039785178     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (22)

1. AutoAdmin project.Microsoft Research.p://www.research.microsott.corn/dmx/ AuloAdiiiin
2. Agrawal R., Ramakrishnan, S.Fast Algorithms for Mining Association Rules in Large Databases, VLDB 1994.
3. Baralis E., Paraboschi S.Teniente E.Materialized View Selection in a Multidimensional Database, VLDB 1997.
4. Chaudhuri S.Narasayya V., An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server.VLDB 1997.
5. Chaudhuri S., Narasayya V.AutoAdmin ;What-If' Index Analysis Utility.ACM SIGMOD 1998.
6. Chaudhuri S., Narasayya V., Automating Statistics Management for Query Optimizers.ICDE 200O
7. Chaudhuri S., Narasayya V.Index Merging.ICDE 1999.
8. Finkelstein S, Schkolnick M, Tiberio P.Physical Database Design for Relational Databases, ACM TODS.Mar.1988.
9. Gupta H.Selection of Views to Materialize in a Data Warehouse.ICDT.1997.
10. Gupta H.Mumick IS.Selection of Views to Materialize Under a Maintenance-Time Constraint.ICDT 1999.
11. II.Gupta H.Harinarayan V., Rajaramana A., UlIman iD.Index Selection for OLAP, ICDE 1997.
12. Harinarayan V., Rajaramana A.Ullman J.D.Implementing Data Cubes Efficiently.ACM SIGMOD 1996.
13. Kotidis Y., Roussopoulos N.DynaMat: A Dynamic View Management System for Data Warehouses.ACM SIGMOD 1999.
14. http://www.oracle.com!
15. Rozen S.Automating Physical Database Design: An Extensible Approach.Ph.D.Dissertation.New York Univeristy, 1993.
16. http:/lwww.informix.comiinformix/solutions/dw/redbricklvistal
17. Rozen S., Shasha D.A Framework for Automating Physical Database Design.VLDB 1991.
18. Shukla A., Deshpande P.M.Naughton iF., Materialized View Selection for Multidimensional Datasets.VLDB 1998.
19. Shukla A., Deshpande P.M.Naughton iF., Ramaswaniy K., Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies.VLDB 1996.
20. TPC Benchmark H (Decision Support) Revision 1.1.O http://www.tpc.org/
21. Valentin G.Zuliani M., Zilio D.Lohman G.Skelley A.DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes ICDE 200O
22. Yang i., Karlapalem K., Li Q.Algorithms For Materialized View Design in Data Warehousing Environment.VLDB 1997.