Simulation database system special for power equipment and management method thereof

Abstract

The invention provides a special simulation database system for power equipment and a management method thereof. The system comprises a simulation database unit and a data management unit, the simulation database unit is provided with a special simulation database for power equipment, the simulation database is provided with different types of simulation resource libraries and a data interaction module, each simulation resource library stores power simulation resource data according to a standardized mode, and the data interaction module realizes interaction with the data management unit. The data management unit interacts operation data according to static or dynamic data management requirements. According to the system, data standardization and normalization degree are improved by means of related settings, and compatibility and interoperability are optimized. The management method comprises the steps that the data management unit generates an instruction according to requirements and sends the instruction to the special database, the data interaction module interacts with the simulation resource library according to the instruction, comprehensive calling, storage, updating and maintenance of data are completed, the defects of an existing simulation database in dynamic data support and management flexibility are effectively overcome, and the dynamic simulation data management efficiency is improved. And an efficient, accurate and flexible solution is provided for power equipment simulation data management.

Description

Technical Field

[0001] The present invention belongs to the technical field of power equipment simulation, and particularly relates to a special simulation database system for power equipment and its management method. Background Art

[0002] With the rapid development of modern power systems, the design and performance evaluation of power equipment have become increasingly complex. Simulation databases play a crucial role in CAE (Computer-Aided Engineering) simulation calculations, providing engineers with important information about product design and performance. By comprehensively utilizing simulation databases, engineers can conduct product design and performance evaluation more accurately and efficiently, thereby reducing development costs, shortening product time-to-market, and improving product quality. For example, the material model simulation database stores the properties and behavior models of various materials, enabling engineers to accurately simulate the physical properties of materials, such as elasticity, plasticity, and heat conduction, in simulations. The material database contains experimental data of various materials, helping engineers select appropriate material models and providing material parameters for use in simulations.

[0003] Although existing special simulation databases for power equipment have improved the efficiency of simulation work to a certain extent, they still have some significant problems. First, the degree of data standardization and normalization is not high, resulting in poor compatibility and interoperability between different databases, increasing the difficulty of cross-platform data exchange. Second, the database update mechanism is not flexible enough. When new data types need to be added or existing data needs to be modified, manual intervention is often required, which is time-consuming and laborious. Third, most existing simulation databases focus on the management of static data and lack support for dynamic data, such as the recording and analysis of a large number of intermediate results generated during long-running simulations. Summary of the Invention

[0004] In view of this, the present invention provides a special simulation database system for power equipment and its management method to solve the above problems existing in existing special simulation databases for power equipment.

[0005] To achieve the above object, the technical solutions provided by the present invention are as follows:

[0006] In a first aspect, the present invention provides a special simulation database system for power equipment, including:

[0007] A simulation database unit and a data management unit;

[0008] The simulation database unit is provided with a special simulation database for power equipment;

[0009] The special simulation database for power equipment includes several different types of simulation resource libraries and a data interaction module;

[0010] Each simulation resource library stores corresponding power simulation resource data according to the standardized content management method of its affiliated type;

[0011] The data interaction module is used to implement data interaction between the special simulation database for power equipment and the data management unit;

[0012] The data management unit is used to perform data interaction with the simulation database unit through the data interaction module according to the static data management requirements or the dynamic data management requirements during the power equipment simulation process, so as to call, store, update and maintain the data of each simulation resource library according to the standardized content management method.

[0013] Furthermore, different types of simulation resource libraries at least include:

[0014] Geometric model library, material parameter library, equipment condition library, field quantity criterion library and simulation case library;

[0015] The geometric model library stores model establishment resources according to the standardized content management method of classification criteria, element information and file format, and is used to provide the required data resources for power equipment simulation during the model establishment stage;

[0016] The material parameter library stores material parameter resources according to the standardized content management method of classification criteria, element information and necessary material parameter types;

[0017] The equipment condition library stores condition parameter resources according to the standardized content management method of classification criteria and necessary condition parameters;

[0018] The field quantity criterion library stores field quantity criterion resources according to the standardized content management method of classification criteria and criterion types;

[0019] The simulation case library stores case resources according to the standardized content management method of case elements, file naming rules and content requirements of case reports.

[0020] Furthermore, the special simulation database for power equipment adopts the SQLite database architecture, and the data interaction module based on the SQLite database architecture includes the following components:

[0021] Core engine and virtual machine;

[0022] The core engine is used to convert the data management instructions of the data management unit into SQL instructions; the data management instructions are SQL statements generated by the data management unit according to the static data management requirements or the dynamic data management requirements during the power equipment simulation process for managing data;

[0023] The virtual machine is used to perform corresponding management operations on the power simulation resource data in the special simulation database for power equipment according to the SQL instructions.

[0024] Further, the core engine includes:

[0025] an SQL parser and a query optimizer;

[0026] The SQL parser is used to parse SQL statements and convert them into SQL queries;

[0027] The query optimizer is used to optimize the SQL queries to adapt to the standardized content management methods of each power simulation resource database.

[0028] Further, the virtual machine includes:

[0029] a bytecode generator and a virtual machine execution engine;

[0030] The bytecode generator is used to convert the optimized SQL queries into bytecode instructions, and the bytecode instructions include descriptions of management operations;

[0031] The virtual machine execution engine is used to perform corresponding management operations on the power simulation resource data in the power equipment dedicated simulation database according to the bytecode instructions.

[0032] Further, the power equipment dedicated simulation database based on the SQLite database architecture further includes: a storage engine;

[0033] The storage engine is used to store the power simulation resource data of each simulation resource library through a selected data structure.

[0034] Further, the data structure adopts a B-tree data structure.

[0035] Further, the power simulation resource data of the power equipment dedicated simulation database is stored in a database file, and the storage method of the database file adopts page-based storage.

[0036] In a second aspect, the present invention provides a management method for a power equipment dedicated simulation database system, which is implemented based on the power equipment dedicated simulation database system in the first aspect, and includes the following steps:

[0037] Using the data management unit to generate data management instructions according to static data management requirements or dynamic data management requirements during the power equipment simulation process;

[0038] Sending the data management instructions to the power equipment dedicated simulation database of the simulation database unit, so that the data interaction module of the power equipment dedicated simulation database performs data interaction with each simulation resource library according to the data management instructions to complete the invocation, storage, update and maintenance of the power simulation resource data.

[0039] Further, updating and maintaining the power simulation resource data includes the following steps:

[0040] Generate a first instruction or a second instruction using a data management unit; the first instruction is an instruction for adding new data and completing data storage at a specified physical address using the input data, and the second instruction is a command for modifying data and overwriting information stored at an original physical address using the input data;

[0041] Sending the first instruction or the second instruction to the power equipment dedicated simulation database of the simulation database unit, so that the data interaction module of the power equipment dedicated simulation database performs a corresponding operation on the input data according to the first instruction or the second instruction;

[0042] If the data interaction module receives the first instruction, the following operations are performed:

[0043] Using the original data of the power equipment dedicated simulation database as the reference information, and comparing the newly added data in the first instruction with the reference information to determine the repeated parts between the two;

[0044] Store the non-repeated part of the newly added data to the specified physical address in the special simulation database for electric power equipment, store the repeated part to the specified physical address in the special simulation database for electric power equipment or cancel the storage operation;

[0045] If the data interaction module receives the second instruction, it performs the following operations:

[0046] The modified data in the second instruction is replaced with the existing data at the original physical address in the power equipment-specific simulation database.

[0047] In summary, the present invention provides a special simulation database system for electric power equipment, including: a simulation database unit and a data management unit; the simulation database unit is provided with a special simulation database for electric power equipment; the special simulation database for electric power equipment includes several different types of simulation resource libraries and data interaction modules; each simulation resource library stores corresponding electric power simulation resource data in accordance with the standardized content management method of the type to which it belongs; the data interaction module is used to realize data interaction between the special simulation database for electric power equipment and the data management unit; the data management unit is used to interact with the simulation database unit through the data interaction module according to the static data management requirements or the dynamic data management requirements in the simulation process of electric power equipment, so as to call and store, update and maintain the data of each simulation resource library in accordance with the standardized content management method. The database system can improve the degree of data standardization and normalization and improve the compatibility and interoperability of the database by setting different types of simulation resource libraries and data interaction modules and storing data in accordance with the standardized content management method.

[0048] The present invention also provides a management method for a special simulation database system of power equipment, including generating a data management instruction by using a data management unit according to the static data management requirement or the dynamic data management requirement during the power equipment simulation process; sending the data management instruction to the special simulation database of the power equipment in the simulation database unit, so that the data interaction module of the special simulation database of the power equipment can perform data interaction with each simulation resource library according to the data management instruction to complete the invocation, storage, update and maintenance of the power simulation resource data. This management method can realize the comprehensive invocation, storage, update and maintenance of the power simulation resource data according to the static and dynamic data management requirements, effectively making up for the deficiencies of the existing simulation database in terms of dynamic data support and data management flexibility. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings required for the description of the embodiments or the prior art. Obviously, the following drawings are only some embodiments of the present invention. For those of ordinary skill in the art, other drawings can be obtained according to these drawings without creative efforts.

[0050] Figure 1 It is a block diagram of a special simulation database system of power equipment provided by an embodiment of the present invention;

[0051] Figure 2 It is an implementation logic diagram of a special simulation database of power equipment provided by an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0052] In order to make the objectives, features, and advantages of the present invention more obvious and understandable, the following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the drawings in the embodiments of the present invention. Obviously, the following described embodiments are only some embodiments of the present invention, rather than all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those of ordinary skill in the art without creative efforts belong to the scope of protection of the present invention.

[0053] Please refer to Figure 1 : A special simulation database system of power equipment provided by an embodiment of the present invention includes: a simulation database unit and a data management unit;

[0054] The simulation database unit is provided with a special simulation database for power equipment; the special simulation database for power equipment includes several simulation resource libraries of different types and a data interaction module; each simulation resource library stores corresponding power simulation resource data according to the standardized content management method of its belonging type; the data interaction module is used to realize data interaction between the special simulation database for power equipment and the data management unit.

[0055] It should be noted that the special simulation database for power equipment contains several simulation resource libraries of different types. These different types are divided based on factors such as the different natures and uses of the data required in the power equipment simulation process. For example, there may be a resource library for simulating the performance of different components of power equipment, or a resource library for simulating different operating conditions, etc.

[0056] At the same time, a data interaction module is also equipped. This module is responsible for realizing data interaction between the special simulation database for power equipment and the data management unit, enabling effective information transmission and communication between the two units.

[0057] Each simulation resource library stores the corresponding power simulation resource data according to the standardized content management method of its belonging type. This standardized management method can ensure the standardization and consistency of the data, facilitating subsequent data query, call, update and other operations. For example, for a parameter data resource library of a certain type of power equipment, the data values of each parameter are stored according to a unified specified format, classification standard, etc.

[0058] The data management unit is used to perform data interaction with the simulation database unit through the data interaction module according to the static data management requirements or the dynamic data management requirements during the power equipment simulation process, so as to call, store, update and maintain the data of each simulation resource library according to the standardized content management method.

[0059] It should be noted that the data management unit can work according to the static data management requirements (such as the management of some fixed basic parameter data of power equipment during the system initialization stage) or the dynamic data management requirements during the power equipment simulation process (such as the management of real-time generated data such as equipment status change data and real-time energy consumption data during the simulation operation).

[0060] Through the interaction with the simulation database unit, the data of each simulation resource library is called (accurately obtained when specific data is needed for analysis, calculation and other operations), stored (newly generated data or updated data is saved according to the specified method), and updated and maintained (corresponding modifications are made when the data changes or the data quality needs to be optimized to ensure the accuracy and integrity of the data, etc.).

[0061] This embodiment provides a special simulation database system for power equipment. By setting up different types of simulation resource libraries and data interaction modules, and storing data according to the standardized content management method, this system can improve the standardization and normalization of data, and enhance the compatibility and interoperability of the database. The data management unit it possesses can interact with the simulation database unit according to different data management requirements, effectively solving the problems of inflexible existing database update mechanisms and insufficient support for dynamic data.

[0062] In one embodiment, the simulation database for power transmission and transformation equipment consists of a geometric model library, a material parameter library, an equipment operating condition library, a field quantity criterion library, and a simulation case library, which are for simulation practitioners to refer to in the processes of model building, material loading, load application, result analysis, and report generation.

[0063] (1) The geometric model library stores model building resources according to the standardized content management method of classification criteria, element information, and file format, and is used to provide the required data resources for power equipment simulation during the model building stage. The design of classification criteria, element information, and file format can be as follows:

[0064] 1) Classification criteria

[0065] Geometric models are usually classified at the first level by equipment type, at the second level by equipment voltage level, and at the third level by part type.

[0066] 2) Element information

[0067] Geometric model elements include two-dimensional / three-dimensional computer-aided design (CAD) model files, and the model files should cover at least part geometric dimensions and topological relationships.

[0068] 3) File format

[0069] CAD model files should be stored in common file formats, usually including:.x_t,.sat,.asm,.step / stp,.iges / igs,.stl,.dwg,.dxf,.prt, etc.

[0070] (2) The material parameter library stores material parameter resources according to the standardized content management method of classification criteria, element information, and necessary material parameter types. The design of classification criteria, element information, and necessary material parameter types can be as follows:

[0071] 1) Classification criteria

[0072] Material parameters are usually not classified. If classification is needed, they can be classified according to dimensions such as material form and physical field.

[0073] 2) Element information

[0074] Material parameters should provide the values and units of various material parameters according to the classification requirements. If the material parameters vary with physical quantities, it is generally advisable to provide the material parameter values, parameter curves, or empirical formulas under different physical quantity conditions.

[0075] 3) Electric field parameters

[0076] Electric field parameters should include conductivity, relative permittivity, and tangent of the dielectric loss angle.

[0077] 4) Magnetic field parameters

[0078] Magnetic field parameters should include relative permeability and conductivity.

[0079] 5) Structural field parameters

[0080] Structural field parameters should include density, Young's modulus, Poisson's ratio, and coefficient of thermal expansion.

[0081] 6) Fluid field parameters

[0082] Fluid field parameters should include density and viscosity.

[0083] 7) Thermal field parameters

[0084] Thermal field parameters should include thermal conductivity, specific heat capacity, density, and emissivity.

[0085] (3) The equipment operating condition library stores operating condition parameter resources according to the classification standard and the standardized content management method of necessary operating condition parameters. The classification standard and necessary operating condition parameters can be designed as follows:

[0086] 1) Classification standard

[0087] Equipment operating conditions are usually classified at the first level according to equipment type, at the second level according to equipment voltage level, and at the third level according to design conditions and operating conditions.

[0088] 2) Design conditions

[0089] Design conditions should include the content specified in relevant standards or technical specifications for power transmission and transformation equipment. Design conditions need to consider environmental conditions, such as insulation design, temperature rise design, seismic design, etc.

[0090] 3) Operating conditions

[0091] Operating conditions should include the state parameters, environmental parameters, and system parameters of the operation of power transmission and transformation equipment.

[0092] (4) The field quantity criterion library stores field quantity criterion resources according to the classification standard and the standardized content management method of criterion types. The classification standard and criterion types can be designed as follows:

[0093] 1) Classification

[0094] The field quantity criteria are usually classified at the first level according to the equipment type and at the second level according to the criterion type.

[0095] 2) Insulation criterion

[0096] Based on the material properties and application conditions, give the criterion value, unit, and acquisition source of the insulation criterion.

[0097] 3) Magnetic field criterion

[0098] Based on the material properties and application conditions, give the criterion value, unit, and acquisition source of the magnetic field criterion.

[0099] 4) Structure criterion

[0100] Based on the material properties and application conditions, give the criterion value, unit, and acquisition source of the structure criterion.

[0101] 5) Temperature rise criterion

[0102] Based on the material properties and application conditions, give the criterion value, unit, and acquisition source of the temperature rise criterion.

[0103] 6) Noise criterion

[0104] Based on the material properties and application conditions, give the criterion value, unit, and acquisition source of the noise criterion.

[0105] (5) The simulation case library stores case resources according to the standardized content management method of case elements, file naming rules, and content requirements of case reports. The case elements, file naming rules, and content requirements of case reports can be designed as follows:

[0106] 1) Case elements

[0107] Each simulation case should provide a full set of CAE simulation files, which generally include geometric models, material parameter settings, mesh generation settings, loads, boundary conditions, solution settings, and result post-processing settings.

[0108] 2) File naming rules

[0109] The naming of CAE simulation files contains elements and the order is: equipment type, voltage level, object (if any), physical field, software tool and version. For example: "Power transformer - 500kV - winding - magnetic field - COMSOL6.0", "Converter transformer - 800kV - tank - magnetic field and thermal field - MAXWELL2022R1&FLUENT2022R1", "Wall bushing - 500kV - electric field - MAXWELL2022R1".

[0110] 3) Case report

[0111] The simulation case should be accompanied by a case report to explain the basic situation and show pictures in necessary parts. The report content generally includes: background, geometric model, material properties, mesh division, load, boundary conditions, solution settings, calculation results and their analysis.

[0112] In one embodiment, the special simulation database for power equipment adopts the SQLite database architecture. The data interaction module based on the SQLite database architecture includes the following components: a core engine and a virtual machine;

[0113] The core engine is used to convert the data management instructions of the data management unit into SQL instructions; the data management instructions are SQL statements generated by the data management unit according to the static data management requirements or the dynamic data management requirements during the power equipment simulation process for managing data;

[0114] The virtual machine is used to perform corresponding management operations on the power simulation resource data in the special simulation database for power equipment according to the SQL instructions.

[0115] It should be noted that SQLite is a lightweight embedded database engine with advantages such as small size, self - contained, and zero - configuration, and is very suitable for use in some specific application scenarios, such as the management of power equipment simulation data here. It can effectively implement functions such as data storage, management, and query without the need for complex database server configurations.

[0116] The main role of the core engine is to convert the data management instructions generated by the data management unit into SQL instructions. Here, the data management instructions are generated by the data management unit according to different requirements, including static data management requirements (such as during system initialization or in conventional fixed data management scenarios) and dynamic data management requirements during the power equipment simulation process (such as data management requirements generated in real - time during the simulation operation). And these data management instructions themselves exist in the form of SQL statements, and their purpose is to manage data. The core engine is like a translator that converts the SQL statement instructions issued by the data management unit for specific data management tasks into standard SQL instructions in a way that the SQLite database can understand and execute, so as to perform corresponding operations in the SQLite database environment subsequently.

[0117] The virtual machine, based on the SQL instructions converted by the core engine, performs corresponding management operations on the power simulation resource data in the special simulation database for power equipment. These management operations can cover various aspects, such as data query, insertion, update, deletion, etc. That is to say, when the core engine successfully converts the data management instructions into SQL instructions, the virtual machine, based on these SQL instructions, takes actual actions on the power simulation resource data stored in the special simulation database for power equipment in this specific environment to achieve operations such as obtaining the required data according to specific conditions, adding new data records, modifying the values of existing data, or deleting the data that is no longer needed, so as to ensure that the data in the special simulation database for power equipment can be processed in a timely and accurate manner according to different management requirements.

[0118] In one embodiment, the core engine includes: an SQL parser and a query optimizer;

[0119] The SQL parser is used to parse SQL statements and convert them into SQL queries;

[0120] The query optimizer is used to optimize the SQL queries to adapt to the standardized content management methods of each power simulation resource database.

[0121] It should be noted that the main responsibility of the SQL parser is to parse SQL statements. Here, the SQL statements refer to the SQL statements generated by the data management unit according to the static data management requirements or the dynamic data management requirements during the power equipment simulation process for managing data. The SQL parser will conduct a detailed analysis of these input SQL statements according to the syntax rules of the SQL language, etc., to understand the structure, intention, and specific operations involved in the statements (such as query, insertion, update, deletion, etc.).

[0122] After completing the parsing of the SQL statements, the SQL parser will convert them into SQL queries. This conversion process is actually to present the original SQL statements in a form that is more convenient for subsequent processing and execution. The SQL query is a form of preliminary processing and more targeted representation, which clarifies the specific query operations to be performed in the database and their related conditions, etc., providing a basic operation object for the subsequent work of the query optimizer.

[0123] After receiving the SQL query converted by the SQL parser, the query optimizer will optimize it. Since different power simulation resource databases have their own standardized content management methods, these methods may have specific requirements for aspects such as data storage structure and index setting. The task of the query optimizer is to adjust and optimize the SQL query according to these standardized content management methods, so that the finally generated SQL instructions can interact with each power simulation resource database more efficiently and accurately during execution, thereby realizing the effective management of power simulation resource data. For example, if a power simulation resource database stores data according to a specific classification method and sets corresponding indexes, the query optimizer will optimize the SQL query according to these characteristics, so as to be able to locate the required data faster when querying data, reducing unnecessary query operations and resource consumption.

[0124] In one embodiment, the virtual machine includes: a bytecode generator and a virtual machine execution engine;

[0125] The bytecode generator is used to convert the optimized SQL query into bytecode instructions, and the bytecode instructions include descriptions of management operations;

[0126] The virtual machine execution engine is used to perform corresponding management operations on the power simulation resource data in the power equipment dedicated simulation database according to the bytecode instructions.

[0127] It should be noted that the bytecode generator is responsible for further converting the SQL query optimized by the query optimizer into bytecode instructions. The bytecode instructions here contain descriptions of specific management operations (such as data query, insertion, update, deletion, etc.). It is like a "translator", which converts the operation requirements in the form of SQL query, a relatively high-level and database query language-oriented form, into bytecode, a lower-level and more convenient instruction form for the virtual machine execution engine to directly process, laying a foundation for subsequent execution of specific data management operations in the virtual machine environment.

[0128] The virtual machine execution engine then performs corresponding management operations on the power simulation resource data in the power equipment dedicated simulation database according to the bytecode instructions generated by the bytecode generator. It is the part that actually executes specific data management actions. According to the content described in the bytecode instructions, it performs operations such as obtaining specific data, adding new data, modifying existing data, and deleting unnecessary data in the power equipment dedicated simulation database, thereby realizing the effective management of power simulation resource data and ensuring that the data in the database can be accurately processed according to different management requirements.

[0129] In one embodiment, a dedicated simulation database for power equipment based on the SQLite database architecture further includes: a storage engine; the storage engine is used to store the power simulation resource data of each simulation resource library through a selected data structure.

[0130] It should be noted that in the dedicated simulation database for power equipment based on the SQLite database architecture, the storage engine plays a key role. It is responsible for storing the power simulation resource data of each simulation resource library through a selected data structure, ensuring that the data can be saved in a suitable and efficient manner for subsequent querying, calling, updating, and other operations.

[0131] In one embodiment, the data structure in the storage engine adopts a B-tree data structure.

[0132] It should be noted that a B-tree is a balanced multi-way search tree commonly used in database storage. It has good balance and can effectively handle a large amount of data while ensuring the search efficiency. Adopting a B-tree data structure can make the power simulation resource data more efficient in storage and search. For example, when querying power equipment-related data according to specific conditions, the required information can be located quickly.

[0133] In one embodiment, the power simulation resource data of the dedicated simulation database for power equipment is stored in a single database file, and the storage method of the database file adopts page-based storage.

[0134] It should be noted that the power simulation resource data of the dedicated simulation database for power equipment is stored in a single database file, and the storage method is page-based storage. Page-based storage divides the storage space into pages of equal size, and the data is stored and managed in units of pages. This method is convenient for organizing and managing data. For example, when reading or writing data, operations can be performed in units of pages, improving the efficiency of storing and accessing data, and also facilitating the maintenance and management of the database file.

[0135] Please refer to Figure 2 , Figure 2It shows the implementation logic of a special simulation database for power equipment, that is, the user operates on the database through SQL statements. The special simulation database for power equipment based on the SQLite architecture uses an SQL parser to parse SQL statements into internal data structures for further processing. The parsed SQL query is passed to a query optimizer, which then generates a series of bytecode instructions that contain the detailed steps for querying, updating, or other operations on the database. The virtual machine execution engine executes the corresponding operations in the order of the bytecode, and the operations may include reading, writing, indexing, etc. of the database file. The logical architecture of SQLite is a relatively simple but efficient design, suitable for scenarios such as embedded systems and mobile applications.

[0136] The embodiment of the present invention also provides a management method for a special simulation database system for power equipment, which is implemented based on the special simulation database system for power equipment in the foregoing embodiment, and includes the following steps:

[0137] The data management unit generates data management instructions according to the static data management requirements or the dynamic data management requirements during the power equipment simulation process;

[0138] The data management instructions are sent to the special simulation database for power equipment in the simulation database unit, so that the data interaction module of the special simulation database for power equipment performs data interaction with each simulation resource library according to the data management instructions, so as to complete the invocation, storage, update, and maintenance of the power simulation resource data.

[0139] In one embodiment, updating and maintaining the power simulation resource data includes the following steps:

[0140] The data management unit generates a first instruction or a second instruction; the first instruction is an instruction for adding data and storing the data at a specified physical address using input data, and the second instruction is an instruction for modifying data and overwriting the stored information under the original physical address using input data;

[0141] The first instruction or the second instruction is sent to the special simulation database for power equipment in the simulation database unit, so that the data interaction module of the special simulation database for power equipment performs corresponding operations on the input data according to the first instruction or the second instruction;

[0142] Among them, if the data interaction module receives the first instruction, the following operations are performed:

[0143] Taking the original data in the special simulation database for power equipment as the reference information, and comparing the newly added data in the first instruction with the reference information to judge the overlapping part between the two;

[0144] Store the non-repeated part of the new data at the specified physical address in the special simulation database for power equipment, and store the repeated part at the specified physical address in the special simulation database for power equipment or cancel the storage operation;

[0145] If the data interaction module receives a second instruction, perform the following operations:

[0146] Replace the existing data at the original physical address in the special simulation database for power equipment with the modified data in the second instruction.

[0147] Taking the several simulation resource library designs proposed in the foregoing embodiments as examples, their update and maintenance processes are as follows:

[0148] If the update instruction is a first instruction, use the original data in the database as reference information, and compare the new data in the first instruction with the reference information. For different database types, there are differences in the content of the reference information and the operations after information comparison.

[0149] 1) For the geometric model library, the reference information is equipment type, equipment voltage level, part type, and file format. If and only if the new data has no repetition with the reference information, automatically store the new data in the first instruction in the geometric model library; if there is a coincidence between the basic information of the new data in the first instruction and any of the reference information, mark the new data in the first instruction as coincident information, push the equipment type, equipment voltage level, part type, file format, file size, storage / modification time of the new data and the reference information to the first permission end, and according to the feedback instruction of the first permission end, store the new data in the first instruction with coincident information in the geometric model library or cancel the storage operation;

[0150] 2) For the material parameter library, the reference information is material name and parameter type. If and only if the new data has no repetition with the reference information, automatically store the new data in the first instruction in the material parameter library; if there is a coincidence between the basic information of the new data in the first instruction and any of the reference information, mark the new data in the first instruction as coincident information, push the material name, parameter type, file size, storage / modification time of the new data and the reference information to the first permission end, and according to the feedback instruction of the first permission end, store the new data in the first instruction with coincident information in the material parameter library or cancel the storage operation;

[0151] 3) For the equipment operating condition library, the reference information is equipment type, voltage level, and operating condition type. If and only if the new data in the first instruction has no duplicates with the reference information, the new data in the first instruction will be automatically stored in the equipment operating condition library. If there is a coincidence between the basic information of the new data in the first instruction and any of the reference information, mark the new data in the first instruction as coincident information, and push the equipment type, voltage level, operating condition type, file size, storage / modification time of the new data and the reference information to the first permission end. Then, according to the feedback instruction from the first permission end, store the new data in the first instruction with coincident information in the equipment operating condition library, or cancel the storage operation;

[0152] 4) For the field quantity criterion library, the reference information is equipment type, criterion type, and acquisition source. If and only if the new data in the first instruction has no duplicates with the reference information, the new data in the first instruction will be automatically stored in the field quantity criterion library. If there is a coincidence between the basic information of the new data in the first instruction and any of the reference information, mark the new data in the first instruction as coincident information, and push the equipment type, criterion type, acquisition source, file size, storage / modification time of the new data and the reference information to the first permission end. Then, according to the feedback instruction from the first permission end, store the new data in the first instruction with coincident information in the field quantity criterion library, or cancel the storage operation;

[0153] 5) For the simulation case library, the reference information is equipment type, voltage level, physical field type, software type, and software version. If and only if the new data in the first instruction has no duplicates with the reference information, the new data in the first instruction will be automatically stored in the simulation case library. If there is a coincidence between the basic information of the new data in the first instruction and any of the reference information, mark the new data in the first instruction as coincident information, and push the equipment type, voltage level, physical field type, software type, software version, file size, storage / modification time of the new data and the reference information to the first permission end. Then, according to the feedback instruction from the first permission end, store the new data in the first instruction with coincident information in the simulation case library, or cancel the storage operation;

[0154] If the update instruction is the second instruction, obtain the basic information of the update data from the external network or manual input and the basic information of the existing database, and replace the basic information of the existing data at the physical storage address of the original database with the basic information of the update data according to the second instruction.

[0155] The above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, those of ordinary skill in the art should understand that: they can still modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the various embodiments of the present invention.

Claims

1. A simulation database system dedicated to power equipment, characterized in that: include: Simulation database unit and data management unit; The simulation database unit is provided with a special simulation database for electric power equipment; The power equipment dedicated simulation database includes several different types of simulation resource libraries and data interaction modules; Each of the simulation resource libraries stores corresponding power simulation resource data in a standardized content management manner of the type to which it belongs; The data interaction module is used to realize data interaction between the power equipment dedicated simulation database and the data management unit; The data management unit is used to interact with the simulation database unit through the data interaction module according to static data management requirements or dynamic data management requirements during power equipment simulation, so as to call, store, update and maintain the data of each simulation resource library in accordance with the standardized content management method.

2. The power equipment-specific simulation database system according to claim 1, characterized in that: The simulation resource libraries of different types include at least: Geometric model library, material parameter library, equipment operating condition library, field quantity criterion library and simulation case library; The geometric model library stores model building resources in accordance with the standardized content management method of classification standards, element information and file formats, and is used to provide the required data resources for the power equipment simulation in the model building stage; The material parameter library stores material parameter resources in a standardized content management manner according to classification standards, element information and necessary material parameter types; The equipment operating condition library stores operating condition parameter resources according to the classification standard and the standardized content management method of the necessary operating condition parameters; The field quantity criterion library stores field quantity criterion resources in a standardized content management manner according to classification standards and criterion types; The simulation case library stores case resources in a standardized content management manner according to case elements, file naming rules, and content requirements of case reports.

3. The power equipment dedicated simulation database system according to claim 1, characterized in that: The power equipment dedicated simulation database adopts the SQLite database architecture, and the data interaction module based on the SQLite database architecture includes the following components: Core engine and virtual machine; The core engine is used to convert the data management instructions of the data management unit into SQL instructions; the data management instructions are SQL statements for managing data generated by the data management unit according to the static data management requirements or the dynamic data management requirements in the power equipment simulation process; The virtual machine is used to perform corresponding management operations on the power simulation resource data in the power equipment dedicated simulation database according to the SQL instructions.

4. The power equipment-specific simulation database system according to claim 3 is characterized in that: The core engine includes: SQL parser and query optimizer; The SQL parser is used to parse the SQL statement and convert it into an SQL query; The query optimizer is used to optimize the SQL query to adapt to the standardized content management method of each of the power simulation resource databases.

5. The power equipment-specific simulation database system according to claim 4, characterized in that: The virtual machine includes: Bytecode generator and virtual machine execution engine; The bytecode generator is used to convert the optimized SQL query into a bytecode instruction, wherein the bytecode instruction includes a description of the management operation; The virtual machine execution engine is used to perform corresponding management operations on the power simulation resource data in the power equipment dedicated simulation database according to the bytecode instructions.

6. The power equipment-specific simulation database system according to claim 3, characterized in that: The power equipment-specific simulation database based on the SQLite database architecture further includes: a storage engine; The storage engine is used to store the power simulation resource data of each simulation resource library through a selected data structure.

7. The power equipment-specific simulation database system according to claim 6, characterized in that: The data structure adopts a B-tree data structure.

8. The power equipment-specific simulation database system according to claim 3, characterized in that: The power simulation resource data of the power equipment dedicated simulation database is stored in a database file, and the database file is stored in a page-type storage manner.

9. A management method for a special simulation database system for electric power equipment, characterized in that: The implementation of the dedicated simulation database system for electric power equipment according to any one of claims 1 to 8 comprises the following steps: Generate data management instructions using a data management unit according to static data management requirements or dynamic data management requirements during power equipment simulation; The data management instruction is sent to the power equipment-specific simulation database of the simulation database unit, so that the data interaction module of the power equipment-specific simulation database interacts with each simulation resource library according to the data management instruction to complete the call and storage as well as the update and maintenance of the power simulation resource data.

10. The management method of the power equipment dedicated simulation database system according to claim 9, characterized in that: Updating and maintaining the power simulation resource data includes the following steps: The data management unit is used to generate a first instruction or a second instruction; the first instruction is an instruction for adding new data and completing data storage at a specified physical address using the input data, and the second instruction is a command for modifying data and overwriting information stored at an original physical address using the input data; Sending the first instruction or the second instruction to the power equipment dedicated simulation database of the simulation database unit, so that the data interaction module of the power equipment dedicated simulation database performs corresponding operations on the input data according to the first instruction or the second instruction; If the data interaction module receives the first instruction, the following operations are performed: Using the original data of the power equipment dedicated simulation database as the reference information, and comparing the newly added data in the first instruction with the reference information to determine the repeated parts between the two; Store the non-repeated part of the newly added data to the specified physical address in the power equipment-specific simulation database, store the repeated part to the specified physical address in the power equipment-specific simulation database or cancel the storage operation; If the data interaction module receives the second instruction, the following operations are performed: The modified data in the second instruction is replaced with the existing data at the original physical address in the power equipment-specific simulation database.

Images