{"id":"https://openalex.org/W2170411554","doi":"https://doi.org/10.14778/2367502.2367514","title":"A storage advisor for hybrid-store databases","display_name":"A storage advisor for hybrid-store databases","publication_year":2012,"publication_date":"2012-08-01","ids":{"openalex":"https://openalex.org/W2170411554","doi":"https://doi.org/10.14778/2367502.2367514","mag":"2170411554"},"language":"en","primary_location":{"id":"doi:10.14778/2367502.2367514","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2367502.2367514","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5083506277","display_name":"Philipp R\u00f6sch","orcid":null},"institutions":[{"id":"https://openalex.org/I4210135152","display_name":"Roland Ernst Stiftung","ror":"https://ror.org/03m629g08","country_code":"DE","type":"nonprofit","lineage":["https://openalex.org/I4210135152"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Philipp R\u00f6sch","raw_affiliation_strings":["SAP Research, SAP AG, Dresden, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP Research, SAP AG, Dresden, Germany","institution_ids":["https://openalex.org/I4210135152"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075638855","display_name":"Lars Dannecker","orcid":null},"institutions":[{"id":"https://openalex.org/I4210135152","display_name":"Roland Ernst Stiftung","ror":"https://ror.org/03m629g08","country_code":"DE","type":"nonprofit","lineage":["https://openalex.org/I4210135152"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Lars Dannecker","raw_affiliation_strings":["SAP Research, SAP AG, Dresden, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP Research, SAP AG, Dresden, Germany","institution_ids":["https://openalex.org/I4210135152"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5006693655","display_name":"Franz F\u00e4rber","orcid":null},"institutions":[{"id":"https://openalex.org/I4210132444","display_name":"Systems, Applications & Products in Data Processing (Germany)","ror":"https://ror.org/03dsc8d33","country_code":"DE","type":"company","lineage":["https://openalex.org/I4210132444"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Franz F\u00e4rber","raw_affiliation_strings":["SAP AG, Walldorf, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP AG, Walldorf, Germany","institution_ids":["https://openalex.org/I4210132444"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5065868199","display_name":"Gregor Hackenbroich","orcid":null},"institutions":[{"id":"https://openalex.org/I4210135152","display_name":"Roland Ernst Stiftung","ror":"https://ror.org/03m629g08","country_code":"DE","type":"nonprofit","lineage":["https://openalex.org/I4210135152"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Gregor Hackenbroich","raw_affiliation_strings":["SAP Research, SAP AG, Dresden, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"SAP Research, SAP AG, Dresden, Germany","institution_ids":["https://openalex.org/I4210135152"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":5.1445,"has_fulltext":false,"cited_by_count":23,"citation_normalized_percentile":{"value":0.95558181,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"5","issue":"12","first_page":"1748","last_page":"1758"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9973000288009644,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9969000220298767,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.8572531342506409},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8255640268325806},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.6485906839370728},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.6451212167739868},{"id":"https://openalex.org/keywords/table","display_name":"Table (database)","score":0.6124330163002014},{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.5148438811302185},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.47874516248703003},{"id":"https://openalex.org/keywords/storage-model","display_name":"Storage model","score":0.45843392610549927},{"id":"https://openalex.org/keywords/data-management","display_name":"Data management","score":0.44528454542160034},{"id":"https://openalex.org/keywords/row","display_name":"Row","score":0.4225025475025177},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.4203353822231293},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2803388833999634}],"concepts":[{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.8572531342506409},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8255640268325806},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.6485906839370728},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.6451212167739868},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.6124330163002014},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.5148438811302185},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.47874516248703003},{"id":"https://openalex.org/C2779659223","wikidata":"https://www.wikidata.org/wiki/Q7619926","display_name":"Storage model","level":2,"score":0.45843392610549927},{"id":"https://openalex.org/C1668388","wikidata":"https://www.wikidata.org/wiki/Q1149776","display_name":"Data management","level":2,"score":0.44528454542160034},{"id":"https://openalex.org/C135598885","wikidata":"https://www.wikidata.org/wiki/Q1366302","display_name":"Row","level":2,"score":0.4225025475025177},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.4203353822231293},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2803388833999634},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.14778/2367502.2367514","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2367502.2367514","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.294.3520","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.294.3520","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://vldb.org/pvldb/vol5/p1748_philipprosch_vldb2012.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.755.2611","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.755.2611","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://arxiv.org/pdf/1208.4169.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W199215620","https://openalex.org/W944728381","https://openalex.org/W1484886958","https://openalex.org/W1553825122","https://openalex.org/W1570477871","https://openalex.org/W1576035775","https://openalex.org/W1851390469","https://openalex.org/W1926949488","https://openalex.org/W1969877208","https://openalex.org/W1977330283","https://openalex.org/W1997375126","https://openalex.org/W2017782374","https://openalex.org/W2039910065","https://openalex.org/W2063601856","https://openalex.org/W2096126766","https://openalex.org/W2100542992","https://openalex.org/W2108094106","https://openalex.org/W2114712170","https://openalex.org/W2122816893","https://openalex.org/W2124851765","https://openalex.org/W2130642985","https://openalex.org/W2156930555","https://openalex.org/W2172220707","https://openalex.org/W2280677980","https://openalex.org/W2911997474","https://openalex.org/W2915063781","https://openalex.org/W4244225911"],"related_works":["https://openalex.org/W2129469317","https://openalex.org/W2033980616","https://openalex.org/W4245850857","https://openalex.org/W2466884276","https://openalex.org/W2918191903","https://openalex.org/W1603211808","https://openalex.org/W4205329089","https://openalex.org/W99483491","https://openalex.org/W2041090168","https://openalex.org/W2079690139"],"abstract_inverted_index":{"With":[0],"the":[1,28,40,64,67,73,101,124,140,144,151,155,158,164,170,174,177],"SAP":[2,5,159],"HANA":[3,160],"database,":[4],"offers":[6,31],"a":[7,85,113,128],"high-performance":[8,32],"in-memory":[9],"hybrid-store":[10],"database.":[11],"Hybrid-store":[12],"databases---that":[13],"is,":[14],"databases":[15],"supporting":[16],"row-":[17,76],"and":[18,24,52,107,118,137,142],"column-oriented":[19,78],"data":[20,75,106,141,175],"management---are":[21],"getting":[22],"more":[23,25,54],"prominent.":[26],"While":[27],"columnar":[29],"management":[30],"capabilities":[33],"for":[34,123,154],"analyzing":[35],"large":[36],"quantities":[37],"of":[38,60,172],"data,":[39],"row-oriented":[41],"store":[42,72,103,179],"can":[43],"handle":[44],"transactional":[45],"point":[46],"queries":[47],"as":[48,50,167,169],"well":[49,168],"inserts":[51],"updates":[53],"efficiently.":[55],"To":[56],"effectively":[57],"take":[58],"advantage":[59],"both":[61],"stores":[62],"at":[63,93],"same":[65],"time":[66],"novel":[68],"question":[69],"whether":[70],"to":[71,116,135,182],"given":[74],"or":[77],"arises.":[79],"We":[80,149],"tackle":[81],"this":[82,94],"problem":[83],"with":[84,180],"storage":[86,98,152],"advisor":[87,99,153],"tool":[88,132],"that":[89],"supports":[90],"database":[91],"administrators":[92],"decision.":[95],"Our":[96],"proposed":[97],"recommends":[100],"optimal":[102,178],"based":[104],"on":[105,146],"query":[108,120,184],"characteristics;":[109],"its":[110],"core":[111],"is":[112],"cost":[114],"model":[115],"estimate":[117],"compare":[119],"execution":[121],"times":[122],"different":[125,147],"stores.":[126,148],"Besides":[127],"per-table":[129],"decision,":[130],"our":[131],"also":[133],"considers":[134],"horizontally":[136],"vertically":[138],"partition":[139],"manage":[143],"partitions":[145],"evaluated":[150],"use":[156],"in":[157,176],"database;":[161],"we":[162],"show":[163],"recommendation":[165],"quality":[166],"benefit":[171],"having":[173],"respect":[181],"increased":[183],"performance.":[185]},"counts_by_year":[{"year":2023,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":6},{"year":2016,"cited_by_count":1},{"year":2015,"cited_by_count":3},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}