基于SQL的机车检修数据库构建技术的研究

机务段建立重点检修设备网络系统是适应机务管理网络化的要求,对提高机车检修质量具有重要意义,检修数据库的构建是其中一个重要的组成部分,在简要介绍重点检修设备网络系统的总体构成设想基础上,分析了检修数据库建立的软硬件环境,提出用结构化查询语言来构建检修数据库是较好的选择,对数据库的逻辑设计、物理设计和安全性设计等方面提出了初步建议和设想,以建立一个完整、安全和实用的机车检修数据库.

Study on database construction technology of locomotive repair based on SQL

Creating repair database could improve the repair quality greatly, it was briefly introduced the network system ofmain repair equipment, brought up that using structured query language to construct repair database was a perfect choice,analyzed the soft and hard conditions of creating repair database, also suggested preliminary measures and conceptions to thelogic design, the physics design and the safety performance design for creating a complete, safe and functional locomotiverepair database.