Issue No. 04 - April (2013 vol. 25)
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/TKDE.2012.62
Guillaume Verger , INRIA and LIRMM, Montpellier
Patrick Valduriez , INRIA and LIRMM, Montpellier
Reza Akbarinia , INRIA and LIRMM, Montpellier
SUM queries are crucial for many applications that need to deal with uncertain data. In this paper, we are interested in the queries, called ALL_SUM, that return all possible sum values and their probabilities. In general, there is no efficient solution for the problem of evaluating ALL_SUM queries. But, for many practical applications, where aggregate values are small integers or real numbers with small precision, it is possible to develop efficient solutions. In this paper, based on a recursive approach, we propose a new solution for those applications. We implemented our solution and conducted an extensive experimental evaluation over synthetic and real-world data sets; the results show its effectiveness.
Decision support systems, Complexity theory, Probabilistic logic, Indexes, Aggregates, Distribution functions, query processing, Database management, systems
Guillaume Verger, Patrick Valduriez, Reza Akbarinia, "Efficient Evaluation of SUM Queries over Probabilistic Data", IEEE Transactions on Knowledge & Data Engineering, vol. 25, no. , pp. 764-775, April 2013, doi:10.1109/TKDE.2012.62