CN102479285B - Calculation method for sag characteristic quantity of power quality - Google Patents
Calculation method for sag characteristic quantity of power quality Download PDFInfo
- Publication number
- CN102479285B CN102479285B CN201010555567.7A CN201010555567A CN102479285B CN 102479285 B CN102479285 B CN 102479285B CN 201010555567 A CN201010555567 A CN 201010555567A CN 102479285 B CN102479285 B CN 102479285B
- Authority
- CN
- China
- Prior art keywords
- event
- temporarily
- temptable
- enter step
- totaltable
- 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 13
- 238000012544 monitoring process Methods 0.000 claims abstract description 31
- 238000000034 method Methods 0.000 claims abstract description 6
- 230000001174 ascending effect Effects 0.000 claims description 3
- 238000000151 deposition Methods 0.000 claims description 3
- 238000006116 polymerization reaction Methods 0.000 description 4
- 230000001052 transient effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000007257 malfunction Effects 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 238000011084 recovery Methods 0.000 description 1
Abstract
The invention discloses a calculation method for sag characteristic quantities of power quality. In the method, data in a database based on PQView are used for calculation of the sag characteristic quantities. The method comprises the following steps: defining totalTable, tempTable and resultTable; taking an event within a certain period from a sag view table, and storing the event into the totalTable; taking the monitoring point ID (identity) of the first record, the starting time of the event and the time offset in the totalTable, and adding the event into the tempTable; defining a variable i; and judging whether i is less than the number of lines of the totalTable, and adopting different methods for treatment under different conditions. The existing data in the database based on the PQView are utilized, original data are extracted from the database and are processed to obtain the required sag characteristic quantities during monitoring of the power quality, and the sag characteristic quantities can be used as scientific decision basis for governance of a power company over the power quality.
Description
Technical field
The present invention relates to quality of power supply field, relate in particular to a kind of computing method of falling temporarily characteristic quantity for the quality of power supply.
Background technology
Along with the application of exact instrument and complex electronic equipment, user more and more requires the electric power supply of high-quality and high reliability.In recent years, along with the introduction of external sophisticated equipment and the development of application and electron trade, that is caused by power quality problem is extremely increasing.
The quality of power supply (Power Quality), refers to quality supply from universal significance, comprises quality of voltage, current quality, power supply quality and power quality.It can be defined as: cause the deviation of voltage, electric current or the frequency of consumer fault or cisco unity malfunction, its content comprises frequency departure, voltage deviation, voltage fluctuation and flicker, three-phase imbalance, temporary transient or transient overvoltage, wave form distortion (harmonic wave), voltage dip, interruption, rises and power supply continuity etc. temporarily.
In recent years along with economic develop rapidly, electric load increases swift and violent, power load increasingly complex and variation, more and more non-linear, impact, imbalance and the abundant application apparatus of harmonic wave access electrical network in succession, all can have influence on to some extent the quality of power supply of power supply grid.In addition monitoring means imperfection and operation, external interference and various failure and other reasons, power quality problem becomes increasingly conspicuous.
At present, what a lot of Utilities Electric Co.s electric energy quality monitoring system adopted is all the database based on PQView, PQView is the power quality analysis software of U.S.'s DianKeYuan development, in this database, store many electric energy quality monitoring data, how falling temporarily the calculating of characteristic quantity to collect data from this database, is the problem that present inventor is devoted to research and solves.
Summary of the invention
The object of the invention is to overcome the defect of prior art and a kind of computing method of falling temporarily characteristic quantity for the quality of power supply are provided, these computing method can realize from the database based on PQView and will collect data and fall temporarily the calculating of characteristic quantity.
The technical scheme that realizes above-mentioned purpose is: a kind of computing method of falling temporarily characteristic quantity for the quality of power supply, and the method is the calculating of the data in the database based on PQView being fallen temporarily to characteristic quantity, wherein, comprises the following steps:
Step 1, definition is deposited section table that falls temporarily event sometime and, for showing totalTable, is defined the table of the event in a minute of depositing for showing tempTable, and the table that the event of falling temporarily after final combination is deposited in definition is to show resultTable, then enters step 2;
Step 2, from a taking-up event for section sometime view table of falling temporarily of arranging with monitoring point ID ascending order, deposits in table totalTable, then enters step 3;
Step 3, monitoring point ID, event start time and the time offset of taking out first record in table totalTable, and this event is added in table tempTable, then enter step 4;
Step 4, definition one variable i, i is 1, then enters step 5;
Step 5, judges whether i is less than the line number of showing totalTable,
If so, enter step 61;
If not, enter step 62;
Step 61, judges that whether monitoring point ID is identical,
If identical, enter step 71, judge whether in n minute, if in n minute, this event is joined in table tempTable, and enter step 10, if not in n minute, enter step 72, n is positive number;
If not identical, enter step 72, judge whether the line number of table tempTable is greater than 0, if be greater than 0, enter step 8, if be not more than 0, enter step 9;
Step 8, combines the event in this table by composition of matter algorithm, and calculates corresponding field, the event after combination is added in table resultTable, and empty table tempTable, then enters step 9;
Step 9, using this i article of event respective field as new monitoring point ID, event start time and time offset, and is added in table tempTable, then enters step 10;
Step 10, variable i adds 1, then returns to step 5;
Step 62, whether the line number that judges table tempTable is greater than 0, if be greater than 0, the event in this table is combined by composition of matter algorithm, and calculate corresponding field, the event after combination is added in table resultTable, and empty table tempTable, then enter step 73, if be not more than 0, directly enter step 73;
Step 73, is saved in table resultTable in one SQL Server database, then finishes.
The above-mentioned computing method of falling temporarily characteristic quantity for the quality of power supply, wherein, the described view table that falls is temporarily to obtain from the database based on PQView, this falls temporarily and in view table, includes field: monitoring point ID, event start time, time offset, duration, phase is fallen temporarily, temporarily range of decrease value pu, range of decrease value kv temporarily, whether reason, falls in duration cycle temporarily, be combination event, event id falls temporarily, combination event ID.
The invention has the beneficial effects as follows: the present invention has utilized the data in the existing database based on PQView, by extracting raw data in this database, raw data is obtained to the needed characteristic quantity that falls temporarily in electric energy quality monitoring after treatment, and these data provide the decision-making foundation of science for Utilities Electric Co. to the improvement of the quality of power supply.
Embodiment
The invention will be further described below.
A kind of computing method of falling temporarily characteristic quantity for the quality of power supply of the present invention, the method is the calculating of the data in the database based on PQView being fallen temporarily to characteristic quantity, comprises the following steps:
Step 1, definition is deposited section table that falls temporarily event sometime and, for showing totalTable, is defined the table of the event in a minute of depositing for showing tempTable, and the table that the event of falling temporarily after final combination is deposited in definition is to show resultTable, then enters step 2;
Step 2, from a taking-up event for section sometime view table of falling temporarily of arranging with monitoring point ID ascending order, deposits in table totalTable, then enters step 3;
Step 3, monitoring point ID, event start time and the time offset of taking out first record in table totalTable, and this event is added in table tempTable, then enter step 4;
Step 4, definition one variable i, i is 1, then enters step 5;
Step 5, judges whether i is less than the line number of showing totalTable,
If so, enter step 61;
If not, enter step 62;
Step 61, judges that whether monitoring point ID is identical,
If identical, enter step 71, judge whether in n minute, if in n minute, this event is joined in table tempTable, and enter step 10, if not in n minute, enter step 72, n is positive number;
If not identical, enter step 72, judge whether the line number of table tempTable is greater than 0, if be greater than 0, enter step 8, if be not more than 0, enter step 9;
Step 8, combines the event in this table by composition of matter algorithm, and calculates corresponding field, the event after combination is added in table resultTable, and empty table tempTable, then enters step 9;
Step 9, using this i article of event respective field as new monitoring point ID, event start time and time offset, and is added in table tempTable, then enters step 10;
Step 10, variable i adds 1, then returns to step 5;
Step 62, whether the line number that judges table tempTable is greater than 0, if be greater than 0, the event in this table is combined by composition of matter algorithm, and calculate corresponding field, the event after combination is added in table resultTable, and empty table tempTable, then enter step 73, if be not more than 0, directly enter step 73;
Step 73, is saved in table resultTable in one SQL Server database (relational database management system), then finishes.
Falling temporarily view table is to obtain from the database based on PQView, and this falls temporarily and in view table, includes field: monitoring point ID, event start time, time offset, duration, phase is fallen temporarily, temporarily range of decrease value pu, range of decrease value kv temporarily, whether reason, falls in duration cycle temporarily, be combination event, event id falls temporarily, combination event ID.
The preparation method of this table is as follows: from the database based on PQView, read and data that calculating is relevant with voltage dip characteristic quantity, then they are deposited in and fall temporarily mark sheet.
The field of falling temporarily mark sheet comprises monitoring point, the event start time, phase is fallen temporarily, the first temporary range of decrease value pu, the second temporary range of decrease value kv, duration s and duration cycle, for obtaining above-mentioned data, the table in the database based on PQView relating to comprises: channel information table Channel, Event Information Table Event, the change information table RMSVariation of voltage effective value, monitoring point information table Site and data of monitoring point source information table SiteSource, all include several fields in each form, in channel information table Channel, include name field, includes siteSourceID field in Event Information Table Event, whenStart field, startTime field, baseV field, includes eventID field in the change information table RMSVariation of voltage effective value, duration field, channelID field, minimum field, includes name field in the information table Site of monitoring point, in data of monitoring point source information table SiteSource, includes eventID field.
The calculating of the first temporary range of decrease value pu is from A, the B of the change information table RMSVariation of voltage effective value, C item voltage, to get value minimum in minimum field, be nominal voltage divided by the baseV field in Event Information Table Event again, obtain the first temporary range of decrease value pu, if the value obtaining is less than or equal to 0.9, on this, occur to fall temporarily, entry position and temporarily range of decrease value, generally the special circumstances of voltage dip will be interrupted counting between short time voltage, therefore, in the present invention, voltage dip is to comprise between short time voltage interrupting;
The data acquisition mode of the second temporary range of decrease value kv is to read eventID field from the change information table RMSVariation of voltage effective value, the computing method of PQView are to read baseV field according to eventID field from Event Information Table Event, again with first fall temporarily temporary range of decrease value pu multiply each other after divided by 1000, electric power is that the computing method that provide are second temporary range of decrease value kv=amplitude pu* nominal voltages;
Duration s refers in three-phase that any phase voltage rms value is lower than 90%, till the above duration of three-phase voltage full recovery to 90%, duration s is the duration field of getting in the change information table RMSVariation of voltage effective value, when A, B, C three-phase occur to fall temporarily when identical, duration is now the mutually corresponding duration of temporary range of decrease value minimum, if the temporary range of decrease value of three-phase is equal, the duration is decided to be the time of origin side-play amount corresponding duration the earliest; If the side-play amount of time of origin also equate, the duration of long corresponding duration duration after as polymerization; For the duration after different event polymerization, be the corresponding duration of temporary range of decrease value minimum in event; If run into the equal situation of temporary range of decrease value, get the duration of event start time event early as the duration of this polymerization events;
Duration cycle is that the duration is divided by 0.02s;
The data acquisition mode of monitoring point is to read eventID field from the change information table RMSVariation of voltage effective value, from Event Information Table Event, read siteSourceID field according to eventID field again, from data of monitoring point source information table SiteSource, read siteID field according to the siteSourceID field that reads reading, finally from the information table Site of monitoring point, read name field according to siteID field, i.e. monitoring point title;
The data acquisition mode of event start time is to read eventID field from the change information table RMSVariation of voltage effective value, from Event Information Table Event, read whenStart and startTime field according to eventID field, for polymerization events, this time is that the event start time the earliest occurs in all events;
The data acquisition mode of falling temporarily phase is to read channelID field from the change information table RMSVariation of voltage effective value, then reads name field according to channelID field from channel information table Channel, i.e. corresponding title of falling temporarily phase.
In the time that same monitoring point occurs to fall event temporarily in succession, need to carry out composition of matter, getting the assembly time long is 60s, this time is self-defined in the database based on PQView, each the falling temporarily after the synthetic array of event group in 1 minute, calculate temporary range of decrease value and duration, event initial time is first time of falling temporarily record in this combination again.
For the duration after different event combination, be the corresponding duration of temporary range of decrease value minimum in event; If run into the equal situation of temporary range of decrease value, get the duration of event start time event early as the duration of this combination event.
Below the present invention is had been described in detail, those skilled in the art can make many variations example to the present invention according to the above description in conjunction with the embodiments.Thereby some details in embodiment should not form limitation of the invention, the present invention by the scope defining using appended claims as protection scope of the present invention.
Claims (1)
1. for computing method of falling temporarily characteristic quantity for the quality of power supply, the method is the calculating of the data in the database based on PQView being fallen temporarily to characteristic quantity, it is characterized in that, comprises the following steps:
Step 1, definition is deposited section table that falls temporarily event sometime and, for showing totalTable, is defined the table of the event in a minute of depositing for showing tempTable, and the table that the event of falling temporarily after final combination is deposited in definition is to show resultTable, then enters step 2;
Step 2, from a taking-up event for section sometime view table of falling temporarily of arranging with monitoring point ID ascending order, deposits in table totalTable, then enters step 3;
Step 3, monitoring point ID, event start time and the time offset of taking out first record in table totalTable, and this event is added in table tempTable, then enter step 4;
Step 4, definition one variable i, i is 1, then enters step 5;
Step 5, judges whether i is less than the line number of showing totalTable,
If so, enter step 61;
If not, enter step 62;
Step 61, judges that whether monitoring point ID is identical,
If identical, enter step 71, judge whether in n minute, if in n minute, this event is joined in table tempTable, and enter step 10, if not in n minute, enter step 72, n is positive number;
If not identical, enter step 72, judge whether the line number of table tempTable is greater than 0, if be greater than 0, enter step 8, if be not more than 0, enter step 9;
Step 8, combines the event in this table by composition of matter algorithm, and calculates corresponding field, the event after combination is added in table resultTable, and empty table tempTable, then enters step 9;
Step 9, using i article of event respective field as new monitoring point ID, event start time and time offset, and is added in table tempTable, then enters step 10;
Step 10, variable i adds 1, then returns to step 5;
Step 62, whether the line number that judges table tempTable is greater than 0, if be greater than 0, the event in this table is combined by composition of matter algorithm, and calculate corresponding field, the event after combination is added in table resultTable, and empty table tempTable, then enter step 73, if be not more than 0, directly enter step 73;
Step 73, is saved in table resultTable in one SQL Server database, then finishes,
The described view table that falls is temporarily to obtain from the database based on PQView, and this falls temporarily and in view table, includes field: monitoring point ID, event start time, time offset, duration, phase is fallen temporarily, the first temporary range of decrease value pu, the second temporary range of decrease value kv, whether reason, falls in duration cycle temporarily, be combination event, event id falls temporarily, combination event ID.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010555567.7A CN102479285B (en) | 2010-11-23 | 2010-11-23 | Calculation method for sag characteristic quantity of power quality |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010555567.7A CN102479285B (en) | 2010-11-23 | 2010-11-23 | Calculation method for sag characteristic quantity of power quality |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102479285A CN102479285A (en) | 2012-05-30 |
| CN102479285B true CN102479285B (en) | 2014-06-18 |
Family
ID=46091928
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010555567.7A Active CN102479285B (en) | 2010-11-23 | 2010-11-23 | Calculation method for sag characteristic quantity of power quality |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102479285B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103325069B (en) * | 2013-05-31 | 2016-06-15 | 国家电网公司 | Based on the theoretical Energy loss automatic gauge method of the nested triggering device of database |
| CN104537581B (en) * | 2015-01-30 | 2017-08-11 | 福州大学 | The voltage sag source tuning on-line method matched using fuzzy similarity |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1234120A (en) * | 1996-10-22 | 1999-11-03 | Abb动力T&D股份有限公司 | Energy meter with power quality monitoring and diagnostic system |
| CN101667226A (en) * | 2009-09-30 | 2010-03-10 | 华北电力大学（保定） | Method for calculating output loss of wind power field and unit |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7529642B2 (en) * | 2004-08-20 | 2009-05-05 | Pdf Solutions S.A. | Method for evaluating the quality of data collection in a manufacturing environment |
| JP5177958B2 (en) * | 2006-03-31 | 2013-04-10 | Ｈｏｙａ株式会社 | Processing data management system, processing system for magnetic disk manufacturing apparatus, and data management method for magnetic disk manufacturing apparatus |
-
2010
- 2010-11-23 CN CN201010555567.7A patent/CN102479285B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1234120A (en) * | 1996-10-22 | 1999-11-03 | Abb动力T&D股份有限公司 | Energy meter with power quality monitoring and diagnostic system |
| CN101667226A (en) * | 2009-09-30 | 2010-03-10 | 华北电力大学（保定） | Method for calculating output loss of wind power field and unit |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102479285A (en) | 2012-05-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8660807B2 (en) | Method of substation-control center two-level distributed nonlinear state estimation for power system | |
| CN102479284A (en) | Calculation method of single sag characteristic quantity for power quality | |
| CN109031000A (en) | A kind of method and system based on non-faulting disturbance In situ Measurement grid short circuit capacity | |
| Xu et al. | Synchronized waveforms–a frontier of data-based power system and apparatus monitoring, protection, and control | |
| CN105067963B (en) | Distribution Network Failure method for early warning and system based on transient-wave | |
| CN103744396B (en) | A kind of device being applied to SVG, APF cooperation control | |
| EP2680017A1 (en) | A method of early detection of feeder lines with a high-ohm ground fault in compensated power networks | |
| CN101286635B (en) | Synthetic monitoring method and device in medium-voltage power supply system | |
| CN103065265A (en) | Identification method based on PQ View data source for power quality disruption type | |
| CN102938130A (en) | Comprehensive assessment method for performance indexes of power quality based on PQView | |
| CN102467556B (en) | Power quality intelligent information system and method | |
| CN103809010A (en) | Device and method for determining voltage and power of each phase of medium-voltage network | |
| Price | Practical considerations for implementing wide area monitoring, protection and control | |
| CN102479285B (en) | Calculation method for sag characteristic quantity of power quality | |
| CN201893810U (en) | Power quality intelligent information system | |
| Shankar et al. | Study of phasor measurement unit and its applications | |
| CN102467567A (en) | Data acquiring and computing system for power quality | |
| Mak et al. | Integration of PMU, SCADA, AMI to accomplish expanded functional capabilities of Smart Grid | |
| CN102928693A (en) | Monitoring system and monitoring method for switching process of shunt power capacitor | |
| CN102608467B (en) | Method and system for transient power quality analysis | |
| Shah et al. | Review of power quality monitoring web-based techniques | |
| CN102479286B (en) | Judgment method of sag causes for power quality | |
| CN102479188B (en) | Electric energy quality data acquisition method | |
| CN102479283A (en) | Calculation method of steady state indexes for power quality | |
| CN204304620U (en) | A kind of voltage quality monitoring integral system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| ASS | Succession or assignment of patent right |
Owner name: SHANGHAI ELECTRIC COMMUNICATION CO., LTD. Free format text: FORMER OWNER: SHANGHAI JIULONG ELECTRIC SCIENCE + TECHNOLOGY CO., LTD. Effective date: 20120620 |
|
| C10 | Entry into substantive examination | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20120620 Address after: 200122 Shanghai City, Pudong New Area source deep road, No. 1122 Applicant after: Shanghai Electric Power Corporation Co-applicant after: Shanghai Electric Power Communication Co., Ltd. Address before: 200122 Shanghai City, Pudong New Area source deep road, No. 1122 Applicant before: Shanghai Electric Power Corporation Co-applicant before: Shanghai Jiulong Electric Power Co., Ltd. |
|
| ASS | Succession or assignment of patent right |
Owner name: SHANGHAI ELECTRIC COMMUNICATION CO., LTD. STATE EL Free format text: FORMER OWNER: SHANGHAI ELECTRIC COMMUNICATION CO., LTD. Effective date: 20120910 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20120910 Address after: 200122 Shanghai City, Pudong New Area source deep road, No. 1122 Applicant after: Shanghai Electric Power Corporation Applicant after: Shanghai Electric Power Communication Co., Ltd. Applicant after: State Grid Corporation of China Address before: 200122 Shanghai City, Pudong New Area source deep road, No. 1122 Applicant before: Shanghai Electric Power Corporation Applicant before: Shanghai Electric Power Communication Co., Ltd. |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |