Extraction of a temporal conceptual model from a relational database
Quang Hoang, Van Toan Nguyen
Abstract
Quang Hoang, Van Toan Nguyen
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.
OpenAlex reports 3 citations for this work. Citation counts describe recorded attention and do not establish research quality.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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.
Key concepts: Computer science, Conceptual schema, Relational model, Relational database, Conceptual model, Entity–relationship model, Temporal database, Database model