DBScholar

Back to papers

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
h77db67bb2d78200f
Venue
VLDB
Year
2007
Pagerank
7.8890479e-05
Overall Rank
2,889 | 80.64%
DOI
-

Incoming Non-self Citations Over Time

Authors

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
233 Storm @Twitter 2014 SIGMOD 0.00023754096
607 Twitter Heron: Stream Processing at Scale 2015 SIGMOD 0.00015577054
4,120 On-the-fly Progress Detection in Iterative Stream Queries 2009 VLDB 6.783316e-05
9,708 READY: Completeness is in the Eye of the Beholder 2017 CIDR 5.1253619e-05
Previous Page 1 / 1 Next

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.00053734242
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00046445099
62 Maintaining Views Incrementally 1993 SIGMOD 0.00038944207
73 Including Group-By in Query Optimization 1994 VLDB 0.00037420958
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00032702871
173 Monitoring Streams – A New Class of Data Management Applications 2002 VLDB 0.0002691472
201 Continuously Adaptive Continuous Queries over Streams 2002 SIGMOD 0.00025363666
204 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.0002516936
240 Gigascope: A Stream Database for Network Applications 2003 SIGMOD 0.00023371986
514 TelegraphCQ: Continuous Dataflow Processing 2003 SIGMOD 0.00017005839
654 Materialized Views In Oracle 1998 VLDB 0.00015096471
712 Sequence Query Processing 1994 SIGMOD 0.00014588907
714 Optimization of Large Join Queries: Combining Heuristics and Combinatorial Techniques 1989 SIGMOD 0.00014578551
2,095 Incremental Maintenance for Non-Distributive Aggregate Functions 2002 VLDB 9.0408055e-05
2,133 View Maintenance Issues for the Chronicle Data Model (Extended Abstract) 1995 PODS 8.9830012e-05
3,975 Tribeca: A Stream Database Manager For Network Traffic Analysis 1996 VLDB 6.8730259e-05
4,114 Optimizing Refresh of a Set of Materialized Views 2005 VLDB 6.7859696e-05
13,106 Data Densification in a Relational Database System 2004 SIGMOD 4.9605343e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 2,122 Enhanced Subquery Optimizations in Oracle 2009 VLDB
2 10,248 Continuous Query Processing in Data Streams Using Duality of Data and Queries 2006 SIGMOD
3 5,994 Supporting Time-Constrained SQL Queries in Oracle 2007 VLDB
4 14,134 Scheduling Continuous Queries in Data Stream Management Systems 2008 VLDB
5 7,880 Changing Flights in Mid-air: A Model for Safely Modifying Continuous Queries 2011 SIGMOD
6 2,790 Scheduling for shared window joins over data streams 2003 VLDB
7 4,700 Continuous Analytics: Rethinking Query Processing in a Network-Effect World 2009 CIDR
8 10,233 Evaluating Continuous Queries with Inconsistency Annotations 2025 VLDB
9 201 Continuously Adaptive Continuous Queries over Streams 2002 SIGMOD
10 7,485 Update-Pattern-Aware Modeling and Processing of Continuous Queries 2005 SIGMOD