CN109656909A - A kind of transmission of electricity expert data management system - Google Patents

A kind of transmission of electricity expert data management system Download PDF

Info

Publication number
CN109656909A
CN109656909A CN201811472316.5A CN201811472316A CN109656909A CN 109656909 A CN109656909 A CN 109656909A CN 201811472316 A CN201811472316 A CN 201811472316A CN 109656909 A CN109656909 A CN 109656909A
Authority
CN
China
Prior art keywords
data
management
electricity
user
module
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
Application number
CN201811472316.5A
Other languages
Chinese (zh)
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.)
State Grid Corp of China SGCC
State Grid Hebei Electric Power Co Ltd
Baoding Power Supply Co of State Grid Hebei Electric Power Co Ltd
Original Assignee
State Grid Corp of China SGCC
State Grid Hebei Electric Power Co Ltd
Baoding Power Supply Co of State Grid Hebei 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 State Grid Corp of China SGCC, State Grid Hebei Electric Power Co Ltd, Baoding Power Supply Co of State Grid Hebei Electric Power Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN201811472316.5A priority Critical patent/CN109656909A/en
Publication of CN109656909A publication Critical patent/CN109656909A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06Energy or water supply
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/20Administration of product repair or maintenance

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Health & Medical Sciences (AREA)
  • Theoretical Computer Science (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Physics & Mathematics (AREA)
  • Marketing (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Public Health (AREA)
  • Water Supply & Treatment (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a kind of transmission of electricity expert data management systems, using Distributed Design system, database technology and cloud computing the relevant technologies, have very strong scalability, can adapt to system future mass data storage extension demand and the demand to existing system integration.System uses structuring, modular design concept, can need to modify some module according to business, increase new function or recombination system structure, to achieve the purpose that program is reusable;System can complete the modification maintenance of storage file and table within a very short time, ensure that the scalability of system;It realizes to the efficient analysis and utilization of professional big data of transmitting electricity, pushes the information system management mode of transmission line of electricity big data to continue to develop, while being capable of forming effective analysis result and complementary decision scheme, and then greatly improve the professional operation level of transmission of electricity.

Description

A kind of transmission of electricity expert data management system
Technical field
The present invention relates to a kind of data management system, in particular to a kind of transmission of electricity expert data management system.
Background technique
Transmission line of electricity is the important component of electric system, has the characteristics that wire length, point are more, wide, every year because of power grid The various aspects factors such as construction, municipal works transformation, special administration, the maintenance test of daily O&M, generate a large amount of expert data, base Layer O&M unit needs regular typing, perfect, modification, retrieval, arranges.Because of peopleware, it is pressed for time, the task reasons such as again, warp It often will cause the non-typing of data, inaccuracy, lack of standardization, disunity;It is right because all kinds of special activities carried out every year are different for point Data field requirement is also different, and data statistic analysis heavy workload there is also repetitive operation amount, front and back sometimes Mathematical logic not system;There is presently no be sophisticated to (power production management for part expert data field System, PMS) engineering production management system, as " lean " management deepens constantly, within the quite a long period, data pipe Managing systematization, there is also " short slabs ";Data control generally in the work of respectively acting on one's own of administration, each teams and groups' computer, be not able to achieve it is shared, It is unfavorable for personnel optimization, plan integration.
During its specialized management, daily need obtains route and its not by being analyzed mass data, compared The health status seen, but the data, data and the analysis that are collected into as a result, often all do not summarized well, accumulate with And analysis, so that data and data profound level extend, the utilization rate used and utility value are had a greatly reduced quality, and are unfavorable for line facility The comprehensive analysis of management cannot but form advanced pre-control, therefore data, the product of data so that management work function manages status Tired and analysis, it should be taken seriously, provide foundation and guarantee for the advanced pre-control of transmission line equipment management and long-term stability.
Summary of the invention
In view of the above problems, the present invention provides a kind of transmission of electricity expert data management system, can make expert data reality of transmitting electricity Existing " big data " management, has the characteristics that generalization, systematization, specialization, data sharing, improves establishment units data management work Efficiency promotes professional lean management level of transmitting electricity.
The embodiment of the present invention provides a kind of transmission of electricity expert data management system, comprising:
Data Layer, for storing transmission of electricity profession basis data, business datum, file data and historical data;And receive application Data in data Layer are sent to application layer by application support platform by the order for the called data that support platform is sent;
Application support platform is the interface that data Layer is connect with application layer data, receives the number of all pairs of data Layers of application layer According to request, and read the data in data Layer in each database;The application support platform also provides authentication, bursting tube Reason and interface and report management;
Application layer, for being interacted by gate system with user, Xiang Suoshu application support platform sends request command and obtains data Layer data, and expert data management, query and statistical analysis are carried out, and provide ancillary service;
Portal platform logs in the portal platform for user, receives the data command for the calling application layer that service layer issues, leads to Cross verifying user name and password, the function and the corresponding function privilege of distribution and data permission of Lai Shixian application layer;
Service layer, the data for sending command calls application layer are supplied to relative users;The relative users include: special worker Member, specific responsibility personnel, work area leader and system manager.
Further, the data Layer, comprising:
Basic database, for storing personnel's attribute and daily record data;At least one unique major key of each of them data with Business datum is associated;
Service database, for storing the dirty data of track data, shaft tower data and anti-sudden strain of a muscle;Business datum include it is multiple respectively with base The associated foreign key field of plinth data, file data and historical data, establish basic data, file data and historical data with The logical relation of business datum;
Document data bank, for storing picture file, archive file;At least one unique major key of each of them data and industry Business data are associated;
Historical data base, for storing history item data, history log data;At least one is unique for each of them data Major key is associated with business datum.
Further, the application layer, comprising:
Data administration subsystem sends maintenance request by the portal platform for user, realizes the acquisition and maintenance of data;
Statistical query subsystem sends inquiry request by the portal platform for user, right according to the corresponding permission of user The business datum being related to carries out comprehensive inquiry;
Assistant subsystem sends management request by the portal platform for administrator, realizes to user, role, permission, day The management of will and backup.
Further, the data administration subsystem, comprising:
Account management module, for the statistics and management total to transmission line of electricity;
Work log module, for transmitting electricity, special worker person fills in work log, records daily real work amount in time;
Antifouling work management module, the management for controlling antifouling work in transmission line of electricity and shaft tower;
Sign Board management module, for realizing the increase, deletion, modification of nameplate data;
Rebuilding management module, the equipment rebuilding for being related to transmission of electricity expert data keep a record;
Defect management module changes for the additions and deletions to defect class data and looks into;
Screen of trees management module, for being recorded to screen of trees account;
Three separated management modules, including screen of trees management, the architecture against regulations and construction data violating the regulations realize data dynamic management;
It hands over across control management module, record and be modified data mode across data for the friendship to discovery;
Three across management module, for handing over the friendship across railway, highway in control management module across management to described;
Fault management module makes a report on for the special worker person that transmits electricity and fills in fault management information;
Data and emergency first-aid repair management module are dispatched, is acquired for the data to scheduling class business.
Further, the statistical query subsystem, comprising:
Three-dimensional enquiry module for breaking rules and regulations comprehensive querying to route, including to hidden danger route processing result, statistics and is realized more Condition Flexible Query statistics;
Defect information module, for inquiring body defects aggregation of data;
It hands over across enquiry module, hands over trans-sectoral business aggregation of data inquiry for providing;
Overhaul technological transformation enquiry module, for carrying out self-defined inquiry according to the field of selection to overhaul technological transformation class data;
Sign Board enquiry module summarizes for the inquiry to Sign Board account data;
Work log enquiry module, for carrying out self-defined inquiry according to the field of selection to work log class data;
Antifouling work enquiry module, for carrying out self-defined inquiry according to the field of selection to antifouling work class data;
Three separated statistical analysis modules, for being counted to violation data;According to hidden danger grade, hidden danger type, period, voltage Grade, possession unit are combined condition and are counted;
Fault statistics module, for being counted to breaking management data;Select hidden danger grade, hidden danger type, discovery time section, Voltage class, possession unit, whether defect elimination is combined condition statistics.
Further, the assistant subsystem, comprising:
User registration module, for obtaining name, login account, password, unit department, role, post, the phone information of user Complete registration;
User information maintenance module for new user's creation, Edit Profile, modification user role, deletes user's operation;
Authority management module, for carrying out operating right distribution to role;And creation new role, editor's role permission and deletion angle Color;
Special work Profiling module for the initialization to special worker person, and increases special wage material, deletes, modification, inquiry;
Module is checked in log, checks log for the system manager, and is recorded depending on the user's operation to analyze user Behavior;The system manager includes administrator or Security Officer;
Report management module, for be related to report be managed, for different operation authority user upload and/downloading report It accuses;
Paperwork management module is downloaded for providing template to document involved in hidden danger management for relative users;
Line parameter circuit value information management module, for safeguarding all transmission line of electricity data, provide the addition of track data, editor, Deletion and route unit configuration feature, and it is defeated for being carried out by line name, voltage, asset units, assets class condition The lookup of electric wire circuit-switched data.
The beneficial effect of above-mentioned technical proposal provided in an embodiment of the present invention includes at least:
Above-mentioned a kind of transmission of electricity expert data management system provided in an embodiment of the present invention, using Distributed Design system, database Technology and cloud computing the relevant technologies, have very strong scalability, can adapt to system future mass data storage extension demand With the demand integrated to existing system.System uses structuring, modular design concept, can be needed to modify some according to business Module increases new function or recombination system structure, to achieve the purpose that program is reusable;Modification of the system to storage file and table Maintenance can be completed within a very short time, ensure that the scalability of system;Realize the efficient analysis and benefit to professional big data of transmitting electricity With pushing the information system management mode of transmission line of electricity big data to continue to develop, while being capable of forming effective analysis result and auxiliary Helping property decision scheme, and then greatly improve the professional operation level of transmission of electricity.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification It obtains it is clear that understand through the implementation of the invention.The objectives and other advantages of the invention can be by written explanation Specifically noted structure is achieved and obtained in book, claims and attached drawing.
Below by drawings and examples, technical scheme of the present invention will be described in further detail.
Detailed description of the invention
Attached drawing is used to provide further understanding of the present invention, and constitutes part of specification, with reality of the invention It applies example to be used to explain the present invention together, not be construed as limiting the invention.In the accompanying drawings:
Fig. 1 is transmission of electricity expert data schematic diagram of management system structure provided in an embodiment of the present invention;
Fig. 2 is the network topological diagram of transmission of electricity expert data management system provided in an embodiment of the present invention.
Specific embodiment
Exemplary embodiments of the present disclosure are described in more detail below with reference to accompanying drawings.Although showing the disclosure in attached drawing Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure It is fully disclosed to those skilled in the art.
Transmission of electricity expert data management system provided in an embodiment of the present invention, it is shown referring to Fig.1 comprising:
Data Layer, for storing transmission of electricity profession basis data, business datum, file data and historical data;And receive application Data in data Layer are sent to application layer by application support platform by the order for the called data that support platform is sent;
Application support platform is the interface that data Layer is connect with application layer data, receives the number of all pairs of data Layers of application layer According to request, and read the data in data Layer in each database;The application support platform also provides authentication, bursting tube Reason and interface and report management;
Application layer, for being interacted by gate system with user, Xiang Suoshu application support platform sends request command and obtains data Layer data, and expert data management, query and statistical analysis are carried out, and provide ancillary service;
Portal platform logs in the portal platform for user, receives the data command for the calling application layer that service layer issues, leads to Cross verifying user name and password, the function and the corresponding function privilege of distribution and data permission of Lai Shixian application layer;
Service layer, the data for sending command calls application layer are supplied to relative users;The relative users include: special worker Member, specific responsibility personnel, work area leader and system manager.
The present invention is to reinforce transmission of electricity expert data management, by building this transmission of electricity expert data management system, is realized to defeated The complete control of the relevant Various types of data of electricity.Mainly based on transmission line of electricity, other relevant class electric power of complete paired transmission line Data acquisition and maintenance carry out timely investigation processing to all kinds of transmission of electricity expert datas, can also realize controls in advance, make power transmission facility The conservative management course of work is in slave mode always, it is ensured that the safe and reliable operation of power transmission facility.Referring to net shown in Fig. 2 Network topological relation, this system application Kafka Distributed Message Queue, distributed task scheduling calculates and Redis memory database:
Wherein:
Kafka Distributed Message Queue
Kafka is a kind of Distributed Message Queue system of high-throughput, may be used as load balancing, in processing system All view flow datas.These data are often as the requirement of handling capacity and are solved by processing log and log aggregation. The purpose of Kafka is to unify Message Processing on line and offline by loaded in parallel mechanism.There is following characteristic:
Stability: providing the persistence of message by the disk data structure of O (1), even if this structure is for number disappearing with TB Breath storage is also able to maintain prolonged stability.
High-throughput: even very common hardware kafka can also support hundreds of thousands of message per second.System choosing The structuring of headend equipment and unstructured data are received with kafka technology.
Distributed task scheduling calculates
DTC is a distributed, expansible, fault-tolerant real time computation system.System is absorbed in solution with the technology The scheduling and management of multitask.The tasks such as download pictures can be handled simultaneously, picture recognition, is put in storage, deploys to ensure effective monitoring and control of illegal activities, subscribing to.Distribution meter A kind of calculation method at last, it, which studies the problem of how needing very huge computing capability just to can solve one, is divided into many Then these parts are distributed to multi-node parallel processing, finally these calculated results are integrated to obtain most by small part It is whole as a result, and centralization to calculate be opposite.According to service logic, big data is studied and judged using the very huge calculating energy of needs Power could be completed, if calculated using centralization, time-consuming can be longer.And distributed computing by the application decomposition at many small portions Point, distribute to multiple servers processing.The overall calculation time can be saved in this way, greatly improve computational efficiency.
Redis memory database
Redis is an open source, write based on C language, can persistence, the KeyValue class of multilingual API is provided The memory database of type.Redis has the ability of high-performance concurrent reading and writing.The maximum characteristic of Redis is to support to save List The data structure of chained list and Set set, but also support to carry out various operations to List.It can only be protected with Memcached The data for depositing 1MB are compared, and the maximum limitation of the single memory block of Redis is 1GB.In addition Redis can also be to deposit Expiration time is arranged in Key-Value, therefore can also be taken as the Memcached of a function strengthening version to use.
Transmission of electricity expert data management system provided in this embodiment, using Distributed Design system, database technology and Cloud computing the relevant technologies have very strong scalability, can adapt to system future mass data storage extension demand and to existing The demand of system combination.System uses structuring, modular design concept, can need to modify some module according to business, increase Add new function or recombination system structure, to achieve the purpose that program is reusable;System can to the modification maintenance of storage file and table It completes within a very short time, ensure that the scalability of system;It realizes to the efficient analysis and utilization of professional big data of transmitting electricity, pushes The information system management mode of transmission line of electricity big data continues to develop, while being capable of forming effective analysis result and complementary decision Scheme, and then greatly improve the professional operation level of transmission of electricity.
Further, as shown in Figs. 1-2, data Layer, comprising:
Basic database, for storing personnel's attribute and daily record data;At least one unique major key of each of them data with Business datum is associated;
Service database, for storing the dirty data of track data, shaft tower data and anti-sudden strain of a muscle;Business datum include it is multiple respectively with base The associated foreign key field of plinth data, file data and historical data, establish basic data, file data and historical data with The logical relation of business datum;
Document data bank, for storing picture file, archive file;At least one unique major key of each of them data and industry Business data are associated;
Historical data base, for storing history item data, history log data;At least one is unique for each of them data Major key is associated with business datum.
Wherein: application layer, comprising:
Data administration subsystem sends maintenance request by the portal platform for user, realizes the acquisition and maintenance of data;
Statistical query subsystem sends inquiry request by the portal platform for user, right according to the corresponding permission of user The business datum being related to carries out comprehensive inquiry;
Assistant subsystem sends management request by the portal platform for administrator, realizes to user, role, permission, day The management of will and backup.
The subsystem of application layer is described in detail separately below.
1. data administration subsystem
Expert data management function of transmitting electricity is this system core business function, and main includes including work log, three across management, anti- Pollution flashover data, mark control, accident analysis, friendship across control, rebuilding management, defect management, three separated controls, screen of trees, account data, The information collection and maintenance of data and the big module of emergency first-aid repair 12 are dispatched, the increase of 12 business functions is mainly realized, deletes, repairs Change and reports and submits.
Account management:
Account management is this system foundation, other all business are carried out around account management (transmission line of electricity), account The specific field of management includes administration teams and groups, line name, voltage, start-stop place, start-stop switch number, start-stop bar number, length (km), the left line of wire type, bar number, length, right line, electric pole, steel tower, steel pole, total, electric pole, steel tower, steel pole, total, total base Number, straight line insulation configuration, strain insulator insulation configuration, and stringing road, T link, date of putting into operation, caecum route, affiliated county, double back, Landform, equipment separation, tour vacuum phase.
Account management is the statistics and management total to transmission line of electricity, and account management is the premise that this system other function is carried out Condition.
Work log:
Special work of transmitting electricity can fill in work log by the function, specifically include teams and groups, date, classification of the items, line name, Whether plan target recruitment quantity, work responsible person, is plan, performance, tour record, tour milimeter number, maintenance note Record, maintenance radix, detection record, detection radix, work ticket achieve, operation text achieve, do not complete content, do not complete reason, Control measure, implementation date, same day weather, vehicle, same day weather, vehicle drivers, car telephone, remarks are not completed.Each special work, Each teams and groups record daily real work amount daily by the typing to these fields in time.
Antifouling work management:
Antifouling work management is the management controlled antifouling work in transmission line of electricity and shaft tower, is fallen by the acquisition to antifouling work information It is real it is counter arrange, be obstructed because of safety at power cut, into ground, safety factor, weather influence etc. it is not practicable set up accounts, convenient for combining other works in the future The problems such as work continues to implement, avoids " missing ", " not implementing " occurs, and realizes process management of writing off of setting up accounts.Antifouling work manages word Section includes: serial number, RTV type, line name, voltage class, operation shaft tower, radix, the piece number, this brushing date, color, matter Examine teams and groups, coating quality, spray unit, clearing situation, control period, spraying date, remarks next time.
Sign Board management:
The most basic source of basic data for profession of transmitting electricity, system can to " do not meet state's net require, arrival do not install, with it is real Border is not inconsistent " etc. fields it is clear one by one, convenient for establishment installation production plan, form normalization management, Sign Board management is main to be realized Increase, deletion, modification of nameplate data etc., specific field includes administration teams and groups, line name, voltage, the total radix of steel tower, total Whether radix is whether state's net Sign Board, scene install, situation is retained in library, retain radix, installed date, mounting rod in library Tower installation radix, installation teams and groups, leftover problem, needs to make bar number, needs to make that radix, this route tower statistics, correlation wants It asks, producer, arrival date, issue production requirement, fund state.
Rebuilding management:
Rebuilding management is that the equipment rebuilding being related to transmission of electricity expert data keeps a record, including career field, profession are segmented, voltage Grade, project name, the contents of a project, project verification are according to (including status, concrete reason), device class (see specification), quantity, list Position, item types, the project time started, project's finish time, significance level, belonging to project, it is assets class, overhaul purpose, big Repair reason, entry property, sundry item property, overhaul emphasis (see specification), overhaul effect, project status, deposit project level, Whether rural power grids, total cost (Wan Yuan), remarks.
Defect management:
Defect management is to change to look into the additions and deletions of defect class data.It is the basis of increase line road operation level, which can be according to " defect property, eliminates progress, line name at happening part " realization " longitudinally, laterally, comprehensive " statistics, is quickly all kinds of meters It draws and data support is provided, be more advantageous to plan integration.The field that defect need to record are as follows: plan arranges, whether plan is completed, disappeared It removes, number, find teams and groups, line name, voltage class, defect property, classification, classification, defect content, whether have a power failure, find People, discovery the date, whether capital construction leave, defect elimination responsible person, defect elimination teams and groups, defect elimination date, defect elimination result, date of inspection and receipt, examination Personnel, check and acceptance result, this defect whether typing PMS system, whether be included in overhaul, it is counter arrange, anti-classification, remarks, the card stream of arranging Turn the 1(date), reception staff 1, card circulation the 2(date), reception staff 2.
Screen of trees management:
Screen of trees management be screen of trees account is recorded, including teams and groups, line name, voltage class (kv), shaft tower number, tree species, Number, diameter (cm) hang down away from (m), horizontal (m), affiliated county (city), affiliated township, affiliated village, specific associated process, screen of trees processing Situation eliminates the date, eliminates personnel, eliminates result, formality upload, remarks.
Three disobey management:
Three, which disobey management, includes screen of trees management, the architecture against regulations, breaks rules and regulations to construct, and three disobey it in the weight that management is increase line road operation level Weight, the system define three separated types, eliminate state, each associated process, administer the specific fields such as result, and it is dynamic to realize data State management is able to reflect out difficult point, the emphasis of the improvement of every route, provides valid data to work out plan, three, which disobey management, adopts Collecting field includes key, document code, line name, voltage class, classification, three separated classifications, hidden danger description, discovery date, institute Belong to county/city, date received, write comments and sign one's name, forwarding personnel, forwarding the date, whether taken measures, safety inform book whether under Reach, safety inform book upload, warning sign whether install, warning sign photo upload, whether effectively, whether eliminate, eliminate the date, test Receipts personnel, date of inspection and receipt, remarks.
It hands over and is managed across control:
Hand over across control be record of the friendship to discovery across data, data mode can be modified, hand over across field include serial number, Year, month, it is whether crucial, the discovery date, discovery personnel, voltage class, line name, scissors crossing bar number, be spanned object Situation, conducting wire over the ground, crossed crossing distance, to small size distance, to large size distance, measurement temperature (DEG C), hand over across point away from shaft tower most Small horizontal distance, be spanned object vertical range, be spanned object, be spanned the affiliated county of object (city), be spanned the affiliated township of object, by across More the affiliated village of object, be spanned object affiliated unit, by across power circuit title, numbered across power circuit, treatment people, processing day Phase, processing result.
Three across management:
Three across being to hand over the friendship of span centre typical railway, highway across management, and specific field includes serial number, affiliated company, county, route name Title, voltage class (kilovolt), total track length, route run the time limit (year), line loop (returning), highway names, Gao Sujian If state, line construction timing, two sides anchor support pattern and exhale title it is high, across tower and exhale title it is high, across high speed two sides shaft tower Tower number, two sides crossover tower coordinate (longitude and latitude), small size shaft tower are away from starting point distance (kM), large size shaft tower from home apart from (kM), institute Locate geographical location, across resistance to section of form, across the position mark of high speed, crossover tower away from high speed base horizontal distance, perpendicular across Distance (80 degree), the angle of the crossing, across strain insulator segment length (kilometer), grounded-line wire clamp model, whether using pre-twisted line hardware, grounded-line Whether damper model uses pre-twisted line hardware, steel tower which kind of strengthening measure, grounded-line is taken to have non junction, whether for independently Whether double hanging point two sides insulator chain type, insulator model, the insulator linked network time limit, type of foundation, is located at river or geology Disaster region, whether install on-Line Monitor Device, whether meet three across countermeasure, whether install on-Line Monitor Device, whether It is three across countermeasure, inspection personnel, check data, inspection result.
Fault management:
The special worker person that transmits electricity, which makes a report on, fills in fault management information (electric power theft, external force are destroyed).Complete electric power is gradually formed to set Apply the archive information destroyed by external force.Fault management field includes serial number, time, month, date, time, weather, voltage etc. Grade, line name, technical reason 1, technical reason 2, liability cause 1, liability cause 2, faulty equipment, phase sequence, coincidence, region, Failure overview, obstacle property, whether possession responsibility, troubleshooting, affiliated teams and groups, remarks.
Dispatch data and emergency first-aid repair management:
Scheduling data and emergency first-aid repair management function are the data acquisitions to scheduling class business, and acquisition field includes serial number, route Title, voltage class (kV), action, work unit, work responsible person, planned time, ratify the time, mention the ticket time, Approval draft bank permitted hours, dispatch person on duty, time of ordering, connect enable work responsible person, friendship enable the time, Dispatchers on duty whether be Emergency, unplanned examination & approval single upload, remarks.
2. query statistic subsystem
Query and statistical analysis is to carry out comprehensive inquiry, the department of each county (city) different rights to the business datum being related in system The data of inquiry are different.
Three-dimensional inquiry
System offer breaks rules and regulations comprehensive querying (by route affiliated unit, hidden danger classification, hidden danger grade, discovery time, hair to route Existing personnel), including to hidden danger route processing result etc., statistics, can count by many condition Flexible Query, be opened up with list mode Show, generates report export Excel printout.
Defect information
Body defects query function is inquired body defects aggregation of data, and what is inquired first is a comprehensive inquiry data.It can To inquire the defective data of concrete type according to defect type, the detail of corresponding defective data can be inquired by clicking details.
It hands over across inquiry
System, which provides, hands over trans-sectoral business aggregation of data inquiry (each by route applicant, application time, line name, power supply for construction A approval process and verify as a result, can to power supply for construction application essential information and flow processing step inquiry, statistics, can be by a plurality of Part Flexible Query statistics, is shown with list mode, generates report export Excel printout.
Overhaul technological transformation inquiry
Self-defined inquiry is carried out according to the field of selection to overhaul technological transformation class data, the result of inquiry can export.
Sign Board inquiry
The inquiry of Sign Board account data is summarized.The Sign Board letter that higher level department has permission inquiry, counts (city) company, each county Breath, and self-defined report export Excel is generated, report can be printed out.
Work log inquiry
Self-defined inquiry is carried out according to the field of selection to work log class data, the result of inquiry can export.
Antifouling work inquiry
Self-defined inquiry is carried out according to the field of selection to antifouling work class data, the result of inquiry can export.
Three disobey statistical analysis
Three separated statistics are counted to violation data, can choose hidden danger grade, hidden danger type, period, voltage class, category Ground unit etc. is combined condition and is counted, and statistical result is shown with histogram, and grading according to hidden danger type and hidden danger etc. Row classification.
Statistical framework can be printed, be exported (format PDF/Excel/Word), and statistical information (statistical condition, system Count result description).
Fault statistics
Fault statistics are counted to breaking management data, can choose hidden danger grade, hidden danger type, discovery time section, electricity Pressure grade, possession unit, whether defect elimination etc. is combined condition is counted, and statistical result is shown with histogram, and according to category Classify with hidden danger type on ground.
Statistical framework can be printed, be exported (format PDF/Excel/Word), and statistical information (statistical condition, system Count result description).
3. assistant subsystem
User's registration
Prerequisite using this system is must to be registered as the user of system, can quickly be created by user's registration function New user.In register interface, it is basic to input name, login account, password, unit department, role, post, phone of user etc. Information clicks confirming button and completes registering functional.Note: user role directly determines to user to use the permission of system, different Role possesses different system operatio permissions, if not giving user's assigned role, new user will be unable to log in system.
User information maintenance
All users in user information maintaining-managing system can carry out new user's creation, editor user's letter by user management Breath, deletes user's operation at modification user role, creates new user's operation and is same as above.It can quickly be searched by address name, account To specified user.
Rights management
Role is the basic element in Role-based access control model, and role is the unit and carrier of authority distribution.Role The permission of classification is supported to realize by inheritance.Then we assign user by controlling role's allocation of access rights Role realizes the access privilege control of user.
The permission of role is directed to the resource of system, allocates resources to each role to realize permission control, resource It is the relationship of multi-to-multi between role.Same user's (user group) and role are also the relationship of multi-to-multi.
Rights management is used to carry out operating right distribution to role.New role, editor's role can be created by Role Management Permission, deletion role etc., can quickly position object search by the query function of top.
Special wage material
Initialization to special worker person, and increase, delete, modification, the maintenance inquired.
Log is checked
Log includes including logging in a variety of Log Types such as log, operation log, security log, error log.User is in system When some operations of upper progress, it will record some related contents of lower user's operation, these contents are to system security officer's phase When useful, administrator or Security Officer can be recorded by the operation of user to analyze the behavior of user.Log content has user name Claim, operate IP, action name, operating time and operation description.
Report management
Report management is just managed to being related to report in system, can be uploaded with the user of operating right, same downloading The permission for needing to download.
Report typing field has: report name, reporting unit, on the fields category such as call time, report description, report file Property.
Paperwork management
Paperwork management is to provide template to document involved in hidden danger management, is downloaded for operator.Hidden danger document is current There are illegal notice, safety commitment book, security notice hidden danger book, safety to inform four kinds of documents of book.
Line parameter circuit value information management
All transmission line of electricity data in line parameter circuit value information management maintenance system, provide addition, editor, the deletion of track data With route unit configuration feature, while can also pass through line name, voltage, asset units, assets class condition carry out power transmission line Quick, the accurate lookup of circuit-switched data.
The configuration of route unit is to specify run unit, maintenance unit for transmission line of electricity, start shaft tower and terminate shaft tower information, By the segmented configuration to transmission line of electricity, the different responsible departments of the different zones of route are set.For constituent parts, this is also Data permission foundation when carrying out business incipient fault data, body defects data etc. and making a report on.
Transmission of electricity expert data management system provided in an embodiment of the present invention, the effect that power grid status and technology are developed:
The research and development of transmission of electricity expert data management system and efficient analysis and utilization that application is to professional big data of transmitting electricity.It is several recently Year, the information-based industry development of domestic electrical industry;In the near future, transmission line of electricity big data will be increased with the speed of leap It is long.In consideration of it, current opportunity should be caught, adequately to go into seriously the immense value that big data is contained behind, need to strengthen, data Control, at the same should also collection to data, excavation and analysis pay much attention to, to push transmission line of electricity big data Information system management mode continues to develop, while being capable of forming effective analysis result and complementary decision scheme, and then mention significantly The professional operation level of height transmission of electricity.
The main feature analysis for professional big data of transmitting electricity:
In big data era, transmission line of electricity big data can make the efficiency of the links such as operation, management and analysis obtain Very big promotion.The main feature of transmission line of electricity big data has the following aspects:
A. quantity is larger.This is the important feature of transmission line of electricity big data.As the construction range of transmission line of electricity constantly expands, line The number of devices and importance being related in road constantly enhance and position of the transmission line of electricity in power grid is constantly increased, this is just So that the safe and efficient operation of transmission line of electricity is particularly important, transmission line safety efficiently runs and requires by a large amount of Data analyze to complete, the related data by carefully analyzing transmission line of electricity operation can grasp the operation shape of route in time State.
B. type is more.Type involved in transmission line of electricity big data include line operational data, equipment operating data with And the multiple types such as personnel's business, the classification of transmission line of electricity big data is so careful, can be quasi- in time when something goes wrong in operation True finds reason, and quickly proposes solution, and can provide effectively complementary determine by the analysis to big data Plan scheme carries out prevention work in advance.
Illustrate achievement benefit brought by the present invention below by one embodiment: may include direct benefit and imitates indirectly Benefit:
Direct benefit
By taking certain power supply company administers 778 10127 kilometers of 35-500kV route as an example, wherein management and 17 people of technical staff, fortune Examine 15 156 people of personnel of teams and groups.58.2 kilometers of maintenance line per capita, maximum make an inspection tour 120 kilometers of radius.Daily need is to heavy Data are summarized, are arranged, are analyzed, and 15 technicians, the long-term indwelling work area of 3 administrative staff are caused, and particular time also needs Send support staff to assist, the production works such as operational inspection, repair and maintenance at the scene of cannot being engaged in, personnel's utilization rate significantly under Drop.
Transmit electricity expert data management system research and development and application, can thoroughly " freeing " 15 technicians, 3 administrative staff, According to formula (+3 administrative staff of 15 technicians)/total number of persons 173, personnel's utilization rate can be improved 11%.
Indirect benefit
Transmission line of electricity conveying distance is long, wide coverage, is the core of electric system, and transmission of electricity expert data management system is ground The application of hair and application item strengthens Various types of data specialized management quality, resource-sharing, and data summarization is analyzed, realize " with Data are spoken ", items responsibility is implemented, work in every governance process is embodied, passes through the confluence analysis mistake to transmission of electricity expert data Journey and quickly obtain complementary decision information, be current year profession report and the work plan and operation of power networks in the coming year in Important link makes specific aim anticipation work and gives most strong support effect, and can concentrate on crucial points, difficult point improvement, constantly mentions High grass-roots unit's management level promotes to be promoted professional lean management level of transmitting electricity, has further ensured that power system security can By operation.
Each embodiment in this specification is described in a progressive manner, the highlights of each of the examples are with other The difference of embodiment, the same or similar parts in each embodiment may refer to each other.For device disclosed in embodiment For, since it is corresponded to the methods disclosed in the examples, so being described relatively simple, related place is said referring to method part It is bright.
The foregoing description of the disclosed embodiments enables those skilled in the art to implement or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, as defined herein General Principle can be realized in other embodiments without departing from the spirit or scope of the present invention.Therefore, of the invention It is not intended to be limited to the embodiments shown herein, and is to fit to and the principles and novel features disclosed herein phase one The widest scope of cause.

Claims (6)

1. a kind of transmission of electricity expert data management system characterized by comprising
Data Layer, for storing transmission of electricity profession basis data, business datum, file data and historical data;And receive application Data in data Layer are sent to application layer by application support platform by the order for the called data that support platform is sent;
Application support platform is the interface that data Layer is connect with application layer data, receives the number of all pairs of data Layers of application layer According to request, and read the data in data Layer in each database;The application support platform also provides authentication, bursting tube Reason and interface and report management;
Application layer, for being interacted by gate system with user, Xiang Suoshu application support platform sends request command and obtains data Layer data, and expert data management, query and statistical analysis are carried out, and provide ancillary service;
Portal platform logs in the portal platform for user, receives the data command for the calling application layer that service layer issues, leads to Cross verifying user name and password, the function and the corresponding function privilege of distribution and data permission of Lai Shixian application layer;
Service layer, the data for sending command calls application layer are supplied to relative users;The relative users include: special worker Member, specific responsibility personnel, work area leader and system manager.
2. the system as claimed in claim 1, which is characterized in that the data Layer, comprising:
Basic database, for storing personnel's attribute and daily record data;At least one unique major key of each of them data with Business datum is associated;
Service database, for storing the dirty data of track data, shaft tower data and anti-sudden strain of a muscle;Business datum include it is multiple respectively with base The associated foreign key field of plinth data, file data and historical data, establish basic data, file data and historical data with The logical relation of business datum;
Document data bank, for storing picture file, archive file;At least one unique major key of each of them data and industry Business data are associated;
Historical data base, for storing history item data, history log data;At least one is unique for each of them data Major key is associated with business datum.
3. the system as claimed in claim 1, which is characterized in that the application layer, comprising:
Data administration subsystem sends maintenance request by the portal platform for user, realizes the acquisition and maintenance of data;
Statistical query subsystem sends inquiry request by the portal platform for user, right according to the corresponding permission of user The business datum being related to carries out comprehensive inquiry;
Assistant subsystem sends management request by the portal platform for administrator, realizes to user, role, permission, day The management of will and backup.
4. system as claimed in claim 3, which is characterized in that the data administration subsystem, comprising:
Account management module, for the statistics and management total to transmission line of electricity;
Work log module, for transmitting electricity, special worker person fills in work log, records daily real work amount in time;
Antifouling work management module, the management for controlling antifouling work in transmission line of electricity and shaft tower;
Sign Board management module, for realizing the increase, deletion, modification of nameplate data;
Rebuilding management module, the equipment rebuilding for being related to transmission of electricity expert data keep a record;
Defect management module changes for the additions and deletions to defect class data and looks into;
Screen of trees management module, for being recorded to screen of trees account;
Three separated management modules, including screen of trees management, the architecture against regulations and construction data violating the regulations realize data dynamic management;
It hands over across control management module, record and be modified data mode across data for the friendship to discovery;
Three across management module, for handing over the friendship across railway, highway in control management module across management to described;
Fault management module makes a report on for the special worker person that transmits electricity and fills in fault management information;
Data and emergency first-aid repair management module are dispatched, is acquired for the data to scheduling class business.
5. system as claimed in claim 3, which is characterized in that the statistical query subsystem, comprising:
Three-dimensional enquiry module for breaking rules and regulations comprehensive querying to route, including to hidden danger route processing result, statistics and is realized more Condition Flexible Query statistics;
Defect information module, for inquiring body defects aggregation of data;
It hands over across enquiry module, hands over trans-sectoral business aggregation of data inquiry for providing;
Overhaul technological transformation enquiry module, for carrying out self-defined inquiry according to the field of selection to overhaul technological transformation class data;
Sign Board enquiry module summarizes for the inquiry to Sign Board account data;
Work log enquiry module, for carrying out self-defined inquiry according to the field of selection to work log class data;
Antifouling work enquiry module, for carrying out self-defined inquiry according to the field of selection to antifouling work class data;
Three separated statistical analysis modules, for being counted to violation data;According to hidden danger grade, hidden danger type, period, voltage Grade, possession unit are combined condition and are counted;
Fault statistics module, for being counted to breaking management data;Select hidden danger grade, hidden danger type, discovery time section, Voltage class, possession unit, whether defect elimination is combined condition statistics.
6. system as claimed in claim 3, which is characterized in that the assistant subsystem, comprising:
User registration module, for obtaining name, login account, password, unit department, role, post, the phone information of user Complete registration;
User information maintenance module for new user's creation, Edit Profile, modification user role, deletes user's operation;
Authority management module, for carrying out operating right distribution to role;And creation new role, editor's role permission and deletion angle Color;
Special work Profiling module for the initialization to special worker person, and increases special wage material, deletes, modification, inquiry;
Module is checked in log, checks log for the system manager, and is recorded depending on the user's operation to analyze user Behavior;The system manager includes administrator or Security Officer;
Report management module, for be related to report be managed, for different operation authority user upload and/downloading report It accuses;
Paperwork management module is downloaded for providing template to document involved in hidden danger management for relative users;
Line parameter circuit value information management module, for safeguarding all transmission line of electricity data, provide the addition of track data, editor, Deletion and route unit configuration feature, and it is defeated for being carried out by line name, voltage, asset units, assets class condition The lookup of electric wire circuit-switched data.
CN201811472316.5A 2018-12-04 2018-12-04 A kind of transmission of electricity expert data management system Pending CN109656909A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811472316.5A CN109656909A (en) 2018-12-04 2018-12-04 A kind of transmission of electricity expert data management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811472316.5A CN109656909A (en) 2018-12-04 2018-12-04 A kind of transmission of electricity expert data management system

Publications (1)

Publication Number Publication Date
CN109656909A true CN109656909A (en) 2019-04-19

Family

ID=66112757

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811472316.5A Pending CN109656909A (en) 2018-12-04 2018-12-04 A kind of transmission of electricity expert data management system

Country Status (1)

Country Link
CN (1) CN109656909A (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111432295A (en) * 2020-03-18 2020-07-17 北京科东电力控制系统有限责任公司 Power consumption information acquisition master station system based on distributed technology
CN111861790A (en) * 2020-07-24 2020-10-30 国网安徽省电力有限公司 Electric power full-service data management system
CN112286955A (en) * 2020-10-26 2021-01-29 广东电网有限责任公司 Line information query method and device, electronic equipment and storage medium
CN113326253A (en) * 2020-02-28 2021-08-31 拓尔思天行网安信息技术有限责任公司 Data cleaning method, device, equipment and storage medium based on full-text database

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101908188A (en) * 2009-12-30 2010-12-08 新奥特(北京)视频技术有限公司 Advertisement service management system with automatic check function
WO2010139167A1 (en) * 2009-06-05 2010-12-09 深圳市脑库计算机系统有限公司 Expert support application system platform for government affair and business affair decision-making and its construction method
CN102930396A (en) * 2012-11-02 2013-02-13 复旦大学 Subscriber management system facing to radio and television operators
CN105989443A (en) * 2015-02-15 2016-10-05 杜岸树 Intelligent-mobile-terminal-based communication line inspection system
CN108388625A (en) * 2018-02-12 2018-08-10 安徽千云度信息技术有限公司 A kind of software in project cost management platform based on big data

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2010139167A1 (en) * 2009-06-05 2010-12-09 深圳市脑库计算机系统有限公司 Expert support application system platform for government affair and business affair decision-making and its construction method
CN101908188A (en) * 2009-12-30 2010-12-08 新奥特(北京)视频技术有限公司 Advertisement service management system with automatic check function
CN102930396A (en) * 2012-11-02 2013-02-13 复旦大学 Subscriber management system facing to radio and television operators
CN105989443A (en) * 2015-02-15 2016-10-05 杜岸树 Intelligent-mobile-terminal-based communication line inspection system
CN108388625A (en) * 2018-02-12 2018-08-10 安徽千云度信息技术有限公司 A kind of software in project cost management platform based on big data

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113326253A (en) * 2020-02-28 2021-08-31 拓尔思天行网安信息技术有限责任公司 Data cleaning method, device, equipment and storage medium based on full-text database
CN111432295A (en) * 2020-03-18 2020-07-17 北京科东电力控制系统有限责任公司 Power consumption information acquisition master station system based on distributed technology
CN111861790A (en) * 2020-07-24 2020-10-30 国网安徽省电力有限公司 Electric power full-service data management system
CN112286955A (en) * 2020-10-26 2021-01-29 广东电网有限责任公司 Line information query method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
CN112102111B (en) Intelligent processing system for power plant data
CN109656909A (en) A kind of transmission of electricity expert data management system
CN105407159B (en) Logistics transportation position service system
CN105554059B (en) Logistics transportation Intellisense and position service system based on Beidou navigation technology
CN109376210A (en) A kind of intelligence pollution sources dynamic management system and method
CN110276530A (en) A kind of intelligent engineering operation and maintenance supervising method
CN107341595A (en) A kind of vehicle multidate information public service platform
CN104376430A (en) Hidden risk management system based on cloud service platform and implementing method of hidden risk management system
CN102367742B (en) Monitoring system
CN106383205A (en) VOCs (Volatile Organic Compounds) region on-line monitoring and early warning system
WO2012055295A1 (en) Battery charge/swap monitoring system and method based on internet of things
CN104376494B (en) traffic information management and service system based on cloud system
CN107968482A (en) A kind of generation of electricity by new energy station management platform
CN108964269A (en) Power distribution network O&M and total management system
CN103714434A (en) Chemical industry production site patrol system based on internet of things technology
CN106022617A (en) Inspection control system based on marketing multi-system data center
CN107609987A (en) A kind of intelligent power transformation operational system of equipment oriented owner
CN107066500A (en) A kind of electrical network mass data quality indicator method based on PMS models
CN109739912A (en) Data analysing method and system
CN112883001A (en) Data processing method, device and medium based on marketing and distribution through data visualization platform
CN106646110A (en) Low-voltage distribution network fault positioning system based on GIS and Petri technologies
CN103295164A (en) Power grid safety monitoring management information system and management method
CN104778562B (en) A kind of safe eye supervising platform system in job site
CN110245163A (en) A kind of Operation of Electric Systems hidden troubles removing method
CN117112702A (en) Service rapid processing system for long and large bridge tunneling scene

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: 20190419

RJ01 Rejection of invention patent application after publication