继保异构数据管理系统毕业设计.docVIP

中文摘要 继电保护具有很多非结构化数据（Word、Excel、GIS、PDF、文本等格式），而非结构化数据具有文件小、数量多、异构、多源等特点，实现Word、Excel、JPG、AVI、TXT、PPT等所有格式数据的保存及管理和关?联快速提取保存、查询、显示、修改等 外文摘要 Title The Mangement System for relay protection Heterogeneous Database Abstract The Management System for relay protection Heterogeneous Database Relay protection has many 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 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 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. 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 目录 1 引言 1 2 构建数据模型 3 3 优化查询方法研究 6 3.1 使用存储过程 6 3.2 使用索引 6 3.3 字段过多的大表可拆分 7 3.4 减少表连接 7 3.5 尽可能少的使用子查询嵌套 7 3.6 尽量使用精确查询，少用模糊查询 7 3.7 分页查询方法 7 4 原型系统设计 9 4.1 原型系统框架构建与实现方法 9 4.2 原型系统介绍 9 图4-6 信息查询界面 12 4.3 系统运行效果 14 总结 18 参考文献 19 致谢 21 1 引言 1.1 研究继保异构数据管理系统的目的和意义 随着电力系统规模的不断扩充及复杂度的不断提高, 系统的运行方