A data mapping method and system for offline and online devices

Abstract

The present invention discloses a data mapping method and system for offline and online devices, belonging to the technical field of power system simulation and stability analysis. The method of the present invention comprises: adding a SCADA dictionary table according to the primary key information of the online device, and adding an online ID storage field in the device table; collecting the online device data of the online device and the offline device bound to the same device scheduling ID, storing the online device data in a preset storage structure, reading the primary key information in the online device data, and updating the primary key information to the SCADA dictionary table and the online ID storage field. In the present invention, the SCADA dictionary table is updated, and the scheduling name is changed and the mapped record is recorded, the scheduling name is updated synchronously, and the update log and statistics are supported, so that the maintenance personnel can check and maintain the mapping information conveniently.

Description

Technical Field

[0001] The present invention relates to the technical field of power system simulation and stability analysis, and more specifically, to a data mapping method and system for offline and online devices. Background Art

[0002] Power generation, substation, transmission, and power consumption systems are all complex systems that contain a large amount of information. Through data collection, structured processing, association, and fusion processing, relevant information can be integrated to the greatest extent possible, thus providing decision-makers in the power system with a diversified, basic data that reflects the overall view of the power grid and the entire operation trajectory as a basis for decision-making. The smart grid dispatching and control system (D5000 system) realizes the "horizontal integration and vertical connection" of power grid dispatching services, and based on the model sharing and integration of CIM / E, CIM / G standards and model splicing technology, vertically realizes the coordinated control of national, sub-provincial, and provincial dispatching services, and supports the full network sharing of real-time data, real-time images, and application functions.

[0003] Therefore, by collecting the online data (ID and QS file data) released by the D5000 system, the online mode of the power grid is realized, and the offline analysis and online control are coordinated. Although the power grid tends to be online for power grid analysis and decision-making, some power grid analysis and decision-making with huge calculation amount and low real-time requirements still need offline calculation, and offline analysis and online control need to be coordinated. Offline more advanced analysis is carried out to provide guidance for online calculation; online calculation corrects offline analysis results to make them more in line with reality. The maintenance of online and offline device mapping information is very important. Whether the device mapping information is complete will directly affect the correctness of the simulation analysis results. Summary of the invention

[0004] In view of the above problems, the present invention proposes a data mapping method for offline and online devices, comprising:

[0005] According to the primary key information of the online device, a new SCADA dictionary table is added, and an online ID storage field is added to the device table;

[0006] Collect the online device data of the online devices and offline devices bound to the same device scheduling ID, store the online device data in a preset storage structure, read the primary key information in the online device data, and update the primary key information to the SCADA dictionary table and the online ID storage field.

[0007] Optional, primary key information, including: device type, device scheduling ID, device scheduling name, whether the device has completed mapping information, whether the device is valid information and device notes.

[0008] Optional, the online ID storage field is in the form of a string separated by semicolons. The field before the semicolon is the device scheduling ID, and the field after the semicolon is the device scheduling name.

[0009] Optionally, the updating method is to update regularly at preset time intervals. After the updating is completed, the statistical information, the binding information of the offline device and the online device, and the log record are updated.

[0010] Optionally, before reading the online device data, the online device data is parsed to obtain a parsed file.

[0011] The present invention also proposes a data mapping system for offline and online devices, comprising:

[0012] Initialization module, based on the primary key information of the online device, adds a new SCADA dictionary table and adds an online ID storage field in the device table;

[0013] The mapping module collects the online device data of the online devices and offline devices bound to the same device scheduling ID, stores the online device data in a preset storage structure, reads the primary key information in the online device data, and updates the primary key information to the SCADA dictionary table and the online ID storage field.

[0014] Optional, primary key information, including: device type, device scheduling ID, device scheduling name, whether the device has completed mapping information, whether the device is valid information and device notes.

[0015] Optional, the online ID storage field is in the form of a string separated by semicolons. The field before the semicolon is the device scheduling ID, and the field after the semicolon is the device scheduling name.

[0016] Optionally, the updating method is to update regularly at preset time intervals. After the updating is completed, the statistical information, the binding information of the offline device and the online device, and the log record are updated.

[0017] Optionally, before reading the online device data, the online device data is parsed to obtain a parsed file.

[0018] The present invention updates the SCADA dictionary table while changing the scheduling name and recording the mapped information, synchronously updates the scheduling name, supports updating logs and statistics, and facilitates maintenance personnel to check and maintain the mapping information. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Figure 1 A flow chart of a data mapping method for offline and online devices according to the present invention;

[0020] Figure 2This is a flowchart of an offline and online device mapping information maintenance business according to an embodiment of a data mapping method for offline and online devices of the present invention;

[0021] Figure 3 A flowchart of reading an online ID file in an embodiment of a data mapping method for offline and online devices of the present invention;

[0022] Figure 4 A flow chart of updating a SCADA dictionary table of an online ID file in an embodiment of a data mapping method for offline and online devices of the present invention;

[0023] Figure 5 A flowchart of a method for data mapping between offline and online devices of the present invention is provided to update the PDDB device library online and offline binding device scheduling and naming flowchart;

[0024] Figure 6 The present invention is a structural diagram of a data mapping system for offline and online devices. DETAILED DESCRIPTION

[0025] Now, exemplary embodiments of the present invention are described with reference to the accompanying drawings. However, the present invention can be implemented in many different forms and is not limited to the embodiments described herein. These embodiments are provided to disclose the present invention in detail and completely and to fully convey the scope of the present invention to those skilled in the art. The terms used in the exemplary embodiments shown in the accompanying drawings are not intended to limit the present invention. In the accompanying drawings, the same units / elements are marked with the same reference numerals.

[0026] Unless otherwise specified, the terms (including technical terms) used herein have the commonly understood meanings to those skilled in the art. In addition, it is understood that the terms defined in commonly used dictionaries should be understood to have the same meanings as those in the context of the relevant fields, and should not be understood as idealized or overly formal meanings.

[0027] The present invention proposes a data mapping method for offline and online devices, such as Figure 1 As shown, including:

[0028] According to the primary key information of the online device, a new SCADA dictionary table is added, and an online ID storage field is added to the device table;

[0029] Collect the online device data of the online devices and offline devices bound to the same device scheduling ID, store the online device data in a preset storage structure, read the primary key information in the online device data, and update the primary key information to the SCADA dictionary table and the online ID storage field.

[0030] Primary key information includes: device type, device scheduling ID, device scheduling name, whether the device has completed mapping information, whether the device is valid information, and device notes.

[0031] The online ID storage field is in the form of a string separated by semicolons. The field before the semicolon is the device scheduling ID, and the field after the semicolon is the device scheduling name.

[0032] The updating method of the update is to update regularly at a preset time interval. After the update is completed, the statistical information, the binding information of the offline device and the online device and the log record are updated.

[0033] Before reading the online device data, parse the online device data to obtain the parsing file.

[0034] The present invention will be further described below in conjunction with embodiments:

[0035] The embodiment of the present invention is based on the power grid simulation calculation data management platform of the State Grid Simulation Center, and the main steps are as follows: Figure 2 As shown, it includes: PSDB database adjustment, timed import of online device primary key information, mapping information maintenance and mapping information application;

[0036] The details are as follows:

[0037] 1. PSDB database adjustment, including:

[0038] Create a new SCADA dictionary table:

[0039] Add a new SCADA dictionary table in the PSDB system to save the primary key information of online devices;

[0040] The primary key information includes: device type, online device ID, online device scheduling name, whether it has been mapped, whether it is a valid online device, remarks and other fields.

[0041] The device type, online device ID, online device scheduling naming field and online ID file device type, d5_id, name are consistent;

[0042] Whether it has been mapped and whether it is a valid online device field. To facilitate the subsequent mapping information inspection and verification functions, the mapping information maintenance specialist can use this tool to inspect and maintain the mapping information, such as: device mapping rate statistics, device mapping error inspection and output, etc.;

[0043] Adjustments to the PSDB device library:

[0044] Add an online ID storage field (SCADA_NAME) in the device table. For easy compilation and viewing, this field is designed to be separated by a semicolon ";". The first field is the dispatch ID, and the second field is the dispatch name. As an online device identifier, it supports 1:n mapping between online devices and PSDB devices.

[0045] For example, for the bus with primary key 1234 in the PSDB system, the SCADA_NAME string is: 115404740468146177; National Control. Echeng Converter Station / 500kV.1 Bus; 115404740468146178; National Control. Echeng Converter Station / 500kV.2 Bus; 115404740468146179; National Control. Gaoling Converter Station / 500kV.3 Bus, indicating that the three bus devices in the online system are mapped to the bus with primary key 1234 in the PSDB system.

[0046] 2. Timed import of online device master key information, including:

[0047] Offline and online device binding information update:

[0048] The PSDB system online collection service collects online data to the local system distributed file system every day, reads the collected online device primary key information regularly, refreshes the PSDB dictionary table, and refreshes the online scheduling name bound to the device in the PSDB library;

[0049] Scheduled updates:

[0050] The online data of the SCADA system is updated every 5 / 15 minutes. Each time the collected data is compared with the last time, there will be a small change. The present invention supports the user to execute the online data refreshing offline device function regularly according to the needs, and realizes it by starting the sub-process by the timer. The refresh online device information program execution event is 1-2 seconds, and the sub-process is exited after the execution is completed. If there is a special reason that the previous sub-process has not ended, the next sub-process is invalid and needs to wait for the previous sub-process to end. That is, there can only be one sub-process for refreshing online device information at the current moment;

[0051] Supports custom startup interval, currently set to start once a day;

[0052] When starting up, get the current time of the server, and read the first available ID file compression package of the day in the online collected data in the distributed file according to the time;

[0053] Copy the compressed package in the distributed file system to the program deployment directory, and decompress it to obtain the original ID file;

[0054] If the ID file is valid and has not been imported into the database, call the online and offline mapping program to update to the psdb database, back up the online ID file and generate relevant log records;

[0055] Online device data ID file E format analysis:

[0056] Use c to read E format ID files, use containers such as unordery_map and set, preset container sizes, and improve the efficiency of reading and subsequent data comparison and analysis as much as possible. The parsing process is as follows Figure 3 As shown;

[0057] Device uniqueness:

[0058] The ID in the online data is the primary key. This ID is the primary key of the equipment in the power grid dispatching system and is globally unique. In theory, the dispatching name is also globally unique. However, as the power grid is adjusted, the dispatching name will continue to change and adjust (for example, the transformer equipment is renamed after the transformer plant is expanded, and the line and bus are renamed). Therefore, in both online and offline devices, the device ID is used as a global variable;

[0059] Online record duplication:

[0060] There are a large number of records with the same device ID and different or identical dispatch names in the records. Especially in the plant records, a plant may contain multiple voltage levels. For example, the transformer high, medium and low voltage levels in the substation are different. This plant contains 3 voltage levels. There are three records with the same ID and dispatch name in the ID file, but different voltage levels. This patent only takes the first occurrence of the device ID and dispatch name, discards any subsequent records with the same ID, and records duplicate records in the ID import log;

[0061] Online device availability:

[0062] The validity judgment of online equipment includes that the equipment ID must be 18 digits and the dispatch name must not be empty, otherwise the equipment is invalid. At the same time, the dynamic changes of the power grid must be considered. Each online ID file is combined with the online QS file to record the power grid completely. Due to equipment commissioning, decommissioning, reconstruction and other reasons, the power grid equipment is constantly changing, including the equipment ID or dispatch name, that is, each online collection ID file and the data collected at the previous moment, there is a certain difference, and the equipment outside the collection ID file at the current moment is invalid.

[0063] Incremental update of SCADA dictionary tables

[0064] Considering the amount of data to be read and updated, and the execution efficiency, this patent is based on the Oracle OCCI library of C / C++, and further reads records locally in batches and updates data to the server. After testing, it is found that caching 10,000 records each time is the most efficient, supports transaction rollback, and cancels the operation on the SCADA table when a refresh error occurs. The process is as follows: Figure 4 shown.

[0065] Batch insert new ID records:

[0066] In the PSDB database dictionary table SCADA, batch insert the newly added equipment records in the online ID file. In addition to inserting the dispatch ID and dispatch name, the binding information defaults to none and the valid information defaults to valid.

[0067] Update the SCASD table scheduling name:

[0068] Update the records in the SCADA table with the same primary key but changed call names, and record the log table, including the ID primary key, and the online equipment scheduling name from the initial value to the latest value;

[0069] Update the SCADA table equipment effective status:

[0070] In the PSDB system, the online ID file is updated to the SCADA dictionary table. Each import of the SCADA table is incrementally updated, and the historical records are not automatically deleted. The user needs to maintain it manually to avoid the impact of misoperation on the binding result. In an ID import, the devices that exist in this ID file are set as valid devices, and the non-existent devices are set as invalid devices. When the SCADA table is updated in batches, the invalid devices and the changes of valid and invalid devices are recorded in the import log;

[0071] For invalid ID binding records that already exist in the SCADA table, considering that the device library has already established bindings, automatic deletion by the program may cause the loss of binding information. Users can filter out invalid device binding information through the PSDB mapping maintenance page and maintain it manually.

[0072] Update PSDB device binding information:

[0073] For devices that have been bound online and offline, if the dispatch name of the same dispatch ID changes, not only the dictionary table in PSDB needs to be refreshed, but also each bound device in the PSDB device library needs to be refreshed, such as Figure 5 As shown;

[0074] Online devices and PSDB devices are mapped 1:n, so a long string separated by semicolons ";" is saved in the SCADA_NAME field of each offline device. The first field is the dispatch ID, and the second field is the dispatch name. It may contain multiple such "ID; name" groups. When updating, check and replace the name group by group according to the ID;

[0075] Update statistics:

[0076] Query the PSDB system data dictionary table scada:

[0077] Read the number of all records in the scada table in the psdb database;

[0078] Query all bound device information in PSDB:

[0079] Read the number of all bound online devices in the psdb database;

[0080] Parse online ID file information and the parsing results of online ID files;

[0081] Valid records, the number of legal records in the ID file;

[0082] Duplicate records, with ID as the primary key, have multiple records;

[0083] Invalid records, the number of records with invalid ID or empty scheduling name;

[0084] New PSDB dictionary table SCADA equipment information:

[0085] The number of records added to the ID file relative to the PSDB database with the device ID as the primary key;

[0086] Update PSDB dictionary table SCADA equipment scheduling naming:

[0087] The ID file and PSDB library use the device ID as the primary key, and the number of records with the same ID but different call names;

[0088] Update Update PSDB dictionary table SCADA device status:

[0089] Update, the number of changes in the valid and invalid status of the device;

[0090] Valid, the valid number of devices in the scada table (primary key record in the latest id file);

[0091] Invalid, invalid number of devices in the scada table (no corresponding primary key record in the latest id file);

[0092] Online ID file update PSDB device library result statistics:

[0093] According to the device type, count the record changes of each device in this ID refresh;

[0094] ID file, in the scada ID file, the valid number of this type of equipment (ID is the primary key);

[0095] Scada table, in the scada table of PSDB, the effective number of this type of equipment (ID is the primary key);

[0096] Scada insertion, the number of new records for this type of equipment;

[0097] Scada update, the scada table uses id as the primary key, and the number of records where the equipment scheduling naming is changed;

[0098] Device table, the number of valid mappings of this type of device in the psdb system;

[0099] Equipment update: the equipment table of this type of equipment uses id as the primary key, and the number of records of equipment scheduling name changes;

[0100] Changelog records:

[0101] Each time the online ID update operation is executed, the original online ID file will be backed up, and a log file with the same name ending with log will be generated in the same directory as the ID file to record the changes to the PSDB library. Some of the records are as follows:

[0102] 1. ID[113997365584592897] changed from [Guo Diao. Echeng Converter Station] to [Guo Diao. Echeng Converter Station 1]

[0103] 2. ID [113997365584592901] changed from [National Traffic Control. Jiangling Converter Station] to [National Traffic Control. Jiangling Converter Station 1]

[0104] 3. ID[113997365584592919] changed from [Southwest. Fengjie Serial Compensation Station] to [Southwest. Fengjie Serial Compensation Station hz]

[0105] 4. ID[113997366322791640] changed from [Sichuan.Shuiluo] to [Southwest.Shuiluo Station]

[0106] 5. ID[113997366322791641] changed from [Sichuan.Xiangcheng] to [Southwest.Xiangcheng Station]

[0107] 6. ID [115404740635918648] changed from [Beijing.Xinhangcheng / 220kV.4A#busbar] to [North China.Xinhangcheng / 220kV.4A#busbar]

[0108] The specific record changes are as follows:

[0109] Prompts error records in Id file

[0110] 1. ID error data id[0] dispatch name: [Guodiao. Echeng Converter Station / 500kV.2 Bus]

[0111] 2. ID error data id[0] dispatch name: [National Dispatch.Gaoling Converter Station / 500kV.4 Busbar]

[0112] The Scada table has the same primary key ID but different records in different names

[0113] ID[117093591066608397] changed from [Sichuan.Ganquan / 3# Transformer 1] to [Sichuan.Ganquan / 3# Transformer]

[0114] ID[117093591066608398] changed from [Sichuan.Foguang / 1#Transformer 1] to [Sichuan.Foguang / 1#Transformer]

[0115] Records in each type of equipment table where scada_name has changed due to scheduling naming

[0116] Table [Transformer] id

[767] changed from [Sichuan. Ganquan / 3# Transformer 1] to [Sichuan. Ganquan / 3# Transformer]

[0117] Table [Transformer] id

[756] changed from [Sichuan. Foguang / 1# Transformer 1] to [Sichuan. Foguang / 1# Transformer]

[0118] Changes in device status

[0119] Scada table, device status change [1->0 or 0->1]

[0120] 3. Maintenance of mapping information:

[0121] Collaborative maintenance and data sharing:

[0122] Based on the PSDB system personnel permissions, the whole network equipment is collaboratively maintained according to the login personnel permissions, that is, "whoever owns the equipment, maintains it". The permissions of system users are determined by the user's role, the power grid to which they belong, and the visible scope. The specific rules are as follows:

[0123] The role defines which system functions the user can use from the perspective of the power grid to which he belongs. The offline and online mapping maintenance functions require the user to have the role of device management. With browsing permissions, the user can read-only view the devices under his jurisdiction, and with editing permissions, the user can edit them.

[0124] The power grid defines which part of the data in the system the user can exercise the data modification permissions granted by his role, ensuring that each unit and department maintains the data within its jurisdiction.

[0125] Define the scope of the power grid equipment and related data that users browse, including: Visible scope, which authorizes which power grid users are visible to this method, and the default authorization is visible to the power grid and its subordinates. Visible level: There are five levels: national, network, provincial, regional, and county. The system automatically selects according to the visible scope by default.

[0126] Mapping information is maintained in the device list:

[0127] The maintenance method of device mapping information is the same as that of parameter information. Users can log in to the power grid simulation calculation data management platform to maintain device mapping information.

[0128] Online and offline device dictionary table maintenance:

[0129] The online and offline equipment mapping information dictionary table maintenance interface is used to view and maintain the online ID file import information SACAD table through a graphical interface. The system provides mapping information checking and verification functions. The mapping information maintenance specialist can use this tool to check and maintain the mapping information, including: equipment mapping rate statistics, equipment mapping error checking and output, etc.

[0130] Online and offline information maintenance of equipment:

[0131] Maintain mapping related attributes in the system's device maintenance interface, that is, maintain the SCADA_NAME field in the device table through the graphical interface.

[0132] Maintain online and offline binding information records in the device list:

[0133] Based on the device parameter version control function of the PSDB system, the maintenance of the binding information will trigger the database trigger, record the original binding information, and record when and by whom the binding information was changed from the original value to what value.

[0134] Maintenance mapping information in the primary wiring diagram within the station:

[0135] The PSDB system provides a graphical maintenance view page based on the offline and online device binding information maintained in the form, which displays the device binding information on the primary wiring diagram in the station. If the device is a dotted line, it means that the device is not bound in the PSDB system. The selection form, background service interface and final effect of the online and offline maintenance of the device are consistent with the maintenance in the device list.

[0136] 4. Application of mapping information:

[0137] The mapping information can be exported simultaneously with the model data in PSDB to generate offline and online device mapping tables, including device type, online device ID, PSDB system device primary key, PSDB system device name, etc., for the PSASP model data to be used by the online offline data generation software.

[0138] The present invention also proposes a data mapping system 200 for offline and online devices, such as Figure 6 As shown, including:

[0139] Initialization module 201, based on the primary key information of the online device, adds a SCADA dictionary table and adds an online ID storage field in the device table;

[0140] The mapping module 202 collects the online device data of the online devices and the online devices in the offline devices bound to the same device scheduling ID, stores the online device data in a preset storage structure, reads the primary key information in the online device data, and updates the primary key information to the SCADA dictionary table and the online ID storage field.

[0141] Optional, primary key information, including: device type, device scheduling ID, device scheduling name, whether the device has completed mapping information, whether the device is valid information and device notes.

[0142] Optional, the online ID storage field is in the form of a string separated by semicolons. The field before the semicolon is the device scheduling ID, and the field after the semicolon is the device scheduling name.

[0143] Optionally, the updating method is to update regularly at preset time intervals. After the updating is completed, the statistical information, the binding information of the offline device and the online device, and the log record are updated.

[0144] Optionally, before reading the online device data, the online device data is parsed to obtain a parsed file.

[0145] The present invention updates the SCADA dictionary table while changing the scheduling name and recording the mapped information, synchronously updates the scheduling name, supports updating logs and statistics, and facilitates maintenance personnel to check and maintain the mapping information.

[0146] Those skilled in the art will appreciate that the embodiments of the present application can be provided as methods, systems, or computer program products. Therefore, the present application can adopt the form of complete hardware embodiments, complete software embodiments, or embodiments in combination with software and hardware. Moreover, the present application can adopt the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that contain computer-usable program code. The scheme in the embodiments of the present application can be implemented in various computer languages, for example, object-oriented programming language Java and literal scripting language JavaScript, etc.

[0147] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0148] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0149] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0150] Although the preferred embodiments of the present application have been described, those skilled in the art may make other changes and modifications to these embodiments once they have learned the basic creative concept. Therefore, the appended claims are intended to be interpreted as including the preferred embodiments and all changes and modifications falling within the scope of the present application.

[0151] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

Claims

1. A data mapping method for offline and online devices, the method comprising: According to the primary key information of the online device, a new SCADA dictionary table is added, and an online ID storage field is added to the device table; Collect online device data of online devices and offline devices bound to the same device scheduling ID, store the online device data in a preset storage structure, read the primary key information in the online device data, and update the primary key information to the SCADA dictionary table and the online ID storage field; The online ID storage field is in the form of a string separated by semicolons, the field before the semicolon is the device scheduling ID, and the field after the semicolon is the device scheduling name; The updating method of the update is to update regularly at a preset time interval. After the update is completed, the statistical information, the binding information of the offline device and the online device and the log record are updated; Before reading the online device data, the online device data is parsed to obtain a parsed file.

2. The method according to claim 1, wherein the primary key information comprises: Device type, device scheduling ID, device scheduling name, whether the device has completed mapping information, whether the device is valid information and device notes.

3. A data mapping system for offline and online devices, the system comprising: Initialization module, based on the primary key information of the online device, adds a new SCADA dictionary table and adds an online ID storage field in the device table; The mapping module collects the online device data of the online devices and the offline devices bound to the same device scheduling ID, stores the online device data in a preset storage structure, reads the primary key information in the online device data, and updates the primary key information to the SCADA dictionary table and the online ID storage field; The online ID storage field is in the form of a string separated by semicolons, the field before the semicolon is the device scheduling ID, and the field after the semicolon is the device scheduling name; The updating method of the update is to update regularly at a preset time interval. After the update is completed, the statistical information, the binding information of the offline device and the online device and the log record are updated; Before reading the online device data, the online device data is parsed to obtain a parsed file.

4. The system according to claim 3, wherein the primary key information comprises: Device type, device scheduling ID, device scheduling name, whether the device has completed mapping information, whether the device is valid information and device notes.

Images