Deriving object oriented federated databases and processing federated queries

E. E Peng Lim, Jaideep Srivastava

Research output: Contribution to journalArticle

Abstract

In this paper, we present a federated query processing approach to evaluate queries on an Object-Oriented (OO) federated database. This approach has been designed and implemented in the OO-Myriad project, which is an OO extension to the Myriad FDBS research[1]. Since data integration is performed as part of federated query processing, we have proposed outerjoin, outer-difference and generalized attribute derivation operations together with the traditional relational operations, to be used for integration purposes. To define an OO federated database as a virtual view on multiple OO export databases, we adopt a database mapping strategy that systematically derives each of the class extents, deep class extents and relationships of the federated database using an operator tree consisting of the integration operations. By augmenting federated database queries with this algebraic mapping information, query execution plans can be generated. Based on the original Myriad query processing framework, we have realized the proposed OO federated query processing approach in the OO-Myriad prototype.

Original languageEnglish
Pages (from-to)5-30
Number of pages26
JournalJournal of Systems Integration
Volume8
Issue number1
Publication statusPublished - 1998
Externally publishedYes

Fingerprint

attribute
project
plan

Keywords

  • Database integration
  • Federated query processing
  • Object-oriented view

ASJC Scopus subject areas

  • Earth and Planetary Sciences(all)

Cite this

Deriving object oriented federated databases and processing federated queries. / Lim, E. E Peng; Srivastava, Jaideep.

In: Journal of Systems Integration, Vol. 8, No. 1, 1998, p. 5-30.

Research output: Contribution to journalArticle

@article{d282146168c449c9bab8f69ca2d16b37,
title = "Deriving object oriented federated databases and processing federated queries",
abstract = "In this paper, we present a federated query processing approach to evaluate queries on an Object-Oriented (OO) federated database. This approach has been designed and implemented in the OO-Myriad project, which is an OO extension to the Myriad FDBS research[1]. Since data integration is performed as part of federated query processing, we have proposed outerjoin, outer-difference and generalized attribute derivation operations together with the traditional relational operations, to be used for integration purposes. To define an OO federated database as a virtual view on multiple OO export databases, we adopt a database mapping strategy that systematically derives each of the class extents, deep class extents and relationships of the federated database using an operator tree consisting of the integration operations. By augmenting federated database queries with this algebraic mapping information, query execution plans can be generated. Based on the original Myriad query processing framework, we have realized the proposed OO federated query processing approach in the OO-Myriad prototype.",
keywords = "Database integration, Federated query processing, Object-oriented view",
author = "Lim, {E. E Peng} and Jaideep Srivastava",
year = "1998",
language = "English",
volume = "8",
pages = "5--30",
journal = "Journal of Systems Integration",
issn = "0925-4676",
publisher = "Kluwer Academic Publishers",
number = "1",

}

TY - JOUR

T1 - Deriving object oriented federated databases and processing federated queries

AU - Lim, E. E Peng

AU - Srivastava, Jaideep

PY - 1998

Y1 - 1998

N2 - In this paper, we present a federated query processing approach to evaluate queries on an Object-Oriented (OO) federated database. This approach has been designed and implemented in the OO-Myriad project, which is an OO extension to the Myriad FDBS research[1]. Since data integration is performed as part of federated query processing, we have proposed outerjoin, outer-difference and generalized attribute derivation operations together with the traditional relational operations, to be used for integration purposes. To define an OO federated database as a virtual view on multiple OO export databases, we adopt a database mapping strategy that systematically derives each of the class extents, deep class extents and relationships of the federated database using an operator tree consisting of the integration operations. By augmenting federated database queries with this algebraic mapping information, query execution plans can be generated. Based on the original Myriad query processing framework, we have realized the proposed OO federated query processing approach in the OO-Myriad prototype.

AB - In this paper, we present a federated query processing approach to evaluate queries on an Object-Oriented (OO) federated database. This approach has been designed and implemented in the OO-Myriad project, which is an OO extension to the Myriad FDBS research[1]. Since data integration is performed as part of federated query processing, we have proposed outerjoin, outer-difference and generalized attribute derivation operations together with the traditional relational operations, to be used for integration purposes. To define an OO federated database as a virtual view on multiple OO export databases, we adopt a database mapping strategy that systematically derives each of the class extents, deep class extents and relationships of the federated database using an operator tree consisting of the integration operations. By augmenting federated database queries with this algebraic mapping information, query execution plans can be generated. Based on the original Myriad query processing framework, we have realized the proposed OO federated query processing approach in the OO-Myriad prototype.

KW - Database integration

KW - Federated query processing

KW - Object-oriented view

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

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

M3 - Article

AN - SCOPUS:0032025691

VL - 8

SP - 5

EP - 30

JO - Journal of Systems Integration

JF - Journal of Systems Integration

SN - 0925-4676

IS - 1

ER -