Database system multi-column index selection for a workload
作者： Vivek Narasayya , Surajit Chaudhuri
DOI:
关键词: Reverse index 、 Database 、 Database server 、 Data mining 、 Query optimization 、 Index selection 、 Index (economics) 、 Column (database) 、 Computer science 、 Database index 、 Workload
摘要: An index selection tool helps reduce costs in time and memory selecting an configuration or set of indexes for use by a database server accessing accordance with workload queries. The attempts to the number be considered, configurations enumerated, invocations query optimizer workload.
lens.org 参考文章(22)
Ken England, Lilian Hobbs, Rdb/VMS, a comprehensive guide ,(1991)
Surajit Chaudhuri, Method and apparatus for optimizing queries having group-by operators ,(1996)
S.C. Chang, R.S. Choenni, Henk Blanken, A framework for a tool for physical database design Proceedings 3rd Ingres Benelux Users Conference. pp. 96- 107 ,(1992)
Shaibal Roy, Database system with improved methods for B-tree maintenance ,(1995)
Martin R. Frank, Edward R. Omiecinski, Shamkant B. Navathe, Adaptive and Automated Index Selection in RDBMS extending database technology. pp. 277- 292 ,(1992) , 10.1007/BFB0032437
Dennis Shasha, Steve Rozen, A Framework for Automating Physical Database Design very large data bases. pp. 401- 411 ,(1991)
Frank Olken, Doron Rotem, Simple Random Sampling from Relational Databases very large data bases. pp. 160- 169 ,(1986)
Kyuseok Shim, Surajit Chaudhuri, Method and apparatus for query optimization in a relational database system having foreign functions ,(1993)
Brijesh Agarwal, Database system with methods for improving query performance with cache optimization strategies ,(1997)
Vivek R. Narasayya, Surajit Chaudhuri, An Efficient Cost-Driven Index Selection Tool for Microsoft SQL Server very large data bases. pp. 146- 155 ,(1997)