ProvSQL: Provenance and probability management in PostgreSQL

Pierre Senellart; Louis Jachiet; Silviu Maniu; Yann Ramusat

doi:10.14778/3229863.3236253

ProvSQL: Provenance and probability management in PostgreSQL

Pierre Senellart
, Louis Jachiet
, Silviu Maniu
, Yann Ramusat

DI ENS
Université PSL
INRIA Institut National de Recherche en Informatique et en Automatique
Université Paris-Saclay

Research output: Contribution to journal › Conference article › peer-review

59 Citations (Scopus)

Abstract

This demonstration showcases ProvSQL, an open-source module for the PostgreSQL database management system that adds support for computation of provenance and probabilities of query results. A large range of provenance formalisms are supported, including all those captured by provenance semirings, provenance semirings with monus, as well as where-provenance. Probabilistic query evaluation is made possible through the use of knowledge compilation tools, in addition to standard approaches such as enumeration of possible worlds and Monte-Carlo sampling. ProvSQL supports a large subset of non-aggregate SQL queries.

Original language	English
Pages (from-to)	2034-2037
Number of pages	4
Journal	Proceedings of the VLDB Endowment
Volume	11
Issue number	12
DOIs	https://doi.org/10.14778/3229863.3236253
Publication status	Published - 1 Jan 2018
Event	44th International Conference on Very Large Data Bases, VLDB 2018 - Rio de Janeiro, Brazil Duration: 27 Aug 2018 → 31 Aug 2018

Access to Document

10.14778/3229863.3236253

Cite this

@article{eb23496788054f49be1daf224aa76a2e,

title = "ProvSQL: Provenance and probability management in PostgreSQL",

abstract = "This demonstration showcases ProvSQL, an open-source module for the PostgreSQL database management system that adds support for computation of provenance and probabilities of query results. A large range of provenance formalisms are supported, including all those captured by provenance semirings, provenance semirings with monus, as well as where-provenance. Probabilistic query evaluation is made possible through the use of knowledge compilation tools, in addition to standard approaches such as enumeration of possible worlds and Monte-Carlo sampling. ProvSQL supports a large subset of non-aggregate SQL queries.",

author = "Pierre Senellart and Louis Jachiet and Silviu Maniu and Yann Ramusat",

note = "Publisher Copyright: {\textcopyright} 2018 VLDB Endowment.; 44th International Conference on Very Large Data Bases, VLDB 2018 ; Conference date: 27-08-2018 Through 31-08-2018",

year = "2018",

month = jan,

day = "1",

doi = "10.14778/3229863.3236253",

language = "English",

volume = "11",

pages = "2034--2037",

journal = "Proceedings of the VLDB Endowment",

issn = "2150-8097",

publisher = "VLDB Endowment",

number = "12",

}

TY - JOUR

T1 - ProvSQL

T2 - 44th International Conference on Very Large Data Bases, VLDB 2018

AU - Senellart, Pierre

AU - Jachiet, Louis

AU - Maniu, Silviu

AU - Ramusat, Yann

PY - 2018/1/1

Y1 - 2018/1/1

N2 - This demonstration showcases ProvSQL, an open-source module for the PostgreSQL database management system that adds support for computation of provenance and probabilities of query results. A large range of provenance formalisms are supported, including all those captured by provenance semirings, provenance semirings with monus, as well as where-provenance. Probabilistic query evaluation is made possible through the use of knowledge compilation tools, in addition to standard approaches such as enumeration of possible worlds and Monte-Carlo sampling. ProvSQL supports a large subset of non-aggregate SQL queries.

AB - This demonstration showcases ProvSQL, an open-source module for the PostgreSQL database management system that adds support for computation of provenance and probabilities of query results. A large range of provenance formalisms are supported, including all those captured by provenance semirings, provenance semirings with monus, as well as where-provenance. Probabilistic query evaluation is made possible through the use of knowledge compilation tools, in addition to standard approaches such as enumeration of possible worlds and Monte-Carlo sampling. ProvSQL supports a large subset of non-aggregate SQL queries.

U2 - 10.14778/3229863.3236253

DO - 10.14778/3229863.3236253

M3 - Conference article

AN - SCOPUS:85058897113

SN - 2150-8097

VL - 11

SP - 2034

EP - 2037

JO - Proceedings of the VLDB Endowment

JF - Proceedings of the VLDB Endowment

IS - 12

Y2 - 27 August 2018 through 31 August 2018

ER -

ProvSQL: Provenance and probability management in PostgreSQL

Abstract

Access to Document

Fingerprint

Cite this