Authenticated join processing in outsourced databases

Yin Yang, Dimitris Papadias, Stavros Papadopoulos, Panos Kalnis

Research output: Chapter in Book/Report/Conference proceedingConference contribution

98 Scopus citations


Database outsourcing requires that a query server constructs a proof of result correctness, which can be verified by the client using the data owner's signature. Previous authentication techniques deal with range queries on a single relation using an authenticated data structure (ADS). On the other hand, authenticated join processing is inherently more complex than ranges since only the base relations (but not their combination) are signed by the owner. In this paper, we present three novel join algorithms depending on the ADS availability: (i) Authenticated Indexed Sort Merge Join (AISM), which utilizes a single ADS on the join attribute, (ii) Authenticated Index Merge Join (AIM) that requires an ADS (on the join attribute) for both relations, and (iii) Authenticated Sort Merge Join (ASM), which does not rely on any ADS. We experimentally demonstrate that the proposed methods outperform two benchmark algorithms, often by several orders of magnitude, on all performance metrics, and effectively shift the workload to the outsourcing service. Finally, we extend our techniques to complex queries that combine multi-way joins with selections and projections. ©2009 ACM.
Original languageEnglish (US)
Title of host publicationProceedings of the 35th SIGMOD international conference on Management of data - SIGMOD '09
PublisherAssociation for Computing Machinery (ACM)
Number of pages13
ISBN (Print)9781605585543
StatePublished - 2009


Dive into the research topics of 'Authenticated join processing in outsourced databases'. Together they form a unique fingerprint.

Cite this