Publication Type
Journal Article
Version
publishedVersion
Publication Date
5-1995
Abstract
A key problem in providing enterprise-wide information is the integration of databases that have been independently developed. An important requirement is to accommodate heterogeneity and maintain the autonomy of component databases. Myriad is a federated database prototype developed at the University of Minnesota, to provide a testbed for investigating alternatives in architecture and algorithms for database integration, query processing and optimization, and concurrency control and recovery. The system incorporates our group's research results in these areas. This paper describes our experiences in the design and implementation of Myriad, and in the project management. Special emphasis is given to discussing design alternatives and their impact on Myriad. This paper also presents the software engineering principles and the project management techniques we used in developing Myriad and the lessons we learned. We believe these lessons would be useful for practitioners who wish to develop a similar system. Handling heterogeneity and autonomy were prime objectives throughout the prototyping effort. We are convinced that a prototype federated database is an important infrastructural requirement for the overall goal of ‘enterprise-integration’, and believe Myriad to be a significant contribution towards this.
Keywords
Enterprise integration, federated database, schema integration, query processing, transaction management
Discipline
Databases and Information Systems
Research Areas
Data Science and Engineering
Publication
Software: Practice and Experience
Volume
25
Issue
5
First Page
553
Last Page
562
ISSN
0038-0644
Identifier
10.1002/spe.4380250505
Publisher
Wiley
Citation
LIM, Ee Peng; HWANG, San-Yih; SRIVASTAVA, Jaideep; CLEMENTS, Dave; and GANESH, M..
Myriad: Design and implementation of a federated database prototype. (1995). Software: Practice and Experience. 25, (5), 553-562.
Available at: https://ink.library.smu.edu.sg/sis_research/7
Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-No Derivative Works 4.0 International License.
Additional URL
https://doi.org/10.1002/spe.4380250505