Verifying the Correctness of Analytic Query Results

by   Masoud Nosrati, et al.

Data outsourcing is a cost-effective solution for data owners to tackle issues such as large volumes of data, huge number of users, and intensive computation needed for data analysis. They can simply upload their databases to a cloud and let it perform all management works, including query processing. One problem with this service model is how query issuers can verify the query results they receive are indeed correct. This concern is legitimate because, as a third party, clouds may not be fully trustworthy, and as a large data center, clouds are ideal targets for hackers. There has been significant work on query result verification, but most consider only simple queries where query results can be attained by checking the raw data against the query conditions directly. In this paper, we consider the problem of enabling users to verify the correctness of the results of analytic queries. Unlike simple queries, analytic queries involve ranking functions to score a database, which makes it difficult to build data structures for verification purposes. We propose two approaches, namely one-signature and multi-signature, and show that they work well on three representative types of analytic queries, including top-k, range, and KNN queries, through both analysis and experiments.


page 1

page 2

page 3

page 4


QR2: A Third-party Query Reranking Service Over Web Databases

The ranked retrieval model has rapidly become the de-facto way for searc...

Controlling the Correctness of Aggregation Operations During Sessions of Interactive Analytic Queries

We present a comprehensive set of conditions and rules to control the co...

Closest-Pair Queries and Minimum-Weight Queries are Equivalent for Squares

Let S be a set of n weighted points in the plane and let R be a query ra...

vChain: Enabling Verifiable Boolean Range Queries over Blockchain Databases

Blockchains have recently been under the spotlight due to the boom of cr...

Support Aggregate Analytic Window Function over Large Data by Spilling

Analytic function, also called window function, is to query the aggregat...

Progressive Evaluation of Queries over Untagged Data

Modern information systems often collect raw data in the form of text, i...

Aggregate Analytic Window Query over Spatial Data

Analytic window query is a commonly used query in the relational databas...

Please sign up or login with your details

Forgot password? Click here to reset