Demonstrations
Video demonstrations of ProvSQL in action.
ProvSQL Studio: Inspecting Probabilistic Query Evaluation
November 2026
Demonstration of ProvSQL Studio, the web front end to ProvSQL, on a peer-review database where bids, expertise, and paper topics are uncertain. Studio shows what a single probability hides: which method the optimizer chose, the guarantee it meets when a relative or additive one is requested instead of a method, the provenance circuit, the Tseytin CNF handed to an external compiler and the d-DNNF that d4 returns, and a benchmark of every probability method on the same circuit.
Preserving LLM Output Distributions for Probabilistic Query Evaluation
June 2026
Demonstration of a framework that keeps the whole output distribution of a language model instead of collapsing it to a single top prediction. Candidate values and their probabilities, obtained locally with Llama 3.1 over 10,612 Amazon musical products and 230,156 user reviews, are stored as JSONB mappings and turned by ProvSQL into mutually exclusive gates of a provenance circuit. Plain SQL queries are then evaluated probabilistically, with the uncertainty propagated through joins, group-by, and filters.
Using a Probabilistic Database in an Image Retrieval Application
December 2024
Demonstration of a system that uses ProvSQL as the probabilistic database backend for content-based image retrieval. Uncertain feature vectors from a deep learning object detector are stored and queried, with result probabilities computed via ProvSQL’s knowledge compilation pipeline.
ProvSQL Demonstration
January 2018
The original demonstration of the ProvSQL system, accompanying the VLDB 2018 demonstration paper. Shows provenance tracking and probability management in PostgreSQL, including semiring provenance, where-provenance, and probabilistic query evaluation.