Browse > Article
http://dx.doi.org/10.14374/HFS.2017.25.1.39

A study on the database structure of medical records - Focusing on Yakazudōmei's medical records -  

Kim, Sung-Won (Department of Medical Classics & History, College of Korean Medicine, Dongguk University)
Kim, Ki-Wook (Department of Medical Classics & History, College of Korean Medicine, Dongguk University)
Lee, Byung-Wook (Department of Medical Classics & History, College of Korean Medicine, Dongguk University)
Publication Information
Herbal Formula Science / v.25, no.1, 2017 , pp. 39-49 More about this Journal
Abstract
Objectives : The contents of the literature associated with the medical records were entered into the database. We want to find the structure and search methods for efficient utilization of the database. Methods : The contents were entered into the database using the 'Access 2014 of the MS'. The Query Sentences were created and utilized for a search. Results : We could find information about the prescriptions, medical records and patients by the herbs and symptom combinations using the single table named 'Integrated Knowledge' and queries. Integrated Knowledge is a table that gathered patient information, prescription information and symptom information together. Conclusions : If you store patient, prescription and symptom information on a single table, you could search and use the results by various combinations of the various elements included in the table. These results could help curing patients on the basis of evidence-based treatment at the clinics.
Keywords
Medical records; Database; Query; Data structure;
Citations & Related Records
Times Cited By KSCI : 4  (Citation Analysis)
연도 인용수 순위
1 Kang JS, Kim YC, Shin HK, Kim BS. Study on Effect of Learning Treatment Chart. Korean J. Oriental Physiology & Pathology. 2005:19(3):581-5.
2 Kim HG, Cha WS, Kim NI. Study on YuTuan's medical theory through the analysis of YiXueZhengZhuan medical records. JKMH. 2004: 17(1):57-82.
3 Lee SA. A Study of the Case Records of a Herbalist En Su-ryong in the late Chosun dynasty. JKMH. 2005:18(2):63-91.
4 Kim MG, Kim MW, Han JS, Park SS. The Studies of the constitutional symptoms between The ShinChukbon DongyiSuseBowon and The Gaobon DongyiSuseBowon. The Journal Of The Korea Institute Of KOREAN Medical Informatics. 2004:10(1):47-56.
5 Lee BW. A study of literature using Database(1). The Journal Of The Korea Institute Of KOREAN Medical Informatics. 2004:10(1):23-35.
6 Cha WS. Research of Database Model of Kim-YoungHun's Medical Chart. Korean J. Oriental Physiology & Pathology. 2006:20(2):279-91.
7 Cha WS, Park LS. Study of Young-Hoon Kim's Medical Chart Restoration. Korean J. Oriental Physiology & Pathology. 2008:20(2):1-12.
8 Seo KW, Oh JH, Seo JY, Kim TY, Hong SY, Yun SY, Cha WS, Kim NI. A Study on the Medical Records presented in HanGaekChiHeom. The Journal Of Korean Medical Classics. 2006:19(4):62-9.