@article{ART001709873},
author={YIM JIN HEE and Daewook Lee and 김은실 and Kim Iek Han},
title={Directions for Developing Database Schema of Records in Archives Management Systems},
journal={The Korean Journal of Archival Studies},
issn={1229-7941},
year={2012},
number={34},
pages={57-105}
TY - JOUR
AU - YIM JIN HEE
AU - Daewook Lee
AU - 김은실
AU - Kim Iek Han
TI - Directions for Developing Database Schema of Records in Archives Management Systems
JO - The Korean Journal of Archival Studies
PY - 2012
VL - null
IS - 34
PB - Korean Society Of Archival Studies
SP - 57
EP - 105
SN - 1229-7941
AB - The CAMS(Central Archives Management System) of NAK(National Archives of Korea) is an important system which receives and manages large amount of electronic records annually from 2015. From the point of view in database design, this paper analyzes the database schema of CAMS and discusses the direction of overall improvement of the CAMS.
Firstly this research analyzes the tables for records and folders in the CAMS database which are core tables for the electronic records management. As a result, researchers notice that it is difficult to trust the quality of the records in the CAMS, because two core tables are entirely not normalized and have many columns whose roles are unknown.
Secondly, this study suggests directions of normalization for the tables for records and folders in the CAMS database like followings: First, redistributing the columns into proper tables to reduce the duplication. Second, separating the columns about the classification scheme into separate tables. Third, separating the columns about the records types and sorts into separate tables. Lastly, separating metadata information related to the acquisition, takeover and preservation into separate tables.
Thirdly, this paper suggests considerations to design and manage the database schema in each phase of archival management. In the ingest phase, the system should be able to process large amount of records as batch jobs in time annually. In the preservation phase, the system should be able to keep the management histories in the CAMS as audit trails including the reclassification, revaluation, and preservation activities related to the records. In the access phase, the descriptive metadata sets for the access should be selected and confirmed in various ways.
Lastly, this research also shows the prototype of conceptual database schema for the CAMS which fulfills the metadata standards for records.
KW - Electronic Records Management;Archives Managemetn System;Database Design for Records;Conceptual Schema for Records;Entity Relationship Model for Records
DO -
UR -
ER -
YIM JIN HEE, Daewook Lee, 김은실 and Kim Iek Han. (2012). Directions for Developing Database Schema of Records in Archives Management Systems. The Korean Journal of Archival Studies, 34, 57-105.
YIM JIN HEE, Daewook Lee, 김은실 and Kim Iek Han. 2012, "Directions for Developing Database Schema of Records in Archives Management Systems", The Korean Journal of Archival Studies, no.34, pp.57-105.
YIM JIN HEE, Daewook Lee, 김은실, Kim Iek Han "Directions for Developing Database Schema of Records in Archives Management Systems" The Korean Journal of Archival Studies 34 pp.57-105 (2012) : 57.
YIM JIN HEE, Daewook Lee, 김은실, Kim Iek Han. Directions for Developing Database Schema of Records in Archives Management Systems. 2012; 34 : 57-105.
YIM JIN HEE, Daewook Lee, 김은실 and Kim Iek Han. "Directions for Developing Database Schema of Records in Archives Management Systems" The Korean Journal of Archival Studies no.34(2012) : 57-105.
YIM JIN HEE; Daewook Lee; 김은실; Kim Iek Han. Directions for Developing Database Schema of Records in Archives Management Systems. The Korean Journal of Archival Studies, 34, 57-105.
YIM JIN HEE; Daewook Lee; 김은실; Kim Iek Han. Directions for Developing Database Schema of Records in Archives Management Systems. The Korean Journal of Archival Studies. 2012; 34 57-105.
YIM JIN HEE, Daewook Lee, 김은실, Kim Iek Han. Directions for Developing Database Schema of Records in Archives Management Systems. 2012; 34 : 57-105.
YIM JIN HEE, Daewook Lee, 김은실 and Kim Iek Han. "Directions for Developing Database Schema of Records in Archives Management Systems" The Korean Journal of Archival Studies no.34(2012) : 57-105.
