Speaker
Description
The CMS RPC Construction Database was developed to support the large-scale production, certification, installation, and long-term traceability of Resistive Plate Chamber (RPC) detectors for the CMS experiment. Initially designed for the original CMS RPC construction campaign, the system has subsequently been extended and adapted to support multiple detector upgrade projects, providing a unified framework for detector production and quality assurance across several generations of RPC chambers. The database stores manufacturing data, quality-control measurements, and certification results for all chamber components and assemblies. Individual components are uniquely identified and associated with specific chambers, enabling complete traceability throughout the detector construction process. Following installation, each chamber remains linked to its physical location within the CMS detector, preserving the full production history of all removable components and ensuring compliance with detector documentation and traceability requirements. A hierarchical quality-control model is implemented, covering component certification, chamber assembly, chamber testing, and final validation before shipment and installation. In addition, quality certification is revalidated after each transportation step to verify that no damage or performance degradation has occurred during handling and logistics operations. The system is implemented using an Oracle relational database with a web interface developed in Oracle APEX. Dedicated procedures automate the evaluation of test results, chamber qualification, certification workflows, and installation readiness. Monitoring dashboards and production statistics provide real-time visualization of manufacturing progress and quality indicators during mass-production periods. Over multiple CMS RPC construction and upgrade campaigns, the database has proven to be a key tool for production management, quality assurance, detector traceability, and long-term preservation of provenance information throughout the detector lifecycle.