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: 7221
Venue: SIGMOD
Year: 2025
Pagerank: 4.3997447e-05
Overall Rank: 9,034 | 37.22%
DOI: 10.1145/3725291

Incoming Non-self Citations Over Time

Authors

1. Joris Nix
2. Jens Dittrich

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
9,985	Database Research needs an Abstract Relational Query Language	2026	CIDR	4.1905499e-05
10,104	Query Optimization for Database-Returning Queries	2026	SIGMOD	4.1905499e-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
71	How Good Are Query Optimizers, Really?	2016	VLDB	0.00059446482
121	Improved Query Performance with Variant Indexes	1997	SIGMOD	0.00045429472
310	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.0002815547
503	Worst-case Optimal Join Algorithms	2012	PODS	0.00021517145
623	Generalized Hypertree Decompositions: NP-Hardness and Tractable Variants	2007	PODS	0.00018976192
1,033	Bitmap Index Design and Evaluation	1998	SIGMOD	0.0001453376
1,437	AsterixDB: A Scalable, Open Source BDMS	2014	VLDB	0.00011973401
2,281	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB	9.122455e-05
2,407	Scalable Join Processing on Very Large RDF Graphs	2009	SIGMOD	8.8702781e-05
3,670	The LDBC Social Network Benchmark: Business Intelligence Workload	2023	VLDB	6.8557811e-05
4,157	Performance-Optimal Filtering: Bloom Overtakes Cuckoo at High Throughput	2019	VLDB	6.3935343e-05
5,195	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	5.6314278e-05
5,772	Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries	2024	CIDR	5.3313794e-05
6,294	Free Join: Unifying Worst-Case Optimal and Traditional Joins	2023	SIGMOD	5.1202075e-05
8,029	Tight Fine-Grained Bounds for Direct Access on Join Queries	2022	PODS	4.598451e-05
8,149	Efficiently Computing Join Orders with Heuristic Search	2023	SIGMOD	4.5715614e-05
11,151	mutable: A Modern DBMS for Research and Fast Prototyping	2023	CIDR	4.1905499e-05
12,558	Bridging the Gap between OLAP and SQL	2005	VLDB	4.1905499e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,564	Keyword Search in Databases: The Power of RDBMS	2009	SIGMOD	0.00011340407
3,101	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB	7.5611936e-05
6,863	Declarative Sub-Operators for Universal Data Processing	2023	VLDB	4.9003859e-05
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014370009
1,475	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011765071
12,543	A Nested Relational Approach to Processing SQL Subqueries	2005	SIGMOD	4.1905499e-05
6,525	Database Technology for the Masses: Sub-Operators as First-Class Entities	2021	VLDB	5.0223854e-05
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010663123
1,581	Execution Strategies for SQL Subqueries	2007	SIGMOD	0.00011262795
10,104	Query Optimization for Database-Returning Queries	2026	SIGMOD	4.1905499e-05