CN103700040A - Method and device for generating power data report - Google Patents
Method and device for generating power data report Download PDFInfo
- Publication number
- CN103700040A CN103700040A CN201410016553.6A CN201410016553A CN103700040A CN 103700040 A CN103700040 A CN 103700040A CN 201410016553 A CN201410016553 A CN 201410016553A CN 103700040 A CN103700040 A CN 103700040A
- Authority
- CN
- China
- Prior art keywords
- data
- electric power
- data type
- power data
- main system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 26
- 238000012216 screening Methods 0.000 claims abstract description 10
- 238000001914 filtration Methods 0.000 claims description 20
- 239000000284 extract Substances 0.000 claims description 10
- 238000000605 extraction Methods 0.000 claims description 10
- 238000012545 processing Methods 0.000 claims description 5
- 238000004519 manufacturing process Methods 0.000 description 4
- 238000012544 monitoring process Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the field of power, and particularly relates to a method and a device for generating a power data report. The method comprises the following steps: obtaining at least one data type in data types of a power system, wherein the data types correspond to a corresponding master system in a database, at least one data type is stored in the master system, and at least one power data is stored by each data type; screening out the master system of the obtained data type according to the obtained data type; exporting the power data stored in the screened master system from the database according to the screened master system; generating a power data form from the exported power data. By adopting the method for generating the power data report provided by the embodiment of the invention, the power data repot can be automatically generated from the power data in each master system, so that the problem that the efficiency is low as the power data are obtained by manpower and the report is formed is solved.
Description
Technical field
The present invention relates to power domain, relate in particular a kind of electric power data acquisition methods and device.
Background technology
Development along with power industry, various application systems as marketing system, power information acquisition system, OPEN3000, etc. system arise at the historic moment, yet due to the variation of application system, the data target that each system is paid close attention to is different, incompatible, so, when needs obtain a plurality of index, from different systems, manually obtain data, then generating report forms, inefficiency.
Summary of the invention
In view of this, the object of the invention is to solve traditional electric power data that manually obtains, generating report forms then, the problem of inefficiency, the embodiment of the present invention provides a kind of electric power data acquisition methods and device, and technical scheme is as follows:
An electric power data report form generation method, is characterized in that, comprising:
Obtain at least one class data type in electric power system data type, wherein, described data type to there being corresponding main system, is stored at least one class data type in database in described main system, and every class data type is stored at least one electric power data;
According to the data type of obtaining, the main system under the data type of obtaining described in filtering out in described database;
According to the described main system filtering out, the electric power data of the main system storage filtering out described in recalling in described database;
The electric power data recalling is generated to electric power data form.
Preferably, in above-mentioned electric power data report form generation method, also comprise:
By described electric power data report output to client.
Preferably, in above-mentioned electric power data report form generation method, also comprise:
Obtain the electric power data of electric power data report form template and each main system;
The electric power data of described main system is stored to described database;
According to described report form template, each electric power data in described database is gathered, obtain respectively key word, according to described key word, electric power data is generated to achievement data tuple;
Described achievement data tuple is generated to summary sheet.
Preferably, in above-mentioned electric power data report form generation method, the data type that described basis is obtained, the main system described in the data type of obtaining described in filtering out in described database, comprising:
According to the described data type of obtaining, the target keywords of the data type of obtaining described in extraction;
In described summary sheet, extract and the corresponding target achievement data of described target keywords tuple;
Main system under the data type of obtaining described in obtaining according to described target index tuple.
The embodiment of the present invention also provides a kind of electric power data report generation device, comprising:
The first acquiring unit, be used for obtaining at least one class data type of electric power system data type, wherein, described data type in database to there being corresponding main system, in described main system, store at least one class data type, every class data type is stored at least one electric power data;
Screening unit, the data type of obtaining for basis, the main system under the data type of obtaining described in filtering out in described database;
Processing unit, for the main system filtering out described in basis, the electric power data of the main system storage filtering out described in recalling in described database;
Report generation unit, for generating electric power data form by the electric power data recalling.
Preferably, in above-mentioned electric power data report generation device, also comprise:
Output unit, for by described electric power data report output to client.
Preferably, in above-mentioned electric power data report generation device, also comprise:
Second acquisition unit, for obtaining the electric power data of electric power data report form template and each main system;
Storage unit, for being stored to described database by the electric power data of described main system;
Gather unit, for according to described report form template, each electric power data in described database is gathered, obtain respectively key word, according to described key word, electric power data is generated to achievement data tuple;
Summary sheet generation unit, for generating summary sheet by described achievement data tuple.
Preferably, in above-mentioned electric power data report generation device, described screening unit, comprising:
Keyword extraction module, for the data type of obtaining described in basis, the target keywords of the data type of obtaining described in extraction;
Data tuple extraction module, at described summary sheet, extracts and the corresponding target achievement data of described target keywords tuple;
Acquisition module, for the main system under the data type of obtaining described in obtaining according to described target index tuple.
The electric power data report form generation method that the embodiment of the present invention provides can generate electric power data form automatically by the electric power data in each main system, has solved traditional electric power data that manually obtains, generating report forms then, the problem of inefficiency.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
A kind of schematic flow sheet of the electric power data report form generation method that Fig. 1 provides for the embodiment of the present invention;
Another schematic flow sheet of the electric power data report form generation method that Fig. 2 provides for the embodiment of the present invention;
A kind of structural representation of the electric power data report generation device that Fig. 3 provides for the embodiment of the present invention;
A kind of structural representation of the electric power data report generation device that Fig. 4 provides for the embodiment of the present invention;
A kind of structural representation of the screening unit that Fig. 5 provides for the embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
Referring to Fig. 1, the embodiment of the present invention provides a kind of electric power data report form generation method, and method comprises:
Step 110: obtain at least one class data type in electric power system data type.
Wherein, data type to there being corresponding main system, is stored at least one class data type in database in main system, and every class data type is stored at least one electric power data.
Above-mentioned main system can comprise marketing system in electric system, power information acquisition system, OPEN3000, county telephone central office's production management system, DNS production management system, Reliability management system, outfit load on-line monitoring system, PI Database Systems etc., in each main system, store at least one class data type, every class data type is stored at least one electric power data, as stored power quality data type in power information acquisition system, in power quality data type, can comprise user's power consumption data, the energy data of electric energy meter etc.
Step 120: according to the data type of obtaining, filter out the main system under the data type of obtaining in database.
Wherein, database can be selected SqlServer2000 database, and this database has easy to use, the feature that stability is high.
In database, store electric power system data type, main system, electric power data that electric power system data type is corresponding.In main system, store at least one class data type, every class data type is stored at least one electric power data.
According to the data type of obtaining, in database, filter out the main system under the data type of obtaining, can comprise:
According to the data type of obtaining, extract the target keywords of the data type of obtaining, in database, extract and the corresponding target achievement data of target keywords tuple the main system under the data type that obtains obtaining according to target index tuple.
Step 130: according to the main system filtering out, recall the electric power data of the main system storage filtering out in database.
Step 140: the electric power data recalling is generated to electric power data form.
In other embodiments of the invention, generating electric power data form can also comprise afterwards:
By electric power data report output to client.
Client can be Web server, and user, by browser access Web server, obtains the electric power data form of above-mentioned generation.
The electric power data report form generation method that the embodiment of the present invention provides can generate electric power data form automatically by the electric power data in each main system, has solved traditional electric power data that manually obtains, generating report forms then, the problem of inefficiency.
Referring to Fig. 2, the embodiment of the present invention provides a kind of electric power data report form generation method, and method comprises:
Step 210: the electric power data that obtains electric power data report form template and each main system.
Step 220: the electric power data of main system is stored to database.
Step 230: according to report form template, each electric power data in database is gathered, obtain respectively key word, according to key word, electric power data is generated to achievement data tuple.
Wherein, key word can comprise " quality of power supply ", if what gather is current data, voltage data, frequency data, these data can be gathered, and obtains key word " quality of power supply ", then according to key word by electric power data generated data tuple.
Step 240: achievement data tuple is generated to summary sheet.
Step 250: obtain at least one class data type in electric power system data type.
Wherein, data type to there being corresponding main system, is stored at least one class data type in database in main system, and every class data type is stored at least one electric power data.
Above-mentioned main system can comprise marketing system in electric system, power information acquisition system, OPEN3000, county telephone central office's production management system, DNS production management system, Reliability management system, outfit load on-line monitoring system, PI Database Systems etc., in each main system, store at least one class data type, every class data type is stored at least one electric power data, as stored power quality data type in power information acquisition system, in power quality data type, can comprise user's power consumption data, the energy data of electric energy meter etc.
Step 260: according to the data type of obtaining, filter out the main system under the data type of obtaining in database.
Wherein, database can be selected SqlServer2000 database, and this database has easy to use, the feature that stability is high.
In database, store electric power system data type, main system, electric power data that electric power system data type is corresponding.In main system, store at least one class data type, every class data type is stored at least one electric power data.
Wherein, this step can specifically comprise:
According to the data type of obtaining, extract the target keywords of the data type of obtaining;
In summary sheet, extract and the corresponding target achievement data of target keywords tuple;
Main system under the data type that obtains obtaining according to target index tuple.
Step 270: according to the main system filtering out, recall the electric power data of the main system storage filtering out in database.
Step 280: the electric power data recalling is generated to electric power data form.
The electric power data report form generation method that the embodiment of the present invention provides can generate electric power data form automatically by the electric power data in each main system, has solved traditional electric power data that manually obtains, generating report forms then, the problem of inefficiency.
With reference to figure 3, Fig. 3 shows a kind of structural representation of electric power data report generation device, comprising:
The first acquiring unit U110, be used for obtaining at least one class data type of electric power system data type, wherein, data type in database to there being corresponding main system, in main system, store at least one class data type, every class data type is stored at least one electric power data;
Screening unit U120 for according to the data type obtained, filters out the main system under the data type of obtaining in database;
Processing unit U130 for according to the main system filtering out, recalls the electric power data of the main system storage filtering out in database;
Report generation unit U140, for generating electric power data form by the electric power data recalling.
The electric power data report generation rotor that the embodiment of the present invention provides can generate electric power data form automatically by the electric power data in each main system, has solved traditional electric power data that manually obtains, generating report forms then, the problem of inefficiency.
Further, electric power data report generation device also comprises:
Output unit, for by electric power data report output to client.
Client can be Web server, and user, by browser access Web server, obtains the electric power data form of above-mentioned generation.
With reference to figure 4, Fig. 4 shows a kind of structural representation of electric power data report generation device, and electric power data report generation device, except comprising the first acquiring unit U110, screening unit U120, processing unit U130, report generation unit U140, also comprises:
Second acquisition unit U150, for obtaining the electric power data of electric power data report form template and each main system;
Storage unit U160, for being stored to database by the electric power data of main system;
Gather unit U170, for according to report form template, each electric power data in database is gathered, obtain respectively key word, according to key word, electric power data is generated to achievement data tuple;
Summary sheet generation unit U180, for generating summary sheet by achievement data tuple.
With reference to figure 5, Fig. 5 shows a kind of structural representation of above-mentioned screening unit, and screening unit comprises:
Keyword extraction module U121, for according to the data type of obtaining, extracts the target keywords of the data type of obtaining;
Data tuple extraction module U122, at summary sheet, extracts and the corresponding target achievement data of target keywords tuple;
Acquisition module U123, for the main system under the data type that obtains obtaining according to target index tuple.
It will be appreciated by those skilled in the art that accompanying drawing is the schematic diagram of a preferred embodiment, the module in accompanying drawing or flow process might not be that enforcement the present invention is necessary.
It will be appreciated by those skilled in the art that the module in the device in embodiment can be distributed in the device of embodiment according to embodiment description, also can carry out respective change and be arranged in the one or more devices that are different from the present embodiment.The module of above-described embodiment can be merged into a module, also can further split into a plurality of submodules.
One of ordinary skill in the art will appreciate that all or part of processing in above-described embodiment method is to come the hardware that instruction is relevant to complete by program, described program can be stored in a kind of computer-readable recording medium.
Above-mentioned explanation to the disclosed embodiments, makes professional and technical personnel in the field can realize or use the present invention.To the multiple modification of these embodiment, will be apparent for those skilled in the art, General Principle as defined herein can, in the situation that not departing from the spirit or scope of the present invention, realize in other embodiments.Therefore, the present invention will can not be restricted to these embodiment shown in this article, but will meet the widest scope consistent with principle disclosed herein and features of novelty.
Claims (8)
1. an electric power data report form generation method, is characterized in that, comprising:
Obtain at least one class data type in electric power system data type, wherein, described data type to there being corresponding main system, is stored at least one class data type in database in described main system, and every class data type is stored at least one electric power data;
According to the data type of obtaining, the main system under the data type of obtaining described in filtering out in described database;
According to the described main system filtering out, the electric power data of the main system storage filtering out described in recalling in described database;
The electric power data recalling is generated to electric power data form.
2. method according to claim 1, is characterized in that, also comprises:
By described electric power data report output to client.
3. method according to claim 1, is characterized in that, also comprises:
Obtain the electric power data of electric power data report form template and each main system;
The electric power data of described main system is stored to described database;
According to described report form template, each electric power data in described database is gathered, obtain respectively key word, according to described key word, electric power data is generated to achievement data tuple;
Described achievement data tuple is generated to summary sheet.
4. method according to claim 3, is characterized in that, the data type that described basis is obtained, and the main system described in the data type of obtaining described in filtering out in described database, comprising:
According to the described data type of obtaining, the target keywords of the data type of obtaining described in extraction;
In described summary sheet, extract and the corresponding target achievement data of described target keywords tuple;
Main system under the data type of obtaining described in obtaining according to described target index tuple.
5. an electric power data report generation device, is characterized in that, comprising:
The first acquiring unit, be used for obtaining at least one class data type of electric power system data type, wherein, described data type in database to there being corresponding main system, in described main system, store at least one class data type, every class data type is stored at least one electric power data;
Screening unit, the data type of obtaining for basis, the main system under the data type of obtaining described in filtering out in described database;
Processing unit, for the main system filtering out described in basis, the electric power data of the main system storage filtering out described in recalling in described database;
Report generation unit, for generating electric power data form by the electric power data recalling.
6. device according to claim 5, is characterized in that, also comprises:
Output unit, for by described electric power data report output to client.
7. device according to claim 5, is characterized in that, also comprises:
Second acquisition unit, for obtaining the electric power data of electric power data report form template and each main system;
Storage unit, for being stored to described database by the electric power data of described main system;
Gather unit, for according to described report form template, each electric power data in described database is gathered, obtain respectively key word, according to described key word, electric power data is generated to achievement data tuple;
Summary sheet generation unit, for generating summary sheet by described achievement data tuple.
8. device according to claim 7, is characterized in that, described screening unit, comprising:
Keyword extraction module, for the data type of obtaining described in basis, the target keywords of the data type of obtaining described in extraction;
Data tuple extraction module, at described summary sheet, extracts and the corresponding target achievement data of described target keywords tuple;
Acquisition module, for the main system under the data type of obtaining described in obtaining according to described target index tuple.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410016553.6A CN103700040A (en) | 2014-01-14 | 2014-01-14 | Method and device for generating power data report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410016553.6A CN103700040A (en) | 2014-01-14 | 2014-01-14 | Method and device for generating power data report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103700040A true CN103700040A (en) | 2014-04-02 |
Family
ID=50361559
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410016553.6A Pending CN103700040A (en) | 2014-01-14 | 2014-01-14 | Method and device for generating power data report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103700040A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281447A (en) * | 2014-09-01 | 2015-01-14 | 国家电网公司 | Report form fast generating and issuing system and method |
| CN106655496A (en) * | 2016-11-10 | 2017-05-10 | 国网浙江省电力公司湖州供电公司 | HighSoon database-based reactive power factor real-time monitoring method |
| CN108595478A (en) * | 2018-03-12 | 2018-09-28 | 长春电力设计有限公司 | A kind of method that power distribution network report data generates |
| CN117910445A (en) * | 2024-03-20 | 2024-04-19 | 中国水利水电第七工程局有限公司 | Report automatic generation method, system and storage medium |
-
2014
- 2014-01-14 CN CN201410016553.6A patent/CN103700040A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104281447A (en) * | 2014-09-01 | 2015-01-14 | 国家电网公司 | Report form fast generating and issuing system and method |
| CN104281447B (en) * | 2014-09-01 | 2017-10-10 | 国家电网公司 | The system and method that a kind of form is quickly generated and issued |
| CN106655496A (en) * | 2016-11-10 | 2017-05-10 | 国网浙江省电力公司湖州供电公司 | HighSoon database-based reactive power factor real-time monitoring method |
| CN108595478A (en) * | 2018-03-12 | 2018-09-28 | 长春电力设计有限公司 | A kind of method that power distribution network report data generates |
| CN117910445A (en) * | 2024-03-20 | 2024-04-19 | 中国水利水电第七工程局有限公司 | Report automatic generation method, system and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103700040A (en) | Method and device for generating power data report | |
| CN105488048A (en) | Data query method and device | |
| CN105183731A (en) | Method, device, and system for generating recommended information | |
| CN107944036B (en) | Method for acquiring map change difference | |
| CN104615696A (en) | 95598 knowledge base system and establishment method | |
| US20190050435A1 (en) | Object data association index system and methods for the construction and applications thereof | |
| CN105069153A (en) | Patent analysis system | |
| CN106649363A (en) | Data query method and device | |
| CN109345628A (en) | A kind of model light-weight technologg method, apparatus and electronic equipment | |
| CN112100402A (en) | Power grid knowledge graph construction method and device | |
| CN105117860A (en) | Internet work attendance system and method on the basis of a facial recognition device | |
| CN102624544A (en) | Method and device for creating monitoring tasks | |
| CN107704620A (en) | A kind of method, apparatus of file administration, equipment and storage medium | |
| CN104991152A (en) | Method and device for analyzing wrong wiring of three-phase three-wire electric energy metering device | |
| CN104091610B (en) | A kind of management method of audio file and device | |
| CN107579976A (en) | The method and device of self-defined detection website sensitive information | |
| CN114218291A (en) | Portrait generation method, apparatus, device and storage medium based on target object | |
| CN103473306A (en) | Method and system for adopting structured query language (SQL) mark substitution method to achieve data self-extraction | |
| CN105528662A (en) | Data management system based on electric energy metering system | |
| CN111723063A (en) | Method and device for processing offline log data | |
| CN104157024A (en) | Local real-time monitoring system | |
| CN104408583A (en) | Intelligent decision and analysis system for electric energy | |
| CN204331791U (en) | A kind of electric flux intelligent decision analytic system | |
| CN104102739B (en) | A kind of method and device for expanding entity storehouse | |
| CN109687464B (en) | Power grid power flow analysis method and device, storage medium and processor |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into 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: 20160318 Address after: 315700, No. 286, Xinfeng Road, Dan city, Xiangshan County, Ningbo, Zhejiang Applicant after: STATE GRID ZHEJIANG XIANGSHAN POWER SUPPLY COMPANY Applicant after: State Grid Corporation of China Applicant after: Ningbo Power Supply Company of State Grid Zhejiang Electric Power Company Address before: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant before: State Grid Corporation of China Applicant before: STATE GRID ZHEJIANG XIANGSHAN POWER SUPPLY COMPANY Applicant before: Ningbo Power Supply Company of State Grid Zhejiang Electric Power Company |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140402 |