Design of HEPS magnet database system
-
摘要: 高能同步辐射光源(HEPS) 磁铁数据库系统的开发过程包括数据库设计、数据库创建以及用于存储查询的网页管理系统的整体结构设计和开发。根据对磁铁相关数据格式和功能需求的调研, 整个系统采用MySQL数据库, 将HEPS的磁铁相关数据规范统一地存储, 包括磁铁设计参数、磁铁设备信息和磁铁测量数据等。同时, 开发了一套基于web的数据录入、查询管理系统, 能够提供便捷的数据展示、数据获取等功能, 并可以连接HEPS命名数据库、参数数据库等, 对于磁铁设备的安装、运行和维护以及HEPS整体的设备信息管理具有重要的意义。Abstract: 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.
-
Key words:
- HEPS /
- magnet data /
- database /
- management system /
- web-based application
-
表 1 HEPS磁铁数据库表主要信息
Table 1. Main information in HEPS magnet database tables
table name main parameters contents magnet_design_table design_id, type, family magnet design basic parameters magenet_design_requirement_table length, aperture, intensity magnet design requirements magenet_design_parameter_table offset, current, resistance magnet design parameters design_others_table property, value_double, value_text user-defined parameters equipment_info_table equipment_name, number, weight magnet equipment information rot_coil_system_table mearsure_content, r_ref, date RCS measure conditions rcs_data_table、rcs_data_all_table raw_data, bn, an RCS data and analyzed data hall_probe_system_table mearsure_content, current, hall probe system measure conditions hall_data_table, hall_data_all_table raw_data, gl, bl hall probe system data and analyzed data stretched_wire_system_table mearsure_content, sample_rate SWS measure conditions sws_data_table raw_data, analysis_data SWS data and analyzed data -
[1] 高能同步辐射光源构成及其科学意义[EB/OL]. http://www.ihep.cas.cn/kxcb/kpzt/kxr_2014/kpzb/heps/201405/t20140512_4118360.html.The composition of high-energy photon source and its scientific significance. http://www.ihep.cas.cn/kxcb/kpzt/kxr_2014/kpzb/heps/201405/t20140512_4118360.html [2] 姜晓明, 王九庆, 秦庆, 等. 中国高能同步辐射光源及其验证装置工程[J]. 中国科学: 物理学力学天文学, 2014(10): 1075-1094. https://www.cnki.com.cn/Article/CJFDTOTAL-JGXK201410009.htmJiang Xiaoming, Wang Jiuqing, Qin Qing, et al. Chinese high energy photon source and the test facility. Scientia Sinica Physica: Mechenica & Astronomica, 2014(10): 1075-1094 https://www.cnki.com.cn/Article/CJFDTOTAL-JGXK201410009.htm [3] Chu C P, Qiao Yusi, Wang Chunhong, et al. HEPS high-level software architecture plan[C]//Proc. 9th Int. Particle Accelerator Conf. 2018: 1884-1887. [4] MySQL[EB/OL]. https://baike.baidu.com/item/mySQL/471251?fr=aladdin/. [5] MySQL Workbench[EB/OL]. https://baike.baidu.com/item/MySQL%20Workbench/715772?fr=aladdin/. [6] EER Diagrams[EB/OL]. https://dev.mysql.com/doc/workbench/en/wb-eer-diagrams-section.html. [7] MVC Pattern[EB/OL]. https://netbeans.org/kb/docs/javaee/ecommerce/design.html#mvcDiagram/.