DBScholar

Back to papers

TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads

Summary: TiQuE implements transactional logic (server-side snapshot retrieval and validation) as SQL query plans, allowing transactional semantics to be layered onto existing analytical engines and exploit optimizer/execution capabilities. Prototype on MonetDB shows ~500x transactional throughput improvement while preserving analytical performance, enabling true HTAP without bespoke engines. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID
hd95b97e2b2c48f52
Venue
VLDB
Year
2023
Pagerank
5.1235001e-05
Overall Rank
9,797 | 34.16%
DOI
10.14778/3598581.3598598
PDF
Download (CC BY-NC-ND 4.0)

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{faria_vldb23,
        title = {{TiQuE: Improving the Transactional Performance of Analytical Systems for True Hybrid Workloads}},
        author = {Faria, Nuno and Pereira, José and Alonso, Ana Nunes and Vilaça, Ricardo and Koning, Yunus and Nes, Niels},
        journal = {PVLDB},
        series = {{VLDB} '23},
        volume = {16},
        number = {9},
        pages = {2274--2288},
        doi = {10.14778/3598581.3598598},
        url = {https://doi.org/10.14778/3598581.3598598},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 38 of 38 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
19 A Critique of ANSI SQL Isolation Levels 1995 SIGMOD 0.00058759613
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043795812
55 Calvin: Fast Distributed Transactions for Partitioned Database Systems 2012 SIGMOD 0.00040454492
63 Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases 2017 SIGMOD 0.00038521221
99 The Design of the POSTGRES Storage System 1987 VLDB 0.00034019355
114 A Decomposition Storage Model 1985 SIGMOD 0.00031916625
139 Megastore: Providing Scalable, Highly Available Storage for Interactive Services 2011 CIDR 0.00029466567
157 OLTP Through the Looking Glass, and What We Found There 2008 SIGMOD 0.00028316479
163 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027480091
185 CockroachDB: The Resilient Geo-Distributed SQL Database 2020 SIGMOD 0.00026060465
224 Self-Driving Database Management Systems 2017 CIDR 0.00024011047
234 TiDB: A Raft-based HTAP Database 2020 VLDB 0.00023756332
401 A Case for Fractured Mirrors 2002 VLDB 0.00019102313
431 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00018400856
444 Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores 2015 VLDB 0.0001817002
460 Delta Lake: High-Performance ACID Table Storage over Cloud Object Stores 2020 VLDB 0.00017850215
1,102 Elle: Inferring Isolation Anomalies from Experimental Observations 2021 VLDB 0.00011999358
1,200 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00011559584
1,242 BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications 2017 SIGMOD 0.00011378275
1,264 Don't be lazy, be consistent: Postgres-R, A new way to implement Database Replication 2000 VLDB 0.00011281976
1,335 TicToc: Time Traveling Optimistic Concurrency Control 2016 SIGMOD 0.00010991964
1,352 Improving Optimistic Concurrency Control Through Transaction Batching and Operation Reordering 2019 VLDB 0.00010928386
1,380 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010858313
1,573 Carousel: Low-Latency Transaction Processing for Globally-Distributed Data 2018 SIGMOD 0.00010192267
1,642 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 0.00010002341
1,675 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.9136747e-05
1,845 Towards a One Size Fits All Database Architecture 2011 CIDR 9.5158088e-05
2,911 Deuteronomy: Transaction Support for Cloud Data 2011 CIDR 7.8685228e-05
2,922 Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads 2017 VLDB 7.8496897e-05
2,998 F1 Lightning: HTAP as a Service 2020 VLDB 7.7667188e-05
3,934 The Case For Heterogeneous HTAP 2017 CIDR 6.9145781e-05
4,437 Adaptive Concurrency Control: Despite the Looking Glass, One Concurrency Control Does Not Fit All 2017 CIDR 6.5976634e-05
4,830 Cloud-Native Transactions and Analytics in SingleStore 2022 SIGMOD 6.3885902e-05
5,422 ConfluxDB: Multi-Master Replication for Partitioned Snapshot Isolation Databases 2014 VLDB 6.1349911e-05
5,699 Long-lived Transactions Made Less Harmful 2020 SIGMOD 6.0291201e-05
5,917 Diva: Making MVCC Systems HTAP-Friendly 2022 SIGMOD 5.9469335e-05
6,300 Mainlining Databases: Supporting Fast Transactional Workloads on Universal Columnar Data File Formats 2021 VLDB 5.8174924e-05
11,707 MRVs: Enforcing Numeric Invariants in Parallel Updates to Hotspots with Randomized Splitting 2023 SIGMOD 4.9769913e-05
Previous Page 1 / 1 Next

Semantically Similar Papers