CN103544396B - Integrated electric energy settlement platform based on flexible data processing - Google Patents
Integrated electric energy settlement platform based on flexible data processing Download PDFInfo
- Publication number
- CN103544396B CN103544396B CN201310524936.XA CN201310524936A CN103544396B CN 103544396 B CN103544396 B CN 103544396B CN 201310524936 A CN201310524936 A CN 201310524936A CN 103544396 B CN103544396 B CN 103544396B
- Authority
- CN
- China
- Prior art keywords
- data
- field
- formula
- definition
- name
- 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
- 238000012545 processing Methods 0.000 title abstract description 7
- 238000004364 calculation method Methods 0.000 claims abstract description 7
- 238000000034 method Methods 0.000 claims description 25
- 238000013480 data collection Methods 0.000 claims description 23
- 230000005611 electricity Effects 0.000 claims description 14
- 238000004321 preservation Methods 0.000 claims description 13
- 230000008569 process Effects 0.000 claims description 13
- 230000001747 exhibiting effect Effects 0.000 claims description 9
- 238000013507 mapping Methods 0.000 claims description 9
- 238000012423 maintenance Methods 0.000 claims description 6
- 238000000605 extraction Methods 0.000 claims description 4
- 239000000203 mixture Substances 0.000 claims description 4
- 230000008520 organization Effects 0.000 claims description 4
- 238000000889 atomisation Methods 0.000 claims description 3
- 238000006243 chemical reaction Methods 0.000 claims description 3
- 238000013502 data validation Methods 0.000 claims description 3
- 239000000284 extract Substances 0.000 claims description 3
- 230000003993 interaction Effects 0.000 claims description 3
- 238000001914 filtration Methods 0.000 claims description 2
- 235000013399 edible fruits Nutrition 0.000 claims 1
- 230000008859 change Effects 0.000 abstract description 8
- 238000011161 development Methods 0.000 abstract description 8
- 238000013461 design Methods 0.000 abstract description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 230000006978 adaptation Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 230000008878 coupling Effects 0.000 description 1
- 238000010168 coupling process Methods 0.000 description 1
- 238000005859 coupling reaction Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004899 motility Effects 0.000 description 1
- 239000002245 particle Substances 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
Abstract
The invention relates to a settlement platform in the field of electric power automation, in particular to an integrated electric energy settlement platform based on flexible data processing. Functions of the settlement platform are resolved into data set definition, formula definition, formula calculation and data display. A data frame design for supporting the platform functions includes a data item, a data area, a work area and a result area, and finally the integrated electric power settlement platform is designed, researched and developed through a computer system. By conducting overall modeling and function supporting on electric power settlement, a series of problems caused by electric power settlement difference requirements are solved effectively, and the problem that the whole system software cost is continuously increased due to the fact that electric energy settlement systems of different province networks can only build their own different systems according to local settlement business rules and the systems are always upgraded and maintained along with development and change of settlement business is solved.
Description
Technical field
The present invention relates to a kind of settlement platform of field of electric power automation and in particular to a kind of based on flexible data process
Integrated electric energy settlement platform.
Background technology
Because the electric network composition of each provinces and regions is different, the level of economic development is unbalanced, relevant policies and electric energy market settlement difference
Larger.With the construction of intelligent grid, mutually Ji promotes the trading volume between each net province to increase sharply to large-scale electric power energy, each net
The coupling saving clearing is more and more stronger, needs the settlement platform setting up integration badly, realizes the unified support of electric energy clearing.
For electricity settlement system, before certain motility is had based on market settlement storehouse or clearing algorithms library etc.
Settlement method, but there is no the diversity demand to electric energy to carry out modeling of overall importance and function and support, more cannot adaption demand
Development and change.Therefore, the electricity settlement system that each net saves all sets up different systems according to local account settlement business rule, with
The development and change of account settlement business, system upgrade maintenance state all the time, overall systems soft ware cost continues higher.
Content of the invention
For the deficiencies in the prior art, it is an object of the invention to provide a kind of integrated electric energy based on flexible data process
Settlement platform, by setting up the calculating platform of data-oriented process, by self-defining mode, is input data, the number of electric energy
According to process, data preserve, data exhibiting provide overall process tool calculating platform, effectively solving electric energy clearing face there is no
The diversity demand of electric energy is carried out with modeling of overall importance support with function, more cannot adaption demand development and change, and respectively
The electricity settlement system that net saves all sets up different systems according to local account settlement business rule, and the development with account settlement business becomes
Change, system upgrade maintenance state all the time, overall systems soft ware cost continues a higher difficult problem.
The purpose of the present invention is to be realized using following technical proposals：
The present invention provides a kind of integrated electric energy settlement platform based on flexible data process, and described platform is data-oriented
The calculating platform processing, it thes improvement is that, described platform includes DSD module, the public affairs carrying out data interaction successively
Formula definition module, formula computing module data display module；Described DSD module, formula definition module, formula meter
Calculate the service that module data display module all calls bottom calculating platform；
The energy data of described DSD module comes from data set, and the energy data in described data set comes from
Data item, forms energy data working area, described work by the data set that formula definition module and formula computing module are processed
The energy data in area preserves to electric energy checkout result storehouse.
Further, described data item is the atomization model in settlement data source；Described settlement data source includes：
The data of electricity transaction operation system：Contract dataset, transaction data, planning data and model data；
The data of TMR coulomb collection system：Meter ins and outs data and meter electric quantity data；
The data of manual metering declaration system：Meter ins and outs data and meter electric quantity data.
Further, described data field is the set of data item, and that is, data field is the data item composition of same data structure；
Data field includes the title of data field, data pick-up source, data row, data subject data area field；
Data set is on the basis of data field, the field of the target table definition, data field and object table in integrated data area
Mapping definition, data period definition, come into force, Expiration Date definition information.
Further, described working area is the scratchpad area (SPA) of data field, during every monthly billing, the electric energy of input is prepared number
According to being loaded onto working area, obtain checkout result after the calculating of clearing, be stored in working area；
Fruiting area be checkout result storehouse, for working area data validation errorless after, submit it preservation to checkout result
Area, the data entering fruiting area is issued as checkout result.
Further, described DSD module is used for realizing the acquisition of energy data, the tissue of data and data
Preservation, including：Bottom data collection defines submodule, secondary data collection defines submodule, object table mapping submodule and definition
Source arranges submodule.
Further, bottom data collection is system-oriented underlying database, and described bottom data collection defines submodule the bottom of to
Layer data storehouse is packaged, and as data structure adapter, realizes the data structure conversion of different system, described bottom data collection
Define submodule and determine that content includes：
（1）Determine data field essential information：Including data field title, the typing of data field type of subject information and maintenance；
（2）Determine data field extracted data source：Including three kinds of modes：
One is to carry out configurationization based on table name table, domain name table and main foreign key relationship；
Two is to be extracted based on SQL, according to data item data structure by SQL group organization data；With
Three is to carry out secondary definition based on existing data field, which using defined data field as tables of data,
Obtain derivative data field；
（3）Determine the field of data field：Every string of the multi-column data of extraction is defined as a field by data field, and from
Define the Chinese domain name of each field；The definition that the field of data field first passes through data field extracts automatically, then to extraction
Field out is defined；The field of data field is expansible, supports the field of most 128 numeric types；
（4）Determine the preservation form of data field：The object table that the setting of each data field preserves, setting data field is to single goal
The write back data function of table；
For the setting of object table, configure the table name of the corresponding object table in this data field, and the field to data field first
Mapped with the field of result table, main, foreign key relationship is finally set（Primary key relationships are the major keys arranging this table（One field
Or multiple field）It is made up of which field, and Data Source is set, foreign key relationship is the foreign key field arranging this table to other tables
Major key adduction relationship）And constraints（Constraints be some fields fixation in this table is set as preset normal
Amount）.
Further, secondary data collection is defined as service-oriented, the definition of application oriented business datum, is used by system operatio
Family completes, and described secondary data collection defines submodule and determines that content includes：
A, determine the essential information of data set：Setting dataset name, selects defined data set as the base inherited
Plinth data set；Information according to former data set is automatically generated by its type of subject, field name, result table map information；
B, the secondary definition of data set：On the basis of the data set inherited, the data of the former data set of preview, including data
All domains of collection；The state that dynamic setting filtercondition preservation is currently set；Described filtercondition include " with or, non-" patrol
The relation of collecting and the relation being combined filtration by " bracket ".
Further, described formula definition module is used for realizing the mathematical operation between energy data, including：
<1>Determine formula essential information：Including the title of formula, coding, calculating cycle, entry-into-force time and out-of-service time；
<2>Determine formula component：Reference data collection, its expression formula be dataset name. field name, simultaneously specify master
Body, expression formula now be dataset name. field name. main body name }；
<3>Determine the calculated relationship of formula：The calculated relationship of formula is expressed as the mathematical operation relation between formula component,
Including " addition subtraction multiplication and division " four arithmetic operation, preset function and self-defining function；
<4>Determine the function of formula：Including preset function and self-defining function, wherein self-defining function includes class class
And the function two ways of data base：
A, preset function include maximum max（）, minima min（）, first first（）With the last item last（）；
The mode of b, class class function includes the Chinese of function, functional based method name, |input paramete and class class
Path；To in class function, the parameter of input includes Chinese name, parameter name, parameter type and the parameter sequence number of parameter；
C, the mode of data base's function function include the Chinese of function, functional based method name, |input paramete and
Package bag path.
Further, formula computing module calls defined formula, according to the component data in formula and mathematics fortune
Calculation is calculated, and obtains electric energy checkout result, comprises the steps：
Step S1, data pick-up：Obtain the formula associated by each clearing unit or economic unit, for the calculating in formula
Component, the settlement data source definition according to component obtains the data of component；
Step S2, data calculate：After obtaining formula component data, according to the calculated relationship of formula, by Formula Parsing with
Function parses, and obtains the result of calculation of formula；
Step S3, save workspace：The checkout result of calculating is preserved to working area, working area retains and includes of that month data
In the data of interior most a year；
Step S4, submission preserve：Temporary working area data is submitted to and preserves to formal checkout result storehouse.
Further, described data exhibiting module is used for the data set to setting and computing formula, with self-defined template
Mode carries out data exhibiting, including：
I, model customization：The interface customizing based on cell for the setting；The customization setting at interface includes two aspects：One is solid
Fixed textual display portion；Two is dynamic data display unit；
II, formula show：Chinese to defined data set field, the Chinese that formula defines content is carried out
Display；
III, data display：The data result of data set and formula is shown.
Compared with the prior art, the beneficial effect that the present invention reaches is：
1st, the present invention, by setting up the calculating platform of data-oriented process, by self-defining mode, is the input of electric energy
Data, data processing, data preservation, the calculating platform of data exhibiting offer overall process tool, effectively solving electric energy settles accounts face
That faces there is no the diversity demand to electric energy to carry out modeling of overall importance and function to support, and more cannot the development of adaption demand become
Change, and the electricity settlement system that each net saves all sets up different systems according to local account settlement business rule, with clearing industry
The development and change of business, system upgrade maintenance state all the time, overall systems soft ware cost continues a higher difficult problem.
2nd, the present invention constructs based on data pick-up, data calculating, the definable flexible clearing side of data exhibiting overall process
Method, function includes DSD, formula definition, formula calculating and data exhibiting, realizes power plants generating electricity clearing and net are saved
Between interconnection clearing integration support.
3rd, the data set that this method is set up is obtained by the extraction mapping definition realization clearing input data between data base
Take, the formula definition of foundation is by the operation relation between mathematical relationship expression data and data, and supports function expansion, finally
There is provided displaying interface in the way of self-defined template, this method for designing is solved settlement system and bound with business rule and bring
The difficulties of autgmentability difference, by tool, hardware and software platform calculating platform it is achieved that flexible support to data processing, and
Common software product can be changed into by towards triangular web.
4th, the present invention establishes electric energy settlement platform, provides one for interconnection clearing between power plants generating electricity clearing and net province
Change calculating platform it is achieved that supporting and parallel processing to the unified of the whole network clearing.Meanwhile, this technology passes through the faces such as data adapter unit
To the processing scheme of computer, can flexible adaptation other business and other industry, there is very wide application and popularization value.
Brief description
Fig. 1 is the electric energy settlement data flow graph that the present invention provides；
Fig. 2 is the electric energy settlement function Organization Chart that the present invention provides.
Specific embodiment
Below in conjunction with the accompanying drawings the specific embodiment of the present invention is described in further detail.
The present invention relates to the integrated electric energy settlement platform being processed based on flexible data, first the function of settlement platform is entered
Row decomposes, and including DSD, formula definition, formula calculating, four parts of data exhibiting, and proposes support platform function
Data framework design, including data item, data field, working area and fruiting area, finally by computer system, design and grind
Send out integrated electric energy settlement platform.By said method and technological means it is achieved that power plants generating electricity clearing and net are got in touch between saving
The unification that knot is calculated is supported, is realized the whole network concentration clearing by integrated settlement platform, flexibly supports and adapts to electric energy and settle accounts industry
The growth requirement of business.
The calculating platform that described platform is processed for data-oriented, including the DSD mould carrying out data interaction successively
Block, formula definition module, formula computing module data display module；Described DSD module, formula definition module, public affairs
Formula computing module data display module all calls the service of bottom calculating platform；The electric energy settlement function framework that the present invention provides
Figure is as shown in Figure 2.
The energy data of described DSD module comes from data set, and the energy data in described data set comes from
Data item, forms the working area of energy data, described work by the data set that formula definition module and formula computing module are processed
Make the energy data in area to preserve to electric energy checkout result storehouse.The electric energy settlement data flow graph that the present invention provides is as shown in Figure 1.
1. data item：
Data item is the atomization model in settlement data source, i.e. the minimum particle size of settlement data, and data item includes every knot
Point counting item（Generally contract, transaction, examination etc.）Electricity, electricity price, the information such as the electricity charge.The input data of clearing and output number
According to data structure identical, be the set of data item.Therefore, the process of clearing is by the data acquisition system of one group of input, passes through
Clearing are calculated the data acquisition system of another group of output.
Settlement data source includes：
The data of electricity transaction operation system：Contract dataset, transaction data, planning data and model data；
The data of TMR coulomb collection system：Meter ins and outs data and meter electric quantity data；
The data of manual metering declaration system：Meter ins and outs data and meter electric quantity data.
2. data field：
Data field is the set of data item, and that is, data field is the volume of data item composition of same data structure.Data field
Definition include the title of data field, data pick-up source, data row, data subject, data field field definition etc..
3. data set：
Data set is on the basis of data field, the field of the target table definition, data field and object table in integrated data area
Mapping definition, data period definition, come into force, the Expiration Date definition etc. information, data field is the important component part of data set, number
It is the expanded definition to data field according to collection.
4. working area：
Working area is the scratchpad area (SPA) of data field, the preparation data of input can be loaded onto working area during every monthly billing,
Obtain checkout result after the calculating of clearing, working area can be stored in.
5. fruiting area：
Fruiting area is formal checkout result storehouse, for working area data validation errorless after, can submit it preservation to tie
Calculate fruiting area, the data only entering checkout result area could be issued as formal checkout result.
（One）DSD module is used for realizing the preservation of the acquisition of energy data, the tissue of data and data, bag
Include：Bottom data collection defines submodule, secondary data collection defines submodule, object table mapping submodule and the source that defines arrange submodule
Block.
The definition of bottom data collection is the definition of system-oriented underlying database, and described bottom data collection defines submodule the bottom of to
Layer data storehouse is packaged, and as data structure adapter, realizes the data structure conversion of different system, described bottom data collection
Define submodule definition content to include：
（1）Data field essential information definition：Including data field title, the typing of data field type of subject information and maintenance；
（2）Data field extracted data source defines：Including three kinds of definition modes：One be for based on table name table, domain name table and
Main foreign key relationship carries out configurationization definition, and simply, clearly tables of data is more applicable for main foreign key relationship for which；Two is base
Extracted in SQL, SQL flexible organization data can be passed through according to the data structure of data item, the method is applied to data structure
Situation that is more complicated or quoting external system data source；Three is to carry out secondary definition based on existing data field, and which is by
Defined data field to be treated as tables of data, obtains derivative data field.
（3）The field definition of data field：Data field is to the multi-column data extracting（Each column is referred to as a field）Self-defined
The Chinese domain name of each field, different data fields can have different Field Counts and field name.The field of data field is logical first
The definition crossing data field extracts automatically, then the field extracting is defined.The field of data field is expansible, can prop up
Hold the field of most 128 numeric types.
（4）The preservation definition of data field：Each data field can arrange the object table of preservation, realizes data field at present to single table
Write back data function, if this data field need not preserve also can not arrange.For the setting of object table, configure this data first
The table name of the corresponding object table in area, and the field to data field mapped with the field of result table, finally arranges main, external key and closes
System and constraints.
Secondary data collection is defined as service-oriented, the definition of application oriented business datum, is completed by System Operation User, institute
State secondary data collection definition submodule definition content to include：
A, the essential information definition of data set：Setting dataset name, selects defined data set as the base inherited
Plinth data set.Now, the information such as its type of subject, field name, the mapping of result table is automatic by the information according to former data set
Generate.
B, the secondary definition of data set：On the basis of the data set inherited, can the former data set of preview data, including number
All domains according to collection.Afterwards, it is dynamically arranged filtercondition, by the setting of condition, the scope of data of its preview changes therewith,
Until when meeting demand, the state being currently set can be preserved, now establishes the data set of secondary definition.Here, filtercondition
Multiple conditions can be set, support between each filtercondition " with or, non-" logical relation and be combined by " bracket "
Filter.
（Two）Formula definition module：Expression is the mathematical operation relation between field and field in the data set defining.
The clearing of the component of formula and formula are the field of data set, and each component can be the field under same data set,
Can also be the field of different pieces of information collection, including：
<1>Formula essential information defines：Including the title of formula, coding, calculating cycle, entry-into-force time and out-of-service time；
<2>Formula component defines：Quote defined data set, its expression formula be dataset name. field name, with
When can also specify main body, expression formula now be dataset name. field name. main body name }.Participate in the component that formula calculates
And formulae results are all formula components.
<3>The calculated relationship definition of formula：The calculated relationship of formula is expressed as the mathematical operation relation between formula component.
Support conventional " addition subtraction multiplication and division " four arithmetic operation, additionally, also supporting preset function and self-defining function.
<4>The function definition of formula：Including preset function and self-defining function, wherein self-defining function includes class class
And the function two ways of data base：
A, preset function include maximum max（）, minima min（）, first first（）With the last item last（）；
The mode of b, class class function includes the Chinese of function, functional based method name, |input paramete and class class
Path；To in class function, the parameter of input includes Chinese name, parameter name, parameter type and the parameter sequence number of parameter；
C, the mode of data base's function function include the Chinese of function, functional based method name, |input paramete and
Package bag path.The parameter of input supports that extension is multiple.
（Three）Formula computing module：It is to call defined formula, according to data and the mathematical relationship of component in formula
Calculated, obtained result of calculation.Result of calculation can be preserved to working area after calculating, and formal clearing can be committed to further
Results repository.Comprise the steps：
Step S1, data pick-up：Obtain each clearing unit（Or economic unit）Associated formula, for the meter in formula
Point counting amount, the settlement data source definition according to component obtains the data of component；
Step S2, data calculate：After obtaining component data, according to the calculated relationship of formula, by Formula Parsing function
Parsing, obtains the result of calculation of formula；
Step S3, the result of calculating is preserved to working area, working area, as temporary buffer, only retains and includes this month number
According in the data of interior most a year；
Step S4, submission preserve：Temporary working area data is submitted to and preserves to formal checkout result storehouse.
（Four）Data exhibiting module：To the data set of setting, computing formula, carry out data exhibition in the way of self-defined template
Existing.Template layout is customizable, realizes conveniently, intuitively representing effect.
I, model customization.There is provided and be based on cell（Class Excel）Interface customizing function.The customization setting at interface includes two
Individual aspect：One is fixing textual display portion, and this part can cell be passed through to be manually entered to be configured；Two is dynamically to count
According to display portion, this part is configured with the mapping relations of the field of data set by setting up cell, and preserving in module should
The string expression of this data set of cell reference.
II, formula show.The Chinese of defined data set field can be checked in a template, can simultaneously for formula
It is directly viewable the content of formula definition, the content of definition is similarly shown with Chinese.For example：Meter data set. just
To active .#3601 critical point+meter data set. positive active .#3602 critical point.
III, data display.The data result of data set and formula after calculating, can be checked, for example：34534.1423
(meter data set. positive active .#3601 critical point)+45642.7645 (meter data set. positive active .#3602 critical point).
The present invention provide based on flexible data process integrated electric energy settlement platform it is achieved that power plants generating electricity clearing and
Between net province, the unified of interconnection clearing is supported, is realized the whole network concentration clearing by integrated settlement platform, flexibly supports and adapts to
The growth requirement of electric energy account settlement business.
Finally it should be noted that：Above example is only not intended to limit in order to technical scheme to be described, to the greatest extent
Pipe has been described in detail to the present invention with reference to above-described embodiment, and those of ordinary skill in the art should be understood：Still
The specific embodiment of the present invention can be modified or equivalent, and any without departing from spirit and scope of the invention
Modification or equivalent, it all should be covered in the middle of scope of the presently claimed invention.
Claims (1)
1. a kind of integrated electric energy settlement platform based on flexible data process, described platform is put down for the calculating that data-oriented is processed
Platform is it is characterised in that described platform includes carrying out successively the DSD module of data interaction, formula definition module, formula
Computing module data display module；Described DSD module, formula definition module, formula computing module data represent
Module all calls the service of bottom calculating platform；
The energy data of described DSD module comes from data set, and the energy data in described data set comes from data
, energy data working area is formed by the data set that formula definition module and formula computing module are processed, described working area
Energy data preserves to electric energy checkout result storehouse；
Described data item is the atomization model in settlement data source；Described settlement data source includes：
The data of electricity transaction operation system：Contract dataset, transaction data, planning data and model data；
The data of TMR coulomb collection system：Meter ins and outs data and meter electric quantity data；
The data of manual metering declaration system：Meter ins and outs data and meter electric quantity data；
Described data field is the set of data item, and that is, data field is the data item composition of same data structure；Data field includes counting
According to the title in area, data pick-up source, data row, data subject data area field；
Data set is on the basis of data field, the field mapping of the target table definition, data field and object table in integrated data area
Definition, data period definition, come into force, Expiration Date definition information；
Described working area is the scratchpad area (SPA) of data field, during every monthly billing, the electric energy of input is prepared data and is loaded onto work
Area, obtains checkout result after the calculating of clearing, is stored in working area；
Fruiting area be checkout result storehouse, for working area data validation errorless after, submit it preservation to checkout result area, enter
The data entering fruiting area is issued as checkout result；
Described DSD module is used for realizing the preservation of the acquisition of energy data, the tissue of data and data, including：Bottom
Layer data collection defines submodule, secondary data collection defines submodule, object table mapping submodule and the source that defines arrange submodule；
Bottom data collection is system-oriented underlying database, and described bottom data collection defines submodule and underlying database is sealed
Dress, as data structure adapter, realizes the data structure conversion of different system, described bottom data collection defines submodule and determines
Content includes：
(1) determine data field essential information：Including data field title, the typing of data field type of subject information and maintenance；
(2) determine data field extracted data source：Including three kinds of modes：
One is to carry out configurationization based on table name table, domain name table and main foreign key relationship；
Two is to be extracted based on SQL, according to data item data structure by SQL group organization data；With
Three is to carry out secondary definition based on existing data field, and defined data field as tables of data, is obtained by which
Derivative data field；
(3) determine the field of data field：Every string of the multi-column data of extraction is defined as a field by data field, and self-defined
The Chinese domain name of each field；The definition that the field of data field first passes through data field extracts automatically, then to extracting
Field be defined；The field of data field is expansible, supports the field of most 128 numeric types；
(4) determine the preservation form of data field：The object table that the setting of each data field preserves, setting data field is to single goal table
Write back data function；
For the setting of object table, configure the table name of the corresponding object table in this data field, and the field to data field and knot first
The field of fruit table is mapped, and finally arranges main, foreign key relationship and constraints；
Secondary data collection is defined as service-oriented, the definition of application oriented business datum, is completed by System Operation User, described two
Secondary data collection defines submodule and determines that content includes：
A, determine the essential information of data set：Setting dataset name, selects defined data set as the basic number inherited
According to collection；Information according to former data set is automatically generated by its type of subject, field name, result table map information；
B, the secondary definition of data set：On the basis of the data set inherited, the data of the former data set of preview, including data set
All domains；The state that dynamic setting filtercondition preservation is currently set；Described filtercondition include " with or, non-" logic close
System and the relation being combined filtration by " bracket "；
Described formula definition module is used for realizing the mathematical operation between energy data, including：
<1>Determine formula essential information：Including the title of formula, coding, calculating cycle, entry-into-force time and out-of-service time；
<2>Determine formula component：Reference data collection, its expression formula be dataset name. field name, simultaneously specify main body, this
When expression formula be dataset name. field name. main body name }；
<3>Determine the calculated relationship of formula：The calculated relationship of formula is expressed as the mathematical operation relation between formula component, including
" addition subtraction multiplication and division " four arithmetic operation, preset function and self-defining function；
<4>Determine the function of formula：Including preset function and self-defining function, wherein self-defining function include class class and
The function two ways of data base：
A, preset function include maximum max (), minima min (), first first () and the last item last ()；
The mode of b, class class function includes the Chinese of function, functional based method name, |input paramete and class class road
Footpath；To in class function, the parameter of input includes Chinese name, parameter name, parameter type and the parameter sequence number of parameter；
C, the mode of data base's function function include the Chinese of function, functional based method name, |input paramete and
Package bag path；
Formula computing module calls defined formula, is calculated according to the component data in formula and mathematical operation, obtains
To electric energy checkout result, comprise the steps：
Step S1, data pick-up：Obtain the formula associated by each clearing unit or economic unit, the calculating in formula is divided
Amount, the settlement data source definition according to component obtains the data of component；
Step S2, data calculate：After obtaining formula component data, according to the calculated relationship of formula, by Formula Parsing function
Parsing, obtains the result of calculation of formula；
Step S3, save workspace：The checkout result of calculating is preserved to working area, working area retains including of that month data
The data of most 1 year；
Step S4, submission preserve：Temporary working area data is submitted to and preserves to formal checkout result storehouse；
Described data exhibiting module is used for the data set and computing formula to setting, carries out data exhibition in the way of self-defined template
Existing, including：
I, model customization：The interface customizing based on cell for the setting；The customization setting at interface includes two aspects：One is fixing
Textual display portion；Two is dynamic data display unit；
II, formula show：Chinese to defined data set field, the Chinese that formula defines content is shown
Show；
III, data display：The data result of data set and formula is shown.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310524936.XA CN103544396B (en) | 2013-10-30 | 2013-10-30 | Integrated electric energy settlement platform based on flexible data processing |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310524936.XA CN103544396B (en) | 2013-10-30 | 2013-10-30 | Integrated electric energy settlement platform based on flexible data processing |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103544396A CN103544396A (en) | 2014-01-29 |
| CN103544396B true CN103544396B (en) | 2017-02-08 |
Family
ID=49967841
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310524936.XA Active CN103544396B (en) | 2013-10-30 | 2013-10-30 | Integrated electric energy settlement platform based on flexible data processing |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103544396B (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104318337B (en) * | 2014-07-25 | 2018-01-19 | 国家电网公司 | A kind of modeling method of electricity market member economic model and data model |
| CN104715408B (en) * | 2015-03-19 | 2017-11-07 | 烟台海颐软件股份有限公司 | A kind of electricity transaction the Visual Implementation method based on clearing unit |
| CN108288225B (en) * | 2017-05-28 | 2022-09-23 | 国网山东省电力公司临邑县供电公司 | Electric power transaction implementation method based on electric power transaction platform |
| CN110134685A (en) * | 2019-05-06 | 2019-08-16 | 武汉中岩测控技术有限公司 | A kind of monitoring method and system based on big data field automatic Mosaic algorithm |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1363219A1 (en) * | 2002-05-15 | 2003-11-19 | Kabushiki Kaisha Toshiba | Price evaluation system and method for derivatives, risk management system and method for power exchange |
| CN101794424A (en) * | 2010-01-29 | 2010-08-04 | 华东电网有限公司 | Self-adaptive unified power market transaction method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4125071B2 (en) * | 2002-08-20 | 2008-07-23 | 中国電力株式会社 | Risk-responsive electricity bill proposal support apparatus, risk-responsive bill proposal support method, and program for causing computer to execute the method |
-
2013
- 2013-10-30 CN CN201310524936.XA patent/CN103544396B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1363219A1 (en) * | 2002-05-15 | 2003-11-19 | Kabushiki Kaisha Toshiba | Price evaluation system and method for derivatives, risk management system and method for power exchange |
| CN101794424A (en) * | 2010-01-29 | 2010-08-04 | 华东电网有限公司 | Self-adaptive unified power market transaction method |
Non-Patent Citations (1)
| Title |
|---|
| 《基于构件库的柔性电能结算方法》;龙苏岩;《电力系统自动化》;20130725;第37卷(第14期);第1-2节 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103544396A (en) | 2014-01-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103019742B (en) | A kind of real time workshop method in many DSP platform | |
| CN103544396B (en) | Integrated electric energy settlement platform based on flexible data processing | |
| Mardani et al. | Measuring technical efficiency of potato production in Iran using robust data envelopment analysis | |
| CN106096870A (en) | A kind of performance data treating method and apparatus | |
| CN106921702B (en) | It is a kind of based on service-oriented power distribution network information physical system | |
| CN106651221A (en) | General power enterprise data analysis platform based on state grid index system | |
| Zhang et al. | Second use value of China’s new energy vehicle battery: A view based on multi-scenario simulation | |
| CN106372074A (en) | Construction method for visualization system of risk assessment of contaminated site | |
| CN103116827A (en) | Rural power grid engineering control system | |
| CN102163248B (en) | Advanced synthesizing method for integrated circuit | |
| CN102541540A (en) | Starry telemetry parameter imaging configuration system | |
| CN109189865A (en) | The overall analysis system and method for project data | |
| CN108170425A (en) | A kind of amending method of program code, modification device and terminal device | |
| CN104715408B (en) | A kind of electricity transaction the Visual Implementation method based on clearing unit | |
| CN104504533A (en) | Medical system establishing method and medical system establishing device | |
| CN104615794B (en) | For the mathematical model construction method in three-dimensional electric wiring software | |
| CN108876577A (en) | The system that multilingual mobile visualization collects processing information | |
| CN107807992A (en) | Barcode scanning multiplies public transport payment system | |
| CN109919419A (en) | A kind of enterprise innovation element project evaluation chain method | |
| CN107247594A (en) | Flogic system and its implementation, computing device and computer-readable recording medium | |
| Liu et al. | Optimal scheduling of logistical support for medical resources order and shipment in community health service centers | |
| CN104484230A (en) | Multiple satellite data centre workflow scheduling algorithm on basis of near data calculation principle | |
| CN108062681A (en) | The task pricing method and system of a kind of task subpackage platform | |
| CN112686755A (en) | Market settlement system and method based on settlement model scheme configuration | |
| CN107194529A (en) | A kind of distribution network reliability analysis method of economic benefit based on Text Mining Technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20150929 Address after: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant after: State Grid Corporation of China Applicant after: STATE GRID SHANXI ELECTRIC POWER CO., LTD. Applicant after: China Electric Power Research Institute Address before: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant before: State Grid Corporation of China Applicant before: China Electric Power Research Institute |
|
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |