LPIS Home Page
Google Search

Title: Modelling Constraints with Exceptions in Object-Oriented Databases
Author(s): N. Bassiliades, I. Vlahavas.
Availability: Click here to download the GZ (gzipped postscript) file (15 pages).
Keywords: Semantic Integrity Constraints, Exceptions, Multiple Inheritance.
Appeared in: Entity-Relationship Approach - ER'94, Business Modelling and Re-Engineering, 13th International Conference on the Entity-Relationship Approach, P. Loucopoulos (Ed.), Springer-Verlag, LNCS 881, pp. 189-204, Manchester, United Kingdom, December 1994, 1994.
Abstract: This paper deals with modelling constraints in object-oriented databases, with emphasis given on exceptions. Constraints are restrictions on properties and relations of database objects that ensure the integrity of data. Therefore, they should be obeyed by every object, but as in real-life, there are some exceptions to this rule. Object-oriented databases provide rich semantic constructs, adequate to model real-world relations. Inheritance of constraints in object-oriented databases has been treated in a completely mandatory way, providing no room for exceptions. In this paper, an object-oriented constraint representation scheme is presented, along with a methodology for modelling constraint exceptions. Finally, an algorithm is described that ensures correct run-time resolution of constraint applicability. Since business is not in abstract, but in real-world, business database modelling would be greatly benefited from a tool that allows both a clear definition and an efficient enforcement of constraints with exceptions.
See also :

        This paper has been cited by the following:

1 Robert J. Zhang Elizabeth A. Unger, "Introduction to Database Integrity", Technical Report TR CS-95-14, Department of Computing and Information Sciences, Kansas State University, USA, December 1995.
2 S.M. Embury, P.M.D. Gray, "The declarative expression of semantic integrity in a database of protein structure", Proc. Basque Int. Workshop on Information Technology, San Sebastian, Spain, IEEE Computer Society Press, pp. 216-224, 1995.
3 H. Oakasha, "Consistency Management for Object Databases", Ph.D. thesis, Informatics Faculty, University of Magdeburg, Germany, 2000.
4 B. Thalheim, Entity-Relationship Modeling, Foundations of Database Technology, Springer, 2000, 627 pp., ISBN 3-540-65470-4.
5 H. Oakasha, S. Conrad, G. Saake, "Consistency management in object-oriented databases", Concurrency and Computation: Practice and Experience, Vol. 13, No. 11, 2001, pp. 955985.
6 E. Bertino, G. Guerrini, I. Merlo, "Exception handling in object-oriented databases", Advances in exception handling techniques, pp. 234-250, LNCS 2022, Springer-Verlag, 2001.
7 S. Chattopadhyay, C. Roy, M. Chattopadhyay, "Expressing constraint models in Object Oriented Data using UML and ODL", Proc. Distributed Computing, LNCS 2571, pp. 329-338, Springer-Verlag, 2002
8 J. S. Goonetillake, T. W. Carnduff and W. A. Gray, "An integrity constraint management framework in engineering design", Computers in Industry, Vol. 48, No. 1, pp. 29-44, 2002.
9 A. Olive, "Integrity constraints definition in object-oriented conceptual modeling languages", Proc. Conceptual Modeling - ER 2003, LNCS 2813, Springer-Verlag, pp. 349-362, 2003.
10 J.S. Goonetillake, G.N. Wikramanayake, "Management of Evolving Constraints in a Computerised Engineering Design Environment", Proc. 23rd National IT Conference, pp. 43-54, Colombo, Sri Lanka, 2004.
11 Chhanda Ray, "Modeling of Constraints in Distributed Object Oriented Environment", Synopsis of PhD Dissertation, Pre-proceedings of the First International Conference on Interoperability of Enterprise Software and Applications (INTEROP-ESA2005), Doctoral Symposium, Geneva, Switzerland, February 23 - 25, 2005, pp. 153-164.
12 T. W. Carnduff, J. S. Goonetillake, "The Management of Evolving Engineering Design Constraints", Chapter 3 in Database Modeling for Industrial Data Management: Emerging Technologies and Applications, Zongmin Ma, Ed., pp. 62-114, Idea Group, 2006.
13 A. Olive, "A method for the definition of integrity constraints in object-oriented conceptual modeling languages", Data and Knowledge Engineering, Vol. 59, No. 3, pp. 559-575, 2006.
14 Paladi, N., Arts, T., Model based testing of data constraints: Testing the business logic of a mnesia application with Quviq QuickCheck, (2009) Erlang'09 - Proceedings of the 2009 ACM SIGPLAN Erlang Workshop, Co-located with the Int. Conf. on Functional Programming, ICFP'09, pp. 71-81.