English

Relational Semantics for Databases and Predicate Calculus

Databases 2012-02-08 v3 Logic in Computer Science

Abstract

The relational data model requires a theory of relations in which tuples are not only many-sorted, but can also have indexes that are not necessarily numerical. In this paper we develop such a theory and define operations on relations that are adequate for database use. The operations are similar to those of Codd's relational algebra, but differ in being based on a mathematically adequate theory of relations. The semantics of predicate calculus, being oriented toward the concept of satisfiability, is not suitable for relational databases. We develop an alternative semantics that assigns relations as meaning to formulas with free variables. This semantics makes the classical predicate calculus suitable as a query language for relational databases.

Keywords

Cite

@article{arxiv.1202.0474,
  title  = {Relational Semantics for Databases and Predicate Calculus},
  author = {Philip Kelly and M. H. van Emden},
  journal= {arXiv preprint arXiv:1202.0474},
  year   = {2012}
}

Comments

18 pages, 8 figures. arXiv admin note: text overlap with arXiv:cs/0607039

R2 v1 2026-06-21T20:13:50.701Z