{"id":"https://openalex.org/W2088222399","doi":"https://doi.org/10.1109/rcis.2011.6006854","title":"A decision model to select the optimal storage architecture for relational databases","display_name":"A decision model to select the optimal storage architecture for relational databases","publication_year":2011,"publication_date":"2011-05-01","ids":{"openalex":"https://openalex.org/W2088222399","doi":"https://doi.org/10.1109/rcis.2011.6006854","mag":"2088222399"},"language":"en","primary_location":{"id":"doi:10.1109/rcis.2011.6006854","is_oa":false,"landing_page_url":"https://doi.org/10.1109/rcis.2011.6006854","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 FIFTH INTERNATIONAL CONFERENCE ON RESEARCH CHALLENGES IN INFORMATION SCIENCE","raw_type":"proceedings-article"},"type":"conference-paper","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/A5005735726","display_name":"Andreas L\u00fcbcke","orcid":null},"institutions":[{"id":"https://openalex.org/I95793202","display_name":"Otto-von-Guericke-Universit\u00e4t Magdeburg","ror":"https://ror.org/00ggpsq73","country_code":"DE","type":"education","lineage":["https://openalex.org/I95793202"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Andreas Lubcke","raw_affiliation_strings":["School of Computer Science, Otto-von-Guericke University of Magdeburg, Germany","School of Computer Science, Otto-von-Guericke-University Magdeburg, Magdeburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science, Otto-von-Guericke University of Magdeburg, Germany","institution_ids":["https://openalex.org/I95793202"]},{"raw_affiliation_string":"School of Computer Science, Otto-von-Guericke-University Magdeburg, Magdeburg, Germany","institution_ids":["https://openalex.org/I95793202"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056591899","display_name":"Veit K\u00f6ppen","orcid":"https://orcid.org/0000-0002-6068-3275"},"institutions":[{"id":"https://openalex.org/I95793202","display_name":"Otto-von-Guericke-Universit\u00e4t Magdeburg","ror":"https://ror.org/00ggpsq73","country_code":"DE","type":"education","lineage":["https://openalex.org/I95793202"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Veit Koppen","raw_affiliation_strings":["School of Computer Science, Otto-von-Guericke University of Magdeburg, Germany","School of Computer Science, Otto-von-Guericke-University Magdeburg, Magdeburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science, Otto-von-Guericke University of Magdeburg, Germany","institution_ids":["https://openalex.org/I95793202"]},{"raw_affiliation_string":"School of Computer Science, Otto-von-Guericke-University Magdeburg, Magdeburg, Germany","institution_ids":["https://openalex.org/I95793202"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5042946019","display_name":"Gunter Saake","orcid":"https://orcid.org/0000-0001-9576-8474"},"institutions":[{"id":"https://openalex.org/I95793202","display_name":"Otto-von-Guericke-Universit\u00e4t Magdeburg","ror":"https://ror.org/00ggpsq73","country_code":"DE","type":"education","lineage":["https://openalex.org/I95793202"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Gunter Saake","raw_affiliation_strings":["School of Computer Science, Otto-von-Guericke University of Magdeburg, Germany","School of Computer Science, Otto-von-Guericke-University Magdeburg, Magdeburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Computer Science, Otto-von-Guericke University of Magdeburg, Germany","institution_ids":["https://openalex.org/I95793202"]},{"raw_affiliation_string":"School of Computer Science, Otto-von-Guericke-University Magdeburg, Magdeburg, Germany","institution_ids":["https://openalex.org/I95793202"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I95793202"],"apc_list":null,"apc_paid":null,"fwci":1.7161,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.84053528,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":"11","issue":null,"first_page":"1","last_page":"11"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9995999932289124,"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/T11106","display_name":"Data Management and Algorithms","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.9959999918937683,"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/computer-science","display_name":"Computer science","score":0.814185619354248},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7153533101081848},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.5785067677497864},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5708572864532471},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.5474799275398254},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5246384739875793},{"id":"https://openalex.org/keywords/database-model","display_name":"Database model","score":0.5226383209228516},{"id":"https://openalex.org/keywords/storage-model","display_name":"Storage model","score":0.4714677631855011},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.45423927903175354},{"id":"https://openalex.org/keywords/data-architecture","display_name":"Data architecture","score":0.44988495111465454},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.44966450333595276},{"id":"https://openalex.org/keywords/database-theory","display_name":"Database theory","score":0.436632364988327},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.43634289503097534},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3550676703453064},{"id":"https://openalex.org/keywords/reference-architecture","display_name":"Reference architecture","score":0.23323053121566772},{"id":"https://openalex.org/keywords/software-architecture","display_name":"Software architecture","score":0.17847156524658203},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.09299403429031372}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.814185619354248},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7153533101081848},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.5785067677497864},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5708572864532471},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.5474799275398254},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5246384739875793},{"id":"https://openalex.org/C5968703","wikidata":"https://www.wikidata.org/wiki/Q267136","display_name":"Database model","level":3,"score":0.5226383209228516},{"id":"https://openalex.org/C2779659223","wikidata":"https://www.wikidata.org/wiki/Q7619926","display_name":"Storage model","level":2,"score":0.4714677631855011},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.45423927903175354},{"id":"https://openalex.org/C94070970","wikidata":"https://www.wikidata.org/wiki/Q638422","display_name":"Data architecture","level":5,"score":0.44988495111465454},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.44966450333595276},{"id":"https://openalex.org/C12439846","wikidata":"https://www.wikidata.org/wiki/Q4809258","display_name":"Database theory","level":3,"score":0.436632364988327},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.43634289503097534},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3550676703453064},{"id":"https://openalex.org/C55356503","wikidata":"https://www.wikidata.org/wiki/Q2136675","display_name":"Reference architecture","level":4,"score":0.23323053121566772},{"id":"https://openalex.org/C35869016","wikidata":"https://www.wikidata.org/wiki/Q846636","display_name":"Software architecture","level":3,"score":0.17847156524658203},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.09299403429031372},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/rcis.2011.6006854","is_oa":false,"landing_page_url":"https://doi.org/10.1109/rcis.2011.6006854","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 FIFTH INTERNATIONAL CONFERENCE ON RESEARCH CHALLENGES IN INFORMATION SCIENCE","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":54,"referenced_works":["https://openalex.org/W135684280","https://openalex.org/W173895910","https://openalex.org/W612079661","https://openalex.org/W1492574951","https://openalex.org/W1514659981","https://openalex.org/W1531743794","https://openalex.org/W1553825122","https://openalex.org/W1556530724","https://openalex.org/W1560510652","https://openalex.org/W1570896006","https://openalex.org/W1601629924","https://openalex.org/W1791587242","https://openalex.org/W1964166152","https://openalex.org/W1967051149","https://openalex.org/W1977330283","https://openalex.org/W1981523076","https://openalex.org/W1991571419","https://openalex.org/W2005112390","https://openalex.org/W2006761638","https://openalex.org/W2033464728","https://openalex.org/W2047085757","https://openalex.org/W2055468282","https://openalex.org/W2085601491","https://openalex.org/W2095458406","https://openalex.org/W2096674153","https://openalex.org/W2106867122","https://openalex.org/W2108490710","https://openalex.org/W2116420167","https://openalex.org/W2116436709","https://openalex.org/W2116616082","https://openalex.org/W2130642985","https://openalex.org/W2138512691","https://openalex.org/W2139245968","https://openalex.org/W2144839430","https://openalex.org/W2147011911","https://openalex.org/W2148291485","https://openalex.org/W2157979971","https://openalex.org/W2169333950","https://openalex.org/W2264983728","https://openalex.org/W2295907828","https://openalex.org/W2556521298","https://openalex.org/W3021961968","https://openalex.org/W3138367763","https://openalex.org/W4210672651","https://openalex.org/W4213163687","https://openalex.org/W6633547644","https://openalex.org/W6633895037","https://openalex.org/W6635748457","https://openalex.org/W6638231387","https://openalex.org/W6677483091","https://openalex.org/W6679817081","https://openalex.org/W6680293019","https://openalex.org/W6681994082","https://openalex.org/W7024367303"],"related_works":["https://openalex.org/W1558507836","https://openalex.org/W1502610062","https://openalex.org/W2188578519","https://openalex.org/W2027162968","https://openalex.org/W1989645082","https://openalex.org/W1533863182","https://openalex.org/W2558870711","https://openalex.org/W584886505","https://openalex.org/W2391630783","https://openalex.org/W418913100"],"abstract_inverted_index":{"Requirements":[0],"for":[1,9,90,124],"database":[2,7,23,50,72,115],"systems":[3,104],"differ":[4],"from":[5],"small-scale":[6],"programs":[8],"embedded":[10],"devices":[11],"with":[12,52],"minimal":[13],"footprint":[14],"to":[15,48,54,58,66],"large-scale":[16],"on-line":[17],"analytical":[18],"processing":[19],"applications.":[20],"For":[21],"relational":[22],"management":[24],"systems,":[25],"two":[26],"storage":[27,60,88],"architectures":[28],"have":[29],"been":[30],"introduced:":[31],"a)":[32],"row-oriented":[33],"architecture":[34,89,120],"and":[35,108],"b)":[36],"column-oriented":[37],"architecture.":[38,61],"In":[39],"this":[40],"paper,":[41],"we":[42,75],"present":[43],"a":[44,91,125],"query":[45],"decomposition":[46],"approach":[47],"evaluate":[49],"operations":[51],"respect":[53],"their":[55],"performance":[56,101],"according":[57],"the":[59,83,86,100],"We":[62],"map":[63],"decomposed":[64],"queries":[65],"workload":[67],"patterns":[68],"which":[69,81,119],"contain":[70],"aggregated":[71],"statistics.":[73],"Further,":[74],"develop":[76],"our":[77],"complementary":[78],"decision":[79,97,110],"models":[80],"advise":[82,112],"selection":[84],"of":[85,102],"optimal":[87],"given":[92,126],"application":[93,127],"domain.":[94],"The":[95,106],"first":[96],"model":[98,111],"improves":[99],"running":[103],"(on-line).":[105],"second":[107],"third":[109],"an":[113],"efficient":[114],"design":[116],"or":[117],"decide":[118],"is":[121],"more":[122],"suitable":[123],"domain":[128],"(off-line).":[129]},"counts_by_year":[{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}