Translating relational conceptual schema to object-oriented schema
A multidatabase is a confederation of preexisting distributed, heterogeneous, and autonomous database system. The integration process is essential in the effort of forming a distributed, heterogeneous database system. This process generally consists of two main phases, which are conceptual schema...
Main Author: | |
---|---|
Format: | Thesis |
Language: | English English |
Published: |
2001
|
Subjects: | |
Online Access: | http://psasir.upm.edu.my/id/eprint/8668/1/FSKTM_2001_8%20IR.pdf |
_version_ | 1825944440437473280 |
---|---|
author | Soon, Lay Ki |
author_facet | Soon, Lay Ki |
author_sort | Soon, Lay Ki |
collection | UPM |
description | A multidatabase is a confederation of preexisting distributed, heterogeneous, and
autonomous database system. The integration process is essential in the effort of
forming a distributed, heterogeneous database system. This process generally
consists of two main phases, which are conceptual schema translation phase and
followed by the integration phase. In our research, we have proposed an alternative
translation approach to convert relational database schema to object--oriented
database schema.
The translation approach consists of a set of translation rules, which are based on
inclusion dependencies, key attributes and types of attributes. A database schema
translation tool prototype, called RETOO (Relational-to-Object-Oriented) is then
developed based on the proposed translation approach. RETOO receives a relational
database schema as input data and generate an object-oriented database schema as
the output data.RETOO operates semi-automatically, especially in the process of identifying
operations for each class. This is because relational data model does not provide the
behavioural information of every entity.
The translation approach and RETOO database translation tool prototype are not
only able to maintain the semantics of the relational database schema, but also
enhance the semantics of the translated object-oriented schema via object-oriented
data modelling concepts. |
first_indexed | 2024-03-06T07:15:54Z |
format | Thesis |
id | upm.eprints-8668 |
institution | Universiti Putra Malaysia |
language | English English |
last_indexed | 2024-03-06T07:15:54Z |
publishDate | 2001 |
record_format | dspace |
spelling | upm.eprints-86682023-12-26T01:12:26Z http://psasir.upm.edu.my/id/eprint/8668/ Translating relational conceptual schema to object-oriented schema Soon, Lay Ki A multidatabase is a confederation of preexisting distributed, heterogeneous, and autonomous database system. The integration process is essential in the effort of forming a distributed, heterogeneous database system. This process generally consists of two main phases, which are conceptual schema translation phase and followed by the integration phase. In our research, we have proposed an alternative translation approach to convert relational database schema to object--oriented database schema. The translation approach consists of a set of translation rules, which are based on inclusion dependencies, key attributes and types of attributes. A database schema translation tool prototype, called RETOO (Relational-to-Object-Oriented) is then developed based on the proposed translation approach. RETOO receives a relational database schema as input data and generate an object-oriented database schema as the output data.RETOO operates semi-automatically, especially in the process of identifying operations for each class. This is because relational data model does not provide the behavioural information of every entity. The translation approach and RETOO database translation tool prototype are not only able to maintain the semantics of the relational database schema, but also enhance the semantics of the translated object-oriented schema via object-oriented data modelling concepts. 2001-12 Thesis NonPeerReviewed text en http://psasir.upm.edu.my/id/eprint/8668/1/FSKTM_2001_8%20IR.pdf Soon, Lay Ki (2001) Translating relational conceptual schema to object-oriented schema. Masters thesis, Universiti Putra Malaysia. Relational databases Object-oriented databases English |
spellingShingle | Relational databases Object-oriented databases Soon, Lay Ki Translating relational conceptual schema to object-oriented schema |
title | Translating relational conceptual schema to object-oriented schema |
title_full | Translating relational conceptual schema to object-oriented schema |
title_fullStr | Translating relational conceptual schema to object-oriented schema |
title_full_unstemmed | Translating relational conceptual schema to object-oriented schema |
title_short | Translating relational conceptual schema to object-oriented schema |
title_sort | translating relational conceptual schema to object oriented schema |
topic | Relational databases Object-oriented databases |
url | http://psasir.upm.edu.my/id/eprint/8668/1/FSKTM_2001_8%20IR.pdf |
work_keys_str_mv | AT soonlayki translatingrelationalconceptualschematoobjectorientedschema |