|  |
 |
 |
Functional dependencies in a relational database and propositional logic
|  |
 |
 |
 |
by R. Fagin |
 |
|
|  |
 |  |  |
|
| |
|
IBM Journal of Research and Development, Volume 21, Issue 6, pp. 534-544 (1977).
| |
|
Theoretical database studies form a fundamental framework for the development of sound database management systems, which have provided increasingly sophisticated capabilities for data handling. Studies of database design challenges require a precise formalization so that detailed analyses and comparisons can be made. Such analyses facilitate the design of superior database management systems in terms of performance, reliability, new ways of handling query evaluations and incomplete information, and the specification of data models and data dependencies.
This highly cited paper introduces and describes the strong relationship between mathematical logic and database function. Fagin and his colleagues subsequently broadened the IBM Journal paper findings in a 1981 paper published in the Journal of the ACM (“An equivalence between relational database dependencies and a fragment of propositional logic,” Vol. 28, No. 3, pp. 435-453). Fagin's IBM Journal paper was the first to introduce concepts and notations from mathematical logic, such as logical implication, for the study of databases. Mathematical logic has subsequently been shown to provide a fundamental tool in the study of databases, and many papers have described how to best take advantage of this connection between logic and database design.
| |
|
|
|