{"id":"https://openalex.org/W3003898980","doi":"https://doi.org/10.1007/s13222-019-00330-x","title":"GridTables: A\u00a0One-Size-Fits-Most H2TAP Data Store","display_name":"GridTables: A\u00a0One-Size-Fits-Most H2TAP Data Store","publication_year":2020,"publication_date":"2020-01-31","ids":{"openalex":"https://openalex.org/W3003898980","doi":"https://doi.org/10.1007/s13222-019-00330-x","mag":"3003898980"},"language":"en","primary_location":{"id":"doi:10.1007/s13222-019-00330-x","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s13222-019-00330-x","pdf_url":"https://link.springer.com/content/pdf/10.1007/s13222-019-00330-x.pdf","source":{"id":"https://openalex.org/S73012565","display_name":"Datenbank-Spektrum","issn_l":"1610-1995","issn":["1610-1995","1618-2162"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Datenbank-Spektrum","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://link.springer.com/content/pdf/10.1007/s13222-019-00330-x.pdf","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5061340312","display_name":"Marcus Pinnecke","orcid":"https://orcid.org/0000-0002-3042-5873"},"institutions":[{"id":"https://openalex.org/I4210127568","display_name":"Max Planck Institute for Dynamics of Complex Technical Systems","ror":"https://ror.org/030h7k016","country_code":"DE","type":"facility","lineage":["https://openalex.org/I149899117","https://openalex.org/I4210127568"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Marcus Pinnecke","raw_affiliation_strings":["Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany"],"raw_orcid":"https://orcid.org/0000-0002-3042-5873","affiliations":[{"raw_affiliation_string":"Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany","institution_ids":["https://openalex.org/I4210127568"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059805666","display_name":"Gabriel Campero Durand","orcid":null},"institutions":[{"id":"https://openalex.org/I4210127568","display_name":"Max Planck Institute for Dynamics of Complex Technical Systems","ror":"https://ror.org/030h7k016","country_code":"DE","type":"facility","lineage":["https://openalex.org/I149899117","https://openalex.org/I4210127568"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Gabriel Campero\u00a0Durand","raw_affiliation_strings":["Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany","institution_ids":["https://openalex.org/I4210127568"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061367729","display_name":"David Broneske","orcid":"https://orcid.org/0000-0002-9580-740X"},"institutions":[{"id":"https://openalex.org/I4210127568","display_name":"Max Planck Institute for Dynamics of Complex Technical Systems","ror":"https://ror.org/030h7k016","country_code":"DE","type":"facility","lineage":["https://openalex.org/I149899117","https://openalex.org/I4210127568"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"David Broneske","raw_affiliation_strings":["Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany","institution_ids":["https://openalex.org/I4210127568"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061275415","display_name":"Roman Zoun","orcid":null},"institutions":[{"id":"https://openalex.org/I4210127568","display_name":"Max Planck Institute for Dynamics of Complex Technical Systems","ror":"https://ror.org/030h7k016","country_code":"DE","type":"facility","lineage":["https://openalex.org/I149899117","https://openalex.org/I4210127568"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Roman Zoun","raw_affiliation_strings":["Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany","institution_ids":["https://openalex.org/I4210127568"]}]},{"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/I4210127568","display_name":"Max Planck Institute for Dynamics of Complex Technical Systems","ror":"https://ror.org/030h7k016","country_code":"DE","type":"facility","lineage":["https://openalex.org/I149899117","https://openalex.org/I4210127568"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Gunter Saake","raw_affiliation_strings":["Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Technical and Business Information Systems, Database and Software Engineering Group, University of Magdeburg, Magdeburg, Germany","institution_ids":["https://openalex.org/I4210127568"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5061340312"],"corresponding_institution_ids":["https://openalex.org/I4210127568"],"apc_list":{"value":2890,"currency":"USD","value_usd":2890},"apc_paid":{"value":2890,"currency":"USD","value_usd":2890},"fwci":0.2683,"has_fulltext":true,"cited_by_count":3,"citation_normalized_percentile":{"value":0.60636615,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"20","issue":"1","first_page":"43","last_page":"56"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9990000128746033,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9990000128746033,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9988999962806702,"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.9986000061035156,"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.794148862361908},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.7783791422843933},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5446114540100098},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5043388605117798},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.49521198868751526},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.324921190738678},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.2564340829849243}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.794148862361908},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.7783791422843933},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5446114540100098},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5043388605117798},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.49521198868751526},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.324921190738678},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.2564340829849243},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/s13222-019-00330-x","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s13222-019-00330-x","pdf_url":"https://link.springer.com/content/pdf/10.1007/s13222-019-00330-x.pdf","source":{"id":"https://openalex.org/S73012565","display_name":"Datenbank-Spektrum","issn_l":"1610-1995","issn":["1610-1995","1618-2162"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Datenbank-Spektrum","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1007/s13222-019-00330-x","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s13222-019-00330-x","pdf_url":"https://link.springer.com/content/pdf/10.1007/s13222-019-00330-x.pdf","source":{"id":"https://openalex.org/S73012565","display_name":"Datenbank-Spektrum","issn_l":"1610-1995","issn":["1610-1995","1618-2162"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Datenbank-Spektrum","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.550000011920929,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[{"id":"https://openalex.org/G1154580222","display_name":null,"funder_award_id":"SA 465/50-1","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G2012584104","display_name":null,"funder_award_id":"031L0103","funder_id":"https://openalex.org/F4320330124","funder_display_name":"German Network for Bioinformatics Infrastructure"},{"id":"https://openalex.org/G2795445197","display_name":null,"funder_award_id":"031L0103","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G5647660269","display_name":null,"funder_award_id":"SA 465/51","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"},{"id":"https://openalex.org/G6695730086","display_name":null,"funder_award_id":"SA 465/51-1","funder_id":"https://openalex.org/F4320320879","funder_display_name":"Deutsche Forschungsgemeinschaft"}],"funders":[{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"},{"id":"https://openalex.org/F4320330124","display_name":"German Network for Bioinformatics Infrastructure","ror":null},{"id":"https://openalex.org/F4320335829","display_name":"Otto von Guericke University Magdeburg","ror":"https://ror.org/00ggpsq73"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3003898980.pdf","grobid_xml":"https://content.openalex.org/works/W3003898980.grobid-xml"},"referenced_works_count":65,"referenced_works":["https://openalex.org/W1432073258","https://openalex.org/W1444968430","https://openalex.org/W1556530724","https://openalex.org/W1612645043","https://openalex.org/W1970413560","https://openalex.org/W2000790156","https://openalex.org/W2005091928","https://openalex.org/W2005112390","https://openalex.org/W2017992824","https://openalex.org/W2039767911","https://openalex.org/W2039910065","https://openalex.org/W2063601856","https://openalex.org/W2075345089","https://openalex.org/W2075712468","https://openalex.org/W2083619093","https://openalex.org/W2096229429","https://openalex.org/W2102729946","https://openalex.org/W2117987151","https://openalex.org/W2136390693","https://openalex.org/W2146461854","https://openalex.org/W2153231238","https://openalex.org/W2155595639","https://openalex.org/W2170853664","https://openalex.org/W2194832308","https://openalex.org/W2243512312","https://openalex.org/W2258492288","https://openalex.org/W2259014610","https://openalex.org/W2294000809","https://openalex.org/W2294108820","https://openalex.org/W2403891947","https://openalex.org/W2408388496","https://openalex.org/W2426624872","https://openalex.org/W2439390339","https://openalex.org/W2558012959","https://openalex.org/W2579082966","https://openalex.org/W2584555500","https://openalex.org/W2594691757","https://openalex.org/W2605046487","https://openalex.org/W2612704407","https://openalex.org/W2615841849","https://openalex.org/W2728889630","https://openalex.org/W2732239434","https://openalex.org/W2748826323","https://openalex.org/W2752640170","https://openalex.org/W2759397513","https://openalex.org/W2773466258","https://openalex.org/W2795350225","https://openalex.org/W2798325362","https://openalex.org/W2798340189","https://openalex.org/W2799015892","https://openalex.org/W2803544438","https://openalex.org/W2804924008","https://openalex.org/W2806698719","https://openalex.org/W2889456810","https://openalex.org/W2889859625","https://openalex.org/W2912248064","https://openalex.org/W2912423768","https://openalex.org/W2913737421","https://openalex.org/W2941262733","https://openalex.org/W2948866423","https://openalex.org/W2949975857","https://openalex.org/W2963758034","https://openalex.org/W2972067927","https://openalex.org/W2980657213","https://openalex.org/W4232216758"],"related_works":["https://openalex.org/W2888733525","https://openalex.org/W2379143279","https://openalex.org/W4246658255","https://openalex.org/W613932090","https://openalex.org/W2108441106","https://openalex.org/W2158831935","https://openalex.org/W4210881933","https://openalex.org/W2348698578","https://openalex.org/W13324341","https://openalex.org/W2350484003"],"abstract_inverted_index":{"Abstract":[0],"Heterogeneous":[1],"Hybrid":[2],"Transactional":[3],"Analytical":[4],"Processing":[5],"(":[6],"$$\\mathrm{H}^{2}$$":[7,100],"<mml:math":[8,101],"xmlns:mml=\"http://www.w3.org/1998/Math/MathML\"><mml:mrow><mml:msup><mml:mi>H</mml:mi><mml:mn>2</mml:mn></mml:msup></mml:mrow></mml:math>":[9,102],"TAP)":[10],"database":[11],"systems":[12,33],"have":[13],"been":[14],"developed":[15],"to":[16,29,36,39,43,51,63,89,143,175,211],"match":[17],"the":[18,97,109,141,176,183,215],"requirements":[19],"for":[20,122,145],"low":[21],"latency":[22],"analysis":[23],"of":[24,53,99,111,187,214,217],"real-time":[25],"operational":[26],"data.":[27],"Due":[28],"technical":[30],"challenges,":[31],"these":[32,68],"are":[34],"hard":[35],"architect,":[37],"non-trivial":[38],"engineer,":[40],"and":[41,82,139,153,185,193,203],"complex":[42],"administrate.":[44],"Current":[45],"research":[46,201],"has":[47],"proposed":[48],"excellent":[49],"solutions":[50,69],"many":[52],"those":[54],"challenges":[55,128,204],"in":[56,96,135,209],"isolation":[57],"\u2013":[58],"a":[59,79],"unified":[60],"engine":[61],"enabling":[62],"optimize":[64,144],"performance":[65],"by":[66],"combining":[67],"is":[70,118],"still":[71],"missing.":[72],"In":[73,178],"this":[74,179,197],"concept":[75],"paper,":[76,180],"we":[77,106,129,169,181],"suggest":[78],"highly":[80],"flexible":[81],"adaptive":[83],"data":[84,155],"structure":[85],"(called":[86],"gridtable":[87],")":[88],"physically":[90],"organize":[91],"sparse":[92],"but":[93],"structured":[94],"records":[95],"context":[98],"TAP.":[103],"For":[104],"this,":[105],"focus":[107],"on":[108,167],"design":[110,190],"an":[112],"efficient":[113],"highly-flexible":[114],"storage":[115,134],"layout":[116],"that":[117,205],"built":[119],"from":[120],"scratch":[121],"mixed":[123,146],"query":[124],"workloads.":[125],"The":[126],"key":[127],"address":[130],"are:":[131],"(1)":[132],"partial":[133],"different":[136],"memory":[137],"locations,":[138],"(2)":[140],"ability":[142],"OLTP-/OLAP":[147],"access":[148,173],"patterns.":[149],"To":[150],"guarantee":[151],"safe":[152],"well-specified":[154],"definition":[156],"or":[157],"manipulation,":[158],"as":[159,161],"well":[160],"fast":[162],"querying":[163],"with":[164,199],"no":[165],"compromises":[166],"performance,":[168],"propose":[170],"two":[171],"dedicated":[172],"paths":[174],"storage.":[177],"explore":[182],"architecture":[184],"internals":[186],"gridtables":[188],"showing":[189],"goals,":[191],"concepts":[192],"trade-offs.":[194],"We":[195],"close":[196],"paper":[198],"open":[200],"questions":[202],"must":[206],"be":[207],"addressed":[208],"order":[210],"take":[212],"advantage":[213],"flexibility":[216],"our":[218],"solution.":[219]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2026-07-31T08:31:51.225901","created_date":"2025-10-10T00:00:00"}