{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,10,16]],"date-time":"2026-10-16T06:46:28Z","timestamp":1792133188131,"version":"4.4.0"},"publisher-location":"New York, NY","reference-count":4,"publisher":"Springer New York","isbn-type":[{"value":"9781461482666","type":"print"},{"value":"9781461482659","type":"electronic"}],"license":[{"start":{"date-parts":[[2018,1,1]],"date-time":"2018-01-01T00:00:00Z","timestamp":1514764800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"},{"start":{"date-parts":[[2018,1,1]],"date-time":"2018-01-01T00:00:00Z","timestamp":1514764800000},"content-version":"vor","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2018]]},"DOI":"10.1007\/978-1-4614-8265-9_197","type":"book-chapter","created":{"date-parts":[[2018,12,6]],"date-time":"2018-12-06T07:59:07Z","timestamp":1544083147000},"page":"1851-1854","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":2,"title":["Index Tuning"],"prefix":"10.1007","author":[{"given":"Philippe","family":"Bonnet","sequence":"first","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Dennis","family":"Shasha","sequence":"additional","affiliation":[],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"297","published-online":{"date-parts":[[2018,12,7]]},"reference":[{"key":"197_CR9276","volume-title":"Joe celko\u2019s SQL for smarties: advanced SQL programming","author":"J Celko","year":"2005","unstructured":"Celko J. Joe celko\u2019s SQL for smarties: advanced SQL programming. 3rd ed. San Fransisco: Morgan Kaufmann; 2005.","edition":"3"},{"key":"197_CR9277","volume-title":"The data warehouse toolkit: the complete guide to dimensional modeling","author":"R Kimball","year":"2002","unstructured":"Kimball R, Ross M. The data warehouse toolkit: the complete guide to dimensional modeling. 2nd ed. New York: Wiley; 2002.","edition":"2"},{"key":"197_CR9278","volume-title":"Database tuning: principles, experiments and troubleshooting techniques","author":"D Shasha","year":"2002","unstructured":"Shasha D, Bonnet P. Database tuning: principles, experiments and troubleshooting techniques. San Fransisco: Morgan Kaufmann; 2002."},{"key":"197_CR9279","volume-title":"SQL tuning","author":"D Tow","year":"2003","unstructured":"Tow D. SQL tuning. Sebastopol: O\u2019Reilly; 2003."}],"container-title":["Encyclopedia of Database Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/link.springer.com\/content\/pdf\/10.1007\/978-1-4614-8265-9_197","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2026,10,16]],"date-time":"2026-10-16T06:04:50Z","timestamp":1792130690000},"score":1,"resource":{"primary":{"URL":"https:\/\/link.springer.com\/chapter\/10.1007\/978-1-4614-8265-9_197"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2018]]},"ISBN":["9781461482666","9781461482659"],"references-count":4,"URL":"https:\/\/doi.org\/10.1007\/978-1-4614-8265-9_197","relation":{},"subject":[],"published":{"date-parts":[[2018]]},"assertion":[{"value":"7 December 2018","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}}]}}