CN112579531A - Method for downloading and storing wind power plant data - Google Patents
Method for downloading and storing wind power plant data Download PDFInfo
- Publication number
- CN112579531A CN112579531A CN202011481952.1A CN202011481952A CN112579531A CN 112579531 A CN112579531 A CN 112579531A CN 202011481952 A CN202011481952 A CN 202011481952A CN 112579531 A CN112579531 A CN 112579531A
- Authority
- CN
- China
- Prior art keywords
- data
- downloading
- storing
- power plant
- automatically
- 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 25
- 238000003860 storage Methods 0.000 claims abstract description 18
- 238000012545 processing Methods 0.000 abstract description 4
- 238000007405 data analysis Methods 0.000 abstract description 3
- 230000008901 benefit Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000012549 training Methods 0.000 description 1
Images
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/10—File systems; File servers
- G06F16/13—File access structures, e.g. distributed indices
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/14—Details of searching files based on file metadata
- G06F16/148—File search processing
-
- 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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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/2468—Fuzzy queries
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Business, Economics & Management (AREA)
- Software Systems (AREA)
- Economics (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Probability & Statistics with Applications (AREA)
- Tourism & Hospitality (AREA)
- Automation & Control Theory (AREA)
- Strategic Management (AREA)
- Primary Health Care (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Water Supply & Treatment (AREA)
- Public Health (AREA)
- Library & Information Science (AREA)
- Stored Programmes (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method for downloading and storing wind power plant data, which is characterized in that a computer background program is connected with a wind power plant server database, fuzzy query of the wind power plant database is completed according to keywords specified by an operator, customized data downloading and storage to a specified file directory are realized, query, collection, downloading and storage of the wind power plant data are automatically completed without manual intervention, and convenience is provided for intelligent wind power plant algorithm modeling and big data analysis processing.
Description
Technical Field
The invention belongs to the technical field of wind power, and relates to a method for off-line downloading and storing wind power plant data, which is used for big data acquisition and creates conditions for realizing an intelligent wind farm.
Background
At present, the application of big data has been integrated into our lives. The big data analysis technology is applied to provide positive help for operation management and production decision of the wind power plant, and economic benefit and production efficiency are effectively improved. The method is characterized in that different types of sensors and control equipment are distributed on a single wind turbine generator to acquire data in real time, and various types of meteorological and different types of monitoring data are also arranged outside the generator and are the basis for building an intelligent algorithm model. The mass data are often data with precision of the second or even the millisecond, for example, tens of wind turbines are arranged in a certain wind farm, and the amount of operation data in only one day is also huge. And the back of the mass data often contains rich information, and the information can be presented for decision making and iterative optimization of the wind power plant through an intelligent algorithm. How to collect these data through effective means is the basis of whole wisdom wind-powered electricity generation field operation, therefore has: the expression "algorithmic modeling, data look ahead".
Under a common condition, data of the wind turbine generator is often stored in a database inside a wind farm, and due to the consideration of energy safety, the data can only be circulated inside a local area network of the wind farm and cannot enter a remote public network. Therefore, some problems are brought, namely, in the current state, if an intelligent algorithm engineer wants to acquire corresponding data to perform offline model training and algorithm iterative development, the intelligent algorithm engineer can only manually acquire the data by a professional engineer in the wind power plant, and meanwhile, the intelligent algorithm engineer needs to download and store the data into different data formats one by one in a data list, so that the time and the labor are wasted, and a long-term personnel travel is not a little.
The invention provides a practical, simple and efficient method for offline downloading and storing data of a wind power plant, and convenience is provided for data processing of the wind power plant.
Disclosure of Invention
The invention aims to provide an effective method for downloading and storing mass data offline for a wind power plant, and the data query, collection, downloading and storage of the wind power plant are automatically completed without manual intervention.
In order to achieve the purpose, the technical scheme adopted by the invention is as follows:
a method for downloading and storing wind power plant data comprises the steps of compiling a set of special software program, importing the special software program into a wind power plant central control computer, inputting an account number and a password by running the special software program under the condition of off-line or wind power plant local area network, connecting a wind power plant server database, inputting keywords and a storage directory according to software prompts, automatically downloading and storing a specified data table, and displaying the current progress and the data size; after the data is automatically downloaded and stored, the program is automatically closed, and the whole process automatically runs at the background without manual intervention.
The special software program is an exe file which can run under a Windows system, and the special software does not need to deploy a computer running environment and a software installation package.
The special software program can access any wind power plant database according to the input database address; all or part of table name keywords, year, month, version and other multivariate information can be input at will to customize download data; according to the input information, realizing fuzzy query and automatically storing the required data as a file with a specified format, and automatically generating a file name according to keywords; and automatically storing the downloaded data into a local or mobile hard disk folder of the computer according to the input information, wherein the name of the folder is obtained through the input specified information.
The data storage folder generates an index file according to the input information, and the index file covers all data table names needing to be downloaded.
After the index file is obtained, the program automatically reads the index file line by line to obtain corresponding data, and gradually finishes reading, downloading and storing data information.
The background displays the current progress and data size when the data is read, downloaded and stored, and the program automatically closes after all the required data is stored.
After the operator inputs complete information, the program automatically runs in the background of the computer, and the operator can simultaneously perform other work without being influenced by data downloading and storage.
If the storage path is a mobile hard disk, the special exe software can be operated on the mobile hard disk, and the downloading and the storage of the data can be executed in the mobile hard disk without occupying the space of a computer system.
The invention has the beneficial effects that:
the invention provides a practical, simple and efficient method for offline downloading and storing data of a wind power plant, and convenience is provided for data processing of the wind power plant. The fuzzy query of the wind power plant database is completed according to the keywords appointed by the operator, the customized data downloading and the storage to the appointed file directory are realized, the wind power plant data query, collection, downloading and storage are automatically completed under the condition of no manual intervention, and convenience is provided for intelligent wind power plant algorithm modeling and big data analysis processing.
Drawings
FIG. 1 is a flow chart of the process
FIG. 2 is an example of an index file for demand data
FIG. 3 is an example of collected data
FIG. 4 is an example of a list of collected data
FIG. 5 is an example of a typical data folder collected.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more clear, a method for downloading and storing wind farm data offline according to the present invention is described in detail below with reference to the accompanying drawings. It is to be understood that the specific steps described herein are merely illustrative of the invention and are not to be construed as limiting the invention.
Firstly, writing a set of special software program, importing the special software program into a wind power plant central control computer, inputting an account number and a password to connect with a wind power plant server database by operating the special software program under the condition of offline or wind power plant local area network, inputting keywords and a storage directory according to software prompts, automatically downloading and storing a specified data table, and simultaneously displaying the current progress and the data size; after the data is automatically downloaded and stored, the program is automatically closed, and the whole process automatically runs at the background without manual intervention.
The special software program is an exe file which can run under a Windows system, and the special software does not need to deploy a computer running environment and a software installation package.
The special software program can access any wind power plant database according to the input database address; all or part of table name keywords, year, month, version and other multivariate information can be input at will to customize download data; according to the input information, realizing fuzzy query and automatically storing the required data as a file with a specified format, and automatically generating a file name according to keywords; and automatically storing the downloaded data into a local or mobile hard disk folder of the computer according to the input information, wherein the name of the folder is obtained through the input specified information.
The data storage folder generates an index file according to the input information, and the index file covers all data table names needing to be downloaded.
After the index file is obtained, the program automatically reads the index file line by line to obtain corresponding data, and gradually finishes reading, downloading and storing data information.
The background displays the current progress and data size when the data is read, downloaded and stored, and the program automatically closes after all the required data is stored.
After the operator inputs complete information, the program automatically runs in the background of the computer, and the operator can simultaneously perform other work without being influenced by data downloading and storage.
If the storage path is a mobile hard disk, the special exe software can be operated on the mobile hard disk, and the downloading and the storage of the data can be executed in the mobile hard disk without occupying the space of a computer system.
The software program runs as follows, see fig. 1:
1. the method comprises the following steps of operating wind power plant data acquisition software, and sequentially inputting the following information after a program is operated:
input address 2xx
User name xxx
Inputting a password: xxx
Xxx
Input port: xxxxx
Inputting a keyword: v1.7_ any1s (for example)
Inputting a storage path: d \ dataget
2. After the program runs, firstly, an index file with the format of csv is established under the appointed storage path D \ dataget, a data table containing keywords is listed in the index file, and the id of the leftmost column is the index value of the data table to be collected, as shown in FIG. 2.
3. The program starts to load, reads the index file row by row to download data, and after downloading and storing a table, the row number and column number of each table are displayed, wherein the data of one table is shown in fig. 3.
4. After the program is run, the acquired corresponding data file is found under the designated path, and the data acquisition is completed, as shown in fig. 4.
5. A typical full data folder collected is shown in figure 5.
The method for downloading and storing the wind power plant data offline provided by the invention is described in detail above. The principles and embodiments of the present invention are described herein using specific examples. It should be noted that the person skilled in the art can still make modifications to the foregoing case or equivalent replacements of some of its techniques. Therefore, any improvements and modifications made without departing from the scope of the present invention should be within the scope of the present invention.
Claims (8)
1. A method for downloading and storing wind power plant data comprises the steps of compiling a set of special software program, importing the special software program into a wind power plant central control computer, inputting an account number and a password by running the special software program under the condition of off-line or wind power plant local area network, connecting a wind power plant server database, inputting keywords and a storage directory according to software prompts, automatically downloading and storing a specified data table, and displaying the current progress and the data size; after the data is automatically downloaded and stored, the program is automatically closed, and the whole process automatically runs at the background without manual intervention.
2. The method for downloading and storing wind farm data according to claim 1, wherein the dedicated software program is an exe file that can run under a Windows system without deploying a computer operating environment and without a software installation package.
3. The method of downloading and storing wind farm data according to claim 2, wherein the dedicated software program can access any wind farm database according to the entered database address; all or part of multivariate information customized download data including table name keywords, year, month, version and the like can be input randomly; according to the input information, realizing fuzzy query and automatically storing the required data as a file with a specified format, and automatically generating a file name according to keywords; and automatically storing the downloaded data into a local or mobile hard disk folder of the computer according to the input information, wherein the name of the folder is obtained through the input specified information.
4. A method of downloading and storing wind farm data according to claim 3, characterised in that the storing data folder will first generate an index file from the input information, the index file covering all data table names that need to be downloaded.
5. The method for downloading and storing wind farm data according to claim 4, characterized in that after the index file is obtained, the program automatically reads the index file line by line to obtain corresponding data, and finishes reading, downloading and storing data information step by step.
6. The method for downloading and storing wind farm data according to claim 5, wherein the background displays the current progress and data size at the time of data reading, downloading and storing, and the program automatically closes after all the required data is stored.
7. A method for downloading and storing wind farm data according to claim 3, characterised in that after the operator has entered the complete information, the program is automatically run in the background of the computer and the operator can do other work simultaneously, independent of the data download and storage.
8. The method for downloading and storing wind farm data according to claim 2, characterized in that if the storage path is a mobile hard disk, the special exe software can be run on the mobile hard disk, and the downloading and storing of data can be performed in the mobile hard disk without occupying space of a computer system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011481952.1A CN112579531A (en) | 2020-12-15 | 2020-12-15 | Method for downloading and storing wind power plant data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011481952.1A CN112579531A (en) | 2020-12-15 | 2020-12-15 | Method for downloading and storing wind power plant data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112579531A true CN112579531A (en) | 2021-03-30 |
Family
ID=75135317
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011481952.1A Pending CN112579531A (en) | 2020-12-15 | 2020-12-15 | Method for downloading and storing wind power plant data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112579531A (en) |
Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004129395A (en) * | 2002-10-02 | 2004-04-22 | Neic Japan:Kk | Control method for wind power generating equipment |
| CN101727480A (en) * | 2008-10-10 | 2010-06-09 | Abb技术有限公司 | Method and a system for replicating databases |
| CN102562451A (en) * | 2012-01-17 | 2012-07-11 | 甘肃省电力公司风电技术中心 | System and method for real-time monitoring of ten-million-kilowatt large wind farm |
| CN102736593A (en) * | 2012-06-05 | 2012-10-17 | 吴光军 | Integrated platform system for remote management and control of wind power field cluster |
| CN103093397A (en) * | 2013-02-22 | 2013-05-08 | 上海电机学院 | System and method for processing wind power plant operation data |
| CN203588266U (en) * | 2013-07-04 | 2014-05-07 | 中能电力科技开发有限公司 | Data storage device used for wind power plant |
| EP1518698B1 (en) * | 2003-09-29 | 2016-04-13 | Brother Kogyo Kabushiki Kaisha | Tape creating apparatus |
| CN106569920A (en) * | 2016-11-09 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Database backup method and device |
| CN106850308A (en) * | 2017-02-27 | 2017-06-13 | 湘电风能有限公司 | A kind of dual-machine hot backup system |
| CN107798462A (en) * | 2017-09-19 | 2018-03-13 | 科诺伟业风能设备（北京）有限公司 | A kind of wind power plant wind power generating set operation exception monitor and performance evaluation system |
| CN108921423A (en) * | 2018-06-28 | 2018-11-30 | 北京金风科创风电设备有限公司 | experiment management and data analysis system |
| CN109274121A (en) * | 2018-11-15 | 2019-01-25 | 山东中车风电有限公司 | A kind of wind power plant Optimization about control parameter method and system |
| CN109359101A (en) * | 2018-12-10 | 2019-02-19 | 国电联合动力技术有限公司 | Wind power plant cluster big data distributed analysis computing system |
-
2020
- 2020-12-15 CN CN202011481952.1A patent/CN112579531A/en active Pending
Patent Citations (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2004129395A (en) * | 2002-10-02 | 2004-04-22 | Neic Japan:Kk | Control method for wind power generating equipment |
| EP1518698B1 (en) * | 2003-09-29 | 2016-04-13 | Brother Kogyo Kabushiki Kaisha | Tape creating apparatus |
| CN101727480A (en) * | 2008-10-10 | 2010-06-09 | Abb技术有限公司 | Method and a system for replicating databases |
| CN102562451A (en) * | 2012-01-17 | 2012-07-11 | 甘肃省电力公司风电技术中心 | System and method for real-time monitoring of ten-million-kilowatt large wind farm |
| CN102736593A (en) * | 2012-06-05 | 2012-10-17 | 吴光军 | Integrated platform system for remote management and control of wind power field cluster |
| CN103093397A (en) * | 2013-02-22 | 2013-05-08 | 上海电机学院 | System and method for processing wind power plant operation data |
| CN203588266U (en) * | 2013-07-04 | 2014-05-07 | 中能电力科技开发有限公司 | Data storage device used for wind power plant |
| CN106569920A (en) * | 2016-11-09 | 2017-04-19 | 腾讯科技（深圳）有限公司 | Database backup method and device |
| CN106850308A (en) * | 2017-02-27 | 2017-06-13 | 湘电风能有限公司 | A kind of dual-machine hot backup system |
| CN107798462A (en) * | 2017-09-19 | 2018-03-13 | 科诺伟业风能设备（北京）有限公司 | A kind of wind power plant wind power generating set operation exception monitor and performance evaluation system |
| CN108921423A (en) * | 2018-06-28 | 2018-11-30 | 北京金风科创风电设备有限公司 | experiment management and data analysis system |
| CN109274121A (en) * | 2018-11-15 | 2019-01-25 | 山东中车风电有限公司 | A kind of wind power plant Optimization about control parameter method and system |
| CN109359101A (en) * | 2018-12-10 | 2019-02-19 | 国电联合动力技术有限公司 | Wind power plant cluster big data distributed analysis computing system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Huenteler et al. | Technology life-cycles in the energy sector—Technological characteristics and the role of deployment for innovation | |
| CN101490647A (en) | A method of configuring intelligent electronic devices to facilitate standardized communication messages among a plurality of ieds within a network | |
| CN112115999B (en) | Wind turbine generator fault diagnosis method of space-time multi-scale neural network | |
| CN101741143A (en) | Method for realizing integral configuration of electric automation system | |
| Neis et al. | Model driven software engineering of power systems applications: literature review and trends | |
| KR101843333B1 (en) | The Monitoring System for Photovoltaic Power Generation and the Method Thereof | |
| CN112579531A (en) | Method for downloading and storing wind power plant data | |
| CN115977893B (en) | Wind turbine generator self-diagnosis debugging system based on standardized flow | |
| KR20180108398A (en) | Monitoring system based on meta-model for renewable energy device and method teherof | |
| US20100318343A1 (en) | Smart data access layer for supervisory information system | |
| Podkovalnikov et al. | Technical features of the computing and geo-information system for research of prospective interstate power grid expansion | |
| CN114707907A (en) | Asset management method and asset management system of service script based on object model | |
| CN114201855A (en) | Power station unit installation auxiliary information reorganization method based on three-dimensional model | |
| Jiménez-Delgado et al. | Data management infrastructure from initiatives on photovoltaic solar energy | |
| Zare Oskouei et al. | Modeling and Optimal Operation of Renewable Energy Sources in DIgSILENT PoweFactory | |
| CN112069400A (en) | Whole-network searching method based on regional power grid information | |
| CN109977388A (en) | Remote signalling point table automatic generation method and tool based on electric main wiring diagram identification | |
| Schönfeldt et al. | MTRESS 3.0--Modell Template for Residential Energy Supply Systems | |
| CN112381500B (en) | BPA model parameter maintenance method and system based on Web service | |
| CN113626961B (en) | Automatic mapping method for power supply path | |
| Zach et al. | MOST-designing a vendor and technology independent toolkit for building monitoring, data preprocessing, and visualization | |
| CN113988030A (en) | Office tool for automatic form filling | |
| KR102103889B1 (en) | Method for automatically generating meta model based data for renewable energy monitoring | |
| US20210357804A1 (en) | Systems and methods for classifying sensor data | |
| Carpintero Rentería | Improved modelling of microgrid distributed energy resources with machine learning algorithms |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 618000 No.2, Section 2, South Huashan Road, Jingyang District, Deyang City, Sichuan Province Applicant after: Dongfang Electric Wind Power Co.,Ltd. Address before: 618000 No.2, Section 2, South Huashan Road, Jingyang District, Deyang City, Sichuan Province Applicant before: DONGFANG ELECTRIC WIND POWER Co.,Ltd. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210330 |