{"id":"https://openalex.org/W2164502281","doi":"https://doi.org/10.14778/2350229.2350258","title":"Compacting transactional data in hybrid OLTP&OLAP databases","display_name":"Compacting transactional data in hybrid OLTP&OLAP databases","publication_year":2012,"publication_date":"2012-07-01","ids":{"openalex":"https://openalex.org/W2164502281","doi":"https://doi.org/10.14778/2350229.2350258","mag":"2164502281"},"language":"en","primary_location":{"id":"doi:10.14778/2350229.2350258","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2350229.2350258","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/A5023481936","display_name":"Florian Funke","orcid":"https://orcid.org/0000-0001-7301-1550"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Florian Funke","raw_affiliation_strings":["TU M\u00fcnchen, Munich, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TU M\u00fcnchen, Munich, Germany","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105817801","display_name":"Alfons Kemper","orcid":"https://orcid.org/0009-0003-9066-271X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Alfons Kemper","raw_affiliation_strings":["TU M\u00fcnchen, Munich, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TU M\u00fcnchen, Munich, Germany","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101880157","display_name":"Thomas Neumann","orcid":"https://orcid.org/0000-0001-5787-142X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Thomas Neumann","raw_affiliation_strings":["TU M\u00fcnchen, Munich, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TU M\u00fcnchen, Munich, Germany","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":7.0801,"has_fulltext":false,"cited_by_count":54,"citation_normalized_percentile":{"value":0.97259146,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"5","issue":"11","first_page":"1424","last_page":"1435"},"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.9997000098228455,"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.9997000098228455,"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.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/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"}}],"keywords":[{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.9664632678031921},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.9317365884780884},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8264343738555908},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6913939714431763},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.6906639933586121},{"id":"https://openalex.org/keywords/transactional-memory","display_name":"Transactional memory","score":0.648807168006897},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.476712167263031},{"id":"https://openalex.org/keywords/business-intelligence","display_name":"Business intelligence","score":0.4337371587753296},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.4086138904094696}],"concepts":[{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.9664632678031921},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9317365884780884},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8264343738555908},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6913939714431763},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.6906639933586121},{"id":"https://openalex.org/C134277064","wikidata":"https://www.wikidata.org/wiki/Q878206","display_name":"Transactional memory","level":3,"score":0.648807168006897},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.476712167263031},{"id":"https://openalex.org/C2767350","wikidata":"https://www.wikidata.org/wiki/Q6662173","display_name":"Business intelligence","level":2,"score":0.4337371587753296},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.4086138904094696}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/2350229.2350258","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2350229.2350258","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"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.47999998927116394}],"awards":[],"funders":[{"id":"https://openalex.org/F4320320879","display_name":"Deutsche Forschungsgemeinschaft","ror":"https://ror.org/018mejw64"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":29,"referenced_works":["https://openalex.org/W1561713787","https://openalex.org/W1602137482","https://openalex.org/W1873909800","https://openalex.org/W1969877208","https://openalex.org/W1993819379","https://openalex.org/W1997269120","https://openalex.org/W2004736736","https://openalex.org/W2012999187","https://openalex.org/W2031032746","https://openalex.org/W2054046497","https://openalex.org/W2068245803","https://openalex.org/W2088398920","https://openalex.org/W2091459966","https://openalex.org/W2100542992","https://openalex.org/W2101281312","https://openalex.org/W2102729946","https://openalex.org/W2105326258","https://openalex.org/W2106771621","https://openalex.org/W2114474644","https://openalex.org/W2123686039","https://openalex.org/W2124851765","https://openalex.org/W2140453381","https://openalex.org/W2142098074","https://openalex.org/W2155070484","https://openalex.org/W2157979971","https://openalex.org/W2167911783","https://openalex.org/W2978655370","https://openalex.org/W4235336266","https://openalex.org/W4255327858"],"related_works":["https://openalex.org/W2804682780","https://openalex.org/W2084383859","https://openalex.org/W2102729946","https://openalex.org/W2188262136","https://openalex.org/W3166336118","https://openalex.org/W834810655","https://openalex.org/W2188975716","https://openalex.org/W171602259","https://openalex.org/W2240092424","https://openalex.org/W2978286473"],"abstract_inverted_index":{"Growing":[0],"main":[1,15],"memory":[2,85,103,116],"sizes":[3,86],"have":[4,28],"facilitated":[5],"database":[6,13,55],"management":[7],"systems":[8,27,56,79],"that":[9,21],"keep":[10],"the":[11,34,64,73,113,127,139,144,150,172,181],"entire":[12],"in":[14,90,110],"memory.":[16],"The":[17],"drastic":[18],"performance":[19,119],"improvements":[20],"came":[22],"along":[23],"with":[24],"these":[25,78,190],"in-memory":[26],"made":[29],"it":[30,155],"possible":[31],"to":[32,58,120],"reunite":[33],"two":[35,135],"areas":[36],"of":[37,50,72,87,115,129,134],"online":[38,43,167],"transaction":[39],"processing":[40,45,187],"(OLTP)":[41],"and":[42,53,153,163,168,188],"analytical":[44,60],"(OLAP):":[46],"An":[47],"emerging":[48],"class":[49],"hybrid":[51],"OLTP":[52,174,182],"OLAP":[54],"allows":[57],"process":[59],"queries":[61],"directly":[62],"on":[63],"transactional":[65,74,165],"data.":[66,147],"By":[67],"offering":[68],"arbitrarily":[69],"current":[70],"snapshots":[71],"data":[75,152,166],"for":[76,107,156],"OLAP,":[77],"enable":[80],"real-time":[81],"business":[82],"intelligence.":[83],"Despite":[84],"several":[88],"Terabytes":[89],"a":[91,98,121],"single":[92],"commodity":[93],"server,":[94],"RAM":[95],"is":[96,177],"still":[97],"precious":[99],"resource:":[100],"Since":[101],"free":[102],"can":[104],"be":[105],"used":[106],"intermediate":[108],"results":[109],"query":[111,118],"processing,":[112],"amount":[114],"determines":[117],"large":[122],"extent.":[123],"Consequently,":[124],"we":[125],"propose":[126],"compaction":[128],"memory-resident":[130],"databases.":[131],"Compaction":[132],"consists":[133],"tasks:":[136],"First,":[137],"separating":[138],"mutable":[140],"working":[141],"set":[142],"from":[143,184],"immutable":[145,151],"\"frozen\"":[146],"Second,":[148],"compressing":[149],"optimizing":[154],"efficient,":[157],"memory-consumption-friendly":[158],"snapshotting.":[159],"Our":[160],"approach":[161],"reorganizes":[162],"compresses":[164],"yet":[169],"hardly":[170],"affects":[171],"mission-critical":[173],"throughput.":[175],"This":[176],"achieved":[178],"by":[179],"unburdening":[180],"threads":[183],"all":[185],"additional":[186],"performing":[189],"tasks":[191],"asynchronously.":[192]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":5},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":7},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":7},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":7},{"year":2013,"cited_by_count":7}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}