Abstract
A database federation provides for tight coupling of a collection of heterogeneous legacy databases into a global integrated system. A major problem in constructing database federations concerns maintaining quality and consistency of data on the global level of the federation. In particular, the integration of integrity constraints within component legacy databases into a single global schema is a process that is prone to incompleteness and inconsistency. Moreover, additional inter-database constraints between the various component legacy databases often also have to be taken into account to complete the integration process. Our approach to coupling of component databases into a global, integrated system is based on the concept of mediation. Our major result is that mediation in combination with a so-called integration isomorphism integrates component schemas without loss of constraint information; i.e., integrity constraints available at the component level remain intact after integration on the global level of the federated database. Our approach to integration also allows for specification of additional inter-database constraints between the various component legacy databases. We therefore can handle consistency not only on the local level of component databases, but also consistency on the global level between the various component databases. We shall describe a general semantic framework for specification of database federations based on the UML data model. This data model will prove to offer an elegant and powerful framework for analysis and design of database federations, including integration of integrity constraints.
Chapter PDF
Key words
References
Akehurst, D.H., Bordbar, B.; On Queiying UML data models with OCL; «UML» 2001 4th Int. Conf., LNCS 2185, Springer, 2001
Balsters, H.; Object-oriented modeling and design of database federations; SOM Report, University of Groningen, 2003
Balsters, H.; Modelling database views with derived classes in the UML/OCL-framework; 6th UML-conference, San Francisco, LNCS 2863, Springer, 2003
Balsters, H., de Brock, E.O.; Towards a general semantic framework for design of federated database systems; SOM Report 01A26, University of Groningen, 2001
Balsters, H., de By, R.A., Zicari, R.; Sets and constraints in an object-oriented data model; Proc 7th ECOOP, LNCS 707, Springer 1993.
Blaha, M., Premerlani, W.; Object-oriented modeling and design for database applications; Prentice Hall, 1998
Balsters, H., Spelt, D.; Automatic verification of transactions on an object-oriented database, 6th Int. Workshop on Database Programming Languages, LNCS 1369, Springer, 1998.
Demuth, B., Hussmann, H.; Using UML/OCL constraints for relational database design; «UML»’99: 2nd Int. Conf., LNCS 1723, Springer, 1999
Demuth, B., Hussmann, H., Loecher, S.; OCL as a specification language for business rules in database applications; «UML» 2001, 4th Int. Conf., LNCS 2185, Springer, 2001
P. Drew, R. King, D. McLeod, M. Rusinkievicz, A. Silberschatz; Workshop on semantic heterogeneity and interoperation in multidatabase systems; SIGMOD RECORD 22, 1993
Garcia-Molina, H., Ullman, J.D., Widom, J.; Database systems Prentice Hall, 2002
Hull, R.; Managing Semantic Heterogeneity in Databases; ACM PODS’97, ACM Press 1997.
Response to the UML 2.0 OCL RfP, Revised Submission, Version 1.6, January 6, 2003
Reiter, R.; Towards a logical reconstruction of relational database theory. In: Brodie, M.L., Mylopoulos, J., Schmidt, J.W.; On conceptual modeling; Springer Verlag, 1984
A.P. Sheth, JA. Larson; Federated database systems for managing distributed and heterogeneous and autonomous databases; ACM Computing surveys 22,1990
M. Vermeer; Semantic interoperability for legacy databases. Ph.D.-thesis, University of Twente, 1997.
G. Wiederhold; Value-added mediation in large-scale information systems FIP Data Semantics (DS-6), 1995
Warmer, J.B., Kleppe, A.G.; The object constraint language, 2nd ed.; Addison Wesley, 2003
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Kluwer Academic Publishers
About this chapter
Cite this chapter
Balsters, H., de Brock, B. (2004). Integration of Integrity Constraints in Database Federations. In: Jajodia, S., Strous, L. (eds) Integrity and Internal Control in Information Systems VI. IICIS 2003. IFIP International Federation for Information Processing, vol 140. Springer, Boston, MA. https://doi.org/10.1007/1-4020-7901-X_10
Download citation
DOI: https://doi.org/10.1007/1-4020-7901-X_10
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4020-7900-9
Online ISBN: 978-1-4020-7901-6
eBook Packages: Springer Book Archive