Extraction of a temporal conceptual model from a relational database. (1st January 2013)

• Record Type: Journal Article
• Authors: Hoang, Quang; Nguyen, Van Toan
• Is Part Of: International journal of intelligent information and database systems. Volume 7:Number 4(2013)
• Page Start: 340
• Page End: 355
• Publication Date: 2013-01-01
• Subjects: conceptual modelling -- entity-relationship model, database reverse engineering -- temporal database design -- temporal conceptual schema -- relational model; Database management -- Computer programs -- Periodicals; Information retrieval -- Computer programs -- Periodicals; Information storage and retrieval systems -- Computer programs -- Periodicals; Artificial intelligence -- Periodicals; Expert systems (Computer science) -- Periodicals; Intelligent agents (Computer software) -- Periodicals; 006.33
• Languages: English
• ISSNs: 1751-5858

Abstract

Related to the problem of temporal database design, a relational target model has been designed from a temporal conceptual model. Extraction of the temporal conceptual model from a relational model is called the reverse engineering of the relational model. Solving this problem will facilitate an upgraded temporal information system. In this research, we construct a conceptual model which has been used to design the temporal relational model. This approach of extraction is based on characteristics of the set of attributes, the primary key, and the set of foreign keys of the relational schema in the temporal relational model. Thereby, we propose conversion rules relating to the identification of the components existing within the temporal conceptual model accordingly.