| 超高压直流工程开放式查询系统的设计与实现 |
| |
| 引用本文： | 昝晶晶,杨建华,温渤婴,余世峰. 超高压直流工程开放式查询系统的设计与实现[J]. 电力信息化, 2011, 9(12): 36-39 |
| |
| 作者姓名： | 昝晶晶 杨建华 温渤婴 余世峰 |
| |
| 作者单位： | 1. 中国农业大学信息与电气工程学院,北京,100083
2. 北京网联直流工程技术有限公司,北京,100088 |
| |
| 基金项目： | 国家电网公司网联直流工程技术有限公司资助项目 |
| |
| 摘 要： | 企业级综合管理系统的应用,可以有效提高工程设计和管理的效率.在分析直流公司管理需求和设计特点的基础上,介绍了系统查询和维护模块的实现方法,讨论了利用结构化查询语言实现数据库表扩展和属性修改的过程,分析了通过设备表主、外键设定实现库表相互间链接关系的途径,以及利用数据管道完成异构数据库之间转换的方法.使得系统数据库具有开放性和扩展性,支持在线和离线查询,实际使用后达到了预期目标.
|
| 关 键 词： | 直流工程数据查询 超高压直流 异构数据库转换 数据库扩展 定制下载 |
Design and Implementation of An Open Query System for Extra HVDC Projects |
| |
| ZAN Jing-jing , YANG Jian-hua , WEN Bo-ying , YU Shi-feng. Design and Implementation of An Open Query System for Extra HVDC Projects[J]. Electric Power Information Technology, 2011, 9(12): 36-39 |
| |
| Authors: | ZAN Jing-jing YANG Jian-hua WEN Bo-ying YU Shi-feng |
| |
| Affiliation: | 1. College of Information and Electrical Engineering of China Agricultural University, Beijing 100083, 2. Beijing Wanglian HVDC Engineering Technology Co., Ltd., Beijing 100088, China) |
| |
| Abstract: | 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. |
| |
| Keywords: | data query of DC project extra HVDC transformation of heterogeneous database databaseextension customized downloading |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
