Academia.eduAcademia.edu

Outline

Title
Abstract
Introduction
The Federated Database Model
The Federated Database Architecture
Data Update
Conclusions
References
All Topics
Computer Science
Information Systems

A federated architecture for information management

Profile image of Dennis McLeodDennis McLeod

1985, Acm Transactions on Information Systems

https://doi.org/10.1145/4229.4233
visibility

…

description

26 pages

link

1 file

Abstract

An approach to the coordinated sharing and interchange of computerized information is described emphasizing partial, controlled sharing among autonomous databases. Office information systems provide a particularly appropriate context for this type of information sharing and exchange. A federated database architecture is described in which a collection of independent database systems are united into a loosely coupled federation in order to share and exchange information. A federation consists of components (of which there may be any number) and a single federal dictionary. The components represent individual users, applications, workstations, or other components in an office information system. The federal dictionary is a specialized component that maintains the topology of the federation and oversees the entry of new components. Each component in the federation controls its interactions with other components by means of an export schema and an import schema. The export schema specifies the information that a component will share with other components, while the import schema specifies the nonlocal information that a component wishes to manipulate. The federated architecture provides mechanisms for sharing data, for sharing transactions (via message types) for combining information from several components, and for coordinating activities among autonomous components (via negotiation). A prototype implementation of the federated database mechanism is currently operational on an experimental basis.

Related papers

InterViso: Dealing with the complexity of federated database access
Darrel J Van Buer, Edward Maros, Marjorie Templeton

The VLDB Journal, 1995

Connectivity products are finally available to provide the "highways" between computers containing data. IBM has provided strong validation of the concept with their "Information Warehouse." DBMS vendors are providing gateways into their products, and SQL is being retrofitted on many older DBMSs to make it easier to access data from standard 4GL products and application development systems. The next step needed for data integration is to provide (1) a common data dictionary with a conceptual schema across the data to mask the many differences that occur when databases are developed independently and (2) a server that can access and integrate the databases using information from the data dictionary. In this article, we discuss InterViso, one of the first commercial federated database products. InterViso is based on Mermaid, which was developed at SDC and Unisys . It provides a value added layer above connectivity products to handle views across databases, schema translation, and transaction management.

View PDFchevron_right
The design, implementation, and evaluation of an object-based sharing mechanism for federated database systems
Dennis McLeod

Data Engineering, …, 1993

An approach and mechanism to support the shar-ing of objects (information units) is described, an experimental implementation is presented, and the performance of the system is analyzed and eualu-ated. The mechanism is based upon a core set of constructs that ...

View PDFchevron_right
COMPONENT AND FEDERATION CONCEPT MODELS IN A FEDERATED DATABASE SYSTEM
Nayyer Masood

2003

A methodology for assigning interpretation to a database schema and to develop a federation context in the form of concept models is presented. The concept models are developed using the concepts from an ontology that acts as a semantic fulcrum in the schema integration methodologies. The ontology provides a common vocabulary to establish concept models. The benefit of establishing the concept models is twofold. One, it provides an interpretation to the component schemas of a federated database system. In this perspective it compensates the lack of semantic expressiveness of the current data models. Second, it becomes easier to compare different component schemas and to identify semantic similarities among them that is an essential step in schema integration, hence providing a basis for a semi-automated schema integration approach.

View PDFchevron_right
A Framework for Federated Database system for Autonomous Applications
Mohd Afzal

The system maps of federated database can change multiple autonomous database systems into a single federated database. A federated database system provides a logically integrated view of existing heterogeneous and distributed databases. A framework for federated database has to be done for the development of environmental databases. This article proposes the modern technical challenges associated with classification of environment and Federated technology based on levels of local and compound databases integration and the extent of services are offered by the federation, it also shows the overall system with local and federated database. More generally, the framework provides a step in the development of a new generation of guidance techniques such as local and federated database, schema integration, and data integration. Finally, the implications for practice and for further researches are discussed below.

View PDFchevron_right
A New Mechanism for the Interoperability of Data Systems
EDUARDO AMABLE SAMANIEGO MENA

Lecture Notes in Computer Science, 2004

View PDFchevron_right
Technology New - Federated approach expands database-access technology
David Geer

Computer, 2003

View PDFchevron_right
Federated management of information for TeleCARE
Hamideh Afsarmanesh

2004

Distributed information management plays a fundamental role within the base infrastructure supporting the elderly care domain. Specificities of this domain include the autonomy and independence of its involved actors, the critical data that is handled about individuals, and the variety of hardware/software resources supporting the elderly care environment. A federated information management system coping with these requirements is designed and integrated as a core component of a mobile agent-based infrastructure, to support collaborative networks for elderly care. Functionalities for: federated schema management, federated query processing, HW/SW resource management, specification and enforcement of visibility/access rights to data and resources, and an ontology-based automatic schema generation facility are introduced, and their implementation details are briefly discussed. resources information, error recovery, and cooperative problem-solving for teleassistance services, can be emphasized.

View PDFchevron_right
Methodology and Case Tools for the Development of Federated Databases
Jean-Marc Hick

International Journal of Cooperative Information Systems, 1999

Due to the current technological and economical context, there is an increasing need for cooperating information systems based on federated databases. Though the technical issues of these architectures have been studied for long, the way to build them has not triggered as much effort. This paper describes a general architecture, a methodology and a CASE environment intended to address the problem of providing users and programmers with an abstract interface to independent heterogeneous and distributed databases. The architecture comprises a hierarchy of mediators and a repository that dynamically transform actual data into a virtual homogeneous database and allow client applications to query it. The InterDB approach provides a complete methodology to define this architecture, including schema recovery through reverse engineering, database integration and mapping building. The methodology is supported by the DB-MAIN CASE tool that helps developers generate the mediators and their repository.

View PDFchevron_right
The integration of database systems
Fawzi Gherfal

Object-oriented …, 1995

View PDFchevron_right
Federated Autonomous Databases: project overview
Jaideep Srivastava

Proceedings RIDE-IMS `93: Third International Workshop on Research Issues in Data Engineering: Interoperability in Multidatabase Systems

This paper presents an overview of an ongoing research program, Federated Autonomous Databases, sponsored by Rome Laboratory (US Air Force) and conducted by Honeywell in collaboration with the University of Minnesota and Georgia Institute of Technology. This program is exploratory in nature and is aimed at understanding and solving, within the scope of the program definition, the problem of providing integrated access to distributed, heterogeneous and autonomous databases.

View PDFchevron_right

References (35)

  1. ARITEBOUL, S., AND HULL, R. IFO: A formal semantic database model. In Proceedings of the ACM SIGACT-SIGMOD Symposium on Principles of Database Systems (Apr. 1984). ACM, New York, pp. 119-132.
  2. BRODIE, M. L., MYLOPOULOS, J., AND SCHMIDT, J. W. (ED.). On Concept& Modelling. Springer- Verlag, 1984.
  3. BUNEMAN, P., AND FRANKEL, R. E. A functional query language. In Proceedings of the Znternn- tionul Conference on Manugement of Data (Boston, Mass., May 30-June 1, 1979). ACM, New York, pp. 52-57.
  4. CHAMBERLIN, D. D., GRAY, J. N., AND TRAIGER, I. L. Views, authorization, and locking in a ACM Transactions on Office Information Systems, Vol. 3, No. 3, July 1985. A Federated Architecture for Information Management l 277 relational database system. In Proceedings of the National Computer Conference (June 1975). AFIPS Press, Reston, Va., pp. 425-430.
  5. CLEMM, G. M. ODIN-An extensible software environment: Report and user's manual. CU- CS-262-84, Computer Science Dept., Univ. of Colorado, Boulder, Colo., March, 1984.
  6. CLEMM, G., HEIMBIGNER, D., OSTERWEIL, L., AND WILLIAMS, L. Keystone: A federated software environment. In ACM SIGPLAN Symposium on Programming Languages and Program- ming Environments (Seattle, Wash., May 1985). ACM, New York.
  7. DAYAL, U. AND BERNSTEIN, P. A. On the updatability of relational views. In Proceedings of the 4th International Conference on Very Large Databases (West Berlin, Sept. 1978). ACM, New York, pp. 368-377.
  8. GIBBS, S., AND TSICHRITIZIS, D. A data modelling approach for office information systems. ACM Trans. Office Znf. Syst. 1, 4 (Oct. 1983), 299-319.
  9. GRAY, J. N. Notes on data base operating systems. In Operating Systems: An Advanced Course, Lecture Notes in Computer Science, vol. 60. Springer Verlag, 1978, pp. 393-481.
  10. HAMMER, M., AND MCLEOD, D. On database management system architecture. In Znfotech State of the Art Report: Data Design, Infotech State of the Art Reports, vol. 8. Pergamon Infotech Limited, Maidenhead, United Kingdon, 1980, pp. 177-202.
  11. HAMMER, M., AND MCLEOD, D. Database description with SDM: A semantic database model. ACM Trans. Database Syst. 6,3 (Sept. 1981), 351-386.
  12. HEIMBIGNER, D. M. A federated architecture for database systems. Ph.D. dissertation, Univ. of Southern California, Los Angeles, Calif., Aug. 1982.
  13. HEIMBIGNER, D., AND MCLEOD, D. Federated information bases-A preliminary report. In Znfotech State of the Art Report: Database. Infotech State of the Art Reports, vol. 9. Pergamon Infotech Limited, Maidenhead, United Kingdom, 1981, pp. 383-410.
  14. KATZ, R., AND GOODMAN, N. View processing in multibase-A heterogeneous database system. In An Entity-Relationship Approach to Information Modelling and Analysis, ER Institute, 1981, pp. 259-280.
  15. KIMBLETON, S. R., WANG, P. S. C., AND FONG, E. XNDM: An experimental network data manager. In Proceedings of the Berkeley Workshop on Distributed Data Management and Com- puter Networks (Berkeley, Calif., Aug. 1979). Pp. 3-17.
  16. KIMBLETON, S. R., WOOD, H. M., AND FITZGERALD, M. L. Network operating systems-An implementation approach. In Proceedings of the National Computer Conference (June 1978), AFIPS Press, Arlington, Va., pp. 773-782.
  17. KING, R., AND MCLEOD, D. A database design methodology and tool for information systems. ACM Trans. Office Znf. Syst.1, 1 (Jan. 1985), pp. 2-21.
  18. KING., R., AND MCLEOD, D. Semantic database models. In Database Design, S. B. Yao, Ed. Prentice Hall, Englewood Cliffs, N.J., 1985.
  19. LIEN, Y. E., AND YING, J. H. Design of a distributed entity-relationship database system. In Proceedings of the International Computer Software and Applications Conference (Chicago, Nov. 1978). IEEE, New York, pp. 277-282.
  20. LINDSAY, B., AND SELINGER, P. G. Site autonomy issues in R*: A distributed database man- agement system. Res. Rep. RJ2927, IBM Research Lab, San Jose, Calif., Sept. 1980.
  21. LITWIN, W. A model for distributed data bases. In Proceedings of the ACM 2ndAnnual Louisiana Computer Exposition (Feb. 1980). ACM, New York, pp. l-36.
  22. LITWIN, W. Logical design of distributed data bases. MOD-1-043, INRIA, Paris, France, July 1981.
  23. LYNGBAEK, P., AND MCLEOD, D. Object sharing in distributed information systems. ACM Trans. Office Znf. Syst. 2, 2 (Apr. 1984), 96-122.
  24. MOSS, E. B. Nested transactions: An approach to reliable distributed computing. Ph.D. Disser- tation, Massachusetts Institute of Technology, Cambridge, Mass., Apr. 1981.
  25. MOTRO, A., AND BUNEMAN, P. Constructing superviews. In Proceedings of the ACM-SIGMOD International Conference on Management of Data (Ann Arbor, Mich., Apr. 1981), ACM, New York, pp. 56-64.
  26. MYLOPOULOS, J., BERNSTEIN, P. A., AND WONG, H. K. T. A language facility for designing database-intensive applications. ACM Trans. Database Syst. 5, 2 (June 1980), 185-207.
  27. NAVATHE, S. B. Schema analysis for database restructuring. ACM Trans. Database Syst. 5, 2 l D. Heimbigner and D. McLeod (June 1980), 157-184.
  28. OPPEN, D. C., AND YOGEN, Y. K. The clearinghouse: A decentralized agent for locating named objects in a distributed environment. ACM Trans. Office Znf. Syst. 1, 3 (July 1983), 230-253.
  29. ROTHNIE, J. B., JR., BERNSTEIN, P. A., Fox, S., GOODMAN, N., HAMMER, M., LANDERS, T. A., REEVE, C., SHIPMAN, D. W., AND WONG, E. Introduction to a system for distributed databases (SDD-1). ACM Trans. Database Syst. 5, 1 (Mar. 1980), 1-17.
  30. ROTHNIE, J. B., JR., AND GOODMAN, N. A survey of research and development in distributed database management. In Proceedings of the 3rd International Conference on Very Large Databases (Tokyo, Japan, Oct. 1977). IEEE, New York, pp. 48-62.
  31. ROWE, L. A., AND SHOENS, K. A. Data abstraction, views, and updates in Rigel. In Proceedings of the ACM-SZGMOD International Conference on Management of Data (Boston, May 1979).
  32. SHIPMAN, D. The functional data model and the the data language DAPLEX. ACM Trans. Database Syst. 2,3 (Mar. 1981), 140-173.
  33. SMITH, J. M., BERNSTEIN, P. A., DAYAL, U., GOODMAN, N., LANDERS, T., LIN, K. W. T., AND WONG, E. Multibase: Integrating heterogeneous distributed database systems. In Proceedings of the National Computer Conference (June 1981). AFIPS Press, Reston, Va., pp. 487-499.
  34. STONEBRAKER, M. R., AND NEUHOLD, E. A distributed database version of INGRES. In Proceedings of the Berkeley Workshop on Distributed Data Manugement and Computer Networks, (Berkeley, Calif., May 1977). University of California, Berkeley, pp. 19-36.
  35. TSICHRITZIS, D. C. Integrating data base and message systems. In Proceedings of the International Conference on Very Large Databases (Cannes, France, Sept. 1981). IEEE, New York, pp. 356- 362. Received December 1984; revised June 1985; accepted June 1985

Related papers

Federated information management for cooperative information
Hamideh Afsarmanesh

Neth Heart J, 1997

A new emerging area of research and technological development, set forward by the requirements of today's progressive industries is the paradigm of virtual organizations. A virtual organization, is primarily an interoperabte network of pre-existing enterprises with a common goal, where the enterprises can together function as a single real organization. This paradigm has the potential of representing the basic architecture needed in many multifaceted application domains. Early analysis of virtual organizations and their potential member organizations (nodes), identify a large number of main characteristics, and certain functional and information management requirements in this environment. Although the advanced Information Technology provides the necessary basic tools to support virtual organizations, there are many unresolved issues involved in the development of such cooperative architecture and system. This paper addresses many difficult issues in virtual organizations domain, but it mainly focuses on the management of information in this paradigm. Both the reference model tbr virtual organization's requirement specification, and the federated information management architecture that we claim to be essential for design of a system to support this paradigm, are the novel features presented in this paper.

View PDFchevron_right
Federated database systems for managing distributed, heterogeneous, and autonomous databases
deka prikitiuw

ACM Computing Surveys, 1991

A federated database system (FDBS) is a collection of cooperating database systems that are autonomous and possibly heterogeneous. In this paper, we define a reference architecture for distributed database management systems from system and schema viewpoints and show how various FDBS architectures can be developed. We then define a methodology for developing one of the popular architectures of an FDBS. Finally, we discuss critical issues related to developing and operating an FDBS.

View PDFchevron_right
Federated information systems: Concepts, terminology and architectures
Ralf-detlef Kutsche

1999

We are currently witnessing the emerging of a new generation of software systems: Federated information systems. Their main characteristic is that they are constructed as an integrating layer over existing legacy applications and databases. They can be broadly classified in three dimensions: the degree of autonomy they allow in integrated components, the degree of heterogeneity between components they can cope with, and whether or not they support distribution. Whereas the communication and interoperation problem has come into a stage of applicable solutions over the past decade, semantic data integration has not become similarly clear.

View PDFchevron_right
Design, Share and Re-use of Data and Applications into a Federate DataBase System
Thierry Millan

Le Centre pour la Communication Scientifique Directe - HAL - Université Paris Descartes, 1998

This paper presents an architecture to federate preexisting hospital databases. This solution relies on an oriented-object approach, persistence by reachability and a new MultiDataBase System (MDBS) architecture. The MDBS allows to develop global applications to exploit all the DataBase Management System (DBMS) resources distributed across the hospital network. However, the emergency of global applications should not disturb the preexisting local application. Furthermore, the MDBS provides data accessibility for preexisting applications. The MDBS is in charge to manage global transactions and to collect global data when no more used.

View PDFchevron_right
Engineering federated information systems
W. Hasselbring

ACM SIGMOD Record, 1999

After the successful rst International Workshop on Engineering Federated Database Systems EFDBS'97 in Barcelona in June 1997 CEH + 97 , the goal of this second workshop was to bring together researchers and practitioners interested in various issues in the development of federated information systems, whereby the scope has been extended to cover database and non-database information sources the change from EFDBS to EFIS re ects this. This report provides details of the workshop content and the conclusions reached in the nal discussion.

View PDFchevron_right

Related topics

  • Information Systems
  • Information Management
  • Library and Information Studies

    • Cited by

    Federated database systems for managing distributed, heterogeneous, and autonomous databases
    Evert Sandye Taasiringan

    ACM Computing Surveys, 1990

    A federated database system (FDBS) is a collection of cooperating database systems that are autonomous and possibly heterogeneous. In this paper, we define a reference architecture for distributed database management systems from system and schema viewpoints and show how various FDBS architectures can be developed. We then define a methodology for developing one of the popular architectures of an FDBS. Finally, we discuss critical issues related to developing and operating an FDBS.

    View PDFchevron_right
    MSQL: A Multidatabase Language
    Witold Litwin

    Information Sciences, 1989

    Many databases are now accessible through computer networks, and users frequently have data of interest in different databases. Manipulations of such data call for functions that do not exist in classical manipulation languages and database systems. A new type of data manipulation languages is needed, called multidatabase manipulation languages. We describe the multidatabase language MSQL, designed for the manipulation of data from different relational databases. MSQL is an extension of SQL, which has become the standard for relational database systems.

    View PDFchevron_right
    Foundations for the Arcadia environment architecture
    Michael Young

    Sigplan Notices, 1989

    Early software environments have supported a narrow range of activities (programming environments) or else been restricted to a single "hard-wired" software development process. The Arcadia research project is investigating the construction of software environments that are tightly integrated, yet flexible and extensible enough to support experimentation with alternative software processes and tools. This has led us to view an environment as being composed of two distinct., cooperating parts. One is the v&ant part, consisting of process programs and the tools and objects used and defined by those programs. The other is the fixed part, or infmstructure, supporting creation, execution, and change to the constituents of the variant part. The major components of the infrastructure are a process programming language and interpreter, object management system, and user interface management system. Process programming facilitates precise definition and automated support of software development and maintenance activities.

    View PDFchevron_right
    A rule-based approach for merging generalization hierarchies
    Michael Mannino

    Information Systems, 1988

    We describe the underlying operators and rules of an interactive procedure for merging generalization hierarchies. This procedure assists a designer in defining a global view which is a view over multiple databases.

    View PDFchevron_right
    Federated Stream Processing Support for Real-Time Business Intelligence Applications
    Laura Haas

    Lecture Notes in Business Information Processing, 2010

    In this paper, we describe the MaxStream federated stream processing architecture to support real-time business intelligence applications. MaxStream builds on and extends the SAP MaxDB relational database system in order to provide a federator over multiple underlying stream processing engines and databases. We show preliminary results on usefulness and performance of the MaxStream architecture on the SAP Sales and Distribution Benchmark.

    View PDFchevron_right
    580 California St., Suite 400
    San Francisco, CA, 94104
    © 2025 Academia. All rights reserved