超高压直流工程开放式查询系统的设计与实现

Design and Implementation of An Open Query System for Extra HVDC Projects

企业级综合管理系统的应用,可以有效提高工程设计和管理的效率。在分析直流公司管理需求和设计特点的基础上,介绍了系统查询和维护模块的实现方法,讨论了利用结构化查询语言实现数据库表扩展和属性修改的过程,分析了通过设备表主、外键设定实现库表相互间链接关系的途径,以及利用数据管道完成异构数据库之间转换的方法。使得系统数据库具有开放性和扩展性,支持在线和离线查询,实际使用后达到了预期目标。

The application of an integrated enterprise management system can improve the efficiency of engineering design and management. Based on the analysis of the design and management requirements for a DC company, this paper introduces the implementation methods of a query module and a maintenance module respectively, discusses the implementation processes for extending database tables and modifying table attributes using SQL （Structured Query Language） statements, analyzes the methods to establish the links between tables through foreign keys, and realizes an open and extensible database by transforming heterogeneous databases through data pipelines. The system supports on-line and off-line searches. Application results show that the system achieves its design aims.