Continuous Queries in Oracle

Summary: Oracle CQ fuses streaming/CEP with an RDBMS, via a query-difference engine that tracks real-time changes and writes results to history. Mixed DML, joins/aggregates, and semantic-constraint optimizations with batched re-computation to cut latency. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 9718
Venue: VLDB
Year: 2007
Pagerank: 8.0685625e-05
Overall Rank: 2,838 | 80.54%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Andrew Witkowski (Oracle)
2. Srikanth Bellamkonda (Oracle)
3. Hua-Gang Li (Oracle)
4. Vince Liang (Oracle)
5. Lei Sheng (Oracle)
6. Wayne Smith (Oracle)
7. Sankar Subramanian (Oracle)
8. James Terry (Oracle)
9. Tsae-Feng Yu (Oracle)

BibTeX Citation

@article{witkowski_vldb07,
        title = {{Continuous Queries in Oracle}},
        author = {Witkowski, Andrew and Bellamkonda, Srikanth and Li, Hua-Gang and Liang, Vince and Sheng, Lei and Smith, Wayne and Subramanian, Sankar and Terry, James and Yu, Tsae-Feng},
        journal = {PVLDB},
        series = {{VLDB} '07},
        year = {2007}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
220	Storm @Twitter	2014	SIGMOD	0.00024244587
612	Twitter Heron: Stream Processing at Scale	2015	SIGMOD	0.0001573018
4,189	On-the-fly Progress Detection in Iterative Stream Queries	2009	VLDB	6.8435848e-05
9,492	READY: Completeness is in the Eye of the Beholder	2017	CIDR	5.2625108e-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
25	NiagaraCQ: A Scalable Continuous Query System for Internet Databases	2000	SIGMOD	0.00054667018
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00047309646
61	Maintaining Views Incrementally	1993	SIGMOD	0.00039026867
71	Including Group-By in Query Optimization	1994	VLDB	0.00038021159
110	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.0003309592
167	Monitoring Streams – A New Class of Data Management Applications	2002	VLDB	0.0002757283
193	Continuously Adaptive Continuous Queries over Streams	2002	SIGMOD	0.00025964286
198	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00025618616
230	Gigascope: A Stream Database for Network Applications	2003	SIGMOD	0.00023891474
505	TelegraphCQ: Continuous Dataflow Processing	2003	SIGMOD	0.00017285498
643	Materialized Views In Oracle	1998	VLDB	0.00015372449
687	Sequence Query Processing	1994	SIGMOD	0.00014948592
698	Optimization of Large Join Queries: Combining Heuristics and Combinatorial Techniques	1989	SIGMOD	0.00014879675
2,064	Incremental Maintenance for Non-Distributive Aggregate Functions	2002	VLDB	9.2383582e-05
2,080	View Maintenance Issues for the Chronicle Data Model (Extended Abstract)	1995	PODS	9.2052704e-05
3,879	Tribeca: A Stream Database Manager For Network Traffic Analysis	1996	VLDB	7.0504052e-05
4,019	Optimizing Refresh of a Set of Materialized Views	2005	VLDB	6.9521212e-05
12,769	Data Densification in a Relational Database System	2004	SIGMOD	5.093636e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	2,095	Enhanced Subquery Optimizations in Oracle	2009	VLDB
2	10,017	Continuous Query Processing in Data Streams Using Duality of Data and Queries	2006	SIGMOD
3	5,863	Supporting Time-Constrained SQL Queries in Oracle	2007	VLDB
4	13,778	Scheduling Continuous Queries in Data Stream Management Systems	2008	VLDB
5	8,065	Changing Flights in Mid-air: A Model for Safely Modifying Continuous Queries	2011	SIGMOD
6	2,735	Scheduling for shared window joins over data streams	2003	VLDB
7	4,583	Continuous Analytics: Rethinking Query Processing in a Network-Effect World	2009	CIDR
8	10,818	Evaluating Continuous Queries with Inconsistency Annotations	2025	VLDB
9	193	Continuously Adaptive Continuous Queries over Streams	2002	SIGMOD
10	7,321	Update-Pattern-Aware Modeling and Processing of Continuous Queries	2005	SIGMOD