{"id":"https://openalex.org/W4413953486","doi":"https://doi.org/10.14778/3742728.3742731","title":"Hermes: Off-the-Shelf Real-Time Transactional Analytics","display_name":"Hermes: Off-the-Shelf Real-Time Transactional Analytics","publication_year":2025,"publication_date":"2025-04-01","ids":{"openalex":"https://openalex.org/W4413953486","doi":"https://doi.org/10.14778/3742728.3742731"},"language":"en","primary_location":{"id":"doi:10.14778/3742728.3742731","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3742728.3742731","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/A5064140883","display_name":"Elena Milkai","orcid":null},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Elena Milkai","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100734491","display_name":"Xiangyao Yu","orcid":"https://orcid.org/0009-0001-0785-2519"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xiangyao Yu","raw_affiliation_strings":["University of Wisconsin-Madison"],"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5069237428","display_name":"Jignesh M. Patel","orcid":"https://orcid.org/0000-0003-3653-2538"},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Jignesh M. Patel","raw_affiliation_strings":["Carnegie Mellon University"],"affiliations":[{"raw_affiliation_string":"Carnegie Mellon University","institution_ids":["https://openalex.org/I74973139"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5064140883"],"corresponding_institution_ids":["https://openalex.org/I135310074"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.32208925,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"18","issue":"8","first_page":"2334","last_page":"2347"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9865999817848206,"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/T10742","display_name":"Peer-to-Peer Network Technologies","score":0.9865999817848206,"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/T12203","display_name":"Mobile Agent-Based Network Management","score":0.9799000024795532,"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/T13062","display_name":"Cognitive Computing and Networks","score":0.9763000011444092,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/off-the-shelf","display_name":"Off the shelf","score":0.7371461391448975},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.6316575407981873},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5337499380111694},{"id":"https://openalex.org/keywords/transactional-analysis","display_name":"Transactional analysis","score":0.47370645403862},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3570270538330078},{"id":"https://openalex.org/keywords/software-engineering","display_name":"Software engineering","score":0.08383959531784058},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.08162304759025574}],"concepts":[{"id":"https://openalex.org/C2982819384","wikidata":"https://www.wikidata.org/wiki/Q7078910","display_name":"Off the shelf","level":2,"score":0.7371461391448975},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.6316575407981873},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5337499380111694},{"id":"https://openalex.org/C96961170","wikidata":"https://www.wikidata.org/wiki/Q623513","display_name":"Transactional analysis","level":2,"score":0.47370645403862},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3570270538330078},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.08383959531784058},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.08162304759025574},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3742728.3742731","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3742728.3742731","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":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":23,"referenced_works":["https://openalex.org/W1967601791","https://openalex.org/W2021651899","https://openalex.org/W2250374629","https://openalex.org/W2396727930","https://openalex.org/W2435606122","https://openalex.org/W2533835508","https://openalex.org/W2753767407","https://openalex.org/W2890707978","https://openalex.org/W2915048431","https://openalex.org/W3004616691","https://openalex.org/W3085441975","https://openalex.org/W3085477028","https://openalex.org/W3085924233","https://openalex.org/W3086851012","https://openalex.org/W3146147323","https://openalex.org/W3198682658","https://openalex.org/W4236979447","https://openalex.org/W4246662059","https://openalex.org/W4281771843","https://openalex.org/W4285451014","https://openalex.org/W4386125382","https://openalex.org/W4386768483","https://openalex.org/W4396571399"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","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"],"abstract_inverted_index":{"Many":[0],"modern":[1],"applications":[2],"require":[3],"real-time":[4,35,50,173],"analytics,":[5],"where":[6],"analytical":[7,72,86,117],"processing":[8,21],"(AP)":[9],"workloads":[10],"needs":[11],"access":[12],"to":[13,39,64,168],"the":[14,58,67,136,140,156],"latest":[15,68],"data":[16],"updates":[17,70],"from":[18],"a":[19,53,89,101,110,144],"transactional":[20,69,79,83,181],"(TP)":[22],"engine.":[23,138],"However,":[24],"managing":[25],"separate":[26],"TP":[27,60,137],"and":[28,61,74,85,130,143,175],"AP":[29,62,127],"engines":[30,63],"across":[31],"teams":[32],"complicates":[33],"achieving":[34],"analytics":[36,51,174,182],"without":[37,119],"switching":[38],"specialized":[40],"HTAP":[41,158,170],"systems.":[42],"To":[43],"address":[44],"this":[45,98],"challenge,":[46],"we":[47,152],"introduce":[48],"off-the-shelf":[49],",":[52,106,132],"system":[54],"design":[55],"that":[56,81,112,164],"leverages":[57],"existing":[59,121],"provide":[65],"(1)":[66],"for":[71,77,172],"queries":[73,87],"(2)":[75],"support":[76],"efficient":[78],"analytics-transactions":[80],"combine":[82],"logic":[84],"within":[88],"single":[90],"ACID":[91],"transaction-at":[92],"various":[93],"isolation":[94],"levels.":[95],"We":[96],"demonstrate":[97],"concept":[99],"with":[100,116,133,155],"new":[102,145],"service":[103],"called":[104,147],"Hermes":[105,154,165],"which":[107],"acts":[108],"as":[109,135],"middleware":[111],"merges":[113],"log":[114],"records":[115],"reads":[118],"altering":[120],"engines.":[122],"Our":[123,161],"evaluation":[124],"utilizes":[125],"two":[126],"engines,":[128],"FlexPushdownDB":[129],"DuckDB":[131],"MySQL":[134],"Using":[139],"HATtrick":[141],"benchmark":[142],"workload":[146],"Transactional":[148],"Analytics":[149],"Workload":[150],"(TAW),":[151],"compare":[153],"leading":[157],"solution,":[159],"TiDB.":[160],"results":[162],"indicate":[163],"performs":[166],"comparably":[167],"current":[169],"solutions":[171],"surpasses":[176],"them":[177],"by":[178],"3\u00d7":[179],"in":[180],"performance.":[183]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}