Title: Extraction of a temporal conceptual model from a relational database

Authors: Quang Hoang; Van Toan Nguyen

Addresses: Department of Information Technology, College of Sciences, Hue University, 77 Nguyen Hue Street, Hue, Vietnam ' Department of Information Technology, Pham Van Dong University, 986 Quang Trung Street, Quang Ngai, Vietnam

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.

Keywords: conceptual modelling; entity-relationship models; database reverse engineering; temporal database design; temporal conceptual schema; relational modelling; relational databases; temporal information systems.

DOI: 10.1504/IJIIDS.2013.056315

International Journal of Intelligent Information and Database Systems, 2013 Vol.7 No.4, pp.340 - 355

Received: 19 Dec 2011
Accepted: 18 Jan 2013

Published online: 10 Sep 2013 *

Full-text access for editors Access for subscribers Purchase this article Comment on this article