CN115408445A - Method for calculating and visually processing daily electric quantity data of cascade power station in real time - Google Patents
Method for calculating and visually processing daily electric quantity data of cascade power station in real time Download PDFInfo
- Publication number
- CN115408445A CN115408445A CN202211065568.2A CN202211065568A CN115408445A CN 115408445 A CN115408445 A CN 115408445A CN 202211065568 A CN202211065568 A CN 202211065568A CN 115408445 A CN115408445 A CN 115408445A
- Authority
- CN
- China
- Prior art keywords
- electric quantity
- time
- power
- sequence
- data
- 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.)
- Withdrawn
Links
- 238000000034 method Methods 0.000 title claims abstract description 42
- 230000006870 function Effects 0.000 claims abstract description 49
- 230000005611 electricity Effects 0.000 claims abstract description 12
- 238000005516 engineering process Methods 0.000 claims abstract description 11
- 238000013079 data visualisation Methods 0.000 claims description 5
- 238000005538 encapsulation Methods 0.000 claims description 4
- 238000004806 packaging method and process Methods 0.000 claims description 2
- 238000003672 processing method Methods 0.000 claims 3
- 238000004364 calculation method Methods 0.000 abstract description 20
- 230000000007 visual effect Effects 0.000 abstract description 4
- 238000012800 visualization Methods 0.000 abstract description 4
- 230000001788 irregular Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 5
- 230000001174 ascending effect Effects 0.000 description 3
- 238000013500 data storage Methods 0.000 description 2
- 230000001186 cumulative effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000009977 dual effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000010248 power generation Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical 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/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- 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/2474—Sequence data queries, e.g. querying versioned data
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
- G06F16/287—Visualization; Browsing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Mathematical Physics (AREA)
- Probability & Statistics with Applications (AREA)
- Software Systems (AREA)
- Fuzzy Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Supply And Distribution Of Alternating Current (AREA)
Abstract
A method for calculating and visually processing daily electric quantity data of a cascade power station in real time is characterized in that the daily real-time electric quantity is obtained by combining with SQL (structured query language) and the area surrounded by real-time active data sequences at all times, and a calculation and statistics method of the daily electric quantity data is packaged into functions which can be simultaneously and concurrently called by combining with SQL and Function technologies; the SQL technology is adopted to call the function to complete the total electricity addition of the cascade multi-power-station; and (4) performing cascade power station daily electric quantity data real-time visualization on the total electric quantity of the multi-cascade power station by adopting a View technology. The method comprehensively utilizes the Structured Query Language (SQL), the Function (Function) and the View (View) of the database technology, and realizes the rapid and accurate real-time calculation statistics and visual display of the daily generated energy value of multiple power supplies by passing the power time sequence data of high-frequency irregular time intervals through an algorithm and a device without the help of an electric energy acquisition device system.
Description
Technical Field
The invention relates to the technical field of data information processing, in particular to a method for calculating and visually processing daily electric quantity data of a cascade power station in real time.
Background
The method has the following defects in calculation, statistics, calculation and display of daily electric quantity data of the step power station and the power plant in the power industry: when daily electric quantity data are visually displayed, the updating frequency of the electric quantity data is limited by a traditional acquisition device and a traditional calculation method, only the calculation and display functions of low-frequency data above an hour scale can be performed, and the statistical calculation and display functions of high-frequency data such as minutes and seconds cannot be realized.
Structured Query Language (SQL) is a special-purpose programming Language, a database Query and programming Language, used to access data and Query, update, and manage relational database systems. Structured query languages are high-level, non-procedural programming languages that allow users to work on high-level data structures, suitable for different relational database systems with completely different underlying structures. The Function (Function) is to encapsulate SQL with certain functions in data, has a Function of inputting specified type data and automatically returning corresponding data results, and is easily called by other database objects. View (View) refers to a View in a computer database, which is a virtual table, a set of data query results defined by SQL. It typically does not take up physical storage space and is generated dynamically when referencing views.
Disclosure of Invention
The invention provides a method for calculating, counting and displaying the real-time state of the daily electric quantity of a cascade power station in real time and visualizing the real-time state of the daily electric quantity, which relies on a Structured Query Language (SQL), a Function (Function) and a View (View) of a database technology, and realizes the rapid and accurate real-time calculation, counting and visualization of the multi-power-supply daily electric quantity numerical value under the condition of not depending on an electric energy acquisition device system by passing the high-frequency power time sequence data with irregular time intervals through an algorithm.
The technical scheme adopted by the invention is as follows:
a method for calculating daily electric quantity data of a cascade power station in real time comprises the steps of recording the daily real-time electric quantity as S, decomposing the daily electric quantity into electric quantity S1, electric quantity S2 and electric quantity S3 according to a daily electric quantity data real-time calculation statistical schematic diagram shown in a figure 1;
the calculation method comprises the following steps:
step 1: the method comprises the following steps of accurately calculating power sequence electric quantity S1 by adopting an area surrounding method of multiplying power by time, wherein the unit of power is as follows: ten thousand kilowatts, the unit of electric quantity is: hundred million degrees, calculating power sequence electric quantity S1:
wherein: n is the number of the power value sequences required, tn +1 is the time of the n +1 th power value sequence, tn is the time of the n th power value sequence, and i is a natural number from 1 st to n.
Step 2: accurately calculating the electric quantity S2 of the power sequence by adopting an area surrounding method of multiplying power by time, delaying the electric quantity S2 between the power numerical value sequence P1 at the 1 st moment and the 0 point T0 at the day, wherein the power unit is as follows: ten thousand kilowatts, the unit of electric quantity is: hundred million degrees;
electric quantity S2= P1 (T1-T0) × 24/10000;
and step 3: and (3) delaying the electric quantity S3 from the nth power numerical value sequence Pn to the current time point Tnow, wherein the power unit is as follows: ten thousand kilowatts, the unit of electric quantity is: hundred million degrees;
electric quantity S3= pn. (Tnow-Tn) × 24/10000;
and 4, step 4: accumulating the electric quantity S1-S3, arranging units and reserving 4-bit effective decimal to obtain single-power-supply real-time electric quantity S:
power S = power S1+ power S2+ power S3.
And 4-bit effective decimal reservation of the result is completed through a general round () function in the step 4.
In the step 1, the electric quantity of the power value sequence Pn from the 1 st power value sequence P1 at the time T1 to the nth power value sequence Pn at the time Tn is split and recorded as: the amount of electricity S1.
The step 1 comprises the following steps:
step 1.1: acquiring an active sequence data set with a sequence number on the same day from an active real-time data table corresponding to a structured database by using an SQL language to form a natural number sequence from 1 to n;
step 1.2: and (3) carrying out dislocation offset on the natural number sequence of the active sequence data set with the sequence number on the current day acquired in the step (1.1), realizing the numerical value sequence of the data set after offset and the data set before offset, and subtracting 1 from the data row number under the condition of the same timestamp to form an integer sequence from 0 to n.
Step 1.3: and calculating the power sequence electric quantity S1 by adopting an area surrounding method of multiplying power by time.
In the step 2, the power value sequence from the 1 st power value sequence P1 at the time T1 to the 0 point T0 at the day is split, and the power value sequence is surrounded by time to form electric quantity, which is recorded as electric quantity S2.
In the step 3, the electric quantity formed from the nth power value Pn at the time Tn to the current time point Tnow is divided and recorded as electric quantity S3.
And (3) performing FUNCTION encapsulation on the method for acquiring the electric quantity S by adopting SQL, transmitting a single-point NUMBER and a digital parameter into the FUNCTION, returning the current day electric quantity by the FUNCTION, taking the digital as a result, marking the FUNCTION as DL _ TODAY _ CALC (IN _ ID IN NUMBER), and performing FUNCTION generation by adopting a CREATE REPLACE FUNCTION mode.
And calling a packaging function DL _ TODAY _ CALC (IN _ ID IN NUMBER) by SQL to realize the total addition of the power of multiple power supplies.
And accumulating the electric quantities of the plurality of power supplies by using a view technology and a Create view DL _ ALL _ VIW mode to form the cascade station daily electric quantity data visualization.
The invention discloses a method for calculating and visually processing daily electric quantity data of a cascade power station in real time, which has the following technical effects:
1) The method for realizing the real-time calculation and statistics of the daily electric quantity data through the SQL sentence by adopting the active real-time sequence data can quickly finish the second-level high-frequency generation of the daily electric quantity data by utilizing the existing active real-time data on the premise of not increasing or modifying electric quantity acquisition data equipment and systems, and has higher accuracy.
2) The method comprehensively utilizes the Structured Query Language (SQL), the Function (Function) and the View (View) of the database technology, and realizes the rapid and accurate real-time calculation statistics and visual display of the daily generated energy value of multiple power supplies by passing the power time sequence data with high frequency irregular time intervals through an algorithm and a device without the help of an electric energy acquisition device system.
3) The invention combines the actual requirements of the power industry, is realized by depending on a software technology, is suitable for the management system of most power stations, and has high function deployment speed.
Drawings
Fig. 1 is a schematic diagram of real-time calculation statistics of daily electricity data.
Fig. 2 is a flow chart of real-time calculation and visualization of daily electricity data.
Detailed Description
A method for calculating and visually processing daily electric quantity data of a cascade power station in real time comprises the following steps: designing a calculation and statistics method of daily electric quantity data universal for a single power station, acquiring the daily real-time electric quantity by combining SQL and using the area surrounded by real-time active data sequences at each moment, specifically performing deviation processing on the active real-time data sequences, and improving the precision of generating electric quantity by actively surrounding the electric quantity by a method of extending an active initial sequence backwards and extending an active sequence at the tail forwards to the current moment; the calculation and statistics method of the daily electric quantity data is combined with SQL and Function technologies to be packaged into a Function which can be simultaneously and concurrently called; the SQL technology is adopted to call the function to complete the total electricity addition of the cascade multi-power-station; and (4) performing cascade power station daily electric quantity data real-time visualization on the total electric quantity of the multi-cascade power station by adopting a View technology.
The present invention will be described in further detail below with reference to the accompanying drawings.
The method comprises the following steps: and acquiring an active sequence data set with a sequence number on the current day from an active real-time data table corresponding to the structured database by adopting an SQL language to form n sequences starting from 1. The SQL code is simply introduced:
select rownum id,time,factv from wds.RTEMS where time>＝trunc(sysdate)and time<＝sysdate and senid＝1000order by time asc；
RTEMS refers to a data storage table of an active data sequence; the rownum id is an integer sequence growth sequence; time is active sequence data time; the factv is the value of active sequence data; trunc (sysdate) is a data system internal function, and refers to 0 point and 0 point of the current day; sysdate is a data system internal function and refers to the current time of the day; the order by time asc is used for carrying out ascending arrangement on the taken active data sequence; and the sense is an active point number which needs to be converted into the corresponding power supply electric quantity. The query result of the SQL instruction is specifically shown in the following table 1:
TABLE 1 query result one of SQL commands
Step two: and acquiring an active sequence data set sequence with a sequence number at the current day from an active real-time data table corresponding to the structured database by using an SQL language for dislocation offset, and subtracting 1 from the sequence number of all data rows to form n sequences from 0 under the condition that the offset data set and the data set before offset are in the same time. The SQL code is simply introduced:
select rownum-1id,time,factv from wds.RTEMS where time>＝trunc(sysdate)and time<＝sysdate and senid＝1000order by time asc；
RTEMS refers to a data storage table of an active data sequence; the rownum-1id is an integer sequence growing sequence after offset; time is active sequence data time; the fact is that the active sequence data value; trunc (sysdate) is a data system internal function, and refers to 0 point and 0 point of the current day; sysdate is a data system internal function and refers to the current time of the day; the order by time asc is to carry out ascending arrangement on the taken active data sequence; and the sense is an active point number which needs to be converted into the corresponding power supply electric quantity. The query result of the SQL instruction is specifically shown in the following table 2:
TABLE 2 query result of SQL instruction two
Step three: and (3) accurately calculating the power sequence electric quantity S1 by adopting an area rectangular surrounding method of multiplying power by time, such as the electric quantity S1 part in a statistical schematic diagram of the daily electric quantity data real-time calculation in the figure 1. The SQL code is simply introduced:
select sum((t2_time-t1_time)*24*(t2_factv))/10000as dl from(
select t1.id,t1.time t1_time,t1.factv t1_factv,t2.time t2_time,t2.factv t2_factv from
(select rownum id,time,factv from wds.RTEMS where time>＝trunc(sysdate)and time<＝sysdate and senid＝55555order by time asc)t1,
(select rownum-1id,time,factv from wds.RTEMS where time>＝trunc(sysdate)and time<＝sysdate and senid＝55555order by time asc)t2
where t1.id＝t2.id(+)and t2.time is not null)；
(1) the method comprises the following steps Introducing the single-point sequence data set with the sequence number, time and active numerical value formed in the step 1 through the SQL statement of (select horizontal id, time, factv from \8230; \/8230; asc) t 1;
(2) the method comprises the following steps Introducing the single-point sequence data set with the deviated sequence number, time and active numerical value formed in the step 2 through the SQL statement of (select brown-1 id, time, factv from 8230; asc) t 2;
(3) the method comprises the following steps Querying a new data set by using the condition that the serial numbers of the id of the t1 data set and the id of the t2 data set are equal to each other (
select t1.id,t1.time t1_time,t1.factv t1_factv，t2.time t2_time，t2.factv t2_factv from……where t1.id＝t2.id(+)and t2.time is not null；
Finally, the algorithm of the third step is adopted
The amount of electricity S1 is calculated. Specifically, the calculation statistics of the S1 electric quantity is realized by SQL coding the select sum ((t 2_ time-t1_ time) _ 24: (t 2_ factv))/10000 as dl from (\8230;).
Step four: and (3) delaying the electric quantity S2 from the power value sequence (P1) at the 1 st moment (T1) to the 0 point (T0) at the day, and calculating the electric quantity S2 part in the statistical schematic diagram of the daily electric quantity data in real time in fig. 1. S2= P1 (T1-T0) 24/10000. The SQL code is simply introduced:
select(t3.time-trunc(sysdate))*t3.factv*24/10000dl from
(select time,factv from(select time,factv from wds.RTEMS where senid＝55555and time>＝trunc(sysdate)order by time asc)where rownum＝1)t3；
firstly, forming an ascending data set of a sequence with time and active fault at present through an SQL statement of (select time, fault from wds. RTEMS \8230; \ 8230; order by time asc);
then, forming a1 st data sequence with time and active fault through an SQL statement of (select time, fault from (\8230; where root rownum = 1);
and finally, accurately calculating the electric quantity S2 of the power sequence by adopting an area surrounding method of multiplying power by time, and extending the electric quantity S2, S2= P1, (T1-T0) 24/10000) from the power numerical value sequence (P1) at the 1 st moment (T1) to the current 0 point (T0), wherein the calculation statistics of the electric quantity S2 is realized by an SQL statement of select (T3. Time-trunc (sysdate)). T3.Factv 24/10000 from (('8230);' 8230);) T3.
Step five: and (3) delaying the nth power numerical value sequence (Pn) to the electric quantity S3 of the current time T now, and calculating the electric quantity S3 part in the statistical schematic diagram in real time according to the daily electric quantity data in the figure 1. S3= pn. (T now-Tn) × 24/10000. The SQL code is simply introduced:
select(sysdate-t4.time)*t4.factv*24/10000dl from
(select time,factv from(select time,factv from wds.RTEMS where senid＝55555and time>＝trunc(sysdate)order by time desc)where rownum＝1)t4；
firstly, forming a descending data set of a sequence with time and active fault at present through an SQL statement of (select time, fault from wds. RTEMS \8230; \ 8230; order by time desc);
then, through SQL statement of (select time, failure from (\8230; where nownum = 1), the last 1 data sequence with time and active failure is formed;
and finally, accurately calculating the power sequence electric quantity S3 by adopting an area surrounding method of power multiplied by time, delaying the electric quantity S3, S3= Pn, (Tnow-Tn) × 24/10000 from the power numerical value sequence (P1) at the last 1 moment (Tnow), and specifically realizing S3 electric quantity statistics by a SQL statement of select (sysdate-t 4. Time) × t4.Factv 24/10000dl from (\8230;) t4.
Step six: and accumulating the electric quantities S1, S2 and S3, normalizing the units and reserving 4-bit significant decimal to obtain complete electric quantity S. The SQL code is simply introduced:
select round(a1.dl+a2.dl+a3.dl,4)dl from(……)a1,(……)a2,(……)a3；
firstly, forming the electric quantity S1 in the third step into a Structured Query Language (SQL) data set of a1 (8230; 8230);
secondly, forming the electric quantity S2 in the fourth step into a Structured Query Language (SQL) data set of a1 (\8230;);
thirdly, forming the electric quantity S3 in the fifth step into a SQL data set of a1 (8230; a 1);
and finally, carrying out total calculation and statistics on the electric quantities S1, S2 and S3 through an SQL statement of select round (a 1.dl + a2.dl + a3.dl, 4) dl to obtain the real-time accumulated electric quantity S of the single point on the day.
Step seven: the method for acquiring the electric quantity S by using SQL is used for carrying out function encapsulation, a single-point NUMBER parameter IN _ ID IN NUMBER is transmitted into the function, the function RETURNs the electric quantity RETURN FLOAT of the current day as a result, the function is DL _ TODAY _ CALC (IN _ ID IN NUMBER), and the specific SQL creating method comprises the following steps:
firstly, defining a character string variable v _ str varchar2 (1000) for storing the SQL code formed in the step 6;
secondly, defining a numerical value variable v _ ID number (11) for storing a single-point number parameter IN _ ID introduced by a number function;
again, a value v _ dl number (11, 3) is defined for storing the result of the function execution, i.e. the real-time daily electricity quantity data of the single power station.
Finally, the encapsulation of the function is completed through the create or replace function dl _ today _ calc (in _ id in number), and the function code is formed as follows:
step eight: in the SQL code, a function is called to sum up daily real-time accumulated electric quantity of a plurality of power supplies, taking number 1000, 1001, 1002, 1003, 1004, 1005 as an example, the SQL code for calling the function dl _ today _ calc (in _ id in number) to complete electric quantity summary is as follows:
SELECT t2.sl sl FROM(select dl_today_calc(1000)+dl_today_calc(1001)+dl_today_calc(1002)+dl_today_calc(1003)+dl_today_calc(1004)+dl_today_calc(1005)sl from dual)t2。
step nine: and (5) forming a visual view of the plurality of power supply electric quantity data obtained in the step eight by using create view, wherein the visual view has second-level real-time display, and the view SQL code is as follows:
create view DL _ ALL _ VIW as select 'cascaded power station cumulative power generation' MC, a1.Sl from (select t2.Sl from (select DL _ today _ calc (1000) + DL _ today _ calc (1001) + DL _ today _ calc (1002) + DL _ today _ calc (1003) + DL _ today _ calc (1004) + DL _ today _ calc (1005) sl from) t 2) a1.
Claims (8)
1. A method for calculating daily electric quantity data of a cascade power station in real time is characterized by comprising the following steps:
step 1: calculating power sequence electric quantity S1:
and 2, step: delaying electric quantity S2 between the power value sequence P1 and T0 at the moment T1:
electric quantity S2= P1 (T1-T0) × 24/10000;
and step 3: and (3) delaying the electric quantity S3 from the nth power numerical value sequence Pn to the current time point Tnow:
electric quantity S3= pn. (Tnow-Tn) × 24/10000;
and 4, step 4: accumulating the electric quantity S1-S3, arranging units and reserving 4-bit effective decimal to obtain the single-power-supply real-time electric quantity S:
electricity quantity S = electricity quantity S1+ electricity quantity S2+ electricity quantity S3.
2. The method for calculating the daily electric quantity data of the cascaded power station in real time according to claim 1, wherein the method comprises the following steps: in the step 1, the electric quantity of the power value sequence Pn from the time T1 to the time Tn is split and recorded as: the amount of electricity S1.
3. The method for calculating the daily electric quantity data of the cascaded power station in real time as claimed in claim 1, wherein the method comprises the following steps: the step 1 comprises the following steps:
step 1.1: acquiring an active sequence data set with a sequence number on the current day from an active real-time data table corresponding to a structured database by adopting an SQL language, and forming a natural number sequence from 1 to n;
step 1.2: carrying out dislocation offset on the natural number sequence of the active sequence data set with the sequence number on the current day acquired in the step 1.1, so as to realize the numerical value sequence of the data set after offset and the data set before offset, and subtracting 1 from the data row number under the condition of the same timestamp to form an integer sequence from 0 to n;
step 1.3: and calculating the power sequence electric quantity S1 by adopting an area surrounding method of multiplying power by time.
4. The method for calculating the daily electric quantity data of the cascaded power station in real time according to claim 1, wherein the method comprises the following steps: in the step 2, the power value sequence from the time point T1 to the time point T0 is split, and the time is used for surrounding to form the electric quantity, which is recorded as the electric quantity S2.
5. The method for calculating the daily electric quantity data of the cascaded power station in real time as claimed in claim 1, wherein the method comprises the following steps: in the step 3, the electric quantity formed from the power value Pn at the time Tn to the current time point Tnow is divided and recorded as electric quantity S3.
6. A cascade power station daily electric quantity data visualization processing method is characterized by comprising the following steps: the SQL method for obtaining the electric quantity S is adopted for carrying out function encapsulation, and the method is characterized in that: the FUNCTION transmits a single-point NUMBER, a digital parameter, the FUNCTION returns the current day power, the digital is taken as a result, the FUNCTION is marked as DL _ TODAY _ CALC (IN _ ID IN NUMBER), and the FUNCTION is generated by adopting a CREATE REPLACE FUNCTION mode.
7. The cascade power station daily electric quantity data visualization processing method according to claim 6, characterized in that: and calling a packaging function DL _ TODAY _ CALC (IN _ ID IN NUMBER) by SQL to realize the total addition of the power of multiple power supplies.
8. The cascade power station daily electric quantity data visualization processing method according to claim 7, characterized in that: and accumulating the electric quantity of a plurality of power supplies by using a view technology and adopting a Create view DL _ ALL _ VIW mode to form the step power station daily electric quantity data visualization.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211065568.2A CN115408445A (en) | 2022-09-01 | 2022-09-01 | Method for calculating and visually processing daily electric quantity data of cascade power station in real time |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211065568.2A CN115408445A (en) | 2022-09-01 | 2022-09-01 | Method for calculating and visually processing daily electric quantity data of cascade power station in real time |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115408445A true CN115408445A (en) | 2022-11-29 |
Family
ID=84164030
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211065568.2A Withdrawn CN115408445A (en) | 2022-09-01 | 2022-09-01 | Method for calculating and visually processing daily electric quantity data of cascade power station in real time |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115408445A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116911642A (en) * | 2023-09-12 | 2023-10-20 | 中国长江电力股份有限公司 | Multi-dimensional multi-state oriented hydroelectric generating set equipment index calculation system and method |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103344824A (en) * | 2013-07-08 | 2013-10-09 | 国家电网公司 | Electric energy integration method based on time mark measurement |
| CN104572813A (en) * | 2014-11-26 | 2015-04-29 | 国家电网公司 | Report generation method and device |
| CN105046367A (en) * | 2015-07-30 | 2015-11-11 | 国电南京自动化股份有限公司 | Wind power budgeting method based on high-precision real-time database |
| CN107730104A (en) * | 2017-09-30 | 2018-02-23 | 广东美的制冷设备有限公司 | Electricity statistical method, system, Cloud Server, household electrical appliances and readable storage medium storing program for executing |
| CN110442595A (en) * | 2019-07-26 | 2019-11-12 | 南京南瑞继保电气有限公司 | A kind of method and apparatus of general SQL report data collection building |
| CN112541014A (en) * | 2020-11-26 | 2021-03-23 | 江苏瑞中数据股份有限公司 | Measurement data access system based on data center |
| CN113010492A (en) * | 2021-03-16 | 2021-06-22 | 中国建设银行股份有限公司 | Database access method and device |
-
2022
- 2022-09-01 CN CN202211065568.2A patent/CN115408445A/en not_active Withdrawn
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103344824A (en) * | 2013-07-08 | 2013-10-09 | 国家电网公司 | Electric energy integration method based on time mark measurement |
| CN104572813A (en) * | 2014-11-26 | 2015-04-29 | 国家电网公司 | Report generation method and device |
| CN105046367A (en) * | 2015-07-30 | 2015-11-11 | 国电南京自动化股份有限公司 | Wind power budgeting method based on high-precision real-time database |
| CN107730104A (en) * | 2017-09-30 | 2018-02-23 | 广东美的制冷设备有限公司 | Electricity statistical method, system, Cloud Server, household electrical appliances and readable storage medium storing program for executing |
| CN110442595A (en) * | 2019-07-26 | 2019-11-12 | 南京南瑞继保电气有限公司 | A kind of method and apparatus of general SQL report data collection building |
| CN112541014A (en) * | 2020-11-26 | 2021-03-23 | 江苏瑞中数据股份有限公司 | Measurement data access system based on data center |
| CN113010492A (en) * | 2021-03-16 | 2021-06-22 | 中国建设银行股份有限公司 | Database access method and device |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116911642A (en) * | 2023-09-12 | 2023-10-20 | 中国长江电力股份有限公司 | Multi-dimensional multi-state oriented hydroelectric generating set equipment index calculation system and method |
| CN116911642B (en) * | 2023-09-12 | 2023-12-26 | 中国长江电力股份有限公司 | Multi-dimensional multi-state oriented hydroelectric generating set equipment index calculation system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Singh et al. | An efficient technique for reliability analysis of power systems including time dependent sources | |
| CN110555785B (en) | Monthly plan safety and stability checking method and system | |
| EP2608074A2 (en) | Systems and methods for merging source records in accordance with survivorship rules | |
| CN103186541B (en) | A kind of mapping relations generate method and device | |
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN113378011B (en) | Construction method and system of complex product assembly digital twin body | |
| CN115408445A (en) | Method for calculating and visually processing daily electric quantity data of cascade power station in real time | |
| CN101477555B (en) | Fast retrieval and generation display method for task tree based on SQL database | |
| CN112540975B (en) | Multi-source heterogeneous data quality detection method and system based on petri net | |
| CN103646100A (en) | Report data organization model | |
| CN111078766A (en) | Data warehouse model construction system and method based on multidimensional theory | |
| CN105279269A (en) | SQL generating method and system for supporting table free association | |
| CN111159152A (en) | Secondary operation and maintenance data fusion method based on big data processing technology | |
| CN112256681A (en) | Air traffic control digital index application system and method | |
| CN104299065B (en) | A kind of method that Correctness of model is verified between dispatching automation main preparation system | |
| CN116345565A (en) | New energy and energy storage capacity combined optimization method, system, equipment and medium | |
| CN101996246B (en) | Method and system for instant indexing | |
| CN104317879B (en) | A kind of telemetry real-time exhibition method based on real-time data base | |
| CN112418732A (en) | Multi-energy hub-containing comprehensive energy system planning method and system based on maximum flow and minimum cut theorem | |
| CN110348623A (en) | Complex Product Development time prediction and optimization method based on Design Structure Model | |
| CN111144682A (en) | Method for mining main influence factors of operation efficiency of power distribution network | |
| CN116911642B (en) | Multi-dimensional multi-state oriented hydroelectric generating set equipment index calculation system and method | |
| Wang et al. | Structure and query optimization of relay protection data model based on shortest path algorithm | |
| CN113515570B (en) | Distributed database data replication method and device | |
| Liu et al. | Short-Term Load Prediction Based on Typical Daily Feature Selection and Time Convolutional Neural Network |
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 | ||
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20221129 |