Equipment ledger equipment dynamic parameter data storage method, system, equipment and medium

Abstract

The invention discloses an equipment ledger equipment dynamic parameter data storage method and system, equipment and a medium. The method comprises the following steps: constructing an equipment directory table according to basic information of equipment in a new energy system; constructing an equipment type table according to the type of equipment in a new energy system, and associating the equipment type table with the equipment directory table; constructing a manufacturer directory table according to the manufacturer names of the devices in the new energy system; constructing an equipment directory dynamic attribute table according to the dynamic data of the equipment types, wherein the equipment directory dynamic attribute table is associated with the equipment type table; a manufacturer equipment classification table is constructed according to equipment manufacturer directory screening conditions, the manufacturer equipment classification table is associated with the manufacturer directory table and the equipment type table, and the method, the system, the equipment and the medium can realize association of equipment ledger business data in a new energy system.

Description

Technical Field

[0001] The present invention belongs to the field of information technology and relates to a method, system, device and medium for storing dynamic parameter data of equipment ledger equipment. Background Art

[0002] The development and optimization of the electricity market trading mechanism has become a top priority. With the increasing proportion of new energy installed capacity in the overall power generation system, it is particularly important to effectively improve the refined management capabilities of new energy companies for site facilities. However, with the continuous increase in equipment in new energy systems and the expansion of the number of equipment, there is no unified dictionary-level equipment inventory information management technology. The existing data storage method can no longer meet the association of equipment inventory business data in new energy systems. Summary of the invention

[0003] The purpose of the present invention is to overcome the shortcomings of the above-mentioned prior art and provide a method, system, device and medium for storing dynamic parameter data of equipment inventory equipment. The method, system, device and medium can realize the association of equipment inventory business data in new energy systems.

[0004] In order to achieve the above object, the present invention adopts the following technical scheme:

[0005] In one aspect of the present invention, the method for storing dynamic parameter data of equipment ledger equipment of the present invention comprises:

[0006] Construct an equipment list based on the basic information of the equipment in the new energy system;

[0007] According to the types of equipment in the new energy system, construct an equipment type table, and associate the equipment type table with the equipment directory table;

[0008] Construct a manufacturer list table based on the manufacturer names of the equipment in the new energy system;

[0009] Constructing a dynamic attribute table of a device directory according to dynamic data of device types, and associating the dynamic attribute table of the device directory with the device type table;

[0010] A manufacturer equipment classification table is constructed according to the equipment manufacturer list screening conditions, and the manufacturer equipment classification table is associated with the manufacturer list table and the equipment type table.

[0011] The device ledger device dynamic parameter data storage method of the present invention is further improved in that:

[0012] Furthermore, the basic information of the equipment includes equipment ID, equipment number, equipment type, installed capacity and commissioning date.

[0013] Furthermore, it also includes:

[0014] The device model of the device in the new energy system is determined, and the device model of the device is associated with the device manufacturer.

[0015] Furthermore, the device model includes a logical model and a factory model.

[0016] Furthermore, the dynamic data of the device type is stored in the dynamic attribute table of the device directory in a row-to-column manner.

[0017] In a second aspect of the present invention, the method for storing dynamic parameter data of equipment ledger equipment of the present invention comprises:

[0018] The first building module is used to build a device list table according to the basic information of the devices in the new energy system;

[0019] A second construction module is used to construct a device type table according to the type of the device in the new energy system, and associate the device type table with the device directory table;

[0020] The third building module is used to build a manufacturer list table according to the manufacturer names of the equipment in the new energy system;

[0021] A fourth construction module is used to construct a dynamic attribute table of a device list according to dynamic data of the device type, wherein the dynamic attribute table of the device list is associated with the device type table;

[0022] The fifth construction module is used to construct a manufacturer equipment classification table according to the device manufacturer list screening conditions, and associate the manufacturer equipment classification table with the manufacturer list table and the device type table.

[0023] The equipment ledger equipment dynamic parameter data storage system of the present invention is further improved in that:

[0024] Furthermore, it also includes:

[0025] The association module is used to determine the device model of the device in the new energy system and associate the device model of the device with the device manufacturer.

[0026] Furthermore, the dynamic data of the device type is stored in the dynamic attribute table of the device directory in a row-to-column manner.

[0027] In the third aspect of the present invention, the computer device described in the present invention includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of the device inventory device dynamic parameter data storage method are implemented.

[0028] In the fourth aspect of the present invention, the computer-readable storage medium of the present invention stores a computer program, and when the computer program is executed by a processor, the steps of the device inventory device dynamic parameter data storage method are implemented.

[0029] The present invention has the following beneficial effects:

[0030] The equipment inventory equipment dynamic parameter data storage method, system, equipment and medium described in the present invention, when in specific operation, starts with basic data based on the characteristics of the new energy system, establishes an equipment directory table, an equipment type table, a manufacturer directory table, an equipment directory dynamic attribute table and a manufacturer equipment classification table, and then associates the equipment type table with the equipment directory table; associates the equipment directory dynamic attribute table with the equipment type table; and associates the manufacturer equipment classification table with the manufacturer directory table and the equipment type table, so as to realize the association of equipment inventory business data in the new energy system. BRIEF DESCRIPTION OF THE DRAWINGS

[0031] The accompanying drawings constituting a part of the present invention are used to provide a further understanding of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the accompanying drawings:

[0032] Figure 1 The figure is a flow chart of the method of the present invention. DETAILED DESCRIPTION

[0033] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0034] In the description of the present invention, it should be understood that the terms “include” and “comprises” indicate the presence of described features, wholes, steps, operations, elements and / or components, but do not exclude the presence or addition of one or more other features, wholes, steps, operations, elements, components and / or collections thereof.

[0035] It should also be understood that the terms used in the present specification are only for the purpose of describing specific embodiments and are not intended to limit the present invention. As used in the present specification and the appended claims, unless the context clearly indicates otherwise, the singular forms "a", "an" and "the" are intended to include plural forms.

[0036] It should be further understood that the term "and / or" used in the present specification and the appended claims refers to any combination of one or more of the associated listed items and all possible combinations, and includes these combinations. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in the present invention generally indicates that the associated objects are in an "or" relationship.

[0037] It should be understood that, although the terms first, second, third, etc. may be used to describe preset ranges, etc. in the embodiments of the present invention, these preset ranges should not be limited to these terms. These terms are only used to distinguish preset ranges from each other. For example, without departing from the scope of the embodiments of the present invention, the first preset range may also be referred to as the second preset range, and similarly, the second preset range may also be referred to as the first preset range.

[0038] The word "if" as used herein may be interpreted as "at the time of" or "when" or "in response to determining" or "in response to detecting", depending on the context. Similarly, the phrases "if it is determined" or "if (stated condition or event) is detected" may be interpreted as "when it is determined" or "in response to determining" or "when detecting (stated condition or event)" or "in response to detecting (stated condition or event)", depending on the context.

[0039] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiment of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiment of the present invention. Obviously, the described embodiment is only an embodiment of a part of the present invention, not all embodiments, and is not intended to limit the scope of the present invention. In addition, in the following description, the description of well-known structures and technologies is omitted to avoid unnecessary confusion of the concepts disclosed in the present invention. Based on the embodiments in the present invention, all other embodiments obtained by ordinary technicians in this field without making creative work should fall within the scope of protection of the present invention.

[0040] The accompanying drawings show schematic diagrams of structures according to embodiments disclosed in the present invention. These figures are not drawn to scale, and some details are magnified and some details may be omitted for the purpose of clear expression. The shapes of various regions and layers shown in the figures and the relative sizes and positional relationships therebetween are only exemplary, and may deviate in practice due to manufacturing tolerances or technical limitations, and those skilled in the art may additionally design regions / layers with different shapes, sizes, and relative positions according to actual needs.

[0041] Embodiment 1

[0042] refer to Figure 1The device account device dynamic parameter data storage method of the present invention comprises the following steps:

[0043] 1) Build a device list;

[0044] The process of step 1) is: create an equipment list table, which is used to store the basic information of each device. The devices are wind turbines and inverters. The basic information includes the general fixed parameter information of the devices. The above fixed parameter information is the basis for building the equipment ledger. For example, the basic information includes the device ID 1011, the device number C1011, the device type 1001, the installed capacity 1500 and the commissioning date.

[0045] 2) Construct a device type table;

[0046] The process of step 2) is: create a device type table, which is used to store detailed information of different device types and the relationship between the basic information of the device in the device directory table. The device type table is used as the basis for classifying device attributes. For example, the device type ID is 1001, the device type is variable pitch dual-fed, the manufacturer ID is 11, and the manufacturer name is Huawei.

[0047] 3) Equipment model (factory model);

[0048] The process of step 3) is: associate the factory model with the specific model manufactured by the manufacturer, which is used to store the type attributes of the device and associate it with the device manufacturer. For example, the data primary key is 100101, the device type ID is 1001, the device type is variable pitch dual-fed, the manufacturer ID is 11, the manufacturer name is Huawei, and all other device attribute values.

[0049] 4) Equipment model (logical model);

[0050] The process of step 4) is as follows: The logical model involves the modifications or customizations that the device may undergo in actual applications. The logical model is used to store the type attributes of the device and is associated with the device manufacturer. For example, the data primary key ID is 100101, the factory device type is 1001, the device type is variable pitch dual-fed, the manufacturer ID is 11, and the manufacturer name is Huawei, etc. All device attribute values.

[0051] 5) Manufacturer list;

[0052] The process of step 5) is: to achieve standardization of manufacturer information, a manufacturer directory table is established, which is used to store all manufacturer names and other information entered into the system in a certain standard format, for example, the manufacturer ID is 11, the manufacturer name is Huawei, the manufacturer address and other manufacturer registration information.

[0053] 6) Dynamic attribute table of equipment list;

[0054] The process of step 6) is: create a dynamic attribute table of the equipment directory, which is used to store dynamic parameters of the equipment type. By converting rows to columns, dynamically changing parameter values ​​are stored and associated with the equipment type table for subsequent query and management. For example, primary key ID, equipment type ID, and storage of fixed parameters.

[0055] 7) Manufacturer equipment classification table;

[0056] The process of step 7) is: Finally, create a manufacturer equipment classification table to store the manufacturer list screening conditions and associate it with the manufacturer list table and the equipment type table. This helps to quickly retrieve relevant information based on the manufacturer and equipment type when needed. For example, the manufacturer ID, manufacturer name is Huawei, the manufacturer equipment type is equipment type ID 1001, etc.

[0057] The present invention has the following characteristics:

[0058] Establishment of standard coding specifications for equipment inventory: sort out equipment inventory data according to different subsystem classifications, and establish clear standard coding specifications for different levels of equipment such as large components, sub-components, and spare parts.

[0059] Visualization of equipment management data flow: Design a transparent and intuitive data management process to monitor and optimize all aspects of equipment management and improve management efficiency and transparency.

[0060] Realization of equipment full life cycle analysis capabilities: With the help of detailed data in dynamic ledgers, we can implement refined management of equipment and support analysis of its entire life cycle, thereby strengthening equipment maintenance and optimization decisions.

[0061] Embodiment 2

[0062] The equipment ledger equipment dynamic parameter data storage system of the present invention comprises:

[0063] The first building module is used to build a device list table according to the basic information of the devices in the new energy system;

[0064] A second construction module is used to construct a device type table according to the type of the device in the new energy system, and associate the device type table with the device directory table;

[0065] The third building module is used to build a manufacturer list table according to the manufacturer names of the equipment in the new energy system;

[0066] A fourth construction module is used to construct a dynamic attribute table of a device list according to dynamic data of the device type, wherein the dynamic attribute table of the device list is associated with the device type table;

[0067] The fifth construction module is used to construct a manufacturer equipment classification table according to the device manufacturer list screening conditions, and associate the manufacturer equipment classification table with the manufacturer list table and the device type table.

[0068] The division of modules in the embodiments of the present application is schematic and is only a logical function division. There may be other division methods in actual implementation. In addition, each functional module in each embodiment of the present application may be integrated into a processor, or may exist physically separately, or two or more modules may be integrated into one module. The above-mentioned integrated modules may be implemented in the form of hardware or in the form of software functional modules.

[0069] Embodiment 3

[0070] A computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps of implementing the method for storing dynamic parameter data of the equipment ledger equipment are implemented, for example, including: constructing an equipment directory table according to the basic information of the equipment in the new energy system; constructing an equipment type table according to the type of equipment in the new energy system, and associating the equipment type table with the equipment directory table; constructing a manufacturer directory table according to the manufacturer name of the equipment in the new energy system; constructing an equipment directory dynamic attribute table according to the dynamic data of the equipment type, and associating the equipment directory dynamic attribute table with the equipment type table; constructing a manufacturer equipment classification table according to the equipment manufacturer directory screening conditions, and associating the manufacturer equipment classification table with the manufacturer directory table and the equipment type table. Among them, the memory may include a memory, such as a high-speed random access memory, and may also include a non-volatile memory, such as at least one disk memory, etc.; the processor, the network interface, and the memory are interconnected through an internal bus, and the internal bus can be an industrial standard architecture bus, a peripheral component interconnection standard bus, an extended industrial standard structure bus, etc. The bus can be divided into an address bus, a data bus, a control bus, etc. The memory is used to store programs, specifically, the programs may include program codes, and the program codes include computer operation instructions. The memory may include internal memory and non-volatile memory, and provide instructions and data to the processor.

[0071] Embodiment 4

[0072] A computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the device ledger device dynamic parameter data storage method are implemented, for example, including: constructing a device list table according to the basic information of the equipment in the new energy system; constructing a device type table according to the type of equipment in the new energy system, and associating the device type table with the device list table; constructing a manufacturer list table according to the manufacturer name of the equipment in the new energy system; constructing a device list dynamic attribute table according to the dynamic data of the device type, and associating the device list dynamic attribute table with the device type table; constructing a manufacturer device classification table according to the device manufacturer list screening conditions, and associating the manufacturer device classification table with the manufacturer list table and the device type table. Specifically, the computer-readable storage medium includes, but is not limited to, for example, volatile memory and / or non-volatile memory. The volatile memory may include random access memory (RAM) and / or cache memory (cache), etc. The non-volatile memory may include read-only memory (ROM), hard disk, flash memory, optical disk, disk, etc.

[0073] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0074] The present application is described with reference to the flowcharts and / or block diagrams of the methods, devices (systems), and computer program products according to the embodiments of the present application. It should be understood that each process and / or box in the flowchart and / or block diagram, as well as the combination of the processes and / or boxes in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to generate a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1 A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0075] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture including an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0076] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0077] Those skilled in the art will readily appreciate other embodiments of the present invention after considering the specification and disclosure of the invention. This application is intended to cover any variations, uses or adaptations of the present invention that follow the general principles of the present invention and include common knowledge or customary techniques in the art that are not disclosed by the present invention. The specification and examples are to be considered exemplary only, and the true scope and spirit of the present invention are indicated by the following claims.

[0078] It should be understood that the present invention is not limited to the exact construction that has been described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the present invention is limited only by the appended claims.

[0079] The above description is only a preferred embodiment of the present invention and does not limit the present invention in any way. Any simple modification, change and equivalent structural change made to the above embodiment based on the technical essence of the present invention still falls within the protection scope of the technical solution of the present invention.

Claims

1. A method for storing dynamic parameter data of equipment ledger, characterized in that: include: Construct an equipment list based on the basic information of the equipment in the new energy system; According to the types of equipment in the new energy system, construct an equipment type table, and associate the equipment type table with the equipment directory table; Construct a manufacturer list table based on the manufacturer names of the equipment in the new energy system; Constructing a dynamic attribute table of a device directory according to dynamic data of device types, and associating the dynamic attribute table of the device directory with the device type table; A manufacturer equipment classification table is constructed according to the equipment manufacturer list screening conditions, and the manufacturer equipment classification table is associated with the manufacturer list table and the equipment type table.

2. The method for storing dynamic parameter data of equipment ledger equipment according to claim 1, characterized in that: The basic information of the equipment includes equipment ID, equipment number, equipment type, installed capacity and commissioning date.

3. The method for storing dynamic parameter data of equipment ledger equipment according to claim 1, characterized in that: Also includes: The device model of the device in the new energy system is determined, and the device model of the device is associated with the device manufacturer.

4. The method for storing dynamic parameter data of equipment ledger equipment according to claim 1, characterized in that: The device models include logical models and factory models.

5. The method for storing dynamic parameter data of equipment ledger equipment according to claim 1, characterized in that: The dynamic data of the equipment type is stored in the equipment directory dynamic attribute table in a row-to-column manner.

6. A device ledger device dynamic parameter data storage system, characterized in that: include: The first building module is used to build a device list table according to the basic information of the devices in the new energy system; A second construction module is used to construct a device type table according to the type of the device in the new energy system, and associate the device type table with the device directory table; The third building module is used to build a manufacturer list table according to the manufacturer names of the equipment in the new energy system; A fourth construction module is used to construct a dynamic attribute table of a device list according to dynamic data of the device type, wherein the dynamic attribute table of the device list is associated with the device type table; The fifth construction module is used to construct a manufacturer equipment classification table according to the device manufacturer list screening conditions, and associate the manufacturer equipment classification table with the manufacturer list table and the device type table.

7. The equipment account equipment dynamic parameter data storage system according to claim 6 is characterized in that: Also includes: The association module is used to determine the device model of the device in the new energy system and associate the device model of the device with the device manufacturer.

8. The equipment account equipment dynamic parameter data storage system according to claim 6 is characterized in that: The dynamic data of the equipment type is stored in the equipment directory dynamic attribute table in a row-to-column manner.

9. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the device inventory device dynamic parameter data storage method as described in any one of claims 1-5 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the device inventory device dynamic parameter data storage method as described in any one of claims 1 to 5 are implemented.

Images