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 - 1995
Externally publishedYes

Fingerprint

Project management
Concurrency control
Query processing
Testbeds
Software engineering
Recovery

Keywords

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

ASJC Scopus subject areas

  • Software

Cite this

Myriad : Design and implementation of a federated database prototype. / Lim, Ee‐Peng ‐P; Hwang, San‐Yih ‐Y; Srivastava, Jaideep; Clements, Dave; Ganesh, M.

In: Software - Practice and Experience, Vol. 25, No. 5, 1995, p. 533-562.

Research output: Contribution to journalArticle

Lim, Ee‐Peng ‐P ; Hwang, San‐Yih ‐Y ; Srivastava, Jaideep ; Clements, Dave ; Ganesh, M. / Myriad : Design and implementation of a federated database prototype. In: Software - Practice and Experience. 1995 ; Vol. 25, No. 5. pp. 533-562.
@article{25dd57c7dc3246c3aed8e79a56a63c77,
title = "Myriad: Design and implementation of a federated database prototype",
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, query processing, schema integration, transaction management",
author = "Lim, {Ee‐Peng ‐P} and Hwang, {San‐Yih ‐Y} and Jaideep Srivastava and Dave Clements and M. Ganesh",
year = "1995",
doi = "10.1002/spe.4380250505",
language = "English",
volume = "25",
pages = "533--562",
journal = "Software - Practice and Experience",
issn = "0038-0644",
publisher = "John Wiley and Sons Ltd",
number = "5",

}

TY - JOUR

T1 - Myriad

T2 - Design and implementation of a federated database prototype

AU - Lim, Ee‐Peng ‐P

AU - Hwang, San‐Yih ‐Y

AU - Srivastava, Jaideep

AU - Clements, Dave

AU - Ganesh, M.

PY - 1995

Y1 - 1995

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

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

KW - enterprise integration

KW - federated database

KW - query processing

KW - schema integration

KW - transaction management

UR - http://www.scopus.com/inward/record.url?scp=84987189188&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84987189188&partnerID=8YFLogxK

U2 - 10.1002/spe.4380250505

DO - 10.1002/spe.4380250505

M3 - Article

VL - 25

SP - 533

EP - 562

JO - Software - Practice and Experience

JF - Software - Practice and Experience

SN - 0038-0644

IS - 5

ER -