ScholarLens Back to search
2004•Unpublished venueRequires access

A Temporal Relational and Object Relational Database Design Technique

Putsadee Pornphol, Suphamit Chittayasothorn

Open publisher page 4 citations

Abstract

The NIAM (Nijssen’s Information Analysis Methodology) conceptual schema model was originated in the 1970s and later became more popular under a new name ORM (Object Role Model). It is a fact-based conceptual schema model that can be represented by graphical diagrams or described by a formal natural language. Since all relationship types are elementary, they cannot be further decomposed. This property enables the ORM conceptual schema diagram to be transformed into 5NF relational database schemas. This paper presents temporal database application development using TORM, a temporal extension to the ORM conceptual schema model. The notions of valid time and life span are introduced to the entity type and fact type concepts. An implementation of a TORM conceptual schema on relational and object relational database schemas are also presented.

About this research paper

What this paper is about

The NIAM (Nijssen’s Information Analysis Methodology) conceptual schema model was originated in the 1970s and later became more popular under a new name ORM (Object Role Model). It is a fact-based conceptual schema model that can be represented by graphical diagrams or described by a formal natural language. Since all relationship types are elementary, they cannot be further decomposed. This property enables the ORM conceptual schema diagram to be transformed into 5NF relational database schemas. This paper presents temporal database application development using TORM, a temporal extension to the ORM conceptual schema model. The notions of valid time and life span are introduced to the entity type and fact type concepts. An implementation of a TORM conceptual schema on relational and object relational database schemas are also presented.

Why it matters

OpenAlex reports 4 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

The NIAM (Nijssen’s Information Analysis Methodology) conceptual schema model was originated in the 1970s and later became more popular under a new name ORM (Object Role Model). It is a fact-based conceptual schema model that can be represented by graphical diagrams or described by a formal natural language. Since all relationship types are elementary, they cannot be further decomposed. This property enables the ORM conceptual schema diagram to be transformed into 5NF relational database schemas. This paper presents temporal database application development using TORM, a temporal extension to the ORM conceptual schema model. The notions of valid time and life span are introduced to the entity type and fact type concepts. An implementation of a TORM conceptual schema on relational and object relational database schemas are also presented.

Key concepts: Conceptual schema, Semi-structured model, Computer science, Database schema, Entity–relationship model, Database design, Schema migration, Database model

Related papers

Related paper 1Related paper 2Related paper 3
Back to paper searchBrowse research topicsOriginal source
A Temporal Relational and Object Relational Database Design Technique — Research Paper | ScholarLens