{"id":"https://openalex.org/W4383749392","doi":"https://doi.org/10.14778/3598581.3598598","title":"TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads","display_name":"TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads","publication_year":2023,"publication_date":"2023-05-01","ids":{"openalex":"https://openalex.org/W4383749392","doi":"https://doi.org/10.14778/3598581.3598598"},"language":"en","primary_location":{"id":"doi:10.14778/3598581.3598598","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3598581.3598598","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":true,"oa_status":"green","oa_url":"https://hdl.handle.net/1822/89620","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5048260664","display_name":"Nuno Faria","orcid":"https://orcid.org/0000-0003-4691-0440"},"institutions":[{"id":"https://openalex.org/I4210166615","display_name":"INESC TEC","ror":"https://ror.org/05fa8ka61","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590","https://openalex.org/I4210166615"]},{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Nuno Faria","raw_affiliation_strings":["INESCTEC and University of Minho, Braga, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"INESCTEC and University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I4210166615","https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065441606","display_name":"Jos\u00e9 Pereira","orcid":"https://orcid.org/0000-0002-3341-9217"},"institutions":[{"id":"https://openalex.org/I4210166615","display_name":"INESC TEC","ror":"https://ror.org/05fa8ka61","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590","https://openalex.org/I4210166615"]},{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Pereira","raw_affiliation_strings":["INESCTEC and University of Minho, Braga, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"INESCTEC and University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I4210166615","https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079603660","display_name":"Ana Nunes Alonso","orcid":"https://orcid.org/0000-0002-0519-9675"},"institutions":[{"id":"https://openalex.org/I4210166615","display_name":"INESC TEC","ror":"https://ror.org/05fa8ka61","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590","https://openalex.org/I4210166615"]},{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Ana Nunes Alonso","raw_affiliation_strings":["INESCTEC and University of Minho, Braga, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"INESCTEC and University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I4210166615","https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5075281320","display_name":"Ricardo Vila\u00e7a","orcid":"https://orcid.org/0000-0002-6957-1536"},"institutions":[{"id":"https://openalex.org/I4210166615","display_name":"INESC TEC","ror":"https://ror.org/05fa8ka61","country_code":"PT","type":"nonprofit","lineage":["https://openalex.org/I4210125590","https://openalex.org/I4210166615"]},{"id":"https://openalex.org/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Ricardo Vila\u00e7a","raw_affiliation_strings":["INESCTEC and University of Minho, Braga, Portugal"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"INESCTEC and University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I4210166615","https://openalex.org/I99682543"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5092635966","display_name":"Yunus Koning","orcid":null},"institutions":[{"id":"https://openalex.org/I3211772741","display_name":"BioDetection Systems (Netherlands)","ror":"https://ror.org/05396f476","country_code":"NL","type":"company","lineage":["https://openalex.org/I3211772741"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Yunus Koning","raw_affiliation_strings":["MonetDB Solutions, Amsterdam, The Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MonetDB Solutions, Amsterdam, The Netherlands","institution_ids":["https://openalex.org/I3211772741"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041092741","display_name":"Niels Nes","orcid":"https://orcid.org/0009-0000-5927-2551"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Niels Nes","raw_affiliation_strings":["MonetDB Solutions and CWI Amsterdam, The Netherlands"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MonetDB Solutions and CWI Amsterdam, The Netherlands","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.6663,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.68589762,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":98},"biblio":{"volume":"16","issue":"9","first_page":"2274","last_page":"2288"},"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.9998000264167786,"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.9998000264167786,"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.9962000250816345,"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.9886000156402588,"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.8647541999816895},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.650185763835907},{"id":"https://openalex.org/keywords/transactional-leadership","display_name":"Transactional leadership","score":0.5550774931907654},{"id":"https://openalex.org/keywords/snapshot","display_name":"Snapshot (computer storage)","score":0.541465163230896},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4949926733970642},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.48985692858695984},{"id":"https://openalex.org/keywords/transactional-memory","display_name":"Transactional memory","score":0.47030109167099},{"id":"https://openalex.org/keywords/throughput","display_name":"Throughput","score":0.440092533826828},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4004214406013489},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.35404694080352783},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.1756405234336853}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8647541999816895},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.650185763835907},{"id":"https://openalex.org/C68489960","wikidata":"https://www.wikidata.org/wiki/Q2370659","display_name":"Transactional leadership","level":2,"score":0.5550774931907654},{"id":"https://openalex.org/C55282118","wikidata":"https://www.wikidata.org/wiki/Q252683","display_name":"Snapshot (computer storage)","level":2,"score":0.541465163230896},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4949926733970642},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.48985692858695984},{"id":"https://openalex.org/C134277064","wikidata":"https://www.wikidata.org/wiki/Q878206","display_name":"Transactional memory","level":3,"score":0.47030109167099},{"id":"https://openalex.org/C157764524","wikidata":"https://www.wikidata.org/wiki/Q1383412","display_name":"Throughput","level":3,"score":0.440092533826828},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4004214406013489},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.35404694080352783},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.1756405234336853},{"id":"https://openalex.org/C555944384","wikidata":"https://www.wikidata.org/wiki/Q249","display_name":"Wireless","level":2,"score":0.0},{"id":"https://openalex.org/C77805123","wikidata":"https://www.wikidata.org/wiki/Q161272","display_name":"Social psychology","level":1,"score":0.0},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/3598581.3598598","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3598581.3598598","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"},{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/89620","is_oa":true,"landing_page_url":"https://hdl.handle.net/1822/89620","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":"","raw_type":"journal article"}],"best_oa_location":{"id":"pmh:oai:repositorium.sdum.uminho.pt:1822/89620","is_oa":true,"landing_page_url":"https://hdl.handle.net/1822/89620","pdf_url":null,"source":{"id":"https://openalex.org/S4306402433","display_name":"Portuguese National Funding Agency for Science, Research and Technology (RCAAP Project by FCT)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":"","raw_type":"journal article"},"sustainable_development_goals":[{"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9","score":0.4000000059604645}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":65,"referenced_works":["https://openalex.org/W1509841269","https://openalex.org/W1515932031","https://openalex.org/W1522250531","https://openalex.org/W1545155892","https://openalex.org/W1967601791","https://openalex.org/W1969925795","https://openalex.org/W1981420413","https://openalex.org/W2007005039","https://openalex.org/W2025073323","https://openalex.org/W2039910065","https://openalex.org/W2047474931","https://openalex.org/W2051669959","https://openalex.org/W2054075931","https://openalex.org/W2060440895","https://openalex.org/W2063601856","https://openalex.org/W2068245803","https://openalex.org/W2097155078","https://openalex.org/W2102729946","https://openalex.org/W2104954161","https://openalex.org/W2117034946","https://openalex.org/W2117546628","https://openalex.org/W2119887456","https://openalex.org/W2130642985","https://openalex.org/W2132449006","https://openalex.org/W2133386065","https://openalex.org/W2139086035","https://openalex.org/W2141710443","https://openalex.org/W2161730338","https://openalex.org/W2170853664","https://openalex.org/W2171543585","https://openalex.org/W2250374629","https://openalex.org/W2290782711","https://openalex.org/W2293393493","https://openalex.org/W2394555589","https://openalex.org/W2425029179","https://openalex.org/W2426624872","https://openalex.org/W2476146301","https://openalex.org/W2525726844","https://openalex.org/W2584555500","https://openalex.org/W2612041618","https://openalex.org/W2612759782","https://openalex.org/W2734941459","https://openalex.org/W2753767407","https://openalex.org/W2798304533","https://openalex.org/W2902648414","https://openalex.org/W2915025126","https://openalex.org/W2915055379","https://openalex.org/W2919742489","https://openalex.org/W2982402713","https://openalex.org/W3004616691","https://openalex.org/W3031917602","https://openalex.org/W3032843849","https://openalex.org/W3085441975","https://openalex.org/W3085477028","https://openalex.org/W3085924233","https://openalex.org/W3131834909","https://openalex.org/W3137759927","https://openalex.org/W4243479492","https://openalex.org/W4244180879","https://openalex.org/W4281786663","https://openalex.org/W4282568518","https://openalex.org/W4380433133","https://openalex.org/W6679817081","https://openalex.org/W6686169942","https://openalex.org/W6733403177"],"related_works":["https://openalex.org/W2069952143","https://openalex.org/W2542847180","https://openalex.org/W2177773059","https://openalex.org/W3034994054","https://openalex.org/W2155226960","https://openalex.org/W2978286473","https://openalex.org/W2171499640","https://openalex.org/W2316531414","https://openalex.org/W2101555342","https://openalex.org/W2124593258"],"abstract_inverted_index":{"Transactions":[0],"have":[1],"been":[2],"a":[3,10,16,68,75,98],"key":[4],"issue":[5],"in":[6,74,108,138],"database":[7],"management":[8,34],"for":[9,43,48],"long":[11],"time":[12],"and":[13,20,24,35,101,111,132],"there":[14],"are":[15],"plethora":[17],"of":[18,97,104,115,120],"architectures":[19],"algorithms":[21],"to":[22,45,52,70],"support":[23,53],"implement":[25,71],"them.":[26],"The":[27],"current":[28],"state-of-the-art":[29,153],"is":[30,36],"focused":[31],"on":[32,89,130,145],"storage":[33],"tightly":[37],"coupled":[38],"with":[39,67,151],"its":[40],"design,":[41],"leading,":[42],"instance,":[44],"the":[46,95,102,109,152],"need":[47],"completely":[49],"new":[50,54],"engines":[51],"features":[55],"such":[56,78],"as":[57,79],"Hybrid":[58],"Transactional":[59],"Analytical":[60],"Processing":[61],"(HTAP).":[62],"We":[63,125],"address":[64],"this":[65],"challenge":[66],"proposal":[69],"transactional":[72,99,139],"logic":[73],"query":[76,117,123],"language":[77],"SQL.":[80],"This":[81],"means":[82],"that":[83,94],"our":[84,127],"approach":[85],"can":[86,112],"be":[87],"layered":[88],"existing":[90],"analytical":[91,146],"systems":[92],"but":[93],"retrieval":[96],"snapshot":[100],"validation":[103],"update":[105],"transactions":[106],"runs":[107],"server":[110],"take":[113],"advantage":[114],"advanced":[116],"execution":[118],"capabilities":[119],"an":[121,134],"optimizing":[122],"engine.":[124],"demonstrate":[126],"proposal,":[128],"TiQuE,":[129],"MonetDB":[131],"obtain":[133],"average":[135],"500x":[136],"improvement":[137],"throughput":[140],"while":[141],"retaining":[142],"good":[143],"performance":[144],"queries,":[147],"making":[148],"it":[149],"competitive":[150],"HTAP":[154],"systems.":[155]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4}],"updated_date":"2026-07-23T08:03:31.855105","created_date":"2025-10-10T00:00:00"}