{"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":{"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":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-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/A5048260664","display_name":"Nuno Faria","orcid":"https://orcid.org/0000-0003-4691-0440"},"institutions":[{"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"]},{"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"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Nuno Faria","raw_affiliation_strings":["INESCTEC and University of Minho, Braga, Portugal"],"affiliations":[{"raw_affiliation_string":"INESCTEC and University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210166615"]}]},{"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/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]},{"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"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Jos\u00e9 Pereira","raw_affiliation_strings":["INESCTEC and University of Minho, Braga, Portugal"],"affiliations":[{"raw_affiliation_string":"INESCTEC and University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210166615"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079603660","display_name":"Ana Nunes","orcid":"https://orcid.org/0000-0002-0519-9675"},"institutions":[{"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"]},{"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"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Ana Nunes Alonso","raw_affiliation_strings":["INESCTEC and University of Minho, Braga, Portugal"],"affiliations":[{"raw_affiliation_string":"INESCTEC and University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210166615"]}]},{"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/I99682543","display_name":"University of Minho","ror":"https://ror.org/037wpkx04","country_code":"PT","type":"education","lineage":["https://openalex.org/I99682543"]},{"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"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Ricardo Vila\u00e7a","raw_affiliation_strings":["INESCTEC and University of Minho, Braga, Portugal"],"affiliations":[{"raw_affiliation_string":"INESCTEC and University of Minho, Braga, Portugal","institution_ids":["https://openalex.org/I99682543","https://openalex.org/I4210166615"]}]},{"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"],"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":["NL"],"is_corresponding":false,"raw_author_name":"Niels Nes","raw_affiliation_strings":["MonetDB Solutions and CWI Amsterdam, The Netherlands"],"affiliations":[{"raw_affiliation_string":"MonetDB Solutions and CWI Amsterdam, The Netherlands","institution_ids":[]}]}],"institution_assertions":[],"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.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":0,"max":67},"biblio":{"volume":"16","issue":"9","first_page":"2274","last_page":"2288"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998,"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.9998,"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.9962,"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.9886,"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/snapshot","display_name":"Snapshot (computer storage)","score":0.54146516}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8647542},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.65018576},{"id":"https://openalex.org/C68489960","wikidata":"https://www.wikidata.org/wiki/Q2370659","display_name":"Transactional leadership","level":2,"score":0.5550775},{"id":"https://openalex.org/C55282118","wikidata":"https://www.wikidata.org/wiki/Q252683","display_name":"Snapshot (computer storage)","level":2,"score":0.54146516},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.49499267},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.48985693},{"id":"https://openalex.org/C134277064","wikidata":"https://www.wikidata.org/wiki/Q878206","display_name":"Transactional memory","level":3,"score":0.4703011},{"id":"https://openalex.org/C157764524","wikidata":"https://www.wikidata.org/wiki/Q1383412","display_name":"Throughput","level":3,"score":0.44009253},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40042144},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.35404694},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.17564052},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"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/C555944384","wikidata":"https://www.wikidata.org/wiki/Q249","display_name":"Wireless","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"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":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4,"display_name":"Industry, innovation and infrastructure","id":"https://metadata.un.org/sdg/9"}],"grants":[],"datasets":[],"versions":[],"referenced_works_count":61,"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/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"],"related_works":["https://openalex.org/W3034994054","https://openalex.org/W2978286473","https://openalex.org/W2542847180","https://openalex.org/W2316531414","https://openalex.org/W2177773059","https://openalex.org/W2171499640","https://openalex.org/W2155226960","https://openalex.org/W2124593258","https://openalex.org/W2101555342","https://openalex.org/W2069952143"],"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]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4383749392","counts_by_year":[],"updated_date":"2025-01-05T04:39:58.343864","created_date":"2023-07-11"}