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.9187241e-05
Overall Rank
2,876 | 80.67%
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
231 Storm @Twitter 2014 SIGMOD 0.00023841089
606 Twitter Heron: Stream Processing at Scale 2015 SIGMOD 0.00015635133
4,098 On-the-fly Progress Detection in Iterative Stream Queries 2009 VLDB 6.8090144e-05
9,672 READY: Completeness is in the Eye of the Beholder 2017 CIDR 5.1447969e-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.00053930011
39 Efficiently Updating Materialized Views 1986 SIGMOD 0.00046602544
62 Maintaining Views Incrementally 1993 SIGMOD 0.00039045511
73 Including Group-By in Query Optimization 1994 VLDB 0.00037522101
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.0003276959
171 Monitoring Streams – A New Class of Data Management Applications 2002 VLDB 0.00027011593
200 Continuously Adaptive Continuous Queries over Streams 2002 SIGMOD 0.000254553
202 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00025244649
240 Gigascope: A Stream Database for Network Applications 2003 SIGMOD 0.00023435436
510 TelegraphCQ: Continuous Dataflow Processing 2003 SIGMOD 0.00017065714
648 Materialized Views In Oracle 1998 VLDB 0.00015151422
706 Sequence Query Processing 1994 SIGMOD 0.00014643264
708 Optimization of Large Join Queries: Combining Heuristics and Combinatorial Techniques 1989 SIGMOD 0.00014629998
2,081 Incremental Maintenance for Non-Distributive Aggregate Functions 2002 VLDB 9.0742282e-05
2,115 View Maintenance Issues for the Chronicle Data Model (Extended Abstract) 1995 PODS 9.0155433e-05
3,958 Tribeca: A Stream Database Manager For Network Traffic Analysis 1996 VLDB 6.898757e-05
4,093 Optimizing Refresh of a Set of Materialized Views 2005 VLDB 6.8115511e-05
13,059 Data Densification in a Relational Database System 2004 SIGMOD 4.9793485e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

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