Journal of the ACM · 1987 · 73 citations · 16 references
ComputingComputer ScienceInformation SystemsAgingData ManagementDatabasesDatabase DesignDatabase ManagementRelational AlgebraRelational Data ModelRelational DatabasesTemporal DatabasesConstraintsDatabase Lifecycle ManagementDatabase Schema EvolutionDynamic Constraint SatisfactionFunctional Dependency TheorySurvivabilityTemporal Relational DatabasesTemporal Relational Model
Functional dependencies are the static constraints considered in this study. The paper introduces a simple extension of the relational model to investigate how dynamic constraints influence database evolution. The model incorporates both static functional dependencies and dynamic constraints—global updates restricted to dynamic FD analogs—and examines their interaction over time using age and age closure concepts. Dynamic constraints alter the static functional dependencies satisfied by the database over time, and the study links these effects to future evolution through survivability and survivability closure.
A simple extension of the relational model is introduced to study the effects of dynamic constraints on database evolution. Both static and dynamic constraints are used in conjunction with the model. The static constraints considered here are functional dependencies (FDs). The dynamic constraints involve global updates and are restricted to certain analogs of FDs, called “dynamic” FDs. The results concern the effect of the dynamic constraints on the static constraints satisfied by the database in the course of time. The effect of the past history of the database on the static constraints is investigated using the notions of age and age closure. The connection between the static constraints and the potential future evolution of the database is briefly discussed using the notions of survivability and survivability closure.
16
The theory of joins in relational databases
A. V. Aho, Catriel Beeri, Jeffrey D. Ullman · ACM Transactions on Database Systems · 1979 · 423 citations · Full text
Horn clauses and database dependencies
Ronald Fagin · Journal of the ACM · 1982 · 377 citations · Full text
On the Structure of Armstrong Relations for Functional Dependencies
Catriel Beeri, M. Dowd, Ronald Fagin et al. · Journal of the ACM · 1984 · 198 citations · Full text