KNOWLEDGE AND EXPERIENCE IN TEMPORAL DATABASE DESIGN

Hồng Ly Nguyễn

Main Article Content

Abstract

 

Limited research has been conducted on the application of temporal databases. The review of related literature shows that articles are mainly theoretical with few applications. Therefore, it is necessary to suggest detailed solutions so that individuals and organizations can easily and effectively apply them in building a database to ensure the completeness and accuracy of information.

This article shares information on a solution to build a database for a system that supports reporting and statistical templates and forms used in administrative agencies. It includes a database building process with steps, including the analysis of some common errors related to the "mechanical" application of design methods. At the same time, the paper proposes suitable solutions to improve the efficiency of database processing to meet different usage needs in practice.

 

 

 

Article Details

References

Gregersen, H., & Jensen, C. S.(1999). Temporal EntityRelationship Models – a Survey. IEEE, 11(3) 464-497.
Hoang, Q., & Nguyen, V. C.(2012). Mot cach tiep can trong viec thiet ke Co so du lieu Thoi gian [An approach to designing Temporal Database]. Hue University, 74A(5), 99-107.
Kurian, L.(2021). Bi-Temporal implementation inrelational databasemanagement systems: MS SQL Server. International Journal of Computer Science and Information Security (IJCSIS), 19(3).
Jensen, C. S, & Snodgrass, R. T. (1999). Temporal Data Management. IEEE Transactions on Knowledge and Data Engineering, 11(3), 464-497.