Database system for managing 20,000 20-inch PMTs at JUNO

A database system, known as the large PMT characterization and instrumentation database system (LPMT-CIDS), was designed and implemented for the Jiangmen Underground Neutrino Observatory (JUNO). The system is based on a Linux + Apache + MySQL + PHP (LAMP) server and focuses on modularization and architecture separation. It covers all the testing stages for the 20-inch photomultiplier tubes (PMTs) at JUNO and provides its users with data storage, analysis, and visualization services. Based on the successful use of the system in the 20-inch PMT testing program, its design approach and construction elements can be extended to other projects.