From Object-Relational to Federated Databases

  • Nelson M. Mattos
  • Jim Kleewein
  • Mary Tork Roth
  • Kathryn Zeidenstein
Part of the Informatik aktuell book series (INFORMAT)


Object-relational databases allow users to manipulate rich data types that are not supported by traditional relational database systems. However, the majority of such data are in systems that are outside of that database—either in file systems, specialized systems, hierarchical databases, or other varieties of relational database that do not provide as rich a level of abstraction. Users want to take advantage of object-relational technology to exploit the rich semantics and abstraction but cannot afford to change existing applications or to move that data into the database to do so. The solution for enterprises is a federated database system, which allows users to leverage their existing applications and existing data, while allowing new applications to exploit the functional richness of object-relational technology.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [BM72]
    R. Bayer and E.M. McCreight. Organization and maintenance of large ordered indices. Acta Informatica, 1 (3): 173–189, 1972.CrossRefGoogle Scholar
  2. [CD96]
    M. Carey, D. DeWitt: Of Objects and Databases: A Decade of Turmoil. VLDB Conference 1996: pp. 3–14.Google Scholar
  3. [Ch98]
    W. Chen, J. Chow, Y. Fuh. M. Jou, N. Mattos, B. Tran, Y. Wang. UDS: An Extensible Architecture for User-Defined Search. submitted for publication.Google Scholar
  4. [Co79]
    D. Comer. The ubiquitous b-tree. ACM Computing Surveys, 2 (11): 121–137, 1979.CrossRefGoogle Scholar
  5. [CR93]
    P. Chrysanthis and K. Ramamritham. Impact of autonomy requirements on transactions and their management in heterogeneous distributed database systems. Proceedings of the DBTA Workshop on Interoperability of Database Systems and Database applications, 1993.Google Scholar
  6. [CR94a]
    P. Chrysanthis and K. Ramamritham. Autonomy requirements in heterogeneous distributed database systems. Proceedings of the conference on the Advances on Data Management, 1994.Google Scholar
  7. [FH98]
    F. de Ferreira Rezende and K. Hergula. The Heterogeneity Problem and Middleware Technology: Experiences with and Performance of Database Gateways. Proc. International Conference on Very Large Databases, pp. 146–157. New York, August, 1998.Google Scholar
  8. [Me198]
    Final Committee Draft Database Language SQL- Part 2: Foundation ( SQL/Foundation), by Jim Melton (ed. ), September 1998.Google Scholar
  9. [HM93]
    J. Hammer and D. McLeod. An approach to resolving semantic heterogeneity in a federation of autonomous, heterogeneous, database systems. Internation Journal of Intelligent and Cooperative Information Systems 2(1). PP 51–83, March 1993.CrossRefGoogle Scholar
  10. [Leung97]
    T.Y. Leung, H. Pirahesh, P. Seshadri, and J. Hellerstein. Query Rewrite Optimization Rules in IBM DB2 Universal Database. Readings in Database Systems, Third Edition. M. Stonebraker and J. Hellerstein (eds. ), 1997.Google Scholar
  11. [OV91]
    M. Tamer Özsu and P. Valduriez: Principles of Distributed Database Systems, Prentice Hall, p. 79, 1991.Google Scholar
  12. [Pir92]
    H. Pirahesh, J.M. Hellerstein, and W. Hasan. Extensible/Rule Based Query Rewrite Optimization in Starburst. Proc. ACM-SIGMOD International Conference on Management of Data, pp. 39–48, San Diego, June 1992.Google Scholar
  13. [Pir97]
    H. Pirahesh, T.Y. Leung, and W. Hasan. A Rule Engine for Query Transformation in Starburst and IBM DB2 C/S DBMS. IEEE Twelfth International Conference on Data Engineering, April 1997.Google Scholar
  14. [RS97]
    M. Tork Roth, P. Schwarz: Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources. VLDB Conference 1997, pp. 266–275.Google Scholar
  15. [SB98]
    M. Stonebraker, P. Brown, with D. Moore: Object-Relational DBMSs. Morgan Kaufmann Publishers, 1998.Google Scholar
  16. [SL90]
    A. Sheth and J. Larson. Federated database systems for managing distributed, heterogeneous, and autonomous databases. ACM Computing Surveys, 22 (3). pp. 183–236, Sept 1990.CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1999

Authors and Affiliations

  • Nelson M. Mattos
    • 1
  • Jim Kleewein
    • 1
  • Mary Tork Roth
    • 1
  • Kathryn Zeidenstein
    • 1
  1. 1.Santa Teresa LaboratoryIBM Database Common TechnologySan JoseUSA

Personalised recommendations