{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,4,28]],"date-time":"2025-04-28T09:27:24Z","timestamp":1745832444249},"reference-count":26,"publisher":"Elsevier BV","issue":"3","license":[{"start":{"date-parts":[[1993,12,1]],"date-time":"1993-12-01T00:00:00Z","timestamp":754704000000},"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":["Data & Knowledge Engineering"],"published-print":{"date-parts":[[1993,12]]},"DOI":"10.1016\/0169-023x(93)90023-i","type":"journal-article","created":{"date-parts":[[2003,3,14]],"date-time":"2003-03-14T17:15:20Z","timestamp":1047662120000},"page":"207-233","source":"Crossref","is-referenced-by-count":21,"title":["On the selection of secondary indices in relational databases"],"prefix":"10.1016","volume":"11","author":[{"given":"Sunil","family":"Choenni","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Henk M.","family":"Blanken","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Thiel","family":"Chang","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"key":"10.1016\/0169-023X(93)90023-I_BIB1","doi-asserted-by":"crossref","first-page":"68","DOI":"10.1145\/320521.320537","article-title":"Minimum cost selection of secondary indexes for formatted files","volume":"2","author":"Anderson","year":"1977","journal-title":"ACM Trans. Database Syst."},{"key":"10.1016\/0169-023X(93)90023-I_BIB2","first-page":"24","article-title":"Index selection in relational databases","volume":"89","author":"Barcucci","year":"1989"},{"issue":"1","key":"10.1016\/0169-023X(93)90023-I_BIB3","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 Trans. Software Engrg."},{"issue":"4","key":"10.1016\/0169-023X(93)90023-I_BIB4","doi-asserted-by":"crossref","first-page":"602","DOI":"10.1145\/319628.319650","article-title":"Query processing in a system for distributed databases (SDD-1)","volume":"6","author":"Bernstein","year":"1981","journal-title":"ACM Trans. Database Syst."},{"issue":"4","key":"10.1016\/0169-023X(93)90023-I_BIB5","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":"Bonanno","year":"1985","journal-title":"Comput. J."},{"key":"10.1016\/0169-023X(93)90023-I_BIB6","series-title":"A separability-based method for secondary index selection in physical database design, methodology and tools for data base design","first-page":"149","author":"Bonfatti","year":"1983"},{"issue":"5","key":"10.1016\/0169-023X(93)90023-I_BIB7","doi-asserted-by":"crossref","first-page":"253","DOI":"10.1145\/360762.360766","article-title":"Analysis and performance of inverted database structures","volume":"18","author":"Cardenas","year":"1975","journal-title":"Commun. ACM"},{"key":"10.1016\/0169-023X(93)90023-I_BIB8","series-title":"Proc. Internat. Conf. on Computing and Information","article-title":"Index selection in relational databases","author":"Choenni","year":"1993"},{"key":"10.1016\/0169-023X(93)90023-I_BIB9","series-title":"Proc. ACM Symp. Applied Computing","first-page":"358","article-title":"On the automation of physical database design","author":"Choenni","year":"1993"},{"issue":"4","key":"10.1016\/0169-023X(93)90023-I_BIB10","doi-asserted-by":"crossref","first-page":"440","DOI":"10.1145\/320289.320296","article-title":"The difficulty of optimum index selection","volume":"3","author":"Comer","year":"1978","journal-title":"ACM Trans. Database Syst."},{"issue":"1","key":"10.1016\/0169-023X(93)90023-I_BIB11","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 Trans. Database Syst."},{"key":"10.1016\/0169-023X(93)90023-I_BIB12","first-page":"6","article-title":"A combinatorial problem related to the selection of indices for a file","author":"Haitsma","year":"1975"},{"issue":"2","key":"10.1016\/0169-023X(93)90023-I_BIB13","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":"SE-9","author":"Ip","year":"1983","journal-title":"IEEE Trans. Software Engrg."},{"issue":"11","key":"10.1016\/0169-023X(93)90023-I_BIB14","doi-asserted-by":"crossref","first-page":"945","DOI":"10.1145\/182.358456","article-title":"On estimating block accesses in database organizations","volume":"26","author":"Luk","year":"1983","journal-title":"Commun. ACM"},{"key":"10.1016\/0169-023X(93)90023-I_BIB15","series-title":"Proc. Internat. Conf. on Very Large Databases","first-page":"401","article-title":"A framework for automating database design","author":"Rozen","year":"1991"},{"key":"10.1016\/0169-023X(93)90023-I_BIB16","doi-asserted-by":"crossref","first-page":"141","DOI":"10.1016\/0306-4379(75)90003-4","article-title":"The optimal selection of secondary indices for files","volume":"1","author":"Schkolnick","year":"1975","journal-title":"Informat. Syst."},{"key":"10.1016\/0169-023X(93)90023-I_BIB17","series-title":"Proc. Internat. Conf. on Very Large Databases","first-page":"474","article-title":"A survey of physical database design methodology and techniques","author":"Schkolnick","year":"1978"},{"issue":"2","key":"10.1016\/0169-023X(93)90023-I_BIB18","doi-asserted-by":"crossref","first-page":"163","DOI":"10.1145\/3857.3863","article-title":"Estimating the cost of updates in a relational database","volume":"10","author":"Schkolnick","year":"1985","journal-title":"ACM Trans. Database Syst."},{"issue":"2","key":"10.1016\/0169-023X(93)90023-I_BIB19","doi-asserted-by":"crossref","first-page":"304","DOI":"10.1287\/opre.26.2.305","article-title":"Minimizing a submodular function on a lattice","volume":"26","author":"Topkis","year":"1978","journal-title":"Operat. Res."},{"key":"10.1016\/0169-023X(93)90023-I_BIB20","volume":"Vol. 1","author":"Ullman","year":"1988"},{"key":"10.1016\/0169-023X(93)90023-I_BIB21","series-title":"Proc. Internat. Conf. on Very Large Data Bases","first-page":"487","article-title":"Separability \u2014 An approach to physical database design","author":"Whang","year":"1981"},{"issue":"11","key":"10.1016\/0169-023X(93)90023-I_BIB22","doi-asserted-by":"crossref","first-page":"940","DOI":"10.1145\/182.358452","article-title":"Estimating block accesses in database organizations: a closed noniterative formula","volume":"26","author":"Whang","year":"1983","journal-title":"Commun. ACM"},{"issue":"1","key":"10.1016\/0169-023X(93)90023-I_BIB23","doi-asserted-by":"crossref","first-page":"57","DOI":"10.1016\/0306-4379(85)90009-2","article-title":"Property of separability in physical design of networkmodel databases","volume":"10","author":"Whang","year":"1984","journal-title":"Informat. Syst."},{"key":"10.1016\/0169-023X(93)90023-I_BIB24","series-title":"Proc. Foundations of Data Organization","first-page":"487","article-title":"Index selection in relational databases","author":"Whang","year":"1987"},{"issue":"3","key":"10.1016\/0169-023X(93)90023-I_BIB25","doi-asserted-by":"crossref","first-page":"410","DOI":"10.1287\/moor.7.3.410","article-title":"Maximising real-valued submodular functions: Primal and dual heuristics for location problems","volume":"7","author":"Wolsey","year":"1982","journal-title":"Math Operat. Res."},{"issue":"4","key":"10.1016\/0169-023X(93)90023-I_BIB26","doi-asserted-by":"crossref","first-page":"260","DOI":"10.1145\/359461.359475","article-title":"Approximating block accesses in database organizations","volume":"20","author":"Yao","year":"1977","journal-title":"Commun. ACM"}],"container-title":["Data & Knowledge Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0169023X9390023I?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0169023X9390023I?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,3,26]],"date-time":"2019-03-26T15:50:52Z","timestamp":1553615452000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/0169023X9390023I"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1993,12]]},"references-count":26,"journal-issue":{"issue":"3","published-print":{"date-parts":[[1993,12]]}},"alternative-id":["0169023X9390023I"],"URL":"https:\/\/doi.org\/10.1016\/0169-023x(93)90023-i","relation":{},"ISSN":["0169-023X"],"issn-type":[{"value":"0169-023X","type":"print"}],"subject":[],"published":{"date-parts":[[1993,12]]}}}