CN113760609B - Method for realizing power grid data sharing access - Google Patents
Method for realizing power grid data sharing access Download PDFInfo
- Publication number
- CN113760609B CN113760609B CN202111105829.4A CN202111105829A CN113760609B CN 113760609 B CN113760609 B CN 113760609B CN 202111105829 A CN202111105829 A CN 202111105829A CN 113760609 B CN113760609 B CN 113760609B
- Authority
- CN
- China
- Prior art keywords
- data
- access
- database
- unit
- power grid
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
-
- 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/21—Design, administration or maintenance of databases
-
- 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/23—Updating
-
- 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—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/06—Electricity, gas or water supply
Abstract
The invention discloses a method for realizing power grid data sharing access in the technical field of data access, which comprises a data access system, wherein the working method of the data access system comprises the following steps: the data processing module processes and uploads the data; the data backup module is used for backing up the power grid data and generating a database of the power grid data, and simultaneously setting mapping conditions for the power grid data; the data access module provides a database access request, generates a database mapping condition and can download data; and the access sharing module processes the power grid data accessed by the data access module to generate the power grid data access frequency. The data backup module is used for setting the access mapping condition of the database, so that when the data is accessed, the related power grid data in the backup database can be quickly called out by setting the access mapping condition, the load pressure can not be generated on the original database, and the access data can be efficiently called.
Description
Technical Field
The invention relates to the technical field of data access, in particular to a method for realizing power grid data sharing access.
Background
The whole of the power substation and the power transmission and distribution line of various voltages in the power system is called a power grid. The power grid comprises three units of power transformation, power transmission and power distribution, wherein the power grid is used for transmitting and distributing electric energy and changing voltage, 6, 10, 20, 35 and 66 kilovolts are medium voltage, 110 and 220 kilovolts are high voltage, 330, 500 and 750 kilovolts are ultrahigh voltage, and direct current 800, alternating current 1000 kilovolts and more are ultrahigh voltage in the power transmission and distribution voltage class. The power grid system relates to a plurality of departments, such as an operation and maintenance department, an operation management department, a user cost management department and the like, when the data of the departments need to be accessed, the departments can only access to the independent data system of the related departments, so that the overall efficiency is lower, and in addition, when the data is accessed, the phenomena of error modification and the like are easily caused to the data, and the data is inaccurate.
Based on the above, the invention designs a method for realizing the shared access of the power grid data so as to solve the problems.
Disclosure of Invention
The invention aims to provide a method for realizing the shared access of power grid data, which aims to solve the problems that a plurality of departments, such as an operation and maintenance department, an operation management department, a user expense management department and the like, are involved in a power grid system in the background technology, and when the data of the departments need to be accessed, the departments can only enter an independent data system of the relevant departments to access, so that the overall efficiency is lower, and in addition, when the data is accessed, the phenomena of error modification and the like are easy to cause, and the data is inaccurate.
In order to achieve the above purpose, the present invention provides the following technical solutions: the method for realizing the power grid data sharing access comprises a data access system consisting of a data processing module, a data backup module, a data access module and an access sharing module, and the working method of the data access system comprises the following steps:
extracting operation, operation maintenance and billing bill data in the power grid system by the data processing module, and processing and uploading the data;
the data backup module is used for backing up the power grid data uploaded by the data processing module and generating a database of the power grid data, and simultaneously setting mapping conditions for the power grid data in the database;
providing a database access request by the data access module, generating a database mapping condition, and simultaneously downloading data in a database;
and the access sharing module processes the power grid data accessed by the data access module to generate the power grid data access frequency.
Preferably, the data processing module includes a data extracting unit, a data integrating unit, and a data uploading unit, where the data extracting unit is used to extract power grid operation data, power grid operation and maintenance data, and power grid billing and billing data in the power grid system, and compress the extracted data, the data integrating unit is used to integrate and sort the data extracted by the data extracting unit and compressed, and the data uploading unit is used to upload the data processed by the data integrating unit.
Preferably, the data backup module includes a database generating unit, a database mirroring unit, and a data mapping unit, where the database generating unit is configured to generate a database for the grid data uploaded by the data processing module, and the database mirroring unit is configured to mirror the database and further backup the database to generate a backup database, where the backup database is used as a data access object, and the data mapping unit generates a data mapping condition based on the grid data in the backup database, and the data mapping condition is used as an access condition of the backup database.
Preferably, the data access module comprises an access request generation unit, a mapping condition generation unit and a data downloading unit, wherein the access request generation unit is used for generating a database access request, the mapping condition generation unit is used for generating a data access mapping condition based on the database access request, and the data downloading unit is used for downloading the grid data of the database in the data backup module based on the data access mapping condition.
Preferably, the access sharing module includes an access data processing unit, an access data frequency generating unit, and an access data updating unit, where the access data processing unit is configured to process the data downloaded by the data access module, so that the data can be displayed in a modeling manner, the access data frequency generating unit is configured to generate the frequency of the data downloaded by the data access module, and each time the data access module downloads, the access frequency is generated, and the access data updating unit is configured to update the data generating the access frequency at a high frequency, and reduce the frequency of updating other data with low frequency or without the access frequency, so as to reduce the system load.
Compared with the prior art, the invention has the beneficial effects that: the access mapping condition of the database is set through the data backup module, so that when the data is accessed, the related power grid data in the backup database can be quickly obtained through setting the access mapping condition, load pressure can not be generated on the original database, the access data can be efficiently called, in addition, even if the data in the backup database is wrongly modified, the original database can not be influenced, the management department can conveniently and timely change the access data, the access sharing module can be used for setting the frequency of the access data, and further, the update frequency of the access data can be selectively set according to the access frequency, and the system load is further reduced.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed for the description of the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a schematic diagram of a frame structure of a data access system of the present invention;
FIG. 2 is a schematic diagram of a frame structure of a data processing module according to the present invention;
FIG. 3 is a schematic diagram of a frame structure of a data backup module according to the present invention;
FIG. 4 is a schematic diagram of a frame structure of a data access module according to the present invention;
FIG. 5 is a schematic diagram of a framework for accessing a shared module according to the present invention.
In the drawings, the list of components represented by the various numbers is as follows:
the system comprises a 1-data processing module, a 101-data extraction unit, a 102-data integration unit, a 103-data uploading unit, a 2-data backup module, a 201-database generating unit, a 202-database mirroring unit, a 203-data mapping unit, a 3-data access module, a 301-access request generating unit, a 302-mapping condition generating unit, a 303-data downloading unit, a 4-access sharing module, a 401-access data processing unit, a 402-access data frequency generating unit and a 403-access data updating unit.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1-5, the present invention provides a technical solution: the method for realizing the power grid data sharing access comprises a data access system consisting of a data processing module 1, a data backup module 2, a data access module 3 and an access sharing module 4, and the working method of the data access system comprises the following steps:
the data processing module 1 extracts operation, operation and maintenance and billing data in the power grid system, processes and uploads the data, the data processing module 1 comprises a data extraction unit 101, a data integration unit 102 and a data uploading unit 103, the data extraction unit 101 is used for extracting power grid operation data, power grid operation and maintenance data and power grid billing data in the power grid system, compressing the extracted data, the data integration unit 102 is used for integrating and sequencing the data which are extracted by the data extraction unit 101 and are subjected to compression processing, and the data uploading unit 103 is used for uploading the data which are processed by the data integration unit 102;
the data backup module 2 is used for backing up the power grid data uploaded by the data processing module 1 and generating a database of the power grid data, and simultaneously setting mapping conditions for the power grid data in the database, the data backup module 2 comprises a database generating unit 201, a database mirroring unit 202 and a data mapping unit 203, the database generating unit 201 is used for generating a database for the power grid data uploaded by the data processing module 1, the database mirroring unit 202 is used for mirroring the database and further backing up the database to generate a backup database, the backup database is used as a data access object, the data mapping unit 203 generates the data mapping conditions based on the power grid data in the backup database, and the data mapping conditions are used as access conditions of the backup database;
the data access module 3 provides a database access request and generates a database mapping condition, and can download data in a database at the same time, the data access module 3 comprises an access request generating unit 301, a mapping condition generating unit 302 and a data downloading unit 303, the access request generating unit 301 is used for generating a database access request, the mapping condition generating unit 302 generates a data access mapping condition based on the database access request, and the data downloading unit 303 downloads grid data of the database in the data backup module 2 based on the data access mapping condition;
the access sharing module 4 processes the grid data accessed by the data access module 3 to generate a grid data access frequency, the access sharing module 4 comprises an access data processing unit 401, an access data frequency generating unit 402 and an access data updating unit 403, the access data processing unit 401 is used for processing the data downloaded by the data access module 3, so that the data can be displayed in a modeling mode, the access data frequency generating unit 402 is used for generating the frequency of the data downloaded by the data access module 3, each time the data access module 3 downloads, the access frequency is generated, the access data updating unit 403 is used for updating the data with the high frequency of the access frequency, and the frequency of other data with the low frequency or without the access frequency is reduced, so that the system load is reduced.
In the description of the present specification, the descriptions of the terms "one embodiment," "example," "specific example," and the like, mean that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present invention. In this specification, schematic representations of the above terms do not necessarily refer to the same embodiments or examples. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples.
The preferred embodiments of the invention disclosed above are intended only to assist in the explanation of the invention. The preferred embodiments are not exhaustive or to limit the invention to the precise form disclosed. Obviously, many modifications and variations are possible in light of the above teaching. The embodiments were chosen and described in order to best explain the principles of the invention and the practical application, to thereby enable others skilled in the art to best understand and utilize the invention. The invention is limited only by the claims and the full scope and equivalents thereof.
Claims (3)
1. The method for realizing the power grid data sharing access is characterized by comprising a data access system consisting of a data processing module (1), a data backup module (2), a data access module (3) and an access sharing module (4), wherein the working method of the data access system comprises the following steps: extracting operation, operation maintenance and billing bill data in a power grid system by the data processing module (1), and processing and uploading the data; the data backup module (2) performs backup on the power grid data uploaded by the data processing module (1) and generates a database of the power grid data, and simultaneously sets mapping conditions on the power grid data in the database; providing a database access request by the data access module (3), generating a database mapping condition, and simultaneously downloading data in a database; the access sharing module (4) processes the power grid data accessed by the data access module (3) to generate power grid data access frequency; the data backup module (2) comprises a database generation unit (201), a database mirroring unit (202) and a data mapping unit (203), wherein the database generation unit (201) is used for generating a database for the power grid data uploaded by the data processing module (1), the database mirroring unit (202) is used for mirroring the database and further backing up the database to generate a backup database, the backup database is used as a data access object, and the data mapping unit (203) generates data mapping conditions based on the power grid data in the backup database, and the data mapping conditions are used as access conditions of the backup database; the data access module (3) comprises an access request generation unit (301), a mapping condition generation unit (302) and a data downloading unit (303), wherein the access request generation unit (301) is used for generating a database access request, the mapping condition generation unit (302) is used for generating a data access mapping condition based on the database access request, and the data downloading unit (303) is used for downloading grid data of a database in the data backup module (2) based on the data access mapping condition.
2. The method for realizing the shared access of the power grid data according to claim 1, wherein the data processing module (1) comprises a data extraction unit (101), a data integration unit (102) and a data uploading unit (103), the data extraction unit (101) is used for extracting power grid operation data, power grid operation and maintenance data and power grid charging bill data in a power grid system, the extracted data is compressed, the data integration unit (102) is used for integrating and ordering the data which are extracted by the data extraction unit (101) and are subjected to compression, and the data uploading unit (103) is used for uploading the data which are processed by the data integration unit (102).
3. A method for implementing grid data sharing access according to claim 1, wherein the access sharing module (4) comprises an access data processing unit (401), an access data frequency generating unit (402) and an access data updating unit (403), the access data processing unit (401) is used for processing data downloaded by the data access module (3) so as to enable the data to be displayed in a modeling manner, the access data frequency generating unit (402) is used for generating the frequency of the data downloaded by the data access module (3), each time the data access module (3) downloads, an access frequency is generated, the access data updating unit (403) is used for performing high-frequency access frequency updating on the data generating the access frequency, and other low-frequency or non-access frequency data updating frequencies are reduced.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111105829.4A CN113760609B (en) | 2021-09-22 | 2021-09-22 | Method for realizing power grid data sharing access |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111105829.4A CN113760609B (en) | 2021-09-22 | 2021-09-22 | Method for realizing power grid data sharing access |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113760609A CN113760609A (en) | 2021-12-07 |
| CN113760609B true CN113760609B (en) | 2023-10-20 |
Family
ID=78796636
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111105829.4A Active CN113760609B (en) | 2021-09-22 | 2021-09-22 | Method for realizing power grid data sharing access |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113760609B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101496005A (en) * | 2005-12-29 | 2009-07-29 | 亚马逊科技公司 | Distributed replica storage system with web services interface |
| CN102207978A (en) * | 2011-06-30 | 2011-10-05 | 北京新媒传信科技有限公司 | Database access method and system |
| CN103927344A (en) * | 2014-03-31 | 2014-07-16 | 国网山东省电力公司 | Data integration method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8639267B2 (en) * | 2008-03-14 | 2014-01-28 | William J. Johnson | System and method for location based exchanges of data facilitating distributed locational applications |
-
2021
- 2021-09-22 CN CN202111105829.4A patent/CN113760609B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101496005A (en) * | 2005-12-29 | 2009-07-29 | 亚马逊科技公司 | Distributed replica storage system with web services interface |
| CN102207978A (en) * | 2011-06-30 | 2011-10-05 | 北京新媒传信科技有限公司 | Database access method and system |
| CN103927344A (en) * | 2014-03-31 | 2014-07-16 | 国网山东省电力公司 | Data integration method |
Non-Patent Citations (2)
| Title |
|---|
| Financial Big Data Hot and Cold Separation Scheme Based on HBase and Redis;Kunhui Li等;《2019 IEEE Intl Conf on Parallel & Distributed Processing with Applications, Big Data & Cloud Computing, Sustainable Computing & Communications, Social Computing & Networking (ISPA/BDCloud/SocialCom/SustainCom)》;第1612-1617页 * |
| 基于Oracle数据库的MELINETSII双机RAC集群系统的设计与实现;胡昌文;《图书馆学研究》;第32-36页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113760609A (en) | 2021-12-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9058443B2 (en) | Planning economic energy dispatch in electrical grid under uncertainty | |
| CN110209635B (en) | PSD-BPA-to-pandapower power system power flow input data conversion method | |
| CN102495841A (en) | Power supply system monitoring method and related device thereof | |
| CN106557870B (en) | Energy-saving potential evaluation method for power grid contract energy management project | |
| CN107656971A (en) | A kind of intelligent grid collection Monitoring Data storage method based on Redis | |
| CN111400393A (en) | Data processing method and device based on multi-application platform and storage medium | |
| CN113760609B (en) | Method for realizing power grid data sharing access | |
| CN110264027B (en) | Member model extension method and system for power-assisted service market | |
| CN109040047A (en) | Indicator card data compression, transmission method and device | |
| CN109492055B (en) | A method of power grid big data warehouse is established based on CIM model | |
| Wogrin | Time series aggregation for optimization: One-size-fits-all? | |
| CN109214927A (en) | Method based on the investment of national grid General Engineering Cost digital simulation electricity power engineering | |
| CN107590211B (en) | Intelligent power grid information system | |
| CN109164297A (en) | Multifunction electric meter | |
| Xu et al. | Fault recovery of distribution network containing distributed generation based on heuristic search algorithm and multi-population genetic algorithm | |
| CN103700040A (en) | Method and device for generating power data report | |
| CN106155841A (en) | The method and system of data backup | |
| CN113052420A (en) | Project feasibility evaluation method based on simulation intelligence | |
| CN111371460B (en) | High-low frequency matching data compression method suitable for intelligent ammeter | |
| Vimlesh et al. | Distributed generation planning in distribution networks by hybrid GA-MCS based optimization | |
| CN112702340B (en) | Historical message compression method and system, computing equipment and storage medium thereof | |
| CN111384720B (en) | Test sequence optimization method and device for multi-terminal direct current transmission system | |
| CN108123436A (en) | Voltage out-of-limit prediction model based on principal component analysis and multivariate regression algorithm | |
| Wang et al. | Research on electric energy information acquisition system based on embedded platform | |
| Bharti et al. | A New Graph Theoretic Power Flow Framework for Microgrid |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Cui Yan Inventor after: Yang Yang Inventor after: Liang Zhihong Inventor after: Liu Mingwei Inventor after: Wang Jinhe Inventor after: Kang Yi Inventor after: Chen Yuxu Inventor after: Ren Haowen Inventor after: Huang Chaoheng Inventor before: Liu Mingwei Inventor before: Xiao Zhanhui Inventor before: Yang Yang Inventor before: Yang Xiaoxue Inventor before: Kang Yi Inventor before: Chen Yuxu Inventor before: Ren Haowen Inventor before: Huang Chaoheng |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |