Automatic Partitioning of Database Applications

Summary: Automatic partitioning of database applications between app and DB server using Pyxis. It profiles, analyzes dependencies, and minimizes control transfers and data movement to approach stored-procedure performance; experiments on TPC-C/TPC-W show up to 3x latency reduction and 1.7x throughput gain versus non-partitioned, competitive with handcrafted stored procedures. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 10383
Venue: VLDB
Year: 2012
Pagerank: 7.2422925e-05
Overall Rank: 3,308 | 76.99%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 16 of 16 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,513	Leveraging Lock Contention to Improve OLTP Application Performance	2016	VLDB	8.6178149e-05
2,867	StatusQuo: Making Familiar Abstractions Perform Using Program Analysis	2013	CIDR	7.9831651e-05
2,926	Design Principles for Scaling Multi-core OLTP Under High Contention	2016	SIGMOD	7.884983e-05
2,954	Magpie: Python at Speed and Scale using Cloud Backends	2021	CIDR	7.8262582e-05
3,512	Feral Concurrency Control: An Empirical Investigation of Modern Application Integrity	2015	SIGMOD	7.0250008e-05
4,166	Sloth: Being Lazy is a Virtue (When Issuing Database Queries)	2014	SIGMOD	6.391976e-05
4,633	Transaction Healing: Scaling Optimistic Concurrency Control on Multicores	2016	SIGMOD	6.0340758e-05
4,648	Aggify: Lifting the Curse of Cursor Loops using Custom Aggregates	2020	SIGMOD	6.0247446e-05
5,554	Fast Failure Recovery for Main-Memory DBMSs on Multicores	2017	SIGMOD	5.4390216e-05
5,614	New Directions in Cloud Programming	2021	CIDR	5.4101976e-05
6,140	Speeding up Database Applications with Pyxis	2013	SIGMOD	5.1910467e-05
6,483	Towards Unified Ad-hoc Data Processing	2014	SIGMOD	5.0456397e-05
6,692	WeBridge: Synthesizing Stored Procedures for Large-Scale Real-World Web Applications	2024	SIGMOD	4.9599916e-05
10,099	PLForge: Enhancing Language Models for Natural Language to Procedural Extensions of SQL	2026	SIGMOD	4.1945683e-05
10,333	OLTP Through the Looking Glass 16 Years Later: Communication is the New Bottleneck	2025	CIDR	4.1945683e-05
11,797	Runtime Optimization of Join Location in Parallel Data Management Systems	2017	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
202	LINQ: Reconciling Objects, Relations and XML in the .NET Framework	2006	SIGMOD	0.00034920912
285	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.0002899128
286	Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design	2004	SIGMOD	0.00028990057
1,456	Rewriting Procedures for Batched Bindings	2008	VLDB	0.00011899772

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,005	Clay: Fine-Grained Adaptive Partitioning for General Database Schemas	2017	VLDB	7.7303579e-05
1,999	Data Morphing: An Adaptive, Cache-Conscious Storage Technique	2003	VLDB	9.8235392e-05
3,214	Query Optimization Techniques for Partitioned Tables	2011	SIGMOD	7.3661891e-05
285	Automating Physical Database Design in a Parallel Database	2002	SIGMOD	0.0002899128
1,700	Bridging the Archipelago between Row-Stores and Column-Stores for Hybrid Workloads	2016	SIGMOD	0.00010858865
7,406	Database Isolation By Scheduling	2021	VLDB	4.7375424e-05
4,108	Cracking the Database Store	2005	CIDR	6.4440088e-05
5,742	JECB: a Join-Extension, Code-Based Approach to OLTP Data Partitioning	2014	SIGMOD	5.3450287e-05
679	Skew-Aware Automatic Database Partitioning in Shared-Nothing, Parallel OLTP Systems	2012	SIGMOD	0.00018215154
6,140	Speeding up Database Applications with Pyxis	2013	SIGMOD	5.1910467e-05