Developing Translation Rules for Converting Relational to Object Oriented Database Conceptual Schema
A multidatabase is a confederation of pre-existing distributed, heterogeneous, and autonomous database system. Obviously, 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 conce...
| Main Authors: | , , , |
|---|---|
| Format: | Article |
| Language: | English English |
| Published: |
Universiti Putra Malaysia Press
2005
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/3844/ http://psasir.upm.edu.my/id/eprint/3844/1/Pages_from_JST_VOL_13_NO._1.pdf |
| _version_ | 1848839645408788480 |
|---|---|
| author | Ibrahim, Hamidah Ki, Soon Lay Mamat, Ali Muda, Zaiton |
| author_facet | Ibrahim, Hamidah Ki, Soon Lay Mamat, Ali Muda, Zaiton |
| author_sort | Ibrahim, Hamidah |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | A multidatabase is a confederation of pre-existing distributed, heterogeneous,
and autonomous database system. Obviously, 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 followed by the integration phase. This paper presents a
translation approach to convert relational database schema to object-oriented
database schema. The translation approach consists of a set of translation rules,
which is based on inclusion dependencies, key attributes and types of attributes.
A database schema translation tool prototype, called RETOO (RElational-ToObject-
Qriented) is then developed based on the proposed translation approach.
RETOO receives a relational database schema as input data and generates an
object-oriented database schema as the output. The translation approach is not
only able to maintain the semantics of the relational database schema, but also
enhance the semantics of the translated object-oriented schema via objectoriented
data modeling concepts. |
| first_indexed | 2025-11-15T07:14:44Z |
| format | Article |
| id | upm-3844 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English English |
| last_indexed | 2025-11-15T07:14:44Z |
| publishDate | 2005 |
| publisher | Universiti Putra Malaysia Press |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-38442013-05-27T07:11:42Z http://psasir.upm.edu.my/id/eprint/3844/ Developing Translation Rules for Converting Relational to Object Oriented Database Conceptual Schema Ibrahim, Hamidah Ki, Soon Lay Mamat, Ali Muda, Zaiton A multidatabase is a confederation of pre-existing distributed, heterogeneous, and autonomous database system. Obviously, 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 followed by the integration phase. This paper presents a translation approach to convert relational database schema to object-oriented database schema. The translation approach consists of a set of translation rules, which is based on inclusion dependencies, key attributes and types of attributes. A database schema translation tool prototype, called RETOO (RElational-ToObject- Qriented) is then developed based on the proposed translation approach. RETOO receives a relational database schema as input data and generates an object-oriented database schema as the output. The translation approach is not only able to maintain the semantics of the relational database schema, but also enhance the semantics of the translated object-oriented schema via objectoriented data modeling concepts. Universiti Putra Malaysia Press 2005 Article NonPeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/3844/1/Pages_from_JST_VOL_13_NO._1.pdf Ibrahim, Hamidah and Ki, Soon Lay and Mamat, Ali and Muda, Zaiton (2005) Developing Translation Rules for Converting Relational to Object Oriented Database Conceptual Schema. Pertanika Journal of Science & Technology, 13 (1). pp. 1-21. ISSN 0128-7680 English |
| spellingShingle | Ibrahim, Hamidah Ki, Soon Lay Mamat, Ali Muda, Zaiton Developing Translation Rules for Converting Relational to Object Oriented Database Conceptual Schema |
| title | Developing Translation Rules for Converting Relational
to Object Oriented Database Conceptual Schema |
| title_full | Developing Translation Rules for Converting Relational
to Object Oriented Database Conceptual Schema |
| title_fullStr | Developing Translation Rules for Converting Relational
to Object Oriented Database Conceptual Schema |
| title_full_unstemmed | Developing Translation Rules for Converting Relational
to Object Oriented Database Conceptual Schema |
| title_short | Developing Translation Rules for Converting Relational
to Object Oriented Database Conceptual Schema |
| title_sort | developing translation rules for converting relational
to object oriented database conceptual schema |
| url | http://psasir.upm.edu.my/id/eprint/3844/ http://psasir.upm.edu.my/id/eprint/3844/1/Pages_from_JST_VOL_13_NO._1.pdf |