CN115187425A - Power utilization data processing method based on configuration software and relational database trigger - Google Patents
Power utilization data processing method based on configuration software and relational database trigger Download PDFInfo
- Publication number
- CN115187425A CN115187425A CN202210385358.5A CN202210385358A CN115187425A CN 115187425 A CN115187425 A CN 115187425A CN 202210385358 A CN202210385358 A CN 202210385358A CN 115187425 A CN115187425 A CN 115187425A
- Authority
- CN
- China
- Prior art keywords
- data
- month
- configuration software
- time
- last
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 17
- 238000000034 method Methods 0.000 claims abstract description 9
- 230000005611 electricity Effects 0.000 claims description 13
- 238000012986 modification Methods 0.000 claims description 9
- 230000004048 modification Effects 0.000 claims description 9
- 230000008569 process Effects 0.000 claims description 9
- 230000001960 triggered effect Effects 0.000 claims description 6
- 238000004458 analytical method Methods 0.000 abstract description 4
- 238000004904 shortening Methods 0.000 abstract 1
- 230000006855 networking Effects 0.000 description 5
- 238000010586 diagram Methods 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 229910052799 carbon Inorganic materials 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000013307 optical fiber Substances 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
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J13/00—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
- H02J13/00001—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by the display of information or by user interaction, e.g. supervisory control and data acquisition systems [SCADA] or graphical user interfaces [GUI]
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J13/00—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
- H02J13/00002—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by monitoring
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J13/00—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
- H02J13/00006—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by information or instructions transport means between the monitoring, controlling or managing units and monitored, controlled or operated power network element or electrical equipment
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J13/00—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
- H02J13/00006—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by information or instructions transport means between the monitoring, controlling or managing units and monitored, controlled or operated power network element or electrical equipment
- H02J13/00016—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by information or instructions transport means between the monitoring, controlling or managing units and monitored, controlled or operated power network element or electrical equipment using a wired telecommunication network or a data transmission bus
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J13/00—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
- H02J13/00006—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by information or instructions transport means between the monitoring, controlling or managing units and monitored, controlled or operated power network element or electrical equipment
- H02J13/00016—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by information or instructions transport means between the monitoring, controlling or managing units and monitored, controlled or operated power network element or electrical equipment using a wired telecommunication network or a data transmission bus
- H02J13/00017—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network characterised by information or instructions transport means between the monitoring, controlling or managing units and monitored, controlled or operated power network element or electrical equipment using a wired telecommunication network or a data transmission bus using optical fiber
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J13/00—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
- H02J13/00032—Systems characterised by the controlled or operated power network elements or equipment, the power network elements or equipment not otherwise provided for
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J13/00—Circuit arrangements for providing remote indication of network conditions, e.g. an instantaneous record of the open or closed condition of each circuitbreaker in the network; Circuit arrangements for providing remote control of switching means in a power distribution network, e.g. switching in and out of current consumers by using a pulse code signal carried by the network
- H02J13/00032—Systems characterised by the controlled or operated power network elements or equipment, the power network elements or equipment not otherwise provided for
- H02J13/00034—Systems characterised by the controlled or operated power network elements or equipment, the power network elements or equipment not otherwise provided for the elements or equipment being or involving an electric power substation
-
- H—ELECTRICITY
- H02—GENERATION; CONVERSION OR DISTRIBUTION OF ELECTRIC POWER
- H02J—CIRCUIT ARRANGEMENTS OR SYSTEMS FOR SUPPLYING OR DISTRIBUTING ELECTRIC POWER; SYSTEMS FOR STORING ELECTRIC ENERGY
- H02J2213/00—Indexing scheme relating to details of circuit arrangements for providing remote indication of network conditions of for circuit arrangements for providing remote control of switching means in a power distribution network
- H02J2213/10—Indexing scheme relating to details of circuit arrangements for providing remote indication of network conditions of for circuit arrangements for providing remote control of switching means in a power distribution network using simultaneously two or more different transmission means
Landscapes
- Engineering & Computer Science (AREA)
- Power Engineering (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Computer Networks & Wireless Communication (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Human Computer Interaction (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a power utilization data processing method based on configuration software and a relational database trigger, which comprises the following steps: firstly, configuration software acquires data of each loop intelligent electric meter on site through a physical network, secondly, the acquired data is classified through a relational database, and finally, the data is presented to a user through an interface of the configuration software. Compared with the prior art, the method has the advantages of greatly shortening the deployment period of data acquisition and analysis of the power distribution system and the like.
Description
Technical Field
The invention relates to a power consumption data processing method, in particular to a power consumption data processing method based on configuration software and a relational database trigger.
Background
The electric parameters in the power grid are in change all the time, overload, unbalance and other factors can damage power distribution equipment, and the generation of the factors is not expected, so that the current power distribution monitoring software is configured by SCADA configuration software with strong real-time performance, data acquisition can be completed for several days by the soft data acquisition of the SCADA configuration software at the early stage, and the analysis and classification of the subsequent power consumption data can be realized by compiling programs, so that the workload of the compiling programs is large, the period is long, errors are easy to make, and the construction period cannot be guaranteed.
Therefore, how to shorten the deployment period of data acquisition and analysis of the power distribution system by using software technology becomes a technical problem to be solved.
Disclosure of Invention
The present invention provides a power consumption data processing method based on configuration software and relational database trigger to overcome the above-mentioned drawbacks of the prior art.
The purpose of the invention can be realized by the following technical scheme:
according to one aspect of the invention, a power utilization data processing method based on configuration software and a relational database trigger is provided, and comprises the following steps: firstly, configuration software acquires data of each loop intelligent electric meter on site through a physical network, secondly, the acquired data are classified through a relational database, and finally, the data are presented to a user through an interface of the configuration software.
As a preferred technical solution, the physical network includes: connecting 25 adjacent intelligent electric meters with the upper limit of the number in each substation into a bus, wherein the bus is connected to one port of a data acquisition unit, the multi-port data acquisition unit is accessed to a switch of a monitoring center after passing through a photoelectric converter, and the switch is accessed to a background computer to form a physical network;
the configuration software acquires voltage, current, power factor and electric energy data of each loop intelligent ammeter on site through a physical network.
As a preferred technical solution, the database adopts an SQL database, which includes 5 data tables, namely RealData, hisData, EPIday, EPImonth, and epilayer, wherein the structures of the data tables RealData and HisData include three fields of ID, power, and time, and the structures of the data tables EPIday, EPImonth, and epilayer include 5 fields of ID, starting power, ending power, power difference, and time.
As a preferred technical scheme, after the configuration software processes the acquired data, the ADO component forwards the data to the SQL database once an hour, and the content of the real-time data table RealData in the SQL database is updated in real time.
As a preferred technical scheme, a trigger is established in the SQL database, and the trigger is triggered when the time of the real-time database RealData is updated.
As a preferred technical solution, the content triggered by the trigger includes 3 parts, which are the content of updating the daily report table EPIday, the content of updating the monthly report table EPImonth, and the content of updating the annual report table EPIyear, respectively.
As a preferred technical solution, the content of the updated daily statement EPIday is specifically:
acquiring actual values of three fields including ID, electric energy and time to be modified from the inside of the updated copy table, acquiring the actual values of the original three fields including ID, electric energy and time from the deleted temporary table, and inserting a difference value obtained by subtracting the electric energy value before modification from the electric energy value after modification into the daily statement EPIday together with the ID and the time before modification; wherein the copy table is a temporary table INSERTED.
As a preferred technical solution, the content of the updated monthly report form EPImonth specifically is:
if the hour data value in the time is equal to 0, calculating daily electricity utilization data according to the date data in the time value under the two conditions of being more than 1 and being equal to 1; if the date data in the time value is more than 1, subtracting 1 from the current date to obtain the yesterday date, and if the date data in the time value is equal to 1, using the last day of the last month as the yesterday date;
obtaining specific yesterday, namely subtracting the electric energy value of 0 min 0 s at 0 th yesterday from the electric energy value of 0 min 0 s at 0 th yesterday, wherein the difference is the power consumption of a yesterday loop, and obtaining daily data;
if the date data value in the time is equal to 1 and the hour data is equal to 0, the value of 0 minute and 0 second at 1 day and 0 at 1 day of the current year month is subtracted by the value of 0 minute and 0 second at 0 day of the last month, namely the electricity consumption of the last month, and the annual electricity consumption report is the electricity consumption report of 1-12 months and each month.
As a preferred technical solution, in the last 1 day of the previous month, if the current month is 2, 4, 6, 8, 9, 11, the last 1 day of the previous month is 31, the previous month is the current month minus 1, and the year is the current year; if the current month is 5, 7, 10, 12, the last month is 30 for the last 1 day, the last month is the current month minus 1, and the year is the current year; if the current month is 1, the last 1 day of the last month is 31, the month of the last month is 12, and the current year of the year is reduced by 1; if the current month is 3, then it is rounded by dividing by 4, with 0 being 29 for the last 1 day, 28 for greater than 0, the last month being the current month minus 1, and the year being the current year.
As a preferred technical scheme, the configuration software takes out data in the database through the ADO component, presents a daily-monthly report to a user through the interface report component, and meets the requirements of the user on data acquisition in different departments, different years, different months, different days and different process flows.
Compared with the prior art, the invention has the following advantages:
according to the invention, rapid deployment of field data acquisition is realized based on configuration software, the acquired data is classified and processed through the relational database, and finally the data is presented to a user through an interface of the configuration software, so that the deployment cycle of data acquisition and analysis of the power distribution system is greatly shortened, the efficiency is improved, and data support can be provided for the national double-carbon strategy.
Drawings
FIG. 1 is a diagram illustrating a hardware networking architecture implemented in accordance with the present invention;
FIG. 2 is a diagram of configuration software data acquisition and relational database data processing according to the present invention;
FIG. 3 is a schematic plan view of a power distribution structure for a project of the present invention;
fig. 4 is a schematic diagram of physical networking according to the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, not all, embodiments of the present invention. All other embodiments, which can be obtained by a person skilled in the art without any inventive step based on the embodiments of the present invention, shall fall within the scope of the present invention.
The relational database uses table structure, format is consistent and easy to maintain, SQL language is generally used for complex query and convenient use, SQL language can be used for very complex query and complex operation between one table and a plurality of tables, particularly, a trigger is used as a method for analyzing data and maintaining data integrity, the trigger is a special storage process related to a table event, the execution is triggered by an event instead of being called by a program or being started manually, and statements for modifying the database can be automatically executed by a system, for example, the statements can be activated to execute when an operation (insert, delete, update) is carried out on one table; the invention provides a power distribution data acquisition and data analysis technology based on configuration software and a relational database trigger, which comprehensively compares the real-time performance of SCADA configuration software and the convenience of processing data by a relational database.
The invention relates to a power consumption data processing method based on configuration software and a relational database trigger, which comprises the following steps: firstly, configuration software acquires data of each loop intelligent electric meter on site through a physical network, secondly, the acquired data are classified through a relational database, and finally, the data are presented to a user through an interface of the configuration software.
The 25 adjacent intelligent electric meters with the upper limit of the number in each substation are connected into a bus, the bus is connected to one port of a data acquisition unit, the multi-port data acquisition unit is connected to a switch of a monitoring center through a photoelectric converter, and the switch is connected to a background computer to form a physical networking, as shown in fig. 1.
The configuration software acquires voltage, current, power factor and electric energy data of each loop intelligent ammeter in a field through a physical network;
the SQL database comprises 5 data tables, namely RealData, hisData, EPIday, EPImonth and EPIyear, wherein the structures of the RealData and HisData data tables comprise three fields of ID, electric energy and time, and the structures of the EPIday, EPImonth and EPIyear data tables comprise 5 fields of ID, initial electric energy, ending electric energy, electric energy difference and time;
after the configuration software processes the acquired data, the ADO component forwards the data to the SQL database once an hour, and the content of real-time data table RealData in the SQL database is updated in real time, as shown in FIG. 2;
a trigger is built in the SQL database, and is triggered when the time of the real-time database RealData is updated;
the content triggered by the trigger comprises 3 parts, namely the content of an updated daily statement EPIday, the content of an updated monthly statement EPImonth and the content of an updated annual statement EPIyear;
updating the content of the daily statement EPIday, acquiring actual values of three fields including ID, electric energy and time to be modified from an updated copy table (temporary table INSERTED), acquiring the actual values of the original three fields including ID, electric energy and time from a deleted temporary table, and inserting a difference value obtained by subtracting the electric energy value before modification from the electric energy value after modification into the daily statement EPIday together with the ID and the time before modification;
updating the content of the monthly report EPImonth, and if the hour data value in the time is equal to 0, calculating daily electricity consumption data according to the date data in the time value under two conditions of more than 1 and equal to 1; if the date data in the time value is more than 1, subtracting 1 from the current date to obtain the yesterday date, and if the date data in the time value is equal to 1, using the last day of the last month as the yesterday date;
if the current month is 2, 4, 6, 8, 9, 11 in the last 1 day of the last month, the last 1 day of the last month is 31, the month of the last month is the current month minus 1, and the year is the current year; if the current month is 5, 7, 10, 12, the last month is 30 for the last 1 day, the last month is the current month minus 1, and the year is the current year; if the current month is 1, the last 1 day of the last month is 31, the month of the last month is 12, and the current year of the year is reduced by 1; if the current month is 3, then use year divide by 4 to get the whole, equal to 0 is 29 for the last 1 day, 28 for more than 0, the month of the previous month is the current month minus 1, the year is the current year;
after the specific year, month and day of yesterday is obtained, the electric energy value of 0 min 0 s at 0 th day can be subtracted by the electric energy value of 0 min 0 s at 0 th day, and the difference value is the electricity consumption of the yesterday loop, so that monthly report data can be obtained;
if the date data value in the time is equal to 1 and the hour data is equal to 0, subtracting the value of 0 minute and 0 second when 1 day and 0 when the current year and month is 1 day and 0 second when the current year and month is used, namely the electricity consumption in the previous month, wherein the annual electricity consumption report is the electricity consumption report in 1-12 months and each month;
the configuration software takes out the data in the database through the ADO component, presents a daily and monthly annual report form to the user through the interface report form component, and meets the requirements of the user on data acquisition in different departments, different years, different months, different days and different process flows;
DETAILED DESCRIPTION OF EMBODIMENT (S) OF INVENTION
As shown in fig. 3, a floor plan of 8 substations in a project:
s1: establishing a networking model, as shown in the following figure 4, the site has 8 power distribution rooms, 25 adjacent intelligent electric meters with the upper limit of quantity in each power distribution room are connected into a bus, the bus is connected to one port of a data acquisition unit, and the multi-port data acquisition unit is connected to a host of a monitoring center through an optical fiber via a switch;
s2: an SCADA configuration software IO equipment configuration process enters an engineering development interface and an IO equipment configuration interface, takes modbus-RTU as an example, and creates a mouse right button;
s3, adding an equipment name and an equipment address, selecting a communication mode, selecting a serial port, a setting, a baud rate, a parity check, a data bit and a stop bit, or adopting a TCP/IP mode;
s4: in the real-time database configuration process of the SCADA configuration software, a newly-established database variable enters an engineering database configuration interface, a node is newly established by right-clicking on the three characters of the database, the node enters the engineering database configuration interface, double clicking is performed on the node T101002, and a telemetering amount is clicked in an existing node dialog box; according to the specification, a variable point is established, taking a certain type of electric power meter as an example, according to the register address 000BH of the specification voltage, H in the 000BH represents a 16-system, so B is the register number 11, and the register address of the specification is from 0, so that the voltage register address is 12 when the variable is established in software; using configuration software to quickly construct an IO equipment library and a data acquisition database according to a networking model:
s5, the SCADA configuration software forwards the data to the execution code of the relational database and the execution code of the trigger of the relational database:
s6: the data processing is finished, and the data is presented to the user in the form of a primary graph and a daily, monthly and annual report through configuration software;
while the invention has been described with reference to specific embodiments, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
Claims (10)
1. A power utilization data processing method based on configuration software and a relational database trigger is characterized by comprising the following steps: firstly, configuration software acquires data of each loop intelligent electric meter on site through a physical network, secondly, the acquired data is classified through a relational database, and finally, the data is presented to a user through an interface of the configuration software.
2. The power consumption data processing method according to claim 1, wherein the physical network comprises: connecting 25 adjacent intelligent electric meters with the upper limit of the number in each substation into a bus, connecting the bus to one port of a data acquisition unit, connecting the multi-port data acquisition unit to a switch of a monitoring center through a photoelectric converter, and connecting the switch to a background computer to form a physical network;
the configuration software acquires voltage, current, power factor and electric energy data of each loop intelligent electric meter on site through a physical network.
3. The power consumption data processing method based on the configuration software and the relational database trigger as claimed in claim 1, wherein the database is an SQL database, the SQL database comprises 5 data tables, namely RealData, hisData, EPIday, EPImonth and EPIyear, the structures of the RealData and HisData data tables comprise three fields of ID, electric energy and time, and the structures of the EPIday, EPImonth and EPIyear data tables comprise three fields of ID, starting electric energy, ending electric energy, electric energy difference and 5 fields of time.
4. The power consumption data processing method based on the configuration software and the relational database trigger as claimed in claim 3, wherein the configuration software processes the acquired data, and forwards the data to the SQL database once an hour through the ADO component, so as to update the content of the real-time data table RealData in the SQL database in real time.
5. The power consumption data processing method as claimed in claim 3, wherein a trigger is built in the SQL database and is triggered when the time of the real-time database RealData is updated.
6. The power consumption data processing method based on configuration software and relational database trigger as claimed in claim 5, wherein the trigger comprises 3 parts, which are respectively the content of updating daily table EPIday, the content of updating monthly table EPImonth and the content of updating annual table EPIyear.
7. The power consumption data processing method based on configuration software and relational database trigger as claimed in claim 5, wherein the content of the update daily report form EPIday is:
acquiring actual values of three fields of ID, electric energy and time to be modified from the inside of the updated copy table, acquiring actual values of the original fields of ID, electric energy and time from the deleted temporary table, and inserting a difference value obtained by subtracting the electric energy value before modification from the electric energy value after modification into the daily statement EPIday together with the ID and the time before modification; wherein the copy table is a temporary table INSERTED.
8. The power consumption data processing method based on configuration software and relational database triggers according to claim 5, wherein the updating of the monthly report form EPImonth specifically comprises:
if the hour data value in the time is equal to 0, calculating daily electricity consumption data according to the date data in the time value under the two conditions of being more than 1 and being equal to 1; if the date data in the time value is more than 1, subtracting 1 from the current date to obtain the yesterday date, and if the date data in the time value is equal to 1, using the last day of the last month as the yesterday date;
obtaining specific yesterday, namely subtracting the electric energy value of 0 min 0 s at 0 th yesterday from the electric energy value of 0 min 0 s at 0 th yesterday, wherein the difference is the power consumption of a yesterday loop, and obtaining daily data;
if the date data value in the time is equal to 1 and the hour data is equal to 0, the value of 0 minute and 0 second at 1 day and 0 at 1 day of the current year month is subtracted by the value of 0 minute and 0 second at 0 day of the last month, namely the electricity consumption of the last month, and the annual electricity consumption report is the electricity consumption report of 1-12 months and each month.
9. The method of claim 8, wherein if the current month is 2, 4, 6, 8, 9, 11, the last 1 day of the previous month is 31, the previous month is the current month minus 1, and the year is the current year; if the current month is 5, 7, 10, 12, the last month is 30 for the last 1 day, the last month is the current month minus 1, and the year is the current year; if the current month is 1, the last 1 day of the last month is 31, the month of the last month is 12, and the current year of the year is reduced by 1; if the current month is 3, then use year divided by 4 to get the whole, equal to 0 is 29 for the last 1 day, 28 for more than 0, the previous month is the current month minus 1, and the year is the current year.
10. The power consumption data processing method based on the configuration software and the relational database trigger as claimed in claim 3, wherein the configuration software extracts the data in the database through the ADO component, presents a daily-monthly report to the user through the interface report component, and meets the requirements of the user on data acquisition in departments, years, months, days and process flows.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210385358.5A CN115187425A (en) | 2022-04-13 | 2022-04-13 | Power utilization data processing method based on configuration software and relational database trigger |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210385358.5A CN115187425A (en) | 2022-04-13 | 2022-04-13 | Power utilization data processing method based on configuration software and relational database trigger |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN115187425A true CN115187425A (en) | 2022-10-14 |
Family
ID=83512495
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210385358.5A Pending CN115187425A (en) | 2022-04-13 | 2022-04-13 | Power utilization data processing method based on configuration software and relational database trigger |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115187425A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115617816A (en) * | 2022-11-22 | 2023-01-17 | 北京国科伟业电力科技有限公司 | System for acquiring specified ammeter data table |
-
2022
- 2022-04-13 CN CN202210385358.5A patent/CN115187425A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115617816A (en) * | 2022-11-22 | 2023-01-17 | 北京国科伟业电力科技有限公司 | System for acquiring specified ammeter data table |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107402976B (en) | Power grid multi-source data fusion method and system based on multi-element heterogeneous model | |
| Trillo-Montero et al. | Development of a software application to evaluate the performance and energy losses of grid-connected photovoltaic systems | |
| CN107786000B (en) | Intelligent generation method for configuration file of digital relay protection tester | |
| Rohjans et al. | mosaik-A modular platform for the evaluation of agent-based Smart Grid control | |
| US11176028B2 (en) | System, method and storage device for CIM/E model standard compliance test | |
| CN107394892B (en) | Method and system for determining debugging range of interval change of intelligent substation | |
| CN108879667B (en) | Power grid closed-loop control power flow simulation method | |
| CN115187425A (en) | Power utilization data processing method based on configuration software and relational database trigger | |
| CN103632031B (en) | A kind of rural area based on load curve decomposition load type load modeling method | |
| CN111398859B (en) | User low-voltage cause big data analysis method and system | |
| CN107247827B (en) | Virtual terminal model modeling and automatic wiring method based on machine learning | |
| CN111382558A (en) | Test report automatic generation method and system based on power monitoring system | |
| CN112182499A (en) | Low-voltage distribution network topological structure identification method based on time sequence electric quantity data | |
| CN108647268A (en) | Increment updating method for distribution network planning data integration | |
| CN112183823B (en) | Rule tree-based type selection method and system for electric energy metering device | |
| CN103310040B (en) | The construction method of versatile customization platform in electric secondary device simulation | |
| CN110380418B (en) | Newton-Raphson power flow calculation optimization method based on graph decomposition | |
| CN112003284A (en) | Low-voltage distribution area topology identification method based on strong synchronous load characteristic matching | |
| CN108875038A (en) | The method and system of hierarchical structure real-time data base are attached under relational database data | |
| Jiang et al. | Research and implementation of automatic configuration method for monitoring information table of smart substation equipment | |
| Song et al. | Research on the data management and decision-making method of the intelligent substation system based on SCD | |
| CN112651136B (en) | CIM equipment measurement model generation method, device, equipment and medium | |
| Wang | Design and implementation strategy of data migration system based on Hadoop platform | |
| Li et al. | Application software front-end modeling, verification and case based on the Interface Window Tree | |
| Yu et al. | Advantages of Synchronous Line Loss Checking Based on Multi-Source Data Fusion Theory |
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 |