TrialDB: A web-based Clinical Study Data Management System

Clinical Study Data Management Systems (CSDMSs) are a class of software that support centralized management of data generated during the conduct of clinical studies. Commercial CSDMSs include Oracle Clinical, ClinTrial and MetaTrial. Such systems, which are typically deployed at an institutional or organizational level, must accommodate diverse types of data from different clinical domains that is generated by different groups of clinical investigators. Large-scale CSDMSs typically employ a high-end database engine that is usually accessed over an intranet or the Internet using Web-based technologies. CSDMSs in institution-wide use for a variety of clinical domains are best served by entity-attribute-value (EAV) modeling for the clinical data: all the commercial CSDMSs that we are aware of use EAV design. However, de novo development of EAV databases for data management is a challenging task. A large body of generic metadata-driven code must be developed before a basic EAV application can be written. Clearly, the availability of pre-existing software with the requisite functionality would be very valuable. We will discuss the benefits of such software being in open-source form.