CN108022042B - Method for realizing rapid calculation of provincial power grid examination compensation based on memory database Redis - Google Patents
Method for realizing rapid calculation of provincial power grid examination compensation based on memory database Redis Download PDFInfo
- Publication number
- CN108022042B CN108022042B CN201711233895.3A CN201711233895A CN108022042B CN 108022042 B CN108022042 B CN 108022042B CN 201711233895 A CN201711233895 A CN 201711233895A CN 108022042 B CN108022042 B CN 108022042B
- Authority
- CN
- China
- Prior art keywords
- unit
- data
- assessment
- calculation
- compensation
- 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.)
- Active
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 60
- 238000000034 method Methods 0.000 title claims abstract description 31
- 230000008569 process Effects 0.000 claims abstract description 12
- 238000004573 interface analysis Methods 0.000 claims abstract description 6
- 238000011156 evaluation Methods 0.000 claims description 16
- 230000009471 action Effects 0.000 claims description 13
- 230000002159 abnormal effect Effects 0.000 claims description 6
- 238000004458 analytical method Methods 0.000 claims description 6
- 238000012797 qualification Methods 0.000 claims description 5
- 239000000284 extract Substances 0.000 claims description 4
- 238000012986 modification Methods 0.000 claims description 4
- 230000004048 modification Effects 0.000 claims description 4
- 230000000737 periodic effect Effects 0.000 claims description 4
- 230000003993 interaction Effects 0.000 claims description 3
- 230000007246 mechanism Effects 0.000 claims description 3
- 238000010248 power generation Methods 0.000 claims description 3
- 238000005070 sampling Methods 0.000 claims description 3
- 230000010354 integration Effects 0.000 description 3
- 238000005259 measurement Methods 0.000 description 3
- 230000001105 regulatory effect Effects 0.000 description 3
- 238000007726 management method Methods 0.000 description 2
- 238000010187 selection method Methods 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 238000007792 addition Methods 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 239000004576 sand Substances 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2471—Distributed queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- Y—GENERAL 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
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS 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
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- General Physics & Mathematics (AREA)
- Development Economics (AREA)
- Health & Medical Sciences (AREA)
- Educational Administration (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Theoretical Computer Science (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Game Theory and Decision Science (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 method for realizing rapid calculation of provincial power grid examination compensation based on a memory database Redis, which comprises the following steps: the big data file is automatically analyzed, the examination compensation electric quantity is calculated according to the examination unit, and the calculation result is displayed; according to the invention, the calculation of daily assessment compensation is realized by using the memory database, and after redundant source data is abandoned, daily assessment electric quantity result data and necessary source data are stored in the Oracle permanent database, so that the pressure of the Oracle data can be reduced by more than 70%. Meanwhile, two statistical dimensions of automatic daily statistics and automatic monthly statistics in Oracle are designed, assessment compensation results are counted in daily and monthly dimensions, the statistical mode adopts an Oracle database storage process mode, the assessment compensation results are automatically called after interface analysis, and assessment compensation cost after manual exemption assessment and compensation are calculated and dispatched and monthly assessment data are collected through calling the assessment compensation results in this mode.
Description
Technical Field
The invention relates to the technical field of provincial power grid examination compensation, in particular to a rapid calculation method for realizing provincial power grid examination compensation based on a memory database Redis.
Background
In 2009, an electric prisoner issues an auxiliary service management rule and a power plant grid-connected management rule (two rules of building a factory), each power grid assessment compensation platform is continuously on line, but as time goes on, a new energy power plant starts to be brought into the assessment compensation calculation range of the two rules, the number and data types of the grid-connected power plants are rapidly increased, a single data file reaches or even exceeds a hundred M level, the assessment compensation calculation pressure is huge, the time consumed by single calculation reaches several hours, and the time consumed by whole-month calculation is more days; the data exchange file style customized based on the power grid specification is in a time longitudinal format, the JAVA platform has limited running space and cannot cache a large amount of data, and sectional operation in hours is adopted during evaluation compensation calculation, so that the cross-section evaluation is too slow, and the two-source data are completely stored, so that the database has more garbage data and excessive resource consumption; when results are displayed, the existing platform uses a browser login mode, effective adaptation cannot be performed along with technology generation, power grid and power plant users increase, and due to the fact that the JVM of the JAVA platform is limited, second-level data cannot be cached, detailed curves cannot be displayed for the users.
Disclosure of Invention
Aiming at the defects in the prior art, the invention aims to solve the technical problem of providing a method for realizing provincial power grid assessment compensation quick calculation based on a memory database Redis, which can buffer a large amount of data, adopts sectional operation in seconds when performing assessment compensation calculation, ensures quick assessment processing on a span, has less database garbage data and low resource consumption, and can show a detailed curve for a user.
In order to solve the technical problems, the technical scheme adopted by the invention is as follows: a quick calculation method for realizing provincial power grid assessment compensation based on a memory database Redis is characterized by comprising the following steps: the big data file is automatically analyzed, the examination compensation electric quantity is calculated according to the examination unit, and the calculation result is displayed;
(I) automatic parsing of big data files
(1) Setting up a memory database Redis in the application server, and calling the Redis database by an interface program through a driver library;
(2) acquiring required data according to three exchange file formats of fixed period, unfixed period and no period established by the power grid data exchange specification;
(3) when the interface reads the file, the device ID and the data type are used as keys, the data are used as values, and the acquired data are stored in a Redis memory database according to the time sequence;
(4) adopting JAVA to compile an interface program, adopting a timing search mechanism, automatically searching an appointed directory every 30 seconds, starting a corresponding thread to analyze according to the name of a data file in the directory, and destroying the thread after the analysis is finished;
(II) calculating examination compensation electric quantity according to examination unit
After the interface analysis data file is read, an analysis thread is automatically started, the assessment unit which circularly participates in assessment compensation extracts all source data of the unit on the same day from a memory database, the daily assessment electric quantity is calculated according to a 'two rules' algorithm, and the daily assessment electric quantity result data of the assessment unit can be output to other systems according to requirements, so that the daily assessment electric quantity calculation is realized;
(III) displaying the calculation result
And performing data interaction by adopting the inner core of the browser, displaying a statistical result in a client mode, supporting source data and process quantity of open data calculation, displaying the source data in a curve form when a user selects to view a detailed calculation process of a certain assessment unit, and providing the process quantity in calculation to display a detailed calculation step for the user.
In the above method for implementing provincial power grid assessment compensation fast calculation based on the memory database Redis, the format of the exchange file formulated by the power grid data exchange specification is a period fixed form, and the exchange graph includes:
line 1: time, unit 1, unit 2, …, unit k
Line 2: hh24: mi: ss, unit 1, unit 2, …, unit k
……
Line n + 1: hh24: mi: ss, unit 1, unit 2, …, unit k
Such section includes active file, idle file, frequency file, and the cycle is fixed, and the time increases progressively, and vertical format is abandoned abnormal data automatically during analytic such file to according to the automatic record of filling of sampling period.
In the above method for implementing a rapid calculation of provincial power grid assessment compensation based on a memory database Redis, the exchange file format formulated by the power grid data exchange specification is a periodic fixed form, which exchange profile includes:
line 1: "time", "power plant name", "unit name", "data type 1", "data type 2", etc.
Line 2: hh24: mi: ss, power plant, unit, value.
......
Line n + 1: hh24: mi: ss, power plant, unit, value.
The file comprises a PLC instruction record, a power generation plan modification record, an unfixed period, time increment and a longitudinal format, and abnormal data is automatically discarded when the file is analyzed.
In the above method for implementing provincial power grid assessment compensation fast calculation based on the memory database Redis, the format of the exchange file formulated by the power grid data exchange specification is a period fixed form, and the exchange graph includes:
line 1: "name of power plant", "name of unit", "start time", and "end time"
Line 2: factory name, unit name, start time, end time
……
Line n + 1: name of power plant, name of unit, start time, end time
The file comprises unit start-stop peak regulation records, no period, disordered time and small data magnitude, and when the file is analyzed, the file is directly stored.
The method for realizing the provincial power grid examination compensation rapid calculation based on the memory database Redis comprises the steps of calculating the examination compensation electric quantity according to the examination unit, wherein the steps comprise calculation of primary frequency modulation evaluation records and calculation of AGC (automatic gain control) regulation rate.
The calculation method of the primary frequency modulation evaluation record is that all frequency values are extracted from the memory database, the out-of-limit time is judged, the primary frequency modulation evaluation record is automatically generated, and the integral electric quantity Q of the primary frequency modulation action of the unit is obtainedrReach the theoretical action integral electric quantity QtAnd the action is judged to be qualified in 50 percent of the total weight.
In the method for realizing provincial power grid examination compensation fast calculation based on the memory database Redis, the AGC regulation rate is calculated as the regulation rate omegakiAnd calculating the qualification rate, taking a PLC k and an assessment period i of a power plant as examples, 1% of thermal power generating units, and if an AGC instruction is more than 30MW for the units controlled by the whole plant, SkiThe capacity sum of the starting units of the whole plant is obtained; if the AGC command is less than 30 MW; s. thekiThe maximum single unit capacity in the whole plant startup unit.
The method for realizing the rapid calculation of the provincial power grid examination compensation based on the memory database Redis has the advantages that: according to the invention, the calculation of daily assessment compensation is realized by using the memory database, and after redundant source data is abandoned, daily assessment electric quantity result data and necessary source data are stored in the Oracle permanent database, so that the pressure of the Oracle data can be reduced by more than 70%. The invention simultaneously designs two statistical dimensions of automatic daily statistics and automatic monthly statistics in Oracle, and evaluates and compensates results according to the two dimensions of daily and monthly statistics, wherein the statistical mode adopts an Oracle database storage process mode, and the evaluation and compensation costs after artificial exemption evaluation and compensation are calculated and dispatched and monthly evaluation data are summarized by automatically dispatching after interface analysis.
Drawings
Fig. 1 is a schematic diagram of an integration start/end time selection method.
Detailed Description
The present invention will be described in further detail with reference to the following embodiments and the accompanying drawings.
A method for realizing provincial power grid assessment compensation rapid calculation based on a memory database Redis comprises the following steps: the big data file is automatically analyzed, the examination compensation electric quantity is calculated according to the examination unit, and the calculation result is displayed.
1. Big data file auto parsing
The method adopts JAVA to compile an interface program, adopts a timing search mechanism, automatically searches the appointed directory every 30 seconds, starts a corresponding thread to analyze according to the name of a data file in the directory, and destroys the thread after the analysis is finished.
The method includes the steps that a memory database Redis is built in an application server, and an interface program calls the Redis database through a driving library; when the interface reads the file, the device ID and the data type are used as keys, the data are used as values, and the data are stored into a Redis memory database according to the time sequence.
The profile format formulated according to the grid data exchange specifications mainly has three types:
the first type: line 1: time, unit 1, unit 2, …, unit k
Line 2: hh24: mi: ss, unit 1, unit 2, …, unit k
……
Line n + 1: hh24: mi: ss, unit 1, unit 2, …, unit k
Such files, period fixed, time incremented, vertical format, for example: active, reactive files, frequency files, etc.; the method of the invention automatically discards abnormal data when analyzing the file, and automatically fills missing records according to sampling period.
The second type: line 1: "time", "power plant name", "unit name", "data type 1", "data type 2", etc.
Line 2: hh24: mi: ss, power plant, unit, value.
......
Line n + 1: hh24: mi: ss, power plant, unit, value.
Such files, with fixed periods, time increments, vertical formats, such as: PLC instruction recording, power generation plan modification
Records, and the like; the method of the invention automatically discards abnormal data when analyzing such files.
In the third category: line 1: "name of power plant", "name of unit", "start time", and "end time"
Line 2: name of power plant, name of unit, start time, end time
……
Line n + 1: name of power plant, name of unit, start time, end time
Such files, no cycles, out of order in time, have small data magnitudes, such as: the peak regulation records of the start and stop of the unit and the like; when such profile is parsed by the method of the present invention, it is directly warehoused.
2. Calculating the examination compensation electric quantity according to the examination unit
The method automatically starts an analysis thread after the interface analysis data file is read, circularly participates in the examination and compensation examination unit, extracts all source data of the unit on the same day from a memory database, calculates the daily examination electric quantity according to a 'two detailed rules' algorithm, and can output the daily examination electric quantity result data of the examination unit to other systems according to requirements, thereby realizing the calculation of the daily examination electric quantity.
Calculation of primary frequency modulation evaluation records
The invention extracts all frequency values from the memory database, judges the out-of-limit time and automatically generates a primary frequency modulation evaluation record. The integral electric quantity Qr of the primary frequency modulation action of the unit reaches 50% of the theoretical action integral electric quantity Qt, and the action is judged to be qualified, and the calculation method comprises the following steps:
wherein, PkFor actual output, the transmission delay of the power plant active data to a dispatching end is considered, and the output data is pushed forward for 2 seconds during calculation;
is an integralStarting output, wherein the integral starting time is the time when the frequency passes through the dead zone, and the integral ending time is the time when the frequency returns to the dead zone (the maximum limit value is 1 minute); f is the system frequency, f0A frequency threshold of a unit primary frequency modulation action dead zone; 5% is the unit rotation speed inequality rate; skThe rated capacity of the unit.
The selection method of the integration starting and ending time comprises the following steps: as shown in fig. 1, the dead zone of the primary frequency modulation action after the frequency passes through is a point, the corresponding time is t3, the maximum value after passing through the check peak threshold is c point, the corresponding time is t0, the frequency resetting point is e point, the corresponding time is t4, the point is deviated from the center of the t0 time and is expanded to two sides for 30 seconds, which is marked as t1 point and t2 point, and the corresponding frequency points are b point and d point respectively, then the check time period algorithm of the primary frequency modulation is as follows:
1. if t4-t3 is less than 60s, the examination starting time is t3, and the examination ending time is t4.
2. t3< t1 and t2< t4, the examination start time is t1, and the examination end time is t 2.
3. t4-t3>60s, t3> t1, t2< t4, wherein the examination starting time is t3, and the examination ending time is t3+60 s.
4. t4-t3>60s, t3< t1 and t2> t4, wherein the examination starting time is t4-60s, and the examination ending time is t4.
The starting power of the active integral is checked to be the power corresponding to the t3 point, and the power of the generator at the starting point is not checked.
If the frequency returns to the dead zone for more than 3 seconds, the assessment is considered to be finished.
Calculation of AGC adjustment rate
Regulating the rate omegakiCalculating the qualification rate (taking a power plant PLC k and an assessment period i as an example) (1% of thermal power generating units), and if the AGC instruction is more than 30MW for the units controlled by the whole plant, SkiThe capacity sum of the starting units of the whole plant is obtained; if the AGC command is less than 30 MW; skiThe capacity of the single machine set is the maximum capacity in the whole plant starting machine set.
Wherein, VkiThe actual regulating speed of the PLC k in the assessment period i is in MW/min, and the calculation method is as follows:
to eliminate calculation errors due to data errors, only the adjustment command threshold P is reachedTiThe instructions of the conditions take part in the speed measurement calculation, Pki0And Pki1Respectively, the current value and the target value of the speed measurement in the examination period i, tiThe time for the output to change to the target value after the instruction is issued. Command threshold PTiThe calculation method is as follows:
PTi＝Ski×R0
wherein S iskiIs the total capacity, R, of the unit operated under the controller (PLC) of the power plant0The method is characterized in that a threshold proportionality constant is examined and is independently set according to the installation condition of each power plant.
The linear region selection algorithm in AGC adjustment is as follows:
determining a scanning start-stop time period:
tt＝ts+Ts+Tf
wherein, ttIs a scanning end point; t is tsTaking an instruction sending time point as a scanning starting point; t issTaking the result of dividing the instruction regulating quantity by the theoretical speed as the theoretical action time; t isfThe delay is searched for additional fixed time (thermal power and hydropower can be distinguished).
Judging whether the adjustment participates in speed measurement:
wherein mu is a participation sign; t is tsAnd t'sRespectively sending instruction time points of the current time and the next time; t isdThe sum of the theoretical action time of the instruction and the fixed delay of the unit.
Determining a linear period start:
t1＝t， P-Ps＝Psd
wherein, t1Is the linear period starting point; p is the current actual output; psActual force is applied for a scanning starting point; psd＝Min[Ski×R1,5MW]Setting threshold, t, for the starting point action1The value of (A) is that the moment when the force reaches the threshold of the starting point is pushed forward for 2 seconds, R1Is a constant of proportionality.
Determining the end of the linear period:
t2＝t， Pt-P＝Ptd
wherein, t2Is the linear time period end point; p is the current actual output; p istExerting force for a target; ptd＝Min[Ski×R2,5MW]Setting threshold R for starting point action2Is a constant of proportionality.
If t cannot be determined1And t2Get t1＝ts,t2＝tt。
If the PLC output simultaneously passes through the dead zone and approaches the target output (for the unit which is adjusted quickly) in the same scanning period (2 seconds), the default unit adjustment rate is the set rate.
Accuracy of adjustment thetakiCalculation of qualification Rate (taking power plant PLC k, assessment period i as an example)
Wherein, Δ PkiIs PLC k real-time active power output P in the period of ikiCurves and their AGC commands
The difference between the curves (AGC continuous planning curve formed by simulating the response time and the registration rate according to the AGC command), i.e. the curve period T divided by the integralkiNo instruction (N)kiLess than or equal to 0) the last calculation result is used:
selection algorithm of curve period: 1) the actual output reaches the regulation dead zone (the set threshold of the distance target value) in the estimated time, and then T is takenc(setting parameters) period as a curve period; 2) and if the estimated time does not reach the regulation dead zone, calculating a difference value between the actual output of the theoretical time point reaching the target value and the AGC instruction target output.
According to the invention, the calculation of daily assessment compensation is realized by using the memory database, and after redundant source data is abandoned, daily assessment electric quantity result data and necessary source data are stored in the Oracle permanent database, so that the pressure of the Oracle data can be reduced by more than 70%.
Screening of source data storage:
Titime data warehousing flag
Wherein, tbegIs the integral starting time, t, of any evaluation record or AGC tachometer recordendIs the integration end time of the same record.
The invention simultaneously designs two statistical dimensions of automatic daily statistics and automatic monthly statistics in Oracle, and evaluates and compensates results according to the two dimensions of daily and monthly statistics, wherein the statistical mode adopts an Oracle database storage process mode, and the evaluation and compensation costs after artificial exemption evaluation and compensation are calculated and dispatched and monthly evaluation data are summarized by automatically dispatching after interface analysis.
3. Display of calculation results
The method adopts the inner core of the browser to carry out data interaction, displays the statistical result in a client mode, supports the source data and the process quantity of open data calculation, displays the source data in a curve form when a user selects to check the detailed calculation process of a certain assessment unit, and provides the process quantity in calculation at the same time to display the detailed calculation steps for the user.
It is to be understood that the above description is not intended to limit the present invention, and the present invention is not limited to the above examples, and those skilled in the art should understand that they can make various changes, modifications, additions and substitutions within the spirit and scope of the present invention.
Claims (1)
1. A quick calculation method for realizing provincial power grid assessment compensation based on a memory database Redis is characterized by comprising the following steps: the big data file is automatically analyzed, the examination compensation electric quantity is calculated according to the examination unit, and the calculation result is displayed;
(I) automatic parsing of big data files
(1) Setting up a memory database Redis in the application server, and calling the Redis database by an interface program through a driver library;
(2) acquiring required data according to three exchange file formats of fixed period, unfixed period and no period established by the power grid data exchange specification;
(3) when the interface reads the file, the device ID and the data type are used as keys, the data are used as values, and the acquired data are stored in a Redis memory database according to the time sequence;
(4) adopting JAVA to compile an interface program, adopting a timing search mechanism, automatically searching an appointed directory every 30 seconds, starting a corresponding thread to analyze according to the name of a data file in the directory, and destroying the thread after the analysis is finished;
(II) calculating the examination compensation electric quantity according to the examination unit
After the interface analysis data file is read, an analysis thread is automatically started, the assessment unit which circularly participates in assessment compensation extracts all source data of the unit on the same day from a memory database, the daily assessment electric quantity is calculated according to a 'two rules' algorithm, and the daily assessment electric quantity result data of the assessment unit is output to other systems according to requirements, so that the daily assessment electric quantity is calculated;
the step of calculating the assessment compensation electric quantity according to the assessment unit comprises the calculation of a primary frequency modulation assessment record and the calculation of an AGC regulation rate; the calculation method of the primary frequency modulation evaluation record is to extract all frequency values from the memory databaseJudging the out-of-limit time, automatically generating a primary frequency modulation evaluation record, and generating the integral electric quantity Q of the primary frequency modulation action of the unitrReach theoretical action integral electric quantity QtJudging the action to be qualified in 50 percent of the total weight; the AGC adjusting rate is calculated as an adjusting rate omegakiAnd (4) calculating the qualification rate, taking a power plant PLC k and an examination period i as an example, calculating the thermal power generating unit by 1%, and if the AGC instruction is more than 30MW for the units controlled by the whole plant, and calculating the qualification rate SkiThe capacity sum of the starting units of the whole plant is obtained; if the AGC command is less than 30 MW; skiThe maximum unit capacity in the whole plant startup unit is obtained;
(III) displaying the calculation result
Adopting the inner core of the browser to carry out data interaction, displaying a statistical result in a client mode, supporting source data and process quantity of open data calculation, displaying the source data in a curve form when a user selects to view a detailed calculation process of a certain assessment unit, and simultaneously providing the process quantity in calculation to display the detailed calculation step for the user;
the format of an exchange file formulated by the power grid data exchange specification is a periodic fixed form, and the exchange file comprises:
line 1: time, unit 1, unit 2, …, unit k
Line 2: hh24: mi: ss, unit 1, unit 2, …, unit k
……
Line n + 1: hh24: mi: ss, unit 1, unit 2, …, unit k
The files comprise active files, reactive files, frequency files, fixed periods, time increment and longitudinal formats, abnormal data are automatically abandoned when the files are analyzed, and missing records are automatically filled according to sampling periods;
the format of an exchange file formulated by the power grid data exchange specification is a periodic fixed form, and the exchange file comprises:
line 1: "time", "power plant name", "unit name", "data type 1", "data type 2", etc.
Line 2: hh24: mi: ss, power plant, unit, value.
......
Line n + 1: hh24: mi: ss, power plant, unit, value.
The file comprises a PLC instruction record, a power generation plan modification record, an unfixed period, time increment and a longitudinal format, and abnormal data is automatically discarded when the file is analyzed;
the format of an exchange file formulated by the power grid data exchange specification is a periodic fixed form, and the exchange file comprises:
line 1: "name of power plant", "name of unit", "start time", and "end time"
Line 2: name of power plant, name of unit, start time, end time
……
Line n + 1: name of power plant, name of unit, start time, end time
The file comprises the peak regulation records of the start and stop of the unit, has no period, disordered time and small data magnitude, and is directly put in storage when the file is analyzed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711233895.3A CN108022042B (en) | 2017-11-30 | 2017-11-30 | Method for realizing rapid calculation of provincial power grid examination compensation based on memory database Redis |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711233895.3A CN108022042B (en) | 2017-11-30 | 2017-11-30 | Method for realizing rapid calculation of provincial power grid examination compensation based on memory database Redis |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108022042A CN108022042A (en) | 2018-05-11 |
| CN108022042B true CN108022042B (en) | 2022-07-08 |
Family
ID=62077806
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711233895.3A Active CN108022042B (en) | 2017-11-30 | 2017-11-30 | Method for realizing rapid calculation of provincial power grid examination compensation based on memory database Redis |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108022042B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241132B (en) * | 2018-08-06 | 2022-05-13 | 宁波三星智能电气有限公司 | Method for retrieving daily time table rate of electric energy meter |
| CN110210909A (en) * | 2019-06-11 | 2019-09-06 | 云南电网有限责任公司 | Settlement method, device, equipment and the storage medium of frequency modulation ancillary service cost |
| CN111259009B (en) * | 2020-01-13 | 2020-09-22 | 深圳维格智数科技有限公司 | Flexible multidimensional database type cloud dimension table processing method and system |
| CN112001555A (en) * | 2020-08-26 | 2020-11-27 | 广州兆和电力技术有限公司 | Method, device, system and medium for power generation plan examination of power plant |
| CN113127928B (en) * | 2021-04-29 | 2022-04-22 | 山东英信计算机技术有限公司 | Database data access method and device, electronic equipment and medium |
| CN115525041B (en) * | 2022-09-21 | 2023-07-25 | 华能威海发电有限责任公司 | Fault diagnosis method, system, equipment and medium for evaluating performance indexes of power plant |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5936151A (en) * | 1997-12-22 | 1999-08-10 | International Paper Company | Method and apparatus for measuring an electrical property of papermaking furnish |
| CN103843225A (en) * | 2011-07-26 | 2014-06-04 | Gogoro有限公司 | Apparatus, method and article for authentication, security and control of power storage devices, such as batteries, based on user profiles |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101950379A (en) * | 2010-08-02 | 2011-01-19 | 国电南瑞科技股份有限公司 | Running evaluation integrated operation platform of large power grid-connected power generation plant |
| CN103646111B (en) * | 2013-12-25 | 2017-02-15 | 普元信息技术股份有限公司 | System and method for realizing real-time data association in big data environment |
| CN105406521B (en) * | 2015-12-23 | 2017-12-01 | 国电南瑞科技股份有限公司 | A kind of computational methods for evaluating unit AGC regulation performance New Sets |
| CN205829181U (en) * | 2016-07-07 | 2016-12-21 | 国网山东省电力公司电力科学研究院 | A kind of primary frequency modulation optimal control device based on power measurement deviation dynamic compensation |
| CN106649711A (en) * | 2016-12-21 | 2017-05-10 | 国电南瑞南京控制系统有限公司 | Distributed type preposed acquisition system based on Redis real-time database |
| CN107247797A (en) * | 2017-06-26 | 2017-10-13 | 国电南瑞科技股份有限公司 | Time scale measurement data-storage system and method in electric power scheduling automatization system based on Redis |
-
2017
- 2017-11-30 CN CN201711233895.3A patent/CN108022042B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5936151A (en) * | 1997-12-22 | 1999-08-10 | International Paper Company | Method and apparatus for measuring an electrical property of papermaking furnish |
| CN103843225A (en) * | 2011-07-26 | 2014-06-04 | Gogoro有限公司 | Apparatus, method and article for authentication, security and control of power storage devices, such as batteries, based on user profiles |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108022042A (en) | 2018-05-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108022042B (en) | Method for realizing rapid calculation of provincial power grid examination compensation based on memory database Redis | |
| Fleming et al. | Effects of power reserve control on wind turbine structural loading | |
| Huang et al. | Short term wind speed predictions by using the grey prediction model based forecast method | |
| AU2019296291B2 (en) | Wind turbine control method and device, controller, and control system | |
| CN101414317A (en) | Equivalent wind speed method for processing wind electric field static power equivalence dispersion problem | |
| CN112651560B (en) | Ultra-short-term wind power prediction method, device and equipment | |
| CN110159484A (en) | Wind-powered electricity generation group of planes start and stop control method based on wind power plant field grade energy hole | |
| CN113783237A (en) | Energy storage fast frequency modulation control method considering response delay | |
| CN103580043B (en) | Energy storage charge/discharge control method in wind storage integral system | |
| CN108416140A (en) | Time-history analysis seismic wave selection based on maximum instantaneous input energy and amplitude modulation method | |
| WO2018073688A1 (en) | Determining loads on a wind turbine | |
| CN111626645A (en) | Method and system for measuring and calculating future-year energy storage configuration capacity | |
| Bidikli | A robust adaptive control design for the rotor speed control of variable speed wind turbines | |
| Silva-Saravia et al. | Chance-constrained optimal location of damping control actuators under wind power variability | |
| CN116542030A (en) | Double-fed fan parameter identification method, system and equipment based on track sensitivity | |
| CN115048528A (en) | Method and device for constructing knowledge graph of new energy electric field operation data | |
| CN110219776B (en) | Method for searching dynamic rated power interval of wind generating set | |
| CN104484520A (en) | Equivalent wind speed method for processing wind power plant static power equivalent dispersion problems | |
| CN113991647A (en) | Frequency response capacity planning-oriented random production simulation method for power system | |
| CN112736935A (en) | Method for online checking model parameters of power system stabilizer by using PSS compensation angle | |
| CN107342599B (en) | Method for automatically diagnosing stability and adjusting parameters of control system in electromechanical transient simulation | |
| CN112748667B (en) | Method for on-line checking model parameters of automatic voltage regulator by using terminal voltage response curve | |
| CN115358495B (en) | Calculation method for wind power prediction comprehensive deviation rate | |
| CN115764928A (en) | Wide-area measurement information-based frequency deviation extreme value online prediction method and device | |
| CN103701112B (en) | Operation of power networks state shot and long term weak link recognition system and 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 |