Issue No. 08 - August (2010 vol. 22)
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/TKDE.2010.65
Zachary G. Ives , University of Pennsylvania, Philadelphia
Wenchao Zhou , University of Pennsylvania, Philadelphia
Nicholas E. Taylor , University of Pennsylvania, Philadelphia
Mengmeng Liu , University of Pennsylvania, Philadelphia
Boon Thau Loo , University of Pennsylvania, Philadelphia
The data management community has recently begun to consider declarative network routing and distributed acquisition: e.g., sensor networks that execute queries about contiguous regions, declarative networks that maintain shortest paths, and distributed and peer-to-peer stream systems that detect transitive relationships among data at the distributed sources. In each case, the fundamental operation is to maintain a view over dynamic network state. This view is typically distributed, recursive, and may contain aggregation, e.g., describing shortest paths or least costly paths. Surprisingly, solutions to computing such views are often domain-specific, expensive, and incomplete. We recast the problem as incremental recursive view maintenance given distributed streams of updates to tuples: new stream data becomes insert operations and tuple expirations become deletions. We develop techniques to maintain compact information about tuple derivability or data provenance. We complement this with techniques to reduce communication: aggregate selections to prune irrelevant aggregation tuples, provenance-aware operators that determine when tuples are no longer derivable and remove them from the view, and shipping operators that reduce the information being propagated while still maintaining correct answers. We validate our work in a distributed setting with sensor and network router queries, showing significant gains in communication overhead without sacrificing performance.
Distributed databases, query processing.
Zachary G. Ives, Wenchao Zhou, Nicholas E. Taylor, Mengmeng Liu, Boon Thau Loo, "Maintaining Recursive Views of Regions and Connectivity in Networks", IEEE Transactions on Knowledge & Data Engineering, vol. 22, no. , pp. 1126-1141, August 2010, doi:10.1109/TKDE.2010.65