2007 · 85 citations · 18 references
ComputingComputer ScienceComputational GeometryData StructuresDatabasesData Structure AlgorithmsDatabase ManagementGeometric Data StructuresQuery OptimizationQuery ProcessingAd Hoc QueryingArrangement Data StructuresGeometric Representation ApproximationIncremental Database UpdatesQuery EvaluationStream Query ProcessingTop-k Query ProcessingTop-k Ranking
A top-k query retrieves the k highest scoring tuples from a data set with respect to a scoring function defined on the attributes of a tuple. The efficient evaluation of top-k queries has been an active research topic and many different instantiations of the problem, in a variety of settings, have been studied. However, techniques developed for conventional, centralized or distributed databases are not directly applicable to highly dynamic environments and on-line applications, like data streams. Recently, techniques supporting top-k queries on data streams have been introduced. Such techniques are restrictive however, as they can only efficiently report top-k answers with respect to a pre-specified (as opposed to ad-hoc) set of queries. In this paper we introduce a novel geometric representation for the top-k query problem that allows us to raise this restriction. Utilizing notions of geometric arrangements, we design and analyze algorithms for incrementally maintaining a data set organized in an arrangement representation under streaming updates. We introduce query evaluation strategies that operate on top of an arrangement data structure that are able to guarantee efficient evaluation for ad-hoc queries. The performance of our core technique is augmented by incorporating tuple pruning strategies, minimizing the number of tuples that need to be stored and manipulated. This results in a main memory indexing technique supporting both efficient incremental updates and the evaluation of ad-hoc top-k queries. A thorough experimental study evaluates the efficiency of the proposed technique.
18
Models and issues in data stream systems
Brian Babcock, Shivnath Babu, Mayur Datar et al. · 2002 · 2.5K citations
S. Borzsony, Donald Kossmann, Konrad Stocker · 2002 · 2.2K citations
Optimal aggregation algorithms for middleware
Ronald Fagin, Amnon Lotem, Moni Naor · Journal of Computer and System Sciences · 2003 · 941 citations
Optimal Histograms with Quality Guarantees
H. V. Jagadish, Nick Koudas, S. Muthukrishnan et al. · 1998 · 382 citations