CN113852199A - Multi-dimensional distribution automation inspection system - Google Patents

Multi-dimensional distribution automation inspection system Download PDF

Info

Publication number
CN113852199A
CN113852199A CN202111129244.6A CN202111129244A CN113852199A CN 113852199 A CN113852199 A CN 113852199A CN 202111129244 A CN202111129244 A CN 202111129244A CN 113852199 A CN113852199 A CN 113852199A
Authority
CN
China
Prior art keywords
information
data
power grid
distribution automation
grid equipment
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.)
Granted
Application number
CN202111129244.6A
Other languages
Chinese (zh)
Other versions
CN113852199B (en
Inventor
吴健
沈伟
许颖文
刘丽君
魏睿文
陈彦萤
万小进
李凯嵘
潘舒
刘卉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Taizhou Power Supply Co of State Grid Jiangsu Electric Power Co Ltd
Original Assignee
Taizhou Power Supply Co of State Grid Jiangsu Electric Power Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Taizhou Power Supply Co of State Grid Jiangsu Electric Power Co Ltd filed Critical Taizhou Power Supply Co of State Grid Jiangsu Electric Power Co Ltd
Priority to CN202111129244.6A priority Critical patent/CN113852199B/en
Publication of CN113852199A publication Critical patent/CN113852199A/en
Application granted granted Critical
Publication of CN113852199B publication Critical patent/CN113852199B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • HELECTRICITY
    • H02GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
    • H02JCIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
    • H02J13/00Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
    • H02J13/00001Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by the display of information or by user interaction, e.g. supervisory control and data acquisition systems [SCADA] or graphical user interfaces [GUI]
    • HELECTRICITY
    • H02GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
    • H02JCIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
    • H02J13/00Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
    • H02J13/00002Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by monitoring
    • HELECTRICITY
    • H02GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
    • H02JCIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
    • H02J13/00Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
    • H02J13/00006Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by information or instructions transport means between the monitoring, controlling or managing units and monitored, controlled or operated power network element or electrical equipment
    • HELECTRICITY
    • H02GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
    • H02JCIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
    • H02J13/00Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
    • H02J13/00032Systems characterised by the controlled or operated power network elements or equipment, the power network elements or equipment not otherwise provided for
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02EREDUCTION OF GREENHOUSE GAS [GHG] EMISSIONS, RELATED TO ENERGY GENERATION, TRANSMISSION OR DISTRIBUTION
    • Y02E60/00Enabling technologies; Technologies with a potential or indirect contribution to GHG emissions mitigation
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
    • Y04S40/00Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them
    • Y04S40/12Systems for electrical power generation, transmission, distribution or end-user application management characterised by the use of communication or information technologies, or communication or information technology specific aspects supporting them characterised by data transport means between the monitoring, controlling or managing units and monitored, controlled or operated electrical equipment

Landscapes

  • Engineering & Computer Science (AREA)
  • Power Engineering (AREA)
  • Human Computer Interaction (AREA)
  • Data Exchanges In Wide-Area Networks (AREA)

Abstract

The invention discloses a multi-dimensional distribution automation inspection system, which comprises: the data acquisition module is used for acquiring power grid equipment information, power grid equipment measurement sampling information and power grid equipment operation information; the intelligent data analysis module is used for converting the information by adopting a bit operation conversion algorithm and a label conversion object mode, classifying and integrating the converted information in a grading way, and screening data by comparing preset threshold information; and the intelligent client module is used for analyzing the screened data, integrating and screening the analyzed data, and performing client early warning by adopting an early warning mode of multi-measurement, multi-correspondence and multi-threshold. According to the invention, an automatic daily inspection means is improved by an intelligent operation means of collecting and analyzing data, early warning and calibration; through program intelligent operation, calibration, analysis and partial manual intervention, the inspection efficiency is improved, and the stable operation of the distribution automation system is ensured.

Description

Multi-dimensional distribution automation inspection system
Technical Field
The invention relates to the technical field of power distribution network inspection, in particular to a multi-dimensional power distribution automation inspection system.
Background
At present, power distribution automation system patrols including server operation information patrols, and system operation patrols, and the accident is patrolled, and operation defect is patrolled etc. and its system possesses following function: alarm query, querying historical operating data; the method comprises the steps of short message pushing, namely receiving data in real time through short messages; browsing and patrolling the graph; and the server operation information is inquired one by one.
However, the automation system has the following disadvantages in the daily patrol process: the alarm query patrol means is single, various information is queried through various query tools, the workload is increased, and the one-key patrol function is lacked; the short message pushing quantity is large and too frequent, the correct judgment of automation personnel is interfered, the alarm threshold value is not set intelligently, and a real-time patrol means is lacked; the graph browsing mode needs to pre-draw graph information, and the graph information is inquired through a four-area web, so that the workload is high, and the report counting function is not realized; the inspection of the line account information is complex, many inspection of a plurality of model account tables can inquire the distribution network line account, and the functions of one-key export and the like are not supported; the main and distribution networks are independent, and each patrol formation module is also independent, so that independent patrol is required, and results cannot be gathered in a centralized manner. In a word, the existing distribution automation inspection system is a distributed system, the data of the equipment has no relevance, and some data are displayed in different types or in a script form, so that the data are not convenient to analyze and the related equipment is accurately inspected and early-warned.
Disclosure of Invention
Based on this, the invention provides a multi-dimensional power distribution automation inspection system aiming at the technical problems.
The embodiment of the invention provides a multi-dimensional power distribution automation inspection system, which comprises:
the data acquisition module is used for acquiring power grid equipment information, power grid equipment measurement sampling information and power grid equipment operation information; the power grid equipment operation information is in an E text form;
the data intelligent analysis module is used for converting the power grid equipment information of different measurement types into object information with an incidence relation by adopting a bit operation conversion algorithm; converting an E text of the operation information of the power grid equipment into object information with an incidence relation by adopting a label conversion object mode; classifying and grading integrating the converted power grid equipment information, the power grid equipment measurement sampling information and the converted power grid equipment operation information, and performing data screening by comparing preset threshold information;
and the intelligent client module is used for analyzing the screened data, integrating and screening the analyzed data, and performing client early warning by adopting an early warning mode of multiple measurement, multiple correspondence and multiple thresholds.
In one embodiment, the power grid equipment information is obtained by real-time inquiry through a client; the power grid equipment measurement sampling information is obtained through timing scheduling inquiry;
the query mode is as follows: and (3) linking an alarm library, a model library and a measurement sampling library in a network database by using the drive link pool under multiple data sources to query the multiple data sources.
In one embodiment, the operation information of the power grid equipment is acquired by an equipment operation information acquirer;
the device operation information collector monitors the operation state of each server in the server node information by reading the memory real-time library and the script mode, and the monitoring information comprises: memory status, disk status, network status.
In one embodiment, the monitoring information further includes: usage of tablespaces, containment operations, and suspicious operation records of containment operations.
In one embodiment, the power grid equipment information of different measurement types includes: current value, voltage value, active value, inactive value.
In one embodiment, the bit operation conversion algorithm performs an and operation on the device ID converted into a domain information ID corresponding to the measurement type after being shifted left by 32 bits in binary.
In one embodiment, the intelligent data analysis module includes: an alarm screening unit;
the alarm screening unit is used for monitoring frequent displacement of the switch equipment, frequent switching on and off of a communication channel and remote control failure alarm in the remote control equipment; and the time status screening of the table information in the ALARM mode is carried out.
In one embodiment, the intelligent data analysis module includes: a remote measuring sampling screening unit;
the telemetering sampling screening unit is used for appointing telemetering sampling information through bit operation of relevant information of the equipment list and screening data according to time intervals through dynamic sampling table names and column names defined in the telemetering sampling information.
In one embodiment, the intelligent data analysis module includes: an equipment operation information screening unit;
the device operation information screening unit is used for intelligently converting the text file into object information with an incidence relation by adopting a label conversion object mode through an E file monitored and generated by the node operation information monitor, converting the object information into specific device information and screening the specific device information through a preset threshold value.
In one embodiment, the intelligent client module is specifically used for statistical tour warning, automatic system operation defect tour warning, tour monitoring of distribution automation equipment ledgers, report statistics warning, accident warning and database warning of hardware equipment.
Compared with the prior art, the multi-dimensional power distribution automation inspection system provided by the embodiment of the invention has the following beneficial effects:
according to the invention, the automatic daily inspection means is promoted by the intelligent operation means of data acquisition and analysis, early warning and calibration, so that the workload is reduced, the operation stability of the system is ensured, and a solvable scheme is provided by the data acquisition and analysis, so that the problems occurring in the inspection process are accurately and effectively solved; through program intelligent operation, calibration, analysis and partial manual intervention, the inspection efficiency is improved, and the stable operation of the distribution automation system is ensured. The method comprises the steps of carrying out multi-data source collection after upgrading and integrating scattered inspection modules in a power distribution automation system, analyzing and screening data intelligent algorithms, and uniformly inspecting, early warning and correcting; the routing inspection modules which are dispersed under different equipment and network segments in the original distribution automation system are gathered, and the functions are upgraded on the basis, so that the cost for communication between the original dispersed routing inspection modules is greatly reduced, and the problem processing efficiency is improved; the abnormity of the equipment is generated, data monitoring, analysis and statistics, early warning and correction are carried out to form a complete closed loop, and the operation function efficiency of the distribution automation system is greatly improved.
Drawings
FIG. 1 is a schematic diagram of a system network topology provided in one embodiment;
fig. 2 is a schematic diagram of a logical structure of the system provided in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
Fig. 1 shows the network topology of the invention, service deployment is performed by means of internal client chaining bastion machine, the system relies on software environment, such as JDK, MYSQL, DMSERVER, etc. deployed in web server, remote client accesses the system through firewall of web by means of adding white list, wherein data interaction between web server and database server is as shown in fig. 2.
Referring to fig. 1 and 2, a multi-dimensional power distribution automation inspection system provided in an embodiment of the present invention includes:
the data acquisition module is used for acquiring the power grid equipment information, the equipment measurement sampling information and the equipment operation information in a timing and quantitative mode; sending the data to a data intelligent analysis module, screening by an intelligent algorithm, classifying, and classifying the data information in a grading manner; the intelligent client module analyzes the screened information, designs an early warning mode with more measurement, more correspondence and more thresholds to carry out client warning and generates a solution and a statistical report; and finally, abnormal information is processed in a machine intelligent calibration, alignment and manual intervention mode, so that the problem is solved and a closed loop is formed. Specifically, the method comprises the following steps:
a data acquisition module: the module mainly comprises two parts:
the first is equipment measurement data acquisition in a timing scheduling function and equipment information acquisition queried by a client in real time, and the query of the part mainly depends on a drive link pool under multiple data sources to ensure that the higher query efficiency is achieved when a warning library, a model library and multiple data sources of a measurement sampling library are linked.
The second is data acquisition of an equipment operation information acquisition unit, the acquisition unit monitors each server in the server node information by reading a memory real-time library and a script mode, and the monitored information comprises: memory, disk, network state. Also monitored is the usage of tablespace, containment operations and containment operations' suspicious operation records. The three data information are collected and transmitted in a mode of generating an E text.
The data intelligent analysis module: the module regularly schedules and inquires measurement sampling information by inquiring real-time equipment information, integrates data analyzed by an E text, performs data screening and early warning by comparing preset threshold information, and simultaneously converts the incidence relation by adopting a bit operation mode aiming at different types of measurement of the equipment, such as current value, voltage value, active value, passive value and the like. The specific conversion algorithm is to convert the device ID into a binary system, shift the binary system by 32 bits to the left, and perform an and operation on the domain information ID corresponding to the measurement type. The module comprises three aspects for the information of data intelligent screening:
and (4) alarming: the method mainly monitors frequent displacement of the switch equipment, frequent switching on and off of a communication channel and remote control failure alarm in the remote control equipment; the data is mainly screened by the time state of the related table information in the ALARM mode.
Telemetry sampling: the data screening of the telemetering sampling specifies telemetering sampling information through bit operation of relevant information of the equipment list, and the data screening is carried out according to time intervals through a dynamic sampling table name and a column name defined in the telemetering sampling information.
Equipment operation information: the method comprises the steps of intelligently converting a text file into object information with an incidence relation by adopting a label conversion object mode through an E file monitored and generated by a node operation information monitor, converting the object information into specific equipment information, and screening and early warning through a preset threshold value.
The intelligent client module: the module performs classification, hierarchical integration and secondary screening on the screened data (wherein the analysis is to re-analyze the data after conversion and screening into specific equipment information, measurement sampling information and equipment operation information), provides a set of intelligent early warning function and sampling analysis function at a client, provides a derivable data report, and provides a resolvable scheme or early warning by displaying visual information. The method mainly comprises the following steps: performing statistics tour early warning on hardware equipment; an automatic system operation defect inspection tour; inspecting and monitoring the distribution automation equipment machine account and counting reports; accident early warning; database forewarning, etc.
Example (b):
1. data table structure
Figure BDA0003279451940000061
Figure BDA0003279451940000071
Figure BDA0003279451940000081
Figure BDA0003279451940000091
2. State definition
Node state definition specification
Figure BDA0003279451940000101
Network state definition specification
Figure BDA0003279451940000102
Node type definition specification
Figure BDA0003279451940000103
3. Hardware patrol of equipment
The file format of the server CPU, the memory, the hard disk capacity and the network state E is as follows:
Figure BDA0003279451940000104
4. power distribution automation system operation defect inspection tour
Frequent displacement of switch
select yx_id,long2_to_long1(yx_id),count(*)from dms_yx_bw A where (occur_time>=(to_date('%s','yyyy-mm-dd hh24:mi:ss'))and occur_time<(to_date('%s','yyyy-mm-dd hh24:mi:ss'))and status<=34)groupbyA.yx_idhavingcount(*)>=%dorderbycount(*)desc
Three variables, start time, end time, count number, support input acquisition, default day 0 to day 23:59:59, count number default 4.
Protecting against frequent repositioning
select yx_id,long2_to_long1(yx_id),count(*)from dms_rl_yx_warn A where(occur_time>=(to_date('%s','yyyy-mm-dd hh24:mi:ss'))and occur_time<(to_date('%s','yyyy-mm-dd hh24:mi:ss'))and status<=34)groupbyA.yx_idhavingcount(*)>=%dorderbycount(*)desc
long2_ to _ long1(yx _ id), this value corresponds to the distribution network protection node table (dms _ relay _ sig) master key. And displaying the webpage by using the corresponding Chinese name reference. And the retrieval of responsibility areas, affiliated feeders, Chinese name keywords, voltage grades and the like in the distribution network protection node table is supported.
Frequent switching on and off of channel
select chan_id,count(*)from dms_channel_gk A where(occur_time>=(to_date('%s','yyyy-mm-dd hh24:mi:ss'))andoccur_time<(to_date('%s','yyyy-mm-ddhh24:mi:ss'))and status in(1,4))group byA.chan_id havingcount(*)>=%dorderbycount(*)desc。
channel id, which corresponds to the distribution network channel table (dms _ channel _ info) primary key. And displaying the webpage by using the corresponding Chinese name reference.
Support area, keyword retrieval. Region acquisition means: dms _ channel _ info.channel _ id finds dms _ channel _ info.terminal _ id
Channel exit
select channel _ id, status from dms _ channel _ gk A where (occur _ time >) (to _ date ('% s', 'yyyyyyyy-mm-ddhh 24: mi: ss')) and occur _ time < (to _ date ('% s', 'yyyyyyyyyyy-dd hh24: mi: ss')) and status in (1,4)) order by occur _ time (1 for input and 4 for exit)
channel id, which corresponds to the distribution network channel table (dms _ channel _ info) primary key. And displaying the webpage by using the corresponding Chinese name reference.
Support area, keyword retrieval. Region acquisition means: dms _ channel _ info.id finds dms _ channel _ info.terminal _ id ═ dms _ terminal _ info.id finds dms _ terminal _ info.area _ id.
Failure of remote control
select occur_time,meas_id,feeder_id,combined_id,user_id,content,status from alarm.dms_op_ctrl c where(occur_time>=(to_date('%s','yyyy-mm-dd hh24:mi-ss'))and occur_time<(to_date('%s','yyyy-mm-dd hh24:mi-ss'))and(status in(6,10)))orderbyoccur_timedesc
The method for converting the meas _ id into the master key of the distribution network switch table (dms _ cb _ device) is as follows:
Figure BDA0003279451940000111
and the responsibility areas, the affiliated feeders, Chinese name keywords, voltage classes and the like in the distribution network switch list are searched.
5. Standing book inspection
selectid,name,feeder_id,area_id,term_dept,para_6,term_type,if_stat_static from dms_terminal_info
selectid,name,st_idfromdms_feeder_device
selectid,namefromsubstation
selectid,simu_mode,ctrl_mode,feeder_idfromcb_ctrl_mode
selectid,terminal_id,para_4,proto_type,manual_statusfromdms_channel_info
selectpsid,tem_id,index_nofromdms_send_dc
selectmenu_name,actual_value,display_valuefromsys_menu_info
Patrol data
The fields are as follows: manual state setting index statistics of terminal name terminal type two-three remote communication mode operation state stipulation type of FA execution mode of regional unit plant station name line name FA operation mode
A uniqueness field: id of terminal name dms _ terminal _ info
The region: xuzhou (write dead or use configuration file according to deployment area)
Unit: term _ depth of dms _ term _ info corresponds to menu "unit to which terminal belongs"
Factory site name, the feeder _ id of the dms _ terminal _ info finds the st _ id of the dms _ feeder _ device finds the name of the substation
Line name: the feeder _ id of the dms _ terminal _ info corresponds to the name of the dms _ feeder _ device
An FA operation mode: the dms _ terminal _ info table feeder _ id ═ cb _ ctrl _ mode table feeder _ id, the single _ mode of the cb _ ctrl _ mode table corresponds to the menu "DA running mode", and if not, the menu is "unconfigured"
The FA executes the mode: the dms _ terminal _ info table feeder _ id ═ cb _ ctrl _ mode table feeder _ id, ctrl _ mode of the cb _ ctrl _ mode table corresponds to the menu "DA execution mode," unconfigured "if not found"
And (3) terminal name: dms _ terminal _ info table name
The terminal type: term _ type of dms _ term _ info corresponds to menu "terminal type"
Two and three remote operations: three methods are as follows:
1) string with two remote/three remote in general name
2) Judging the system configuration, wherein the ID of the dms _ terminal _ info table is dms _ send _ dc.tem _ ID, and acquiring the record in the dms _ send _ dc table; there is a record and dms _ send _ dx.index _ no is three-way if 0, and 2-way if not
3) The system configuration is judged to be too troublesome and temporarily not written
The communication mode is as follows: the ID of the dms _ terminal _ info table is dms _ channel _ info.terminal _ ID, and dms _ channel _ info.para _4 corresponds to the menu "terminal communication mode"
The operation state is as follows: run _ state of dms _ terminal _ info table corresponds to menu "distribution terminal operation mode"
The type of the convention: the ID of the dms _ final _ info table is dms _ channel _ info.final _ ID, and dms _ channel _ info.proto _ type corresponds to the menu "preamble communication protocol"
Manual configuration: the ID of the dms _ terminal _ info table is dms _ channel _ info.terminal _ ID, and dms _ channel _ info.manual _ status corresponds to the menu "communication station manual configuration"
Index statistics: the if _ stat _ state of the dms _ terminal _ info table corresponds to the menu "binary decision".
6. Process patrol
selectocure time, node id, proc alias, status, contentfromalarm, proc _ war _ info (time range is set by person)
Taking proc _ alias as a unit, counting the times, and checking the specific details by right key
status corresponding menu "progress alarm status"
7. Database patrol
Watch space use patrol
Sql:select
t.nametablespace_name,
d.free_size*SF_GET_PAGE_SIZE()/1024/1024
||'M'free_space,
d.total_size*SF_GET_PAGE_SIZE()/1024/1024
||'M'total_space,
d.free_size*100/d.total_size"%FREE"
from
v$tablespacet,
v$datafiled
where
t.id=d.group_id;
And setting a utilization rate alarm threshold value and giving a key prompt to the table space with higher utilization rate.
Single-meter record utilization rate inspection tour
The data E file format is as follows:
Figure BDA0003279451940000131
and setting a utilization rate alarm threshold value and prompting the point of using a higher table.
8. Line FA state patrol
Configuration patrol:
cb _ id of the FA mode definition table cb _ ctrl _ mode as an index
The switch name is as follows: cb _ id decision 407 or 13502, referring to the table name
Static definitions whether or not: whether a record exists in the equipment ID (cb _ ID) of the distribution network static equipment switch relation table or not
Static definition: and acquiring feeder _ ID and displaying the name of a feeder line by using the equipment ID (cb _ ID) of the distribution network static equipment switch relation table
Whether the data is not actually measured: breaker table id ═ cb _ id, get the record status, and take the and with 0x00002000
The number of associated protections: number of records of rly _ brk1 ═ cb _ id in protection signal table (a plurality of records are repeatedly processed as follows)
Protection 1: the main key id (sig _ id) of the record is obtained by protecting the name of the real _ brk1 ═ cb _ id in the signal protection table
Static definitions whether or not: whether a record exists in the equipment ID sigid of the distribution network static equipment switch relation table or not
Whether the data is not actually measured: the guard signal table id sig _ id is obtained, and the record qual is anded with 0x00002000
Protection type: sigjd, pnt _ type of the record is obtained, and menu definition information is presented
And (3) state patrol:
cb _ id of the FA mode definition table cb _ ctrl _ mode as an index
The switch name is as follows: cb _ id decision 407 or 13502, referring to the table name
The method comprises the following steps: st _ id of cb _ ctrl _ mode, corresponding to primary key of factory site table
The current operation mode is as follows: simu _ mode0 of cb _ ctrl _ mode online 1 offline 2 simulation (menu definition table DA run mode)
The current execution mode is as follows: ctrl _ mode0 interaction of cb _ ctrl _ mode 1 auto (menu definition table DA execution mode)
9. Redundant data inspection tour of distribution automation system
Redundant graph tour
1) Graphic information table graph _ info _ net, line single line diagram, showing that one line pair generally uses 3 single line diagrams (simplified diagram, detailed scheduling diagram, detailed inspection diagram) by using line name, and aiming at line sets less than 3 or more than three
Figure BDA0003279451940000132
Redundant model inspection tour
1) Primary device redundancy
1. Feeder table dms _ feeder _ device field st _ id, rdf _ id, graph _ name are null (all or a relationship)
2. The switching station table dms _ combined _ device fields feeder _ id, rdf _ id are empty
3. The switch table dms _ cb _ device feeder _ id, the fields rdf _ id, ind, jnd are empty
4. The switch table dms _ disconnect _ device field feeder _ id, rdf _ id, ind, jnd is empty
5. The feeder segment table dms _ section _ device field feeder _ id, rdf _ id, ind, jnd is empty
6. The bus table dms _ bs _ device field feeder _ id, combined _ id, rdf _ id, nd is null
7. The protection table dms _ relay _ sig field feeder _ id is empty, the reply _ brk1 is empty, or the id is determined to be empty first, and if the record does not exist in the table, the record is also redundant data
2) Secondary device redundancy
Distribution network terminal table dms _ terminal _ info
The chan _ ID is found in the distribution network channel table through the terminal ID, and the chan _ ID1 of the prepositive remote signaling definition table dms _ fes _ yx _ definition does not exist in the chan _ ID
3) Preamble data
The chan _ id1 of the preposition remote signaling table dms _ fes _ yx _ define table is empty or dot _ no <0
The chan _ id1 of the preposed telemetry table dms _ fes _ yc _ define table is null or dot _ no <0
Redundant user patrol
1) Obtaining user information in a system
Selectuser_id,user_name,create_datefromsys_priv_user_d_def
2) Obtaining user operation information
Seectocucur _ time, content, status, custom _ group, node _ id, user _ idfrogmaser _ office (ocucur _ time > -TO _ DATE ('2021-02-2300:00:00', 'yyyyyyy-mm-ddhh 24: mi: ss') AND ocucur _ time < (TO _ DATE) ('2021-02-2316:38:36', 'yyyyyyy-mm-ddhh 24: mi: ss') ORDERYocucur _ time default TO no login as a redundant user for more than 30 days
10. Suspicious operation inspection tour of distribution automation system
Hang tablet operation tour
Only the distribution network listing is processed, the listing information table (token _ info) app _ record is 0 and app _ record3>0
Acquiring a field: token _ id, graph _ name, device _ id, token _ no, note, record _ app, user _ name, reserv _ str1, resp _ area, record _ app3
Calculating the card hanging time according to the card hanging time, wherein the longer the time is, the longer the time is
Supporting the inquiry of listing duration, type, user, keyword, etc
Judging the table _ no of the device _ id, if the table _ no is 13502, supporting the viewing of distribution network telecommand deflection history alarms (listing time to the present); 13533 support viewing distribution network secondary remote signaling deflection history alarm (time to now)
Judging table _ no of device _ id, if 13502 supports checking A-phase current sampling (the listing time is up to now); 13506 supporting the check of bus voltage sampling (time to now)
Locking operation patrol
1. Blocked device parse file dms _ devstate _20201117153000.txt- - -lock _ info
2. And judging whether the file recording is automatic or not and if so, judging that the equipment type is a distribution network switch as follows: the remote signaling value is 0, the current is larger than the X value, and the suspicious mark is carried out; the remote signaling value is 1, the current is less than the X value, and the suspicious mark is carried out; x value can be set
3. Checking the blocking operating time of the device (settable time period, long blocking flag suspicious)
selected _ time, content, status, combined _ ID, stored _ group, feeder _ ID, node _ ID, resp _ area, user _ ID, yx _ ID from, dms _ op _ yx where (occur _ time > -TO _ DATE ('2020-11-1900: 00:00', 'yyyyy-mm-dd hh24: mi: ss') AND occur _ time < (TO _ DATE) ('2020-11-1917:25:55', 'yyyy-mm-ddhh24: mi)') AND (status) } 3 or status > -2 AND _ ID > -TO _ logging 1_ TO _ logging _2 (ORR) } device)
Suppression operation tours
1. The suppression device parses a file dms _ devstate.
Figure BDA0003279451940000141
2. According to whether the file recording is automatic or not, if not, the state is inhibited, and then the file is suspicious
3. If the file record is in automatic state, check the suppression operation time of the equipment (the time period can be set, the long-time suppression mark is suspicious)
selected _ time, content, status, combined _ ID, stored _ group, feeder _ ID, node _ ID, resp _ area, user _ ID, yx _ ID from area, dms _ op _ yx where (occur _ time > -TO _ DATE ('2020-11-1900: 00:00', 'yyyyy-mm-dd hh24: mi: ss') AND ocucur _ time < (TO _ DATE) ('2020-11-1917:25:55', 'yyyyy-mm-dd hh24: mi: ss')) AND status ═ 7 yx _ ID ═ long _ 1_ TO _ long2 (device ID)) ORDER _ time.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the techniques in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features. Furthermore, the above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims (10)

1. The utility model provides a distribution automation system of patrolling and examining of multidimension degree which characterized in that includes:
the data acquisition module is used for acquiring power grid equipment information, power grid equipment measurement sampling information and power grid equipment operation information; the power grid equipment operation information is in an E text form;
the data intelligent analysis module is used for converting the power grid equipment information of different measurement types into object information with an incidence relation by adopting a bit operation conversion algorithm; converting an E text of the operation information of the power grid equipment into object information with an incidence relation by adopting a label conversion object mode; classifying and grading integrating the converted power grid equipment information, the power grid equipment measurement sampling information and the converted power grid equipment operation information, and performing data screening by comparing preset threshold information;
and the intelligent client module is used for analyzing the screened data, integrating and screening the analyzed data, and performing client early warning by adopting an early warning mode of multiple measurement, multiple correspondence and multiple thresholds.
2. The multi-dimensional power distribution automation inspection system according to claim 1,
the power grid equipment information is obtained by real-time inquiry through a client; the power grid equipment measurement sampling information is obtained through timing scheduling inquiry;
the query mode is as follows: and (3) linking an alarm library, a model library and a measurement sampling library in a network database by using the drive link pool under multiple data sources to query the multiple data sources.
3. The multidimensional power distribution automation inspection system according to claim 1, wherein the power grid equipment operation information is acquired by an equipment operation information collector;
the device operation information collector monitors the operation state of each server in the server node information by reading the memory real-time library and the script mode, and the monitoring information comprises: memory status, disk status, network status.
4. The multi-dimensional power distribution automation inspection system according to claim 3, wherein the monitoring information further includes: usage of tablespaces, containment operations, and suspicious operation records of containment operations.
5. The multidimensional power distribution automation inspection system according to claim 1, wherein the different measurement types of power grid equipment information include: current value, voltage value, active value, inactive value.
6. The multi-dimensional power distribution automation inspection system according to claim 1, wherein the bit operation conversion algorithm performs an and operation for converting the device ID into a binary field information ID shifted left by 32 bits and corresponding to the measurement type.
7. The multidimensional power distribution automation inspection system according to claim 1, wherein the data intelligent analysis module includes: an alarm screening unit;
the alarm screening unit is used for monitoring frequent displacement of the switch equipment, frequent switching on and off of a communication channel and remote control failure alarm in the remote control equipment; and the time status screening of the table information in the ALARM mode is carried out.
8. The multidimensional power distribution automation inspection system according to claim 1, wherein the data intelligent analysis module includes: a remote measuring sampling screening unit;
the telemetering sampling screening unit is used for appointing telemetering sampling information through bit operation of relevant information of the equipment list and screening data according to time intervals through dynamic sampling table names and column names defined in the telemetering sampling information.
9. The multidimensional power distribution automation inspection system according to claim 1, wherein the data intelligent analysis module includes: an equipment operation information screening unit;
the device operation information screening unit is used for intelligently converting the text file into object information with an incidence relation by adopting a label conversion object mode through an E file monitored and generated by the node operation information monitor, converting the object information into specific device information and screening the specific device information through a preset threshold value.
10. The multidimensional power distribution automation inspection system according to claim 1, wherein the intelligent client module is specifically used for statistical inspection early warning of hardware devices, inspection early warning of operation defects of an automation system, inspection monitoring of machine accounts of power distribution automation devices, report statistical early warning, accident early warning, and database early warning.
CN202111129244.6A 2021-09-26 2021-09-26 Multi-dimensional power distribution automation inspection system Active CN113852199B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111129244.6A CN113852199B (en) 2021-09-26 2021-09-26 Multi-dimensional power distribution automation inspection system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111129244.6A CN113852199B (en) 2021-09-26 2021-09-26 Multi-dimensional power distribution automation inspection system

Publications (2)

Publication Number Publication Date
CN113852199A true CN113852199A (en) 2021-12-28
CN113852199B CN113852199B (en) 2023-12-05

Family

ID=78979774

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111129244.6A Active CN113852199B (en) 2021-09-26 2021-09-26 Multi-dimensional power distribution automation inspection system

Country Status (1)

Country Link
CN (1) CN113852199B (en)

Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090281674A1 (en) * 2008-05-09 2009-11-12 Taft Jeffrey D Method and system for managing a power grid
CN102801216A (en) * 2012-09-06 2012-11-28 上海欣影电力科技发展有限公司 Intelligent substation inspection system
CN104617671A (en) * 2015-02-06 2015-05-13 广州供电局有限公司 Method for monitoring operation state of electric power automatic system based on multi-dimensiona
CN107302588A (en) * 2017-07-25 2017-10-27 贵州眯果创意科技有限公司 A kind of intelligent network energy monitor control system based on Web
CN109066971A (en) * 2018-07-26 2018-12-21 安徽南瑞继远电网技术有限公司 Intelligent substation fortune inspection managing and control system and method based on whole station business datum
CN110707823A (en) * 2019-11-08 2020-01-17 国网上海市电力公司 Multi-dimensional intelligent remote inspection system for transformer substation
CN111585345A (en) * 2020-05-26 2020-08-25 广东电网有限责任公司 Intelligent patrol system for distribution network
CN111784178A (en) * 2020-07-10 2020-10-16 西南石油大学 Distribution transformer state evaluation method based on multi-source information fusion
CN112311097A (en) * 2020-11-03 2021-02-02 国网智能科技股份有限公司 On-line intelligent patrol centralized monitoring system and method for transformer substation
CN112435361A (en) * 2020-11-03 2021-03-02 国网智能科技股份有限公司 Transformer substation combined inspection method and system

Patent Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20090281674A1 (en) * 2008-05-09 2009-11-12 Taft Jeffrey D Method and system for managing a power grid
CN102801216A (en) * 2012-09-06 2012-11-28 上海欣影电力科技发展有限公司 Intelligent substation inspection system
CN104617671A (en) * 2015-02-06 2015-05-13 广州供电局有限公司 Method for monitoring operation state of electric power automatic system based on multi-dimensiona
CN107302588A (en) * 2017-07-25 2017-10-27 贵州眯果创意科技有限公司 A kind of intelligent network energy monitor control system based on Web
CN109066971A (en) * 2018-07-26 2018-12-21 安徽南瑞继远电网技术有限公司 Intelligent substation fortune inspection managing and control system and method based on whole station business datum
CN110707823A (en) * 2019-11-08 2020-01-17 国网上海市电力公司 Multi-dimensional intelligent remote inspection system for transformer substation
CN111585345A (en) * 2020-05-26 2020-08-25 广东电网有限责任公司 Intelligent patrol system for distribution network
CN111784178A (en) * 2020-07-10 2020-10-16 西南石油大学 Distribution transformer state evaluation method based on multi-source information fusion
CN112311097A (en) * 2020-11-03 2021-02-02 国网智能科技股份有限公司 On-line intelligent patrol centralized monitoring system and method for transformer substation
CN112435361A (en) * 2020-11-03 2021-03-02 国网智能科技股份有限公司 Transformer substation combined inspection method and system

Also Published As

Publication number Publication date
CN113852199B (en) 2023-12-05

Similar Documents

Publication Publication Date Title
CN101325520B (en) Method for locating and analyzing fault of intelligent self-adapting network based on log
CN103079219B (en) Base station automatic inspection digital management system and method
CN107612779B (en) Secondary safety protection network equipment of dispatching data network and service operation monitoring system
CN106371986A (en) Log treatment operation and maintenance monitoring system
CN105868075A (en) System and method for monitoring and analyzing large amount of logs in real time
CN106649040A (en) Automatic monitoring method and device for performance of Weblogic middleware
CN101997925A (en) Server monitoring method with early warning function and system thereof
CN111162949A (en) Interface monitoring method based on Java byte code embedding technology
CN111259073A (en) Intelligent business system running state studying and judging system based on logs, flow and business access
CN110209518A (en) A kind of multi-data source daily record data, which is concentrated, collects storage method and device
CN113849553A (en) Substation data acquisition and processing method and system based on Internet of things equipment data acquisition
CN104574219A (en) System and method for monitoring and early warning of operation conditions of power grid service information system
CN101989931A (en) Operation alarm processing method and device
CN113179173A (en) Operation and maintenance monitoring system for highway system
Hamilton et al. SCADA Statistics monitoring using the elastic stack (Elasticsearch, Logstash, Kibana)
CN110929896A (en) Security analysis method and device for system equipment
CN112350846A (en) Asset learning method, device, equipment and storage medium for intelligent substation
CN111352195A (en) Intelligent optical cable monitoring system for optical cable protection
CN109858807B (en) Enterprise operation monitoring method and system
CN111666741A (en) Automatic generation method of scheduling comprehensive report
CN106534162A (en) Server temperature monitoring system and method based on remote management communication protocol
CN114253806A (en) Access stratum log collection, analysis and early warning system
KR100984282B1 (en) An enterprise security management system using an memory cache
CN117914511A (en) Security audit system based on data exchange and log analysis
CN112162896A (en) InfluxDB-based cluster data monitoring method

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
GR01 Patent grant
GR01 Patent grant