{"id":"https://openalex.org/W4417070541","doi":"https://doi.org/10.1145/3769775","title":"Counting Is All You Need for Instant Tuple Discovery: Enabling Real-Time HTAP in Standalone DBMSs","display_name":"Counting Is All You Need for Instant Tuple Discovery: Enabling Real-Time HTAP in Standalone DBMSs","publication_year":2025,"publication_date":"2025-12-04","ids":{"openalex":"https://openalex.org/W4417070541","doi":"https://doi.org/10.1145/3769775"},"language":"en","primary_location":{"id":"doi:10.1145/3769775","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3769775","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://doi.org/10.1145/3769775","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5111863519","display_name":"Kyoung Soo Lim","orcid":"https://orcid.org/0009-0007-6603-2397"},"institutions":[{"id":"https://openalex.org/I139264467","display_name":"Seoul National University","ror":"https://ror.org/04h9pn542","country_code":"KR","type":"education","lineage":["https://openalex.org/I139264467"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Kyungmin Lim","raw_affiliation_strings":["Seoul National University, Seoul, Republic of Korea"],"raw_orcid":"https://orcid.org/0009-0007-6603-2397","affiliations":[{"raw_affiliation_string":"Seoul National University, Seoul, Republic of Korea","institution_ids":["https://openalex.org/I139264467"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102197109","display_name":"Min-Seok Yoon","orcid":"https://orcid.org/0009-0004-2496-1591"},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Minseok Yoon","raw_affiliation_strings":["Hanyang University, Seoul, Republic of Korea"],"raw_orcid":"https://orcid.org/0009-0004-2496-1591","affiliations":[{"raw_affiliation_string":"Hanyang University, Seoul, Republic of Korea","institution_ids":["https://openalex.org/I4575257"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062525251","display_name":"K. S. Kim","orcid":"https://orcid.org/0009-0004-4954-1454"},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Kihwan Kim","raw_affiliation_strings":["Hanyang University, Seoul, Republic of Korea"],"raw_orcid":"https://orcid.org/0009-0004-4954-1454","affiliations":[{"raw_affiliation_string":"Hanyang University, Seoul, Republic of Korea","institution_ids":["https://openalex.org/I4575257"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025255598","display_name":"Alan Fekete","orcid":"https://orcid.org/0000-0003-3804-5450"},"institutions":[{"id":"https://openalex.org/I129604602","display_name":"The University of Sydney","ror":"https://ror.org/0384j8v12","country_code":"AU","type":"education","lineage":["https://openalex.org/I129604602"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Alan Fekete","raw_affiliation_strings":["The University of Sydney, Sydney, Australia"],"raw_orcid":"https://orcid.org/0000-0003-3804-5450","affiliations":[{"raw_affiliation_string":"The University of Sydney, Sydney, Australia","institution_ids":["https://openalex.org/I129604602"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034858357","display_name":"Hyungsoo Jung","orcid":"https://orcid.org/0000-0002-5376-7200"},"institutions":[{"id":"https://openalex.org/I139264467","display_name":"Seoul National University","ror":"https://ror.org/04h9pn542","country_code":"KR","type":"education","lineage":["https://openalex.org/I139264467"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Hyungsoo Jung","raw_affiliation_strings":["Seoul National University, Seoul, Republic of Korea"],"raw_orcid":"https://orcid.org/0000-0002-5376-7200","affiliations":[{"raw_affiliation_string":"Seoul National University, Seoul, Republic of Korea","institution_ids":["https://openalex.org/I139264467"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.39076652,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"3","issue":"6","first_page":"1","last_page":"28"},"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.7588000297546387,"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.7588000297546387,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.12999999523162842,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T12127","display_name":"Software System Performance and Reliability","score":0.027300000190734863,"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/tuple","display_name":"Tuple","score":0.7706999778747559},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.7239999771118164},{"id":"https://openalex.org/keywords/trace","display_name":"TRACE (psycholinguistics)","score":0.6395999789237976},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.5368000268936157},{"id":"https://openalex.org/keywords/transformation","display_name":"Transformation (genetics)","score":0.44609999656677246},{"id":"https://openalex.org/keywords/resource","display_name":"Resource (disambiguation)","score":0.38280001282691956},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.3815999925136566},{"id":"https://openalex.org/keywords/path","display_name":"Path (computing)","score":0.3783000111579895},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.3515999913215637}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8823000192642212},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7706999778747559},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.7239999771118164},{"id":"https://openalex.org/C75291252","wikidata":"https://www.wikidata.org/wiki/Q1315756","display_name":"TRACE (psycholinguistics)","level":2,"score":0.6395999789237976},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.5368000268936157},{"id":"https://openalex.org/C204241405","wikidata":"https://www.wikidata.org/wiki/Q461499","display_name":"Transformation (genetics)","level":3,"score":0.44609999656677246},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.38769999146461487},{"id":"https://openalex.org/C206345919","wikidata":"https://www.wikidata.org/wiki/Q20380951","display_name":"Resource (disambiguation)","level":2,"score":0.38280001282691956},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.3815999925136566},{"id":"https://openalex.org/C2777735758","wikidata":"https://www.wikidata.org/wiki/Q817765","display_name":"Path (computing)","level":2,"score":0.3783000111579895},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3630000054836273},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.3515999913215637},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.3285999894142151},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.32339999079704285},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3118000030517578},{"id":"https://openalex.org/C79403827","wikidata":"https://www.wikidata.org/wiki/Q3988","display_name":"Real-time computing","level":1,"score":0.28999999165534973},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.2856999933719635},{"id":"https://openalex.org/C2164484","wikidata":"https://www.wikidata.org/wiki/Q5170150","display_name":"Core (optical fiber)","level":2,"score":0.2768000066280365},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.2757999897003174},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.27300000190734863},{"id":"https://openalex.org/C19012869","wikidata":"https://www.wikidata.org/wiki/Q578372","display_name":"Response time","level":2,"score":0.2718000113964081},{"id":"https://openalex.org/C45235069","wikidata":"https://www.wikidata.org/wiki/Q278425","display_name":"Table (database)","level":2,"score":0.2705000042915344},{"id":"https://openalex.org/C78766204","wikidata":"https://www.wikidata.org/wiki/Q555032","display_name":"Multi-core processor","level":2,"score":0.26759999990463257},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.267300009727478},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.2614000141620636},{"id":"https://openalex.org/C29202148","wikidata":"https://www.wikidata.org/wiki/Q287260","display_name":"Resource allocation","level":2,"score":0.2603999972343445},{"id":"https://openalex.org/C20556612","wikidata":"https://www.wikidata.org/wiki/Q4469374","display_name":"Volume (thermodynamics)","level":2,"score":0.2581000030040741},{"id":"https://openalex.org/C63540848","wikidata":"https://www.wikidata.org/wiki/Q3140932","display_name":"Fault tolerance","level":2,"score":0.25760000944137573},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.25270000100135803},{"id":"https://openalex.org/C2775941552","wikidata":"https://www.wikidata.org/wiki/Q25212305","display_name":"Isolation (microbiology)","level":2,"score":0.2515000104904175}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3769775","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3769775","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.1145/3769775","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3769775","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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":"cc-by-nc","license_id":"https://openalex.org/licenses/cc-by-nc","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":31,"referenced_works":["https://openalex.org/W2006296837","https://openalex.org/W2014977566","https://openalex.org/W2041423790","https://openalex.org/W2068739275","https://openalex.org/W2075345089","https://openalex.org/W2102639991","https://openalex.org/W2104954161","https://openalex.org/W2122048769","https://openalex.org/W2250374629","https://openalex.org/W2605800201","https://openalex.org/W2754332001","https://openalex.org/W2764131694","https://openalex.org/W2765113847","https://openalex.org/W2798441769","https://openalex.org/W2948214724","https://openalex.org/W2949054050","https://openalex.org/W3085441975","https://openalex.org/W3085924233","https://openalex.org/W3131834909","https://openalex.org/W3167346145","https://openalex.org/W3174745414","https://openalex.org/W3176391989","https://openalex.org/W4281718197","https://openalex.org/W4281774998","https://openalex.org/W4312621027","https://openalex.org/W4313065965","https://openalex.org/W4366660200","https://openalex.org/W4383749392","https://openalex.org/W4383749451","https://openalex.org/W4386768711","https://openalex.org/W4404181190"],"related_works":[],"abstract_inverted_index":{"HTAP":[0,128],"systems":[1],"aim":[2],"to":[3,132],"unify":[4],"operational":[5],"and":[6,32,37,111,116],"analytical":[7],"workloads,":[8],"yet":[9],"real-time":[10,49,127],"analytics":[11,50],"remains":[12],"constrained":[13],"by":[14,130],"the":[15],"overhead":[16],"of":[17],"extract-transform-load":[18],"(ETL)":[19],"operations.":[20],"Existing":[21],"solutions":[22],"often":[23],"rely":[24],"on":[25],"dual-system":[26],"architectures,":[27],"incurring":[28],"substantial":[29],"resource":[30],"costs":[31],"delays":[33],"from":[34],"data":[35,99,138],"reformatting":[36],"relocation.":[38],"We":[39,106],"present":[40],"TracerETL":[41,108,125],",":[42,66],"a":[43,67,74,141],"progressive":[44,137],"ETL":[45],"framework":[46],"that":[47,72,122],"enables":[48],"in":[51,109,140],"standalone":[52,142],"DBMSs":[53],"through":[54],"instant":[55],"tuple":[56,69,75],"location":[57],"discovery":[58],"during":[59],"transformation.":[60],"At":[61],"its":[62],"core":[63],"is":[64],"Tracer":[65],"counting-based":[68],"tracking":[70],"mechanism":[71],"constructs":[73],"trace":[76,82],"vector":[77,83],"using":[78],"per-partition":[79],"counters.":[80],"This":[81],"deterministically":[84],"encodes":[85],"each":[86],"tuple's":[87],"future":[88],"relocation":[89],"path":[90],"with":[91,124],"arrival":[92],"order":[93],"across":[94],"transformation":[95],"levels,":[96],"enabling":[97],"precise":[98],"access":[100],"at":[101],"any":[102],"stage-without":[103],"auxiliary":[104],"indexes.":[105],"implement":[107],"PostgreSQL":[110,123],"evaluate":[112],"it":[113],"against":[114],"OLAP-":[115],"OLTP-optimized":[117],"DBMSs.":[118],"Experimental":[119],"results":[120],"show":[121],"accelerates":[126],"queries":[129],"up":[131],"127\u00d7,":[133],"while":[134],"efficiently":[135],"handling":[136],"conversion":[139],"DBMS.":[143]},"counts_by_year":[],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-12-06T00:00:00"}