Towards Unified Ad-hoc Data Processing

Summary: UniAD introduces UniQL, an HOQ-based intermediate representation for ad-hoc procedural data tasks, enabling cross-boundary optimizations between procedural and declarative code. A four-benchmark study demonstrates substantial performance gains across diverse user programs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 4925
Venue: SIGMOD
Year: 2014
Pagerank: 5.7959651e-05
Overall Rank: 6,714 | 53.94%
DOI: 10.1145/2588555.2610492

Incoming Non-self Citations Over Time

Authors

1. Xiaogang Shi (Peking University)
2. Bin Cui (Peking University)
3. Gillian Dobbie (University of Auckland)
4. Beng Chin Ooi (National University of Singapore)

BibTeX Citation

@inproceedings{shi_sigmod14,
        title = {{Towards Unified Ad-hoc Data Processing}},
        author = {Shi, Xiaogang and Cui, Bin and Dobbie, Gillian and Ooi, Beng Chin},
        series = {{SIGMOD} '14},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/2588555.2610492},
        url = {https://dl.acm.org/doi/10.1145/2588555.2610492},
        year = {2014}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
2,939	Extracting Equivalent SQL from Imperative Code in Database Applications	2016	SIGMOD	7.9395908e-05
6,181	Just-In-Time Data Virtualization: Lightweight Data Management with ViDa	2015	CIDR	5.9494838e-05

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
6	Pig Latin: A Not-So-Foreign Language for Data Processing	2008	SIGMOD	0.0010686205
23	Efficiently Compiling Efficient Query Plans for Modern Hardware	2011	VLDB	0.00054886415
32	Hive - A Warehousing Solution Over a Map-Reduce Framework	2009	VLDB	0.00050111008
38	Hekaton: SQL Server’s Memory-Optimized OLTP Engine	2013	SIGMOD	0.00047648573
226	OLTP-Bench: An Extensible Testbed for Benchmarking Relational Databases	2014	VLDB	0.00024027277
1,073	A General Framework for the Optimization of Object-Oriented Queries	1992	SIGMOD	0.00012300294
1,257	Automatic Optimization for MapReduce Programs	2011	VLDB	0.000114432
1,261	Rewriting Procedures for Batched Bindings	2008	VLDB	0.0001143305
2,505	A Transformation-Based Approach to Optimizing Loops in Database Programming Languages	1992	SIGMOD	8.4960641e-05
2,941	Automatic Partitioning of Database Applications	2012	VLDB	7.937125e-05
4,452	Just-in-time compilation for SQL query processing	2013	VLDB	6.6942969e-05
4,977	Relational Approach for Shortest Path Discovery over Large Graphs	2012	VLDB	6.4166233e-05
5,759	Holistic Optimization by Prefetching Query Results	2012	SIGMOD	6.0962298e-05
8,962	Automatic Contention Detection and Amelioration for Data-Intensive Operations	2010	SIGMOD	5.3435928e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	9,949	UniView: A Unified Autonomous Materialized View Management System for Various Databases	2024	VLDB
2	4,273	User-Defined Operators: Efficiently Integrating Custom Algorithms into Modern Databases	2022	VLDB
3	9,307	Unify: A System For Unstructured Data Analytics	2025	VLDB
4	8,096	Efficient Execution of User-Defined Functions in SQL Queries	2023	VLDB
5	9,917	The UDFBench Benchmark for General-purpose UDF Queries	2025	VLDB
6	5,991	Iterative Query Processing based on Unified Optimization Techniques	2019	SIGMOD
7	13,095	A Uniform Approach to Processing Temporal Queries	1992	VLDB
8	8,999	HADAD: A Lightweight Approach for Optimizing Hybrid Complex Analytics Queries	2021	SIGMOD
9	124	A Query Language and Optimization Techniques for Unstructured Data	1996	SIGMOD
10	6,253	Declarative Sub-Operators for Universal Data Processing	2023	VLDB