{"id":"https://openalex.org/W4399329703","doi":"https://doi.org/10.1007/s00778-024-00858-9","title":"A survey on hybrid transactional and analytical processing","display_name":"A survey on hybrid transactional and analytical processing","publication_year":2024,"publication_date":"2024-06-04","ids":{"openalex":"https://openalex.org/W4399329703","doi":"https://doi.org/10.1007/s00778-024-00858-9"},"language":"en","primary_location":{"id":"doi:10.1007/s00778-024-00858-9","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-024-00858-9","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-024-00858-9.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"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":"The VLDB Journal","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/s00778-024-00858-9.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5029628355","display_name":"Haoze Song","orcid":"https://orcid.org/0009-0000-5952-5168"},"institutions":[{"id":"https://openalex.org/I889458895","display_name":"University of Hong Kong","ror":"https://ror.org/02zhqgq86","country_code":"HK","type":"education","lineage":["https://openalex.org/I889458895"]}],"countries":["HK"],"is_corresponding":true,"raw_author_name":"Haoze Song","raw_affiliation_strings":["Department of Computer Science, The University of Hong Kong, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, The University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I889458895"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101741069","display_name":"Wenchao Zhou","orcid":"https://orcid.org/0009-0002-2689-6020"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wenchao Zhou","raw_affiliation_strings":["Database and Storage Lab Alibaba Cloud, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Database and Storage Lab Alibaba Cloud, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015360935","display_name":"Heming Cui","orcid":"https://orcid.org/0000-0001-7746-440X"},"institutions":[{"id":"https://openalex.org/I889458895","display_name":"University of Hong Kong","ror":"https://ror.org/02zhqgq86","country_code":"HK","type":"education","lineage":["https://openalex.org/I889458895"]}],"countries":["HK"],"is_corresponding":false,"raw_author_name":"Heming Cui","raw_affiliation_strings":["Department of Computer Science, The University of Hong Kong, Hong Kong, China"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, The University of Hong Kong, Hong Kong, China","institution_ids":["https://openalex.org/I889458895"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080930328","display_name":"X. Peng","orcid":"https://orcid.org/0009-0008-6355-4525"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiang Peng","raw_affiliation_strings":["Database and Storage Lab Alibaba Cloud, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Database and Storage Lab Alibaba Cloud, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100450470","display_name":"Feifei Li","orcid":"https://orcid.org/0009-0003-0770-5775"},"institutions":[{"id":"https://openalex.org/I45928872","display_name":"Alibaba Group (China)","ror":"https://ror.org/00k642b80","country_code":"CN","type":"company","lineage":["https://openalex.org/I45928872"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Feifei Li","raw_affiliation_strings":["Database and Storage Lab Alibaba Cloud, Hangzhou, China"],"affiliations":[{"raw_affiliation_string":"Database and Storage Lab Alibaba Cloud, Hangzhou, China","institution_ids":["https://openalex.org/I45928872"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5029628355"],"corresponding_institution_ids":["https://openalex.org/I889458895"],"apc_list":{"value":2290,"currency":"EUR","value_usd":2890},"apc_paid":{"value":2290,"currency":"EUR","value_usd":2890},"fwci":4.1617,"has_fulltext":true,"cited_by_count":12,"citation_normalized_percentile":{"value":0.94493307,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"33","issue":"5","first_page":"1485","last_page":"1515"},"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.9965000152587891,"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.9965000152587891,"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.995199978351593,"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9825999736785889,"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/transactional-analysis","display_name":"Transactional analysis","score":0.61992347240448},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5401095747947693},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.1893543004989624},{"id":"https://openalex.org/keywords/social-psychology","display_name":"Social psychology","score":0.06034427881240845}],"concepts":[{"id":"https://openalex.org/C96961170","wikidata":"https://www.wikidata.org/wiki/Q623513","display_name":"Transactional analysis","level":2,"score":0.61992347240448},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5401095747947693},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.1893543004989624},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.06034427881240845}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/s00778-024-00858-9","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-024-00858-9","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-024-00858-9.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"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":"The VLDB Journal","raw_type":"journal-article"},{"id":"pmh:oai:hub.hku.hk:10722/343843","is_oa":true,"landing_page_url":"https://hub.hku.hk/handle/10722/343843","pdf_url":"http://hub.hku.hk/bitstream/10722/343843/1/content.pdf","source":{"id":"https://openalex.org/S4377196271","display_name":"The HKU Scholars Hub (University of Hong Kong)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I889458895","host_organization_name":"University of Hong Kong","host_organization_lineage":["https://openalex.org/I889458895"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-nc-nd","license_id":"https://openalex.org/licenses/cc-by-nc-nd","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Article"}],"best_oa_location":{"id":"doi:10.1007/s00778-024-00858-9","is_oa":true,"landing_page_url":"https://doi.org/10.1007/s00778-024-00858-9","pdf_url":"https://link.springer.com/content/pdf/10.1007/s00778-024-00858-9.pdf","source":{"id":"https://openalex.org/S78926909","display_name":"The VLDB Journal","issn_l":"0949-877X","issn":["0949-877X","1066-8888"],"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":"The VLDB Journal","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.6100000143051147,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":false},"content_urls":{"pdf":"https://content.openalex.org/works/W4399329703.pdf"},"referenced_works_count":128,"referenced_works":["https://openalex.org/W335353633","https://openalex.org/W1482997398","https://openalex.org/W1509841269","https://openalex.org/W1555950237","https://openalex.org/W1570477871","https://openalex.org/W1605782097","https://openalex.org/W1791587242","https://openalex.org/W1821608153","https://openalex.org/W1967024051","https://openalex.org/W1967091776","https://openalex.org/W1967601791","https://openalex.org/W1970532985","https://openalex.org/W1989306170","https://openalex.org/W1993892970","https://openalex.org/W1994211684","https://openalex.org/W2005112390","https://openalex.org/W2012999187","https://openalex.org/W2020129682","https://openalex.org/W2020765455","https://openalex.org/W2034094825","https://openalex.org/W2038412523","https://openalex.org/W2043877046","https://openalex.org/W2053296404","https://openalex.org/W2068245803","https://openalex.org/W2068739275","https://openalex.org/W2070991879","https://openalex.org/W2075345089","https://openalex.org/W2083755493","https://openalex.org/W2091380526","https://openalex.org/W2097647952","https://openalex.org/W2102639991","https://openalex.org/W2102729946","https://openalex.org/W2103670492","https://openalex.org/W2105904337","https://openalex.org/W2110004505","https://openalex.org/W2114507260","https://openalex.org/W2120114814","https://openalex.org/W2123686039","https://openalex.org/W2124199440","https://openalex.org/W2125895608","https://openalex.org/W2128472672","https://openalex.org/W2135003477","https://openalex.org/W2144839430","https://openalex.org/W2161694911","https://openalex.org/W2164502281","https://openalex.org/W2165663045","https://openalex.org/W2167026479","https://openalex.org/W2169379483","https://openalex.org/W2170853664","https://openalex.org/W2185655604","https://openalex.org/W2230141493","https://openalex.org/W2248620604","https://openalex.org/W2250374629","https://openalex.org/W2265110944","https://openalex.org/W2396309311","https://openalex.org/W2426624872","https://openalex.org/W2428665651","https://openalex.org/W2430301697","https://openalex.org/W2436533802","https://openalex.org/W2476433236","https://openalex.org/W2487598231","https://openalex.org/W2548266162","https://openalex.org/W2600958660","https://openalex.org/W2604961016","https://openalex.org/W2605843372","https://openalex.org/W2606409849","https://openalex.org/W2612041618","https://openalex.org/W2612368883","https://openalex.org/W2612488340","https://openalex.org/W2612704407","https://openalex.org/W2753767407","https://openalex.org/W2754332001","https://openalex.org/W2763907538","https://openalex.org/W2769027965","https://openalex.org/W2794759365","https://openalex.org/W2799108731","https://openalex.org/W2889320527","https://openalex.org/W2902264868","https://openalex.org/W2970632477","https://openalex.org/W2970918514","https://openalex.org/W2971106790","https://openalex.org/W2982234780","https://openalex.org/W2982402713","https://openalex.org/W2982604121","https://openalex.org/W2994875404","https://openalex.org/W3008451085","https://openalex.org/W3015600567","https://openalex.org/W3023647491","https://openalex.org/W3029596260","https://openalex.org/W3043320740","https://openalex.org/W3080409317","https://openalex.org/W3085441975","https://openalex.org/W3085790652","https://openalex.org/W3085824626","https://openalex.org/W3085924233","https://openalex.org/W3100081533","https://openalex.org/W3118977279","https://openalex.org/W3120753775","https://openalex.org/W3131834909","https://openalex.org/W3137759927","https://openalex.org/W3137814466","https://openalex.org/W3146448298","https://openalex.org/W3158900323","https://openalex.org/W3167346145","https://openalex.org/W3168289090","https://openalex.org/W3174745414","https://openalex.org/W3175055685","https://openalex.org/W3175782024","https://openalex.org/W3176153696","https://openalex.org/W3196498014","https://openalex.org/W3203754680","https://openalex.org/W4221156673","https://openalex.org/W4238455951","https://openalex.org/W4255987097","https://openalex.org/W4281754544","https://openalex.org/W4281774998","https://openalex.org/W4281775561","https://openalex.org/W4281786663","https://openalex.org/W4282542689","https://openalex.org/W4282568518","https://openalex.org/W4289533878","https://openalex.org/W4294904080","https://openalex.org/W4312371657","https://openalex.org/W4312738011","https://openalex.org/W4312887229","https://openalex.org/W4317641620","https://openalex.org/W4376653923","https://openalex.org/W6600734529"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2578325747","https://openalex.org/W2571883070","https://openalex.org/W2577697054","https://openalex.org/W2162165622","https://openalex.org/W2576957459","https://openalex.org/W2577063523","https://openalex.org/W2033109348","https://openalex.org/W2571694425"],"abstract_inverted_index":{"Abstract":[0],"To":[1],"provide":[2],"applications":[3],"with":[4],"the":[5,13,134],"ability":[6],"to":[7,26],"analyze":[8],"fresh":[9],"data":[10,95],"and":[11,19,31,52,57,77,83,98,117,130,146,163],"eliminate":[12],"time-consuming":[14],"ETL":[15],"workflow,":[16],"hybrid":[17,99,104],"transactional":[18],"analytical":[20,33],"(HTAP)":[21],"systems":[22,44,88],"have":[23,45,59],"been":[24,60],"developed":[25],"serve":[27],"online":[28,32],"transaction":[29],"processing":[30,34],"workloads":[35],"in":[36,80],"a":[37,65,122],"single":[38],"system.":[39],"In":[40],"recent":[41],"years,":[42],"HTAP":[43,70,87,105,158],"attracted":[46],"considerable":[47],"interest":[48],"from":[49],"both":[50],"academia":[51],"industry.":[53],"Several":[54],"new":[55],"architectures":[56],"technologies":[58],"proposed.":[61],"This":[62],"paper":[63],"provides":[64],"comprehensive":[66],"overview":[67],"of":[68],"these":[69],"systems.":[71],"We":[72,101,141],"review":[73],"recently":[74],"published":[75],"papers":[76],"technical":[78],"reports":[79],"this":[81],"field":[82],"broadly":[84],"classify":[85,103],"existing":[86],"into":[89,106],"two":[90],"categories":[91],"based":[92,109],"on":[93,110,120],"their":[94,111,147],"formats:":[96],"monolithic":[97,139],"HTAP.":[100],"further":[102],"four":[107],"sub-categories":[108],"storage":[112],"architecture:":[113],"row-oriented,":[114],"column-oriented,":[115],"separated,":[116],"hybrid.":[118],"Based":[119],"such":[121],"taxonomy,":[123],"we":[124,155],"outline":[125],"each":[126],"stream\u2019s":[127],"design":[128],"challenges":[129],"performance":[131],"issues":[132],"(e.g.,":[133],"contradictory":[135],"format":[136],"demand":[137],"for":[138],"HTAP).":[140],"then":[142],"discuss":[143],"potential":[144],"solutions":[145],"trade-offs":[148],"by":[149],"reviewing":[150],"noteworthy":[151],"research":[152],"findings.":[153],"Finally,":[154],"summarize":[156],"emerging":[157],"applications,":[159],"benchmarks,":[160],"future":[161],"trends,":[162],"open":[164],"problems.":[165]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":10},{"year":2024,"cited_by_count":1}],"updated_date":"2026-04-02T15:55:50.835912","created_date":"2025-10-10T00:00:00"}