Abstract
In this paper we discuss the use and treatment of integrity constraints in the federated database design process. We consider different situations occurring frequently in the schema transformation and schema integration process. Based on that, general rules are given which describe the correct treatment of integrity constraints. Other proposed integration approaches do not consider integrity constraints at all or are restricted to special kinds of constraints. Therefore, our approach can be used to extend or complete existing integration methodologies.
This is a preview of subscription content, log in via an institution to check access.
Preview
Unable to display preview. Download preview PDF.
References
C. Batini, M. Lenzerini, and S. B. Navathe. A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys, 18(4):323–364, December 1986.
R. Busse, P. Fankhauser, and E. J. Neuhold. Federated Schemata in ODMG. In J. Eder and L. A. Kalinichenko, editors, East/West Database Workshop, Proc. 2nd Int. Workshop, pages 356–379, Springer, 1994.
R. Cooper and Z. Qin. A Graphical Data Modelling Program with Constraint Specification and Management. In P. M. D. Gray and R. J. Lucas, editors, Advanced Database Systems, Proc. 10th British National Conf. on Databases, BNCOD 10, pages 192–208, LNCS 618, Springer, 1992.
L. DeMichiel. Resolving Database Incompatibility: An Approach to Performing Relational Operations over Mismatched Domains. IEEE Transactions on Knowledge and Data Engineering, 1(4):485–493, December 1989.
M. Garcia-Solaco, M. Castellanos, and F. Saltor. A Semantic-Discriminated Approach to Integration in Federated Databases. In S. Laufmann, S. Spaccapietra, and T. Yokoi, editors, Proc. 3rd Int. Conf. on Cooperative Information Systems (CoopIS'95) pages 19–31, 1995.
W. Kim, I. Choi, S. Gala, and M. Scheevel. On Resolving Schematic Heterogeneity in Multidatabase Systems. In W. Kim, editor, Modern Database Systems, pages 521–550, ACM Press, 1995.
R. Krishmamurthy, W. Litwin, and W. Kent. Interoperability of Heterogeneous Databases with Schematic Discrepancies. In Y. Kambayashi, M. Rusinkiewicz, and A. Sheth, editors, Proc. 1st Int. Workshop on Interoperability in Multidatabase Systems, pages 144–151, IEEE Computer Society Press, 1991.
E. Radeke and M. H. Scholl. Framework for Object Migration in Federated Database Systems. In Proc. 3rd Int. Conf. on Parallel and Distributed Database Systems, IEEE Computer Science Press, 1994.
M. P. Reddy, B. E. Prasad, and A. Gupta. Formulating Global Integrity Constraints during Derivation of Global Schema. Data & Knowledge Engineering, 16(3):241–268, July 1995.
M. P. Reddy, B. E. Prasad, P. G. Reddy, and A. Gupta. A Methodology for Integration of Heterogeneous Databases. IEEE Transactions on Knowledge & Data Engineering, 6(6):920–933, December 1994.
I. Schmitt and S. Conrad. Restructuring Class Hierarchies for Schema Integration. In R. Topor and K. Tanaka, editors, Database Systems for Advanced Applications '97, Proc. 5th Int. Conf., DASFAA'97, Melbourne, Australia, April 1–4, 1997, pages 411–420, World Scientific Publishing, 1997.
I. Schmitt and G. Saake. Integration of Inheritance Trees as Part of View Generation for Database Federations. In B. Thalheim, editor, Conceptual Modelling — ER'96, Proc. 15th Int. Conf., pages 195–210, LNCS 1157, Springer, 1996.
A. P. Sheth and J. A. Larson. Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys, 22(3):183–236, September 1990.
S. Spaccapietra, C. Parent, and Y. Dupont. Model Independent Assertions for Integration of Heterogeneous Schemas. The VLDB Journal, 1(1):81–126, July 1992.
M. W. W. Vermeer and P. M. G. Apers. The Role of Integrity Constraints in Database Interoperation. In T. M. Vijayaraman, A. P. Buchmann, C. Mohan, and N. L. Sarda, editors, Proc. 22nd Int. Conf. on Very Large Data Bases (VLDB'96), Bombay, India, pages 425–435, Morgan Kaufmann Publishers, September 1996.
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 1997 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Conrad, S., Höding, M., Saake, G., Schmitt, I., Türker, C. (1997). Schema integration with integrity constraints. In: Small, C., Douglas, P., Johnson, R., King, P., Martin, N. (eds) Advances in Databases. BNCOD 1997. Lecture Notes in Computer Science, vol 1271. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-63263-8_22
Download citation
DOI: https://doi.org/10.1007/3-540-63263-8_22
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-63263-4
Online ISBN: 978-3-540-69254-6
eBook Packages: Springer Book Archive