Abstract
The logical theory of database integrity is developed as an application of deontic logic. After a brief introduction to database theory and Kripke semantics, a deontic operator X, denoting “what should hold, non-trivially, given a set of constraints”, is defined and axiomatized. The theory is applied to updates, to dynamic constraints and to databases extended with nulls.
Similar content being viewed by others
References
L. Åqvist,Introduction to Deontic Logic (Bibliopolis, Napoli, 1987).
F. Bancilhon and N. Spyratos, Update semantics of relational views, ACM Trans. Database Syst. 6(1981)557–575.
E.F. Codd, Extending the relational database model to capture more meaning, ACM Trans. Database Syst. 4(1979).
E.F. Codd,The Relational Model for Database Management: Version 2 (Addison-Wesley, 1990).
C.J. Date,An Introduction to Database Systems, Vol II (Addison-Wesley, 1983).
C.J. Date,Relational Database: Selected Writings (Addison-Wesley, 1986).
S.J. van Denneheuvel and K.L. Kwast, Weak equivalence for constraint sets, in:Proc. IJACI'91, Sydney, ed. J. Mylopoulos and R. Reiter (Kaufmann, 1991).
L. Fariñas del Cerro and A. Herzig, An automated modal logic of elementary changes, in:Non-Standard Logics for Automated Reasoning, ed. Ph. Smets et al. (Academic Press, 1988).
R. Fagin, J. Ullman and M. Vardi, On the semantics of updates in databases, in:Proc. PODS'83: 2nd ACM Symp. on Principles of Database Systems, Atlanta (1983).
S.J. Hegner, Canonical view update support through Boolean algebras of components, J. ACM 31(1984).
W. van der Hoek, Modalities for reasoning about knowledge and quantities, Thesis, Vrije Universiteit, Amsterdam (1992).
C.E. Hughes and M.J. Cresswell,An Introduction to Modal Logic (Methuen, 1968).
T. Imielinski and W. Lipski, The relational model of data and cylindric algebras, J. Comp. Syst. Sci. 28(1984).
R. Koymans, Specifying message passing and time-critical systems with temporal logic, Thesis, Technische Universiteit Eindhoven (1989).
S. Kripke, Identity and necessity, in:Identity and Individuation, ed. M.K. Munitz (New York University Press, 1971). Reprinted in:Naming, Necessity and Natural Kinds, ed. S.P. Schwartz (Cornell University Press, 1977).
K.L. Kwast, A deontic operator for database integrity, in:Proc. DEON'91, Amsterdam (1991), ed. J.-J. Ch. Meyers and R. Wieringa.
K.L. Kwast, The relational database model, Thesis, University of Amsterdam (1992).
K.L Kwast, Weak implication: Theory and applications, in:Proc. JELIA'92, 3rd Eur. Workshop on Logic in AI, Berlin (1992).
R. Langerak, View updates in relational databases with independent scheme, ACM Trans. Database Syst. 15(1)(1984).
H. Levesque, Foundations of a functional approach to knowldege representation, Artificial Intelligence 23(1984).
W. Lipski, On databases with incomplete information, J. ACM 28(1981).
J.-J. Ch. Meyer, H. Weigand and R. Wieringa, Specifying dynamic and deontic integrity constraints, Report IR-175, Vrije Universiteit, Amsterdam (1988).
J.-J. Ch. Meyer and W. van der Hoek, Non-monotonic reasoning by monotonie means, Report IR-171, Vrije Universiteit, Amsterdam (1988).
J.-J. Ch. Meyer and R. Wieringa, Applications of deontic logic in computer science: A concise overview, in:Proc. DEON'91, Amsterdam (1991), ed. J.-J. Ch. Meyer and R. Wieringa.
J. Paredeans, P. de Bra, M. Gyssens and D. van Gucht,The Structure of the Relational Database Model (Springer, 1989).
R. Reiter, On integrity constraints, in:Proc. 2nd TARK: Conf. on Theoretical Aspects of Reasoning about Knowledge (1988), ed. M. Vardi.
J.D. Ullman,Principles of Database Systems (Computer Science Press, 1982).
J.D. Ullman,Principles of Data and Knowledge-based Systems, Vols. I and II (Computer Science Press, 1989).
M. Vardi, Fundamentals of dependency theory, in:Trends in Theoretical Computer Science, ed. E. Borger (Computer Science Press, 1988).
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Kwast, K.L. A deontic approach to database integrity. Ann Math Artif Intell 9, 205–238 (1993). https://doi.org/10.1007/BF01531267
Issue Date:
DOI: https://doi.org/10.1007/BF01531267