{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,29]],"date-time":"2025-09-29T08:24:46Z","timestamp":1759134286909},"reference-count":33,"publisher":"Association for Computing Machinery (ACM)","issue":"2","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2009,8]]},"abstract":"<jats:p>Solid state disks (SSDs) provide much faster random access to data compared to conventional hard disk drives. Therefore, the response time of a database engine could be improved by moving the objects that are frequently accessed in a random fashion to the SSD. Considering the price and limited storage capacity of solid state disks, the database administrator needs to determine which objects (tables, indexes, materialized views, etc.), if placed on the SSD, would most improve the performance of the system. In this paper we propose a tool called \"Object Placement Advisor\" for making a wise decision for the object placement problem. By collecting profile inputs from workload runs, the advisor utility provides a list of objects to be placed on the SSD by applying heuristics like the greedy knapsack technique or dynamic programming. To show that the proposed approach is effective in conventional database management systems, we have conducted experiments on IBM DB2 with queries and schemas based on the TPC-H and TPC-C benchmarks. The results indicate that using a relatively small amount of SSD storage, the response time of the system can be reduced significantly by considering the recommendation of the advisor.<\/jats:p>","DOI":"10.14778\/1687553.1687557","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1318-1329","source":"Crossref","is-referenced-by-count":39,"title":["An object placement advisor for DB2 using solid state storage"],"prefix":"10.14778","volume":"2","author":[{"given":"Mustafa","family":"Canim","sequence":"first","affiliation":[{"name":"University of Texas at Dallas, Richardson, TX"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"George A.","family":"Mihaila","sequence":"additional","affiliation":[{"name":"IBM Watson Research Center, Hawthorne, NY"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Bishwaranjan","family":"Bhattacharjee","sequence":"additional","affiliation":[{"name":"IBM Watson Research Center, Hawthorne, NY"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Kenneth A.","family":"Ross","sequence":"additional","affiliation":[{"name":"Columbia University, New York, NY"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Christian A.","family":"Lang","sequence":"additional","affiliation":[{"name":"IBM Watson Research Center, Hawthorne, NY"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2009,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-30570-5_13"},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066157.1066292"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1142473.1142549"},{"key":"e_1_2_1_4_1","first-page":"169","volume-title":"Proceedings of the 27th International Conference on Very Large Data Bases(VLDB '01)","author":"Ailamaki A.","year":"2001","unstructured":"A. Ailamaki , D. J. DeWitt , M. D. Hill , and M. Skounakis . Weaving relations for cache performance (best paper award) . In Proceedings of the 27th International Conference on Very Large Data Bases(VLDB '01) , pages 169 -- 180 , Sept. 2001 . A. Ailamaki, D. J. DeWitt, M. D. Hill, and M. Skounakis. Weaving relations for cache performance (best paper award). In Proceedings of the 27th International Conference on Very Large Data Bases(VLDB '01), pages 169--180, Sept. 2001."},{"issue":"2","key":"e_1_2_1_5_1","first-page":"20","article-title":"Self-tuning technology in microsoft sql server","volume":"22","author":"Chaudhuri S.","year":"1999","unstructured":"S. Chaudhuri , E. Christensen , G. Graefe , V. R. Narasayya , and M. J. Zwilling . Self-tuning technology in microsoft sql server . IEEE Data Eng. Bull. , 22 ( 2 ): 20 -- 26 , 1999 . S. Chaudhuri, E. Christensen, G. Graefe, V. R. Narasayya, and M. J. Zwilling. Self-tuning technology in microsoft sql server. IEEE Data Eng. Bull., 22(2):20--26, 1999.","journal-title":"IEEE Data Eng. Bull."},{"key":"e_1_2_1_6_1","volume-title":"Introduction to Algorithms","author":"Cormen T. H.","year":"2001","unstructured":"T. H. Cormen , C. Stein , R. L. Rivest , and C. E. Leiserson . Introduction to Algorithms . McGraw-Hill Higher Education , 2001 . T. H. Cormen, C. Stein, R. L. Rivest, and C. E. Leiserson. Introduction to Algorithms. McGraw-Hill Higher Education, 2001."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.5555\/1316689.1316784"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1363189.1363198"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/313310.313345"},{"key":"e_1_2_1_10_1","unstructured":"IBM DB2 Database for Linux UNIX and Windows Information Center. http:\/\/publib.boulder.ibm.com.  IBM DB2 Database for Linux UNIX and Windows Information Center. http:\/\/publib.boulder.ibm.com."},{"key":"e_1_2_1_11_1","volume-title":"Building the Operational Data Store","author":"Inmon W. H.","year":"1999","unstructured":"W. H. Inmon . Building the Operational Data Store . John Wiley & Sons, Inc. , New York, NY, USA , 1999 . W. H. Inmon. Building the Operational Data Store. John Wiley & Sons, Inc., New York, NY, USA, 1999."},{"key":"e_1_2_1_12_1","unstructured":"Z. Kerekes. Are mlc ssds ever safe in enterprise apps? http:\/\/www.storagesearch.com\/ssd-slc-mlc-notes.html.  Z. Kerekes. Are mlc ssds ever safe in enterprise apps? http:\/\/www.storagesearch.com\/ssd-slc-mlc-notes.html."},{"key":"e_1_2_1_13_1","unstructured":"Z. Kerekes. The ssd buyer preferences market report. http:\/\/www.storagesearch.com\/ssdsurvey.html.  Z. Kerekes. The ssd buyer preferences market report. http:\/\/www.storagesearch.com\/ssdsurvey.html."},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.14778\/1453856.1453913"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2002.1047770"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247488"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376723"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2006.11.002"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/360825.360843"},{"key":"e_1_2_1_20_1","unstructured":"L. Mearian. Solid-state disk lackluster for laptops pcs. http:\/\/www.computerworld.com\/action\/article. do?command=printArticleBasic&articleId=9112065.  L. Mearian. Solid-state disk lackluster for laptops pcs. http:\/\/www.computerworld.com\/action\/article. do?command=printArticleBasic&articleId=9112065."},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1007\/s007780050033"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/1236360.1236412"},{"key":"e_1_2_1_23_1","first-page":"311","volume-title":"In Proceedings of the USENIX Annual Technical Conference (USENIX 03","author":"Nugent J. A.","year":"2003","unstructured":"J. A. Nugent , A. C. Arpaci-Dusseau , and R. H. Arpaci-Dusseau . Controlling your place in the file system with gray-box techniques . In In Proceedings of the USENIX Annual Technical Conference (USENIX 03 , pages 311 -- 324 . USENIX Association , 2003 . J. A. Nugent, A. C. Arpaci-Dusseau, and R. H. Arpaci-Dusseau. Controlling your place in the file system with gray-box techniques. In In Proceedings of the USENIX Annual Technical Conference (USENIX 03, pages 311--324. USENIX Association, 2003."},{"key":"e_1_2_1_24_1","unstructured":"Oracle Automated Workload Repository. http:\/\/www.oracle.com\/technology\/deploy\/performance\/index.html.  Oracle Automated Workload Repository. http:\/\/www.oracle.com\/technology\/deploy\/performance\/index.html."},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/1457150.1457153"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.5555\/648311.754748"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.5555\/645371.651315"},{"key":"e_1_2_1_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/1457150.1457154"},{"key":"e_1_2_1_29_1","unstructured":"Microsoft SQLServer Performance Studio. http:\/\/www.microsoft.com\/sqlserver\/2008\/en\/us\/wp-sql-2008-performance-scale.aspx.  Microsoft SQLServer Performance Studio. http:\/\/www.microsoft.com\/sqlserver\/2008\/en\/us\/wp-sql-2008-performance-scale.aspx."},{"key":"e_1_2_1_30_1","unstructured":"TPC-C On-Line Transaction Processing Benchmark. http:\/\/www.tpc.org\/tpcc\/.  TPC-C On-Line Transaction Processing Benchmark. http:\/\/www.tpc.org\/tpcc\/."},{"key":"e_1_2_1_31_1","unstructured":"TPC-H Decision Support Benchmark. http:\/\/www.tpc.org\/tpch\/.  TPC-H Decision Support Benchmark. http:\/\/www.tpc.org\/tpch\/."},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/1275986.1275991"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.5555\/1078026.1078424"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/1687553.1687557","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:56:35Z","timestamp":1672224995000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/1687553.1687557"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2009,8]]},"references-count":33,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2009,8]]}},"alternative-id":["10.14778\/1687553.1687557"],"URL":"https:\/\/doi.org\/10.14778\/1687553.1687557","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2009,8]]}}}