KNOWLEDGE AND EXPERIENCE IN TEMPORAL DATABASE DESIGN
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.
Keywords
database, design, temporal database
Article Details
References
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.