Data integration through database federation

  • Authors:
  • L. M. Haas;E. T. Lin;M. A. Roth

  • Affiliations:
  • IBM Software Group, Silicon Valley Laboratory, 555 Bailey Avenue, San Jose, California 95141;IBM Software Group, Silicon Valley Laboratory, 555 Bailey Avenue, San Jose, California 95141;IBM Software Group, Silicon Valley Laboratory, 555 Bailey Avenue, San Jose, California 95141

  • Venue:
  • IBM Systems Journal
  • Year:
  • 2002

Quantified Score

Hi-index 0.00

Visualization

Abstract

In a large modern enterprise, it is almost inevitable that different parts of the organization will use different systems to produce, store, and search their critical data. Yet, it is only by combining the information from these various systems that the enterprise can realize the full value of the data they contain. Database federation is one approach to data integration in which middleware, consisting of a relational database management system, provides uniform access to a number of heterogeneous data sources. In this paper, we describe the basics of database federation, introduce several styles of database federation, and outline the conditions under which each style of federation should be used. We discuss the benefits of an information integration solution based on database technology, and we demonstrate the utility of the database federation approach through a number of usage scenarios involving IBM's DB2 product.