A microcomputer-based clinical trial database incorporated with an 'audit trail' for correction process

Multicenter clinical trials usually involve several hundred research variables with tens of thousands of records and require mainframe computers for processing. Because of recent advances in hardware and software, it has become possible to support data management and statistical analysis for a complex research project totally on a microcomputer. The Veterans Administration Cooperative Studies Program Coordinating Center (CSPCC) in Hines, IL, U.S.A. has successfully implemented three studies employing the SIR/PC Database Management System (DBMS) on an IBM PC AT. The CSPCC DBMS was designed with a method of verifying data and of updating the database, that leaves a more detailed 'audit trial' of the original data and subsequent modifications than provided by the SIR audit trail facility. Data validation can be done at any time throughout the study to facilitate error identification as early as possible in the data handling process. DBMS operation and maintenance are automated by a system of menus. The utility programs are prestored in a procedure file to optimize performance. The simple design speeds implementation and also reduces the cost of development.