Extending SQL to Return a Subdatabase

Summary: Extends SQL with a RESULTDB clause to return a subdatabase—exposing all query-participating tables in their normalized forms rather than a single denormalized result. Shows applicability to hierarchical data, materialized views, and distributed DBs, with rewrite methods and an open-source algorithm; experiments reveal reduced transfer sizes and low overhead. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 7282
Venue: SIGMOD
Year: 2025
Pagerank: 5.3058708e-05
Overall Rank: 9,183 | 37.00%
DOI: 10.1145/3725291

Incoming Non-self Citations Over Time

Authors

1. Joris Nix (Saarland University)
2. Jens Dittrich (Saarland University)

BibTeX Citation

@inproceedings{nix_sigmod25,
        title = {{Extending SQL to Return a Subdatabase}},
        author = {Nix, Joris and Dittrich, Jens},
        series = {{SIGMOD} '25},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3725291},
        url = {https://dl.acm.org/doi/10.1145/3725291},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,133	Database Research needs an Abstract Relational Query Language	2026	CIDR	5.093636e-05
10,394	Query Optimization for Database-Returning Queries	2026	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 18 of 18 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
18	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059284255
104	Improved Query Performance with Variant Indexes	1997	SIGMOD	0.00033932213
186	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.00026182534
411	Worst-case Optimal Join Algorithms	2012	PODS	0.00018902089
673	Generalized Hypertree Decompositions: NP-Hardness and Tractable Variants	2007	PODS	0.00015095061
794	Bitmap Index Design and Evaluation	1998	SIGMOD	0.00013969303
1,015	AsterixDB: A Scalable, Open Source BDMS	2014	VLDB	0.00012647763
1,740	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB	9.875587e-05
1,979	Scalable Join Processing on Very Large RDF Graphs	2009	SIGMOD	9.3621296e-05
3,018	The LDBC Social Network Benchmark: Business Intelligence Workload	2023	VLDB	7.8473755e-05
3,510	Performance-Optimal Filtering: Bloom Overtakes Cuckoo at High Throughput	2019	VLDB	7.3561488e-05
4,553	Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries	2024	CIDR	6.6346951e-05
4,849	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	6.4803828e-05
5,781	Free Join: Unifying Worst-Case Optimal and Traditional Joins	2023	SIGMOD	6.0910397e-05
7,882	Efficiently Computing Join Orders with Heuristic Search	2023	SIGMOD	5.5237338e-05
8,047	Tight Fine-Grained Bounds for Direct Access on Join Queries	2022	PODS	5.500514e-05
11,354	mutable: A Modern DBMS for Research and Fast Prototyping	2023	CIDR	5.093636e-05
12,742	Bridging the Gap between OLAP and SQL	2005	VLDB	5.093636e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,555	Keyword Search in Databases: The Power of RDBMS	2009	SIGMOD
2	3,889	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB
3	6,253	Declarative Sub-Operators for Universal Data Processing	2023	VLDB
4	1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD
5	1,154	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD
6	12,727	A Nested Relational Approach to Processing SQL Subqueries	2005	SIGMOD
7	6,263	Database Technology for the Masses: Sub-Operators as First-Class Entities	2021	VLDB
8	1,860	Querying Multiple Features of Groups in Relational Databases	1996	VLDB
9	1,362	Execution Strategies for SQL Subqueries	2007	SIGMOD
10	10,394	Query Optimization for Database-Returning Queries	2026	SIGMOD