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: 7220
Venue: SIGMOD
Year: 2025
Pagerank: 4.4039656e-05
Overall Rank: 9,031 | 37.18%
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,986	Database Research needs an Abstract Relational Query Language	2026	CIDR	4.1945683e-05
10,104	Query Optimization for Database-Returning Queries	2026	SIGMOD	4.1945683e-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.00059038975
121	Improved Query Performance with Variant Indexes	1997	SIGMOD	0.00045447517
310	The Vertica Analytic Database: C-Store 7 Years Later	2012	VLDB	0.00028132402
502	Worst-case Optimal Join Algorithms	2012	PODS	0.00021526612
626	Generalized Hypertree Decompositions: NP-Hardness and Tractable Variants	2007	PODS	0.00018973823
1,035	Bitmap Index Design and Evaluation	1998	SIGMOD	0.00014532778
1,438	AsterixDB: A Scalable, Open Source BDMS	2014	VLDB	0.00011973592
2,275	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB	9.1262202e-05
2,410	Scalable Join Processing on Very Large RDF Graphs	2009	SIGMOD	8.8773796e-05
3,668	The LDBC Social Network Benchmark: Business Intelligence Workload	2023	VLDB	6.8591612e-05
4,158	Performance-Optimal Filtering: Bloom Overtakes Cuckoo at High Throughput	2019	VLDB	6.3994318e-05
5,194	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	5.6368209e-05
5,765	Predicate Transfer: Efficient Pre-Filtering on Multi-Join Queries	2024	CIDR	5.336442e-05
6,305	Free Join: Unifying Worst-Case Optimal and Traditional Joins	2023	SIGMOD	5.1209718e-05
8,028	Tight Fine-Grained Bounds for Direct Access on Join Queries	2022	PODS	4.6028646e-05
8,164	Efficiently Computing Join Orders with Heuristic Search	2023	SIGMOD	4.5718104e-05
11,148	mutable: A Modern DBMS for Research and Fast Prototyping	2023	CIDR	4.1945683e-05
12,549	Bridging the Gap between OLAP and SQL	2005	VLDB	4.1945683e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
1,564	Keyword Search in Databases: The Power of RDBMS	2009	SIGMOD	0.00011350495
3,096	On Efficiently Implementing SchemaSQL on a SQL Database System	1999	VLDB	7.5678495e-05
6,863	Declarative Sub-Operators for Universal Data Processing	2023	VLDB	4.905092e-05
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014382575
1,476	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011779092
12,534	A Nested Relational Approach to Processing SQL Subqueries	2005	SIGMOD	4.1945683e-05
6,525	Database Technology for the Masses: Sub-Operators as First-Class Entities	2021	VLDB	5.027205e-05
1,754	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	0.00010670609
1,582	Execution Strategies for SQL Subqueries	2007	SIGMOD	0.00011265079
10,104	Query Optimization for Database-Returning Queries	2026	SIGMOD	4.1945683e-05