Welcome to the ADMT Publication Server

Interactive Preference-aware Query Optimization

DocUID: 2015-009 Full Text: PDF

Author: Nathan R. Ong, Stephen E. Rojcewicz, Nicholas L. Farnan, Adam J. Lee, Panos K. Chrysanthis, Ting Yu

Abstract: PASQL is an extension to SQL that allows users of a distributed database to specify privacy constraints on an SQL query evaluation plan. However, privacy constraints can be difficult for users to specify, and worse yet, all possible situations that could lead to a privacy violation may not be known to the user a priori. To address these challenges, we propose a GUI-based interactive process for detecting such violations and generating appropriate constraints. In this work, we demonstrate two approaches to implementing such a GUI that provide different ways of analyzing and interactively optimizing a PASQL query plan.

Keywords: Graphical user interfaces, Privacy, Servers, Query processing, Visualization, Image color analysis, Data privacy

Published In: IEEE 31st International Conference on Data Engineering

ISBN: 978-1-4799-7964-6

Pages: 1512-1515

Place Published: Seoul, South Korea

Year Published: 2015

DOI: 10.1109/ICDE.2015.7113414

Project: PAQO Subject Area: Data Privacy, Query Processing

Publication Type: Demonstration

Sponsor: NSF CCF-0916015, NSF OIA-1028162, Others, NSF CNS-0914946, NSF CNS-0747247, NSF CNS-0964295, NSF CNS-1253204

Citation:Text Latex BibTex XML Nathan R. Ong, Stephen E. Rojcewicz, Nicholas L. Farnan, Adam J. Lee, Panos K. Chrysanthis, and Ting Yu. Interactive Preference-aware Query Optimization. IEEE 31st International Conference on Data Engineering. 1512-1515. 2015. Seoul, South Korea. DOI: 10.1109/ICDE.2015.7113414.