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