CN112579643B - Information control method and device for relay protection module - Google Patents

Information control method and device for relay protection module Download PDF

Info

Publication number
CN112579643B
CN112579643B CN202011428817.0A CN202011428817A CN112579643B CN 112579643 B CN112579643 B CN 112579643B CN 202011428817 A CN202011428817 A CN 202011428817A CN 112579643 B CN112579643 B CN 112579643B
Authority
CN
China
Prior art keywords
module
information
defect
modules
relay protection
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN202011428817.0A
Other languages
Chinese (zh)
Other versions
CN112579643A (en
Inventor
薛钟
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Nanjing SAC Automation Co Ltd
Original Assignee
Nanjing SAC Automation Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Nanjing SAC Automation Co Ltd filed Critical Nanjing SAC Automation Co Ltd
Priority to CN202011428817.0A priority Critical patent/CN112579643B/en
Publication of CN112579643A publication Critical patent/CN112579643A/en
Application granted granted Critical
Publication of CN112579643B publication Critical patent/CN112579643B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2455Query execution
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00Arrangements for software engineering
    • G06F8/70Software maintenance or management
    • G06F8/71Version control; Configuration management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F9/00Arrangements for program control, e.g. control units
    • G06F9/06Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
    • G06F9/44Arrangements for executing specific programs
    • G06F9/451Execution arrangements for user interfaces

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Software Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Computer Security & Cryptography (AREA)
  • Human Computer Interaction (AREA)
  • Computational Linguistics (AREA)
  • Stored Programmes (AREA)

Abstract

The invention discloses a relay protection module information control method and a device, comprising the following steps: the software version control module is used for adding, modifying, deleting and inquiring software version information operated by all related relay protection modules; the module information control module is used for adding, modifying, deleting and inquiring basic information of all related relay protection modules; the module defect control module is used for adding, modifying, deleting and inquiring the defect information of all related relay protection modules; a module relationship control module for entering a relationship: substitution relationships between modules, correspondence relationships between a module and a software version running on the module, and attribution relationships between a module and all defects to which the module relates; and the authority control module is used for setting the management authority and the visibility degree and the database of different persons for different module information. The invention greatly improves the research and development efficiency and the test efficiency of the relay protection module and reduces the maintenance cost, the learning cost and the labor cost.

Description

Information control method and device for relay protection module
Technical Field
The invention relates to the technical field of relay protection, in particular to a relay protection module information control method and device.
Background
In the current relay protection field, specialized, visual and humanized management means for the relationship among the module information, the software version and the defect relationship are lacked, and due to a large amount of historical module, software version and defect information which are not managed properly, the relationship among the module information, the software version and the defects is difficult to sort and display. For example, how many defects (left-over or added) a module has and how many modules a defect may affect, few people can give a direct answer. Some specialties spend a great deal of time and effort with each carding module and defect relationship. In the more serious case, even if a great deal of effort is put into practice, there is no way to ensure the correctness of the carding result without professional management means.
Disclosure of Invention
In order to solve the defects in the prior art, the invention provides a relay protection module information control method and a relay protection module information control device, and solves the problem that the relationship among module information, software version and defect in relay protection is unclear.
In order to achieve the above purpose, the invention adopts the following technical scheme: a relay protection module information control method comprises the following steps:
the software version control method run on the relay protection module comprises the following steps:
adding, modifying, deleting and inquiring software version information operated by all related relay protection modules;
when newly adding, acquiring software version information operated on the relay protection module through a GUI interface, and storing the software version information into a table of a database;
generating a standardized software filing file according to the content of the database;
the relay protection module information control method comprises the following steps:
adding, modifying, deleting and inquiring basic information of all related relay protection modules;
when newly adding, through GUI interface, newly adding module information, confirming whether the newly added module has the defect of replacing the module left over; if the defect exists, whether the modification is needed to be confirmed; if no defect, saving the module information into a database; generating a standardized electronic filing file according to the saved module information;
the relay protection module defect information control method comprises the following steps:
adding, modifying, deleting and inquiring defect information of all related relay protection modules;
if the defects are found, adding defect information of the module through a GUI interface, and confirming the module influenced by the defects; storing the defect information and the affected modules into a database, and generating a module defect list and a defect statistical report according to the data;
recording a relation: substitution relations between modules, correspondence relations between modules and versions of software running on the modules, and attribution relations between modules and all defects related to the modules;
and setting the management authority and the visibility degree of different persons for different module information.
Further, the software version information comprises a version name, a version type, a version description, an item type, version attribution, modified content, version constraints, an upgrading method and an archiving path.
Further, the module information includes length, width, height, module type, module description, module model, printed board number, filing path, submission status, developer, and applicable platform of the module.
Further, the module defect information includes a defect ID, a defect name, a defect type, a defect grade, a defect source, and a defect status.
A relay protection module information control device comprising:
the software version control module is used for adding, modifying, deleting and inquiring software version information operated by all related relay protection modules; the newly added software version information is stored in a database, and a standardized software filing file is generated according to the content of the database;
the module information control module is used for adding, modifying, deleting and inquiring basic information of all related relay protection modules; if the module is newly added, the information of the newly added module is confirmed through a GUI interface to determine whether the newly added module has defects left by a replacement module, if so, whether the newly added module is modified is determined, and if not, the information of the module is stored in a database; generating a standardized electronic filing file according to the saved module information;
the module defect control module is used for adding, modifying, deleting and inquiring the defect information of all related relay protection modules; if the defect is found, newly adding defect information through a GUI interface, and confirming the influence range of the defect; and storing the information of the defects and the affected modules into a database, and generating a defect list and a defect statistical report according to the data.
A module relationship control module for entering a relationship: substitution relationships between modules, correspondence relationships between a module and a software version running on the module, and attribution relationships between a module and all defects to which the module relates;
the authority control module is used for setting the management authority and the visibility degree of different personnel for different module information;
and a database.
Further, the software version information includes: version name, version type, version description, item type, version attribution, modified content, version constraints, upgrade method, and archive path.
Further, the module information includes: module length, width, height, module type, module description, module model, printed board number, filing path, pick-up status, developer and applicable platform.
Further, the module defect information includes a defect ID, a defect name, a defect type, a defect grade, a defect source, and a defect status.
The invention achieves the following beneficial effects:
the invention supports digital recording and graphical display;
the invention is a process-oriented quality monitoring;
the invention supports standardized paperless archiving;
the invention can greatly improve the research and development efficiency and the test efficiency of the relay protection module and well reduce the maintenance cost, the learning cost and the labor cost.
Drawings
FIG. 1 is a system architecture diagram of the present invention.
Detailed Description
The invention is further described below with reference to the accompanying drawings. The following examples are only for illustrating the technical solutions of the present invention more clearly, and the protection scope of the present invention is not limited thereby.
Example 1:
as shown in fig. 1, a relay protection module information control method includes:
1) the software version control method run on the relay protection module comprises the following steps:
the software version filing is mainly used for generating the relation data of the modules and the software running on the modules, and recording the relation data into a VM _ relation table in a database. From this table it is possible to look up which software version is running on a module and how many models of modules the same software version can support.
The software version control method comprises the following steps:
adding, modifying, deleting and inquiring software version information operated by all related relay protection modules;
when newly adding, acquiring software version information operated on the relay protection module through a GUI interface, and storing the software version information into a vb _ relationship table of a database; the vb _ relation table stores the corresponding relation between the module and the software running on the module;
generating a standardized software filing file according to the database content;
the software version information can be persisted into a database, and data analysis, graphic display and generation of a standardized electronic filing file can be further carried out according to the persisted software version information.
2) A relay protection module information control method; the method comprises the following steps:
adding, modifying, deleting and inquiring basic information of all related relay protection modules;
when adding, adding module information through GUI interface;
(2) confirming whether the newly added module has the defects left by the replacement module;
(3) if the defect exists, whether the modification is needed to be confirmed; if the data is directly released without defects and is persisted into a database;
(4) based on the persisted module information, further data analysis, graphical presentation, and generation of standardized electronic archive files may be performed. Such as showing a list of module replacement relationships, a module tree, etc.
3) The relay protection module defect information control method comprises the following steps:
adding, modifying, deleting and inquiring defect information of all related relay protection modules;
the defect information control is used for recording defects generated on the module and managing, counting, analyzing and displaying the defect information.
(1) If the defect is found, newly adding defect information through a GUI (graphical user interface), wherein the defect information comprises a software version for finding the defect;
(2) confirming the influence range of the defect, namely how many modules are influenced by the defect;
(3) and storing the information of the defects and the affected modules into a database, and generating a defect list and a defect statistical report according to the data.
Example 2:
a relay protection module information control device comprising: the system comprises a software version control module, a module information control module, a module defect control module, a module relation control module, an authority control module and a database;
the software version control module is used for adding, modifying, deleting and inquiring software version information operated by all related relay protection modules; the newly added software version information is saved in a VM _ relation table in a database, and a standardized software filing file is generated according to the content of the database;
the VM _ relationship table stores the corresponding relation between the module and the software running on the module;
the software version information comprises version name, version type, version description, item type, version attribution, modified content, version constraint, upgrading method, filing path and the like. As shown in the table 1 below, the following examples,
Figure RE-GDA0002954293850000051
Figure RE-GDA0002954293850000061
the module control module: the method is used for adding, modifying, deleting and inquiring basic information of all related relay protection modules, if the modules are added, whether the added modules have defects left by replacing the modules is determined, and if the modules have defects, whether the modules are modified is determined; if no defect exists, directly releasing the data and saving the data into a database; based on the persisted module information, further data analysis, graphical presentation, and generation of standardized electronic archive files may be performed. Such as showing a list of module replacement relationships, a module tree, etc.
The basic information of the module comprises the length, width, height, module type, module description, module model, printed board number, filing path, submission state, developer, applicable platform and other static information which are not changed in the module. As shown in table 2:
TABLE 2 basic information Table of Module
Figure RE-GDA0002954293850000062
Figure RE-GDA0002954293850000071
The module defect control module is used for adding, modifying, deleting and inquiring defect information of all related relay protection modules, and if defects are found, adding the defect information through a GUI (graphical user interface); confirming the influence range of the defect, namely how many modules are influenced by the defect; and storing the information of the defects and the influenced modules into a vb _ relation _ detail table in a database, and generating a defect list and a defect statistical report of the modules according to the data.
The module defect information includes a defect ID, a defect name, a defect type, a defect grade, a defect source, a defect status, and the like. As shown in table 3:
TABLE 3 Module Defect information Table
Figure RE-GDA0002954293850000081
The module relation control module is used for recording three relations, namely a substitution relation between the first module and the second module, namely the module B can substitute the module A for use and is in a one-to-one relation in a single direction; second, the correspondence between the modules and the versions of software running on the modules; third, the attribution relationship between the module and all the defects that the module is involved with.
The authority control module: for distinguishing the management authority and the visibility degree of different persons for different module information.
The invention is used for managing the relationship between modules and the software version, and the relationship between the modules and the software version relates to 1 table VM _ relationship.
The invention is used to manage the relationship between modules and defects involving 2 tables vb _ relation and vb _ relation _ detail.
The table structure is as follows:
Figure RE-GDA0002954293850000082
Figure RE-GDA0002954293850000091
Figure RE-GDA0002954293850000092
as will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The above description is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, several modifications and variations can be made without departing from the technical principle of the present invention, and these modifications and variations should also be regarded as the protection scope of the present invention.

Claims (8)

1. A relay protection module information control method is characterized in that: the method comprises the following steps:
the software version control method run on the relay protection module comprises the following steps:
adding, modifying, deleting and inquiring software version information operated by all related relay protection modules;
when newly adding, acquiring software version information operated on the relay protection module through a GUI interface, and storing the software version information into a table of a database;
generating a standardized software filing file according to the database content;
the information control method of the relay protection module comprises the following steps:
adding, modifying, deleting and inquiring basic information of all related relay protection modules;
when newly adding, through GUI interface, newly adding module information, confirm whether newly adding the module has the defect that the replacement module leaves over; if the defect exists, whether the modification is needed to be confirmed; if the module information is not defective, saving the module information into a database; generating a standardized electronic filing file according to the saved module information;
the relay protection module defect information control method comprises the following steps:
adding, modifying, deleting and inquiring defect information of all related relay protection modules;
if the defects are found, adding defect information of the module through a GUI interface, and confirming the module influenced by the defects; storing the defect information and the affected modules into a database, and generating a module defect list and a defect statistical report according to the data;
recording a relation: substitution relations between modules, correspondence relations between modules and versions of software running on the modules, and attribution relations between modules and all defects related to the modules;
and setting the management authority and the visibility degree of different persons for different module information.
2. The information control method of the relay protection module according to claim 1, wherein: the software version information comprises version name, version type, version description, item type, version attribution, modified content, version constraint, upgrading method and filing path.
3. The relay protection module information control method according to claim 1, wherein: the module information includes the length, width, height, module type, module description, module model, printed board number, filing path, submission status, developer, and applicable platform of the module.
4. The information control method of the relay protection module according to claim 1, wherein: the module defect information includes a defect ID, a defect name, a defect type, a defect grade, a defect source, and a defect status.
5. A relay protection module information control device is characterized in that: the method comprises the following steps:
the software version control module is used for adding, modifying, deleting and inquiring software version information operated by all related relay protection modules; the newly added software version information is stored in a database, and a standardized software filing file is generated according to the content of the database;
the module information control module is used for newly adding, modifying, deleting and inquiring basic information of all related relay protection modules; if the module is newly added, the information of the newly added module is confirmed through a GUI interface to determine whether the newly added module has defects left by a replacement module, if so, whether the newly added module is modified is determined, and if not, the information of the module is stored in a database; generating a standardized electronic filing file according to the saved module information;
the module defect control module is used for adding, modifying, deleting and inquiring the defect information of all related relay protection modules; if the defect is found, newly adding defect information through a GUI interface, and confirming the influence range of the defect; storing the information of the defects and the affected modules into a database, and generating a defect list and a defect statistical report of the modules according to the data;
a module relationship control module for entering a relationship: substitution relations between modules, correspondence relations between modules and versions of software running on the modules, and attribution relations between modules and all defects related to the modules;
the authority control module is used for setting the management authority and the visibility degree of different personnel for different module information;
and a database.
6. The relay protection module information control device according to claim 5, wherein: the software version information includes: version name, version type, version description, item type, version attribution, modified content, version constraints, upgrade method, and archive path.
7. The relay protection module information control device according to claim 5, wherein: the module information includes: module length, width, height, module type, module description, module model, printed board number, filing path, pick-up status, developer and applicable platform.
8. The relay protection module information control device according to claim 5, wherein: the module defect information includes a defect ID, a defect name, a defect type, a defect grade, a defect source, and a defect status.
CN202011428817.0A 2020-12-09 2020-12-09 Information control method and device for relay protection module Active CN112579643B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011428817.0A CN112579643B (en) 2020-12-09 2020-12-09 Information control method and device for relay protection module

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011428817.0A CN112579643B (en) 2020-12-09 2020-12-09 Information control method and device for relay protection module

Publications (2)

Publication Number Publication Date
CN112579643A CN112579643A (en) 2021-03-30
CN112579643B true CN112579643B (en) 2022-09-09

Family

ID=75130347

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011428817.0A Active CN112579643B (en) 2020-12-09 2020-12-09 Information control method and device for relay protection module

Country Status (1)

Country Link
CN (1) CN112579643B (en)

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102855187B (en) * 2012-07-31 2015-10-28 许继电气股份有限公司 A kind of protective relaying device bug track management system and method
CN105741000A (en) * 2014-12-11 2016-07-06 国网天津静海供电有限公司 Relay protection apparatus software version management system

Also Published As

Publication number Publication date
CN112579643A (en) 2021-03-30

Similar Documents

Publication Publication Date Title
US8024305B2 (en) Updating a data warehouse schema based on changes in an observation model
CN104423960B (en) A kind of method and system of project continuous integrating
CN107908550B (en) Software defect statistical processing method and device
US20080163187A1 (en) Graphical representation of dependencies between changes of source code
US20120291014A1 (en) System and method for testing the development and updates in a test system using production/live data
CN108280137B (en) Task-based pipe network data editing method and device
CN113326247B (en) Cloud data migration method and device and electronic equipment
CN110910081A (en) Workflow configuration implementation method and system based on laboratory information management system
CN111694612A (en) Configuration checking method, device, computer system and storage medium
CN113760354B (en) Ontology information version management and control method and device of dispatching automation system
CN111190814A (en) Software test case generation method and device, storage medium and terminal
CN112579643B (en) Information control method and device for relay protection module
CN116823464B (en) Data asset management platform, electronic device, and computer-readable storage medium
CN113010208A (en) Version information generation method, version information generation device, version information generation equipment and storage medium
US20200285630A1 (en) Systems and methods for application data transaction auditing
CN112346994B (en) Test information association method, device, computer equipment and storage medium
CN117608536B (en) Gap data online template customization and supplementary recording system and method thereof
CN112130838A (en) Transaction data processing method and device
US8150821B2 (en) System and method for using generic utilities to perform database utilities on mainframe operated DB2 databases
CN113934712B (en) Method, device and equipment for processing field model of industrial quality inspection data
CN113468158B (en) Data restoration method, system, electronic equipment and medium
CN110990281B (en) Automatic static analysis method
CN113204490A (en) Batch operation testing method and device, electronic equipment and storage medium
CN117851481A (en) Method, system, medium and equipment for automatic production of data analysis report
CN115599469A (en) Transaction execution method and device

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant