CN103914501A - Power industry real-time reporting method based on massive real-time database - Google Patents
Power industry real-time reporting method based on massive real-time database Download PDFInfo
- Publication number
- CN103914501A CN103914501A CN201310494306.2A CN201310494306A CN103914501A CN 103914501 A CN103914501 A CN 103914501A CN 201310494306 A CN201310494306 A CN 201310494306A CN 103914501 A CN103914501 A CN 103914501A
- Authority
- CN
- China
- Prior art keywords
- real
- time
- data
- excel
- formula
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000005516 engineering process Methods 0.000 claims description 11
- 238000005538 encapsulation Methods 0.000 claims description 3
- 238000001914 filtration Methods 0.000 claims description 3
- 238000005070 sampling Methods 0.000 claims description 3
- 238000004458 analytical method Methods 0.000 abstract description 2
- 238000004519 manufacturing process Methods 0.000 abstract 1
- 238000004806 packaging method and process Methods 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000000630 rising effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2477—Temporal data queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- 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
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Economics (AREA)
- General Engineering & Computer Science (AREA)
- Mathematical Physics (AREA)
- Water Supply & Treatment (AREA)
- Data Mining & Analysis (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Software Systems (AREA)
- Fuzzy Systems (AREA)
- Databases & Information Systems (AREA)
- Public Health (AREA)
- Probability & Statistics with Applications (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a power industry real-time reporting method based on a massive real-time database and belongs to the technical field of power system automation. When an Excel user-defined formula is compiled, a data acquisition interface provided by the massive real-time database of a power system is utilized to achieve acquisition of required data by the formula according to requirements of power automation and informatization to report business data and statistic data, then COM class base packaging and registering of the compiled formula is finished, the compiled formula is added into the Excel in an automatic loading item mode in an Excel loading item, and finally the compiled formula is utilized to acquire and update real-time data in the massive real-time database of the power system in real time in a real-time report client interface to form the real-time report. The method solves the problem that massive data reports in the power industry are complex in manufacture, and data statistic analysis consumes long time. By means of the method, users can quickly customize required individual report templates to achieve real-time reporting.
Description
Technical field
The invention belongs to power system automation technology field, particularly relate to the real-time report method of a kind of power industry based on magnanimity real-time data base.
Background technology
Power industry robotization now and the level of informatization are more and more higher, and the thing followed is the sharply rising of data acquisition and storage size, and in order to meet the requirement of electrical network fine-grained management, data acquiring frequency is also more and more higher.Therefore, adapt to Automation of Electric Systems and informationalized development in order to meet, magnanimity real-time data base is being widely used power industry.But, in the face of the data of magnanimity like this, how to customize fast statistical report forms such as generating daily paper, monthly magazine, annual report and personalized real-time form to assist management decision, just become a major issue of needing solution badly.
The Excel of Microsoft has powerful data analysis, demonstration and computing power, has become the industry standard of office automation.Excel has comprised a lot of built-in formula, as formula such as mathematics, date, text, logics, very convenient, can flexibly and fast process data.Although the built-in formula of Excel is very powerful, while processing concrete business statistics form, it is far from being enough only relying on built-in formula, need to add self-defining formula and carry out service computation and report form statistics.
VSTO is the Office development technique under .Net platform, more powerful Office development platform is provided, the appearance of VSTO technology has improved Office product and concrete business binding ability greatly, can by VSTO technique construction more flexibly, powerful, cross-platform enterprise level solution.Can be by means of VSTO technology the Excel self-defining formula based on COM class libraries.
Summary of the invention
The object of this invention is to provide a kind of real-time report method of the power industry based on magnanimity real-time data base, pass through the method, user can check the real time data of power equipment running state fast, historical data, sampled data, the data message that statistics and computational data etc. are dissimilar, can customize fast daily paper according to personalized form demand, monthly magazine, the polytype report form templates such as annual report, can check at any time the instant report data of report form template, can refresh in real time form real time data, thereby monitor the real time data of real-time form, generate fast statistical report form data, make a policy fast with assisted user.
Specifically, the present invention adopts following technical scheme to realize, and comprises the following steps:
1) in the time of establishment Excel self-defining formula, according to power automation and the information-based requirement to form business datum and statistics, the data acquisition interface of utilizing electric system magnanimity real-time data base to provide, realizes Excel self-defining formula obtaining desired data;
2) the COM class libraries encapsulation of the Excel self-defining formula that utilizes VSTO technology to complete step 1) has been worked out;
3) the procedure set registration tool Regasm.exe that uses .Net to carry registers the COM class libraries of the Excel self-defining formula having encapsulated, and then in Excel add-in, the mode with robotization add-in is added the Excel self-defining formula of having worked out in Excel to;
4) in real-time report client end interface, utilize the Excel self-defining formula Real-time Obtaining worked out, refresh the real time data in electric system magnanimity real-time data base, form real-time form.
Technique scheme is further characterized in that: the desired data of described Excel self-defining formula comprises that the expression formula filtering data of expression formula computational data, certain time period history/sampled value of real time data, the device history data information of certain time period, the equal interval sampling data message of certain time period, polytype statistical information of certain time period, certain time period history/sampled value of power equipment measuring point and device data meet the time statistics of expression formula condition.
Technique scheme is further characterized in that: the data acquisition interface that described electric system magnanimity real-time data base provides, support whether the result set data of obtaining, support of batch device measuring point data are with timestamp.
Beneficial effect of the present invention is as follows: the invention solves power industry Magnanimous Data Report form and make complicated, data statistic analysis longer problem consuming time.The application of the invention, user can customize required personalized report form template fast.As long as open report form template, thereby self-defining formula will automatically calculate and obtains report data generating report forms data automatically and efficiently, use real-time refresh function, thereby the real time data on form can refresh the object that reaches data monitoring in real time.
Accompanying drawing explanation
Fig. 1 is the system architecture diagram of real-time form technology of the present invention.
Fig. 2 is the time format schematic diagram that self-defined Excel formula of the present invention is supported.
Fig. 3 is the rate of qualified voltage statistical report form schematic diagram based on real-time form technology.
Embodiment
With reference to the accompanying drawings and in conjunction with example the present invention is described in further detail.
System architecture of the present invention as shown in Figure 1, is roughly divided into four steps:
Step 1, in the time of establishment Excel self-defining formula, according to power automation and the information-based requirement to form business datum and statistics, the data acquisition interface of utilizing electric system magnanimity real-time data base to provide, realizes Excel self-defining formula obtaining desired data.
Magnanimity real-time data base provides a large amount of data acquisition interface, generally should comprise that the real time data, the device history data information of certain time period, the equal interval sampling data message of certain time period, polytype statistical information of certain time period, the expression formula computational data of certain time period history/sampled value, expression formula filtering data and the device data of certain time period history/sampled value of power equipment measuring point meets time statistics of expression formula condition etc.
Interface is supported obtaining of batch device measuring point data, supports that whether result set data are with timestamp, support the multiple display effects such as result set row, column.The time parameter of data is supported the time showing form of absolute time and two types of multiple patterns of relative time, specifically sees Fig. 2.
Step 2, complete the encapsulation in the COM-AddIn formula storehouse of Excel self-defining formula by VSTO technology.
Add the quoting of Interop.Microsoft.Office.Core.dll and two Office class libraries of Microsoft.Office.Interop.Excel.dll according to the implementation of VSTO technology, then realize registration and anti-register method RegisterFunction and the UnregisterFunction of COM class libraries.
If the data acquisition interface that magnanimity real-time data base provides does not support that Managed Code calls, need to use the envelope feed technique Reseal database interface of Managed Code and unmanaged code.
Deployment and the loading in step 3, Excel formula storehouse.
First use the procedure set registration tool Regasm.exe that .Net carries to register the COM class libraries of having realized; Then in Excel add-in, the mode with robotization add-in is added the Excel formula storehouse of exploitation in Excel to.Develop and added Excel program to for solving the Excel formula storehouse of the power industry service application based on magnanimity real-time data base like this.
Step 4, Excel formula use interface and refresh in real time.
The client end interface of formula is the requisite part that formula uses, can help user not statistical report form and the personalized form in real time such as the required daily paper of customization, monthly magazine, annual report fast solution formula function in the situation that.The client end interface of formula provides with Excel add-in .xla file, provides corresponding operation interface to each formula.Finally, in real-time report client end interface, utilize the Excel self-defining formula Real-time Obtaining worked out, refresh the real time data in electric system magnanimity real-time data base, form real-time form.In client with the data Real-time Obtaining of report form formula in the real-time form of timer mode control and refresh in real time.
The inventive method before disposing and using, should first confirm data collected disposed and the normal magnanimity real-time data base using in, the PC operating system that then requires to use real-time form is for Windows operating system and Office has been installed.If above-mentioned environment is ready, first on PC, use Regasm.exe instrument to register completed Excel self-defining formula storehouse, then in Excel, load this formula storehouse, finally client end interface is put into Excel and starts automatic loading under macrodirectory, form has just been disposed in real time.User just can be by the various required statistical report forms of real-time report client end interface definition, can find that statistics can automatically calculate and be shown in Excel, open this Excel statistics at every turn and all can automatically calculate.Fig. 3 is an example of the real-time form of the inventive method, has provided the rate of qualified voltage statistical conditions based on real-time form technology.
Although the present invention with preferred embodiment openly as above, embodiment is not of the present invention for limiting.Without departing from the spirit and scope of the invention, any equivalence of doing changes or retouching, belongs to equally the present invention's protection domain.Therefore protection scope of the present invention should be take the application's the content that claim was defined as standard.
Claims (3)
1. the real-time report method of the power industry based on magnanimity real-time data base, is characterized in that, comprises the steps:
1) in the time of establishment Excel self-defining formula, according to power automation and the information-based requirement to form business datum and statistics, the data acquisition interface of utilizing electric system magnanimity real-time data base to provide, realizes Excel self-defining formula obtaining desired data;
2) the COM class libraries encapsulation of the Excel self-defining formula that utilizes VSTO technology to complete step 1) has been worked out;
3) the procedure set registration tool Regasm.exe that uses .Net to carry registers the COM class libraries of the Excel self-defining formula having encapsulated, and then in Excel add-in, the mode with robotization add-in is added the Excel self-defining formula of having worked out in Excel to;
4) in real-time report client end interface, utilize the Excel self-defining formula Real-time Obtaining worked out, refresh the real time data in electric system magnanimity real-time data base, form real-time form.
2. the real-time report method of the power industry based on magnanimity real-time data base according to claim 1, it is characterized in that, the desired data of described Excel self-defining formula comprises that the expression formula filtering data of expression formula computational data, certain time period history/sampled value of real time data, the device history data information of certain time period, the equal interval sampling data message of certain time period, polytype statistical information of certain time period, certain time period history/sampled value of power equipment measuring point and device data meet the time statistics of expression formula condition.
3. the real-time report method of the power industry based on magnanimity real-time data base according to claim 1, it is characterized in that, the data acquisition interface that described electric system magnanimity real-time data base provides, supports whether the result set data of obtaining, support of batch device measuring point data are with timestamp.
?
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310494306.2A CN103914501B (en) | 2013-10-21 | 2013-10-21 | The real-time report method of power industry based on magnanimity real-time data base |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310494306.2A CN103914501B (en) | 2013-10-21 | 2013-10-21 | The real-time report method of power industry based on magnanimity real-time data base |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103914501A true CN103914501A (en) | 2014-07-09 |
| CN103914501B CN103914501B (en) | 2018-06-22 |
Family
ID=51040191
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310494306.2A Active CN103914501B (en) | 2013-10-21 | 2013-10-21 | The real-time report method of power industry based on magnanimity real-time data base |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103914501B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105975595A (en) * | 2016-05-09 | 2016-09-28 | 国网浙江省电力公司湖州供电公司 | Data quality monitoring and assessing method of real-time data center |
| CN105975473A (en) * | 2016-01-19 | 2016-09-28 | 北京匡恩网络科技有限责任公司 | Customized trend analysis subsystem |
| CN107562888A (en) * | 2017-09-05 | 2018-01-09 | 北京瑞凯软件科技开发有限公司 | The data sheet generation method and system of a kind of track traffic synthetic monitoring system |
| CN107832279A (en) * | 2017-09-12 | 2018-03-23 | 北京中燕信息技术有限公司 | A kind of method, equipment and computer-readable recording medium for generating form |
| CN107967246A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | Report computational methods and device |
| CN108009131A (en) * | 2017-11-30 | 2018-05-08 | 重庆电力高等专科学校 | User power utilization data exception analysis method based on power information collection |
| CN111488404A (en) * | 2020-04-10 | 2020-08-04 | 粤水电轨道交通建设有限公司 | Method for rapidly compiling monitoring report in Excel |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101944082A (en) * | 2010-09-10 | 2011-01-12 | 中国恩菲工程技术有限公司 | Excel-like report processing method |
-
2013
- 2013-10-21 CN CN201310494306.2A patent/CN103914501B/en active Active
Non-Patent Citations (1)
| Title |
|---|
| 黎浩宏: "利用VSTO技术创建Excel自定义函数的研究", 《硅谷SILICON VALLEY科技创新论坛》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105975473A (en) * | 2016-01-19 | 2016-09-28 | 北京匡恩网络科技有限责任公司 | Customized trend analysis subsystem |
| CN105975595A (en) * | 2016-05-09 | 2016-09-28 | 国网浙江省电力公司湖州供电公司 | Data quality monitoring and assessing method of real-time data center |
| CN105975595B (en) * | 2016-05-09 | 2018-03-23 | 国网浙江省电力公司湖州供电公司 | A kind of real time data centre data quality-monitoring wire examination method |
| CN107967246A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | Report computational methods and device |
| CN107562888A (en) * | 2017-09-05 | 2018-01-09 | 北京瑞凯软件科技开发有限公司 | The data sheet generation method and system of a kind of track traffic synthetic monitoring system |
| CN107832279A (en) * | 2017-09-12 | 2018-03-23 | 北京中燕信息技术有限公司 | A kind of method, equipment and computer-readable recording medium for generating form |
| CN108009131A (en) * | 2017-11-30 | 2018-05-08 | 重庆电力高等专科学校 | User power utilization data exception analysis method based on power information collection |
| CN111488404A (en) * | 2020-04-10 | 2020-08-04 | 粤水电轨道交通建设有限公司 | Method for rapidly compiling monitoring report in Excel |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103914501B (en) | 2018-06-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103914501A (en) | Power industry real-time reporting method based on massive real-time database | |
| US20180012145A1 (en) | Machine learning based analytics platform | |
| US8131686B2 (en) | Data migration factory | |
| CN101867494B (en) | Soft hardware performance monitoring method based on monitoring template, and system thereof | |
| CN106445484A (en) | Method and system for realizing data tracking through software development kit | |
| CN102520619B (en) | General-purpose satellite remote sensing simulator | |
| CN115034638A (en) | Digital twinning processing method and digital twinning system | |
| CN109885939B (en) | Photovoltaic power station construction method and system based on building information model | |
| Fiaschetti et al. | Monitoring and controlling energy distribution: Implementation of a distribution management system based on Common Information Model | |
| CN103914307A (en) | Interactive-interface fast implementation method based on reusable library | |
| CN103631578A (en) | Data display method in power distribution network automated system | |
| CN106452879A (en) | PB-based SCD cross-platform analysis method | |
| CN110019116A (en) | Data traceability method, apparatus, data processing equipment and computer storage medium | |
| CN105989213A (en) | Communication engineering drawing generation method and drawing design client | |
| CN115794641A (en) | Method, device and equipment for making number based on business process and storage medium | |
| CN104202328A (en) | GOOSE/SMV (generic object oriented substation event/sampled measured value) message subscribing method, GOOSE/SMV message subscribing configuration module and GOOSE/SMV message subscribing terminal | |
| CN102857552B (en) | The application of cloud in grid power information controls | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| Koch | An Internet of Things approach to electrical power monitoring and outage reporting | |
| CN110287243B (en) | Distributed data real-time acquisition and display system and method | |
| CN101329625A (en) | Expert system developing platform | |
| CN102750183B (en) | Numerical simulation open-type application program interface of electric power system | |
| Zolotova et al. | Architecture for a universal mobile communication module | |
| Pukas et al. | Software Solution for Energy Smart Analyzer with IoT Module | |
| CN109918353B (en) | Method for automatically processing information and terminal equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| DD01 | Delivery of document by public notice |
Addressee: Person in charge of national Power Grid Corp patent Zhao Yuxiao Shi Yongyi Zhou Sheng Document name: Notice of non patent agency Addressee: Person in charge of national Power Grid Corp patent Zhao Yuxiao Shi Yongyi Zhou Sheng Document name: Notification to Make Rectification |
|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |