Authenticated join processing in outsourced databases

Handle URI:
http://hdl.handle.net/10754/564235
Title:
Authenticated join processing in outsourced databases
Authors:
Yang, Yin; Papadias, Dimitris; Papadopoulos, Stavros; Kalnis, Panos ( 0000-0002-5060-1360 )
Abstract:
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.
KAUST Department:
Computer, Electrical and Mathematical Sciences and Engineering (CEMSE) Division; Computer Science Program
Publisher:
Association for Computing Machinery (ACM)
Journal:
Proceedings of the 35th SIGMOD international conference on Management of data - SIGMOD '09
Conference/Event name:
International Conference on Management of Data and 28th Symposium on Principles of Database Systems, SIGMOD-PODS'09
Issue Date:
2009
DOI:
10.1145/1559845.1559849
Type:
Conference Paper
ISBN:
9781605585543
Appears in Collections:
Conference Papers; Computer Science Program; Computer, Electrical and Mathematical Sciences and Engineering (CEMSE) Division

Full metadata record

DC FieldValue Language
dc.contributor.authorYang, Yinen
dc.contributor.authorPapadias, Dimitrisen
dc.contributor.authorPapadopoulos, Stavrosen
dc.contributor.authorKalnis, Panosen
dc.date.accessioned2015-08-04T06:20:06Zen
dc.date.available2015-08-04T06:20:06Zen
dc.date.issued2009en
dc.identifier.isbn9781605585543en
dc.identifier.doi10.1145/1559845.1559849en
dc.identifier.urihttp://hdl.handle.net/10754/564235en
dc.description.abstractDatabase 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.en
dc.publisherAssociation for Computing Machinery (ACM)en
dc.subjectDatabase outsourcingen
dc.subjectJoin algorithmsen
dc.subjectQuery authenticationen
dc.titleAuthenticated join processing in outsourced databasesen
dc.typeConference Paperen
dc.contributor.departmentComputer, Electrical and Mathematical Sciences and Engineering (CEMSE) Divisionen
dc.contributor.departmentComputer Science Programen
dc.identifier.journalProceedings of the 35th SIGMOD international conference on Management of data - SIGMOD '09en
dc.conference.date29 June 2009 through 2 July 2009en
dc.conference.nameInternational Conference on Management of Data and 28th Symposium on Principles of Database Systems, SIGMOD-PODS'09en
dc.conference.locationProvidence, RIen
dc.contributor.institutionDepartment of Computer Science and Engineering, Hong Kong University of Science and Technology, Clear Water Bay, Hong Kongen
kaust.authorKalnis, Panosen
All Items in KAUST are protected by copyright, with all rights reserved, unless otherwise indicated.