Interactive preference-aware query optimization

N. R. Ong, S. E. Rojcewicz, N. L. Farnan, A. J. Lee, P. K. Chrysanthis, Ting Yu

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

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.

Original languageEnglish
Title of host publicationProceedings - International Conference on Data Engineering
PublisherIEEE Computer Society
Pages1512-1515
Number of pages4
Volume2015-May
ISBN (Print)9781479979639
DOIs
Publication statusPublished - 26 May 2015
Event2015 31st IEEE International Conference on Data Engineering, ICDE 2015 - Seoul, Korea, Republic of
Duration: 13 Apr 201517 Apr 2015

Other

Other2015 31st IEEE International Conference on Data Engineering, ICDE 2015
CountryKorea, Republic of
CitySeoul
Period13/4/1517/4/15

Fingerprint

Graphical user interfaces

ASJC Scopus subject areas

  • Information Systems
  • Signal Processing
  • Software

Cite this

Ong, N. R., Rojcewicz, S. E., Farnan, N. L., Lee, A. J., Chrysanthis, P. K., & Yu, T. (2015). Interactive preference-aware query optimization. In Proceedings - International Conference on Data Engineering (Vol. 2015-May, pp. 1512-1515). [7113414] IEEE Computer Society. https://doi.org/10.1109/ICDE.2015.7113414

Interactive preference-aware query optimization. / Ong, N. R.; Rojcewicz, S. E.; Farnan, N. L.; Lee, A. J.; Chrysanthis, P. K.; Yu, Ting.

Proceedings - International Conference on Data Engineering. Vol. 2015-May IEEE Computer Society, 2015. p. 1512-1515 7113414.

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

Ong, NR, Rojcewicz, SE, Farnan, NL, Lee, AJ, Chrysanthis, PK & Yu, T 2015, Interactive preference-aware query optimization. in Proceedings - International Conference on Data Engineering. vol. 2015-May, 7113414, IEEE Computer Society, pp. 1512-1515, 2015 31st IEEE International Conference on Data Engineering, ICDE 2015, Seoul, Korea, Republic of, 13/4/15. https://doi.org/10.1109/ICDE.2015.7113414
Ong NR, Rojcewicz SE, Farnan NL, Lee AJ, Chrysanthis PK, Yu T. Interactive preference-aware query optimization. In Proceedings - International Conference on Data Engineering. Vol. 2015-May. IEEE Computer Society. 2015. p. 1512-1515. 7113414 https://doi.org/10.1109/ICDE.2015.7113414
Ong, N. R. ; Rojcewicz, S. E. ; Farnan, N. L. ; Lee, A. J. ; Chrysanthis, P. K. ; Yu, Ting. / Interactive preference-aware query optimization. Proceedings - International Conference on Data Engineering. Vol. 2015-May IEEE Computer Society, 2015. pp. 1512-1515
@inproceedings{58a3ff891c2b4270acf6f7e5b11e21b4,
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.",
author = "Ong, {N. R.} and Rojcewicz, {S. E.} and Farnan, {N. L.} and Lee, {A. J.} and Chrysanthis, {P. K.} and Ting Yu",
year = "2015",
month = "5",
day = "26",
doi = "10.1109/ICDE.2015.7113414",
language = "English",
isbn = "9781479979639",
volume = "2015-May",
pages = "1512--1515",
booktitle = "Proceedings - International Conference on Data Engineering",
publisher = "IEEE Computer Society",

}

TY - GEN

T1 - Interactive preference-aware query optimization

AU - Ong, N. R.

AU - Rojcewicz, S. E.

AU - Farnan, N. L.

AU - Lee, A. J.

AU - Chrysanthis, P. K.

AU - Yu, Ting

PY - 2015/5/26

Y1 - 2015/5/26

N2 - 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.

AB - 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.

UR - http://www.scopus.com/inward/record.url?scp=84940828611&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84940828611&partnerID=8YFLogxK

U2 - 10.1109/ICDE.2015.7113414

DO - 10.1109/ICDE.2015.7113414

M3 - Conference contribution

AN - SCOPUS:84940828611

SN - 9781479979639

VL - 2015-May

SP - 1512

EP - 1515

BT - Proceedings - International Conference on Data Engineering

PB - IEEE Computer Society

ER -