dorsal/arxiv
View SchemaImproving Database Performance by Application-side Transaction Merging
| Authors | Xueyuan Ren, Frank Li, Yang Wang |
|---|---|
| Categories | |
| ArXiv ID | 2601.10596vv1 |
| URL | https://arxiv.org/abs/2601.10596 |
| License | http://creativecommons.org/licenses/by/4.0/ |
Abstract
This paper explores a new opportunity to improve the performance of transaction processing at the application side by merging structurely similar statements or transactions. Concretely, we re-write transactions to 1) merge similar statements using specific SQL semantics; 2) eliminate redundant reads; and 3) merge contending statements across transactions by pre-computing their aggregated effect. Following this idea, we present the design of TransactionMerger, a middleware to collect and merge transactions across different clients. We further present a static analysis tool to identify the merging opportunity without violating isolation as well as our experience of re-writing transactions in TPC-C and Spree, a popular real-world application. Our evaluation shows that such transaction merging can improve TPC-C throughput by up to 2.65X and Spree throughput by 3.52X.
{
"annotation_id": "7d1affcc-0b98-4df7-b03f-fd0725da4b1b",
"date_created": "2026-02-17T05:53:23.746000Z",
"date_modified": "2026-02-17T05:53:23.746000Z",
"file_hash": "361f0faab8aa9bfad444801d069d83a368c8e5706c9f950fa242a8ff02f52690",
"private": false,
"record": {
"abstract": "This paper explores a new opportunity to improve the performance of transaction processing at the application side by merging structurely similar statements or transactions. Concretely, we re-write transactions to 1) merge similar statements using specific SQL semantics; 2) eliminate redundant reads; and 3) merge contending statements across transactions by pre-computing their aggregated effect. Following this idea, we present the design of TransactionMerger, a middleware to collect and merge transactions across different clients. We further present a static analysis tool to identify the merging opportunity without violating isolation as well as our experience of re-writing transactions in TPC-C and Spree, a popular real-world application. Our evaluation shows that such transaction merging can improve TPC-C throughput by up to 2.65X and Spree throughput by 3.52X.",
"arxiv_id": "2601.10596",
"authors": [
"Xueyuan Ren",
"Frank Li",
"Yang Wang"
],
"categories": [
"cs.DB"
],
"license": "http://creativecommons.org/licenses/by/4.0/",
"title": "Improving Database Performance by Application-side Transaction Merging",
"url": "https://arxiv.org/abs/2601.10596",
"version": "v1"
},
"schema_id": "dorsal/arxiv",
"source": {
"execution_id": "14641bef-d6e9-4f81-a6e3-048f76313fa1",
"id": "arXiv Dataset",
"type": "Model",
"variant": "snapshot-2026-01-17",
"version": "0.1.0"
},
"user_id": 1000002
}