English (United Kingdom)

https://curated-unify.zendy.io/wp-json/zendy-region/v1/featured_content/oa?rat=en

https://curated-unify.zendy.io/wp-json/zendy-region/v1/highlighted_journal/

Global: Zendy Plus annual

Presents the access of premium content as premium feature

Premium Content

Presents the keyphrase highlighting as premium feature

Keyphrase Highlighting

Presents the summarisation as premium feature

Summarisation

Insights

Presents the pdf analysis as premium feature

PDF Analysis

Presents the zaia usage as premium feature

ZAIA

Global: Zendy Tools annual

Global: Zendy Free Plan

Global: Zendy Tools monthly

Global: Zendy Plus monthly

The emergence of object-relational database (ORDB) technology into the commercial database market has caused the database professional’s attention in seeking how to utilize its object-oriented features in the database development. Although the ORDB technology is already available for use in all the major DBMS products, its industrial adoption rate is relatively low. The purpose of the paper is to promote utilization of ORDBMS features in for industrial database application practitioners and provide them the solutions to the problems in their database development. The goal of the paper is to present how to use the object-relational database management system (ORDBMS) to overcome relational database (RDB) existing problems and improve database performance in the database development using features of ORDB technology. The paper introduces how to use the specific ORDB technology to solve normalization problems in 1) Transitive dependency, 2) Multi-value attributes, and 3) Non-1st Normal Form and also provides the solutions to data complexity problems with specific ORDBMS techniques: 1) object view, 2) object inheritance, and 3) object and integration. The paper concludes with a summary and discussion of significance and advantages of using ORDBMSs to solve the problems in the database development. The author utilizes Oracle as a tool to demonstrate how to overcome some weaknesses of relational DBMS. The ORDBMS script in the study has been tested in the Oracle 9i, 10g, and 11g environment.

USING OBJECT-RELATIONAL DATABASE TECHNOLOGY TO SOLVE PROBLEMS IN DATABASE DEVELOPMENT