Data Warehouse to Support Clinical Trials in Dentistry

The increasing digitalization of clinical research requires infrastructure capable of integrating and quality-checking large volumes of data. In this study, we present the design of a relational data warehouse (DW) for collecting periodontal clinical data. The core of the DW is the 'Patient' table, with all other clinical information stored in related tables linked to it through appropriate relationships. The effectiveness of the DW was assessed using 95 real-world records (47 subjects with periodontitis and 48 controls) collected during the Gum-Gut Project.