{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,6,29]],"date-time":"2024-06-29T13:28:55Z","timestamp":1719667735538},"reference-count":14,"publisher":"Elsevier BV","issue":"1","license":[{"start":{"date-parts":[[2003,7,1]],"date-time":"2003-07-01T00:00:00Z","timestamp":1057017600000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Expert Systems with Applications"],"published-print":{"date-parts":[[2003,7]]},"DOI":"10.1016\/s0957-4174(03)00003-4","type":"journal-article","created":{"date-parts":[[2003,4,25]],"date-time":"2003-04-25T01:00:19Z","timestamp":1051232419000},"page":"15-37","source":"Crossref","is-referenced-by-count":8,"title":["A knowledge-based approach for index selection in relational databases"],"prefix":"10.1016","volume":"25","author":[{"given":"Yishai A.","family":"Feldman","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Jacob","family":"Reouven","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"issue":"1","key":"10.1016\/S0957-4174(03)00003-4_BIB1","doi-asserted-by":"crossref","first-page":"32","DOI":"10.1109\/32.44361","article-title":"Optimal selection of secondary indexes","volume":"16","author":"Barcucci","year":"1990","journal-title":"IEEE Transactions on Software Engineering"},{"issue":"4","key":"10.1016\/S0957-4174(03)00003-4_BIB2","doi-asserted-by":"crossref","first-page":"398","DOI":"10.1093\/comjnl\/28.4.398","article-title":"An approximation algorithm for secondary index selection in relational database physical design","volume":"28","author":"Bonano","year":"1985","journal-title":"The Computer Journal"},{"key":"10.1016\/S0957-4174(03)00003-4_BIB3","unstructured":"Chaudhuri, S., & Narasayya, V (1997). An efficient, cost-driven index selection tool for Micorosft SQL server. VLDB'97, Proceedings of the 23rd International Conference on Very Large Data Bases, Athens, Greece, August 1997."},{"key":"10.1016\/S0957-4174(03)00003-4_BIB4","series-title":"The AI workbench Babylon","year":"1992"},{"issue":"4","key":"10.1016\/S0957-4174(03)00003-4_BIB5","doi-asserted-by":"crossref","DOI":"10.1145\/320289.320296","article-title":"The difficulty of optimum index selection","volume":"3","author":"Comer","year":"1978","journal-title":"ACM Transactions on Database Systems"},{"issue":"1","key":"10.1016\/S0957-4174(03)00003-4_BIB6","doi-asserted-by":"crossref","first-page":"91","DOI":"10.1145\/42201.42205","article-title":"Physical database design for relational databases","volume":"13","author":"Finkelstein","year":"1988","journal-title":"ACM Transactions on Database Systems"},{"key":"10.1016\/S0957-4174(03)00003-4_BIB7","doi-asserted-by":"crossref","unstructured":"Frank, M. R., Omiecinski, E. R. & Navathe, S. B (1992). Adaptive and automated index selection in RDBMS. Proceedings of the 23rd International Conference on Extending Database Technology, Vienna, Austria, March 1992.","DOI":"10.1007\/BFb0032437"},{"issue":"2","key":"10.1016\/S0957-4174(03)00003-4_BIB8","doi-asserted-by":"crossref","first-page":"524","DOI":"10.1093\/comjnl\/28.5.524","article-title":"Towards the optimal secondary index organization and secondary index selection","volume":"28","author":"Hatzopoulo","year":"1985","journal-title":"The Computer Journal"},{"key":"10.1016\/S0957-4174(03)00003-4_BIB9","unstructured":"IBM Corp (1991). IBM DATABASE 2 Version 2.2: Administration Course."},{"key":"10.1016\/S0957-4174(03)00003-4_BIB10","unstructured":"IBM Corp (1993). IBM DATABASE 2 Version 2.2: Administration Guide."},{"issue":"2","key":"10.1016\/S0957-4174(03)00003-4_BIB11","doi-asserted-by":"crossref","first-page":"135","DOI":"10.1109\/TSE.1983.236458","article-title":"On the selection of an optimal set of indexes","volume":"9","author":"Ip","year":"1983","journal-title":"IEEE Transactions on Software Engineering"},{"key":"10.1016\/S0957-4174(03)00003-4_BIB12","series-title":"Knowledge acquisition for expert systems: A practical handbook","author":"Kidd","year":"1987"},{"key":"10.1016\/S0957-4174(03)00003-4_BIB13","unstructured":"King, W. F (1974). On the selection of indices for a file. Technical report, International Business Machines Corp., TR.RJ 1341, San Jose CA."},{"key":"10.1016\/S0957-4174(03)00003-4_BIB14","doi-asserted-by":"crossref","unstructured":"Valentin, G., Zuliani, M., Zilio, D. C., Lohman, G. M., & Skelley, A (2000). DB2 advisor: An optimizer smart enough to recommend its own indexes. Proceedings of the 16th International Conference on Data Engineering, San Diego, CA.","DOI":"10.1109\/ICDE.2000.839397"}],"container-title":["Expert Systems with Applications"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0957417403000034?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:S0957417403000034?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,3,27]],"date-time":"2019-03-27T11:28:10Z","timestamp":1553686090000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/S0957417403000034"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2003,7]]},"references-count":14,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2003,7]]}},"alternative-id":["S0957417403000034"],"URL":"https:\/\/doi.org\/10.1016\/s0957-4174(03)00003-4","relation":{},"ISSN":["0957-4174"],"issn-type":[{"value":"0957-4174","type":"print"}],"subject":[],"published":{"date-parts":[[2003,7]]}}}