Publication Type
Journal Article
Version
acceptedVersion
Publication Date
1-2009
Abstract
In the outsourced database model, a data owner publishes her database through a third-party server; i.e., the server hosts the data and answers user queries on behalf of the owner. Since the server may not be trusted, or may be compromised, users need a means to verify that answers received are both authentic and complete, i.e., that the returned data have not been tampered with, and that no qualifying results have been omitted. We propose a result verification approach for one-dimensional queries, called Partially Materialized Digest scheme (PMD), that applies to both static and dynamic databases. PMD uses separate indexes for the data and for their associated verification information, and only partially materializes the latter. In contrast with previous work, PMD avoids unnecessary costs when processing queries that do not request verification, achieving the performance of an ordinary index (e.g., a B+-tree). On the other hand, when an authenticity and completeness proof is required, PMD outperforms the existing state-of-the-art technique by a wide margin, as we demonstrate analytically and experimentally. Furthermore, we design two verification methods for spatial queries. The first, termed Merkle R-tree (MR-tree), extends the conventional approach of embedding authentication information into the data index (i.e., an R-tree). The second, called Partially Materialized KD-tree (PMKD), follows the PMD paradigm using separate data and verification indexes. An empirical evaluation with real data shows that the PMD methodology is superior to the traditional approach for spatial queries too.
Keywords
Query result verification, Authentication in outsourced databases
Discipline
Databases and Information Systems | Numerical Analysis and Scientific Computing
Publication
VLDB Journal
Volume
18
Issue
1
First Page
363
Last Page
381
ISSN
1066-8888
Identifier
10.1007/s00778-008-0108-z
Publisher
Springer Verlag
Citation
MOURATIDIS, Kyriakos; SACHARIDIS, Dimitris; and PANG, Hwee Hwa.
Partially Materialized Digest Scheme: An Efficient Verification Method for Outsourced Databases. (2009). VLDB Journal. 18, (1), 363-381.
Available at: https://ink.library.smu.edu.sg/sis_research/745
Copyright Owner and License
Authors
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.
Additional URL
http://doi.org/10.1007/s00778-008-0108-z
Included in
Databases and Information Systems Commons, Numerical Analysis and Scientific Computing Commons