Myriad: Design and implementation of a federated database prototype

Ee‐Peng ‐P Lim, San‐Yih ‐Y Hwang, Jaideep Srivastava, Dave Clements, M. Ganesh

Research output: Contribution to journalArticle

9 Citations (Scopus)

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.

Original languageEnglish
Pages (from-to)533-562
Number of pages30
JournalSoftware: Practice and Experience
Volume25
Issue number5
DOIs
Publication statusPublished - May 1995

    Fingerprint

Keywords

  • enterprise integration
  • federated database
  • query processing
  • schema integration
  • transaction management

ASJC Scopus subject areas

  • Software

Cite this