基于关系型数据库的高铁路基监测案例库设计  

Design of a Relational Database Based Case Base for High-speed Railway Roadbed Monitoring

作　　者：朱丹 蒋关鲁[1,2] 黄德贵[1,2] 刘乙甫 饶千竺 李建国 ZHU Dan;JIANG Guanlu;HUANG Degui;LIU Yifu;RAO Qianzhu;LI Jianguo(School of Civil Engineering,Southwest Jiaotong University,Chengdu 610031,China;Key Laboratory of High-speed Railway Engineering of Ministry of Education,Southwest Jiaotong University,Chengdu 610031,China)

机构地区：[1]西南交通大学土木工程学院,成都610031 [2]西南交通大学高速铁路线路工程教育部重点实验室,成都610031

出　　处：《铁道标准设计》2025年第1期50-56,共7页Railway Standard Design

基　　金：四川省国际科技创新合作/港澳台科技创新合作项目(2021YFH0024);中铁二院华东勘察设计有限责任公司科研项目(KYL202112-0022)。

摘　　要：随着中国高铁事业的发展,以往科学研究和工程实践积累了大量的现场监测试验数据,但由于当时数据管理技术落后,试验数据在项目结束后多被“束之高阁”,科研价值得不到充分实现。随着计算机技术的不断进步,变形监测系统逐渐成为研究热点,但目前大多数系统的研究更侧重于自动监测技术的实现和可视化模型的展示,忽略底层数据库的设计。针对上述问题,以云桂高铁路基现场监测试验为例,基于E-R概念模型,分析整理相关工程信息与试验数据,梳理得到相应的关系模式,据此完成了历史案例数据库表结构设计,优化了数据管理方式。对数据进行规范化处理后,将其批量装载至基于MySQL5.7的数据库管理系统,建立云桂高铁路基监测试验历史案例数据库,从而实现数据的一体化管理和基于用户角色的权限管理。可在保障数据库数据安全、可靠的基础上,根据用户需求便捷、高效地展示数据。基于上述案例数据库建立相应的数据展示系统,能清晰、直观地展示云桂高铁路基监测试验的逻辑和组织结构,方便后续相关人员了解项目信息,以便进行深入剖析,从而达到数据重用的目的。Due to the development of Chinas 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.

关 键 词：高速铁路 铁路路基 监测试验 数据管理 数据库设计 E-R模型 数据重用 

分 类 号：U213.1[交通运输工程—道路与铁道工程] U238