Formal systems for join dependencies

Catriel Beeri*, Moshe Y. Vardi

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

6 Scopus citations

Abstract

We investigate whether a sound and complete formal system for join dependencies can be found. We present a system that is sound and complete for tuple generating dependencies and is strong enough to derive join dependencies from join dependencies using only generalized join dependencies in the derivation. We also present a system that sound and complete for tuple generating dependencies and is complete for extended join dependencies (which are a special case of generalized join dependencies). Finally, we construct a Gentzen-style system that is sound and complete for join dependencies. The last two systems have unbounded inference rules.

Original languageEnglish
Pages (from-to)99-116
Number of pages18
JournalTheoretical Computer Science
Volume38
Issue numberC
DOIs
StatePublished - 1985

Keywords

  • Database
  • formal system
  • implication problem
  • join dependency
  • relational model

Fingerprint

Dive into the research topics of 'Formal systems for join dependencies'. Together they form a unique fingerprint.

Cite this