Estimating Range Queries using Aggregate Data with Integrity Constraints: a Probabilistic Approach
Francesco Buccafurri, Filippo Furfaro, Domenico Sacca'
Abstract
The problem of recovering (count and sum) range queries over multidimensional data only on the basis of aggregate information on such data is addressed. This problem can be formalized as follows. Suppose that a transformation T producing a summary from a multidimensional data set is used. Now, given a data set D, a summary S=T(D) and a range query r on D, the problem consists of studying r by modelling it as a random variable defined over the sample space of all the data sets D' such that T(D) = S. The study of such a random variable, done by the definition of its probability distribution and the computation of its mean value and variance, represents a well-founded, theoretical probabilistic approach for estimating the query only on the basis of the available information (that is the summary S) without assumptions on original data.
Create a lesson
Related papers
Navigating Runtime Dynamism in Semantic Query Serving
Hengrui Zhang, Xupeng Miao
SQLoom: Set-Contrastive Learning of Syntactic, Semantic, and Logical Dependencies for Text-to-SQL
Hao Fu, Degang Sun, Wan Wei et al.
Stop Handcrafting Your Engine! GenDB-V: Towards AI-Generated and Formally Verified Database Systems
Jiale Lao, Immanuel Trummer
Recast: Refinement-Centered Approximate Nearest Neighbor Search Optimized for Storage
Zehai Yang, Fengyi Tao, Wenzhuo Dong et al.
USDB: Scaling Storage for Next-Generation Recommender Systems at ByteDance
Xiaoran Zhu, Jieming Cai, Weiping Yu et al.
Mixed-Type Relational Database Synthesis with Graph-Prompted Language Model
Yuxiang Sun, Mengshi Chen, Jianwei Wang et al.