CN112445796B - New energy station report generation method - Google Patents
New energy station report generation method Download PDFInfo
- Publication number
- CN112445796B CN112445796B CN202011205671.3A CN202011205671A CN112445796B CN 112445796 B CN112445796 B CN 112445796B CN 202011205671 A CN202011205671 A CN 202011205671A CN 112445796 B CN112445796 B CN 112445796B
- Authority
- CN
- China
- Prior art keywords
- measuring point
- station
- equipment
- type
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 35
- 238000013507 mapping Methods 0.000 claims description 10
- 238000004146 energy storage Methods 0.000 claims description 9
- 238000012423 maintenance Methods 0.000 abstract description 6
- 230000008520 organization Effects 0.000 abstract description 3
- 238000001914 filtration Methods 0.000 description 10
- 238000005259 measurement Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 8
- 230000006978 adaptation Effects 0.000 description 4
- 238000000354 decomposition reaction Methods 0.000 description 3
- 238000013461 design Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 230000011664 signaling Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000000903 blocking effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 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
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 station report generation method includes determining a corresponding special model database table according to station types selected by a user, wherein the special model database table contains the corresponding relation between station identifications of all stations in the same type and equipment information of equipment contained in the stations, generating a model tree corresponding to the selected station types according to the general model database table and the determined special model database table, displaying the model tree so that the user can select equipment to be queried, extracting measuring point attribute data corresponding to the equipment IDs from the measuring point database table according to the equipment IDs of the equipment selected by the user, and generating a new energy station report containing the corresponding relation between measuring point attribute standard names and the measuring point attribute data. The method can be adapted to various site models, can be used by operation and maintenance personnel without mastering database knowledge, can provide more logic operations to search the measuring points, has high-efficiency model organization and interface display capability, and enables the new energy site report system to be 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 for using or converting energy by using unconventional energy, and in practical application, the new energy station specifically refers to a photovoltaic station, an energy storage station, a wind power station, a micro-grid station and the like. As the scale of new energy stations is larger and larger, equipment is more and more, so that station-level models and data volume are larger, and operation and maintenance work is complicated. The requirements of operation and maintenance personnel on the report form are changed under the scene, the report form making mode is more convenient and quicker, and the custom report form can be made under the condition that the knowledge of a database and a site model are not required to be mastered.
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 micro-grid, and because the database models of each station are different, a report system applicable to a certain station needs to be developed or modified in a targeted way in order to be applicable to other stations;
2) Report data often depends on database storage, and the database needs to be operated in the report making process, so that users are required to have certain database application capabilities, and operation and maintenance personnel often do not have the capabilities.
Disclosure of Invention
Object of the invention
The invention aims to provide a new energy station report generation method which can be adapted to various station models, can be used by operation and maintenance personnel without mastering database knowledge, can provide more logic operations to search measuring points, has high-efficiency model organization and interface display capability, and enables a new energy station report system to be easier to use, more efficient and better to use.
(II) technical scheme
In order to solve the problems, the invention provides a new energy station report generation method, which comprises 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 in the same type and equipment information of equipment contained in the stations, the equipment information comprises equipment IDs, and the station type comprises a photovoltaic station, an energy storage station, a wind power station or a micro-grid 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 so that a user selects equipment to be queried, wherein the general database table contains the corresponding relation between station identifications and station information of all types of stations;
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 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 comprises:
a list of venue type options is displayed to enable the user to select a venue 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 a corresponding relation between a station type and a 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 according to the determined special model database table and equipment information corresponding to each station;
determining station information corresponding to each station according to the determined station identification and the universal model database table;
and generating a model tree according to the station information and the equipment information.
Specifically, according to the equipment ID of the equipment selected by the user, extracting the measuring point attribute data corresponding to the equipment ID from the measuring point database table, and generating a new energy station report containing the corresponding relation between the standard name of the measuring point attribute and the measuring point attribute data, specifically comprising:
determining the type of the measuring point according to the equipment ID of the equipment selected by the user;
based on a preset mapping relation, determining a corresponding measuring point attribute standard name and a custom English name of the measuring point attribute in a measuring point database table according to the measuring point type;
extracting measuring point attribute data corresponding to the equipment ID from a measuring point database table according to the custom English name;
and establishing a corresponding relation between the measuring point attribute standard name and measuring point attribute data, and generating a new energy station report.
In an alternative embodiment, the determining the type of the measurement point according to the device ID of the device selected by 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 the measuring point type from the measuring point type option list;
and determining the type of the measuring point according to the selection of the user.
In another alternative embodiment, the determining the type of the measurement point according to the device ID of the device selected by the user includes:
determining a device type based on a device ID of the user selected device;
and determining the measuring point type corresponding to the equipment ID of the equipment selected by the user based on the mapping relation between the preset equipment type and the measuring point type.
Further, the establishing a correspondence between the standard name of the measuring point attribute and the measuring point attribute data, and generating a new energy station report, includes:
displaying a standard name list of the measuring point attribute so that a user can select the measuring point attribute;
and generating a new energy station report containing the corresponding relation between the measuring point attribute standard name and the attribute value according to the selection of the user.
Further, when the equipment to be queried comprises a plurality of measuring points, corresponding relations among the measuring point identifiers, the measuring point attribute standard names and the measuring point attribute data are established, and a new energy station report is generated.
Further, the report generating method further comprises the following steps:
acquiring attribute data boundaries input by a user;
determining a measuring point identifier of the measuring point attribute data in the data boundary according to the input attribute data boundary;
and according to the determined measuring point identification, establishing a corresponding relation among the measuring point identification, the measuring point attribute standard name and the measuring point attribute data, and generating a new energy station report with specific attributes.
(III) beneficial effects
The technical scheme of the invention has the following beneficial technical effects:
the method can be adapted to various site models, can be used by operation and maintenance personnel without mastering database knowledge, can provide more logic operations to search the measuring points, has high-efficiency model organization and interface display capability, and enables the new energy site report system to be easier to use, more efficient and better to use.
Drawings
FIG. 1 is a flow chart of a new energy station report generation method provided by the invention;
fig. 2 is a schematic diagram of a new energy station report generating method according to an embodiment of the present invention.
Detailed Description
The objects, technical solutions and advantages of the present invention will become more apparent by the following detailed description of the present invention with reference to the accompanying drawings. It should be understood that the description is only illustrative and is not intended to limit the scope of the invention. In addition, in the following description, descriptions of well-known structures and techniques are omitted so as not to unnecessarily obscure the present invention.
Referring to fig. 1, the invention provides a new energy station report generation method, which comprises the following steps:
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 in the same type and equipment information of equipment contained in the stations, the equipment information comprises equipment IDs, and the station type comprises a photovoltaic station, an energy storage station, a wind power station or a micro-grid 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 so that a user selects equipment to be queried, wherein the general database table contains the corresponding relation between station identifications and station information of all types of stations;
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 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, corresponding station information such as station names and position information, and further include device information such as device names and device IDs of all devices included in each station, and may specifically be generated according to an existing model tree generating method, which is not limited in the present invention; the measuring point attribute comprises measuring point information such as acquisition time, storage period, station, measurement type (such as A phase current, B phase voltage and the like), and the like, and can be specifically set according to the needs, and the invention is not limited.
For different types of stations, the equipment contained in the station 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, and the new energy station report generation method provided by the invention can determine the corresponding special database table by establishing the corresponding relation between the station type and the special database table, so that each station model tree corresponding to the type is generated, the specific equipment to be measured under a certain station can be selected through the model tree, and the attribute data can be extracted from the measuring point database table to generate the attribute report corresponding to the equipment measuring point.
Further, before determining the corresponding special model database table according to the station type selected by the user, the method further comprises:
a list of venue type options is displayed to enable the user to select a venue type from the list of options.
The method is convenient for users to intuitively select the types of the stations according to the needs, the users can generate the required report without mastering the knowledge of the database, and meanwhile, database adaptation development work caused by different models due to different types of the stations 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 a corresponding relation between a station type and a 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 correspondence between the station type and the special model database table by loading the related database table configuration file, and is simple in operation and convenient for development 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 according to the determined special model database table and equipment information corresponding to each station;
determining station information corresponding to each station according to the determined station identification and the universal model database table;
and generating a model tree according to the station information and the equipment information.
Specifically, according to the equipment ID of the equipment selected by the user, extracting the measuring point attribute data corresponding to the equipment ID from the measuring point database table, and generating a new energy station report containing the corresponding relation between the standard name of the measuring point attribute and the measuring point attribute data, specifically comprising:
determining the type of the measuring point according to the equipment ID of the equipment selected by the user;
based on a preset mapping relation, determining a corresponding measuring point attribute standard name and a custom English name of the measuring point attribute in a measuring point database table according to the measuring point type;
extracting measuring point attribute data corresponding to the equipment ID from a measuring point database table according to the custom English name;
and establishing a corresponding relation between the measuring point attribute standard name and measuring point attribute data, and generating a new energy station report. In an alternative embodiment, the mapping relationship between the standard name of the measurement point attribute and the custom english name of the measurement point attribute in the measurement point database table is stored in the configuration file.
Specifically, in the invention, the types of the measuring points comprise telemetry, remote signaling, remote pulse and the like, and the invention is not limited; the custom english names refer to the attribute names of the measuring points in the database table, and are compiled by a programmer according to a certain rule, for example, the custom english names SEQSVTIMERID, SEQSAVETIMERID all correspond to the measuring point attributes 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 custom English names of the measuring point attributes in the database table.
In an alternative embodiment, the determining the type of the measurement point 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 the measuring point type from the measuring point type option list;
and determining the type of the measuring point according to the selection of the user.
In another alternative embodiment, the determining the type of the measurement point according to the device ID of the device selected by the user includes:
determining a device type based on a device ID of the user selected device;
and determining the measuring point type corresponding to the equipment ID of the equipment selected by the user based on the mapping relation between the preset equipment type and the measuring point type. Specifically, the establishing a correspondence between the standard name of the measuring point attribute and the measuring point attribute data, and generating a new energy station report form includes:
displaying a standard name list of the measuring point attribute so that a user can select the measuring point attribute;
and generating a new energy station report containing the corresponding relation between the measuring point attribute standard name and the attribute value according to the selection of the user.
By displaying the standard name list of the measuring point attribute, a user can filter the measuring point attribute according to the requirement, so that a report can be generated more pertinently, and the report generation time is reduced.
Further, when the equipment to be queried comprises a plurality of measuring points, corresponding relations among the measuring point identifiers, the measuring point attribute standard names and the measuring point attribute data are established, and a new energy station report is generated.
Further, when the apparatus includes a plurality of measurement points, it further includes: acquiring attribute data boundaries input by a user; determining a measuring point identifier of the measuring point attribute data in the data boundary according to the input attribute data boundary; and according to the determined measuring point identification, establishing a corresponding relation among the measuring point identification, the measuring point attribute standard name and the measuring point attribute data, and generating a new energy station report with specific attributes.
The following is one embodiment of the present invention:
the new energy station report generation method sequentially comprises station selection, database adaptation, model decomposition and station filtering. With reference to fig. 2, the functions are described as follows:
1) Station type selection: the new energy station report comprises four types of report services, namely a photovoltaic station report, an energy storage station report, a wind power station report and a micro-grid station report, and in order for a report system to accurately adapt to different reports, namely to accurately adapt to different database models, in the early stage of report generation, a station partition function is needed to select a station of a specific type, and then other operations of the report are performed.
2) Database adaptation: after the user selects the report business of the specific station, the report system loads the preset special model database table configuration file. The configuration file includes a one-to-one correspondence between different site types and special model database table names, for example, energy storage site device layer information is stored in a storage table, and device layer information of a micro-grid site is often stored in an equivalence table. The report system determines the database table to be searched by the database model by reading the table name of the special model database of the selected station type, namely, the report system adapts databases of different types according to the selected station 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, tens of thousands of four-remote information and hundreds of thousands of four-remote information are fewer, and a common transformer substation report system can inquire and organize all the information into a visual structure at one time, so that a large amount of memory and time are consumed, the memory is not released in a short time, and the problems of interface blocking, unsmooth operation and the like can occur at the moment. Aiming at the problem, the method can be used for carrying out hierarchical linkage inquiry and display according to a station model, and specifically comprises the following steps:
a) Firstly, inquiring station and equipment information, organizing data to an operation interface according to a hierarchy, waiting for a user to select specific equipment, determining the type (such as telemetry) of an inquiring measuring point, and determining specific attribute information of the inquiring measuring point;
b) The report system obtains enough query conditions according to the user operation, queries corresponding data in the database according to the query conditions, and organizes the data content into an interface table;
c) The specific attribute information of the query measuring point can be determined by reading a preset configuration file of field mapping attribute standard names, and displaying the configuration file to a user for selection, wherein the configuration file stores the mapping relation between each English field (custom English name of the measuring point attribute) and the measuring point attribute standard name in different data tables (telemetry, remote signaling or remote pulse).
4) And (3) measuring point filtration: based on the data in the interface table, the user can conveniently and quickly find the intended measuring point by filtering attribute information of a plurality of fields, such as filtering out the measuring point storing data once every 1 hour through a 'storage period' field, filtering out the measuring point representing current through a 'measuring point type' field, and the like.
With reference to fig. 2, the new energy station report design flow is as follows:
1) Selecting a station type, wherein a user selects one of report services of four station types, namely a photovoltaic station, an energy storage station, a wind power station and a micro-grid station;
2) Under the determined station type, the configuration files of special model database tables of different station types are read, the special model database table under the station type is determined corresponding to the selected station type;
3) Initializing database connection according to database configuration information set by a user, inquiring the type of site model information from the database by a report system based on the special model database table and the general database table (comprising all types of sites and corresponding site information), only inquiring equipment levels (namely, which sites are shared and which equipment is arranged under each site), and organizing site and equipment model data to an operation interface according to the levels to form a model tree;
4) User operation: inquiring a database according to a certain device selected from a certain station, analyzing the type of a measuring point actually contained in the device, displaying the measuring point type on an interface, and selecting and inquiring a telemetry (or remote signaling and remote pulse) data table by a user;
5) The report system reads a configuration file of the standard names of the attribute of the mapping measuring points of the fields of the data table, corresponds to the telemetry data table, and loads all the standard names of the attribute of the measuring points corresponding to the table to an operation interface;
6) User operation: selecting a measuring point attribute standard name of a measuring point to be queried to determine a telemetry table field to be queried;
7) The report system inquires the selected field data of all the records corresponding to the telemetry data table according to the field station, the equipment and the telemetry table field selected by the user, and organizes the data to the interface table according to the sequence of the telemetry point numbers;
8) User operation: filtering the measuring points (for example, filtering the measuring points with a storage period of 1 hour) through the selected fields (attribute data boundaries) based on the interface table data, and refreshing the table interface by the report system according to the filtering conditions;
9) User operation: selecting a telemetry measuring point which is wanted to be displayed by a report, and determining inquiry time through a time plug-in;
10 Inquiring the corresponding data in the telemetry history data table according to the selected measuring points and the inquiring time, displaying the inquired history data in a table 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 station type selection function, and scenes are determined for subsequent functions, so that four scene services of a photovoltaic station, an energy storage station, a wind power station and a micro-grid station are compatible; through the function of database adaptation, the database under various station types is adapted, so that the report system can be suitable for various station models, and repeated development is reduced; the data information of huge new energy stations is displayed to users in a layered manner through a model decomposition function, so that the problems of memory occupation, slow database inquiry, clamping of 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 by a report form can be rapidly screened out.
In general, through the report form design method, a user can quickly and conveniently complete report form design of multiple 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 grasping database skills.
It is to be understood that the above-described embodiments of the present invention are merely illustrative of or explanation of the principles of the present invention and are in no way limiting of the invention. Accordingly, any modification, equivalent replacement, improvement, etc. made without departing from the spirit and scope of the present invention should be included in the scope of the present invention. Furthermore, the appended claims are intended to cover all such changes and modifications that fall within the scope and boundary of the appended claims, or equivalents of such scope and boundary.
Claims (8)
1. The new energy station report generation method is characterized by comprising the following steps of:
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 in the same type and equipment information of equipment contained in the stations, the equipment information comprises equipment IDs, and the station type comprises a photovoltaic station, an energy storage station, a wind power station or a micro-grid 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 so that a user selects equipment to be queried, wherein the general database table contains the corresponding relation between station identifications and station information of all types of stations;
the method specifically comprises the steps of generating a model tree corresponding to a selected station type according to a general model database table and a determined special model database table, wherein the model tree specifically comprises the following steps:
determining all station identifications under the station type according to the determined special model database table and equipment information corresponding to each station;
determining station information corresponding to each station according to the determined station identification and the universal model database table;
generating a model tree according to the station information and the equipment information;
extracting measuring point attribute data corresponding to the equipment ID from a measuring point database table according to the equipment ID of equipment selected by a user, and generating a new energy station report containing the corresponding relation between the standard name of the measuring point attribute and the measuring point attribute data, wherein the new energy station report specifically comprises the following steps:
determining the type of the measuring point according to the equipment ID of the equipment selected by the user;
based on a preset mapping relation, determining a corresponding measuring point attribute standard name and a custom English name of the measuring point attribute in a measuring point database table according to the measuring point type;
extracting measuring point attribute data corresponding to the equipment ID from a measuring point database table according to the custom English name;
and establishing a corresponding relation between the measuring point attribute standard name and measuring point attribute data, and generating a new energy station report.
2. The report generating method as claimed in claim 1, wherein,
before determining the corresponding special model database table according to the station type selected by the user, the method further comprises the following steps:
a list of venue type options is displayed to enable the user to select a venue type from the list of options.
3. The report generating method as claimed in claim 1, wherein,
the determining a corresponding special model database table according to the station type selected by the user specifically comprises the following steps:
loading a preset database table configuration file, wherein the configuration file comprises a corresponding relation between a station type and a 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. The report generating method as claimed in claim 1, wherein,
the determining the type of the measuring point according to the device ID of the device selected by the user comprises the following steps:
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 the measuring point type from the measuring point type option list;
and determining the type of the measuring point according to the selection of the user.
5. The report generating method as claimed in claim 1, wherein,
the determining the type of the measuring point according to the device ID of the device selected by the user comprises the following steps:
determining a device type based on a device ID of the user selected device;
and determining the measuring point type corresponding to the equipment ID of the equipment selected by the user based on the mapping relation between the preset equipment type and the measuring point type.
6. The report generating method as claimed in claim 1, wherein,
the establishing the corresponding relation between the measuring point attribute standard name and the measuring point attribute data, and generating a new energy station report form comprises the following steps:
displaying a standard name list of the measuring point attribute so that a user can select the measuring point attribute;
and generating a new energy station report containing the corresponding relation between the measuring point attribute standard name and the attribute value according to the selection of the user.
7. The report generating method as claimed in claim 1, wherein,
when the equipment to be queried comprises a plurality of measuring points, corresponding relations among the measuring point identifiers, the measuring point attribute standard names and the measuring point attribute data are established, and a new energy station report is generated.
8. The report generating method as claimed in claim 7, wherein,
further comprises:
acquiring attribute data boundaries input by a user;
determining a measuring point identifier of the measuring point attribute data in the data boundary according to the input attribute data boundary;
and according to the determined measuring point identification, establishing a corresponding relation among the measuring point identification, the measuring point attribute standard name and the measuring point attribute data, 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 CN112445796A (en) | 2021-03-05 |
| CN112445796B true 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) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113687895B (en) * | 2021-08-18 | 2024-06-07 | 广东电网有限责任公司 | Display method and device for equipment information |
Citations (5)
| 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 |
| 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 |
Family Cites Families (2)
| 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 |
| US8856182B2 (en) * | 2008-01-25 | 2014-10-07 | Avaya Inc. | Report database dependency tracing through business intelligence metadata |
-
2020
- 2020-11-02 CN CN202011205671.3A patent/CN112445796B/en active Active
Patent Citations (5)
| 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 |
| 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 |
|---|
| 一种IEC 61850通用数据类数据库信息模型的建模方法;陈爱林;叶锋;耿明志;张海东;徐歆;任浩;;电力***自动化(13);全文 * |
| 基于元数据的分布式通用查询***研究与实现;王战英;王占宏;;微型电脑应用(08);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112445796A (en) | 2021-03-05 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109669983B (en) | Visual multi-data-source ETL tool | |
| US5604892A (en) | Method for modeling a physical system of elements using a relational database | |
| CN111159365B (en) | Implementation method, system and storage medium of scheduling model ontology intelligent question-answering system | |
| CN107943831B (en) | HBase-based power grid historical data centralized storage method | |
| CN106126528B (en) | A kind of moonlet test basic information generation method based on platform model | |
| 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 | |
| CN110108955A (en) | A kind of new-energy grid-connected performance automatic test analysis platform and detection method | |
| CN109389326B (en) | Monitoring event-oriented object modeling method, device and system | |
| CN207473028U (en) | Power distribution network fault positioning system | |
| CN110852023A (en) | Automatic generation method and device for primary main wiring diagram of intelligent substation | |
| CN112445796B (en) | New energy station report generation method | |
| CN105279275A (en) | Point list configuration method of dispatch master station end | |
| CN107944659B (en) | Method and device for automatically generating plant station monitoring system report | |
| CN112672370A (en) | Method, system, equipment and storage medium for automatically detecting network element index data | |
| CN113642850A (en) | Data fusion method and terminal for power distribution network planning | |
| CN107124035B (en) | Method and device for processing station area identification information | |
| CN109189873A (en) | A kind of Meteorological Services big data monitoring analysis system platform | |
| CN109271350B (en) | Database and information point table automatic comparison and synchronization method based on telecontrol communication | |
| CN110674235A (en) | Marketing and distribution topology file synchronous management system and method | |
| CN112488642B (en) | Cloud file management method based on structured labels and taking object as core | |
| CN112286884B (en) | Method, system and medium for automatically generating topology of ring main unit of power distribution network | |
| CN114049082A (en) | Power grid technical improvement overhaul cost data structuring method | |
| CN104317879B (en) | A kind of telemetry real-time exhibition method based on real-time data base | |
| CN105302921B (en) | Map class date storage method and system |
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 |