1. Design of a Relational Database Based Case Base for High-speed Railway Roadbed Monitoring.
- Author
-
ZHU Dan, JIANG Guanlu, HUANG Degui, LIU Yifu, RAO Qianzhu, and LI Jianguo
- Abstract
Due to the development of China's high-speed railway, a large amount of field monitoring test data has been accumulated from previous scientific research and engineering practice. However, due to the backwardness of data management technology at that time, the test data were mostly "shelved" at the end of the project, and the scientific research value was not fully realized. Owing to the continuous progress of computer technology, the deformation monitoring system has gradually become a prevalent research topic. However, most of the current system research focuses more on the implementation of automatic monitoring technology and visualization model presentation, ignoring the design of the underlying database. Aiming at the aforementioned problems and taking Kunming-Nanning High-speed Railway roadbed field monitoring test as an example, we analyze and organize relevant engineering information and test data based on the E-R conceptual model, categorize the corresponding relationship pattern, and appropriately complete the design of the historical case database table structure and optimize the data management method. After the data is normalized, it will be batch loaded to a MySQL5.7-based database management system to establish the Kunming-Nanning High-speed Railway roadbed monitoring test history case database. Thus, integrated data management and user role-based authority management will be realized. This case database, a means of developing a secure and reliable database, can conveniently and efficiently display data as per user needs. Based on the aforementioned case database, a corresponding data display system is established. The system can clearly and intuitively display the logical structure and organization of the roadbed monitoring test of Kunming-Nanning High-speed Railway, and to achieve data reuse, and enable the subsequent relevant personnel to understand the project information for in-depth analysis. [ABSTRACT FROM AUTHOR]
- Published
- 2025
- Full Text
- View/download PDF