MetaCartSign in to MyCiteSeer

Include Citations | Advanced Search | Help

Include Citations | Advanced Search | Help

  NiagaraCQ: A Scalable Continuous Query System for Internet Databases (2000) [335 citations — 6 self]

Download:
pdf
by Jianjun Chen, David J. Dewitt, Feng Tian, Yuan Wang
In SIGMOD
http://www.cs.wisc.edu/~jchen/Sigmod00_2.pdf
Add To MetaCart

Abstract:

Continuous queries are persistent queries that allow users to receive new results when they become available. While continuous query systems can transform a passive web into an active environment, they need to be able to support millions of queries due to the scale of the Internet. No existing systems have achieved this level of scalability. NiagaraCQ addresses this problem by grouping continuous queries based on the observation that many web queries share similar structures. Grouped queries can share the common computation, tend to fit in memory and can reduce the I/O cost significantly. Furthermore, grouping on selection predicates can eliminate a large number of unnecessary query invocations. Our grouping technique is distinguished from previous group optimization approaches in the following ways. First, we use an incremental group optimization strategy with dynamic re-grouping. New queries are added to existing query groups, without having to regroup already installed queries. Second, we use a query-split scheme that requires minimal changes to a general-purpose query engine. Third, NiagaraCQ groups both change-based and timer-based queries in a uniform way. To insure that NiagaraCQ is scalable, we have also employed other techniques including incremental evaluation of continuous queries, use of both pull and push models for detecting heterogeneous data source changes, and memory caching. This paper presents the design of NiagaraCQ system and gives some experimental results on the system’s performance and scalability. 1.

Citations

133 Continuous Queries over Append-Only Databases – Terry, Goldberg, et al. - 1992
124 Continual Queries for Internet Scale Event-Driven Information Delivery – Liu, Pu, et al. - 1999
94 The Architecture of an Active Database Management System – McCarthy, Dayal - 1989
88 Multiple query optimization – Sellis
61 Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS – Schreier, Pirahesh, et al. - 1991
39 Continual queries for Internet-scale event-driven information delivery – Liu, Pu, et al. - 1999
37 Scalable trigger processing – Hanson, Carnes, et al. - 1999
28 Anatomy of a modular multiple query optimizer – Rosenthal, Chakravarthy - 1988
27 Simultaneous optimization and evaluation of multiple dimensional queries – Zhao, Deshpande, et al. - 1998
23 Multiple query processing in deductive databases using query graphs – Chakravarthy, Minker - 1986
18 Selection Predicate Indexing for Active Databases using Interval Skip Lists – Hanson, Johnson - 1996
3 an architecture for transforming a passive dbms into an active dbms – Alert - 1991
1 XML-QL: A Query Langaage for XML. http://www.w3.org/TR/NOTE-xml-ql – Deutsch, Fernandez, et al.
1 Multiple QueryProcessing in Deductive Databases using Query Graphs. VLDB Conference 1986: 384-391. [DFF+98 – Chakravarthy, Minker - 1999
1 Selection PredicateIndexing for Active Databases Using Interval Skip List – Hanson, Johnson - 1994
1 Anatomy of aModular Multiple Query Optimizer. VLDB 1988: 230-239. [Sel86] T. Sellis. Multiple query optimization. ACMTransactions on Database Systems – Rosenthal, Chakravarthy - 1986