Abstract:Derived datasets can be defined implicitly or explicitly. An implicit definition (of dataset O in terms of datasets I) is a logical specification involving two distinguished sets of relational symbols. One set of relations is for the "source data" I, and the other is for the "interface data" O. Such a specification is a valid definition of O in terms of I, if any two models of the specification agreeing on I agree on O. In contrast, an explicit definition is a transformation (or "query" below) that produces O from I. Variants of Beth's theorem state that one can convert implicit definitions to explicit ones. Further, this conversion can be done effectively given a proof witnessing implicit definability in a suitable proof system. We prove the analogous implicit-to-explicit result for nested relations: implicit definitions, given in the natural logic for nested relations, can be converted to explicit definitions in the nested relational calculus (NRC). We first provide a model-theoretic argument for this result, which makes some additional connections that may be of independent interest, between NRC queries, interpretations, a standard mechanism for defining structure-to-structure translation in logic, and between interpretations and implicit to definability "up to unique isomorphism". The latter connection uses a variation of a result of Gaifman concerning "relatively categorical" theories. We also provide a proof-theoretic result that provides an effective argument: from a proof witnessing implicit definability, we can efficiently produce an NRC definition. This will involve introducing the appropriate proof system for reasoning with nested sets, along with some auxiliary Beth-type results for this system. As a consequence, we can effectively extract rewritings of NRC queries in terms of NRC views, given a proof witnessing that the query is determined by the views.

Scaling Relational Inference Using Proofs and Refutations

Diagnosis via Proofs of Unsatisfiability for First-Order Logic with Relational Objects

Proving Query Equivalence Using Linear Integer Arithmetic

Automatic Inference of Relational Object Invariants

LeanReasoner: Boosting Complex Logical Reasoning with Lean

Scalable Knowledge Refactoring using Constrained Optimisation

Relational Verification via Invariant-Guided Synchronization

Optimization of bound disjunctive queries with constraints

Towards a Scalable Proof Engine: A Performant Prototype Rewriting Primitive for Coq

Scaling Package Queries to a Billion Tuples via Hierarchical Partitioning and Customized Optimization

Scaling Abstraction Refinement for Program Analyses in Datalog Using Graph Neural Networks

Inference Scaling $\scriptsize\mathtt{F}$Laws: The Limits of LLM Resampling with Imperfect Verifiers

SQALER: Scaling Question Answering by Decoupling Multi-Hop and Logical Reasoning

Enhancing Predicate Pairing with Abstraction for Relational Verification

Lifted Causal Inference in Relational Domains

Beyond the Grounding Bottleneck: Datalog Techniques for Inference in Probabilistic Logic Programs (Technical Report)

Soft Reasoning on Uncertain Knowledge Graphs

Verifying SQL Queries using Theories of Tables and Relations

Proving correctness for SQL implementations of OCL constraints

VeriEQL: Bounded Equivalence Verification for Complex SQL Queries with Integrity Constraints

Synthesizing nested relational queries from implicit specifications: via model theory and via proof theory