View and index selection for query-performance improvement: Quality-centered algorithms and heuristics

International Conference on Information and Knowledge Management, Proceedings

Volumn , Issue , 2008, Pages 1329-1330

  Kormilitsin, Maxim ^a   Chirkova, Rada ^a   Stallmann, Matthias ^a   Fathi, Yahya ^a  

^a North Carolina State University   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EFFICIENT METHOD; INDEX SELECTION; MATERIALIZED VIEW; OPTIMUM PERFORMANCE; PERFORMANCE IMPROVEMENTS; PERFORMANCE TUNING; PRECOMPUTING; PROCESSING PERFORMANCE; SELECTION PROBLEMS; TOTAL COST OF OWNERSHIP;

COMPETITION; KNOWLEDGE MANAGEMENT;

DATABASE SYSTEMS;

EID: 70349245428     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1458082.1458261     Document Type: Conference Paper

References (5)

1. S. Agrawal, S. Chaudhuri, and V. R. Narasayya. Automated selection of materialized views and indexes in SQL databases. In VLDB, pages 496-505, 2000.
2. N. Bruno and S. Chaudhuri. Automatic physical database tuning: A relaxation-based approach. In SIGMOD Conf., 2005.
3. S. Chaudhuri, M. Datar, and V. R. Narasayya. Index selection for databases: A hardness study and a principled heuristic solution. IEEE TKDE, 16(11):1313-1323, 2004.
4. M. Held and R. M. Karp. The traveling salesman problem and minimum spanning trees. Oper. Research, 18:1138-1162, 1970.
5. M. Kormilitsin, R. Chirkova, Y. Fathi, and M. Stallmann. Plan-based view and index selection for query-performance improvement. Technical report, NCSU, 2008. Available at http://www.csc.ncsu.edu/research/tech/reports.php.