VALIDATION OF DATABASE MANAGEMENT SYSTEM APPLICATIONS FOR CLINICAL TRIALS

This article deals with the organization, methodology, and documentation for user-written main frame database management system (DBMS) application programs for clinical trials. Validation is defined as a quality-building process, not an error-finding process. Both functional and structural approaches to unit testing are cov-ered. Important differences between DBMS application programs and computation-al programs and their impact on validation are presented. Validation methodology is presented for data dictionary, data entry, data retrieval, and Statistical Analysis System (SAS) interface, report writing, and security applications. Computer simula-tion methods, batch versions of interactive programs-independent SAS listings, and shortcuts facilitated by features of certain DBMSs are presented. Recommendations are made to DBMS vendors for needed validation tools