A data management method and system for distributed renewable energy
By constructing a relational index table and storing data according to the power type, the problem of low efficiency in renewable energy data management in the existing technology is solved, efficient data storage and query are achieved, and the system's management and control capabilities are improved.
Patent Information
- Application Number
- CN201910068830.0
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2019-01-24
- Publication Date
- 2025-05-02
- Estimated Expiration
- 2039-01-24
AI Technical Summary
The existing renewable energy data management methods lead to poor data resolution, low storage efficiency, and slow query speed, which leads to a large accumulation of distributed renewable energy data, which is not conducive to system control.
By constructing a relational index table, finding the corresponding table name according to the power type, and storing the data in the corresponding table, realizing flexible access and classified storage of data, reducing the repeated storage of the same data at adjacent moments.
It improves data storage efficiency, realizes rapid query and flexible management of distributed renewable energy data, reduces data accumulation problems, and enhances the control capabilities of the system.
Smart Images

Figure CN111475502B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to distributed renewable energy, and in particular to a data management method and system for distributed renewable energy based on a microgrid. Background Art
[0002] In recent years, distributed renewable energy has grown rapidly, and large-scale distributed renewable energy has been connected to the power grid, which has brought new challenges and higher requirements for the effective management and control of distributed renewable energy. The microgrid constructed by bidirectional multi-port power electronic transformers can realize flexible networking, integrate distributed renewable energy at multiple AC and DC voltage levels, realize flexible and safe access and efficient application, solve the problem of grid connection of various forms of distributed power sources; and reduce the transformation links, improve energy utilization efficiency, enhance system control capabilities, realize interconnection and complementarity in a larger range, and fully absorb renewable energy. Although the utilization rate of distributed renewable energy has been improved through microgrids, the existing data management methods of renewable energy have resulted in weak data resolution, low storage efficiency, and slow query speed. As time goes by, a large amount of data of distributed renewable energy has accumulated, which is not conducive to the management and control of distributed renewable energy. Summary of the invention
[0003] In order to solve the data storage problem of distributed renewable energy in the prior art, the present invention provides a data management method and system for distributed renewable energy, which can realize flexible access to distributed renewable energy data, and can quickly complete the classified storage and efficient query of distributed renewable energy data, and can greatly reduce the repeated storage of the same data at adjacent times, effectively improving the data storage efficiency.
[0004] The technical solution provided by the present invention is: a data management method for distributed renewable energy, comprising:
[0005] Obtaining operating data of power sources to be stored in distributed renewable energy sources;
[0006] Based on the pre-built relational index table and the type of the power source to be stored, searching for the table name corresponding to the power source to be stored;
[0007] Storing the operating data of the power source to be stored in the table corresponding to the table name;
[0008] Wherein, the relationship index table includes: power type and table name corresponding to the power type.
[0009] Preferably, the construction of the relationship index table includes:
[0010] Classify the power sources of distributed renewable energy and establish a table to store data for each type of power source;
[0011] Name the table and obtain the corresponding table name;
[0012] Construct a relational index table based on index information consisting of power type and corresponding table name;
[0013] Among them, the power supply types include: wind power, photovoltaics, energy storage, solar thermal and DC piles.
[0014] Preferably, searching for a table name corresponding to the power source to be stored based on a pre-built relationship index table and the type of the power source to be stored includes:
[0015] Searching in the relational index table based on the type of power to be stored;
[0016] When there is a type of power source to be stored in the relational index table, obtaining a table name corresponding to the power source to be stored;
[0017] When the type of power source to be stored does not exist in the relational index table, a table is constructed based on the type of power source to be stored, and index information is added to the relational index table.
[0018] Preferably, the constructing of a table based on the type of the power source to be stored and adding index information to the relationship index table includes:
[0019] Based on the type of power source to be stored, a table for storing operation data corresponding to the power source type is constructed, and a table name corresponding to the table is determined;
[0020] Add a row to the relationship index table to record the newly added power type and the table name.
[0021] Preferably, storing the operating data of the power supply to be stored in the table corresponding to the table name includes:
[0022] When the power source to be stored needs to store process data, the current moment data and the relevant attributes of the current moment are stored in the table corresponding to the table name, otherwise the data obtained at the current moment of the power source to be stored is compared with the data stored in the table at the previous moment;
[0023] When the data acquired by the power source to be stored at the current moment is the same as the data stored in the table at the previous moment, the data acquired at the current moment is filtered out, otherwise the data at the current moment and the related attributes at the current moment are stored in the table corresponding to the table name;
[0024] The related attributes include: current state, controlled state, and control type.
[0025] Preferably, after constructing the relationship index table, the method further includes:
[0026] When an existing power type needs to be deleted, the index information corresponding to the power type in the relationship index table and the table for storing the power type data are deleted.
[0027] Preferably, the step of obtaining the operating data of the power source to be stored in the distributed renewable energy source includes:
[0028] The operation data of the power source to be stored in the distributed renewable energy is obtained at a set time interval.
[0029] Based on the same inventive concept, the present invention also provides a data management system for distributed renewable energy, comprising:
[0030] An acquisition module, used for acquiring operation data of the power source to be stored in the distributed renewable energy;
[0031] A query module, used for searching the table name corresponding to the power source to be stored based on the pre-built relationship index table and the type of the power source to be stored;
[0032] A storage module, used for storing the operating data of the power supply to be stored in a table corresponding to the table name;
[0033] Wherein, the relationship index table includes: power type and table name corresponding to the power type.
[0034] Preferably, the system further comprises a construction module for constructing a relationship index table;
[0035] The building blocks include:
[0036] A classification unit, used for classifying the power sources of distributed renewable energy and establishing a table for storing data for each type of power source;
[0037] A naming unit, used to name the table and obtain a corresponding table name;
[0038] A construction unit, used to construct a relational index table based on index information consisting of power type and corresponding table name;
[0039] Among them, the power supply types include: wind power, photovoltaics, energy storage, solar thermal and DC piles.
[0040] Preferably, the query module includes:
[0041] A search unit, configured to search the relational index table based on the type of power source to be stored;
[0042] A table name acquisition unit, used for acquiring a table name corresponding to the power source to be stored when there is a type of power source to be stored in the relational index table;
[0043] A newly adding unit is used to construct a table based on the type of power source to be stored when there is no type of power source to be stored in the relationship index table, and to add index information to the relationship index table.
[0044] Compared with the prior art, the present invention has the following beneficial effects:
[0045] The technical solution provided by the present invention obtains the operating data of the power supply to be stored in the distributed renewable energy; based on the pre-constructed relationship index table and the type of the power supply to be stored, searches for the table name corresponding to the power supply to be stored; stores the operating data of the power supply to be stored in the table corresponding to the table name, wherein the relationship index table includes: the correspondence between the power supply type and the table name, which can quickly find the power supply data storage location through the index, and can also quickly complete the data classification storage of the distributed renewable energy, thereby improving the data management efficiency.
[0046] The technical solution provided by the present invention only requires adding a row of records to the relationship index table and constructing a table for data storage when a new power source is connected, thereby realizing flexible access and classified storage of distributed renewable energy data.
[0047] The technical solution provided by the present invention can quickly find the storage table name through the relationship index table when performing data query, and the table does not store data of other power types, thereby realizing efficient query of distributed renewable energy data; for power sources that do not need to store process data, the repeated storage of the same data at adjacent moments can be greatly reduced according to the characteristics of the power source. BRIEF DESCRIPTION OF THE DRAWINGS
[0048] Figure 1 This is a flow chart of a data management method for distributed renewable energy provided by the present invention. DETAILED DESCRIPTION
[0049] In order to better understand the present invention, the content of the present invention is further described below in conjunction with the accompanying drawings and examples.
[0050] Embodiment 1:
[0051] In the past, data on renewable energy sources were all stored in the same table. To distinguish power types, it was necessary to query and distinguish them through type IDs, and the storage method could only be used to store data once every minute or every few minutes, which was not very distinguishable. As time went on, a large amount of data from each power source would accumulate in one table, seriously affecting the query speed. At the same time, when a certain power source ceased to operate, the data that had been running in the past and needed to be deleted was not easy to delete. Moreover, since the data of each power source had its own characteristics, the unified storage method would result in that the power source that did not need to store the entire process data could not use its characteristics to simplify storage and improve storage efficiency. For example, it was impossible to use the fact that the data of photovoltaic power sources was zero when there was no light at night, and that energy storage would keep the data at a fixed value for a long time when not charging or discharging, etc. That is, long-term repeated data was stored multiple times. Based on the existing background conditions, it was provided Figure 1 A data management method for distributed renewable energy is shown, comprising:
[0052] Step S1, obtaining operation data of the power source to be stored in the distributed renewable energy source;
[0053] Step S2: searching for a table name corresponding to the power source to be stored based on the pre-built relationship index table and the type of the power source to be stored;
[0054] Step S3, storing the operating data of the power supply to be stored in the table corresponding to the table name;
[0055] Wherein, the relationship index table includes: power type and table name corresponding to the power type.
[0056] Step S2, based on the pre-built relationship index table and the type of the power source to be stored, searching for the table name corresponding to the power source to be stored, including:
[0057] A corresponding relationship index table is established, which is used to store the power types that all distributed renewable energy sources need to store and the table names of the data stored in this type of power supply, and the table is constructed accordingly to store data of the corresponding power types, including wind power, photovoltaic, energy storage, solar thermal, DC piles, etc.
[0058] If a certain type of power supply is added, a row is added to the corresponding relationship index table to record the power supply type and the table name for storing data of the power supply of this type, and the table is constructed for data storage.
[0059] Obtain the operating data of each power source of distributed renewable energy every minute.
[0060] The storage table name corresponding to each distributed renewable energy data is found through the power source type in the corresponding relationship index table.
[0061] Step S3, storing the operating data of the power source to be stored in the table corresponding to the table name, including:
[0062] If the data of the power supply is connected for the first time, the time data and other related attributes are directly stored in the corresponding table.
[0063] If the power supply of the data needs to be stored in process data, the time data and other related attributes are directly stored in the corresponding table.
[0064] If the power supply of the data does not need to store the entire process data, the data obtained by the power supply at this moment is compared with the data most recently stored in the table. If it is the same as the data stored at the most recent moment, the data obtained at this moment is filtered out, that is, the data at this moment is not stored; if it is different from the data stored at the most recent moment, the data at this moment and other related attributes continue to be stored, avoiding multiple storage of continuous repeated data.
[0065] The relevant attributes in this embodiment include: current state, controlled state, control type, etc.
[0066] If a certain power source of the microgrid is no longer in operation, the power source correspondence row in the correspondence index table and the corresponding table for data storage are deleted.
[0067] When querying data, find the table name of the power supply storage data through the power supply type in the corresponding relationship index table, and then query.
[0068] The data in this embodiment is stored until the microgrid is no longer in operation.
[0069] The data storage of distributed renewable energy based on microgrid can smoothly find its storage location through index; if a certain type of power supply is newly connected, it is only necessary to add a row of records in the corresponding index table and build a table for data storage, which realizes the flexible access and classified storage of distributed renewable energy data; when performing data query, the storage table name can be quickly found through the corresponding index table, and the table does not store data of other power types, which realizes efficient query of distributed renewable energy data; for power supplies that do not need to store process data, the repeated storage of the same data at adjacent moments can be greatly reduced according to the characteristics of the power supply.
[0070] The present invention provides a data management method for distributed renewable energy based on a microgrid, which can not only smoothly find its storage location through indexing, but also realize flexible access to the data of each power source of distributed renewable energy, and can also quickly complete the data classification storage and efficient query of distributed renewable energy, and can greatly reduce the repeated storage of the same data at adjacent moments, effectively improving the data storage efficiency.
[0071] This embodiment takes the power supply of distributed renewable energy as an example, and stores the power supply data through the method provided by the present invention, including:
[0072] (1) Establish a corresponding relationship index table M, which stores n rows of data. Each row of data is the type of distributed renewable energy power source and the table name M1, M2, ..., M2 corresponding to the storage data of the type of power source. n , and each power source constructs its own table M1, M2...M n Used for data storage.
[0073] (2) If a new type of power supply x is added, a row is added to the corresponding relationship index table. The data in this row stores the power supply type x and the table name M for storing data of this type of power supply. n+1 , and construct the M n+1 Tables are used to store data.
[0074] (3)T i Obtaining distributed renewable energy related operation data at all times i .
[0075] (4) Find data P by the power type of the corresponding index table M in (1) i The corresponding storage table name M i .
[0076] (5) If the power supply data P i For the first access, directly set T i Data at the moment P i And other related attributes are stored in table M i middle.
[0077] (6) If data P i If the power supply needs to be stored in the process data, then directly i Data at the moment P i and other related attributes are stored in the corresponding table M i middle.
[0078] (7) If data P i If the power supply does not need to store the entire process data, then T i Data P obtained at all times i Table M i The most recently stored data P i-1 Compare and if the data is the same, filter out T i The data P obtained at the moment i , that is, T i Time data P i Do not store; if the data is not the same, continue to store it in T i Time data P i and Ti Other related attributes that need to be stored corresponding to the moment avoid multiple storage of consecutive repeated data.
[0079] (8) If a certain power source y of the microgrid is no longer in operation, delete a row of the corresponding relationship index table M in (1) related to the power source y and the corresponding table M for data storage. y That's it.
[0080] (9) Continue to execute operations (2) to (8) until the microgrid is no longer in operation.
[0081] (10) When querying data, find the table name M of the power storage data through the power type of the corresponding index table M in (1). z , and then query.
[0082] Embodiment 2:
[0083] Based on the same inventive concept, the present invention also provides a distributed renewable energy data management system, comprising:
[0084] An acquisition module, used for acquiring operation data of the power source to be stored in the distributed renewable energy;
[0085] A query module, used for searching the table name corresponding to the power source to be stored based on the pre-built relationship index table and the type of the power source to be stored;
[0086] A storage module, used for storing the operating data of the power supply to be stored in a table corresponding to the table name;
[0087] Wherein, the relationship index table includes: power type and table name corresponding to the power type.
[0088] In an embodiment, the system further comprises a construction module for constructing a relationship index table;
[0089] The building blocks include:
[0090] A classification unit, used for classifying the power sources of distributed renewable energy and establishing a table for storing data for each type of power source;
[0091] A naming unit, used to name the table and obtain a corresponding table name;
[0092] A construction unit, used to construct a relational index table based on index information consisting of power type and corresponding table name;
[0093] Among them, the power supply types include: wind power, photovoltaics, energy storage, solar thermal and DC piles.
[0094] In an embodiment, the query module includes:
[0095] A search unit, configured to search the relational index table based on the type of power source to be stored;
[0096] A table name acquisition unit, used for acquiring a table name corresponding to the power source to be stored when there is a type of power source to be stored in the relational index table;
[0097] A newly adding unit is used to construct a table based on the type of power source to be stored when there is no type of power source to be stored in the relationship index table, and to add index information to the relationship index table.
[0098] Obviously, the described embodiments are only some embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0099] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.
[0100] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.
[0101] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.
[0102] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.
[0103] The above are merely embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention are included in the scope of the claims of the present invention to be approved.
Claims
1. A data management method for distributed renewable energy, characterized in that: include: Obtaining operating data of power sources to be stored in distributed renewable energy sources; Based on the pre-built relational index table and the type of the power source to be stored, searching for the table name corresponding to the power source to be stored; Storing the operating data of the power source to be stored in the table corresponding to the table name; Wherein, the relationship index table includes: power type and table name corresponding to the power type; The step of storing the operating data of the power supply to be stored in the table corresponding to the table name includes: When the power source to be stored needs to store process data, the current moment data and the relevant attributes of the current moment are stored in the table corresponding to the table name, otherwise the data obtained at the current moment of the power source to be stored is compared with the data stored in the table at the previous moment; When the data acquired by the power source to be stored at the current moment is the same as the data stored in the table at the previous moment, the data acquired at the current moment is filtered out, otherwise the data at the current moment and the related attributes at the current moment are stored in the table corresponding to the table name; The related attributes include: current state, controlled state, and control type.
2. The method according to claim 1, characterized in that The construction of the relationship index table includes: Classify the power sources of distributed renewable energy and establish a table to store data for each type of power source; Name the table and obtain the corresponding table name; Construct a relational index table based on index information consisting of power type and corresponding table name; Among them, the power supply types include: wind power, photovoltaics, energy storage, solar thermal and DC piles.
3. The method according to claim 2, characterized in that The searching for the table name corresponding to the power source to be stored based on the pre-built relational index table and the type of the power source to be stored includes: Searching in the relational index table based on the type of power to be stored; When there is a type of power source to be stored in the relational index table, obtaining a table name corresponding to the power source to be stored; When the type of power source to be stored does not exist in the relational index table, a table is constructed based on the type of power source to be stored, and index information is added to the relational index table.
4. The method according to claim 3, characterized in that The constructing of a table based on the type of the power source to be stored and adding index information to the relationship index table includes: Based on the type of power source to be stored, a table for storing operation data corresponding to the power source type is constructed, and a table name corresponding to the table is determined; Add a row to the relationship index table to record the newly added power type and the table name.
5. The method according to claim 2, characterized in that After the relationship index table is constructed, the following steps are also included: When an existing power type needs to be deleted, the index information corresponding to the power type in the relationship index table and the table for storing the power type data are deleted.
6. The method according to claim 1, characterized in that The obtaining of the operation data of the power source to be stored in the distributed renewable energy source includes: The operation data of the power source to be stored in the distributed renewable energy is obtained at a set time interval.
7. A data management system for distributed renewable energy, characterized in that: include: An acquisition module, used for acquiring operation data of the power source to be stored in the distributed renewable energy; A query module, used for searching the table name corresponding to the power source to be stored based on the pre-built relationship index table and the type of the power source to be stored; A storage module, used for storing the operating data of the power supply to be stored in a table corresponding to the table name; Wherein, the relationship index table includes: power type and table name corresponding to the power type; The storage module is specifically used for: When the power source to be stored needs to store process data, the current moment data and the relevant attributes of the current moment are stored in the table corresponding to the table name, otherwise the data obtained at the current moment of the power source to be stored is compared with the data stored in the table at the previous moment; When the data acquired by the power source to be stored at the current moment is the same as the data stored in the table at the previous moment, the data acquired at the current moment is filtered out, otherwise the data at the current moment and the related attributes at the current moment are stored in the table corresponding to the table name; The related attributes include: current state, controlled state, and control type.
8. The system according to claim 7, characterized in that The system also includes a construction module, which is used to construct a relationship index table; The building blocks include: A classification unit, used for classifying the power sources of distributed renewable energy and establishing a table for storing data for each type of power source; A naming unit, used to name the table and obtain a corresponding table name; A construction unit, used to construct a relational index table based on index information consisting of power type and corresponding table name; Among them, the power supply types include: wind power, photovoltaics, energy storage, solar thermal and DC piles.
9. The system according to claim 7, characterized in that The query module comprises: A search unit, configured to search the relational index table based on the type of power source to be stored; A table name acquisition unit, used for acquiring a table name corresponding to the power source to be stored when there is a type of power source to be stored in the relational index table; A newly adding unit is used to construct a table based on the type of power source to be stored when there is no type of power source to be stored in the relationship index table, and to add index information to the relationship index table.
Citation Information
Patent Citations
Method and system for carrying out multi-dimensional regional inquiry on distribution type sequence table
CN103020204A
Mass data united storage method based on unified indexing and search method
CN103390015A