Abstract
Federated database systems provide a homogeneous interface to possibly heterogeneous local database systems. This homogeneous interface consists of a global schema which is the result of a logical integration of the schemata of the corresponding local database systems and file systems. In this paper, we sketch the integration process and a set of tools for supporting the design process. Besides the classical database schema integration, the design process for federated information systems requires the integration of other aspects like integrity rules, authorization policies and transactional processes. This paper reports on an integrated approach to tool support of several of these integration aspects. The different integration facets are linked via the database integration method GIM allowing a high degree of automatic integration steps.
This work has been supported by the CICYT under MENHIR/ESPILL TIC 97-0593-C05-01 Project and by DGEUI under IRGAS GV97-TI-05-34 Project.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
A. Adelberg. NoDoSE — A Tool for Semi-Automatically Extracting Structured and Semistructured Data from Text Documents. In L. Haas, A. Tiwary, eds., Proc. SIGMOD’98, ACM SIGMOD Record, Vol. 25, pp. 283–294, ACM Press, 1998.
S. Balko, C. Turker. Integration of Aggregation Constraints. In S. Conrad, W. Hasselbring, G. Saake, eds., Proc. 2nd Int. Workshop on Engineering Federated Information Systems, EFIS’99, pp. 5–24. infix-Verlag, 1999.
C. Batini, M. Lenzerini, S. B. Navathe. A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys, 18(4):323–364, 1986.
Y. Breitbart, H. Garcia-Molina, A. Silberschatz. Overview of Multidatabase Transaction Management. The VLDB Journal, 1(2):181–240, 1992.
S. Castano, M. G. Fugini, G. Martella, P. Samarati. Database Security. ACM Press, Addison-Wesley, 1995.
S. Conrad, I. Schmitt, C. Turker. Considering Integrity Constraints During Federated Database Design. In S. M. Embury, N. J. Fiddian, A. W. Gray, A. C. Jones, eds., Advances in Databases, BNCOD 16, LNCS 1405, pp. 119–133. Springer, 1998.
U. Dayal, H. Y. Hwang. View Definition and Generalization for Database Integration in a Multidatabase System. IEEE Transactions on Software Engineering, 10(6):628–644, 1984.
Y. Dupont, S. Spaccapietra. Schema Integration Engineering in Cooperative Databases Systems. In K. Yetongnon, S. Hariri, eds., Proc. 9th ISCA Int. Conf. on Parallel and Distributed Computing Systems, PDCS’96, pp. 759–765. International Society for Computers and Their Application, 1996.
B. Ganter, R. Wille. Formal Concept Analysis. Springer, 1998.
D. Georgakopoulos, M. Rusinkiewicz, A. Sheth. Using Tickets to Enforce the Serializability of Multidatabase Transactions. IEEE Transactions on Knowledge and Data Engineering, 6(1):166–180, 1994.
E. Hildebrandt, G. Saake. User Authentication in Multidatabase Systems. In R. Wagner, ed., Proc. 9th DEXA Workshop, pp. 281–286. IEEE CS Press, 1998.
R. Himmelroder, B. Ludascher. Querying the Web with FLORID. In M. H. Scholl, H. Riedel, T. Grust, and D. Gluche, eds., 10. Workshop “Grundlagen von Datenbanken,” Forschungsbericht No. 63, pp. 94–98, Universitat Konstanz, Fachbereich Informatik, 1998.
M. Hoding. An Approach to Integration of File Based Systems into Database Federations. In Heterogeneous Information Management, Proc. 10th ERCIM Database Research Group Workshop, pp. 61–71, ERCIM-96-W003, European Research Consortium for Informatics and Mathematics, 1996.
M. Hoding, R. Hofestadt, G. Saake, U. Scholz. Schema Derivation for WWW Information Sources and their Integration with Databases in Bioinformatics. In [16], pp. 296–304.
J. A. Larson, S. B. Navathe, R. Elmasri. A Theory of Attribute Equivalence in Databases with Application to Schema Integration. IEEE Transactions on Software Engineering, 15(4):449–463, 1989.
W. Litwin, T. Morzy, G. Vossen, eds., Proc. ADBIS’98, LNCS 1475, Springer, 1998.
A. Motro. Superviews: Virtual Integration of Multiple Databases. IEEE Transactions on Software Engineering, 13(7):785–798, 1987.
K.-U. Sattler, M. Hoding. Adapter Generation for Extraction and Querying Data from Web Sources. In Proc. 2nd ACM SIGMOD Workshop WebDB’99, 1999.
I. Schmitt, G. Saake. Integration of Inheritance Trees as Part of View Generation for Database Federations. In B. Thalheim, ed., Conceptual Modelling — ER’96, LNCS 1157, pp. 195–210. Springer, 1996.
I. Schmitt, G. Saake. Merging Inheritance Hierarchies for Database Integration. In M. Halper, ed., Proc. CoopIS’98, pp. 322–331. IEEE CS Press, 1998.
I. Schmitt, G. Saake. Integrating Schemata using the GIM Method. Informatik Preprint, Universitat Magdeburg, 1999.
I. Schmitt, C. Turker. Refining Extensional Relationships and Existence Requirements for Incremental Schema Integration. In G. Gardarin, J. French, N. Pissinou, K. Makki, L. Bougamin, eds., Proc. CIKM’98, pp. 322–330. ACM Press, 1998.
K. Schwarz, C. Turker, G. Saake. Extending Transaction Closures by N-ary Termination Dependencies. In [16], pp. 131–142.
A. P. Sheth, J. A. Larson. Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys, 22(3):183–236, 1990.
S. Spaccapietra, C. Parent, Y. Dupont. Model Independent Assertions for Integration of Heterogeneous Schemas. The VLDB Journal, 1(1):81–126, 1992.
K. Schwarz, I. Schmitt, C. Turker, M. Hoding, E. Hildebrandt, S. Balko, S. Conrad, G. Saake. Tool Support for the Design of Database Federations in SIGMAFDB. Informatik Preprint 14, Universitat Magdeburg, 1999.
C. Turker, G. Saake. Deriving Relationships between Integrity Constraints for Schema Comparison. In [16], pp. 188–199.
C. Turker, G. Saake. Consistent Handling of Integrity Constraints and Extensional Assertions for Schema Integration. In Proc. ADBIS’99, LNCS. Springer, 1999.
C. Turker, K. Schwarz, G. Saake. Commit Protocols for Global Transactions in Federated Database Systems. Informatik Preprint 2, Universitat Magdeburg, 1999.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Schwarz, K. et al. (1999). Design Support for Database Federations. In: Akoka, J., Bouzeghoub, M., Comyn-Wattiau, I., Métais, E. (eds) Conceptual Modeling — ER ’99. ER 1999. Lecture Notes in Computer Science, vol 1728. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-47866-3_30
Download citation
DOI: https://doi.org/10.1007/3-540-47866-3_30
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66686-8
Online ISBN: 978-3-540-47866-9
eBook Packages: Springer Book Archive