loading...
 This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
22nd International Conference on Data Engineering (ICDE'06)
MiniCount: Efficient Rewriting of COUNT-Queries Using Views
Atlanta, Georgia
April 03-April 07
ISBN: 0-7695-2570-9
Vaclav Lin, University of Economics, Czech Republic
Vasilis Vassalos, Athens University of Economics and Business, Greece
Prodromos Malakasiotis, Athens University of Economics and Business, Greece
We present MiniCount, the first efficient sound and complete algorithm for finding maximally contained rewritings of conjunctive queries with count, using conjunctive views with count and conjunctive views without aggregation. An efficient and scalable solution to this problem yields significant benefits for data warehousing and decision support systems, as well as for powerful data integration systems.We first present a naive rewriting algorithm implicit in the recent theoretical results by Cohen et al. [5] and identify three independent sources of exponential complexity in the naive algorithm, including an expensive containment check. Then we present and discuss MiniCount and prove it sound and complete. We also present an experimental study that shows Mini- Count to be orders of magnitude faster than the naive algorithm, and to be able to scale to large numbers of views
Citation:
Vaclav Lin, Vasilis Vassalos, Prodromos Malakasiotis, "MiniCount: Efficient Rewriting of COUNT-Queries Using Views," icde, pp.1, 22nd International Conference on Data Engineering (ICDE'06), 2006
Usage of this product signifies your acceptance of the Terms of Use.