The development and implementation of a computerized database for clinical research in minimal access surgery

• Published in: Surgical endoscopy Vol. 15; no. 9; pp. 1008 - 1010
• Main Authors: Birch, D. W, Park, A, Bailey, M, Witzke, W, Witzke, D, Hoskins, J
• Format: Journal Article
• Language: English
• Published: New York Springer Nature B.V 01-09-2001
• Subjects: Relational data bases
• ISSN: 0930-2794; 1432-2218
• DOI: 10.1007/s004640080028

BackgroundThe measurement of outcomes after minimal access surgery (MAS) relies on the maintenance of an accurate, prospective clinical database. The development of a system for data management often proves to be challenging, expensive, and extremely time-consuming.MethodsWe developed a computerized relational database for MAS using Microsoft Access 97 to reside on a hospital server, taking advantage of existing network connections, security, and backup systems. The design of the database includes a point-and-click approach with dropdown boxes for diagnoses, procedures, and complications (limited free-text entry). A fundamental feature of this database allows surgeons and surgical trainees to record clinical information at the point and time of data acquisition.ResultsA “beta version” or fully functional draft of the database was presented to a group of surgeons from a variety of specialties (n=8), and a structured interview based on a questionnaire was used to elicit the surgeon’s evaluations of the database. Using the information from the interviews, the database was extensively revised and restructured.ConclusionsWe have developed a relational database that reflects the needs of surgeons interested in clinical research. This database may serve as a template for other centers. It can be expanded to adopt new procedures or modified for other surgical specialties.