메뉴 건너뛰기




Volumn 179, Issue 13, 2009, Pages 2263-2272

An index selection method without repeated optimizer estimations

Author keywords

Configuration recommendation; Database management system (DBMS); Index selection problem (ISP); Optimizer; Performance tuning

Indexed keywords

CONFIGURATION RECOMMENDATION; DATABASE MANAGEMENT SYSTEM (DBMS); INDEX SELECTION PROBLEM (ISP); OPTIMIZER; PERFORMANCE TUNING;

EID: 64549155243     PISSN: 00200255     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.ins.2009.02.009     Document Type: Article
Times cited : (5)

References (30)
  • 1
    • 0000843040 scopus 로고
    • An algorithm for large zero-one knapsack problems
    • Balas E., and Zemel E. An algorithm for large zero-one knapsack problems. Operations Research 28 (1980) 1130-1154
    • (1980) Operations Research , vol.28 , pp. 1130-1154
    • Balas, E.1    Zemel, E.2
  • 5
    • 38049071057 scopus 로고    scopus 로고
    • Selection and pruning algorithms for bitmap index selection problem using data mining
    • Bellatreche L., Missaoui R., Necir H., and Drias H. Selection and pruning algorithms for bitmap index selection problem using data mining. Lecture Notes in Computer Science 4654 (2007) 221-230
    • (2007) Lecture Notes in Computer Science , vol.4654 , pp. 221-230
    • Bellatreche, L.1    Missaoui, R.2    Necir, H.3    Drias, H.4
  • 7
    • 0029519455 scopus 로고
    • Exact and approximate algorithms for the index selection problem in physical database design
    • Caprara A., Fischetti M., and Maio D. Exact and approximate algorithms for the index selection problem in physical database design. IEEE Transactions on Knowledge and Data Engineering 7 6 (1995) 955-967
    • (1995) IEEE Transactions on Knowledge and Data Engineering , vol.7 , Issue.6 , pp. 955-967
    • Caprara, A.1    Fischetti, M.2    Maio, D.3
  • 13
    • 84976836562 scopus 로고
    • The difficulty of optimum index selection
    • Comer D. The difficulty of optimum index selection. ACM Transactions on Database Systems 3 4 (1978) 440-445
    • (1978) ACM Transactions on Database Systems , vol.3 , Issue.4 , pp. 440-445
    • Comer, D.1
  • 14
    • 0037411406 scopus 로고    scopus 로고
    • A knowledge-based approach for index selection in relational databases
    • Feldman Y.A., and Reouven J. A knowledge-based approach for index selection in relational databases. Expert Systems with Applications 25 1 (2003) 15-37
    • (2003) Expert Systems with Applications , vol.25 , Issue.1 , pp. 15-37
    • Feldman, Y.A.1    Reouven, J.2
  • 17
    • 0027608375 scopus 로고
    • Query evaluation techniques for large databases
    • Graefe G. Query evaluation techniques for large databases. ACM Comput. Surv. 25 2 (1993) 73-169
    • (1993) ACM Comput. Surv. , vol.25 , Issue.2 , pp. 73-169
    • Graefe, G.1
  • 19
    • 0017217582 scopus 로고
    • An integer programming formulation of computer data base design problems
    • Hoffer J.A. An integer programming formulation of computer data base design problems. Information Sciences 11 1 (1976) 29-48
    • (1976) Information Sciences , vol.11 , Issue.1 , pp. 29-48
    • Hoffer, J.A.1
  • 20
    • 64549106596 scopus 로고    scopus 로고
    • C.J. Huang, A New Approach to Evaluating Index Benefit Using Database System Statistics, Master Thesis of National Chung Hsing University, Taiwan, 2004.
    • C.J. Huang, A New Approach to Evaluating Index Benefit Using Database System Statistics, Master Thesis of National Chung Hsing University, Taiwan, 2004.
  • 22
    • 0021437481 scopus 로고
    • Query optimization in database systems
    • Jarke M., and Koch J. Query optimization in database systems. ACM Comput. Surv. 16 2 (1984) 111-152
    • (1984) ACM Comput. Surv. , vol.16 , Issue.2 , pp. 111-152
    • Jarke, M.1    Koch, J.2
  • 23
    • 33750324776 scopus 로고    scopus 로고
    • Cost modeling of spatial operators using non-parametric regression
    • Jiang S., Lee B.S., and He Z. Cost modeling of spatial operators using non-parametric regression. Information Sciences 177 2 (2007) 607-631
    • (2007) Information Sciences , vol.177 , Issue.2 , pp. 607-631
    • Jiang, S.1    Lee, B.S.2    He, Z.3
  • 24
    • 2542579372 scopus 로고    scopus 로고
    • Toward autonomic computing with DB2 universal database
    • Lightstone S.S., Lohman G., and Zilio D. Toward autonomic computing with DB2 universal database. SIGMOD Rec. 31 3 (2002) 55-61
    • (2002) SIGMOD Rec. , vol.31 , Issue.3 , pp. 55-61
    • Lightstone, S.S.1    Lohman, G.2    Zilio, D.3
  • 29
    • 33645887842 scopus 로고    scopus 로고
    • An efficient algorithm for the collapsing knapsack problem
    • Wu J., and Srikanthan T. An efficient algorithm for the collapsing knapsack problem. Information Sciences 176 12 (2006) 1739-1751
    • (2006) Information Sciences , vol.176 , Issue.12 , pp. 1739-1751
    • Wu, J.1    Srikanthan, T.2


* 이 정보는 Elsevier사의 SCOPUS DB에서 KISTI가 분석하여 추출한 것입니다.