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...

Full description

Saved in:
Bibliographic Details
Main Author: Soon, Lay Ki
Format: Thesis
Language:English
English
Published: 2001
Subjects:
Online Access:http://psasir.upm.edu.my/id/eprint/8668/1/FSKTM_2001_8%20IR.pdf
Tags: Add Tag
No Tags, Be the first to tag this record!
id my-upm-ir.8668
record_format uketd_dc
spelling my-upm-ir.86682023-12-26T01:12:26Z Translating relational conceptual schema to object-oriented schema 2001-12 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. Relational databases Object-oriented databases 2001-12 Thesis http://psasir.upm.edu.my/id/eprint/8668/ http://psasir.upm.edu.my/id/eprint/8668/1/FSKTM_2001_8%20IR.pdf text en public masters Universiti Putra Malaysia Relational databases Object-oriented databases Faculty of Computer Science and Information Technology Ibrahim, Hamidah English
institution Universiti Putra Malaysia
collection PSAS Institutional Repository
language English
English
advisor Ibrahim, Hamidah
topic Relational databases
Object-oriented databases

spellingShingle Relational databases
Object-oriented databases

Soon, Lay Ki
Translating relational conceptual schema to object-oriented schema
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.
format Thesis
qualification_level Master's degree
author Soon, Lay Ki
author_facet Soon, Lay Ki
author_sort Soon, Lay Ki
title Translating relational conceptual schema to object-oriented schema
title_short 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_sort translating relational conceptual schema to object-oriented schema
granting_institution Universiti Putra Malaysia
granting_department Faculty of Computer Science and Information Technology
publishDate 2001
url http://psasir.upm.edu.my/id/eprint/8668/1/FSKTM_2001_8%20IR.pdf
_version_ 1794018769635377152