Programmed database system at the Chang Gung Craniofacial Center: part I

Area of Science:

• Medical Informatics
• Database Management Systems
• Craniofacial Surgery

Background:

• Databases are essential for managing information in various applications, including healthcare.
• The Craniofacial Center at Chang Gung Memorial Hospital has accumulated extensive patient data over 20 years.
• Digitizing patient records into a computer database is crucial for efficient management.

Purpose of the Study:

• To design and implement a custom database system for managing craniofacial patient records.
• To ensure the accuracy and integrity of diagnostic and treatment data.
• To facilitate easy and reliable retrieval of patient information.

Main Methods:

• A custom database was developed using Paradox 8, integrated with ACDSee Photo browser and DOS.
• Standardized data input modes were programmed to minimize typographical errors.
• A custom coding system was implemented for precise data management.

Main Results:

• The database contains records for 25,200 patients (1987-2002), with 24,331 undergoing operations.
• Data for 14,828 patients with complete/incomplete clefts were registered.
• Proportions of unilateral to bilateral and female to male cases were documented.

Conclusions:

• The developed database system ensures accurate data input through standardized programming and a custom coding system.
• The system facilitates efficient and reliable data retrieval using advanced search functionalities.
• This database enhances the management of craniofacial patient data for improved research and clinical practice.