Federated Databases and Systems: Part II - A Tutorial on Their Resource Consolidation.

David K. Hsiao: Federated Databases and Systems: Part II - A Tutorial on Their Resource Consolidation. VLDB J. 1(2): 285-310(1992)
  author    = {David K. Hsiao},
  title     = {Federated Databases and Systems: Part II - A Tutorial on Their
               Resource Consolidation},
  journal   = {VLDB J.},
  volume    = {1},
  number    = {2},
  year      = {1992},
  pages     = {285-310},
  ee        = {db/journals/vldb/Hsiao92a.html},
  bibsource = {DBLP,}


The issues and solutions for the interoperabilty of a class of heterogeneous databases and their database systems are expounded in two parts. Part I presented the data-sharing issues in federated databases and systems. The present article explores resource-consolidation issues. Interoperability in this context refers to data sharing among heterogeneous databases, and to resource consolidation of computer hardware, system software, and support personnel. Resource consolidation requires the presence of a database system architecture which supports the heterogeneous system software, thereby eliminating the need for various computer hardware and support personnel. The class of heterogeneous databases and database systems expounded herein is termed federated, meaning that they are joined in order to meet certain organizational requirements and because they require their respective application specificities, integrity constraints, and security requirements to be upheld. Federated databases and systems are new. While there are no technological solutions, there has been considerable research towards their development. This tutorial is aimed at exposing the need for such solutions. A taxonomy is introduced in our review of existing research undertakings and exploratory developments. With this taxonomy, we contrast and compare various approaches to federating databases and systems.

Copyright © 1992 by the VLDB Endowment. Permission to copy without fee all or part of this material is granted provided that the copies are not made or distributed for direct commercial advantage, the VLDB copyright notice and the title of the publication and its date appear, and notice is given that copying is by the permission of the Very Large Data Base Endowment. To copy otherwise, or to republish, requires a fee and/or special permission from the Endowment.

Key Words

Interoperability of heterogeneous databases and systems (attribute-based, hierarchical, network, relational, object-oriented); data-sharing techniques (database conversion, schema transformation, transaction translation, data-model-and-language-to-data-model-and-language mappings).

Online Paper

ACM SIGMOD Anthology

CDROM Version: Load the CDROM "Volume 4 Issue 1, Books, VLDB-j, TODS, ..." and ... DVD Version: Load ACM SIGMOD Anthology DVD 2" and ... BibTeX


[Demurjian et al. 1985]
Steven A. Demurjian, David K. Hsiao, Roger G. Marshall: The Architectural Requirements and Integration Analyses of a Database Server for Office Automation. ACM Annual Conference - The range of computing: mid-80's perspective 1985: 121-131 BibTeX
[Demurjian et al. 1986a]
[Demurjian et al. 1987]
[Demurjian et al. 1986b]
Steven A. Demurjian, David K. Hsiao, Jai Menon: A Multi-Backend Database System for Performance Gains, Capacity Growth and Hardware Upgrade. ICDE 1986: 542-554 BibTeX
[Hall 1989]
[Hall et al. 1990]
[Hsiao 1991]
[Hsiao 1992]
David K. Hsiao: Federated Databases and Systems: Part I - A Tutorial on Their Data Sharing. VLDB J. 1(1): 127-179(1992) BibTeX
[Hsiao 1987]
David K. Hsiao: The Impact of the Interconnecting Network on Parallel Database Computers. IWDM 1987: 216-224 BibTeX
[Hsiao & Kamel 1991]
[Hurson et al. 1989]
Ali R. Hurson, Les L. Miller, Simin H. Pakzad, Margaret H. Eich, Behrooz Shirazi: Parallel Architectures for Database Systems. Advances in Computers 28: 107-151(1989) BibTeX

Referenced by

  1. Stanley Y. W. Su, Herman Lam, Javier A. Arroyo-Figueroa, Tsae-Feng Yu, Zhidong Yang: An Extensible Knowledge Base Management System for Supporting Rule-based Interoperability among Heterogeneous Systems. CIKM 1995: 1-10
ACM SIGMOD Anthology - DBLP: [Home | Search: Author, Title | Conferences | Journals]
VLDB Journal: 1992-1995 Copyright © by VLDB Endowment / 1996-... Copyright © by Springer Verlag,
ACM SIGMOD Anthology: Copyright © by ACM (, Corrections:
DBLP: Copyright © by Michael Ley (, last change: Sun May 17 00:31:17 2009