{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,27]],"date-time":"2025-03-27T02:46:42Z","timestamp":1743043602882,"version":"3.40.3"},"publisher-location":"Berlin, Heidelberg","reference-count":22,"publisher":"Springer Berlin Heidelberg","isbn-type":[{"type":"print","value":"9783642227318"},{"type":"electronic","value":"9783642227325"}],"license":[{"start":{"date-parts":[[2011,1,1]],"date-time":"2011-01-01T00:00:00Z","timestamp":1293840000000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"},{"start":{"date-parts":[[2011,1,1]],"date-time":"2011-01-01T00:00:00Z","timestamp":1293840000000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.springernature.com\/gp\/researchers\/text-and-data-mining"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2011]]},"DOI":"10.1007\/978-3-642-22732-5_6","type":"book-chapter","created":{"date-parts":[[2011,8,30]],"date-time":"2011-08-30T11:21:30Z","timestamp":1314703290000},"page":"59-67","source":"Crossref","is-referenced-by-count":0,"title":["An Interactive Tool for Automatic Index Selection in Relational Database Management Systems"],"prefix":"10.1007","author":[{"given":"Piotr","family":"Ko\u0142aczkowski","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Henryk","family":"Rybi\u0144ski","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","reference":[{"key":"6_CR1","doi-asserted-by":"publisher","first-page":"227","DOI":"10.1145\/1066157.1066184","volume-title":"SIGMOD 2005: Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data","author":"N. Bruno","year":"2005","unstructured":"Bruno, N., Chaudhuri, S.: Automatic physical database tuning: a relaxation-based approach. In: SIGMOD 2005: Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data, pp. 227\u2013238. ACM, New York (2005)"},{"issue":"1","key":"6_CR2","doi-asserted-by":"publisher","first-page":"135","DOI":"10.1007\/BF02568608","volume":"4","author":"A. Caprara","year":"1996","unstructured":"Caprara, A., Salazar, J.: A branch-and-cut algorithm for a generalization of the uncapacitated facility location problem. TOP\u00a04(1), 135\u2013163 (1996), \n                      citeseer.ist.psu.edu\/caprara95branchcut.html","journal-title":"TOP"},{"issue":"6","key":"6_CR3","doi-asserted-by":"publisher","first-page":"955","DOI":"10.1109\/69.476501","volume":"7","author":"A. Caprara","year":"1995","unstructured":"Caprara, A., Fischetti, M., Maio, D.: Exact and approximate algorithms for the index selection problem in physical database design. IEEE Trans. on Knowl. and Data Eng.\u00a07(6), 955\u2013967 (1995)","journal-title":"IEEE Trans. on Knowl. and Data Eng."},{"issue":"2-3","key":"6_CR4","doi-asserted-by":"publisher","first-page":"111","DOI":"10.1016\/S0166-218X(99)00050-5","volume":"92","author":"A. Caprara","year":"1999","unstructured":"Caprara, A., Gonz\u00e1lez, J.J.S.: Separating lifted odd-hole inequalities to solve the index selection problem. Discrete Appl. Math.\u00a092(2-3), 111\u2013134 (1999)","journal-title":"Discrete Appl. Math."},{"key":"6_CR5","unstructured":"Chan, A.Y.: Index selection in a self-adaptive relational data base management system. Tech. rep., Massachusetts Institute of Technology, Cambridge, MA, USA (1976)"},{"key":"6_CR6","first-page":"146","volume-title":"VLDB 1997: Proceedings of the 23rd International Conference on Very Large Data Bases","author":"S. Chaudhuri","year":"1997","unstructured":"Chaudhuri, S., Narasayya, V.R.: An efficient cost-driven index selection tool for Microsoft SQL Server. In: VLDB 1997: Proceedings of the 23rd International Conference on Very Large Data Bases, pp. 146\u2013155. Morgan Kaufmann Publishers Inc., San Francisco (1997)"},{"key":"6_CR7","doi-asserted-by":"crossref","first-page":"519","DOI":"10.1145\/1282480.1282531","volume-title":"VLDB 1975: Proceedings of the 1st International Conference on Very Large Data Bases","author":"G. Farley","year":"1975","unstructured":"Farley, G., Schuster, S.A.: Query execution and index selection for relational data bases. In: VLDB 1975: Proceedings of the 1st International Conference on Very Large Data Bases, pp. 519\u2013519. ACM, New York (1975)"},{"issue":"1","key":"6_CR8","doi-asserted-by":"publisher","first-page":"91","DOI":"10.1145\/42201.42205","volume":"13","author":"S. Finkelstein","year":"1988","unstructured":"Finkelstein, S., Schkolnick, M., Tiberio, P.: Physical database design for relational databases. ACM Trans. Database Syst.\u00a013(1), 91\u2013128 (1988)","journal-title":"ACM Trans. Database Syst."},{"key":"6_CR9","series-title":"LNCS","doi-asserted-by":"publisher","first-page":"791","DOI":"10.1007\/978-3-540-85654-2_71","volume-title":"Database and Expert Systems Applications","author":"P. Ko\u0142aczkowski","year":"2008","unstructured":"Ko\u0142aczkowski, P.: Compressing very large database workloads for continuous online index selection. In: Bhowmick, S.S., K\u00fcng, J., Wagner, R. (eds.) DEXA 2008. LNCS, vol.\u00a05181, pp. 791\u2013799. Springer, Heidelberg (2008)"},{"key":"6_CR10","series-title":"Studies in Computational Intelligence","doi-asserted-by":"crossref","first-page":"3","DOI":"10.1007\/978-3-642-02190-9_1","volume-title":"Automatic Index Selection in RDBMS by Exploring Query Execution Plan Space","author":"P. Ko\u0142aczkowski","year":"2009","unstructured":"Ko\u0142aczkowski, P., Rybiski, H.: Automatic Index Selection in RDBMS by Exploring Query Execution Plan Space. Studies in Computational Intelligence, vol.\u00a0223, pp. 3\u201324. Springer, Heidelberg (2009)"},{"key":"6_CR11","doi-asserted-by":"crossref","unstructured":"Kormilitsin, M., Chirkova, R., Fathi, Y., Stallman, M.: Plan-based view and index selection for query-performance improvement. Tech. Rep.\u00a018. NC State University, Dept. of Computer Science (2008)","DOI":"10.1145\/1458082.1458261"},{"key":"6_CR12","doi-asserted-by":"crossref","unstructured":"Kratica, J., Ljubi\u0107, I., To\u0161i\u0107, D.: A genetic algorithm for the index selection problem (2003), \n                      http:\/\/citeseer.ist.psu.edu\/568873.html","DOI":"10.1007\/3-540-36605-9_26"},{"key":"6_CR13","doi-asserted-by":"publisher","first-page":"736","DOI":"10.1145\/1408800.1408901","volume-title":"ACM 1974: Proceedings of the 1974 Annual ACM Conference","author":"V.Y. Lum","year":"1974","unstructured":"Lum, V.Y.: On the selection of secondary indexes. In: ACM 1974: Proceedings of the 1974 Annual ACM Conference, pp. 736\u2013736. ACM, New York (1974)"},{"key":"6_CR14","doi-asserted-by":"publisher","first-page":"349","DOI":"10.1145\/800184.810505","volume-title":"ACM 1971: Proceedings of the 1971 26th Annual Conference","author":"V.Y. Lum","year":"1971","unstructured":"Lum, V.Y., Ling, H.: An optimization problem on the selection of secondary keys. In: ACM 1971: Proceedings of the 1971 26th Annual Conference, pp. 349\u2013356. ACM, New York (1971)"},{"key":"6_CR15","doi-asserted-by":"publisher","first-page":"439","DOI":"10.1109\/IDEAS.2004.1319819","volume-title":"IDEAS 2004: Proceedings of the International Database Engineering and Applications Symposium (IDEAS 2004)","author":"K.U. Sattler","year":"2004","unstructured":"Sattler, K.U., Schallehn, E., Geist, I.: Autonomous query-driven index tuning. In: IDEAS 2004: Proceedings of the International Database Engineering and Applications Symposium (IDEAS 2004), pp. 439\u2013448. IEEE Computer Society, Washington, DC, USA (2004)"},{"key":"6_CR16","doi-asserted-by":"publisher","first-page":"186","DOI":"10.1145\/500080.500106","volume-title":"SIGMOD 1975: Proceedings of the 1975 ACM SIGMOD International Conference on Management of Data","author":"M. Schkolnick","year":"1975","unstructured":"Schkolnick, M.: Secondary index optimization. In: SIGMOD 1975: Proceedings of the 1975 ACM SIGMOD International Conference on Management of Data, pp. 186\u2013192. ACM, New York (1975)"},{"key":"6_CR17","doi-asserted-by":"publisher","first-page":"793","DOI":"10.1145\/1142473.1142592","volume-title":"SIGMOD 2006: Proceedings of the 2006 ACM SIGMOD International Conference on Management of Data","author":"K. Schnaitter","year":"2006","unstructured":"Schnaitter, K., Abiteboul, S., Milo, T., Polyzotis, N.: Colt: continuous on-line tuning. In: SIGMOD 2006: Proceedings of the 2006 ACM SIGMOD International Conference on Management of Data, pp. 793\u2013795. ACM Press, New York (2006)"},{"key":"6_CR18","doi-asserted-by":"publisher","first-page":"23","DOI":"10.1145\/582095.582099","volume-title":"SIGMOD 1979: Proceedings of the 1979 ACM SIGMOD International Conference on Management of Data","author":"P.G. Selinger","year":"1979","unstructured":"Selinger, P.G., Astrahan, M.M., Chamberlin, D.D., Lorie, R.A., Price, T.G.: Access path selection in a relational database management system. In: SIGMOD 1979: Proceedings of the 1979 ACM SIGMOD International Conference on Management of Data, pp. 23\u201334. ACM, New York (1979)"},{"key":"6_CR19","first-page":"101","volume-title":"ICDE 2000: Proceedings of the 16th International Conference on Data Engineering","author":"A. Skelley","year":"2000","unstructured":"Skelley, A.: DB2 advisor: An optimizer smart enough to recommend its own indexes. In: ICDE 2000: Proceedings of the 16th International Conference on Data Engineering, p. 101. IEEE Computer Society, Washington, DC, USA (2000)"},{"key":"6_CR20","doi-asserted-by":"crossref","unstructured":"Whang, K.Y.: Index selection in relational databases. In: FODO, pp. 487\u2013500 (1985)","DOI":"10.1007\/978-1-4613-1881-1_41"},{"key":"6_CR21","unstructured":"Whang, K.Y., Wiederhold, G., Sagalowicz, D.: Separability - an approach to physical data base design. In: VLDB 1981: Proceedings of the Seventh International Conference on Very Large Data Bases, pp. 320\u2013332. VLDB Endowment (1981)"},{"key":"6_CR22","first-page":"180","volume-title":"ICAC 2004: Proceedings of the First International Conference on Autonomic Computing","author":"D.C. Zilio","year":"2004","unstructured":"Zilio, D.C., Zuzarte, C., Lohman, G.M., Pirahesh, H., Gryz, J., Alton, E., Liang, D., Valentin, G.: Recommending materialized views and indexes with IBM DB2 design advisor. In: ICAC 2004: Proceedings of the First International Conference on Autonomic Computing, pp. 180\u2013188. IEEE Computer Society, Washington, DC, USA (2004)"}],"container-title":["Studies in Computational Intelligence","Emerging Intelligent Technologies in Industry"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-642-22732-5_6","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2023,2,11]],"date-time":"2023-02-11T06:52:59Z","timestamp":1676098379000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/10.1007\/978-3-642-22732-5_6"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2011]]},"ISBN":["9783642227318","9783642227325"],"references-count":22,"URL":"https:\/\/doi.org\/10.1007\/978-3-642-22732-5_6","relation":{},"ISSN":["1860-949X","1860-9503"],"issn-type":[{"type":"print","value":"1860-949X"},{"type":"electronic","value":"1860-9503"}],"subject":[],"published":{"date-parts":[[2011]]}}}