CN115357602A - Method and system for acquiring operation and maintenance work data requirements of transformer substation - Google Patents
Method and system for acquiring operation and maintenance work data requirements of transformer substation Download PDFInfo
- Publication number
- CN115357602A CN115357602A CN202211276451.9A CN202211276451A CN115357602A CN 115357602 A CN115357602 A CN 115357602A CN 202211276451 A CN202211276451 A CN 202211276451A CN 115357602 A CN115357602 A CN 115357602A
- Authority
- CN
- China
- Prior art keywords
- data
- maintenance
- database
- requirement
- demand
- 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.)
- Granted
Links
- 238000012423 maintenance Methods 0.000 title claims abstract description 203
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000012163 sequencing technique Methods 0.000 claims description 8
- 238000012360 testing method Methods 0.000 description 7
- 238000009529 body temperature measurement Methods 0.000 description 4
- 238000013500 data storage Methods 0.000 description 1
- 238000000354 decomposition reaction Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 239000000126 substance Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Human Resources & Organizations (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Mathematical Physics (AREA)
- Supply And Distribution Of Alternating Current (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method and a system for acquiring operation and maintenance work data requirements of a transformer substation, wherein the method comprises the steps of acquiring the association relation between each operation and maintenance work in the transformer substation and corresponding operation and maintenance data; establishing a corresponding primary database and a corresponding secondary database for different operation and maintenance works, wherein the database prestores operation and maintenance data through an array type character template, and all elements of an array correspond to one operation and maintenance operation and the operation and maintenance data generated by the operation and maintenance operation; determining required operation and maintenance data and a corresponding database according to operation and maintenance work requirements; traversing and searching a corresponding character template in a corresponding database according to the working requirement; and returning the operation and maintenance data required by the operation and maintenance work requirement according to the searched character template. According to the invention, the operation and maintenance data are pre-stored in an array form, and corresponding data can be obtained only by traversing and searching the corresponding database during each operation and maintenance work, so that the query time is saved, and the efficiency of the operation and maintenance work is improved.
Description
Technical Field
The invention belongs to the technical field of transformer substation operation and maintenance, and particularly relates to a method and a system for acquiring operation and maintenance work data requirements of a transformer substation.
Background
At present, data of a transformer substation is acquired mainly by manually inquiring in a system or a background, the whole process is time-consuming, and the time for inquiring data of actual measured data and the time for inquiring data of the background are often unmatched. For example, 2 hours are needed to complete a total-station temperature measurement, so that the background current query and other data are a time period rather than a time point, and if accurate recording is needed, a large amount of time is consumed for searching each time. In addition, in the operation process, if the operation is performed in the field and the background related data needs to be acquired, the operator needs to run back and forth, which all results in slow operation progress, and if extra staff are arranged to check in the background, more staff need to be arranged. Therefore, the existing transformer substation data acquisition modes have the problem of low working efficiency.
Disclosure of Invention
In view of this, the invention aims to solve the problem that the existing substation data acquisition mode is low in working efficiency.
In order to solve the technical problems, the invention provides the following technical scheme:
in a first aspect, the invention provides a method for acquiring operation and maintenance work data requirements of a transformer substation, which includes:
acquiring an incidence relation between each operation and maintenance work in the transformer substation and corresponding operation and maintenance data;
establishing corresponding primary databases for different operation and maintenance works, wherein the primary databases pre-store operation and maintenance data through array type character templates, and the array type character templates are classified and stored according to actual intervals of the transformer substation, wherein all elements of one array correspond to one operation and maintenance operation and maintenance data generated by the operation and maintenance operation, and the primary databases are also provided with a plurality of secondary databases according to the types of the operation and maintenance data;
acquiring operation and maintenance work requirements, and determining required operation and maintenance data and corresponding primary databases and secondary databases according to the operation and maintenance work requirements and the association relation;
traversing and searching corresponding character templates in the corresponding primary database and the second database according to the working requirements;
and returning the operation and maintenance data required by the operation and maintenance work requirement according to the searched character template.
Further, the array type text template specifically includes: a fixed text template and a dynamic link text template;
the elements of the fixed character template comprise a primary database name, a secondary database name, keywords and data parameters;
the elements of the dynamically linked text template include a primary database name, a secondary database name, time, keywords, and data parameters.
Further, acquiring operation and maintenance work requirements, and determining required operation and maintenance data and corresponding primary and secondary databases according to the operation and maintenance work requirements and the association relationship, specifically comprising:
acquiring a field expressing the operation and maintenance work requirement, and extracting information of the field to obtain a task name, a required data type and a required data keyword of the operation and maintenance work;
and respectively determining and obtaining the first-level database name, the second-level database name and the key word corresponding to the operation and maintenance work data according to the incidence relation.
Furthermore, in the corresponding primary database and secondary database, the operation and maintenance data required by the operation and maintenance work requirement is returned, which specifically comprises:
establishing a demand frame and initializing each element position in the demand frame, wherein the elements of the demand frame comprise a demand task name, a demand type and a demand interval, and different demand intervals correspond to the division of each interval in the transformer substation;
filling the first-level database name, the second-level database name and the key words into a requirement frame corresponding to the requirement task name, the requirement type and the requirement interval;
traversing all the character templates in the database by using the keywords of the demand frame in the corresponding primary database and the secondary database until the corresponding character templates are matched;
returning the data parameters in the corresponding text template to the corresponding demand interval in the demand frame;
and acquiring the required data of the operation and maintenance work requirement based on the requirement frame.
Further, traversing all the character templates in the database by using the keywords of the requirement frame in the corresponding primary database and the secondary database, specifically comprising:
determining the number of demands according to the keywords of the demand frame, and determining a rapid demand path based on the number of demands, wherein if the number of demands is a single demand or is a single branch demand, the keywords are sorted and then placed in corresponding intervals, and traversal search is performed according to the sorted keywords to match with corresponding text templates; and if the number of the requirements is a plurality of and is the requirement of multiple branches, classifying and sequencing the keywords in sequence, then putting the keywords into corresponding requirement intervals, and traversing and searching the keywords after respective sequencing for different requirement intervals so as to match the corresponding character templates.
In a second aspect, the present invention provides a transformer substation operation and maintenance work data requirement acquisition system, including:
the data association unit is used for acquiring association relations between various operation and maintenance works in the transformer substation and corresponding operation and maintenance data;
the database establishing unit is used for establishing corresponding primary databases for different operation and maintenance works, the primary databases pre-store operation and maintenance data through the array type character templates, and the array type character templates are classified and stored according to the actual intervals of the transformer substation, wherein all elements of one array correspond to one operation and maintenance operation and the operation and maintenance data generated by the operation and maintenance operation, and the primary databases are also provided with a plurality of secondary databases according to the types of the operation and maintenance data;
the database matching unit is used for acquiring operation and maintenance work requirements and determining required operation and maintenance data and corresponding primary databases and secondary databases according to the operation and maintenance work requirements and the incidence relation;
the data retrieval unit is used for traversing and searching corresponding character templates in the corresponding primary database and the corresponding secondary database according to the working requirement;
and the data acquisition unit is used for returning the operation and maintenance data required by the operation and maintenance work according to the searched character template.
Further, in the database establishing unit, the array type text template specifically includes: a fixed text template and a dynamic link text template;
the elements of the fixed character template comprise a primary database name, a secondary database name, keywords and data parameters;
the elements of the dynamically linked text template include a primary database name, a secondary database name, time, keywords, and data parameters.
Further, the operation and maintenance work requirement is obtained in the database matching unit, the required operation and maintenance data and the corresponding primary database and secondary database are determined according to the operation and maintenance work requirement and the association relationship, and the method specifically comprises the following steps:
acquiring a field expressing the operation and maintenance work requirement, and extracting information of the field to obtain a task name, a required data type and a required data keyword of the operation and maintenance work;
and respectively determining and obtaining the first-level database name, the second-level database name and the key word corresponding to the operation and maintenance work data according to the incidence relation.
Further, in the data retrieval unit, in the corresponding primary database and the secondary database, the operation and maintenance data required by the operation and maintenance work requirement is returned, which specifically includes:
establishing a demand frame and initializing each element position in the demand frame, wherein the elements of the demand frame comprise a demand task name, a demand type and a demand interval, and different demand intervals correspond to the division of each interval in the transformer substation;
filling the first-level database name, the second-level database name and the key words into a requirement frame corresponding to the requirement task name, the requirement type and the requirement interval;
traversing all the character templates in the database by using the keywords of the demand frame in the corresponding primary database and the secondary database until the corresponding character templates are matched;
returning the data parameters in the corresponding text template to the corresponding demand interval in the demand frame;
and acquiring the required data of the operation and maintenance work requirement based on the requirement frame.
Further, in the data retrieval unit, traversing all the text templates in the database by using the keywords of the requirement frame in the corresponding primary database and the secondary database, specifically comprising:
determining the required quantity according to the keywords of the requirement frame, and determining a rapid requirement path based on the required quantity, wherein if the required quantity is a single requirement or the required quantity is a single branch, the keywords are sorted and then placed in a corresponding interval, and traversal search is performed according to the sorted keywords so as to match the corresponding text template; if the number of the requirements is a plurality and the requirements are multi-branch requirements, classifying and sequencing the keywords in sequence, then placing the keywords into corresponding requirement intervals, and respectively performing traversal search on different requirement intervals to match with corresponding character templates.
In summary, the invention provides a method and a system for acquiring operation and maintenance work data requirements of a transformer substation, and the method comprises the steps of acquiring an association relation between each operation and maintenance work in the transformer substation and corresponding operation and maintenance data; establishing a corresponding primary database and a corresponding secondary database for different operation and maintenance works, wherein the database prestores operation and maintenance data through an array type character template, and all elements of an array correspond to one operation and maintenance operation and the operation and maintenance data generated by the operation and maintenance operation; determining required operation and maintenance data and a corresponding database according to operation and maintenance work requirements; traversing and searching a corresponding character template in a corresponding database according to the working requirement; and returning the operation and maintenance data required by the operation and maintenance work requirement according to the searched character template. According to the invention, the operation and maintenance data are pre-stored in an array form, and the corresponding data can be obtained only by traversing and searching the corresponding database during each operation and maintenance work, so that the query time is saved, and the efficiency of the operation and maintenance work is improved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without inventive exercise.
Fig. 1 is a schematic flow chart of a method for acquiring operation and maintenance work data requirements of a transformer substation according to an embodiment of the present invention;
fig. 2 is a structural division diagram of a data requirement box according to an embodiment of the present invention.
Detailed Description
In order to make the objects, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the embodiments described below are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be obtained by a person skilled in the art without making any creative effort based on the embodiments in the present invention, belong to the protection scope of the present invention.
At present, the data acquisition of the transformer substation mainly depends on manual work to query in a system or a background, the whole process is time-consuming, and the time for actually measuring the data and the time for querying the data in the background are often unmatched. For example, 2 hours are needed for completing a total-station temperature measurement, so that the background query of data such as current is a time period rather than a time point, and if accurate recording is needed, a large amount of time is consumed for searching each time individually. In addition, in the operation process, if the operation is performed in the field and the related background data needs to be acquired, the operator needs to run back and forth, which results in slow operation progress, and if extra staff is arranged to check in the background, more staff needs to be arranged. Therefore, the existing transformer substation data acquisition modes all have the problem of low working efficiency.
Based on the method, the invention provides a transformer substation operation and maintenance work data requirement acquisition method and a transformer substation operation and maintenance work data requirement acquisition system.
Referring to fig. 1, the present embodiment provides a method for acquiring operation and maintenance work data requirements of a transformer substation, including:
s100: and acquiring the association relation between each operation and maintenance work in the transformer substation and the corresponding operation and maintenance data.
The operation and maintenance work comprises daily maintenance work, operation work, maintenance test, temporary work and the like. In the actual implementation process, a data dictionary can be established by identifying the name and number of the device and the working content keywords, and then calling the corresponding working task or operating task database from a specific directory library, wherein the data dictionary comprises all relevant information of the device, such as background, test, historical data and the like. This establishes an association relationship for each operation and maintenance job and its data.
S200: establishing a corresponding primary database for different operation and maintenance works, pre-storing operation and maintenance data by the primary database through an array type character template, and storing the array type character template in a classified manner according to the actual interval of the transformer substation, wherein all elements of one array correspond to one operation and maintenance operation and the operation and maintenance data generated by the operation and maintenance operation, and the primary database is also provided with a plurality of secondary databases according to the type of the operation and maintenance data.
And each primary database is established and completed by machine learning according to the work name, the task and the operation list in the initial stage of each transformer substation, such as establishing a maintenance base for maintenance work, establishing a patrol base for patrol work, establishing an operation base for operation work, establishing a test base for test work and the like. The data storage templates (i.e. the text templates) in each primary database are all array types, and specifically, the information storage formats in the databases are two types:
1. fixed type character template:
[ library name, keyword 1, keyword 2, keyword 3, keyword 4, keyword 5, type, parameter 1, parameter 2, parameter 3].
2. Dynamically linked text templates: the parameters in this type are obtained dynamically according to time
[ library name, time, address, keyword 1, keyword 2, keyword 3, keyword 4, keyword 5, type, parameter 1, parameter 2, parameter 3].
It will be appreciated that the number of different types of elements in the array is determined in accordance with the circumstances.
Further, secondary classification can be performed in the primary database to obtain a plurality of secondary databases, which can be classified into background databases, test data, history records, and the like.
S300: and acquiring operation and maintenance work requirements, and determining required operation and maintenance data and corresponding primary databases and secondary databases according to the operation and maintenance work requirements and the association relation.
The data requirement of the operation and maintenance work is sent by the terminal equipment, if the real-time data needs to be acquired, the requirement is sent in real time, for example, the required information is automatically sent to a demand end by checking which step an operation task goes to or which step the operation task goes to in a work service instruction book.
The expression form of the issued operation and maintenance work requirement is a field, information extraction is carried out on the field, the task name, the required data type and the required data key word of the operation and maintenance work can be obtained, and further the first-stage database name, the second-stage database name and the key word corresponding to the operation and maintenance work data are respectively determined and obtained according to the incidence relation.
S400: and traversing and searching corresponding character templates in the corresponding primary database and the second database according to the working requirements.
Firstly, a requirement frame needs to be established and each element position in the requirement frame needs to be initialized, elements of the requirement frame comprise a requirement task name, a requirement type and a requirement interval, wherein different requirement intervals correspond to the division of different equipment intervals in a transformer substation. The structure division of the demand frame is shown in fig. 2, wherein the demand task name corresponds to a primary database name such as tour, operation, test, overhaul and the like, the demand type corresponds to a secondary database name such as background data, historical data, test data and the like, the demand interval corresponds to different secondary databases and is divided into a plurality of interval blocks, and each interval block corresponds to one equipment interval in the substation. After the division, the operation and maintenance data generated by different devices cannot interfere with each other.
The format of the demand box is substantially similar to the format of the information storage in the library. And decomposing the established demand frame from the work demand to obtain a plurality of keywords and filling the keywords into the corresponding intervals in the demand frame, and keeping the rest keywords empty if the number of the keywords obtained by decomposition is less than the number of the keywords in the character template. For example, the operation and maintenance work requirement is a temperature measurement requirement, the acquisition field is the oil temperature of the phase A of the #2 main transformer, the background current, the power, the background oil temperature and the like are acquired according to the association relation, and the formatted results are [ patrol library, time, #2 main transformer (interval 1), phase A (interval 1), (interval 2), (interval 3), \ 8230; \ 8230;).
For the demand box after the keywords are obtained, the data names can be positioned according to the data units, traversal searching is carried out through the keywords, the database containing the keywords is positioned, the data parameters are returned, and the related parameters are automatically filled into the demand box. For example, the temperature measurement requirement, the #2 main transformer A-phase oil temperature, the background current, the power, the background oil temperature and the like are required to be obtained, and the parameters such as the current, the power and the oil temperature returned by the database are correspondingly filled into the corresponding requirement frame according to the data name or the numerical unit.
It should be noted that, when traversing and searching are performed from the database according to the keywords, since the data volume in the substation is huge, in order to improve the data retrieval efficiency, a fast demand path needs to be confirmed. After the rapid demand path is confirmed, matching is carried out on the character template according to the path and the method, and corresponding data are obtained.
For a certain work requirement, extracting each requirement one by one, wherein the total quantity of the requirements is N, and meanwhile, establishing a mapping relation (requirement content-sequence position number of each requirement) so as to directly correspond to feedback at a later period. The number of paths confirming the work requirement each time is as follows:
wherein the content of the first and second substances,
representing the number of paths per demand, N beingThe number of demands.
Specifically, for the requirement of N =1 or a single branch, only the requirements are sorted, if the interval number belongs to the interval 1 block, the flow is directly switched to the interval 1, if the interval number belongs to the interval 2 block, the interval 1 block is skipped and the flow is directly switched to the interval 2 block, and in addition, if a plurality of requirements are in the same interval block, the requirements are inherited and traversed one by one according to the numbers, and the corresponding selection frame is further reduced.
And for the multi-branch requirement with N being more than 1, classifying and then sequencing, classifying the requirement number N according to the requirement type, dividing the requirement number into different intervals, performing traversal query according to the sequencing method, and performing corresponding feedback on the final result through the auxiliary code.
S500: and returning the operation and maintenance data required by the operation and maintenance work requirement according to the searched character template.
The embodiment provides a method for acquiring operation and maintenance work data requirements of a transformer substation, which comprises the steps of acquiring the association relation between each operation and maintenance work in the transformer substation and corresponding operation and maintenance data; establishing a corresponding primary database and a corresponding secondary database for different operation and maintenance works, wherein the database prestores operation and maintenance data through an array type character template, and all elements of an array correspond to one operation and maintenance operation and the operation and maintenance data generated by the operation and maintenance operation; determining required operation and maintenance data and a corresponding database according to operation and maintenance work requirements; traversing and searching a corresponding character template in a corresponding database according to the working requirement; and returning the operation and maintenance data required by the operation and maintenance work requirement according to the searched character template. According to the invention, the operation and maintenance data are pre-stored in an array form, and corresponding data can be obtained only by traversing and searching the corresponding database during each operation and maintenance work, so that the query time is saved, and the efficiency of the operation and maintenance work is improved.
The above is a detailed description of an embodiment of the method for acquiring the operation and maintenance work data requirement of the transformer substation according to the present invention, and the following is a detailed description of an embodiment of the system for acquiring the operation and maintenance work data requirement of the transformer substation according to the present invention.
The embodiment provides a transformer substation operation and maintenance work data demand acquisition system, including: the device comprises a data association unit, a database establishment unit, a database matching unit, a data retrieval unit and a data acquisition unit.
In this embodiment, the data association unit is configured to obtain an association relationship between each operation and maintenance work in the substation and corresponding operation and maintenance data.
In this embodiment, the database establishing unit is configured to establish a corresponding primary database for different operation and maintenance works, the primary database prestores the operation and maintenance data through the array-type text templates, and the array-type text templates are classified and stored according to actual intervals of the substation, wherein all elements of one array correspond to one operation and maintenance operation and maintenance data generated by the operation and maintenance operation, and the primary database is further provided with a plurality of secondary databases according to types of the operation and maintenance data.
In the database building unit, the array type text template specifically includes: a fixed text template and a dynamic link text template;
the elements of the fixed character template comprise a primary database name, a secondary database name, keywords and data parameters;
the elements of the dynamically linked text template include a primary database name, a secondary database name, time, keywords, and data parameters.
In this embodiment, the database matching unit is configured to obtain an operation and maintenance work requirement, and determine the required operation and maintenance data and the corresponding primary database and secondary database according to the operation and maintenance work requirement and the association relationship.
The method includes the steps of obtaining operation and maintenance work requirements in a database matching unit, determining needed operation and maintenance data and corresponding primary databases and secondary databases according to the operation and maintenance work requirements and an incidence relation, and specifically includes the following steps:
acquiring a field expressing the operation and maintenance work requirement, and extracting information of the field to obtain a task name, a required data type and a required data keyword of the operation and maintenance work;
and respectively determining and obtaining the first-level database name, the second-level database name and the key word corresponding to the operation and maintenance work data according to the incidence relation.
In this embodiment, the data retrieval unit is configured to search, in the corresponding primary database and the corresponding secondary database, the corresponding text template according to the work requirement in a traversal manner.
In the data retrieval unit, returning required operation and maintenance data in the corresponding primary database and secondary database based on operation and maintenance work requirements, specifically comprising:
establishing a demand frame and initializing each element position in the demand frame, wherein the elements of the demand frame comprise a demand task name, a demand type and a demand interval, and different demand intervals correspond to the division of each interval in the transformer substation;
filling the first-level database name, the second-level database name and the key words into a requirement frame corresponding to the requirement task name, the requirement type and the requirement interval;
traversing all the character templates in the database by using the keywords of the demand frame in the corresponding primary database and the secondary database until the corresponding character templates are matched;
returning the data parameters in the corresponding text template to the corresponding demand interval in the demand frame;
and acquiring required data of the operation and maintenance work requirement based on the requirement frame.
Further, in the data retrieval unit, traversing all the text templates in the database by using the keywords of the demand frame in the corresponding primary database and secondary database, specifically comprising:
determining the number of demands according to the keywords of the demand frame, and determining a rapid demand path based on the number of demands, wherein if the number of demands is a single demand or is a single branch demand, the keywords are sorted and then placed in corresponding intervals, and traversal search is performed according to the sorted keywords to match with corresponding text templates; if the number of the requirements is a plurality of and is the requirement of the multi-branch line, the keywords are classified and sequenced in sequence, then the keywords are put into corresponding requirement intervals, and traversal search is respectively carried out on different requirement intervals so as to match the corresponding character templates.
In this embodiment, the data obtaining unit is configured to return the operation and maintenance data required by the operation and maintenance work requirement according to the searched text template.
It should be noted that, the requirement obtaining system provided in this embodiment is used to implement the requirement obtaining method in the foregoing embodiment, and the specific settings of each unit are subject to complete implementation of the method, which is not described herein again.
The above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for acquiring operation and maintenance work data requirements of a transformer substation is characterized by comprising the following steps:
acquiring an incidence relation between each operation and maintenance work in the transformer substation and corresponding operation and maintenance data;
establishing a corresponding primary database for different operation and maintenance works, wherein the primary database prestores operation and maintenance data through an array type character template, and the array type character template is classified and stored according to the actual interval of a transformer substation, wherein all elements of one array correspond to one operation and maintenance operation and the operation and maintenance data generated by the operation and maintenance operation, and the primary database is also provided with a plurality of secondary databases according to the type of the operation and maintenance data;
acquiring operation and maintenance work requirements, and determining required operation and maintenance data and corresponding primary databases and secondary databases according to the operation and maintenance work requirements and the association relation;
traversing and searching the corresponding character template in the corresponding primary database and the second database according to the working requirement;
and returning the operation and maintenance data required by the operation and maintenance work requirement according to the searched character template.
2. The transformer substation operation and maintenance work data demand acquisition method according to claim 1, wherein the array type text template specifically comprises: a fixed text template and a dynamic link text template;
the elements of the fixed character template comprise a primary database name, a secondary database name, keywords and data parameters;
the elements of the dynamic link type character template comprise a primary database name, a secondary database name, time, keywords and data parameters.
3. The method for acquiring the operation and maintenance work data requirement of the transformer substation according to claim 2, wherein the step of acquiring the operation and maintenance work requirement, and determining the required operation and maintenance data and the corresponding primary database and secondary database according to the operation and maintenance work requirement and the association relationship specifically comprises the steps of:
acquiring a field expressing the operation and maintenance work requirement, and extracting information of the field to obtain a task name, a required data type and a required data keyword of the operation and maintenance work;
and respectively determining and obtaining the first-level database name, the second-level database name and the key word corresponding to the operation and maintenance work data according to the incidence relation.
4. The substation operation and maintenance work data demand acquisition method according to claim 3, wherein the step of returning required operation and maintenance data based on the operation and maintenance work demand in the corresponding primary database and the corresponding secondary database specifically comprises:
establishing a demand frame and initializing each element position in the demand frame, wherein the elements of the demand frame comprise a demand task name, a demand type and a demand interval, and different demand intervals correspond to the division of each interval in a transformer substation;
filling the first-level database name, the second-level database name and the key words into the requirement frame corresponding to the requirement task name, the requirement type and the requirement interval;
traversing all the character templates in the database by using the keywords of the requirement frame in the corresponding primary database and the secondary database until the corresponding character templates are matched;
returning the data parameters in the corresponding text template to the corresponding demand interval in the demand frame;
and acquiring the required data of the operation and maintenance work requirement based on the requirement frame.
5. The method for acquiring the operation and maintenance work data requirement of the transformer substation according to claim 4, wherein traversing all the text templates in the database by using the keywords of the requirement frame in the corresponding primary database and the secondary database specifically comprises:
determining the number of demands according to the keywords of the demand frame, and determining a rapid demand path based on the number of demands, wherein if the number of demands is a single demand or is a single branch demand, the keywords are sorted and then placed in corresponding intervals, and traversal search is performed according to the sorted keywords to match with corresponding text templates; and if the number of the requirements is a plurality of and is the requirement of multiple branches, classifying and sequencing the keywords in sequence, then putting the keywords into corresponding requirement intervals, and traversing and searching the keywords after respective sequencing for different requirement intervals so as to match the corresponding character templates.
6. The utility model provides a transformer substation's operation and maintenance work data demand acquisition system which characterized in that includes:
the data association unit is used for acquiring association relations between various operation and maintenance works in the transformer substation and corresponding operation and maintenance data;
the database establishing unit is used for establishing a corresponding primary database for different operation and maintenance works, the primary database prestores operation and maintenance data through an array type character template, and the array type character template is classified and stored according to the actual interval of the transformer substation, wherein all elements of one array correspond to one operation and maintenance operation and the operation and maintenance data generated by the operation and maintenance operation, and the primary database is also provided with a plurality of secondary databases according to the type of the operation and maintenance data;
the database matching unit is used for acquiring operation and maintenance work requirements, and determining required operation and maintenance data and corresponding primary databases and secondary databases according to the operation and maintenance work requirements and the incidence relation;
the data retrieval unit is used for traversing and searching the corresponding character template in the corresponding primary database and the corresponding secondary database according to the working requirement;
and the data acquisition unit is used for returning the operation and maintenance data required by the operation and maintenance work requirement according to the searched character template.
7. The substation operation and maintenance work data requirement acquisition system according to claim 6, wherein in the database establishing unit, the array type text template specifically comprises: a fixed text template and a dynamic link text template;
the elements of the fixed character template comprise a primary database name, a secondary database name, keywords and data parameters;
the elements of the dynamic link type character template comprise a primary database name, a secondary database name, time, keywords and data parameters.
8. The substation operation and maintenance work data demand acquisition system according to claim 7, wherein the operation and maintenance work demand is acquired in the database matching unit, and the required operation and maintenance data and the corresponding primary database and secondary database are determined according to the operation and maintenance work demand and the association relationship, and specifically includes:
acquiring a field expressing the operation and maintenance work requirement, and extracting information of the field to obtain a task name, a required data type and a required data keyword of the operation and maintenance work;
and respectively determining and obtaining the first-stage database name, the second-stage database name and the key word corresponding to the operation and maintenance work data according to the incidence relation.
9. The substation operation and maintenance work data demand acquisition system according to claim 8, wherein in the data retrieval unit, required operation and maintenance data is returned based on operation and maintenance work demands in the corresponding primary database and secondary database, and specifically includes:
establishing a demand frame and initializing each element position in the demand frame, wherein the elements of the demand frame comprise a demand task name, a demand type and a demand interval, and different demand intervals correspond to the division of each interval in a transformer substation;
filling the first-level database name, the second-level database name and the key words into the requirement frame corresponding to the requirement task name, the requirement type and the requirement interval;
traversing all the character templates in the database by using the keywords of the requirement frame in the corresponding primary database and the secondary database until the corresponding character templates are matched;
returning the data parameters in the corresponding text template to the corresponding demand interval in the demand frame;
and acquiring the required data of the operation and maintenance work requirement based on the requirement frame.
10. The substation operation and maintenance work data demand acquisition system according to claim 9, wherein in the data retrieval unit, in the corresponding primary database and secondary database, traversing all the text templates in the database by using the keywords of the demand frame specifically comprises:
determining the number of demands according to the keywords of the demand frame, and determining a rapid demand path based on the number of demands, wherein if the number of demands is a single demand or is a single branch demand, the keywords are sorted and then placed in corresponding intervals, and traversal search is performed according to the sorted keywords to match with corresponding text templates; and if the number of the requirements is a plurality of and is the requirement of the multi-branch line, classifying and sequencing the keywords in sequence, then putting the keywords into corresponding requirement intervals, and respectively performing traversal search on different requirement intervals so as to match the corresponding character templates.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211276451.9A CN115357602B (en) | 2022-10-19 | 2022-10-19 | Method and system for acquiring operation and maintenance work data requirements of transformer substation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211276451.9A CN115357602B (en) | 2022-10-19 | 2022-10-19 | Method and system for acquiring operation and maintenance work data requirements of transformer substation |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115357602A true CN115357602A (en) | 2022-11-18 |
| CN115357602B CN115357602B (en) | 2023-03-24 |
Family
ID=84008706
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211276451.9A Active CN115357602B (en) | 2022-10-19 | 2022-10-19 | Method and system for acquiring operation and maintenance work data requirements of transformer substation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115357602B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104991975A (en) * | 2015-07-30 | 2015-10-21 | 广东电网有限责任公司佛山供电局 | Data query method and system of electric power business systems |
| CN105677864A (en) * | 2016-01-08 | 2016-06-15 | 国网冀北电力有限公司 | Retrieval method and device for power grid dispatching structural data |
| CN107480239A (en) * | 2017-08-08 | 2017-12-15 | 国网山东省电力公司青岛供电公司 | A kind of power equipment testing regulations querying method and its application system |
| US20190340715A1 (en) * | 2018-05-06 | 2019-11-07 | Strong Force TX Portfolio 2018, LLC | Transaction-enabling systems and methods for using a smart contract wrapper to access embedded contract terms |
| WO2020147349A1 (en) * | 2019-01-14 | 2020-07-23 | 中国电力科学研究院有限公司 | Power distribution network operation aided decision-making analysis system and method |
| KR102274268B1 (en) * | 2020-08-20 | 2021-07-07 | 주식회사 더키 | Apparatus and method for managing energy using a plurality of database server |
| CN113918723A (en) * | 2021-11-25 | 2022-01-11 | 广东电网有限责任公司 | Equipment information classification method and device |
| CN114911826A (en) * | 2021-12-28 | 2022-08-16 | 天翼数字生活科技有限公司 | Associated data retrieval method and system |
-
2022
- 2022-10-19 CN CN202211276451.9A patent/CN115357602B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104991975A (en) * | 2015-07-30 | 2015-10-21 | 广东电网有限责任公司佛山供电局 | Data query method and system of electric power business systems |
| CN105677864A (en) * | 2016-01-08 | 2016-06-15 | 国网冀北电力有限公司 | Retrieval method and device for power grid dispatching structural data |
| CN107480239A (en) * | 2017-08-08 | 2017-12-15 | 国网山东省电力公司青岛供电公司 | A kind of power equipment testing regulations querying method and its application system |
| US20190340715A1 (en) * | 2018-05-06 | 2019-11-07 | Strong Force TX Portfolio 2018, LLC | Transaction-enabling systems and methods for using a smart contract wrapper to access embedded contract terms |
| WO2020147349A1 (en) * | 2019-01-14 | 2020-07-23 | 中国电力科学研究院有限公司 | Power distribution network operation aided decision-making analysis system and method |
| KR102274268B1 (en) * | 2020-08-20 | 2021-07-07 | 주식회사 더키 | Apparatus and method for managing energy using a plurality of database server |
| CN113918723A (en) * | 2021-11-25 | 2022-01-11 | 广东电网有限责任公司 | Equipment information classification method and device |
| CN114911826A (en) * | 2021-12-28 | 2022-08-16 | 天翼数字生活科技有限公司 | Associated data retrieval method and system |
Non-Patent Citations (1)
| Title |
|---|
| 徐兢浩等: "变电站设备运维检修管理数据平台构建及应用", 《东北电力技术》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115357602B (en) | 2023-03-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110108955B (en) | New energy grid-connected performance automatic test analysis platform and detection method | |
| CN111241129B (en) | Industrial production enterprise index data acquisition and calculation system | |
| CN114968984A (en) | Digital twin full life cycle management platform | |
| CN112948572A (en) | Method for visually displaying equipment information and relation of power system through knowledge graph | |
| CN112421454B (en) | Substation equipment diagnosis and maintenance platform based on Internet of things | |
| CN111815162A (en) | Digital auditing tool and method | |
| CN115344719A (en) | Automatic science and technology searching method and system | |
| CN115357602B (en) | Method and system for acquiring operation and maintenance work data requirements of transformer substation | |
| CN111177323A (en) | Power failure plan unstructured data extraction and identification method based on artificial intelligence | |
| CN113111659A (en) | Power inspection work ticket generation method, system, equipment and storage medium | |
| CN110956030B (en) | Method and system for comparing configuration information of remote machine of transformer substation | |
| CN113850489A (en) | Method and device for selecting high-voltage main network transformer based on Internet of things, product and storage medium | |
| CN110956283B (en) | Method and system for matching SCD file with soft pressing plate | |
| CN111275409A (en) | Power grid overhaul audit data processing system and processing method | |
| CN115934923B (en) | E-commerce replying method and system based on big data | |
| CN115357601B (en) | Method and system for acquiring real-time data of power transformation work | |
| CN117078447B (en) | Business financial linkage method, system, electronic equipment and storage medium | |
| CN113674115B (en) | University data management auxiliary system and method based on data management technology | |
| CN113961630A (en) | Application method of automatic unpacking program for X-ray fluorescence measurement of zinc layer weight of galvanized plate | |
| CN114862369A (en) | Distribution network automation manufacturer data sorting and analyzing method, device and storage medium | |
| CN114742244A (en) | Method and device for automatically generating transformer substation mirror image interval based on semantic identification | |
| CN117743592A (en) | Knowledge graph library construction system and method for high-voltage switch cabinet | |
| CN114065714A (en) | Intelligent analysis and automatic report generation method for factory test data of power distribution equipment | |
| CN116628849A (en) | Information capturing method based on CAD electrical schematic diagram | |
| CN115395477A (en) | Distribution network protection constant value digital management system |
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 |