Joining Interval Data in Relational Databases

Summary: Introduces Relational Interval Tree–based join algorithms for interval-valued attributes in relational databases. Implemented on top of any RDBMS, the approach yields substantial speedups over standard interval-join methods, with Oracle9i experiments demonstrating significant gains. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3621
Venue: SIGMOD
Year: 2004
Pagerank: 6.7925685e-05
Overall Rank: 4,268 | 70.72%
DOI: 10.1145/1007568.1007645

Incoming Non-self Citations Over Time

Authors

1. Jost Enderle (Rheinisch-Westfaelische Technische Hochschule Aachen)
2. Matthias Hampel (Ludwig Maximilian University of Munich)
3. Thomas Seidl (Rheinisch-Westfaelische Technische Hochschule Aachen)

BibTeX Citation

@inproceedings{enderle_sigmod04,
        title = {{Joining Interval Data in Relational Databases}},
        author = {Enderle, Jost and Hampel, Matthias and Seidl, Thomas},
        series = {{SIGMOD} '04},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1007568.1007645},
        url = {https://dl.acm.org/doi/10.1145/1007568.1007645},
        year = {2004}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,295	Lightning Fast and Space Efficient Inequality Joins	2015	VLDB	7.5477715e-05
4,482	Overlap Interval Partition Join	2014	SIGMOD	6.6753072e-05
5,066	Conjunctive Queries with Inequalities Under Updates	2018	VLDB	6.3771079e-05
5,593	Beyond Equi-joins: Ranking, Enumeration and Factorization	2021	VLDB	6.1552328e-05
6,106	A Forward Scan based Plane Sweep Algorithm for Parallel Interval Joins	2017	VLDB	5.973703e-05
7,451	The Complexity of Boolean Conjunctive Queries with Intersection Joins	2022	PODS	5.6135032e-05
8,235	Computing Complex Temporal Join Queries Efficiently	2022	SIGMOD	5.4608734e-05
8,894	Distributed Evaluation of Top-k Temporal Joins	2016	SIGMOD	5.3504579e-05
12,757	Efficiently Processing Queries on Interval-and-Value Tuples in Relational Databases	2005	VLDB	5.093636e-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
4	The R*-tree: An Efficient and Robust Access Method for Points and Rectangles	1990	SIGMOD	0.001157935
145	Efficient Processing of Spatial Joins Using R-trees	1993	SIGMOD	0.00029548428
163	On Supporting Containment Queries in Relational Database Management Systems	2001	SIGMOD	0.00027839792
728	Partition Based Spatial-Merge Join	1996	SIGMOD	0.00014542772
994	Spatial Hash-Joins	1996	SIGMOD	0.00012764684
1,139	Managing Intervals Efficiently in Object-Relational Databases	2000	VLDB	0.0001202217
1,202	Fractals for Secondary Key Retrieval	1989	PODS	0.00011672157
1,880	Scalable Sweeping-Based Spatial Join	1998	VLDB	9.5562066e-05
2,115	The Time Index: An Access Structure for Temporal Data	1990	VLDB	9.1449719e-05
2,548	Spatial Joins Using R-trees: Breadth-First Traversal with Global Optimizations	1997	VLDB	8.432498e-05
5,173	High-Performance Extensible Indexing	1999	VLDB	6.3341007e-05
6,172	On Spatially Partitioned Temporal Join	1994	VLDB	5.9512937e-05
6,605	High Level Indexing of User-Defined Types	1999	VLDB	5.8240191e-05
7,595	Query Processing Techniques for Multiversion Access Methods	1996	VLDB	5.5888857e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,740	Adopting Worst-Case Optimal Joins in Relational Database Systems	2020	VLDB
2	1,525	Incremental Distance Join Algorithms for Spatial Databases	1998	SIGMOD
3	1,592	Efficient Processing of Joins on Set-valued Attributes	2003	SIGMOD
4	145	Efficient Processing of Spatial Joins Using R-trees	1993	SIGMOD
5	8,235	Computing Complex Temporal Join Queries Efficiently	2022	SIGMOD
6	1,479	Computing Joins Of Relations	1975	SIGMOD
7	3,977	Event-Join Optimization in Temporal Relational Databases	1989	VLDB
8	6,172	On Spatially Partitioned Temporal Join	1994	VLDB
9	1,139	Managing Intervals Efficiently in Object-Relational Databases	2000	VLDB
10	12,757	Efficiently Processing Queries on Interval-and-Value Tuples in Relational Databases	2005	VLDB