Programmed database system at the Chang Gung Craniofacial Center

Part I

Kai Fong Hung, Nancy Dsen, Shiow Shuh Chuang, Mercedes Glendora De Villa, Philip Kuo Ting Chen, Lun Jou Lo, Sophia Chia Ning Chang, Chung Chih Yu, Yu Ray Chen

Research output: Contribution to journalArticle

1 Citation (Scopus)

Abstract

Background: A database is a system for the management of information. Databases of different forms are widely used in everyday life from telephone books to online library catalogs. The Craniofacial Center at Chang Gung Memorial Hospital has seen over 20,000 patients during the past 20 years. All of the patient records need to digitally input into a computer database. Methods: A database was custom designed using Paradox 8. The ACDSee Photo browser and DOS linked them to the original program. The Paradox 8 was programmed to a standard mode for the diagnosis and treatment data input to prevent typographical errors. Results: We collected the records of 25,200 patients from 1987 to 2002, of which 24,331 underwent operations. The data for 14,828 patients were registered as complete and/or incomplete cleft and the proportions of unilateral to bilateral and female to male are presented in Table 1. Conclusion: This new database system was designed to ensure the accuracy of data input using a standard model that is capable of correct data programming using the custom designed coding system for the Craniofacial Center. The system also provides easy and reliable data retrieval when using the powerful search tools.

Original languageEnglish
Pages (from-to)496-502
Number of pages7
JournalChang Gung Medical Journal
Volume26
Issue number7
Publication statusPublished - Jul 1 2003

Fingerprint

Databases
Library Catalogs
Management Information Systems
Information Storage and Retrieval
Telephone
Therapeutics

Keywords

  • Craniofacial center
  • Database

ASJC Scopus subject areas

  • Medicine(all)

Cite this

Hung, K. F., Dsen, N., Chuang, S. S., De Villa, M. G., Chen, P. K. T., Lo, L. J., ... Chen, Y. R. (2003). Programmed database system at the Chang Gung Craniofacial Center: Part I. Chang Gung Medical Journal, 26(7), 496-502.

Programmed database system at the Chang Gung Craniofacial Center : Part I. / Hung, Kai Fong; Dsen, Nancy; Chuang, Shiow Shuh; De Villa, Mercedes Glendora; Chen, Philip Kuo Ting; Lo, Lun Jou; Chang, Sophia Chia Ning; Yu, Chung Chih; Chen, Yu Ray.

In: Chang Gung Medical Journal, Vol. 26, No. 7, 01.07.2003, p. 496-502.

Research output: Contribution to journalArticle

Hung, KF, Dsen, N, Chuang, SS, De Villa, MG, Chen, PKT, Lo, LJ, Chang, SCN, Yu, CC & Chen, YR 2003, 'Programmed database system at the Chang Gung Craniofacial Center: Part I', Chang Gung Medical Journal, vol. 26, no. 7, pp. 496-502.
Hung KF, Dsen N, Chuang SS, De Villa MG, Chen PKT, Lo LJ et al. Programmed database system at the Chang Gung Craniofacial Center: Part I. Chang Gung Medical Journal. 2003 Jul 1;26(7):496-502.
Hung, Kai Fong ; Dsen, Nancy ; Chuang, Shiow Shuh ; De Villa, Mercedes Glendora ; Chen, Philip Kuo Ting ; Lo, Lun Jou ; Chang, Sophia Chia Ning ; Yu, Chung Chih ; Chen, Yu Ray. / Programmed database system at the Chang Gung Craniofacial Center : Part I. In: Chang Gung Medical Journal. 2003 ; Vol. 26, No. 7. pp. 496-502.
@article{7407b55c6cb644e78f77b3187d32cebe,
title = "Programmed database system at the Chang Gung Craniofacial Center: Part I",
abstract = "Background: A database is a system for the management of information. Databases of different forms are widely used in everyday life from telephone books to online library catalogs. The Craniofacial Center at Chang Gung Memorial Hospital has seen over 20,000 patients during the past 20 years. All of the patient records need to digitally input into a computer database. Methods: A database was custom designed using Paradox 8. The ACDSee Photo browser and DOS linked them to the original program. The Paradox 8 was programmed to a standard mode for the diagnosis and treatment data input to prevent typographical errors. Results: We collected the records of 25,200 patients from 1987 to 2002, of which 24,331 underwent operations. The data for 14,828 patients were registered as complete and/or incomplete cleft and the proportions of unilateral to bilateral and female to male are presented in Table 1. Conclusion: This new database system was designed to ensure the accuracy of data input using a standard model that is capable of correct data programming using the custom designed coding system for the Craniofacial Center. The system also provides easy and reliable data retrieval when using the powerful search tools.",
keywords = "Craniofacial center, Database",
author = "Hung, {Kai Fong} and Nancy Dsen and Chuang, {Shiow Shuh} and {De Villa}, {Mercedes Glendora} and Chen, {Philip Kuo Ting} and Lo, {Lun Jou} and Chang, {Sophia Chia Ning} and Yu, {Chung Chih} and Chen, {Yu Ray}",
year = "2003",
month = "7",
day = "1",
language = "English",
volume = "26",
pages = "496--502",
journal = "Chang Gung Medical Journal",
issn = "0255-8270",
publisher = "Chang Gung Medical Journal",
number = "7",

}

TY - JOUR

T1 - Programmed database system at the Chang Gung Craniofacial Center

T2 - Part I

AU - Hung, Kai Fong

AU - Dsen, Nancy

AU - Chuang, Shiow Shuh

AU - De Villa, Mercedes Glendora

AU - Chen, Philip Kuo Ting

AU - Lo, Lun Jou

AU - Chang, Sophia Chia Ning

AU - Yu, Chung Chih

AU - Chen, Yu Ray

PY - 2003/7/1

Y1 - 2003/7/1

N2 - Background: A database is a system for the management of information. Databases of different forms are widely used in everyday life from telephone books to online library catalogs. The Craniofacial Center at Chang Gung Memorial Hospital has seen over 20,000 patients during the past 20 years. All of the patient records need to digitally input into a computer database. Methods: A database was custom designed using Paradox 8. The ACDSee Photo browser and DOS linked them to the original program. The Paradox 8 was programmed to a standard mode for the diagnosis and treatment data input to prevent typographical errors. Results: We collected the records of 25,200 patients from 1987 to 2002, of which 24,331 underwent operations. The data for 14,828 patients were registered as complete and/or incomplete cleft and the proportions of unilateral to bilateral and female to male are presented in Table 1. Conclusion: This new database system was designed to ensure the accuracy of data input using a standard model that is capable of correct data programming using the custom designed coding system for the Craniofacial Center. The system also provides easy and reliable data retrieval when using the powerful search tools.

AB - Background: A database is a system for the management of information. Databases of different forms are widely used in everyday life from telephone books to online library catalogs. The Craniofacial Center at Chang Gung Memorial Hospital has seen over 20,000 patients during the past 20 years. All of the patient records need to digitally input into a computer database. Methods: A database was custom designed using Paradox 8. The ACDSee Photo browser and DOS linked them to the original program. The Paradox 8 was programmed to a standard mode for the diagnosis and treatment data input to prevent typographical errors. Results: We collected the records of 25,200 patients from 1987 to 2002, of which 24,331 underwent operations. The data for 14,828 patients were registered as complete and/or incomplete cleft and the proportions of unilateral to bilateral and female to male are presented in Table 1. Conclusion: This new database system was designed to ensure the accuracy of data input using a standard model that is capable of correct data programming using the custom designed coding system for the Craniofacial Center. The system also provides easy and reliable data retrieval when using the powerful search tools.

KW - Craniofacial center

KW - Database

UR - http://www.scopus.com/inward/record.url?scp=0141648558&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0141648558&partnerID=8YFLogxK

M3 - Article

VL - 26

SP - 496

EP - 502

JO - Chang Gung Medical Journal

JF - Chang Gung Medical Journal

SN - 0255-8270

IS - 7

ER -