CN116167719A - Method and system for realizing mapping between different systems of power equipment ledgers - Google Patents
Method and system for realizing mapping between different systems of power equipment ledgers Download PDFInfo
- Publication number
- CN116167719A CN116167719A CN202310094713.8A CN202310094713A CN116167719A CN 116167719 A CN116167719 A CN 116167719A CN 202310094713 A CN202310094713 A CN 202310094713A CN 116167719 A CN116167719 A CN 116167719A
- Authority
- CN
- China
- Prior art keywords
- equipment
- mapping
- centralized control
- control system
- ledger
- 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.)
- Pending
Links
- 238000013507 mapping Methods 0.000 title claims abstract description 106
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000003032 molecular docking Methods 0.000 claims abstract description 3
- 238000004590 computer program Methods 0.000 claims description 14
- 238000012545 processing Methods 0.000 claims description 9
- 238000004458 analytical method Methods 0.000 claims description 6
- 238000012795 verification Methods 0.000 claims description 2
- 238000012163 sequencing technique Methods 0.000 claims 1
- 238000010586 diagram Methods 0.000 description 16
- 230000006870 function Effects 0.000 description 14
- 238000003058 natural language processing Methods 0.000 description 10
- 238000005516 engineering process Methods 0.000 description 6
- 230000011218 segmentation Effects 0.000 description 5
- 230000008676 import Effects 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 241000282414 Homo sapiens Species 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 2
- 238000013506 data mapping Methods 0.000 description 2
- 238000013499 data model Methods 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000009795 derivation Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
Images
Classifications
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
-
- 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)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- General Health & Medical Sciences (AREA)
- Water Supply & Treatment (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention belongs to the technical field of intelligent substations of power systems, and provides a method and a system for realizing mapping between different systems of a power equipment ledger. Docking different centralized control system manufacturers, configuring basic information, accessing and mapping equipment accounts; after the basic information is configured, the acquired equipment account information of the centralized control system and the business center is stored into the system; and the model mapping relation table module is used for establishing the mapping relation between the device accounts of the centralized control system and the device accounts of the business center by means of automatic matching and manual checking. According to the invention, the equipment ledgers are correspondingly established among the equipment ledgers among different systems, so that the interconnection and intercommunication among the equipment ledgers among different systems are realized.
Description
Technical Field
The invention belongs to the technical field of intelligent substations of power systems, and particularly relates to a method and a system for realizing mapping among different systems of a power equipment ledger.
Background
The statements in this section merely provide background information related to the present disclosure and may not necessarily constitute prior art.
The existing equipment parts have more built systems, 3 centralized control factories are involved in a centralized control system, equipment account information between the systems cannot be corresponding to each other in an isolated mode, interconnection and intercommunication of the equipment accounts between the systems cannot be realized, and a business center cannot be timely informed of changing after the centralized control equipment is changed; because the attention angles of equipment in each system are different, the names of the same equipment in the field are different among the business center station, the centralized control system and the real-time measurement center station account, so that the business application difficulty of the professional departments of the equipment is increased.
For the current state of the system, the manual derivation is usually adopted to perform one-to-one correspondence, so that the workload of individuals is large, the time is long, and the error is easy to occur.
Disclosure of Invention
In order to solve the technical problems in the background art, the invention provides a method and a system for realizing mapping between different systems of a power equipment ledger, which acquire equipment ledger information in each system in a basic configuration and service calling mode; analyzing the information of the equipment names, voltage levels, affiliated places and the like in the equipment ledgers by using a data model and a Natural Language Processing (NLP) technology, and establishing a mapping relation of the equipment ledger information between the systems by using a similarity algorithm; the method and the device realize accurate correspondence of the stock data account mapping relation in the system, simplify the work corresponding to the equipment and improve the work efficiency.
In order to achieve the above purpose, the present invention adopts the following technical scheme:
the first aspect of the invention provides a method for realizing mapping between different systems of a power equipment ledger.
A method for realizing mapping between different systems of a power equipment ledger comprises the following steps:
docking different centralized control system manufacturers, configuring basic information, accessing and mapping equipment accounts;
after the basic information is configured, the acquired equipment account information of the centralized control system and the business center is stored into the system;
and the model mapping relation table module is used for establishing the mapping relation between the device accounts of the centralized control system and the device accounts of the business center by means of automatic matching and manual checking.
Further, in the configuring of the basic information, it includes: configuring the attribute of each equipment type according to the information of the configuration of the equipment type of the centralized control system; and configuring the attribute under each equipment type according to the information of the equipment type configuration of the service center.
The second aspect of the invention provides a system for realizing mapping between different systems of the power equipment ledger.
A system for implementing mapping between different systems of a power equipment ledger, comprising:
the basic configuration module is used for interfacing different centralized control system manufacturers, configuring basic information, accessing and mapping equipment accounts;
the stock data access module is used for storing the acquired equipment account information of the centralized control system and the business center station into the system after the basic information is configured;
and the model mapping relation table module is used for establishing the mapping relation between the device accounts of the centralized control system and the device accounts of the business center by means of automatic matching and manual checking.
A third aspect of the present invention provides a computer-readable storage medium.
A computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs steps in a method of implementing mapping between power equipment ledgers to different systems as described in the first aspect above.
A fourth aspect of the invention provides a computer device.
A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the processor implementing steps in a method of implementing mapping between different systems of a power equipment ledger as described in the first aspect above when the program is executed by the processor.
Compared with the prior art, the invention has the beneficial effects that:
(1) Interconnection and intercommunication between equipment accounts
The invention establishes the corresponding relation of the equipment ledger information among the systems, so that the equipment ledger information among the systems is interconnected and communicated; if the centralized control equipment is changed, the change information can be timely notified to the business center, and the corresponding relation between the equipment accounts is updated through the model mapping tool, so that the accurate corresponding relation between the equipment accounts is realized.
(2) System model quick correspondence
Aiming at the non-unification of the models among the systems, the model mapping tool configures basic information through the interface, and the model of the model mapping tool is utilized to correspond to the model of each system, so that the corresponding work of equipment is simplified.
(3) The workload of manual checking is reduced, and the working efficiency is improved
The invention automatically maps and manually checks the equipment accounts of the business center and the equipment accounts of the centralized control system through natural language analysis and similarity algorithm, and the unmatched equipment accounts are sorted according to the similarity in a reverse order to derive unmatched equipment lists, and the enforcers and the equipment owners participate in data management work.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the invention.
FIG. 1 is a flow chart of a method for implementing mapping between different systems of a power equipment ledger shown in the present invention;
FIG. 2 is a system architecture diagram illustrating the implementation of mapping between different systems of a power equipment ledger when the system is applied;
FIG. 3 is a functional block diagram of a system for implementing mapping between different systems of a power equipment ledger shown in the present invention;
FIG. 4 is a schematic diagram of a configuration of a service center device type according to the present invention;
FIG. 5 is a schematic view of an equipment ledger access shown in the present invention;
FIG. 6 is a schematic diagram of an automated mapping of device ledgers according to the present invention
Fig. 7 is a schematic diagram of a device ledger mapping relation query shown in the present invention.
Detailed Description
The invention will be further described with reference to the drawings and examples.
It should be noted that the following detailed description is illustrative and is intended to provide further explanation of the invention. Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs.
It is noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting of exemplary embodiments according to the present invention. As used herein, the singular is also intended to include the plural unless the context clearly indicates otherwise, and furthermore, it is to be understood that the terms "comprises" and/or "comprising" when used in this specification are taken to specify the presence of stated features, steps, operations, devices, components, and/or combinations thereof.
It is noted that the flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of methods and systems according to various embodiments of the present disclosure. It should be noted that each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the logical functions specified in the various embodiments. It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the flowchart illustrations and/or block diagrams, and combinations of blocks in the flowchart illustrations and/or block diagrams, can be implemented by special purpose hardware-based systems which perform the specified functions or operations, or combinations of special purpose hardware and computer instructions.
Term interpretation:
mapping relation table: and the database structure is used for storing conversion relations among different types of system data.
And the centralized control system: the new generation centralized control station equipment monitoring system (abbreviated as a centralized control system) is deployed in the centralized control station to realize the remote management and centralized monitoring of equipment under the centralized control station.
Equipment standing book: the related information of the power system resources participating in modeling of the centralized control station comprises containers, primary equipment, secondary equipment, auxiliary equipment and the like which form a power grid.
Natural Language Processing (NLP): the computer is used for processing, understanding and utilizing natural language (such as Chinese, english and the like) of human beings, so that the machine and the human beings can communicate smoothly and smoothly.
Natural Language Analysis (NLA): based on NLP (natural language processing) technology, the processing result is applied to data analysis, and finally, the operations of inquiring, analyzing and the like on the data in the information system by using natural language are realized.
IK segmenter: the IK word segmentation device is an insert of the ES and is mainly used for dividing a section of Chinese or English into individual keywords.
Example 1
As shown in fig. 1, this embodiment provides a method for implementing mapping between different systems of a power equipment ledger, including:
aiming at inconsistent construction models among different manufacturers, the basic information is configured, so that different centralized control manufacturers can be conveniently docked, and data access and data mapping work can be performed;
acquiring equipment account information in the centralized control system and the business center station in a leading-in or interface calling mode;
and establishing a mapping relation between the acquired equipment accounts of the business center and the equipment accounts of the centralized control system in an automatic mapping and manual checking mode.
In this embodiment, the configuration of the basic information is first performed to prepare the equipment account information of the central control system and the station in the subsequent access service;
specifically, during basic configuration, a system administrator needs to perform maintenance management of the centralized control station, and the maintenance management mainly comprises functions of adding, deleting, checking, exporting and the like, so that information of the basic configuration is perfected.
Next, the device type is required to be maintained and managed according to the device type range which is actually accessed to the service center station and the centralized control system, and the functions of adding, deleting, checking, exporting and the like are included;
after the device type is configured, the device type attribute needs to be configured according to the configured device type, and then mapping work is performed on the device type attribute.
In this embodiment, the device account information in the centralized control system and the service center is acquired by means of import or interface call;
after the information configuration in the basic configuration is completed, the system acquires the account information of the equipment in the business by using a mode of calling by a person through an interface; the account information of the centralized control system equipment needs to be acquired in a file importing mode.
In this embodiment, the system uses a person to analyze the device ledger through an IK word segmentation device and a natural language analysis technology, then automatically maps through a similarity algorithm, and establishes a mapping relationship between the device ledgers in a manual checking mode.
The IK word segmentation device mainly divides a section of Chinese or English into individual keywords; the natural language analysis technology is based on NLP (natural language processing) technology, and the processing result is applied to data analysis, so that the operations of inquiring, analyzing and the like on the data in the information system by using natural language are finally realized.
After the system acquires the equipment account information of the business center station and the centralized control system, the equipment account information is stored in a system database. The information such as the equipment name, the voltage level and the like is divided into individual keywords through an IK word segmentation device, and then the expansion word, the synonym and the stop word are configured.
When a user performs data mapping, full text retrieval is performed on a database according to selected equipment type conditions, unnecessary information in the equipment ledger is automatically ignored through stop words configured by an IK word segmentation device, then keyword searching is performed according to a pre-established index, meanwhile, ledger information meeting the conditions is searched out through pre-configured expansion words and synonyms, and then the equipment ledger information is analyzed and processed through natural language processing; and then, carrying out automatic matching according to a similarity algorithm, and accurately establishing a mapping relation between the equipment accounts by a manual checking mode.
Fig. 2 is an application schematic diagram of a model mapping tool, and the method according to this embodiment should be applied to the model mapping tool, so as to implement interconnection and interworking between device accounts between different systems on the province company side and the province super/city side.
Example two
As shown in fig. 3, this embodiment provides a system for implementing mapping between different systems of a power equipment ledger, which includes a basic configuration module, a stock data access module, and a model mapping relation table module.
The basic configuration module configures basic information aiming at inconsistent construction models among centralized control system manufacturers, and the service is mainly used for conveniently interfacing different centralized control system manufacturers and performing equipment account access and mapping.
Specifically, the base configuration module includes: the system comprises a centralized control system centralized control station configuration module, a service center equipment type configuration module, a centralized control system equipment type configuration module, a service center equipment type attribute configuration module, a centralized control system equipment type attribute configuration module and an equipment type attribute mapping module.
Centralized control system centralized control station configuration module: and aiming at each centralized control system of different factories, the basic configuration of the centralized control station is carried out, such as the name of the centralized control station, the place of sale, the IP of the system and the like.
Service center equipment type configuration module: configuring the type of the service center equipment according to the range of the type of the service center actual access equipment; such as device type code, name, english name, etc., as shown in fig. 4.
The centralized control system equipment type configuration module: configuring according to the type of the equipment accessed by the centralized control system and associating with the type of the equipment configured by the service center; such as device type code, name, english name, etc.
Service center equipment type attribute configuration module: and configuring the attribute under each equipment type, such as attribute name, attribute type and the like, according to the information of the equipment type configuration of the service center.
The centralized control system equipment type attribute configuration module: and configuring the attribute under each equipment type, such as attribute name, attribute type and the like, according to the information of the configuration of the equipment type of the centralized control system.
Device type attribute mapping module: selecting a certain equipment type under the centralized control system, and mapping the configured equipment type attribute of the centralized control system and the service center station with the equipment type attribute of the mapping tool; device type attribute mappings may also be derived.
The stock data access module mainly acquires the equipment account information of the centralized control system and the business center station through an interface or a file import mode after the basic information is configured, stores the equipment account information into the system, and provides functions of displaying and exporting the equipment account information.
Specifically, the stock data access module includes: the system comprises a business center station equipment account access module and a centralized control system equipment account access module.
The service center station equipment account access module: according to the information of the basic configuration, the equipment account information required in the system is acquired by calling the interface of the business center, as shown in fig. 5.
Centralized control system equipment standing book access module: the system reads the file exported from the centralized control system in an import mode to acquire the equipment account information of the centralized control system.
The model mapping relation table module mainly establishes a mapping relation between the centralized control system and the equipment accounts of the business center by means of automatic matching and manual checking, and provides a display and export function of the equipment account mapping relation.
Specifically, the model mapping relation table module includes: the system comprises an equipment ledger automatic mapping module, an equipment ledger manual mapping module and an equipment ledger mapping relation query module.
The automatic mapping module of the equipment standing book: after the system acquires the equipment ledger information of the business center and the centralized control system, firstly, analyzing and processing key words in the equipment ledger by using a data model and a computer natural language processing technology, then, scanning a related database, generating a corresponding analysis result according to requirements, and finally, establishing an accurate mapping relation between the centralized control system and the business center equipment ledger by using a similarity algorithm; the mapping information presentation and export functions are provided as shown in fig. 6.
The equipment ledger manual mapping module: the equipment ledger mapping relation after the automatic mapping is finished firstly shows matching similarity values according to a similarity algorithm, sequences are arranged in a reverse order according to the similarity, and then a user can refer to the automatically mapped data according to the similarity values to serve as a verification mode of the automatic mapping; finally, the ledger mapping with low similarity matching can firstly remove the mapping relation, and then establish the mapping relation between the ledgers through manual mapping; and providing a mapping relation for export and display functions.
And the equipment ledger mapping relation query module is used for: a presentation and export function of the device ledger mapping relationship established according to the automatic matching and manual mapping is provided, as shown in fig. 7.
Example III
The present embodiment provides a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, implements the steps in the method for implementing mapping between different systems of a power equipment ledger as described in the above embodiment.
Example IV
The present embodiment provides a computer device, including a memory, a processor, and a computer program stored in the memory and capable of running on the processor, where the processor implements the steps in the method for implementing mapping between different systems of a power equipment ledger according to the above embodiment when executing the program.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of a hardware embodiment, a software embodiment, or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, magnetic disk storage, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations 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.
Those skilled in the art will appreciate that implementing all or part of the above-described methods in accordance with the embodiments may be accomplished by way of a computer program stored on a computer readable storage medium, which when executed may comprise the steps of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a Random access Memory (Random AccessMemory, RAM), or the like.
The above description is only of the preferred embodiments of the present invention and is not intended to limit the present invention, but various modifications and variations can be made to the present invention by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (10)
1. The method for realizing mapping between different systems of the power equipment ledger is characterized by comprising the following steps:
docking different centralized control system manufacturers, configuring basic information, accessing and mapping equipment accounts;
after the basic information is configured, the acquired equipment account information of the centralized control system and the business center is stored into the system;
and the model mapping relation table module is used for establishing the mapping relation between the device accounts of the centralized control system and the device accounts of the business center by means of automatic matching and manual checking.
2. The method for implementing mapping between different systems of a power equipment ledger according to claim 1, characterized in that, when the basic information is configured, it includes: configuring the attribute of each equipment type according to the information of the configuration of the equipment type of the centralized control system; and configuring the attribute under each equipment type according to the information of the equipment type configuration of the service center.
3. A system for implementing mapping between different systems of a power equipment ledger, comprising:
the basic configuration module is used for interfacing different centralized control system manufacturers, configuring basic information, accessing and mapping equipment accounts;
the stock data access module is used for storing the acquired equipment account information of the centralized control system and the business center station into the system after the basic information is configured;
and the model mapping relation table module is used for establishing the mapping relation between the device accounts of the centralized control system and the device accounts of the business center by means of automatic matching and manual checking.
4. The system for implementing mapping between different power equipment accounts according to claim 3, wherein the basic configuration module comprises:
the centralized control system centralized control station configuration module is used for basic configuration of the centralized control station;
the centralized control system equipment type configuration module is used for configuring according to the equipment type accessed by the centralized control system and is associated with the equipment type configured by the service center;
and the centralized control system equipment type attribute configuration module is used for configuring the attribute under each equipment type according to the information of the centralized control system equipment type configuration.
5. The system for implementing mapping between power equipment ledgers and different systems according to claim 3, wherein said basic configuration module further comprises:
the service center equipment type configuration module is used for configuring the service center equipment type according to the service center actual access equipment type range;
and the service center equipment type attribute configuration module is used for configuring the attribute under each equipment type according to the information of the service center equipment type configuration.
6. The system for implementing mapping between power equipment ledgers and different systems according to claim 3, wherein said basic configuration module further comprises:
the device type attribute mapping module is used for selecting a certain device type under the centralized control system and mapping the configured device type attribute of the centralized control system and the service center station with the device type attribute of the mapping tool; allowing device type attribute mappings to be exported.
7. The system for implementing mapping between different systems of a power equipment ledger of claim 3, wherein said stock data access module comprises:
the business center station equipment account access module is used for acquiring equipment account information required in the system by calling an interface of the business center station according to the basic configuration information;
and the centralized control system equipment ledger access module is used for reading the files exported from the centralized control system in an importing mode and obtaining the centralized control system equipment ledger information.
8. The system for implementing mapping between different systems of a power equipment ledger according to claim 3, characterized in that said model mapping relation table module includes:
the equipment ledger automatic mapping module is used for analyzing and processing key words in the equipment ledgers according to the equipment ledger information of the business center and the centralized control system, generating corresponding analysis results according to requirements, and establishing an accurate mapping relation between the centralized control system and the business center equipment ledgers through a similarity algorithm;
the device ledger manual mapping module is used for automatically mapping the completed device ledger mapping relation, displaying and matching similarity values according to a similarity algorithm, sequencing the device ledgers according to a similarity reverse order, and referring the automatically mapped data according to the similarity values to serve as a verification mode of automatic mapping; the ledger mapping with low similarity is firstly subjected to mapping de-mapping, and then a mapping relation between the ledgers is established through manual mapping;
and the equipment ledger mapping relation query module is used for providing the display and the export of the equipment ledger mapping relation established according to the automatic matching and the manual mapping.
9. A computer readable storage medium, on which a computer program is stored, which program, when being executed by a processor, implements the steps of the method of implementing mapping between different systems of a power equipment ledger as claimed in any one of claims 1-2.
10. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor, when executing the program, implements the steps of the method of implementing the mapping between the different systems of the power device ledger of any one of claims 1-2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310094713.8A CN116167719A (en) | 2023-02-07 | 2023-02-07 | Method and system for realizing mapping between different systems of power equipment ledgers |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310094713.8A CN116167719A (en) | 2023-02-07 | 2023-02-07 | Method and system for realizing mapping between different systems of power equipment ledgers |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN116167719A true CN116167719A (en) | 2023-05-26 |
Family
ID=86410845
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310094713.8A Pending CN116167719A (en) | 2023-02-07 | 2023-02-07 | Method and system for realizing mapping between different systems of power equipment ledgers |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116167719A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116521852A (en) * | 2023-06-26 | 2023-08-01 | 南京实创信息技术有限公司 | Power equipment intelligent mapping tool and mapping method based on deep learning |
-
2023
- 2023-02-07 CN CN202310094713.8A patent/CN116167719A/en active Pending
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116521852A (en) * | 2023-06-26 | 2023-08-01 | 南京实创信息技术有限公司 | Power equipment intelligent mapping tool and mapping method based on deep learning |
| CN116521852B (en) * | 2023-06-26 | 2023-09-19 | 南京实创信息技术有限公司 | Deep learning-based intelligent mapping device and mapping method for power equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105373599B (en) | Data mover system based on various data storing platforms | |
| CN108132957B (en) | Database processing method and device | |
| CN111159330B (en) | Database query statement generation method and device | |
| CN102279848A (en) | Method and device for generating report template | |
| CN103020158A (en) | Report form creation method, device and system | |
| CN114201616A (en) | Knowledge graph construction method and system based on multi-source database | |
| CN105046604A (en) | Patent information management system | |
| CN112651218A (en) | Automatic generation method and management method of bidding document, medium and computer | |
| CN116167719A (en) | Method and system for realizing mapping between different systems of power equipment ledgers | |
| CN109815254A (en) | Cross-region method for scheduling task and system based on big data | |
| CN113204329A (en) | Control method for driving business application by unified data model and application system thereof | |
| CN108197187A (en) | Optimization method, device, storage medium and the computer equipment of query statement | |
| CN113642299A (en) | One-key generation method based on power grid statistical form | |
| CN108829651A (en) | A kind of method, apparatus of document treatment, terminal device and storage medium | |
| CN111427865A (en) | Method and device for managing objects of database | |
| CN116010570A (en) | Knowledge graph-based power data query method and device and electronic equipment | |
| CN113626571B (en) | Method, device, computer equipment and storage medium for generating answer sentence | |
| CN106168949B (en) | The method and device that database is split | |
| CN105843605B (en) | A kind of data mapping method and device | |
| CN110704653A (en) | Method for searching component by graph in BIM (building information modeling) model and graph-text searching system | |
| CN109343835A (en) | A kind of rapid build business scaffold code instrumentation based on template | |
| CN110059967B (en) | Data processing method and device applied to city aid decision analysis | |
| CN111784192A (en) | Industrial park emergency plan executable system based on dynamic evolution | |
| CN116307566B (en) | Dynamic design system for large-scale building construction project construction organization scheme | |
| CN110515926A (en) | Heterogeneous data source mass data carding method based on participle and semantic dependency analysis |
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 |