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.
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 *