Database Design And Application Of Relay Protection Function Automatic Test System

With the rapid development of relay protection technology,new relay protection device,especially intelligent relay protection device,has become a complete and complex organic whole,which integrates protection,measurement,control and communication.At the same time,due to the high reliability requirements of relay protection system,a large number of complete and effective tests must be carried out to ensure its quality.However,the low efficiency and low quality of manual testing method has been far from meeting the needs of testing.Relay protection testing technology has some shortcomings,such as low automation rate,low test coverage,poor automation universality,and insufficient attention to automatic test management.Therefore,the research of relay protection automatic test system is of great significance to ensure the reliability of relay protection devices and ensure the safe operation of power grid.As a data storage and data management tool,database system is the core of today’s major software systems,and it is also a very critical and indispensable part in the relay protection automatic test system.This paper mainly completes the database design of automatic test system of relay protection function.Firstly,the overall framework of automatic test system for relay protection is introduced.According to the design steps of relational database,the overall design of automatic test system for relay protection database is completed.Secondly,make clear the indispensable role of test cases in the automatic test system,and then develop the research plan,carry out the demand research for relevant departments and personnel,and complete the database demand analysis.Then,the data is abstracted to form a conceptual model,and the entity relationship diagram of the whole database,namely the system E-R diagram,is established.According to the E-R diagram,the data model of the database is constructed,and the relationshipmodel is obtained.Finally,the physical design of the database is carried out,and the database design is implemented on SQL Server 2008.After the design of the database is basically realized,the trial operation and test of the database are carried out.After a large number of applications,the results show that the final automatic test system of relay protection function can greatly improve the test quality and efficiency,as well as the level of automatic test management,which can meet the needs of high efficiency and accuracy of relay protection function test.