A Case Study of Using an Object-Relational Paradigm in Building a Web Database Application

In this paper, we would like to share our experiences in building a web database application using an object-relational paradigm. The system we built is basically an online system for casual tutors to claim their work for payment. At the design stage, we use an object-oriented design. Since the dat...

Full description

Bibliographic Details
Main Authors: Rahayu, J. Wenny, Taniar, David, Lee, Nung Kion, Pardede, Eric
Format: Article
Language:English
Published: International Society for Computers and Their Applications (ISCA) 2003
Subjects:
Online Access:http://ir.unimas.my/id/eprint/11908/
http://ir.unimas.my/id/eprint/11908/1/A%20Case%20Study_abstract.pdf
_version_ 1848837086222745600
author Rahayu, J. Wenny
Taniar, David
Lee, Nung Kion
Pardede, Eric
author_facet Rahayu, J. Wenny
Taniar, David
Lee, Nung Kion
Pardede, Eric
author_sort Rahayu, J. Wenny
building UNIMAS Institutional Repository
collection Online Access
description In this paper, we would like to share our experiences in building a web database application using an object-relational paradigm. The system we built is basically an online system for casual tutors to claim their work for payment. At the design stage, we use an object-oriented design. Since the database backend is a relational database management system (i.e. Oracle), which also supports some object-oriented features, we need to apply a transformation methodology to map our object-oriented design into relational tables incorporating some object features in Oracle. Once the necessary object types and tables have been created, at the programming stage we use a PHP scripting language accessing the Oracle database where the data is stored.
first_indexed 2025-11-15T06:34:04Z
format Article
id unimas-11908
institution Universiti Malaysia Sarawak
institution_category Local University
language English
last_indexed 2025-11-15T06:34:04Z
publishDate 2003
publisher International Society for Computers and Their Applications (ISCA)
recordtype eprints
repository_type Digital Repository
spelling unimas-119082016-05-12T00:57:58Z http://ir.unimas.my/id/eprint/11908/ A Case Study of Using an Object-Relational Paradigm in Building a Web Database Application Rahayu, J. Wenny Taniar, David Lee, Nung Kion Pardede, Eric L Education (General) T Technology (General) In this paper, we would like to share our experiences in building a web database application using an object-relational paradigm. The system we built is basically an online system for casual tutors to claim their work for payment. At the design stage, we use an object-oriented design. Since the database backend is a relational database management system (i.e. Oracle), which also supports some object-oriented features, we need to apply a transformation methodology to map our object-oriented design into relational tables incorporating some object features in Oracle. Once the necessary object types and tables have been created, at the programming stage we use a PHP scripting language accessing the Oracle database where the data is stored. International Society for Computers and Their Applications (ISCA) 2003 Article NonPeerReviewed text en http://ir.unimas.my/id/eprint/11908/1/A%20Case%20Study_abstract.pdf Rahayu, J. Wenny and Taniar, David and Lee, Nung Kion and Pardede, Eric (2003) A Case Study of Using an Object-Relational Paradigm in Building a Web Database Application. Journal of Computers and their Applications, 10 (3). ISSN 1076-5204 http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.59.8301&rep=rep1&type=pdf
spellingShingle L Education (General)
T Technology (General)
Rahayu, J. Wenny
Taniar, David
Lee, Nung Kion
Pardede, Eric
A Case Study of Using an Object-Relational Paradigm in Building a Web Database Application
title A Case Study of Using an Object-Relational Paradigm in Building a Web Database Application
title_full A Case Study of Using an Object-Relational Paradigm in Building a Web Database Application
title_fullStr A Case Study of Using an Object-Relational Paradigm in Building a Web Database Application
title_full_unstemmed A Case Study of Using an Object-Relational Paradigm in Building a Web Database Application
title_short A Case Study of Using an Object-Relational Paradigm in Building a Web Database Application
title_sort case study of using an object-relational paradigm in building a web database application
topic L Education (General)
T Technology (General)
url http://ir.unimas.my/id/eprint/11908/
http://ir.unimas.my/id/eprint/11908/
http://ir.unimas.my/id/eprint/11908/1/A%20Case%20Study_abstract.pdf