A method for scheduling data items of a collection terminal

By using replacement IDs and basic IDs to identify data items on the data acquisition terminal and establishing a query table, data items are scheduled according to their status. This solves the problem of low data acquisition efficiency under various meter types and reading mechanisms, and achieves more efficient data acquisition.

CN119807217BActive Publication Date: 2025-11-21NINGBO SANXING MEDICAL & ELECTRIC CO LTD
View PDF 2 Cites 0 Cited by

Patent Information

Application Number
CN202411848529.9
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-12-16
Publication Date
2025-11-21
Estimated Expiration
2044-12-16

AI Technical Summary

Technical Problem

Existing data acquisition terminals suffer from low acquisition efficiency and excessive resource consumption when dealing with various meter types and reading mechanisms, making it difficult to meet the reading needs of complex distribution areas.

Method used

Data items are identified using "replacement ID + base ID + collection status + collection count", and a first lookup table and a second lookup table are established. The tables are arranged and combined according to the meter communication protocol and phase, and the data items in different states are scheduled until the data collection is successful.

Benefits of technology

It improves the data item scheduling efficiency of the data acquisition terminal, simplifies the meter reading scenario, and enhances the compatibility and meter reading efficiency of the data acquisition terminal.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

The application relates to a kind of collection terminal data item scheduling method, comprising the following steps: step 1, using "replace ID+base ID+collection state+collection times" to identify each data item to be scheduled of collection terminal;The collection state of each data item is default initial state;Step 2, according to the communication protocol of meter and phase, establish query table database, each communication protocol and phase are arranged combination, establish first query table and second query table, the first query table has stored base ID and its corresponding data item ID in advance, the second query table has stored replace ID and its corresponding next round existing replace data item ID in advance;Step 3, according to the collection state in different state, according to the data item scheduling method under each state is handled, until data collection is successful.The advantage lies in: the method is according to the data scheduling of collection state, compatible field demand, simplify meter reading scene, improve meter reading efficiency.
Need to check novelty before this filing date? Find Prior Art

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data collection, in particular to a collection terminal data item scheduling method. BACKGROUND

[0002] At present, with the development of the power industry and the wide application of power collection technology, the functions and applications of collection terminals are becoming more and more complex. A collection terminal usually mounts hundreds or thousands of meters, and the collection terminal needs to fully adapt to various meters. There are various types of meters, which are divided into single-phase, three-phase three-wire, three-phase four-wire, etc. according to the phase, and are divided into inductive type, electromechanical type, etc. according to the working principle, and are divided into 645-97 meter, 645-07 meter, 698 meter, etc. according to the meter communication protocol. Among these types of meters, there are various reading mechanisms according to different standards. Since the various reading mechanisms support different meters, the collection terminal does not achieve the expected collection efficiency.

[0003] In addition, in the actual transformer area, the collection terminal needs to support various reading mechanisms in the task scheduling process. According to the type of meter and the reading scene, the data items of the same task are divided into frozen data reading, real-time data reading, frozen-to-real-time reading, and replacement id reading scenes. The various actual scenes result in the need to support various reading mechanisms of the meter. Each reading mechanism needs to separately increase the program to realize the reading function. The modification of the reading function also needs to synchronously adjust the programs corresponding to all reading mechanisms. When there are various types of meters in the transformer area, the collection resources are occupied too much, and the reading efficiency of the meter does not achieve the expected effect. SUMMARY

[0004] The technical problem to be solved by the present application is to provide a collection terminal data item scheduling method that can improve the collection efficiency.

[0005] The technical solution adopted by the present application to solve the above technical problem is: a collection terminal data item scheduling method, characterized by comprising the following steps:

[0006] Step 1: using "replacement ID + basic ID + collection state + collection times" to identify each data item to be scheduled of the collection terminal; the collection state of each data item is the initial state by default;

[0007] Step 2: establishing a query table database according to the communication protocol and the phase of the meter. Each communication protocol and phase is arranged in combination to establish a one-to-one correspondence between the first query table and the second query table. The first query table has stored therein the basic ID of each type of meter and the corresponding data item ID. The second query table has stored therein the replacement ID of each type of meter and the corresponding replacement data item ID existing in the next round;

[0008] Step 3, the copying of all data items is completed in turn according to the following method, and the specific process of copying data of one data item is as follows:

[0009] Step 3-1, when the collection terminal performs data item scheduling for the first time, and the collection state is the initial state, the data item ID corresponding to the basic ID of the data item to be scheduled is found in the first query table, it is judged whether the data item ID corresponding to the basic ID of the data item to be scheduled can be found in the first query table, if yes, the found data item ID is assigned to the replacement ID of the data item to be scheduled, the collection number is added by 1, and step 3-2 is entered; if no, the collection state of the data item to be scheduled is switched to the replacement state, the collection number is added by 1, and step 3-3 is entered;

[0010] Step 3-2, the corresponding meter data is collected using the replacement ID of the data item to be scheduled, and the collection state is switched to different states according to different contents returned by the meter, when the collection state is in different states, the data item scheduling method under each state is processed until the data collection is successful;

[0011] Step 3-3, when the collection state is the replacement state, the next round of existing replacement data item ID corresponding to the replacement ID of the data item to be scheduled is found in the second query table, it is judged whether the next round of existing replacement data item ID corresponding to the replacement ID of the data item to be scheduled can be found in the second query table, if yes, the found next round of existing replacement data item ID is assigned to the replacement ID of the data item to be scheduled for copying; if no, step 3-4 is entered;

[0012] Step 3-4, it is judged whether the real-time conversion mechanism is started, if yes, the collection state is set to the real-time state; if no, the collection state is set to the initial state, and the same data item scheduling method under the initial state in step 3-1 is processed.

[0013] Preferably, in step 3-2, the collection state is switched to different states according to different contents returned by the meter, specifically:

[0014] If the meter returns normal data, the collection state is switched to the success state;

[0015] If the meter returns no data, the collection state is switched to the empty state, and the current collection number is added by 1;

[0016] If the meter returns error data, the collection state is switched to the replacement state, and the current collection number is added by 1.

[0017] Preferably, if the collection state is the success state, the data collection is successful.

[0018] Preferably, if the collection state is the empty state, then the last replacement ID is collected to continue collecting the meter data, and after the collection times reach the preset number of times, the collection state is switched to the replacement state.

[0019] Preferably, the preset number of times d is in the range of 2≤d≤5.

[0020] Preferably, the preset number of times d is 3.

[0021] Preferably, the step 2 further comprises establishing a third query table, and the third query table has stored the replacement ID and the corresponding real-time data item ID in advance.

[0022] Preferably, if the collection state is the real-time state, then the replacement ID corresponding real-time data item ID is searched in the third query table, if the replacement ID corresponding real-time data item ID can be found in the third query table, then the real-time data item ID is assigned to the replacement ID for reading; if the replacement ID corresponding real-time data item ID cannot be found in the third query table, then the collection state is set to the initial state.

[0023] Preferably, the replacement ID and the basic ID in the step 1 are the default IDs of the master station when the master station issues a task, and the master station is in communication connection with the collection terminal.

[0024] Preferably, the initial value of the collection times in the step 1 is 0.

[0025] Compared with the prior art, the advantages of the present application are that: by establishing the first query table and the second query table, the first query table has stored the basic ID and the corresponding data item ID in advance, the second query table has stored the replacement ID and the corresponding next round existing replacement data item ID in advance, and when the collection state is in different states, then the data item scheduling method under each state is processed until the data collection is successful; therefore, the method schedules data according to the collection state, is compatible with the field demand, simplifies the meter reading scene, and improves the meter reading efficiency. DETAILED DESCRIPTION

[0026] The present application is further described in detail below in combination with embodiments.

[0027] The data item scheduling method of the collection terminal in the embodiment comprises the following steps:

[0028] Step 1, using “replacement ID+basic ID+collection state+collection times” to identify each data item to be scheduled of the collection terminal; the collection state of each data item is the initial state by default;

[0029] In the embodiment, the replacement ID and the basic ID are the default IDs of the master station when the master station issues a task, and the master station is in communication connection with the collection terminal; the initial value of the collection times is 0.

[0030] Step 2, according to the communication protocol of the meter and the phase, establish a query table database, each communication protocol and phase is arranged in combination, to establish a one-to-one correspondence between the first query table and the second query table, the first query table has stored in advance the basic ID of each type of meter and the corresponding data item ID, the second query table has stored in advance the replacement ID of each type of meter and the corresponding next round existing replacement data item ID;

[0031] Step 3, according to the following method, complete the reading of all data items in turn, and the specific process of data reading of one data item is as follows:

[0032] Step 3-1, when the acquisition terminal first schedules the data item, when the acquisition state is the initial state, find the data item ID corresponding to the basic ID of the data item to be scheduled in the first query table, and judge whether the data item ID corresponding to the basic ID of the data item to be scheduled can be found in the first query table. If yes, assign the found data item ID to the replacement ID of the data item to be scheduled, add 1 to the acquisition number, and go to step 3-2; if not, switch the acquisition state of the data item to be scheduled to the replacement state, add 1 to the acquisition number, and go to step 3-3;

[0033] Step 3-2, use the replacement ID of the data item to be scheduled to collect the corresponding meter data, and switch the acquisition state to different states according to different contents returned by the meter, when the acquisition state is in different states, then process according to the data item scheduling method under each state until the data acquisition is successful;

[0034] Step 3-3, when the acquisition state is the replacement state, find the next round existing replacement data item ID corresponding to the replacement ID of the data item to be scheduled in the second query table, and judge whether the next round existing replacement data item ID corresponding to the replacement ID of the data item to be scheduled can be found in the second query table. If yes, assign the found next round existing replacement data item ID to the replacement ID of the data item to be scheduled for reading; if not, go to step 3-4;

[0035] Step 3-4, judge whether to start the real-time mechanism, if yes, set the acquisition state to the real-time state; if not, set the acquisition state to the initial state, and process according to the same data item scheduling method in step 3-1 when the acquisition state is the initial state.

[0036] In step 3-2 above, the acquisition state is switched to different states according to different contents returned by the meter, which is as follows:

[0037] If the meter returns normal data, the acquisition state is switched to the success state;

[0038] If the meter returns no data, the collection state is switched to the empty state, and the current collection number is incremented by 1.

[0039] If the meter returns error data, the collection state is switched to the replacement state, and the current collection number is incremented by 1.

[0040] If the collection state is the success state, the data collection is successful.

[0041] If the collection state is the empty state, the last replacement ID is collected to continue collecting meter data, and until the collection number reaches a preset number, the collection state is switched to the replacement state. The preset number d is in the range of 2≤d≤5, and in the embodiment, the preset number d=3.

[0042] The step 2 further includes establishing a third query table, which has stored the replacement ID and the corresponding real-time data item ID. The first query table, the second query table and the third query table are all determined by the meter itself according to different protocols, and each single protocol meter has a set of tables. When reading the meter data, the exclusive query table is automatically queried according to the meter protocol.

[0043] If the collection state is the real-time state, the real-time data item ID corresponding to the replacement ID is searched in the third query table. If the real-time data item ID corresponding to the replacement ID can be found in the third query table, the real-time data item ID is assigned to the replacement ID for reading. If the real-time data item ID corresponding to the replacement ID cannot be found in the third query table, the collection state is set to the initial state.

[0044] In the embodiment, the data is scheduled by the identification of each data item (replacement ID+basic ID+collection state+collection number), and different scheduling methods are executed according to the collection state of each data item, so that each data item is successfully collected, and the collection efficiency is improved.

[0045] The above only describes the preferred embodiments of the present application, and it should be noted that for those skilled in the art, without departing from the technical principles of the present application, some improvements and refinements can be made, and these improvements and refinements should also be considered as the protection scope of the present application.

Claims

1. A method for scheduling data items in a data acquisition terminal, characterized in that... Includes the following steps: Step 1: Identify each data item to be scheduled on the acquisition terminal using "Replacement ID + Base ID + Acquisition Status + Acquisition Count"; the acquisition status of each data item is set to the initial state by default. Step 2: Establish a query table database based on the communication protocol and phase of the meter. Each communication protocol and phase is arranged and combined to establish a one-to-one first query table and a second query table. The first query table stores the basic ID of each type of meter and its corresponding data item ID in advance. The second query table stores the replacement ID of each type of meter and its corresponding replacement data item ID in the next round in advance. Step 3: Follow the steps below to copy all data items sequentially. The specific process for copying one data item is as follows: Step 3-1: When the acquisition terminal performs data item scheduling for the first time, if the acquisition state is in the initial state, search for the data item ID corresponding to the base ID of the data item to be scheduled in the first lookup table. Determine whether the data item ID corresponding to the base ID of the data item to be scheduled can be found in the first lookup table. If yes, assign the found data item ID to the replacement ID of the data item to be scheduled, increment the acquisition count by 1, and proceed to step 3-2. If no, switch the acquisition state of the data item to be scheduled to the replacement state, increment the acquisition count by 1, and proceed to step 3-3. Step 3-2: Collect the corresponding meter data using the replacement ID of the data item to be scheduled, and switch the collection status to different states according to the different contents returned by the meter. When the collection status is in different states, process the data item according to the data item scheduling method in each state until the data collection is successful. Step 3-3: When the collection status is in the replacement status, search for the replacement data item ID in the next round corresponding to the replacement ID of the data item to be scheduled in the second lookup table. Determine whether the replacement data item ID in the next round corresponding to the replacement ID of the data item to be scheduled can be found in the second lookup table. If so, assign the found replacement data item ID in the next round to the replacement ID of the data item to be scheduled for copying; otherwise, proceed to step 3-4. Step 3-4: Determine whether to activate the real-time mechanism. If yes, set the acquisition status to real-time. If no, set the acquisition status to the initial state and process the data items according to the same data item scheduling method as in Step 3-1 when the acquisition status is in the initial state.

2. The data item scheduling method for the acquisition terminal according to claim 1, characterized in that: In step 3-2, the data collection status is switched to different states based on the different content returned by the meter, specifically as follows: If the meter returns normal data, the data collection status will be switched to the success status. If the meter returns no data, the collection status will be switched to empty status, and the current collection count will be incremented by 1; If the meter returns erroneous data, the data collection status will be switched to replacement status, and the current data collection count will be incremented by 1.

3. The data item scheduling method for the acquisition terminal according to claim 2, characterized in that: If the collection status is "successful", then the data collection was successful.

4. The data item scheduling method for the acquisition terminal according to claim 2, characterized in that: If the collection status is empty, the meter data will continue to be collected from the last replacement ID until the preset number of collections is reached, at which point the collection status will be switched to replacement status.

5. The data item scheduling method for the acquisition terminal according to claim 4, characterized in that: The range of the preset number of times d is: 2≤d≤5.

6. The data item scheduling method for the acquisition terminal according to claim 5, characterized in that: The preset number of times d = 3.

7. The data item scheduling method for a data acquisition terminal according to any one of claims 1 to 6, characterized in that: Step 2 also includes establishing a third query table, which stores the replacement ID and its corresponding real-time data item ID in advance.

8. The data item scheduling method for the acquisition terminal according to claim 7, characterized in that: If the acquisition status is real-time, then search for the real-time data item ID corresponding to the replacement ID in the third lookup table. If the real-time data item ID corresponding to the replacement ID can be found in the third lookup table, then assign the real-time data item ID to the replacement ID for copying. If the real-time data item ID corresponding to the replacement ID cannot be found in the third lookup table, then set the acquisition status to the initial state.

9. The data item scheduling method for a data acquisition terminal according to any one of claims 1 to 6, characterized in that: The replacement ID and basic ID in step 1 are the default IDs used when the master station issues tasks. The master station communicates with the acquisition terminal.

10. The data item scheduling method for a data acquisition terminal according to any one of claims 1 to 6, characterized in that: The initial number of data collections in step 1 is 0.

Citation Information

Patent Citations

  • Query method and system based on structured query language (SQL)

    CN114625732A

  • Scheduling apparatus and method

    US20110066758A1