A marketing data collection method based on communication adaptation

Abstract

The present invention discloses a marketing data collection method based on communication adaptation, including: using a smart fusion terminal in a substation to actively send a data request to a concentrator; based on the data request, the concentrator uses an information interaction model to analyze the data content to be read; according to the analysis result, the existing data information at the time of initialization is compared, data center equipment information is added or deleted and saved in a cache, and the cache information is transmitted to the smart fusion terminal in a frame. The present invention uses wildcard address and baud rate adaptation technology to improve the efficiency of on-site installation and debugging, saving time and labor costs; uses a configuration file to configure the data to be collected to meet the personalized needs of companies in various cities and reduce the work of upgrading the installed APP on site because the collected data does not meet the on-site application.

Description

Technical Field

[0001] The present invention relates to the technical field of data collection, and in particular to a marketing data collection method based on communication adaptation. Background Art

[0002] The intelligent fusion terminal for the substation is a new type of substation management equipment that can be connected to the main station of the distribution automation system, the main station of the power information collection system, and the Internet of Things management platform. It is designed based on the technical concept of "hardware platformization and software APPization" and integrates the functions of distribution transformer terminals, concentrators, substation meters, etc., to meet the needs of power distribution and emerging businesses. The terminal is based on the design concept of "hardware platformization and software APPization" and aims to obtain the data of household meters in the on-site substation, realize the control of users and terminals including electricity meters, and support rapid deployment and convenient expansion of services. At present, the intelligent fusion terminal for the substation supports carrier, RS485 and other meter reading interfaces, but it cannot replace the functions of the concentrators that have been running on site, and cannot realize the re-installation of encryption chips, which seriously affects the collection of household meter data by the marketing system, and affects the functions of electricity price calculation, fee control, power outage and restoration.

[0003] According to the existing protocols and communication methods, there are four interaction modes between the fusion terminal and the concentrator: network port-698.45, network port-376.1, serial port-698.45, and serial port-376.1. Among them, the concentrator based on the 3761 protocol only supports one TCP channel. Therefore, under the condition of ensuring normal use of the procurement business, the concentrator can only use the serial port communication method. Combined with the on-site installation situation, the RS485-II port is generally used as the uplink serial port communication. The concentrator based on the 698 protocol supports multi-master station connection. In order to ensure the simplicity of on-site installation, the fusion terminal and the concentrator uniformly use the RS485-II serial port communication method. Since the requirements of the RS485-II serial port baud rate of the concentrator by local companies are inconsistent (2400, 4800, and 9600 baud rates may exist), and the addresses of the concentrators being copied are different, it is necessary to configure the address of the downstream concentrator and confirm the RS485-II communication baud rate when installing the APP, which greatly increases the workload of engineering installation and debugging. Summary of the invention

[0004] The purpose of this section is to summarize some aspects of embodiments of the present invention and briefly introduce some preferred embodiments. Some simplifications or omissions may be made in this section and the specification abstract and the invention title of this application to avoid blurring the purpose of this section, the specification abstract and the invention title, and such simplifications or omissions cannot be used to limit the scope of the present invention.

[0005] In view of the above existing problems, the present invention is proposed.

[0006] Therefore, the technical problem solved by the present invention is: it cannot replace the functions of the concentrator already running on site, cannot realize the re-installation of the encryption chip, seriously affects the marketing system to collect household meter data, affects the electricity price calculation, fee control, power outage and restoration and other functions, and increases the workload of engineering installation and debugging.

[0007] In order to solve the above technical problems, the present invention provides the following technical solutions: using the intelligent fusion terminal of the substation to actively send a data test request to the concentrator; based on the data test request, the concentrator uses the information interaction model to analyze the data content to be read; according to the analysis results, the data information already existing at the time of initialization is compared, the data center equipment information is added or deleted and saved in the cache, and the cache information is transmitted in frames to the intelligent fusion terminal of the substation.

[0008] As a preferred solution of the marketing data collection method based on communication adaptation described in the present invention, wherein: the information interaction model includes an application layer, a data link layer and a physical layer.

[0009] As a preferred solution of the marketing data collection method based on communication adaptation described in the present invention, it also includes: the physical layer is RS485 communication, the data link layer uses DLT698.45 / GDB376.1 protocol frame to communicate with the concentrator, the application layer parses the reply message frame, and stores the data in the data center according to the data center storage format for use by other APPs.

[0010] As a preferred solution of the marketing data collection method based on communication adaptation described in the present invention, wherein: judging whether a physical link is established between the intelligent fusion terminal in the substation area and the concentrator includes sending a time message of the concentrator through the RS485-II port according to the wildcard address framing, and sending three times at each of the three baud rates. If the link is normal, the concentrator will return the current time at the baud rate at which the handshake is successful.

[0011] As a preferred solution of the marketing data collection method based on communication adaptation described in the present invention, the three baud rates include 2400, 4800, and 9600 baud rates.

[0012] As a preferred solution of the marketing data collection method based on communication adaptation described in the present invention, wherein: the data information existing at the time of initialization compared with the analysis result includes:

[0013] Use the pairing function to compare data:

[0014]

[0015] Among them, ε represents the error, Respectively represent the coordinates of the feature points of the existing data information, They represent the coordinate values ​​of the feature points in the analysis results after perspective transformation, N c Indicates the number of matching point pairs;

[0016] If the error value is lower than the preset threshold, it means that the data comparison is successful.

[0017] As a preferred solution of the marketing data collection method based on communication adaptation described in the present invention, the data transmission includes periodically reading the latest real-time and current data of the electric meter in the concentrator. If the data length exceeds the maximum size of the sending frame, frame transmission is used; periodically reading the concentrator archive information. When the archive changes, the substation intelligent fusion terminal correspondingly adds or deletes the equipment information in the data center.

[0018] As a preferred solution of the marketing data collection method based on communication adaptation described in the present invention, the handshake process between the intelligent fusion terminal in the substation area and the concentrator includes: the first handshake: when establishing a connection, the intelligent fusion terminal in the substation area sends a syn packet (syn=j) to the concentrator, and enters the SYN-SEND state, waiting for the confirmation of the concentrator; the second handshake: the concentrator receives the syn packet and must confirm the terminal's SYN (ack=i+j), and at the same time sends a SYN packet (syn=k), that is, a SYN+ACK packet, at which time the concentrator enters the SYN-RECV state; the third handshake: the intelligent fusion terminal in the substation area receives the SYN+ACK packet of the concentrator. Send an acknowledgment packet ACK (ack=k+1) to the concentrator. After this packet is sent, the intelligent fusion terminal in the substation area and the concentrator enter the ESTABLISHED state, completing the three-way handshake, and the intelligent fusion terminal in the substation area and the concentrator start to transmit data.

[0019] The beneficial effects of the present invention are as follows: the invention uses wildcard address and baud rate adaptive technology to improve the efficiency of on-site installation and debugging, saving time and labor costs; uses configuration files to configure the data to be collected to meet the personalized needs of companies in various cities, and reduces the on-site installation APP upgrade work done because the collected data does not meet the on-site application. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following briefly introduces the drawings required for describing the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative labor. Among them:

[0021] Figure 1A schematic diagram of the information interaction model flow between a station area intelligent fusion terminal and a concentrator in a marketing data collection method based on communication adaptation provided by one embodiment of the present invention;

[0022] Figure 2 A schematic diagram of the information interaction model module framework of a station area intelligent fusion terminal and a concentrator in a marketing data collection method based on communication adaptation provided by an embodiment of the present invention;

[0023] Figure 3 A schematic diagram of an example of information interaction between a station intelligent fusion terminal and a concentrator in a marketing data collection method based on communication adaptation provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0024] In order to make the above-mentioned purposes, features and advantages of the present invention more obvious and easy to understand, the specific implementation methods of the present invention are described in detail below in conjunction with the drawings of the specification. Obviously, the described embodiments are part of the embodiments of the present invention, but not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary persons in the art without creative work should fall within the scope of protection of the present invention.

[0025] In the following description, many specific details are set forth to facilitate a full understanding of the present invention, but the present invention may also be implemented in other ways different from those described herein, and those skilled in the art may make similar generalizations without violating the connotation of the present invention. Therefore, the present invention is not limited to the specific embodiments disclosed below.

[0026] Secondly, the term "one embodiment" or "embodiment" as used herein refers to a specific feature, structure, or characteristic that may be included in at least one implementation of the present invention. The term "in one embodiment" that appears in different places in this specification does not necessarily refer to the same embodiment, nor does it refer to a separate or selective embodiment that is mutually exclusive with other embodiments.

[0027] The present invention is described in detail with reference to schematic diagrams. When describing the embodiments of the present invention, for the sake of convenience, the cross-sectional diagrams showing the device structure will not be partially enlarged according to the general scale, and the schematic diagrams are only examples, which should not limit the scope of protection of the present invention. In addition, in actual production, the three-dimensional dimensions of length, width and depth should be included.

[0028] At the same time, in the description of the present invention, it should be noted that the directions or positional relationships indicated by the terms "upper, lower, inner and outer" are based on the directions or positional relationships shown in the drawings, and are only for the convenience of describing the present invention and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific direction, be constructed and operated in a specific direction, and therefore cannot be understood as limiting the present invention. In addition, the terms "first, second or third" are only used for descriptive purposes and cannot be understood as indicating or implying relative importance.

[0029] In the present invention, unless otherwise clearly specified and limited, the terms "install, connect, connect" should be understood in a broad sense, for example: it can be a fixed connection, a detachable connection or an integral connection; it can also be a mechanical connection, an electrical connection or a direct connection, or it can be indirectly connected through an intermediate medium, or it can be the internal communication of two components. For ordinary technicians in this field, the specific meanings of the above terms in the present invention can be understood according to specific circumstances.

[0030] Example 1

[0031] Reference Figures 1 to 3 , as an embodiment of the present invention, provides a marketing data collection method based on communication adaptation, comprising:

[0032] S1: Use the intelligent fusion terminal in the substation area to actively send a data measurement request to the concentrator;

[0033] It should be noted that the module structure of the information interaction model between the intelligent fusion terminal and the concentrator is as follows: Figure 2 As shown, the two are connected by a physical channel. The terminal actively sends a data acquisition request to the concentrator, and the concentrator transmits the acquired data to the intelligent fusion terminal via the application layer, data link layer and physical layer.

[0034] Among them, the physical layer is RS485 communication; the data link uses DLT698.45 / GDB376.1 protocol frames to communicate with the concentrator; the application layer parses the reply message frames and stores the data in the data center according to the data center storage format for use by other APPs.

[0035] S2: Based on the data test request, the concentrator uses the information interaction model to analyze the data content to be read;

[0036] It should be noted that the information interaction between the intelligent fusion terminal and the concentrator is as follows: Figure 3 As shown in the figure, after the terminal connects to the concentrator and the handshake is successful, it sends a read data message. If the concentrator's reply message exceeds the maximum size of the send frame, the concentrator will use frame transmission. The terminal parses the message to contain a subsequent frame flag, and the terminal should send a read subsequent frame message and continue to request subsequent messages until the response frame reaches the last frame flag.

[0037] The handshake process between the intelligent fusion terminal in the substation and the concentrator includes:

[0038] First handshake: When establishing a connection, the intelligent fusion terminal in the substation sends a SYN packet (syn=j) to the concentrator and enters the SYN-SEND state, waiting for confirmation from the concentrator;

[0039] Second handshake: When the concentrator receives the SYN packet, it must confirm the terminal's SYN (ack=i+j) and send a SYN packet (syn=k) at the same time, i.e., a SYN+ACK packet. At this time, the concentrator enters the SYN-RECV state;

[0040] The third handshake: The intelligent fusion terminal in the substation receives the SYN+ACK packet from the concentrator. It sends a confirmation packet ACK (ack=k+1) to the concentrator. After this packet is sent, the intelligent fusion terminal in the substation and the concentrator enter the ESTABLISHED state, completing the three-way handshake. The intelligent fusion terminal in the substation and the concentrator start to transmit data.

[0041] S3: Compare the existing data information at the time of initialization based on the analysis results, add or delete the data center equipment information and save it in the cache, and transmit the cache information in frames to the intelligent fusion terminal in the substation area.

[0042] It should be noted that the data information that already exists during the initialization according to the analysis results includes:

[0043] Use the pairing function to compare data:

[0044]

[0045] Among them, ε represents the error, Respectively represent the coordinates of the feature points of the existing data information, They represent the coordinate values ​​of the feature points in the analysis results after perspective transformation, N c Indicates the number of matching point pairs;

[0046] If the error value is lower than the preset threshold, it means that the data comparison is successful.

[0047] More specifically, the specific information interaction process between the intelligent converged terminal and the concentrator is as follows:

[0048] (1) Initialize and load the default configuration file, determine the data content to be read, and then register the meter model with the data center to obtain the archive information and registered device information in the data center.

[0049] (2) Determine whether a physical link is established between the intelligent fusion terminal in the substation area and the concentrator. Send the time message to the concentrator through the RS485-II port according to the wildcard address frame. Send three times at each of the three baud rates of 2400, 4800, and 9600. If the link is normal, the concentrator will return the current time at the baud rate at which the handshake is successful.

[0050] (3) Determine the address of the downstream concentrator and the RS485-II communication baud rate based on the reply message, use the real concentrator address to read the file information, compare it with the existing file information obtained during initialization, add or delete the data center equipment information and save it in the cache.

[0051] (4) Periodically read the latest real-time and current data of the electric meter in the concentrator. If the data length exceeds the maximum size of the sending frame, frame transmission should be used.

[0052] (5) Periodically read the concentrator file information. When the file changes, the terminal should add or delete the device information in the data center accordingly.

[0053] The present invention adopts a configuration file to configure the data to be collected, which can meet the different data requirements of various cities and increase personalized extensions for the subsequent operation of APP in various cities; a unified registration device is adopted, which is decoupled from the on-site user table address, and a compatible solution is provided for other APPs of the fusion terminal to obtain data through the unique device identification of the data center; the present invention adopts a wildcard address adaptive baud rate handshake mechanism to avoid the configuration of the concentrator address and the confirmation of the serial port communication baud rate, which greatly improves the work efficiency of the on-site engineering.

[0054] Example 2

[0055] This embodiment is another embodiment of the present invention. This embodiment is different from the first embodiment in that it provides a verification test of a marketing data collection method based on communication adaptation. In order to verify and illustrate the technical effects adopted in this method, this embodiment adopts a traditional technical solution and conducts a comparative test with the method of the present invention, and compares the test results by means of scientific argumentation to verify the real effect of this method.

[0056] Traditional technical solutions: The workload of engineering installation and debugging is large, the work efficiency is low and the cost is high. In order to verify that this method has higher work efficiency and lower cost than the traditional method, this embodiment will use the traditional protocol and communication method and this method to conduct real-time measurement and comparison of the marketing data collection accuracy of the simulated communication network.

[0057] Test environment: The operation of the distribution network and the generation of marketing data are simulated on the simulation platform. The traditional method and this method are used respectively. The automatic test equipment is turned on and the MATLB software is used to program the simulation test of the two methods. The simulation data is obtained according to the experimental results. The results are shown in the following table.

[0058] Table 1: Comparison of experimental results.

[0059] Test samples Traditional methods Method of the present invention Time / s m <![CDATA[m-n 2 (m>>n 2 )]]> Installation and debugging efficiency 86.33％ 98.10％ Human Cost high Low Data fusion rate 83.12％ 97.23％ Personalized needs Dissatisfied satisfy

[0060] It can be seen from the above table that the method of the present invention has better robustness than the traditional one.

[0061] It should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention rather than to limit it. Although the present invention has been described in detail with reference to the preferred embodiments, those skilled in the art should understand that the technical solutions of the present invention may be modified or replaced by equivalents without departing from the spirit and scope of the technical solutions of the present invention, which should all be included in the scope of the claims of the present invention.

Claims

1. A marketing data collection method based on communication adaptation, characterized in that: include: Use the intelligent fusion terminal in the substation area to actively send data measurement requests to the concentrator; Based on the data test request, the concentrator uses the information interaction model to analyze the data content to be read; Compare the data information that already exists during initialization according to the analysis results, add or delete the data center equipment information and save it in the cache, and transmit the cache information in frames to the intelligent fusion terminal of the substation area; The information interaction model includes an application layer, a data link layer and a physical layer; The physical layer is RS485 communication, the data link layer uses DLT698.45 / GDB376.1 protocol frames to communicate with the concentrator, and the application layer parses the reply message frames and stores the data in the data center according to the data center storage format for use by other APPs; The comparison of the data information existing at the time of initialization according to the analysis results includes: Use the pairing function to compare data: Among them, ε represents the error, Respectively represent the coordinates of the feature points of the existing data information, They represent the coordinate values ​​of the feature points in the analysis results after perspective transformation, N c Indicates the number of matching point pairs; If the error value is lower than the preset threshold, it means that the data comparison is successful; The data transmission includes: Periodically read the latest real-time and current data of the electric meter in the concentrator, and if the length of the data exceeds the maximum size of the transmission frame, use frame transmission; The concentrator file information is read periodically, and when the file changes, the substation intelligent fusion terminal correspondingly adds or deletes the equipment information in the data center.

2. The method for collecting marketing data based on communication adaptation according to claim 1, characterized in that: Determining whether a physical link is established between the station area intelligent fusion terminal and the concentrator includes: The concentrator time message is sent through the RS485-II port according to the wildcard address framing, and the three baud rates are sent three times each. If the link is normal, the concentrator will return the current time at the baud rate at which the handshake is successful.

3. The method for collecting marketing data based on communication adaptation as claimed in claim 2, characterized in that: The three baud rates include 2400, 4800, and 9600 baud rates.

4. The method for collecting marketing data based on communication adaptation according to claim 1 or 3, characterized in that: The handshake process between the intelligent fusion terminal in the substation area and the concentrator include, First handshake: When establishing a connection, the intelligent fusion terminal in the substation sends a SYN packet (syn=j) to the concentrator and enters the SYN-SEND state, waiting for confirmation from the concentrator; Second handshake: the concentrator receives the SYN packet and must confirm the terminal's SYN (ack=i+j), and at the same time sends a SYN packet (syn=k), i.e., a SYN+ACK packet. At this time, the concentrator enters the SYN-RECV state; The third handshake: the substation intelligent fusion terminal receives the SYN+ACK packet from the concentrator and sends a confirmation packet ACK (ack=k+1) to the concentrator. After the packet is sent, the substation intelligent fusion terminal and the concentrator enter the ESTABLISHED state, completing the three-way handshake, and the substation intelligent fusion terminal and the concentrator start to transmit data.

Images