1、 中文摘要 继电保护具有很多非结构化数据( Word、 Excel、 GIS、 PDF、文本等格式),而非结构化 数据具有文件小、数量多、异构、多源等特点, 为了将这些数据有效的进行管理,有必要研究一个方法可以科学管理、高效访问这些数据。本文深入研究了 继电保护非结构化数据的特点及其保存机制,采用 SQL Server 的面向对象特性,建立科学、合理的数据模型, 实现 Word、 Excel、 JPG、 AVI、 TXT、PPT 等所有格式数据的保存及管理和关 联 。并研究 大型数据库实体的建立方法、存储方法、优化方法、参数调整等内容,以及 快 速提取 数据库中数据的方法,主要包括使用存储过程
2、、查询优化、索引等技术手段。最后通过 C#语言 开发出继保异构数据管理系统, 实现系统的全部功能( 保存、查询、显示、修改等 )。并将本文提出的各项关键技术集成在该系统中,选取继保异构数据表进行测试。 关键词 继电保护异构数据 优化查询 C#开发 外文摘要 Title The Mangement System for relay protection Heterogeneous Database Abstract The Management System for relay protection Heterogeneous Database Relay protection has many
3、 unstructured data( Word, Excel, GIS, PDF, text formats .etc) , and unstructured data with documents and number、 small multi-source heterogeneous, etc. In order to manage these data effectively, it is necessary to study a method which can manage scientifically、 efficiently access to these data. This
4、 paper deeply studied the characteristics of points-unstructured data relay protection and preservation mechanism, using SQL Server object-oriented characteristics, establishing a scientific and reasonable data model, realizing all format data the preservation and management and shut league such as
5、Word, Excel, JPG, AVI, TXT, PPT etc. And the establishment of large database entity method, storage method, optimization method, the content such as parameters adjustment, and rapid extraction method of database data, including the use of storage process, query optimization, index technology means.
6、Finally, through to locate the c # development of heterogeneous data management system, all of the functions of system implementation (save, inquiry, display, modify, etc.). And the proposed various key technology will integrate in this system, the selection of following the heterogeneous data table could test. Keywords Heterogeneous data of Relay protection Optimization inquires C # development