{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,1]],"date-time":"2025-11-01T16:46:11Z","timestamp":1762015571644},"reference-count":17,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2012,8]]},"abstract":"<jats:p>With the SAP HANA database, SAP offers a high-performance in-memory hybrid-store database. Hybrid-store databases---that is, databases supporting row- and column-oriented data management---are getting more and more prominent. While the columnar management offers high-performance capabilities for analyzing large quantities of data, the row-oriented store can handle transactional point queries as well as inserts and updates more efficiently. To effectively take advantage of both stores at the same time the novel question whether to store the given data row- or column-oriented arises. We tackle this problem with a storage advisor tool that supports database administrators at this decision. Our proposed storage advisor recommends the optimal store based on data and query characteristics; its core is a cost model to estimate and compare query execution times for the different stores. Besides a per-table decision, our tool also considers to horizontally and vertically partition the data and manage the partitions on different stores. We evaluated the storage advisor for the use in the SAP HANA database; we show the recommendation quality as well as the benefit of having the data in the optimal store with respect to increased query performance.<\/jats:p>","DOI":"10.14778\/2367502.2367514","type":"journal-article","created":{"date-parts":[[2014,6,24]],"date-time":"2014-06-24T12:17:57Z","timestamp":1403612277000},"page":"1748-1758","source":"Crossref","is-referenced-by-count":18,"title":["A storage advisor for hybrid-store databases"],"prefix":"10.14778","volume":"5","author":[{"given":"Philipp","family":"R\u00f6sch","sequence":"first","affiliation":[{"name":"SAP Research, SAP AG, Dresden, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Lars","family":"Dannecker","sequence":"additional","affiliation":[{"name":"SAP Research, SAP AG, Dresden, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Franz","family":"F\u00e4rber","sequence":"additional","affiliation":[{"name":"SAP AG, Walldorf, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Gregor","family":"Hackenbroich","sequence":"additional","affiliation":[{"name":"SAP Research, SAP AG, Dresden, Germany"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2012,8]]},"reference":[{"key":"e_1_2_1_1_1","doi-asserted-by":"crossref","first-page":"930","DOI":"10.1145\/1066157.1066292","volume-title":"Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data","author":"Agrawal S.","year":"2005"},{"key":"e_1_2_1_2_1","first-page":"496","volume-title":"Proceedings of the 26th International Conference on Very Large Data Bases","author":"Agrawal S.","year":"2000"},{"key":"e_1_2_1_3_1","doi-asserted-by":"crossref","first-page":"359","DOI":"10.1145\/1007568.1007609","volume-title":"Proceedings of the 2004 ACM SIGMOD International Conference on Management of Data","author":"Agrawal S.","year":"2004"},{"key":"e_1_2_1_4_1","first-page":"169","volume-title":"Proceedings of the 27th International Conference on Very Large Data Bases","author":"Ailamaki A.","year":"2001"},{"key":"e_1_2_1_5_1","first-page":"54","volume-title":"Proceedings of the 25th International Confernce on Very Large Data Bases","author":"Boncz P. A.","year":"1999"},{"key":"e_1_2_1_6_1","first-page":"225","volume-title":"Proceedings of the 2nd Biennial Conference on Innovative Data Systems Research","author":"Boncz P. A.","year":"2005"},{"key":"e_1_2_1_7_1","first-page":"146","volume-title":"Proceedings of the 23rd International Conference on Very Large Data Bases","author":"Chaudhuri S.","year":"1997"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/2094114.2094126"},{"key":"e_1_2_1_9_1","first-page":"105","volume-title":"Proceedings of the 37th International Conference on Very Large Data Bases","author":"Grund M.","year":"2010"},{"key":"e_1_2_1_10_1","first-page":"98","volume-title":"Proceedings of the 6th International Conference on Database Theory","author":"Gupta H.","year":"1997"},{"key":"e_1_2_1_11_1","first-page":"1199","volume-title":"RCFile: A Fast and Space-efficient Data Placement Structure in MapReduce-based Warehouse Systems. In In Proceedings of the 27th International Conference on Data Engineering","author":"He Y.","year":"2011"},{"key":"e_1_2_1_12_1","doi-asserted-by":"crossref","first-page":"117","DOI":"10.1007\/978-3-642-15105-7_10","volume-title":"Proceedings of the 12th International Conference on Data Warehousing and Knowledge Discovery","author":"Lemke C.","year":"2010"},{"key":"e_1_2_1_13_1","first-page":"1","volume-title":"Proceedings of the 35th SIGMOD international conference on Management of data","author":"Plattner H.","year":"2009"},{"key":"e_1_2_1_14_1","first-page":"89","volume-title":"Proceedings of the 28th International Conference on Very Large Databases","author":"Ramamurthy R.","year":"2002"},{"key":"e_1_2_1_15_1","first-page":"60","volume-title":"Proceedings of the 24th International Conference on Data Engineering","author":"Raman V.","year":"2008"},{"key":"e_1_2_1_16_1","unstructured":"R. Winter. Scaling The Data Warehouse. InformationWeek: Research & Reports http:\/\/www.informationweek.com\/news\/211100262 2008.  R. Winter. Scaling The Data Warehouse. InformationWeek: Research & Reports http:\/\/www.informationweek.com\/news\/211100262 2008."},{"key":"e_1_2_1_17_1","first-page":"1087","volume-title":"Proceedings of the 30th International Conference on Very Large Data Bases","author":"Zilio D. C.","year":"2004"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2367502.2367514","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:51:58Z","timestamp":1672224718000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2367502.2367514"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,8]]},"references-count":17,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2012,8]]}},"alternative-id":["10.14778\/2367502.2367514"],"URL":"https:\/\/doi.org\/10.14778\/2367502.2367514","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2012,8]]}}}