CN106920047B - Power grid statistical data derivation calculation method and system based on hierarchical storage model - Google Patents
Power grid statistical data derivation calculation method and system based on hierarchical storage model Download PDFInfo
- Publication number
- CN106920047B CN106920047B CN201710142421.1A CN201710142421A CN106920047B CN 106920047 B CN106920047 B CN 106920047B CN 201710142421 A CN201710142421 A CN 201710142421A CN 106920047 B CN106920047 B CN 106920047B
- Authority
- CN
- China
- Prior art keywords
- calculation
- factor
- model
- power grid
- result
- 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 322
- 238000009795 derivation Methods 0.000 title claims abstract description 41
- 238000010276 construction Methods 0.000 claims description 2
- 238000000034 method Methods 0.000 abstract description 21
- 238000012545 processing Methods 0.000 abstract description 12
- 238000012423 maintenance Methods 0.000 abstract description 8
- 238000012360 testing method Methods 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 5
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000007620 mathematical function Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
-
- 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
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Health & Medical Sciences (AREA)
- Marketing (AREA)
- General Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Public Health (AREA)
- Primary Health Care (AREA)
- Water Supply & Treatment (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- General Health & Medical Sciences (AREA)
- Game Theory and Decision Science (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses a power grid statistical data derivation calculation method and system based on a hierarchical storage model, which are used for solving the technical problems that in the prior art, a manual definition formula method adopted for processing scheduling system data is large in workload and easy to omit manual maintenance, and a method for performing special statistical calculation by using a special program needs to modify and test a data processing module frequently, so that the stable operation of the system is not facilitated. The method provided by the embodiment of the invention comprises the following steps: constructing a power grid hierarchical relationship model according to the acquired power grid model data; generating a general calculation formula according to the power grid hierarchical relationship model definition, wherein the general calculation formula comprises a calculation factor, a result factor and calculation logic; and acquiring all records of the association table domain of the calculation factor, performing derivative calculation on all records according to calculation logic, and writing the obtained calculation result into the model data position associated with the result factor.
Description
Technical Field
The invention relates to the technical field of power grids, in particular to a power grid statistical data derivation calculation method and system based on a hierarchical storage model.
Background
The current dispatching automation system not only needs to monitor the running state of each device, but also needs to monitor the running statistical data of the power grid, the monitored important statistical index data comprise various loads, total output of areas and stations, output conditions of different power supplies and the like of the power grid, and the current domestic dispatching automation system carries out special statistical calculation on the data through a manual definition formula or by using a special program. Although the rule for processing data by using the manual definition formula is flexible, all related formulas need to be modified along with the change of the power grid model, the manual maintenance workload is increased, and omission easily occurs, so that the statistical result data is lost; although a large amount of maintenance work is avoided by using a special program to carry out special statistical calculation, the rule is fixed, once the data processing requirement or the type of monitoring data changes, the data processing module needs to be modified and tested in a targeted manner, and the stable operation of an online system is not facilitated; and the program is continuously modified, so that the practicability is difficult.
Disclosure of Invention
The embodiment of the invention provides a power grid statistical data derivation calculation method and system based on a hierarchical storage model, and solves the technical problems that in the prior art, a manual maintenance workload of a manual definition formula method adopted for processing scheduling system data is large, omission easily occurs, a data processing module needs to be frequently modified and tested, and stable operation of the system is not facilitated by a method for performing special statistical calculation by using a special program.
The embodiment of the invention provides a power grid statistical data derivation calculation method based on a hierarchical storage model, which comprises the following steps:
constructing a power grid hierarchical relationship model according to the acquired power grid model data;
generating a general calculation formula according to the power grid hierarchical relationship model definition, wherein the general calculation formula comprises a calculation factor, a result factor and calculation logic;
and acquiring all records of the association table domain of the calculation factor, performing derivative calculation on all records according to calculation logic, and writing the obtained calculation result into the model data position associated with the result factor.
Optionally, constructing a power grid hierarchical relationship model according to the obtained power grid model data includes:
and obtaining the association relationship between equipment and a plant station and the association relationship between the plant station and the area in the power grid model data according to the obtained power grid model data, and constructing a power grid hierarchical relationship model among the area, the plant station and the equipment.
Optionally, the general calculation formula further includes calculation parameters;
the calculation parameters comprise calculation starting time, calculation ending time, calculation period, priority and application.
Optionally, the computation logic is a regular statement of a string of computation factors, result factors and operators.
Optionally, the obtaining all records of the association table field of the calculation factor, performing derivative calculation on all records according to the calculation logic, and writing the obtained calculation result into the model data position associated with the result factor includes:
and acquiring all records of the association table field of the calculation factor, performing derivative calculation on all records according to the calculation logic and the calculation parameters, and writing the obtained calculation result into the model data position associated with the result factor.
Optionally, the obtaining all records of the association table field of the calculation factor, performing derivative calculation on all records according to the calculation logic and the calculation parameters, and writing the obtained calculation result into the model data position associated with the result factor specifically includes:
a1, reading all the general calculation formulas, and marking the number of the general calculation formulas as P;
a2, defining i to be 1, wherein i is a subscript of a traversal general calculation formula;
a3, inquiring a general calculation formula, and selecting the ith formula according to the priority of the general calculation formula;
a4, acquiring association information of the calculation factor and the result factor according to a general calculation formula, and acquiring an association table domain corresponding to the calculation factor;
a5, inquiring related model records according to the association table domain, and defining Q records;
a6, defining j to be 1, wherein j is a subscript recorded by traversing the domain-level calculation component association model;
a7, reading the jth record, and performing derivation calculation according to the calculation rule of the general calculation formula;
a8, judging whether j is smaller than Q, if so, j equals j +1, and going to step a 7; if not, go to step A9;
a9, writing the related calculation results into records associated with result factors according to the power grid hierarchical relationship model;
a10, judging whether i is less than P, if so, turning to step A3, wherein i is i + 1; if not, go to step A11;
and A11, finishing the calculation period.
The embodiment of the invention provides a power grid statistical data derivation computing system based on a hierarchical storage model, which comprises:
the building module is used for building a power grid hierarchical relationship model according to the obtained power grid model data;
the generation module is used for generating a general calculation formula according to the power grid hierarchical relationship model definition, wherein the general calculation formula comprises a calculation factor, a result factor and calculation logic;
and the calculation module is used for acquiring all records of the association table domain of the calculation factor, performing derivation calculation on all records according to calculation logic, and writing the obtained calculation result into the model data position associated with the result factor.
Optionally, the building block comprises:
and the construction unit is used for obtaining the association relationship between the equipment and the plant station and the association relationship between the plant station and the area in the power grid model data according to the obtained power grid model data, and constructing a power grid hierarchical relationship model among the area, the plant station and the equipment.
Optionally, the calculation module comprises:
and the calculation unit is used for acquiring all records of the association table domain of the calculation factor, performing derivation calculation on all records according to the calculation logic and the calculation parameters, and writing the obtained calculation result into the model data position associated with the result factor.
Optionally, the computing unit specifically includes:
the reading subunit is used for reading all the general calculation formulas and marking the number of the general calculation formulas as P;
the first definition subunit is used for defining that i is 1, and i is a subscript of the traversal general calculation formula;
the first inquiry subunit is used for inquiring the general calculation formula and selecting the ith formula according to the priority of the general calculation formula;
the obtaining subunit is used for obtaining the correlation information of the calculation factor and the result factor according to the general calculation formula and obtaining the correlation table domain corresponding to the calculation factor;
the second inquiry subunit is used for inquiring the relevant model records according to the association table domain, and Q records are defined;
the second definition subunit is used for defining j to be 1, wherein j is a subscript recorded by traversing the domain-level calculation component association model;
the calculation subunit is used for reading the jth record and performing derivation calculation according to the calculation rule of the general calculation formula;
a first determining subunit, configured to determine whether j is smaller than Q, if j is j +1, go to step a 7; if not, go to step A9;
the writing subunit is used for writing the related calculation result into the record associated with the result factor according to the power grid hierarchical relationship model;
a second determining subunit, configured to determine whether i is smaller than P, if so, if i is equal to i +1, go to step a 3; if not, go to step A11;
and the ending subunit is used for ending the calculation period.
According to the technical scheme, the embodiment of the invention has the following advantages:
the embodiment of the invention provides a power grid statistical data derivation calculation method and system based on a hierarchical storage model, which comprises the following steps: constructing a power grid hierarchical relationship model according to the acquired power grid model data; generating a general calculation formula according to the power grid hierarchical relationship model definition, wherein the general calculation formula comprises a calculation factor, a result factor and calculation logic; and acquiring all records of the association table domain of the calculation factor, performing derivative calculation on all records according to calculation logic, and writing the obtained calculation result into the model data position associated with the result factor. In the embodiment of the invention, the automatic batch calculation of the statistical data of the power grid is realized by constructing the power grid hierarchical relation model and establishing the domain-level general calculation formula, the calculation record set can be automatically adjusted according to the dynamic change of power grid model equipment, the maintenance work of a large number of manual definition formulas is avoided, meanwhile, the calculation logic can be dynamically configured with the modification function through the general calculation formula calculation logic, the calculation logic can be dynamically adjusted in real time without program modification when the calculation requirement changes, and the technical problems that the manual definition formula method adopted for processing the scheduling system data in the prior art has large manual maintenance workload and is easy to omit, and a method for performing special statistical calculation by using a special program needs to frequently modify and test a data processing module, and is not beneficial to the stable operation of the system are solved.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to these drawings without inventive exercise.
Fig. 1 is a schematic flowchart of an embodiment of a grid statistical data derivation calculation method based on a hierarchical storage model according to an embodiment of the present invention;
fig. 2 is a schematic flowchart of a method for calculating derived statistical data of a power grid based on a hierarchical storage model according to another embodiment of the present invention;
fig. 3 is a schematic diagram of a statistical calculation flow of the power grid statistical data derivation calculation method based on the hierarchical storage model according to the embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a power grid statistical data derivation calculation method and system based on a hierarchical storage model, which are used for solving the technical problems that in the prior art, a manual definition formula method adopted for processing scheduling system data is large in workload and easy to omit manual maintenance, and a method for performing special statistical calculation by using a special program needs to modify and test a data processing module frequently, so that the stable operation of the system is not facilitated.
In order to make the objects, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is obvious that the embodiments described below are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, an embodiment of a grid statistical data derivation calculation method based on a hierarchical storage model according to the present invention includes:
101. constructing a power grid hierarchical relationship model according to the acquired power grid model data;
firstly, a power grid hierarchical relation model is constructed according to the obtained field model data of the power grid.
102. Generating a general calculation formula according to the power grid hierarchical relationship model definition, wherein the general calculation formula comprises a calculation factor, a result factor and calculation logic;
after the power grid hierarchical relationship model is constructed, a general calculation formula is generated according to the power grid hierarchical relationship model definition, and the general calculation formula comprises a calculation factor, a result factor and calculation logic. The calculation factor is a data item association table field needing to participate in calculation, and the result factor is a target calculation result association table field. The calculation logic is a regular operation statement of a character string consisting of formula calculation factors, result factors and operators. After the general calculation formula is defined, the background general calculation formula calculation service program can acquire all general calculation formula information at regular time and calculate all general calculation formulas without manual intervention.
103. And acquiring all records of the association table domain of the calculation factor, performing derivative calculation on all records according to calculation logic, and writing the obtained calculation result into the model data position associated with the result factor.
After a general calculation formula is generated according to the power grid hierarchical relationship model definition, the step of performing statistical calculation on data specifically comprises the following steps: and acquiring all records of the association table domain of the calculation factor, performing derivative calculation on all records according to calculation logic, and writing the obtained calculation result into the model data position associated with the result factor.
In the above, for the detailed description of an embodiment of the method for calculating power grid statistical data derivation based on the hierarchical storage model according to the embodiment of the present invention, another embodiment of the method for calculating power grid statistical data derivation based on the hierarchical storage model according to the embodiment of the present invention is described in detail below.
Referring to fig. 2, another embodiment of a grid statistical data derivation calculation method based on a hierarchical storage model according to an embodiment of the present invention includes:
201. acquiring an incidence relation between equipment and a plant station and an incidence relation between the plant station and a region in the power grid model data according to the acquired power grid model data, and constructing a power grid hierarchical relation model among the region, the plant station and the equipment;
firstly, respectively obtaining an equipment model, a plant station model and a region model from a power grid model according to obtained power grid model data, obtaining an incidence relation between equipment and a plant station and an incidence relation between the plant station and the region, then constructing a power grid hierarchical relation model of 'region- > plant station- > equipment' among the region, the plant station and the equipment, and storing the power grid hierarchical relation model in a 'tree' -shaped data structure.
202. Generating a general calculation formula according to the power grid hierarchical relationship model definition, wherein the general calculation formula comprises a calculation factor, a result factor and calculation logic;
after the power grid hierarchical relationship model is constructed, a general calculation formula is generated according to the power grid hierarchical relationship model definition, that is, a general calculation formula rule can be defined in a formula definition tool according to requirements, and the general calculation formula comprises a calculation factor, a result factor, calculation logic and calculation parameters. The calculation factor is a data item association table field needing to participate in calculation, and the result factor is a target calculation result association table field. The calculation logic is a regular operation statement of a character string consisting of formula calculation factors, result factors and operators. The formula operation integrates packaged functions, and the functions comprise mathematical functions and statistical functions. The calculation parameters comprise the starting time, the ending time, the calculation period, the priority and the application of the formula calculation. After the general calculation formula is defined, the background general calculation formula calculation service program can acquire all general calculation formula information at regular time and calculate all general calculation formulas without manual intervention.
203. Acquiring all records of an association table field of the calculation factor, performing derivation calculation on all records according to calculation logic and calculation parameters, and writing an obtained calculation result into a model data position associated with a result factor;
and finally, acquiring all records of the association table domain of the calculation factor, performing derivative calculation on all records according to the calculation logic and the calculation parameters, and writing the obtained calculation result into the model data position associated with the result factor. The method has flexible and configurable functions, when the demand changes, the calculation parameters and the calculation logic of the general calculation formula are modified or the table domain associated with the calculation and result factors is modified, and the background general calculation service automatically recalculates the statistical result according to the modified configuration and calculation logic.
For convenience of understanding, a statistical computation flow of the grid statistical data derivation computation method based on the hierarchical storage model according to the embodiment of the present invention will be described in detail below.
Referring to fig. 3, the steps of calculating the background general calculation formula in one period of the service program are as follows:
a1, starting a calculation cycle, reading all the general calculation formulas, and marking the number of the general calculation formulas as P (namely, P general calculation formulas are assumed);
a2, defining i to be 1, wherein i is a subscript of a traversal general calculation formula;
a3, inquiring a general calculation formula, and selecting the ith formula according to the priority of the general calculation formula;
a4, acquiring association information of the calculation factor and the result factor according to a general calculation formula, and acquiring an association table domain corresponding to the calculation factor;
a5, inquiring related model records according to the association table domain, and defining Q records;
a6, defining j to be 1, wherein j is a subscript recorded by traversing the domain-level calculation component association model;
a7, reading the jth record, and performing derivation calculation according to the calculation rule of the general calculation formula;
a8, judging whether j is smaller than Q, if so, j equals j +1, and going to step a 7; if not, go to step A9;
a9, writing the related calculation results into records associated with result factors according to the power grid hierarchical relationship model;
a10, judging whether i is less than P, if so, turning to step A3, wherein i is i + 1; if not, go to step A11;
and A11, finishing the calculation period.
For the model records of the result factor association table, the formula does not need to be defined in a formula definition tool item by item aiming at each record, and all records can be automatically calculated by only defining one formula. When the requirement changes, calculation parameters and calculation logic can be modified for the defined formula in a formula definition tool or a table domain associated with the calculation factors and the result factors can be modified, and the background general calculation service can automatically recalculate statistical results according to the modified configuration and the calculation logic, so that not only is a great deal of maintenance work avoided, but also the stable operation of the system can be ensured.
In order to describe the detailed statistical computation process of the grid statistical data derivation computation method based on the hierarchical storage model according to the embodiment of the present invention, a grid statistical data derivation computation system based on the hierarchical storage model according to the embodiment of the present invention will be described in detail below.
The power grid statistical data derivation computing system based on the hierarchical storage model provided by the embodiment of the invention comprises:
the building module 301 is configured to build a power grid hierarchical relationship model according to the obtained power grid model data; the building block 301 includes:
the building unit 3011 is configured to obtain, according to the obtained power grid model data, an association relationship between a device and a plant station and an association relationship between the plant station and a region in the power grid model data, and build a power grid hierarchical relationship model among the region, the plant station, and the device.
A generating module 302, configured to generate a general calculation formula according to the power grid hierarchical relationship model definition, where the general calculation formula includes a calculation factor, a result factor, and calculation logic;
the calculation module 303 is configured to obtain all records of the association table field of the calculation factor, perform derivation calculation on all records according to calculation logic, and write an obtained calculation result into a model data position associated with the result factor; the calculation module 303 includes:
a calculating unit 3031, configured to obtain all records of an association table field of a calculation factor, perform derivation calculation on all records according to calculation logic and calculation parameters, and write an obtained calculation result into a model data position associated with a result factor; the calculating unit 3031 specifically includes:
a reading subunit 30311, configured to read all the general calculation formulas, and mark the number of the general calculation formulas as P;
a first definition subunit 30312, configured to define i as 1, where i is a subscript of the traversal general calculation formula;
a first query subunit 30313, configured to query the general calculation formula, and select an ith formula according to the priority of the general calculation formula;
an obtaining subunit 30314, configured to obtain association information of the calculation factor and the result factor according to a general calculation formula, and obtain an association table domain corresponding to the calculation factor;
a second query subunit 30315, configured to query the relevant model records according to the association table domain, where Q records are defined;
a second defining subunit 30316, configured to define j as 1, where j is a subscript recorded in the traversal domain-level computation component association model;
a calculation subunit 30317, configured to read the jth record, and perform derivation calculation according to the calculation rule of the general calculation formula;
a first determining subunit 30318, configured to determine whether j is smaller than Q, if j is smaller than Q, then j +1, and go to step a 7; if not, go to step A9;
a write-in subunit 30319, configured to write the relevant calculation result into the record associated with the result factor according to the power grid hierarchical relationship model;
a second determining subunit 303110, configured to determine whether i is less than P, if i is greater than i +1, go to step A3; if not, go to step A11;
an end subunit 303111 for ending the calculation cycle.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (5)
1. A power grid statistical data derivation calculation method based on a hierarchical storage model is characterized by comprising the following steps:
constructing a power grid hierarchical relationship model according to the acquired power grid model data;
generating a general calculation formula according to the power grid hierarchical relationship model definition, wherein the general calculation formula comprises a calculation factor, a result factor and calculation logic;
acquiring all records of the association table domain of the calculation factor, performing derivation calculation on all the records according to the calculation logic, and writing the obtained calculation result into the model data position associated with the result factor;
the general calculation formula further comprises calculation parameters;
the calculation parameters comprise calculation starting time, calculation ending time, calculation period, priority and application to which the calculation starting time and the calculation ending time belong;
the obtaining all records of the association table field of the calculation factor, performing derivation calculation on all records according to the calculation logic, and writing the obtained calculation result into the model data position associated with the result factor includes:
acquiring all records of the association table domain of the calculation factor, performing derivation calculation on all records according to the calculation logic and the calculation parameters, and writing the obtained calculation result into the model data position associated with the result factor;
the obtaining all records of the association table field of the calculation factor, performing derivation calculation on all records according to the calculation logic and the calculation parameters, and writing the obtained calculation result into the model data position associated with the result factor specifically includes:
a1, reading all the general calculation formulas, and marking the number of the general calculation formulas as P;
a2, defining i to be 1, wherein i is a subscript of a traversal general calculation formula;
a3, inquiring the general calculation formula, and selecting the ith formula according to the priority of the general calculation formula;
a4, acquiring association information of the calculation factor and the result factor according to the general calculation formula, and acquiring an association table domain corresponding to the calculation factor;
a5, inquiring related model records according to the association table domain, and defining Q records;
a6, defining j to be 1, wherein j is a subscript recorded by traversing the domain-level calculation component association model;
a7, reading the jth record, and performing derivation calculation according to the calculation rule of the general calculation formula;
a8, judging whether j is smaller than Q, if so, j equals j +1, and going to step a 7; if not, go to step A9;
a9, writing related calculation results into records associated with the result factors according to the power grid hierarchical relationship model;
a10, judging whether i is less than P, if so, turning to step A3, wherein i is i + 1; if not, go to step A11;
and A11, finishing the calculation period.
2. The grid statistical data derivation calculation method based on the hierarchical storage model according to claim 1, wherein the constructing a grid hierarchical relationship model according to the obtained grid model data comprises:
and acquiring the association relationship between equipment and a plant station and the association relationship between the plant station and the area in the power grid model data according to the acquired power grid model data, and constructing a power grid hierarchical relationship model among the area, the plant station and the equipment.
3. The grid statistical data derivation calculation method based on the hierarchical storage model according to claim 1, wherein the calculation logic is a rule statement of a character string composed of the calculation factor, the result factor and an operator.
4. A power grid statistical data derivation computing system based on a hierarchical storage model is characterized by comprising:
the building module is used for building a power grid hierarchical relationship model according to the obtained power grid model data;
the generation module is used for generating a general calculation formula according to the power grid hierarchical relationship model definition, wherein the general calculation formula comprises a calculation factor, a result factor and calculation logic;
the calculation module is used for acquiring all records of the association table domain of the calculation factor, performing derivation calculation on all records according to the calculation logic, and writing the obtained calculation result into the model data position associated with the result factor;
the general calculation formula further comprises calculation parameters;
the calculation parameters comprise calculation starting time, calculation ending time, calculation period, priority and application to which the calculation starting time and the calculation ending time belong;
the calculation module comprises:
the calculation unit is used for acquiring all records of the association table domain of the calculation factor, performing derivation calculation on all records according to the calculation logic and the calculation parameters, and writing the obtained calculation result into the position of the model data associated with the result factor;
the computing unit specifically includes:
the reading subunit is used for reading all the general calculation formulas and marking the number of the general calculation formulas as P;
the first definition subunit is used for defining that i is 1, and i is a subscript of the traversal general calculation formula;
the first inquiry subunit is used for inquiring the general calculation formula and selecting the ith formula according to the priority of the general calculation formula;
the obtaining subunit is used for obtaining the correlation information of the calculation factor and the result factor according to the general calculation formula, and obtaining the correlation table domain corresponding to the calculation factor;
the second inquiry subunit is used for inquiring the relevant model records according to the association table domain, and Q records are defined;
the second definition subunit is used for defining j to be 1, wherein j is a subscript recorded by traversing the domain-level calculation component association model;
the calculation subunit is used for reading the jth record and performing derivation calculation according to the calculation rule of the general calculation formula;
a first determining subunit, configured to determine whether j is smaller than Q, if j is j +1, go to step a 7; if not, go to step A9;
the writing subunit is used for writing the related calculation result into the record associated with the result factor according to the power grid hierarchical relationship model;
a second determining subunit, configured to determine whether i is smaller than P, if so, if i is equal to i +1, go to step a 3; if not, go to step A11;
and the ending subunit is used for ending the calculation period.
5. The hierarchical storage model-based grid statistics derivation computing system according to claim 4, wherein the building module comprises:
and the construction unit is used for obtaining the association relationship between the equipment and the plant station and the association relationship between the plant station and the area in the power network model data according to the obtained power network model data, and constructing a power network hierarchical relationship model among the area, the plant station and the equipment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710142421.1A CN106920047B (en) | 2017-03-10 | 2017-03-10 | Power grid statistical data derivation calculation method and system based on hierarchical storage model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710142421.1A CN106920047B (en) | 2017-03-10 | 2017-03-10 | Power grid statistical data derivation calculation method and system based on hierarchical storage model |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106920047A CN106920047A (en) | 2017-07-04 |
| CN106920047B true CN106920047B (en) | 2020-11-17 |
Family
ID=59461563
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710142421.1A Active CN106920047B (en) | 2017-03-10 | 2017-03-10 | Power grid statistical data derivation calculation method and system based on hierarchical storage model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106920047B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110163492B (en) * | 2019-04-30 | 2021-11-12 | 南京南瑞继保电气有限公司 | Index processing method and device of rail transit energy management system and storage medium |
| CN112328951B (en) * | 2020-03-17 | 2021-07-20 | 北京三维天地科技股份有限公司 | Processing method of experimental data of analysis sample |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2453381A2 (en) * | 2009-07-07 | 2012-05-16 | Electronics and Telecommunications Research Institute | System for an engine for forecasting cyber threats and method for forecasting cyber threats using the system |
| CN103500157A (en) * | 2013-09-02 | 2014-01-08 | 用友软件股份有限公司 | Device and method for filling form based on dynamic formula |
| CN103093043B (en) * | 2013-01-09 | 2015-08-05 | 中国电力科学研究院 | The method for designing of formulae discovery instrument and design system thereof in power information system |
| CN104167736B (en) * | 2014-09-04 | 2016-08-24 | 国家电网公司 | A kind of bulk power grid parallel network topology analyzing method |
-
2017
- 2017-03-10 CN CN201710142421.1A patent/CN106920047B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP2453381A2 (en) * | 2009-07-07 | 2012-05-16 | Electronics and Telecommunications Research Institute | System for an engine for forecasting cyber threats and method for forecasting cyber threats using the system |
| CN103093043B (en) * | 2013-01-09 | 2015-08-05 | 中国电力科学研究院 | The method for designing of formulae discovery instrument and design system thereof in power information system |
| CN103500157A (en) * | 2013-09-02 | 2014-01-08 | 用友软件股份有限公司 | Device and method for filling form based on dynamic formula |
| CN104167736B (en) * | 2014-09-04 | 2016-08-24 | 国家电网公司 | A kind of bulk power grid parallel network topology analyzing method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106920047A (en) | 2017-07-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111064614B (en) | Fault root cause positioning method, device, equipment and storage medium | |
| CN110543697B (en) | Electric power market simulation running system | |
| CN109739742B (en) | Service data checking method, device and equipment | |
| CN102204168B (en) | Method and apparatus for network traffic simulation | |
| CN106920047B (en) | Power grid statistical data derivation calculation method and system based on hierarchical storage model | |
| CN112217207A (en) | Transient voltage stability margin prediction method and device | |
| CN102609501B (en) | Data cleaning method based on real-time historical database | |
| CN109711849B (en) | Ether house address portrait generation method and device, electronic equipment and storage medium | |
| CN111027197A (en) | Simulation analysis system and method for power equipment | |
| CN113904915A (en) | Intelligent power communication fault analysis method and system based on Internet of things | |
| Ismail et al. | Principal component regression with artificial neural network to improve prediction of electricity demand. | |
| CN111723462A (en) | Visualization method and system for simulation calculation data of power system | |
| CN111401789A (en) | Building construction intelligent supervision system based on BIM | |
| CN115577927A (en) | Important power consumer electricity utilization safety assessment method and device based on rough set | |
| CN114860759A (en) | Data processing method, device and equipment and readable storage medium | |
| CN108805603A (en) | Marketing activity method for evaluating quality, server and computer readable storage medium | |
| CN111737245B (en) | Method and equipment for automatically repairing connectivity of road network | |
| CN112685456A (en) | User access data processing method and device and computer system | |
| CN112819647B (en) | Real-time prediction method and device for transient stability after power grid fault | |
| CN117933732B (en) | Enterprise big data analysis processing system based on cloud computing | |
| CN114024302B (en) | Method and device for evaluating a region | |
| CN117268594B (en) | Intelligent terminal NTC function test method, system and medium | |
| CN112612996B (en) | Sampling time granularity selection method and device, electronic equipment and storage medium | |
| CN112307301B (en) | Rule adjustment method and device based on network data analysis traceability | |
| CN116109120B (en) | Industrial equipment management sharing system and management sharing method thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |