{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,10,1]],"date-time":"2025-10-01T15:24:47Z","timestamp":1759332287817},"reference-count":16,"publisher":"Elsevier","isbn-type":[{"type":"print","value":"9780120884698"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2004]]},"DOI":"10.1016\/b978-012088469-8.50095-4","type":"book-chapter","created":{"date-parts":[[2009,11,6]],"date-time":"2009-11-06T09:12:29Z","timestamp":1257498749000},"page":"1087-1097","source":"Crossref","is-referenced-by-count":91,"title":["DB2 Design Advisor"],"prefix":"10.1016","author":[{"given":"Daniel C.","family":"Zilio","sequence":"first","affiliation":[]},{"given":"Jun","family":"Rao","sequence":"additional","affiliation":[]},{"given":"Sam","family":"Lightstone","sequence":"additional","affiliation":[]},{"given":"Guy","family":"Lohman","sequence":"additional","affiliation":[]},{"given":"Adam","family":"Storm","sequence":"additional","affiliation":[]},{"given":"Christian","family":"Garcia-Arellano","sequence":"additional","affiliation":[]},{"given":"Scott","family":"Fadden","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/B978-012088469-8.50095-4_bib1","series-title":"Proceedings of 26th International Conference on Very Large Data Bases","first-page":"496","article-title":"Automated Selection of Materialized Views and Indexes in SQL Databases","author":"Agrawal","year":"2000"},{"key":"10.1016\/B978-012088469-8.50095-4_bib2","series-title":"SIGMOD Conference","article-title":"Integrating Vertical and Horizontal Partitioning Into Automated Physical Database Design","author":"Agrawal","year":"2004"},{"key":"10.1016\/B978-012088469-8.50095-4_bib3","series-title":"SIGMOD Conference","first-page":"460","article-title":"An Overview of DB2 Parallel Edition","author":"Baru","year":"1995"},{"key":"10.1016\/B978-012088469-8.50095-4_bib4","series-title":"SIGMOD Conference","first-page":"488","article-title":"Narasayya: Compressing SQL workloads","author":"Chaudhuri","year":"2002"},{"key":"10.1016\/B978-012088469-8.50095-4_bib5","series-title":"Proceedings ACM SIGMOD International Conference on Management of Data","first-page":"553","article-title":"Microsoft Index Tuning Wizard for SQL Server 7.0","author":"Chaudhuri","year":"1998"},{"key":"10.1016\/B978-012088469-8.50095-4_bib6","series-title":"Proceedings of ACM SIGMOD","article-title":"AutoAdmin \u201cWhat-Il\u201d Index Analysis Utility","author":"Chaudhuri","year":"1998"},{"issue":"1","key":"10.1016\/B978-012088469-8.50095-4_bib7","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 of Database Systems"},{"key":"10.1016\/B978-012088469-8.50095-4_bib8","series-title":"VLDB","first-page":"250","article-title":"The Value of Merge-Join and Hash-Join in SQL Server","author":"Graefe","year":"1999"},{"key":"10.1016\/B978-012088469-8.50095-4_bib12","series-title":"VLDB","article-title":"Automated design of Multi-dimensional Clustering tables for relational databases","author":"Lightstone","year":"2004"},{"key":"10.1016\/B978-012088469-8.50095-4_bib13","series-title":"VLDB","first-page":"877","article-title":"SMART: Making DB2 (More) Autonomic","author":"Lohman","year":"2002"},{"key":"10.1016\/B978-012088469-8.50095-4_bib15","series-title":"SIGMOD Conference","first-page":"637","article-title":"Multi-Dimensional Clustering: A New Data Layout Scheme in DB2","author":"Padmanabhan","year":"2003"},{"author":"Query Patroller","key":"10.1016\/B978-012088469-8.50095-4_bib16"},{"key":"10.1016\/B978-012088469-8.50095-4_bib17","series-title":"SIGMOD Conference","first-page":"558","article-title":"Automating physical database design in a parallel database","author":"Rao","year":"2002"},{"key":"10.1016\/B978-012088469-8.50095-4_bib21","series-title":"Proceedings of the ICDE Conference","first-page":"101","article-title":"DB2 Advisor: An optimizer smart enough to recommend its own indexes","author":"Valentin","year":"2000"},{"key":"10.1016\/B978-012088469-8.50095-4_bib22","series-title":"SIGMOD Conference","first-page":"105","article-title":"Answering Complex SQL Queries Using Automatic Summary Tables","author":"Zaharioudakis","year":"2000"},{"key":"10.1016\/B978-012088469-8.50095-4_bib23","series-title":"International Conference on Autonomic Computing","article-title":"Recommending Materialized Views and Indexes with IBM's DB2 Design Advisor","author":"Zilio","year":"2004"}],"container-title":["Proceedings 2004 VLDB Conference"],"original-title":[],"language":"en","deposited":{"date-parts":[[2018,12,15]],"date-time":"2018-12-15T14:28:54Z","timestamp":1544884134000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/B9780120884698500954"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2004]]},"ISBN":["9780120884698"],"references-count":16,"URL":"https:\/\/doi.org\/10.1016\/b978-012088469-8.50095-4","relation":{},"subject":[],"published":{"date-parts":[[2004]]}}}