PAQO

A preferenceaware query optimizer for postgreSQL

Nicholas L. Farnan, Adam J. Lee, Panos K. Chrysanthis, Ting Yu

Research output: Chapter in Book/Report/Conference proceedingChapter

3 Citations (Scopus)

Abstract

Although the declarative nature of SQL provides great util-ity to database users, its use in distributed database manage-ment systems can leave users unaware of which servers in the system are evaluating portions of their queries. By allowing users to merely say what data they are interested in access-ing without providing guidance regarding how to retrieve it, query optimizers can generate plans with unintended conse-quences to the user (e.g., violating user privacy by revealing sensitive portions of a user's query to untrusted servers, or impacting result freshness by pulling data from stale data stores). To address these types of issues, we have created a framework that empowers users with the ability to specify constraints on the kinds of plans that can be produced by the optimizer to evaluate their queries. Such constraints are specified through an extended version of SQL that we have developed which we call PASQL. With this proposal, we aim to demonstrate PAQO, a version of PostgreSQL's query op-timizer that we have modified to produce plans that respect constraints specified through PASQL while optimizing user-specified SQL queries in terms of performance.

Original languageEnglish
Title of host publicationProceedings of the VLDB Endowment
Pages1334-1337
Number of pages4
Volume6
Edition12
Publication statusPublished - Aug 2013

Fingerprint

Servers

ASJC Scopus subject areas

  • Computer Science (miscellaneous)
  • Computer Science(all)

Cite this

Farnan, N. L., Lee, A. J., Chrysanthis, P. K., & Yu, T. (2013). PAQO: A preferenceaware query optimizer for postgreSQL. In Proceedings of the VLDB Endowment (12 ed., Vol. 6, pp. 1334-1337)

PAQO : A preferenceaware query optimizer for postgreSQL. / Farnan, Nicholas L.; Lee, Adam J.; Chrysanthis, Panos K.; Yu, Ting.

Proceedings of the VLDB Endowment. Vol. 6 12. ed. 2013. p. 1334-1337.

Research output: Chapter in Book/Report/Conference proceedingChapter

Farnan, NL, Lee, AJ, Chrysanthis, PK & Yu, T 2013, PAQO: A preferenceaware query optimizer for postgreSQL. in Proceedings of the VLDB Endowment. 12 edn, vol. 6, pp. 1334-1337.
Farnan NL, Lee AJ, Chrysanthis PK, Yu T. PAQO: A preferenceaware query optimizer for postgreSQL. In Proceedings of the VLDB Endowment. 12 ed. Vol. 6. 2013. p. 1334-1337
Farnan, Nicholas L. ; Lee, Adam J. ; Chrysanthis, Panos K. ; Yu, Ting. / PAQO : A preferenceaware query optimizer for postgreSQL. Proceedings of the VLDB Endowment. Vol. 6 12. ed. 2013. pp. 1334-1337
@inbook{acd1747971fd43dcadbac866e295cce8,
title = "PAQO: A preferenceaware query optimizer for postgreSQL",
abstract = "Although the declarative nature of SQL provides great util-ity to database users, its use in distributed database manage-ment systems can leave users unaware of which servers in the system are evaluating portions of their queries. By allowing users to merely say what data they are interested in access-ing without providing guidance regarding how to retrieve it, query optimizers can generate plans with unintended conse-quences to the user (e.g., violating user privacy by revealing sensitive portions of a user's query to untrusted servers, or impacting result freshness by pulling data from stale data stores). To address these types of issues, we have created a framework that empowers users with the ability to specify constraints on the kinds of plans that can be produced by the optimizer to evaluate their queries. Such constraints are specified through an extended version of SQL that we have developed which we call PASQL. With this proposal, we aim to demonstrate PAQO, a version of PostgreSQL's query op-timizer that we have modified to produce plans that respect constraints specified through PASQL while optimizing user-specified SQL queries in terms of performance.",
author = "Farnan, {Nicholas L.} and Lee, {Adam J.} and Chrysanthis, {Panos K.} and Ting Yu",
year = "2013",
month = "8",
language = "English",
volume = "6",
pages = "1334--1337",
booktitle = "Proceedings of the VLDB Endowment",
edition = "12",

}

TY - CHAP

T1 - PAQO

T2 - A preferenceaware query optimizer for postgreSQL

AU - Farnan, Nicholas L.

AU - Lee, Adam J.

AU - Chrysanthis, Panos K.

AU - Yu, Ting

PY - 2013/8

Y1 - 2013/8

N2 - Although the declarative nature of SQL provides great util-ity to database users, its use in distributed database manage-ment systems can leave users unaware of which servers in the system are evaluating portions of their queries. By allowing users to merely say what data they are interested in access-ing without providing guidance regarding how to retrieve it, query optimizers can generate plans with unintended conse-quences to the user (e.g., violating user privacy by revealing sensitive portions of a user's query to untrusted servers, or impacting result freshness by pulling data from stale data stores). To address these types of issues, we have created a framework that empowers users with the ability to specify constraints on the kinds of plans that can be produced by the optimizer to evaluate their queries. Such constraints are specified through an extended version of SQL that we have developed which we call PASQL. With this proposal, we aim to demonstrate PAQO, a version of PostgreSQL's query op-timizer that we have modified to produce plans that respect constraints specified through PASQL while optimizing user-specified SQL queries in terms of performance.

AB - Although the declarative nature of SQL provides great util-ity to database users, its use in distributed database manage-ment systems can leave users unaware of which servers in the system are evaluating portions of their queries. By allowing users to merely say what data they are interested in access-ing without providing guidance regarding how to retrieve it, query optimizers can generate plans with unintended conse-quences to the user (e.g., violating user privacy by revealing sensitive portions of a user's query to untrusted servers, or impacting result freshness by pulling data from stale data stores). To address these types of issues, we have created a framework that empowers users with the ability to specify constraints on the kinds of plans that can be produced by the optimizer to evaluate their queries. Such constraints are specified through an extended version of SQL that we have developed which we call PASQL. With this proposal, we aim to demonstrate PAQO, a version of PostgreSQL's query op-timizer that we have modified to produce plans that respect constraints specified through PASQL while optimizing user-specified SQL queries in terms of performance.

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

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

M3 - Chapter

VL - 6

SP - 1334

EP - 1337

BT - Proceedings of the VLDB Endowment

ER -