Skip to main content
SpringerLink
Log in

Design Support for Database Federations

  • Conference paper
  • First Online:
Conceptual Modeling — ER ’99 (ER 1999)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1728))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. 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.

    Google Scholar 

  2. 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.

    Google Scholar 

  3. C. Batini, M. Lenzerini, S. B. Navathe. A Comparative Analysis of Methodologies for Database Schema Integration. ACM Computing Surveys, 18(4):323–364, 1986.

    Article  Google Scholar 

  4. Y. Breitbart, H. Garcia-Molina, A. Silberschatz. Overview of Multidatabase Transaction Management. The VLDB Journal, 1(2):181–240, 1992.

    Article  Google Scholar 

  5. S. Castano, M. G. Fugini, G. Martella, P. Samarati. Database Security. ACM Press, Addison-Wesley, 1995.

    Google Scholar 

  6. 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.

    Chapter  Google Scholar 

  7. 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.

    Article  Google Scholar 

  8. 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.

    Google Scholar 

  9. B. Ganter, R. Wille. Formal Concept Analysis. Springer, 1998.

    Google Scholar 

  10. 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.

    Article  Google Scholar 

  11. E. Hildebrandt, G. Saake. User Authentication in Multidatabase Systems. In R. Wagner, ed., Proc. 9th DEXA Workshop, pp. 281–286. IEEE CS Press, 1998.

    Google Scholar 

  12. 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.

    Google Scholar 

  13. 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.

    Google Scholar 

  14. 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.

    Google Scholar 

  15. 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.

    Article  Google Scholar 

  16. W. Litwin, T. Morzy, G. Vossen, eds., Proc. ADBIS’98, LNCS 1475, Springer, 1998.

    Google Scholar 

  17. A. Motro. Superviews: Virtual Integration of Multiple Databases. IEEE Transactions on Software Engineering, 13(7):785–798, 1987.

    Article  Google Scholar 

  18. K.-U. Sattler, M. Hoding. Adapter Generation for Extraction and Querying Data from Web Sources. In Proc. 2nd ACM SIGMOD Workshop WebDB’99, 1999.

    Google Scholar 

  19. 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.

    Google Scholar 

  20. I. Schmitt, G. Saake. Merging Inheritance Hierarchies for Database Integration. In M. Halper, ed., Proc. CoopIS’98, pp. 322–331. IEEE CS Press, 1998.

    Google Scholar 

  21. I. Schmitt, G. Saake. Integrating Schemata using the GIM Method. Informatik Preprint, Universitat Magdeburg, 1999.

    Google Scholar 

  22. 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.

    Google Scholar 

  23. K. Schwarz, C. Turker, G. Saake. Extending Transaction Closures by N-ary Termination Dependencies. In [16], pp. 131–142.

    Google Scholar 

  24. A. P. Sheth, J. A. Larson. Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Databases. ACM Computing Surveys, 22(3):183–236, 1990.

    Article  Google Scholar 

  25. S. Spaccapietra, C. Parent, Y. Dupont. Model Independent Assertions for Integration of Heterogeneous Schemas. The VLDB Journal, 1(1):81–126, 1992.

    Article  Google Scholar 

  26. 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.

    Google Scholar 

  27. C. Turker, G. Saake. Deriving Relationships between Integrity Constraints for Schema Comparison. In [16], pp. 188–199.

    Google Scholar 

  28. C. Turker, G. Saake. Consistent Handling of Integrity Constraints and Extensional Assertions for Schema Integration. In Proc. ADBIS’99, LNCS. Springer, 1999.

    Google Scholar 

  29. C. Turker, K. Schwarz, G. Saake. Commit Protocols for Global Transactions in Federated Database Systems. Informatik Preprint 2, Universitat Magdeburg, 1999.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institut für Technische und Betriebliche Informationssysteme, Otto-von-Guericke-Universität Magdeburg, Postfach 4120, D—39016, Magdeburg, Germany

    Kerstin Schwarz, Ingo Schmitt, Can Türker, Michael Höding, Eyk Hildebrandt, Balko Sören, Stefan Conrad & Gunter Saake

Authors
  1. Kerstin Schwarz
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Ingo Schmitt
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Can Türker
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Michael Höding
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Eyk Hildebrandt
    View author publications

    You can also search for this author in PubMed Google Scholar

  6. Balko Sören
    View author publications

    You can also search for this author in PubMed Google Scholar

  7. Stefan Conrad
    View author publications

    You can also search for this author in PubMed Google Scholar

  8. Gunter Saake
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Conservatoire National des Arts et Métiers, 292 Rue Saint Martin, F-75141, Paris Cedex 03, France

    Jacky Akoka

  2. Université de Versailles, 45 Avenue des Etats Unis, F-78035, Versailles Cedex, France

    Mokrane Bouzeghoub  & Elisabeth Métais  & 

  3. ESSEC, Avenue Bernard Hirsch, F-92021, Cergy Cedex, France

    Isabelle Comyn-Wattiau

Rights and permissions

Reprints 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

Publish with us

Policies and ethics

Search

Navigation