Title
Interactive preference-aware query optimization
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.
Year
DOI
Venue
2015
10.1109/ICDE.2015.7113414
ICDE
Field
DocType
ISSN
Query optimization,Data mining,Query language,Computer science,Sargable,Web query classification,Query by Example,Spatial query,Information privacy,Database,Query plan
Conference
1084-4627
Citations 
PageRank 
References 
0
0.34
5
Authors
6
Name
Order
Citations
PageRank
N. R. Ong100.34
S. E. Rojcewicz200.34
Nicholas L. Farnan3193.22
Adam J. Lee4214.70
Panos K. Chrysanthis51755343.06
Ting Yu6755.33