高能同步辐射光源(HEPS)磁铁数据库系统的开发过程包括数据库设计、数据库创建以及用于存储查询的网页管理系统的整体结构设计和开发。根据对磁铁相关数据格式和功能需求的调研, 整个系统采用MySQL数据库, 将HEPS的磁铁相关数据规范统一地存储, 包括磁铁设计参数、磁铁设备信息和磁铁测量数据等。同时, 开发了一套基于web的数据录入、查询管理系统, 能够提供便捷的数据展示、数据获取等功能, 并可以连接HEPS命名数据库、参数数据库等, 对于磁铁设备的安装、运行和维护以及HEPS整体的设备信息管理具有重要的意义。

HEPS (High Energy Photon Source) is a planned ultra-bright and extremely low emittance synchrotron light source which will contain about 2500 magnets. The design of magnet database system includes conceptual and functional design of database, database establishment, web-based management platform design and development. The magnet related data including design, measurements, tests, and operation are typically scattered in various storages which is hard to access for high-level purposes. For such a large number of magnets, it is very important to have essential magnet information systematically stored in relational databases for efficient management and applications. This database is developed with MySQL. To provide a better view and access function of magnet related data, a web-based management platform has been developed for data uploading, querying and managing. This system is of great significance to the installation, operation and maintenance of magnet equipment and the overall equipment information management of HEPS.