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.1065586e-05
Overall Rank
9,830 | 34.11%
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.00058631912
48 Weaving Relations for Cache Performance 2001 VLDB 0.00043770511
54 Calvin: Fast Distributed Transactions for Partitioned Database Systems 2012 SIGMOD 0.00040489652
63 Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases 2017 SIGMOD 0.00038609177
101 The Design of the POSTGRES Storage System 1987 VLDB 0.00033939695
114 A Decomposition Storage Model 1985 SIGMOD 0.00031854546
139 Megastore: Providing Scalable, Highly Available Storage for Interactive Services 2011 CIDR 0.00029386971
157 OLTP Through the Looking Glass, and What We Found There 2008 SIGMOD 0.00028244257
161 DB2 with BLU Acceleration: So Much More than Just a Column Store 2013 VLDB 0.00027629724
186 CockroachDB: The Resilient Geo-Distributed SQL Database 2020 SIGMOD 0.00026001543
224 Self-Driving Database Management Systems 2017 CIDR 0.00023973185
232 TiDB: A Raft-based HTAP Database 2020 VLDB 0.00023776373
403 A Case for Fractured Mirrors 2002 VLDB 0.00019067656
431 HYRISE—A Main Memory Hybrid Storage Engine 2011 VLDB 0.00018411252
447 Staring into the Abyss: An Evaluation of Concurrency Control with One Thousand Cores 2015 VLDB 0.00018126139
462 Delta Lake: High-Performance ACID Table Storage over Cloud Object Stores 2020 VLDB 0.00017825062
1,103 Elle: Inferring Isolation Anomalies from Experimental Observations 2021 VLDB 0.00011969356
1,188 Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads 2016 SIGMOD 0.00011580449
1,232 BatchDB: Efficient Isolated Execution of Hybrid OLTP+OLAP Workloads for Interactive Applications 2017 SIGMOD 0.00011406847
1,264 Don't be lazy, be consistent: Postgres-R, A new way to implement Database Replication 2000 VLDB 0.00011265551
1,302 TicToc: Time Traveling Optimistic Concurrency Control 2016 SIGMOD 0.00011092608
1,320 Improving Optimistic Concurrency Control Through Transaction Batching and Operation Reordering 2019 VLDB 0.00011021933
1,383 H2O: A Hands-free Adaptive Store 2014 SIGMOD 0.00010826996
1,575 Carousel: Low-Latency Transaction Processing for Globally-Distributed Data 2018 SIGMOD 0.00010160119
1,646 Data Morphing: An Adaptive, Cache-Conscious Storage Technique 2003 VLDB 9.9748468e-05
1,659 Real-Time Analytical Processing with SQL Server 2015 VLDB 9.9440956e-05
1,845 Towards a One Size Fits All Database Architecture 2011 CIDR 9.507323e-05
2,895 Parallel Replication across Formats in SAP HANA for Scaling Out Mixed OLTP/OLAP Workloads 2017 VLDB 7.8856044e-05
2,922 Deuteronomy: Transaction Support for Cloud Data 2011 CIDR 7.8428159e-05
2,959 F1 Lightning: HTAP as a Service 2020 VLDB 7.7990674e-05
3,869 The Case For Heterogeneous HTAP 2017 CIDR 6.9434054e-05
4,450 Adaptive Concurrency Control: Despite the Looking Glass, One Concurrency Control Does Not Fit All 2017 CIDR 6.5787041e-05
4,763 Cloud-Native Transactions and Analytics in SingleStore 2022 SIGMOD 6.4172712e-05
5,431 ConfluxDB: Multi-Master Replication for Partitioned Snapshot Isolation Databases 2014 VLDB 6.1179834e-05
5,709 Long-lived Transactions Made Less Harmful 2020 SIGMOD 6.010393e-05
5,788 Diva: Making MVCC Systems HTAP-Friendly 2022 SIGMOD 5.9763511e-05
6,295 Mainlining Databases: Supporting Fast Transactional Workloads on Universal Columnar Data File Formats 2021 VLDB 5.8042139e-05
11,753 MRVs: Enforcing Numeric Invariants in Parallel Updates to Hotspots with Randomized Splitting 2023 SIGMOD 4.9605343e-05
Previous Page 1 / 1 Next

Semantically Similar Papers