CN113656479A - Data processing method and device - Google Patents
Data processing method and device Download PDFInfo
- Publication number
- CN113656479A CN113656479A CN202110951465.5A CN202110951465A CN113656479A CN 113656479 A CN113656479 A CN 113656479A CN 202110951465 A CN202110951465 A CN 202110951465A CN 113656479 A CN113656479 A CN 113656479A
- Authority
- CN
- China
- Prior art keywords
- data
- cable
- database
- preprocessing
- cable state
- 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
- 238000003672 processing method Methods 0.000 title claims abstract description 9
- 238000003860 storage Methods 0.000 claims abstract description 62
- 238000007781 pre-processing Methods 0.000 claims abstract description 56
- 230000008447 perception Effects 0.000 claims abstract description 41
- 238000004891 communication Methods 0.000 claims abstract description 35
- 238000000034 method Methods 0.000 claims abstract description 34
- 230000003993 interaction Effects 0.000 claims abstract description 23
- 238000009413 insulation Methods 0.000 claims abstract description 22
- 238000012545 processing Methods 0.000 claims description 37
- 238000012544 monitoring process Methods 0.000 claims description 33
- 238000005070 sampling Methods 0.000 claims description 29
- QVFWZNCVPCJQOP-UHFFFAOYSA-N chloralodol Chemical compound CC(O)(C)CC(C)OC(O)C(Cl)(Cl)Cl QVFWZNCVPCJQOP-UHFFFAOYSA-N 0.000 claims description 23
- 238000001914 filtration Methods 0.000 claims description 22
- 238000005259 measurement Methods 0.000 claims description 17
- 230000006870 function Effects 0.000 claims description 16
- 230000005540 biological transmission Effects 0.000 claims description 11
- 238000006243 chemical reaction Methods 0.000 claims description 7
- 238000010276 construction Methods 0.000 claims description 7
- 239000013307 optical fiber Substances 0.000 claims description 6
- 230000003321 amplification Effects 0.000 claims description 5
- 238000003199 nucleic acid amplification method Methods 0.000 claims description 5
- 230000000737 periodic effect Effects 0.000 claims description 5
- 238000013139 quantization Methods 0.000 claims description 5
- 238000007689 inspection Methods 0.000 abstract description 7
- 238000005516 engineering process Methods 0.000 abstract description 6
- 230000008569 process Effects 0.000 description 10
- 238000012423 maintenance Methods 0.000 description 7
- 238000009826 distribution Methods 0.000 description 6
- 230000000694 effects Effects 0.000 description 6
- 238000004458 analytical method Methods 0.000 description 5
- 238000013461 design Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 5
- 238000000605 extraction Methods 0.000 description 5
- 238000011160 research Methods 0.000 description 5
- 230000032683 aging Effects 0.000 description 4
- 230000008901 benefit Effects 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000013500 data storage Methods 0.000 description 3
- 230000009471 action Effects 0.000 description 2
- 238000005034 decoration Methods 0.000 description 2
- 238000011156 evaluation Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000009825 accumulation Methods 0.000 description 1
- 230000002776 aggregation Effects 0.000 description 1
- 238000004220 aggregation Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 230000006866 deterioration Effects 0.000 description 1
- 238000003745 diagnosis Methods 0.000 description 1
- 230000005684 electric field Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 230000006855 networking Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012805 post-processing Methods 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G01—MEASURING; TESTING
- G01R—MEASURING ELECTRIC VARIABLES; MEASURING MAGNETIC VARIABLES
- G01R31/00—Arrangements for testing electric properties; Arrangements for locating electric faults; Arrangements for electrical testing characterised by what is being tested not provided for elsewhere
- G01R31/12—Testing dielectric strength or breakdown voltage ; Testing or monitoring effectiveness or level of insulation, e.g. of a cable or of an apparatus, for example using partial discharge measurements; Electrostatic testing
- G01R31/1227—Testing dielectric strength or breakdown voltage ; Testing or monitoring effectiveness or level of insulation, e.g. of a cable or of an apparatus, for example using partial discharge measurements; Electrostatic testing of components, parts or materials
- G01R31/1263—Testing dielectric strength or breakdown voltage ; Testing or monitoring effectiveness or level of insulation, e.g. of a cable or of an apparatus, for example using partial discharge measurements; Electrostatic testing of components, parts or materials of solid or fluid materials, e.g. insulation films, bulk material; of semiconductors or LV electronic components or parts; of cable, line or wire insulation
- G01R31/1272—Testing dielectric strength or breakdown voltage ; Testing or monitoring effectiveness or level of insulation, e.g. of a cable or of an apparatus, for example using partial discharge measurements; Electrostatic testing of components, parts or materials of solid or fluid materials, e.g. insulation films, bulk material; of semiconductors or LV electronic components or parts; of cable, line or wire insulation of cable, line or wire insulation, e.g. using partial discharge measurements
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/901—Indexing; Data structures therefor; Storage structures
- G06F16/9024—Graphs; Linked lists
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W4/00—Services specially adapted for wireless communication networks; Facilities therefor
- H04W4/30—Services specially adapted for particular environments, situations or purposes
- H04W4/38—Services specially adapted for particular environments, situations or purposes for collecting sensor information
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04W—WIRELESS COMMUNICATION NETWORKS
- H04W84/00—Network topologies
- H04W84/18—Self-organising networks, e.g. ad-hoc networks or sensor networks
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2218/00—Aspects of pattern recognition specially adapted for signal processing
- G06F2218/02—Preprocessing
- G06F2218/04—Denoising
- G06F2218/06—Denoising by applying a scale-space analysis, e.g. using wavelet analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2218/00—Aspects of pattern recognition specially adapted for signal processing
- G06F2218/08—Feature extraction
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Testing Relating To Insulation (AREA)
Abstract
The invention discloses a data processing method and device. Wherein, the method comprises the following steps: preprocessing the cable state sensing data; determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode; and accessing cable state sensing data in the database based on a preset interface, and determining a wide area network LoRaWAN as a communication mode of the wireless sensor network to perform data interaction between the sensor nodes and the database. The invention solves the technical problem that the insulation state of the cable cannot be effectively monitored in the partial discharge inspection of the cable in the related technology.
Description
Technical Field
The invention relates to the field of power equipment state diagnosis, in particular to a data processing method and device.
Background
With the continuous improvement of the industrialization and urbanization level of China, the power demand is increased rapidly, and the requirement on the safety and stability of a power system is higher and higher. The power cable has the characteristics of simplicity and convenience in installation, high electrical strength, small dielectric loss and the like, can effectively solve the problems of urban power utilization aggregation effect and overlarge land occupancy rate of overhead lines, can be rapidly popularized in 6-35 kV power distribution networks and regional power transmission power grids of 110kV or above, has been developed into important equipment for electric energy transmission of various voltage levels, and has indispensable effects on safe power loads and reliable power transmission.
However, in both dc and ac cables, the aging process inevitably follows when the cables are put into operation. Due to the limitation of manufacturing process and laying condition, insulation aging inevitably occurs under the combined action of factors such as electric field, temperature, moisture and the like, and internal potential faults can accelerate the aging and deterioration process of the cable, so that the operation safety and the power grid stability of the cable are greatly threatened, and the state detection of the cable becomes the heavy work of cable operation and maintenance. According to incomplete statistics, the faults of the 6-35 kV cable equipment of the power system in China totally amount to 3800 times in recent years, wherein the fault of the main body accounts for 2353 times of 61.92 percent of the total fault, and great loss and inconvenience are brought to social production and resident life. Because the workload of cable maintenance and aging evaluation is huge, the measurement influence factors are complicated, and how to quickly, effectively and accurately evaluate the insulation state and the through-current capacity of the cable becomes an important problem to be solved urgently in the operation and maintenance of the power system.
Therefore, the technical problem that the insulation state of the cable cannot be effectively monitored in the partial discharge inspection of the cable in the related art exists.
In view of the above problems, no effective solution has been proposed.
Disclosure of Invention
The embodiment of the invention provides a data processing method and device, which at least solve the technical problem that the insulation state of a cable cannot be effectively monitored in partial discharge inspection of the cable in the related art.
According to an aspect of an embodiment of the present invention, there is provided a data processing method, including: preprocessing the cable state sensing data; determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode; and accessing the cable state sensing data in the database based on a preset interface, and determining that Wide Area Network (Long Range Radio Area Network, LoRaWAN for short) is used as a communication mode of a wireless sensor Network to perform data interaction between the sensor node and the database.
Optionally, when the preprocessing includes data reading, preprocessing the cable state sensing data, including: reading data header information, wherein the data header information comprises at least one of: sampling rate, sampling length, measuring range, quantization depth and amplification factor.
Optionally, when the preprocessing includes data conversion, preprocessing the cable state perception data, including: and converting the data format specified by the acquisition card into the data format specified by the field monitoring software, and converting the sampled data into required data according to the data header information.
Optionally, when the preprocessing includes a filtering process, preprocessing the cable state perception data includes: adopting Fast Fourier Transform (FFT) filtering to inhibit periodic sinusoidal interference in the partial discharge signal; adopting wavelet filtering to inhibit white noise interference in the partial discharge signal; and (3) suppressing random pulse interference in the partial discharge signal by adopting window function filtering.
Optionally, when the preprocessing includes feature map construction, preprocessing the cable state perception data, including: and constructing a three-dimensional characteristic array map and a two-dimensional characteristic data map.
Optionally, determining a storage manner of the cable status awareness data in the database includes at least one of: determining a data table of the cable status awareness data in a database, wherein the data table comprises at least one of: a state information table, a characteristic data table and a characteristic trend table; and determining the compiling storage of the cable state perception data in a database, wherein the compiling storage is used for completing an SQL statement set with a preset function, and the compiling storage is stored in the database.
Optionally, determining that the wide area network LoRaWAN is used as a communication mode of the wireless sensor network to perform data interaction between the sensor node and the database includes: the LoRa gateway is in communication connection with the server through an optical fiber, wherein when communication starts, the sensor node is awakened, a LoRa module of the sensor node is set to be in a transmission mode, and a monitoring instruction is received; during monitoring, the sensor node acquires a state quantity and a sampling measurement value, if the sampling measurement value exceeds a preset threshold value, the state quantity and the sampling measurement value are sent to a gateway through the LoRa module and transmitted to the server, and a new monitoring instruction is waited to be received to acquire insulation state information; otherwise, the sensor node will go to sleep after monitoring.
According to another aspect of the embodiments of the present invention, there is also provided a data processing apparatus, including: the preprocessing module is used for preprocessing the cable state sensing data; the first processing module is used for determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode; and the second processing module is used for accessing the cable state sensing data in the database based on a preset interface and determining a wide area network LoRaWAN as a communication mode of a wireless sensor network to perform data interaction between the sensor node and the database.
According to another aspect of the embodiments of the present invention, there is also provided a computer-readable storage medium, where the computer-readable storage medium includes a stored program, and when the program runs, the apparatus where the computer-readable storage medium is located is controlled to execute the data processing method described in any one of the above.
According to another aspect of the embodiments of the present invention, there is also provided a processor, configured to execute a program, where the program executes a method for processing data according to any one of the foregoing methods.
In the embodiment of the invention, the cable state perception data is preprocessed; determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode; the method comprises the steps of accessing cable state sensing data in a database based on a preset interface, determining that LoRaWAN is used as a communication mode of a wireless sensor network to carry out data interaction between sensor nodes and the database, and achieving the purpose of carrying out on-line monitoring research on the insulation state of the power cable through storage and interaction of the cable state sensing data, thereby achieving the technical effects of more effectively monitoring the insulation state of the cable, improving the operation and maintenance level of the cable, and further solving the technical problem that the insulation state of the cable cannot be effectively monitored in partial discharge inspection of the cable in the related technology.
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 application, illustrate embodiment(s) of the invention and together with the description serve to explain the invention without limiting the invention. In the drawings:
FIG. 1 is a flow chart of a method of processing data according to an embodiment of the invention;
FIG. 2 is a flow diagram of pre-processing cable status awareness data according to an alternative embodiment of the present invention;
FIG. 3 is a schematic illustration of the access steps of a database and reference data tables according to an alternative embodiment of the present invention;
FIG. 4 is a flow diagram of sensor node-gateway communication in accordance with an alternative embodiment of the present invention;
fig. 5 is a schematic diagram of a data processing apparatus according to an embodiment of the present invention.
Detailed Description
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the terms "first," "second," and the like in the description and claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in sequences other than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
Example 1
In accordance with an embodiment of the present invention, there is provided an embodiment of a method for processing data, it being noted that the steps illustrated in the flowchart of the figure may be performed in a computer system such as a set of computer-executable instructions and that, although a logical order is illustrated in the flowchart, in some cases, the steps illustrated or described may be performed in an order different than that presented herein.
Fig. 1 is a flowchart of a data processing method according to an embodiment of the present invention, as shown in fig. 1, the method including the steps of:
step S102, preprocessing cable state perception data;
the preprocessing includes, but is not limited to, data reading, data conversion, filtering, feature map construction, and the like.
Step S104, determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode;
and S106, accessing the cable state sensing data in the database based on a preset interface, and determining that the wide area network LoRaWAN is used as a communication mode of the wireless sensor network to perform data interaction between the sensor nodes and the database.
The wide area network networking LoRaWAN is a communication protocol based on the LoRa technology, mainly comprises three entities of a LoRa terminal, a LoRa gateway and a LoRa server, and according to protocol layering, the LoRaWAN is an MAC layer and the LoRa is a physical layer. In addition, the LoRaWAN has the advantages of long transmission distance, low power consumption, free charge and the like.
The preset interface is an ADO.NET interface; the access form of the database can be Visual Studio 2008 based on a WINDOWS platform, and the method has the advantages of simplicity, flexibility, high access speed, good expandability and the like; NET interface is adopted to access the database, and the application program can access the data in the relational database and hierarchical XML data, so that data operation and rapid access to the data are realized.
In an optional implementation mode, firstly, the processing and analysis (corresponding to the preprocessing) of the cable state perception data mainly comprises data reading, filtering processing, pulse extraction and map construction of a feature array; secondly, cable state perception data storage design is carried out, wherein a state information table, feature data and a feature trend table are mainly established, an SQL statement set with a preset function is completed at the same time, and the SQL statement set is compiled and stored in a database; and finally, accessing the database by adopting an ADO (address data acquisition) NET (network access network) interface, and determining the LoRaWAN as a communication mode of the wireless sensor network.
It should be noted that, in the optional embodiment of the present invention, the storage and interaction of the cable state sensing data can be realized by using the SQL language function and flexibility, the data interactivity and the good expansibility of the ado.
Through the steps, the cable state sensing data can be preprocessed; determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode; the method comprises the steps of accessing cable state sensing data in a database based on a preset interface, determining that LoRaWAN is used as a communication mode of a wireless sensor network to carry out data interaction between sensor nodes and the database, and achieving the purpose of carrying out on-line monitoring research on the insulation state of the power cable through storage and interaction of the cable state sensing data, thereby achieving the technical effects of more effectively monitoring the insulation state of the cable, improving the operation and maintenance level of the cable, and further solving the technical problem that the insulation state of the cable cannot be effectively monitored in partial discharge inspection of the cable in the related technology.
Optionally, when the preprocessing includes data reading, preprocessing the cable state sensing data, including: reading data header information, wherein the data header information comprises at least one of the following: sampling rate, sampling length, measuring range, quantization depth and amplification factor.
In an alternative embodiment, the processing and analyzing of the data includes data reading, wherein the data header information includes key information such as sampling rate, sampling length, measuring range, and the like.
Optionally, when the preprocessing includes data conversion, preprocessing the cable state perception data, including: and converting the data format specified by the acquisition card into the data format specified by the field monitoring software, and converting the sampled data into required data according to the data header information.
In an alternative embodiment, the data format specified by the acquisition card may be converted into the data format specified by the field monitoring software, and the sampled data may be converted into meaningful data according to the information of sampling rate, measuring range, quantization depth, amplification factor, and the like.
Optionally, when the preprocessing includes a filtering process, preprocessing the cable state perception data, including: suppressing periodic sinusoidal interference in the partial discharge signal by adopting FFT filtering; adopting wavelet filtering to inhibit white noise interference in the partial discharge signal; and (3) suppressing random pulse interference in the partial discharge signal by adopting window function filtering.
In an alternative embodiment, FFT filtering, wavelet filtering and window function filtering may be adopted to suppress periodic sinusoidal interference, white noise interference and random impulse interference in the partial discharge signal, respectively.
Optionally, when the preprocessing includes feature map construction, preprocessing the cable state perception data, including: and constructing a three-dimensional characteristic array map and a two-dimensional characteristic data map.
In an alternative embodiment, when the processing and analysis of the data includes feature map construction, a three-dimensional feature array map, extraction of statistical parameters, and a two-dimensional feature data map may be constructed.
Optionally, determining a storage manner of the cable status awareness data in the database includes at least one of: determining a data table of cable status perception data in a database, wherein the data table comprises at least one of: a state information table, a characteristic data table and a characteristic trend table; and determining the compiling storage of the cable state sensing data in the database, wherein the compiling storage is used for completing the SQL statement set of the preset function, and the compiled data is stored in the database.
In an alternative embodiment, the cable state sensing data storage mode comprises data tables, wherein the data tables comprise a state information table, a characteristic data table and a characteristic trend table, and accumulation, analysis and compressed storage of data are facilitated.
In an optional implementation mode, the cable state perception data storage design comprises compiling storage, an SQL statement set with a preset function is completed, and the SQL statement set is compiled and stored in a database, so that the burden of an application program is greatly reduced; the storage process can be compiled by flow control statements, so that the method has strong flexibility and can finish complex judgment and complex operation; the storage process can ensure that a user without authority can indirectly access the database under the control of the user without authority, thereby ensuring the safety of data; related actions can be taken together through a storage process, and the integrity of the database is maintained; if an exception occurs in the storage process (including a network exception, an SQL Server exception and the like), the execution fails, and the database returns to the state before the execution, so that the good post-processing items of the exception are not required to be considered.
Optionally, determining that the LoRaWAN is used as a communication mode of the wireless sensor network to perform data interaction between the sensor node and the database includes: the LoRa gateway is in communication connection with the server through optical fibers, wherein when communication starts, the sensor node is awakened, a LoRa module of the sensor node is set to be in a transmission mode, and a monitoring instruction is received; during monitoring, the sensor node acquires state quantity and a sampling measurement value, if the sampling measurement value exceeds a preset threshold value, the state quantity and the sampling measurement value are sent to the gateway through the LoRa module and transmitted to the server, and a new monitoring instruction is waited to be received to acquire insulation state information; otherwise, the sensor node will go to sleep after monitoring.
In an alternative embodiment, the data communication mode is LoRaWAN, and the LoRa gateway is connected to the server through an optical fiber and ready to receive or transmit data/commands. When communication starts, the sensor node is firstly awakened, and the sensor LoRa module is set to be in a transmission mode. The sensor node can receive the monitoring command. During monitoring, the sensor node acquires state quantity and a sampling measurement value, if the sampling measurement value exceeds a threshold value, data is sent to a gateway through LoRa and further transmitted to a server, and a monitoring center is waited to issue a new monitoring instruction to acquire detailed insulation state information; otherwise, the node will go to sleep after monitoring.
The server is a hardware device of the database.
An alternative embodiment of the invention is described in detail below.
In an optional implementation mode, the storage and interaction of the cable state sensing data are realized by utilizing the advantages of an information interaction technology, so that the on-line monitoring research of the insulation state of the power cable is developed, and the on-line monitoring research comprises the processing and analysis of the cable state sensing data, the storage design of the cable state sensing data, the access form of a database and a communication mode. The specific implementation mode is as follows:
firstly, preprocessing analysis is performed on the detected cable state sensing data, fig. 2 is a flow chart of preprocessing the cable state sensing data according to an alternative embodiment of the present invention, as shown in fig. 2, including data reading, i.e., data header information and original sampling data; data conversion, namely data format conversion and data recovery; filtering, namely FFT, wavelet and window function, to filter out narrow band, white noise and pulse interference; and (4) pulse extraction, namely determining the partial discharge signal pulse according to the pulse amplitude and the occurrence position.
Secondly, constructing a feature map of the state perception data of the measured cable, wherein the feature map comprises a three-dimensional feature array map based on a pulse array and a pulse position array; the discharge two-dimensional map comprises five discharge two-dimensional maps of maximum discharge phase distribution, average discharge phase distribution, discharge frequency phase distribution, partial discharge amplitude distribution and partial discharge energy distribution.
Secondly, carrying out storage design on state sensing data of the tested cable, setting a state information table, a characteristic data table and a characteristic trend table before storage, compressing and storing the state information table, the characteristic data table and the characteristic trend table in a fixed directory of a field industrial personal computer, and storing the characteristic quantity of partial discharge in a database for facilitating query and comparison; when storing, the SQL statement set with the preset function is compiled and then stored in the database.
Then, an interaction mode design is performed on the state perception Data of the measured cable, fig. 3 is a schematic diagram of an access step of the database and a reference Data table according to an optional embodiment of the invention, as shown in fig. 3, a database is accessed by adopting an ado.
Finally, the communication mode of the whole cable state perception data is LoRaWAN, and the LoRa gateway is connected with the server through optical fibers and is ready to receive or send data/instructions at any time. Fig. 4 is a flowchart of sensor node-gateway communication according to an alternative embodiment of the present invention, and as shown in fig. 4, when communication starts, the sensor node is first awakened and the sensor LoRa module is set to a transmission mode. The sensor node can receive the monitoring command. During monitoring, the sensor node acquires state quantity and a sampling measurement value, if the sampling measurement value exceeds a threshold value, data is sent to a gateway through LoRa and further transmitted to a server, and a monitoring center is waited to issue a new monitoring instruction to acquire detailed insulation state information; otherwise, the node will go to sleep after monitoring.
It should be noted that the above alternative embodiment can achieve the following technical effects: the extraction of real partial discharge signals is realized, and accurate data is provided for reliable evaluation of the cable insulation condition by an expert system; the map intuitively represents the local discharge characteristics and comprehensively reflects the relationship among the discharge capacity, the discharge frequency and the discharge phase; the capability of storing the process greatly enhances the function and the flexibility of the SQL language, reduces the burden of an application program, and ensures the safety and the integrity of data and the communication traffic of a network; NET access mode improves interactivity, expansibility and programmability of a cable database; LoRaWAN satisfies the data transmission rate requirement of partial discharge monitoring, and is suitable for being connected to the basic node of perception layer simultaneously. In conclusion, accurate extraction, storage and interaction of power cable partial discharge data can be realized, intelligent routing inspection is facilitated, and the cable operation maintenance level is improved.
Example 2
According to another aspect of the embodiments of the present invention, there is also provided a data processing apparatus, and fig. 5 is a schematic diagram of the data processing apparatus according to the embodiments of the present invention, as shown in fig. 5, the data processing apparatus includes: a pre-processing module 52, a first processing module 54, and a second processing module 56. The following describes the data processing apparatus in detail.
The preprocessing module 52 is configured to preprocess the cable state sensing data; a first processing module 54, connected to the preprocessing module 52, for determining a storage manner of the cable state sensing data in the database, wherein the preprocessed cable state sensing data is stored according to the storage manner; and the second processing module 56 is connected to the first processing module 54, and is configured to access cable state sensing data in the database based on a preset interface, and determine that the LoRaWAN is used as a communication mode of the wireless sensor network to perform data interaction between the sensor node and the database.
It should be noted that the above modules may be implemented by software or hardware, for example, for the latter, the following may be implemented: the modules can be located in the same processor; and/or the modules are located in different processors in any combination.
In the above embodiment, the data processing device can achieve the purpose of developing on-line monitoring research on the insulation state of the power cable through storage and interaction of cable state sensing data, thereby realizing more effective monitoring on the insulation state of the cable, improving the technical effect of the cable operation maintenance level, and further solving the technical problem that the insulation state of the cable cannot be effectively monitored in the cable partial discharge inspection in the related art.
It should be noted here that the preprocessing module 52, the first processing module 54 and the second processing module 56 correspond to steps S102 to S106 in embodiment 1, and the modules are the same as the corresponding steps in implementation examples and application scenarios, but are not limited to the disclosure in embodiment 1.
Optionally, the preprocessing module 52 includes: a first preprocessing unit, configured to read header information when the preprocessing includes data reading, where the header information includes at least one of: sampling rate, sampling length, measuring range, quantization depth and amplification factor.
Optionally, the preprocessing module 52 includes: and the second preprocessing unit is used for converting the data format specified by the acquisition card into the data format specified by the field monitoring software when the preprocessing comprises data conversion, and converting the sampling data into the required data according to the data header information.
Optionally, the preprocessing module 52 includes: the third preprocessing unit is used for adopting FFT filtering to suppress periodic sinusoidal interference in the partial discharge signals when the preprocessing comprises filtering processing; adopting wavelet filtering to inhibit white noise interference in the partial discharge signal; and (3) suppressing random pulse interference in the partial discharge signal by adopting window function filtering.
Optionally, the preprocessing module 52 includes: and the fourth preprocessing unit is used for constructing a three-dimensional characteristic array map and a two-dimensional characteristic data map when the preprocessing comprises the construction of the characteristic map.
Optionally, the first processing module 54 includes at least one of: a first determining unit, configured to determine a data table of the cable status sensing data in a database, where the data table includes at least one of: a state information table, a characteristic data table and a characteristic trend table; and the second determination unit is used for determining the compiling and storing of the cable state sensing data in the database, wherein the compiling and storing are used for completing the SQL statement set of the preset function, and the compiled SQL statement set is stored in the database.
Optionally, the second processing module 56 includes: the LoRa gateway is in communication connection with the server through an optical fiber, wherein the processing unit is used for awakening the sensor node when communication starts, setting the LoRa module of the sensor node into a transmission mode and receiving a monitoring instruction; during monitoring, the sensor node acquires state quantity and a sampling measurement value, if the sampling measurement value exceeds a preset threshold value, the state quantity and the sampling measurement value are sent to the gateway through the LoRa module and transmitted to the server, and a new monitoring instruction is waited to be received to acquire insulation state information; otherwise, the sensor node will go to sleep after monitoring.
Example 3
According to another aspect of the embodiments of the present invention, there is also provided a computer-readable storage medium, which includes a stored program, wherein when the program runs, the apparatus where the computer-readable storage medium is located is controlled to execute the method for processing data in any one of the above.
Optionally, in this embodiment, the computer-readable storage medium may be located in any one of a group of computer terminals in a computer network and/or in any one of a group of mobile terminals, and the computer-readable storage medium includes a stored program.
Optionally, the program when executed controls an apparatus in which the computer-readable storage medium is located to perform the following functions: preprocessing the cable state sensing data; determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode; and accessing the cable state sensing data in the database based on a preset interface, and determining LoRaWAN as a communication mode of the wireless sensor network to perform data interaction between the sensor node and the database.
Example 4
According to another aspect of the embodiments of the present invention, there is also provided a processor, configured to execute a program, where the program executes a method for processing data in any one of the above.
The embodiment of the invention provides equipment, which comprises a processor, a memory and a program which is stored on the memory and can run on the processor, wherein the processor executes the program and realizes the following steps: preprocessing the cable state sensing data; determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode; and accessing the cable state sensing data in the database based on a preset interface, and determining LoRaWAN as a communication mode of the wireless sensor network to perform data interaction between the sensor node and the database.
The invention also provides a computer program product adapted to perform a program for initializing the following method steps when executed on a data processing device: preprocessing the cable state sensing data; determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode; and accessing the cable state sensing data in the database based on a preset interface, and determining LoRaWAN as a communication mode of the wireless sensor network to perform data interaction between the sensor node and the database.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
In the above embodiments of the present invention, the descriptions of the respective embodiments have respective emphasis, and for parts that are not described in detail in a certain embodiment, reference may be made to related descriptions of other embodiments.
In the embodiments provided in the present application, it should be understood that the disclosed technology can be implemented in other ways. The above-described embodiments of the apparatus are merely illustrative, and for example, the division of the units may be a logical division, and in actual implementation, there may be another division, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, units or modules, and may be in an electrical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a removable hard disk, a magnetic or optical disk, and other various media capable of storing program codes.
The foregoing is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, various modifications and decorations can be made without departing from the principle of the present invention, and these modifications and decorations should also be regarded as the protection scope of the present invention.
Claims (10)
1. A method for processing data, comprising:
preprocessing the cable state sensing data;
determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode;
and accessing the cable state perception data in the database based on a preset interface, and determining a wide area network LoRaWAN as a communication mode of a wireless sensor network to perform data interaction between the sensor node and the database.
2. The method of claim 1, wherein preprocessing cable state awareness data when the preprocessing comprises data reading comprises:
reading data header information, wherein the data header information comprises at least one of: sampling rate, sampling length, measuring range, quantization depth and amplification factor.
3. The method of claim 1, wherein preprocessing cable state awareness data when the preprocessing comprises data conversion comprises:
and converting the data format specified by the acquisition card into the data format specified by the field monitoring software, and converting the sampled data into required data according to the data header information.
4. The method of claim 1, wherein preprocessing the cable state awareness data when the preprocessing comprises filtering comprises:
adopting Fast Fourier Transform (FFT) filtering to suppress periodic sinusoidal interference in the partial discharge signal;
adopting wavelet filtering to inhibit white noise interference in the partial discharge signal;
and (3) suppressing random pulse interference in the partial discharge signal by adopting window function filtering.
5. The method of claim 1, wherein preprocessing cable state awareness data when the preprocessing comprises feature map construction comprises:
and constructing a three-dimensional characteristic array map and a two-dimensional characteristic data map.
6. The method of claim 1, wherein determining the manner in which the cable status awareness data is stored in the database comprises at least one of:
determining a data table of the cable status awareness data in a database, wherein the data table comprises at least one of: a state information table, a characteristic data table and a characteristic trend table;
and determining the compiling storage of the cable state perception data in a database, wherein the compiling storage is used for completing an SQL statement set with a preset function, and the compiling storage is stored in the database.
7. The method according to any one of claims 1 to 6, wherein determining the LoRaWAN as a communication mode of the wireless sensor network for data interaction between the sensor node and the database comprises:
the LoRa gateway is in communication connection with the server through an optical fiber, wherein when communication starts, the sensor node is awakened, a LoRa module of the sensor node is set to be in a transmission mode, and a monitoring instruction is received; during monitoring, the sensor node acquires a state quantity and a sampling measurement value, if the sampling measurement value exceeds a preset threshold value, the state quantity and the sampling measurement value are sent to a gateway through the LoRa module and transmitted to the server, and a new monitoring instruction is waited to be received to acquire insulation state information; otherwise, the sensor node will go to sleep after monitoring.
8. An apparatus for processing data, comprising:
the preprocessing module is used for preprocessing the cable state sensing data;
the first processing module is used for determining a storage mode of the cable state perception data in a database, wherein the cable state perception data after being preprocessed is stored according to the storage mode;
and the second processing module is used for accessing the cable state sensing data in the database based on a preset interface and determining a wide area network LoRaWAN as a communication mode of a wireless sensor network to perform data interaction between the sensor node and the database.
9. A computer-readable storage medium, comprising a stored program, wherein when the program runs, the computer-readable storage medium controls an apparatus to execute the data processing method according to any one of claims 1 to 7.
10. A processor, characterized in that the processor is configured to run a program, wherein the program is configured to execute a method for processing data according to any one of claims 1 to 7 when the program is run.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110951465.5A CN113656479A (en) | 2021-08-18 | 2021-08-18 | Data processing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110951465.5A CN113656479A (en) | 2021-08-18 | 2021-08-18 | Data processing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113656479A true CN113656479A (en) | 2021-11-16 |
Family
ID=78481159
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110951465.5A Pending CN113656479A (en) | 2021-08-18 | 2021-08-18 | Data processing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113656479A (en) |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| CN202353611U (en) * | 2011-12-23 | 2012-07-25 | 北京泰克华诚技术信息咨询有限公司 | Wireless sensor node and wireless sensor network |
| CN103901330A (en) * | 2014-04-15 | 2014-07-02 | 上海君世电气科技有限公司 | Partial discharge on-line monitoring method for XLPE cable |
| CN208158613U (en) * | 2018-01-19 | 2018-11-27 | 丰郅(上海)新能源科技有限公司 | Photovoltaic module monitoring system based on LORA wireless telecommunications |
| CN208399019U (en) * | 2018-06-29 | 2019-01-18 | 浙江巨感物联网科技有限公司 | A kind of Wireless Networking type Electric Wires & Cables temperature hidden danger early warning system |
| CN109668637A (en) * | 2018-06-29 | 2019-04-23 | 浙江巨感物联网科技有限公司 | A kind of Wireless Networking type Electric Wires & Cables temperature hidden danger early warning system and method |
| CN110430621A (en) * | 2019-08-02 | 2019-11-08 | 上海西派埃自动化仪表工程有限责任公司 | The communication means and system of detection system |
| CN111107675A (en) * | 2020-01-21 | 2020-05-05 | 山东科华电力技术有限公司 | Cable channel edge Internet of things terminal and method based on ubiquitous power Internet of things |
| CN111579146A (en) * | 2020-05-13 | 2020-08-25 | 国网宁夏电力有限公司检修公司 | SF6 pressure online monitoring system based on remote wireless communication technology |
| CN112364328A (en) * | 2020-12-09 | 2021-02-12 | 国网河北省电力有限公司电力科学研究院 | Computer network information safety monitoring system |
-
2021
- 2021-08-18 CN CN202110951465.5A patent/CN113656479A/en active Pending
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
| CN202353611U (en) * | 2011-12-23 | 2012-07-25 | 北京泰克华诚技术信息咨询有限公司 | Wireless sensor node and wireless sensor network |
| CN103901330A (en) * | 2014-04-15 | 2014-07-02 | 上海君世电气科技有限公司 | Partial discharge on-line monitoring method for XLPE cable |
| CN208158613U (en) * | 2018-01-19 | 2018-11-27 | 丰郅(上海)新能源科技有限公司 | Photovoltaic module monitoring system based on LORA wireless telecommunications |
| CN208399019U (en) * | 2018-06-29 | 2019-01-18 | 浙江巨感物联网科技有限公司 | A kind of Wireless Networking type Electric Wires & Cables temperature hidden danger early warning system |
| CN109668637A (en) * | 2018-06-29 | 2019-04-23 | 浙江巨感物联网科技有限公司 | A kind of Wireless Networking type Electric Wires & Cables temperature hidden danger early warning system and method |
| CN110430621A (en) * | 2019-08-02 | 2019-11-08 | 上海西派埃自动化仪表工程有限责任公司 | The communication means and system of detection system |
| CN111107675A (en) * | 2020-01-21 | 2020-05-05 | 山东科华电力技术有限公司 | Cable channel edge Internet of things terminal and method based on ubiquitous power Internet of things |
| CN111579146A (en) * | 2020-05-13 | 2020-08-25 | 国网宁夏电力有限公司检修公司 | SF6 pressure online monitoring system based on remote wireless communication technology |
| CN112364328A (en) * | 2020-12-09 | 2021-02-12 | 国网河北省电力有限公司电力科学研究院 | Computer network information safety monitoring system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110456234B (en) | Fault arc detection method, device and system | |
| CN112688310B (en) | Line loss analysis method and device applied to power distribution network | |
| CN112763848A (en) | Method and device for determining power system fault | |
| CN110299758A (en) | A kind of comprehensive on-line monitoring and diagnosis system of substation | |
| CN115687969A (en) | Low-voltage transformer fault diagnosis method based on sound characteristic analysis | |
| CN116980958A (en) | Radio equipment electric fault monitoring method and system based on data identification | |
| CN104597813A (en) | Intelligent socket capable of automatically identifying electric appliance running state | |
| CN212009318U (en) | Bridge monitoring facilities based on edge calculation | |
| CN113656479A (en) | Data processing method and device | |
| CN106771491B (en) | Zero sequence voltage measuring method and device | |
| CN203630283U (en) | Hand-held detection device used for cable insulation detection | |
| CN112179486A (en) | Noise monitoring method, device and system, processor and electronic equipment | |
| CN111324073A (en) | Machine tool detection and analysis method and analysis platform thereof | |
| CN112218258A (en) | 5G-based electric power measurement online monitoring method | |
| CN111064279A (en) | Power failure event reporting test system and method | |
| CN206807149U (en) | A kind of Electrical Safety control system based on broadband power line carrier | |
| CN112118550B (en) | Wireless transmission method of equipment state monitoring information | |
| CN107014437A (en) | The intelligent data acquisition method of transformer station's multisensor syste | |
| CN111199078B (en) | Retarder Internet of things fault early warning method based on multi-interval motion curve sample entropy | |
| CN114062867A (en) | Sensor data processing module and transformer substation distributed monitoring system and method | |
| CN107677880A (en) | A kind of overvoltage intelligent identifying system based on the monitoring of leakage conductor tail current | |
| CN116150195A (en) | System and method for online monitoring safety low-carbon electricity consumption of users in multiple types of parks | |
| CN111060730A (en) | On-site data acquisition device and method in periodic rotation process of metering equipment | |
| CN112468248A (en) | Cognitive radio frequency spectrum detection method based on power wireless private network | |
| CN112858902A (en) | Miniature circuit breaker monitoring method and device, computer equipment and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20211116 |