CN112445796A - New energy station report generation method - Google Patents
New energy station report generation method Download PDFInfo
- Publication number
- CN112445796A CN112445796A CN202011205671.3A CN202011205671A CN112445796A CN 112445796 A CN112445796 A CN 112445796A CN 202011205671 A CN202011205671 A CN 202011205671A CN 112445796 A CN112445796 A CN 112445796A
- Authority
- CN
- China
- Prior art keywords
- station
- measuring point
- user
- equipment
- database table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 37
- 238000013507 mapping Methods 0.000 claims description 10
- 238000004146 energy storage Methods 0.000 claims description 9
- 238000005259 measurement Methods 0.000 claims description 6
- 238000012423 maintenance Methods 0.000 abstract description 6
- 230000008520 organization Effects 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 9
- 238000001914 filtration Methods 0.000 description 8
- 230000006978 adaptation Effects 0.000 description 4
- 238000000354 decomposition reaction Methods 0.000 description 3
- 230000011664 signaling Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000000694 effects Effects 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
- 238000012938 design process Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000000007 visual effect Effects 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/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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2246—Trees, e.g. B+trees
-
- 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/248—Presentation of query results
-
- 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02E—REDUCTION OF GREENHOUSE GAS [GHG] EMISSIONS, RELATED TO ENERGY GENERATION, TRANSMISSION OR DISTRIBUTION
- Y02E40/00—Technologies for an efficient electrical power generation, transmission or distribution
- Y02E40/70—Smart grids as climate change mitigation technology in the energy generation sector
-
- 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)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Software Systems (AREA)
- Human Resources & Organizations (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
A new energy field station report generation method is characterized in that a corresponding special model database table is determined according to a field station type selected by a user, the special model database table comprises the corresponding relation between field station identifications of all field stations under the same type and equipment information of equipment contained in the field stations, a model tree corresponding to the selected field station type is generated according to a general model database table and the determined special model database table, the model tree is displayed so that the user can select equipment to be inquired, measuring point attribute data corresponding to the equipment ID are extracted from the measuring point database table according to the equipment ID of the equipment selected by the user, and a new energy field station report including the corresponding relation between a measuring point attribute standard name and the measuring point attribute data is generated. The method can be adapted to various types of station models, can be used by operation and maintenance personnel without mastering database knowledge, can provide more logical operations for retrieving the measuring points, and has efficient model organization and interface display capacity, so that the new energy station report system is easier to use, more efficient and better to use.
Description
Technical Field
The invention relates to the technical field of electric power, in particular to a new energy station report generation method.
Background
The new energy station generally refers to a station which utilizes unconventional energy to use or convert energy, and specifically refers to a photovoltaic station, an energy storage station, a wind power station, a microgrid station and the like in practical application. With the scale of the new energy station becoming larger and larger, more and more equipment is provided, which results in the station-level model and data size becoming larger and the operation and maintenance work being complicated. The demands of operation and maintenance personnel on the report forms are changed in the scene, so that a more convenient and quicker report form making mode is favored, and the user-defined report forms can be made without mastering database knowledge and a station model.
The current new energy station report system faces the following problems:
1) the new energy station comprises various stations of photovoltaic, energy storage, wind power and microgrid, and because the database models of each station are different, a report system suitable for a certain station needs to be developed or modified in a targeted manner in order to be applied to other stations;
2) the report data is often stored depending on a database, and the database needs to be operated in the report making process, so that a user is required to have certain database application capacity, which is not always available to operation and maintenance personnel.
Disclosure of Invention
Objects of the invention
The invention aims to provide a new energy station report generation method which can be adapted to various types of station models, can be used by operation and maintenance personnel without mastering database knowledge, can provide more logical operations for retrieving measuring points, and has efficient model organization and interface display capability, so that a new energy station report system is easier to use, more efficient and better to use.
(II) technical scheme
In order to solve the above problems, the present invention provides a new energy station report generation method, including:
determining a corresponding special model database table according to the station type selected by a user, wherein the special model database table comprises the corresponding relation between station identifications of all stations of the same type and equipment information of equipment contained in the station, the equipment information comprises equipment ID, and the station type comprises a photovoltaic station, an energy storage station, a wind power station or a microgrid station;
generating a model tree corresponding to the selected station type according to a general model database table and a determined special model database table, and displaying the model tree to enable a user to select equipment to be queried, wherein the general model database table comprises corresponding relations between station identifications of all types of stations and station information;
and extracting the measuring point attribute data corresponding to the equipment ID from the measuring point database table according to the equipment ID of the equipment selected by the user, and generating a new energy station report form containing the corresponding relation between the measuring point attribute standard name and the measuring point attribute data.
Further, before determining the corresponding special model database table according to the station type selected by the user, the method further includes:
a list of site type options is displayed to allow the user to select a site type from the list of options.
Specifically, the determining a corresponding special model database table according to the station type selected by the user specifically includes:
loading a preset database table configuration file, wherein the configuration file comprises the corresponding relation between the site type and the special model database table;
and determining a special model database table corresponding to the station type according to the station type selected by the user based on the database table configuration file.
Specifically, generating a model tree corresponding to the selected station type according to the general model database table and the determined special model database table specifically includes:
determining all station identifications under the station type and equipment information corresponding to each station according to the determined special model database table;
according to the determined station identification and the general model database table, station information corresponding to each station is determined;
and generating a model tree according to the station information and the equipment information.
Specifically, measuring point attribute data corresponding to the equipment ID is extracted from a measuring point database table according to the equipment ID of the equipment selected by the user, and a new energy site report containing the corresponding relation between the measuring point attribute standard name and the measuring point attribute data is generated, and the method specifically comprises the following steps:
determining a measuring point type according to the equipment ID of the equipment selected by the user;
determining a corresponding measuring point attribute standard name and a user-defined English name of the measuring point attribute in a measuring point database table according to the measuring point type based on a preset mapping relation;
extracting measuring point attribute data corresponding to the equipment ID from the measuring point database table according to the user-defined English name;
and establishing a corresponding relation between the standard name of the measuring point attribute and the measuring point attribute data, and generating a new energy station report.
In an alternative embodiment, the determining the station type according to the device ID of the device selected by the user comprises:
displaying a measuring point type option list corresponding to the equipment according to the equipment ID of the equipment selected by the user, so that the user can select a measuring point type from the measuring point type option list;
and determining the measuring point type according to the selection of the user.
In another alternative embodiment, said determining the station type from the device ID of the device selected by the user comprises:
determining a device type based on a device ID of a device selected by a user;
and determining the measuring point type corresponding to the equipment ID of the equipment selected by the user based on the preset mapping relation between the equipment type and the measuring point type.
Further, the establishing of the corresponding relationship between the standard name of the measuring point attribute and the measuring point attribute data and the generating of the new energy station report includes:
displaying a measuring point attribute standard name list so that a user can select measuring point attributes;
and generating a new energy station report containing the corresponding relation between the standard name of the measuring point attribute and the attribute value according to the selection of the user.
Further, when the equipment to be inquired comprises a plurality of measuring points, establishing a corresponding relation among measuring point identifications, measuring point attribute standard names and measuring point attribute data, and generating a new energy station report.
Further, the report generation method further includes:
acquiring an attribute data boundary input by a user;
determining measuring point marks of the measuring point attribute data in the data boundary according to the input attribute data boundary;
and establishing a corresponding relation among the measuring point identification, the measuring point attribute standard name and the measuring point attribute data according to the determined measuring point identification, and generating a new energy station report with specific attributes.
(III) advantageous effects
The technical scheme of the invention has the following beneficial technical effects:
the method can be adapted to various types of station models, can be used by operation and maintenance personnel without mastering database knowledge, can provide more logical operations for retrieving the measuring points, and has efficient model organization and interface display capacity, so that the new energy station report system is easier to use, more efficient and better to use.
Drawings
FIG. 1 is a flowchart of a new energy site report generation method provided by the present invention;
fig. 2 is a schematic diagram of a new energy station report generation method according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings in conjunction with the following detailed description. It should be understood that the description is intended to be exemplary only, and is not intended to limit the scope of the present invention. Moreover, in the following description, descriptions of well-known structures and techniques are omitted so as to not unnecessarily obscure the concepts of the present invention.
Referring to fig. 1, the present invention provides a new energy station report generation method, including:
step 101: determining a corresponding special model database table according to the station type selected by a user, wherein the special model database table comprises the corresponding relation between station identifications of all stations of the same type and equipment information of equipment contained in the station, the equipment information comprises equipment ID, and the station type comprises a photovoltaic station, an energy storage station, a wind power station or a microgrid station;
step 102: generating a model tree corresponding to the selected station type according to a general model database table and a determined special model database table, and displaying the model tree to enable a user to select equipment to be queried, wherein the general model database table comprises corresponding relations between station identifications of all types of stations and station information;
step 103: and extracting the measuring point attribute data corresponding to the equipment ID from the measuring point database table according to the equipment ID of the equipment selected by the user, and generating a new energy station report form containing the corresponding relation between the measuring point attribute standard name and the measuring point attribute data.
Specifically, the model tree in the present invention may include a plurality of stations of a specific type and station information such as corresponding station names and location information, and further include device information such as device names and device IDs of all devices included in each station, and may be generated according to an existing model tree generation method, which is not limited in the present invention; the attribute of the measuring point includes measuring point information such as acquisition time, storage period, station to which the measuring point belongs, measurement type (such as phase-A current, phase-B voltage and the like), and the like, and can be specifically set according to requirements, and the invention is not limited.
For different types of stations, the contained equipment is different, each type of station corresponds to a special model database table, the measuring point database table is a general database table of each type of station, the new energy station report generation method provided by the invention can determine the corresponding special database table by selecting the type of the station through establishing the corresponding relation between the type of the station and the special database table, so as to generate model trees of each station corresponding to the type, and can select specific equipment to be measured under a certain station through the model trees, so as to call attribute data from the measuring point database table to generate the attribute report corresponding to the measuring point of the equipment Is more efficient and better in use.
Further, before determining the corresponding special model database table according to the station type selected by the user, the method further includes:
a list of site type options is displayed to allow the user to select a site type from the list of options.
The method is convenient for the user to intuitively select the station types according to the needs, the user can generate the required report without mastering the database knowledge, and meanwhile, the database adaptation development work caused by different models due to different station types can be reduced.
Specifically, the determining a corresponding special model database table according to the station type selected by the user specifically includes:
loading a preset database table configuration file, wherein the configuration file comprises the corresponding relation between the site type and the special model database table;
and determining a special model database table corresponding to the station type according to the station type selected by the user based on the database table configuration file.
The method can establish the one-to-one corresponding relation between the site type and the special model database table by loading the configuration file of the relevant database table, has simple operation and is convenient for developing and debugging personnel to maintain programs.
Specifically, generating a model tree corresponding to the selected station type according to the general model database table and the determined special model database table specifically includes:
determining all station identifications under the station type and equipment information corresponding to each station according to the determined special model database table;
according to the determined station identification and the general model database table, station information corresponding to each station is determined;
and generating a model tree according to the station information and the equipment information.
Specifically, measuring point attribute data corresponding to the equipment ID is extracted from a measuring point database table according to the equipment ID of the equipment selected by the user, and a new energy site report containing the corresponding relation between the measuring point attribute standard name and the measuring point attribute data is generated, and the method specifically comprises the following steps:
determining a measuring point type according to the equipment ID of the equipment selected by the user;
determining a corresponding measuring point attribute standard name and a user-defined English name of the measuring point attribute in a measuring point database table according to the measuring point type based on a preset mapping relation;
extracting measuring point attribute data corresponding to the equipment ID from the measuring point database table according to the user-defined English name;
and establishing a corresponding relation between the standard name of the measuring point attribute and the measuring point attribute data, and generating a new energy station report. In an optional embodiment, the mapping relation between the standard name of the measure point attribute and the custom English name of the measure point attribute in the measure point database table is stored in a configuration file.
Specifically, in the invention, the measuring point types include telemetry, remote signaling, telepulse and the like, and the invention is not limited; the custom English name refers to the name of the measuring point attribute in the database table, and is compiled by a programmer according to certain rules, for example, the custom English name SEQSVTIMERID, SEQSAVETIMERID corresponds to the measuring point attribute with the standard name of "storage period".
The method can automatically identify corresponding attribute data from the database by establishing the corresponding relation between the standard names of the measuring point attributes of different measuring point types and the user-defined English names of the measuring point attributes in the database table.
In an optional embodiment, the determining the station type according to the device ID of the device of the user includes:
displaying a measuring point type option list corresponding to the equipment according to the equipment ID of the equipment selected by the user, so that the user can select a measuring point type from the measuring point type option list;
and determining the measuring point type according to the selection of the user.
In another alternative embodiment, said determining the station type from the device ID of the device selected by the user comprises:
determining a device type based on a device ID of a device selected by a user;
and determining the measuring point type corresponding to the equipment ID of the equipment selected by the user based on the preset mapping relation between the equipment type and the measuring point type. Specifically, the establishing of the corresponding relationship between the standard name of the measuring point attribute and the measuring point attribute data to generate a new energy site report includes:
displaying a measuring point attribute standard name list so that a user can select measuring point attributes;
and generating a new energy station report containing the corresponding relation between the standard name of the measuring point attribute and the attribute value according to the selection of the user.
The measuring point attribute standard name list is displayed, so that a user can filter the measuring point attributes as required, a report is generated more specifically, and the report generation time is reduced.
Further, when the equipment to be inquired comprises a plurality of measuring points, establishing a corresponding relation among measuring point identifications, measuring point attribute standard names and measuring point attribute data, and generating a new energy station report.
Further, when the apparatus includes a plurality of stations, it further includes: acquiring an attribute data boundary input by a user; determining measuring point marks of the measuring point attribute data in the data boundary according to the input attribute data boundary; and establishing a corresponding relation among the measuring point identification, the measuring point attribute standard name and the measuring point attribute data according to the determined measuring point identification, and generating a new energy station report with specific attributes.
The following is a specific embodiment of the present invention:
a new energy station report generation method sequentially comprises the functions of station selection, database adaptation, model decomposition and measuring point filtering. Referring to fig. 2, the functions are described as follows:
1) station type selection: the new energy field station report comprises four report services of a photovoltaic field station report, an energy storage field station report, a wind power field station report and a microgrid field station report, in order that the report system can be accurately matched with different reports, namely different database models, a specific type of field station needs to be selected through a field station partition function at the initial generation stage of the report, and then other operations of the report are carried out.
2) Database adaptation: after the user selects the report service of the specific station, the report system loads the preset configuration file of the special model database table. The configuration file includes a one-to-one correspondence between different station types and table names of the special model database, for example, the equipment layer information of the energy storage stations is stored in a storage table, and the equipment layer information of the microgrid stations is often stored in an equipment table. The report system determines the database table to be searched for next obtaining the database model by reading the table name of the special model database of the selected site type, namely, the report system is adapted to different types of databases according to the selected site type and the configuration file.
3) Model decomposition: the data volume of the new energy station is much larger than that of the traditional transformer substation, the data volume of the new energy station is tens of thousands of less information, and the data volume of the new energy station is hundreds of thousands of information, and a common transformer substation report system can query all the information once and organize the information into a visual structure, so that a large amount of memory and time can be consumed, the memory cannot be released in a short time, and the problems of interface blockage, unsmooth operation and the like can occur. Aiming at the problems, the hierarchical linkage query and display can be carried out according to the station model, and the method specifically comprises the following steps:
a) inquiring information of stations and equipment, organizing data to an operation interface according to levels, waiting for a user to select specific equipment, determining types (such as remote measurement) of inquiry measuring points, and determining specific attribute information of the inquiry measuring points;
b) the report system acquires enough query conditions according to the user operation, queries corresponding data in the database according to the query conditions, and organizes data contents to an interface table;
c) the specific attribute information of the query measuring point is determined, a configuration file of the preset field mapping attribute standard name can be read and displayed for a user to select, and the configuration file stores the mapping relation between each English field (the self-defined English name of the measuring point attribute) in different data tables (telemetering, remote signaling or telepulse) and the measuring point attribute standard name.
4) And (3) measuring point filtering: based on the data in the interface table, the user can filter the attribute information of the fields to conveniently and quickly find the intended measuring point, for example, filtering out the measuring point storing the data once every 1 hour through the field of the storage period, filtering out the measuring point representing the current through the field of the type of the measuring point, and the like.
With reference to fig. 2, the new energy station report design process is as follows:
1) selecting a station type, and selecting one of report businesses of four station types of a photovoltaic station, an energy storage station, a wind power station and a microgrid station by a user;
2) under the determined station type, reading configuration files of special model database tables of different station types, corresponding to the selected station type, and determining the special model database table under the station type;
3) initializing database connection according to database configuration information set by a user, inquiring model information of the type of station from the database by a report system based on the special model database table and the general database table (including all types of stations and corresponding station information), only inquiring equipment levels (namely which stations are shared and which equipment is arranged under each station), and organizing the stations and equipment model data according to the levels to an operation interface to form a model tree;
4) and (3) user operation: according to a certain device selected under a certain station, inquiring a database, analyzing the type of a measuring point actually contained under the device and displaying the type to an interface, and selecting and inquiring a remote measuring (or remote signaling, remote pulse) data table by a user;
5) the report system reads a configuration file of the field mapping measuring point attribute standard name of the data table, corresponds to the remote measuring data table, and completely loads the measuring point attribute standard name corresponding to the table to the operation interface;
6) and (3) user operation: selecting a measuring point attribute standard name of a measuring point to be inquired to determine a telemetry table field to be inquired;
7) the report system inquires the selected field data of all corresponding records in the remote measuring data table according to the field, equipment and remote measuring table field selected by the user, and organizes the data to the interface table according to the remote measuring point number sequence;
8) and (3) user operation: based on the interface table data, filtering measuring points (for example, measuring points with the storage period of 1 hour) through selected fields (attribute data boundaries), and refreshing the table interface by the report system according to the filtering condition;
9) and (3) user operation: selecting a remote measuring point to be displayed on the report, and determining query time through a time plug-in;
10) and inquiring corresponding data in the telemetering historical data table according to the selected measuring point and the inquiring time, displaying the inquired historical data in a form or curve mode, and outputting a report.
According to the report generation method provided by the embodiment, a specific service field is selected through a field station type selection function, a scene is determined for a subsequent function, and four scene services including a photovoltaic field station, an energy storage field station, a wind power field station and a microgrid field station are compatible; the database adaptation function is adopted to adapt to the databases under various station types, so that the report system can be suitable for various station models, and repeated development is reduced; huge new energy station data information is displayed to a user hierarchically through a model decomposition function, and the problems of memory occupation, slow database query, unsmooth user interface operation and the like caused by a large amount of data are solved; through the measuring point filtering function, a stronger measuring point filtering function can be provided for a user, and measuring point data required to be displayed in a report form can be quickly screened out.
Generally speaking, by the report design method, a user can quickly and conveniently complete the report design of various new energy service types through better interface operation experience under the conditions of not knowing huge and complex model information of a new energy station and not mastering database skills.
It is to be understood that the above-described embodiments of the present invention are merely illustrative of or explaining the principles of the invention and are not to be construed as limiting the invention. Therefore, any modification, equivalent replacement, improvement and the like made without departing from the spirit and scope of the present invention should be included in the protection scope of the present invention. Further, it is intended that the appended claims cover all such variations and modifications as fall within the scope and boundaries of the appended claims or the equivalents of such scope and boundaries.
Claims (10)
1. A new energy station report generation method is characterized by comprising the following steps:
determining a corresponding special model database table according to the station type selected by a user, wherein the special model database table comprises the corresponding relation between station identifications of all stations of the same type and equipment information of equipment contained in the station, the equipment information comprises equipment ID, and the station type comprises a photovoltaic station, an energy storage station, a wind power station or a microgrid station;
generating a model tree corresponding to the selected station type according to a general model database table and a determined special model database table, and displaying the model tree to enable a user to select equipment to be queried, wherein the general model database table comprises corresponding relations between station identifications of all types of stations and station information;
and extracting the measuring point attribute data corresponding to the equipment ID from the measuring point database table according to the equipment ID of the equipment selected by the user, and generating a new energy station report form containing the corresponding relation between the measuring point attribute standard name and the measuring point attribute data.
2. A report generation method according to claim 1, before determining the corresponding special model database table according to the station type selected by the user, further comprising:
a list of site type options is displayed to allow the user to select a site type from the list of options.
3. A report generation method according to claim 1, wherein the determining of the corresponding special model database table according to the station type selected by the user specifically includes:
loading a preset database table configuration file, wherein the configuration file comprises the corresponding relation between the site type and the special model database table;
and determining a special model database table corresponding to the station type according to the station type selected by the user based on the database table configuration file.
4. A report generation method according to claim 1, wherein the generation of the model tree corresponding to the selected site type according to the general model database table and the specific model database table includes:
determining all station identifications under the station type and equipment information corresponding to each station according to the determined special model database table;
according to the determined station identification and the general model database table, station information corresponding to each station is determined;
and generating a model tree according to the station information and the equipment information.
5. The report generation method according to claim 1, wherein the point attribute data corresponding to the device ID is extracted from the point database table according to the device ID of the device selected by the user, and a new energy site report including a corresponding relationship between a point attribute standard name and the point attribute data is generated, specifically comprising:
determining a measuring point type according to the equipment ID of the equipment selected by the user;
determining a corresponding measuring point attribute standard name and a user-defined English name of the measuring point attribute in a measuring point database table according to the measuring point type based on a preset mapping relation;
extracting measuring point attribute data corresponding to the equipment ID from the measuring point database table according to the user-defined English name;
and establishing a corresponding relation between the standard name of the measuring point attribute and the measuring point attribute data, and generating a new energy station report.
6. A report generation method according to claim 5, characterized in that said determining of the station type from the device ID of the device selected by the user comprises:
displaying a measuring point type option list corresponding to the equipment according to the equipment ID of the equipment selected by the user, so that the user can select a measuring point type from the measuring point type option list;
and determining the measuring point type according to the selection of the user.
7. A report generation method according to claim 5, characterized in that said determining of the station type from the device ID of the device selected by the user comprises:
determining a device type based on a device ID of a device selected by a user;
and determining the measuring point type corresponding to the equipment ID of the equipment selected by the user based on the preset mapping relation between the equipment type and the measuring point type.
8. The report generation method according to claim 5, wherein the establishing of the corresponding relationship between the standard name of the measure point attribute and the measure point attribute data to generate the new energy field report comprises:
displaying a measuring point attribute standard name list so that a user can select measuring point attributes;
and generating a new energy station report containing the corresponding relation between the standard name of the measuring point attribute and the attribute value according to the selection of the user.
9. The report generation method according to claim 5, wherein when the device to be queried includes a plurality of measurement points, a corresponding relationship between the measurement point identification, the measurement point attribute standard name and the measurement point attribute data is established to generate a new energy site report.
10. A report generation method according to claim 9, further comprising:
acquiring an attribute data boundary input by a user;
determining measuring point marks of the measuring point attribute data in the data boundary according to the input attribute data boundary;
and establishing a corresponding relation among the measuring point identification, the measuring point attribute standard name and the measuring point attribute data according to the determined measuring point identification, and generating a new energy station report with specific attributes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011205671.3A CN112445796B (en) | 2020-11-02 | 2020-11-02 | New energy station report generation method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011205671.3A CN112445796B (en) | 2020-11-02 | 2020-11-02 | New energy station report generation method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112445796A true CN112445796A (en) | 2021-03-05 |
| CN112445796B CN112445796B (en) | 2024-03-01 |
Family
ID=74736571
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011205671.3A Active CN112445796B (en) | 2020-11-02 | 2020-11-02 | New energy station report generation method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112445796B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113687895A (en) * | 2021-08-18 | 2021-11-23 | 广东电网有限责任公司 | Method and device for displaying equipment information |
| CN113687895B (en) * | 2021-08-18 | 2024-06-07 | 广东电网有限责任公司 | Display method and device for equipment information |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090049064A1 (en) * | 2007-08-15 | 2009-02-19 | Lori Alquier | Data and application model for configurable tracking and reporting system |
| US20090193050A1 (en) * | 2008-01-25 | 2009-07-30 | Avaya Inc. | Report database dependency tracing through business intelligence metadata |
| US7640264B1 (en) * | 2005-09-23 | 2009-12-29 | Emc Corporation | System and methods for querying a report database |
| CN105740333A (en) * | 2016-01-23 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Visual advertisement management platform, and implementation method thereof |
| CN107832533A (en) * | 2017-11-15 | 2018-03-23 | 国网江苏省电力有限公司 | A kind of real-time monitoring and displaying method and system of transformer station based on three-dimensional information model |
| CN107944659A (en) * | 2017-10-24 | 2018-04-20 | 许继电气股份有限公司 | A kind of substation supervisory control system auto report completing method and apparatus |
| CN111444293A (en) * | 2020-04-17 | 2020-07-24 | 重庆市勘测院 | Intelligent report generation method for multi-source heterogeneous safety monitoring data |
-
2020
- 2020-11-02 CN CN202011205671.3A patent/CN112445796B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7640264B1 (en) * | 2005-09-23 | 2009-12-29 | Emc Corporation | System and methods for querying a report database |
| US20090049064A1 (en) * | 2007-08-15 | 2009-02-19 | Lori Alquier | Data and application model for configurable tracking and reporting system |
| US20090193050A1 (en) * | 2008-01-25 | 2009-07-30 | Avaya Inc. | Report database dependency tracing through business intelligence metadata |
| CN105740333A (en) * | 2016-01-23 | 2016-07-06 | 北京掌阔移动传媒科技有限公司 | Visual advertisement management platform, and implementation method thereof |
| CN107944659A (en) * | 2017-10-24 | 2018-04-20 | 许继电气股份有限公司 | A kind of substation supervisory control system auto report completing method and apparatus |
| CN107832533A (en) * | 2017-11-15 | 2018-03-23 | 国网江苏省电力有限公司 | A kind of real-time monitoring and displaying method and system of transformer station based on three-dimensional information model |
| CN111444293A (en) * | 2020-04-17 | 2020-07-24 | 重庆市勘测院 | Intelligent report generation method for multi-source heterogeneous safety monitoring data |
Non-Patent Citations (2)
| Title |
|---|
| 王战英;王占宏;: "基于元数据的分布式通用查询系统研究与实现", 微型电脑应用, no. 08 * |
| 陈爱林;叶锋;耿明志;张海东;徐歆;任浩;: "一种IEC 61850通用数据类数据库信息模型的建模方法", 电力系统自动化, no. 13 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113687895A (en) * | 2021-08-18 | 2021-11-23 | 广东电网有限责任公司 | Method and device for displaying equipment information |
| CN113687895B (en) * | 2021-08-18 | 2024-06-07 | 广东电网有限责任公司 | Display method and device for equipment information |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112445796B (en) | 2024-03-01 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US5604892A (en) | Method for modeling a physical system of elements using a relational database | |
| WO2023115842A1 (en) | Data-driven offline and online integrated simulation system and method for power distribution network | |
| CN101771581B (en) | Server-side simulating system based on IEC61850 and method thereof | |
| CN106777808B (en) | Network resource generation method based on standardized CAD drawing | |
| CN112039197A (en) | Automatic mapping method of distribution room topological graph and computer readable storage medium | |
| CN111159365B (en) | Implementation method, system and storage medium of scheduling model ontology intelligent question-answering system | |
| CN106815409B (en) | Analysis method of power grid topological relation | |
| CN112948572A (en) | Method for visually displaying equipment information and relation of power system through knowledge graph | |
| CN207473028U (en) | Distribution Fault Location System | |
| CN110852023A (en) | Automatic generation method and device for primary main wiring diagram of intelligent substation | |
| CN110046391A (en) | Transforming plant primary wiring diagram automatic generation method based on monitoring information table | |
| CN107944659B (en) | Method and device for automatically generating plant station monitoring system report | |
| CN113722311A (en) | Power distribution network power failure range positioning method, system, equipment and medium | |
| CN113642850A (en) | Data fusion method and terminal for power distribution network planning | |
| CN107124035B (en) | Method and device for processing station area identification information | |
| CN112445796B (en) | New energy station report generation method | |
| CN103226794A (en) | Data processing method of power transmission and distribution line | |
| CN107977419A (en) | A kind of nuclear power station DCS O＆Ms support file identification method and system | |
| CN110674235A (en) | Marketing and distribution topology file synchronous management system and method | |
| CN104317879B (en) | A kind of telemetry real-time exhibition method based on real-time data base | |
| CN114049082A (en) | Power grid technical improvement overhaul cost data structuring method | |
| CN114818631A (en) | Method and device for compiling over-plan power utilization and power limiting line modification table | |
| CN113407172A (en) | Distribution cloud master station-based automatic platform area graph display system and method | |
| CN105302921B (en) | Map class date storage method and system | |
| CN110688390A (en) | Power station map navigation system, method, equipment and storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |