A database maintenance method and device for a three-dimensional visualization model of an electric power system

Abstract

The present invention discloses a database maintenance method for a three-dimensional visualization model of an electric power system, comprising the following steps: establishing a topological relationship and a logical relationship between multiple attributes of the three-dimensional visualization model of the electric power system; receiving an instruction for maintaining one of the multiple attributes; determining one of the multiple attributes pointed to by the instruction, and based on the topological relationship and the logical relationship between the multiple attributes, determining a number of associated attributes associated with the one of the multiple attributes. A general module can prompt information to the user in real time. The general module allows the user to drag the positions of multiple attributes in the maintenance interface in the form of configuration, allowing the user to define the grouping of attributes, thereby reducing omissions and errors in attribute maintenance. An expansion module that can read a dynamic library developed by a user for secondary development provides a mechanism for calling a user-defined dynamic library, giving the user the greatest flexibility in database access, and the user can develop the functions he needs to the greatest extent and extend these functions to the database maintenance software.

Description

Technical Field

[0001] The invention relates to the field of graphic databases, and in particular to a database maintenance method and device for a three-dimensional visualization model of an electric power system. Background Art

[0002] With the steady improvement of the information level of the power system, the three-dimensional visualization model of the power system has been popularized in many power central control systems, which makes the maintenance interface of the power system more user-friendly and the operation more intuitive, which is an important sign of the development of the power system. At the same time, the three-dimensional model occupies a larger database storage space, its storage mode is more complex, and its maintenance method is also very different from that of ordinary models, which requires higher technical means to improve the database maintenance efficiency of the three-dimensional visualization model.

[0003] At present, the storage method of the 3D visualization model of the power system in the database is relatively complex. It may be necessary to use multiple fields in multiple tables in the database to store the attributes of the 3D model in order to fully describe the morphology of the 3D model. When rendering the 3D visualization model, the rendering program needs to read these attribute values ​​at the same time, and then combine them with computer graphics tools to reproduce them to the user. The architecture of the existing technology is as follows: Figure 1 shown.

[0004] When maintaining the 3D visualization model of the power system, the current maintenance method is similar to maintaining an ordinary plane model, and the maintenance of the 3D visualization model is completed by directly modifying the field values ​​of the database. Modifying attributes one by one is inefficient and prone to errors. If the user makes a modification error, the user can only know the attribute modification error after the model is fully rendered, and cannot quickly and completely obtain the modification result. On the other hand, the attributes of multiple 3D visualization models maintained by the user may have a certain correlation. The traditional modification method cannot establish the association of these attributes well, and cannot correct the user's operation errors in time, resulting in low maintenance efficiency. Traditional database maintenance software does not support function expansion, cannot perform secondary development, cannot customize user-defined maintenance methods, and users cannot customize their own operation interfaces and operation methods. Database maintenance can only be performed through fixed interfaces and methods provided by developers, which limits the flexibility of 3D model maintenance and reduces the efficiency of 3D visualization model database maintenance. In the power system, the database maintenance method of the 3D visualization model is outdated and inefficient, resulting in a long maintenance and reconstruction cycle of the system, and cannot achieve the purpose of supplying power to power users as soon as possible. Summary of the invention

[0005] The object of the present invention is to provide a method and device for maintaining a database of a three-dimensional visualization model of an electric power system.

[0006] To achieve the above object, the present invention provides a database maintenance method for a three-dimensional visualization model of a power system, characterized in that the method is executed by a general module and comprises the following steps:

[0007] Establish the topological and logical relationships between multiple attributes of the three-dimensional visualization model of the power system;

[0008] receiving an instruction for maintaining an attribute among a plurality of attributes;

[0009] Determine an attribute among the multiple attributes pointed to by the instruction, and determine a plurality of associated attributes associated with the one of the multiple attributes based on the topological relationship and the logical relationship between the multiple attributes;

[0010] Determine the value ranges of several associated attributes, and send the value ranges of several associated attributes to the output component.

[0011] In a preferred embodiment, the method further comprises the steps of:

[0012] After determining one of the multiple attributes pointed to by the instruction, based on the topological relationship and logical relationship between the multiple attributes and the change of one of the multiple attributes, determine the change of other attributes of the three-dimensional visualization model;

[0013] If it is determined that an error occurs in the change of one of the multiple attributes, an error prompt is issued to an output device before rendering the three-dimensional visualization model;

[0014] Receives instructions for grouping several attributes;

[0015] After receiving an instruction to group the plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped together can be maintained simultaneously.

[0016] The present invention provides a database maintenance device for a three-dimensional visualization model of an electric power system, wherein the device comprises a general module, and the general module is configured to perform the following operations:

[0017] Establish the topological and logical relationships between multiple attributes of the three-dimensional visualization model of the power system;

[0018] receiving an instruction for maintaining an attribute among a plurality of attributes;

[0019] Determine an attribute among the multiple attributes pointed to by the instruction, and determine a plurality of associated attributes associated with the one of the multiple attributes based on the topological relationship and the logical relationship between the multiple attributes;

[0020] Determine the value ranges of several associated attributes, and send the value ranges of several associated attributes to the output component.

[0021] In a preferred embodiment, the general module is further configured to perform the following operations:

[0022] After determining one of the multiple attributes pointed to by the instruction, based on the topological relationship and logical relationship between the multiple attributes and the change of one of the multiple attributes, determine the change of other attributes of the three-dimensional visualization model;

[0023] If it is determined that an error occurs in the change of one of the multiple attributes, an error prompt is issued to an output device before rendering the three-dimensional visualization model;

[0024] Receives instructions for grouping several attributes;

[0025] After receiving an instruction to group the plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped together can be maintained simultaneously.

[0026] The present invention provides a database maintenance method for a three-dimensional visualization model of an electric power system, characterized in that the method is executed by an expansion module and comprises the following steps:

[0027] Provide a database access interface, where the database access interface is used to limit the user's access rights to the database, and the database access interface is also used to receive user operation instructions for adding, deleting, modifying and querying the database;

[0028] Provide a template for users to secondary develop dynamic libraries, where the template defines a set of functions with specific names, where the functions can be re-implemented by users and allow users to add custom content, where the definition of the function cannot be modified or deleted;

[0029] A dynamic library is developed based on a database access interface, a template and user instructions, wherein in the dynamic library, the user defines various methods and rules for maintaining a three-dimensional visualization database model of a power system; wherein in the dynamic library, the user can read the values ​​of multiple fields of multiple tables describing a three-dimensional visualization model database through the database access interface, and perform complex calculations, and write the calculation results into the database through the database access interface; wherein the user can set verification logic in the dynamic library to verify the accuracy and correctness of the data;

[0030] A secondary development calling interface is provided, wherein the secondary development calling interface is used to call a dynamic library.

[0031] In a preferred embodiment, the database access interface has atomicity in accessing the database, wherein a database transaction is automatically created each time an operation is performed on the database, and if a write fails midway, a database rollback operation is performed, and the content written to the database this time will become invalid; wherein the database access interface records operation logs and error logs.

[0032] In a preferred embodiment, if the dynamic library provided by the user does not meet the conditions for successful calling, the secondary development universal interface does not recognize the dynamic library and prompts the user with error content.

[0033] The present invention provides a database maintenance device for a three-dimensional visualization model of an electric power system, wherein the device includes an expansion module, and the expansion module is configured to perform the following operations:

[0034] Provide a database access interface, where the database access interface is used to limit the user's access rights to the database, and the database access interface is also used to receive user operation instructions for adding, deleting, modifying and querying the database;

[0035] Provide a template for users to secondary develop dynamic libraries, where the template defines a set of functions with specific names, where the functions can be re-implemented by users and allow users to add custom content, where the definition of the function cannot be modified or deleted;

[0036] A dynamic library is developed based on a database access interface, a template and user instructions, wherein in the dynamic library, the user defines various methods and rules for maintaining a three-dimensional visualization database model of a power system; wherein in the dynamic library, the user can read the values ​​of multiple fields of multiple tables describing a three-dimensional visualization model database through the database access interface, and perform complex calculations, and write the calculation results into the database through the database access interface; wherein the user can set verification logic in the dynamic library to verify the accuracy and correctness of the data;

[0037] A secondary development calling interface is provided, wherein the secondary development calling interface is used to call a dynamic library.

[0038] In a preferred embodiment, the database access interface has atomicity in accessing the database, wherein a database transaction is automatically created each time an operation is performed on the database, and if a write fails midway, a database rollback operation is performed, and the content written to the database this time will become invalid; wherein the database access interface records operation logs and error logs.

[0039] In a preferred embodiment, if the dynamic library provided by the user does not meet the conditions for successful calling, the secondary development universal interface does not recognize the dynamic library and prompts the user with error content.

[0040] Compared with the prior art, the present invention has the following advantages: the general module can prompt the user with information in real time, without having to wait until the entire three-dimensional visualization model is rendered before being informed of an error in setting a certain attribute. The general module allows the user to drag the positions of multiple attributes in the maintenance interface in the form of configuration. The user can divide multiple attributes into a group and maintain them together. The attributes with interrelated relationships are maintained together, allowing the user to define the grouping of attributes to reduce omissions and errors in attribute maintenance. The expansion module that can read the dynamic library of user secondary development provides a mechanism for calling user-defined dynamic libraries, giving users the greatest flexibility in database access. Users can develop the functions they need to the greatest extent and extend these functions to the database maintenance software. The user's maintenance work on the database of the three-dimensional visualization model of the power system is no longer subject to any restrictions of the maintenance software itself. Users can develop any maintenance strategy and implement these strategies in the form of a dynamic library. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 It is a schematic diagram of the maintenance method of the three-dimensional visualization model database of the power system in the prior art.

[0042] Figure 2 is a schematic diagram of a universal module maintenance method according to an embodiment of the present invention.

[0043] Figure 3 It is a schematic diagram of an expansion module maintenance method capable of reading a dynamic library secondary developed by a user according to an embodiment of the present invention. DETAILED DESCRIPTION

[0044] The specific implementation modes of the present invention are described in detail below in conjunction with the accompanying drawings, but it should be understood that the protection scope of the present invention is not limited by the specific implementation modes.

[0045] Unless explicitly stated otherwise, throughout the specification and claims, the term “comprise” or variations such as “include” or “comprising”, etc., will be understood to include the stated elements or components but not to exclude other elements or components.

[0046] The present invention provides a database maintenance method for a three-dimensional visualization model of an electric power system, characterized in that the method is executed by a general module and comprises the following steps:

[0047] Establish the topological and logical relationships between multiple attributes of the three-dimensional visualization model of the power system;

[0048] receiving an instruction for maintaining an attribute among a plurality of attributes;

[0049] Determine an attribute among the multiple attributes pointed to by the instruction, and determine a plurality of associated attributes associated with the one of the multiple attributes based on the topological relationship and the logical relationship between the multiple attributes;

[0050] Determine the value ranges of several associated attributes, and send the value ranges of several associated attributes to the output component.

[0051] In a preferred embodiment, the method further comprises the steps of:

[0052] After determining one of the multiple attributes pointed to by the instruction, based on the topological relationship and logical relationship between the multiple attributes and the change of one of the multiple attributes, determine the change of other attributes of the three-dimensional visualization model;

[0053] If it is determined that an error occurs in the change of one of the multiple attributes, an error prompt is issued to an output device before rendering the three-dimensional visualization model;

[0054] Receives instructions for grouping several attributes;

[0055] After receiving an instruction to group the plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped together can be maintained simultaneously.

[0056] The present invention provides a database maintenance device for a three-dimensional visualization model of an electric power system, wherein the device comprises a general module, and the general module is configured to perform the following operations:

[0057] Establish the topological and logical relationships between multiple attributes of the three-dimensional visualization model of the power system;

[0058] receiving an instruction for maintaining an attribute among a plurality of attributes;

[0059] Determine an attribute among the multiple attributes pointed to by the instruction, and determine a plurality of associated attributes associated with the one of the multiple attributes based on the topological relationship and the logical relationship between the multiple attributes;

[0060] Determine the value ranges of several associated attributes, and send the value ranges of several associated attributes to the output component.

[0061] In a preferred embodiment, the general module is further configured to perform the following operations:

[0062] After determining one of the multiple attributes pointed to by the instruction, based on the topological relationship and logical relationship between the multiple attributes and the change of one of the multiple attributes, determine the change of other attributes of the three-dimensional visualization model;

[0063] If it is determined that an error occurs in the change of one of the multiple attributes, an error prompt is issued to an output device before rendering the three-dimensional visualization model;

[0064] Receives instructions for grouping several attributes;

[0065] After receiving an instruction to group the plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped together can be maintained simultaneously.

[0066] The present invention provides a database maintenance method for a three-dimensional visualization model of an electric power system, characterized in that the method is executed by an expansion module and comprises the following steps:

[0067] Provide a database access interface, where the database access interface is used to limit the user's access rights to the database, and the database access interface is also used to receive user operation instructions for adding, deleting, modifying and querying the database;

[0068] Provide a template for users to secondary develop dynamic libraries, where the template defines a set of functions with specific names, where the functions can be re-implemented by users and allow users to add custom content, where the definition of the function cannot be modified or deleted;

[0069] A dynamic library is developed based on a database access interface, a template and user instructions, wherein in the dynamic library, the user defines various methods and rules for maintaining a three-dimensional visualization database model of a power system; wherein in the dynamic library, the user can read the values ​​of multiple fields of multiple tables describing a three-dimensional visualization model database through the database access interface, and perform complex calculations, and write the calculation results into the database through the database access interface; wherein the user can set verification logic in the dynamic library to verify the accuracy and correctness of the data;

[0070] A secondary development calling interface is provided, wherein the secondary development calling interface is used to call a dynamic library.

[0071] In a preferred embodiment, the database access interface has atomicity in accessing the database, wherein a database transaction is automatically created each time an operation is performed on the database, and if a write fails midway, a database rollback operation is performed, and the content written to the database this time will become invalid; wherein the database access interface records operation logs and error logs.

[0072] In a preferred embodiment, if the dynamic library provided by the user does not meet the conditions for successful calling, the secondary development universal interface does not recognize the dynamic library and prompts the user with error content.

[0073] The present invention provides a database maintenance device for a three-dimensional visualization model of an electric power system, wherein the device includes an expansion module, and the expansion module is configured to perform the following operations:

[0074] Provide a database access interface, where the database access interface is used to limit the user's access rights to the database, and the database access interface is also used to receive user operation instructions for adding, deleting, modifying and querying the database;

[0075] Provide a template for users to secondary develop dynamic libraries, where the template defines a set of functions with specific names, where the functions can be re-implemented by users and allow users to add custom content, where the definition of the function cannot be modified or deleted;

[0076] A dynamic library is developed based on a database access interface, a template and user instructions, wherein in the dynamic library, the user defines various methods and rules for maintaining a three-dimensional visualization database model of a power system; wherein in the dynamic library, the user can read the values ​​of multiple fields of multiple tables describing a three-dimensional visualization model database through the database access interface, and perform complex calculations, and write the calculation results into the database through the database access interface; wherein the user can set verification logic in the dynamic library to verify the accuracy and correctness of the data;

[0077] A secondary development calling interface is provided, wherein the secondary development calling interface is used to call a dynamic library.

[0078] In a preferred embodiment, the database access interface has atomicity in accessing the database, wherein a database transaction is automatically created each time an operation is performed on the database, and if a write fails midway, a database rollback operation is performed, and the content written to the database this time will become invalid; wherein the database access interface records operation logs and error logs.

[0079] In a preferred embodiment, if the dynamic library provided by the user does not meet the conditions for successful calling, the secondary development universal interface does not recognize the dynamic library and prompts the user with error content.

[0080] In a specific embodiment, Figure 2 As shown, the functions of the general modules of the present invention are as follows:

[0081] 1. The topological and logical relationships between multiple attributes of the 3D visualization model of the power system are abstracted and built into the maintenance program. When the user maintains a certain attribute, he will be restricted by other related attributes. The user is prompted in real time about the possible value range of the current attribute and how the current attribute will affect other attributes of the model. If the user enters an inappropriate attribute, the user is prompted in real time without having to wait until the entire 3D visualization model is rendered before being informed of an error in the setting of a certain attribute.

[0082] 2. Allow users to drag the positions of multiple attributes in the maintenance interface in the form of configuration. Users can group multiple attributes together for maintenance, and maintain attributes that are interrelated together. Allow users to define the grouping of attributes to reduce omissions and errors in attribute maintenance.

[0083] In a specific embodiment, Figure 3 As shown, the functions of the expansion module of the present invention that can read the dynamic library secondary development by the user are as follows:

[0084] 1. Provide a database access interface. This interface can limit the user's access rights to the database, and allow the user to add, delete, modify and query the database within the specified rights. This interface has atomic access to the database, that is, each operation will automatically create a database transaction, which can ensure that when the user operates multiple database tables, the write operation will not fail after half of the data is written. If the write fails in the middle, the database rollback operation will be executed, and all the written content will be invalid. At the same time, this interface will also record operation logs and error logs to provide sufficient information to help users record the operation content and find the cause of the error.

[0085] 2. Provide a template for a dynamic library that users can develop. This template defines a set of functions with specific names that can be re-implemented by users and have their own custom content added. These specific function definitions cannot be modified or deleted, otherwise the dynamic library developed by users will not be recognized by the extension module. This dynamic library template is the basis for users to develop dynamic libraries that can be recognized by extension modules.

[0086] 3. Based on the above template and using the database access interface, the user develops a dynamic library for maintaining the three-dimensional visualization model database. In this dynamic library, the operation interface needs to be designed and developed, and the user defines various methods and rules for maintaining the three-dimensional visualization database model of the power system, which are not restricted by the rules in the general module. In the dynamic library developed by the user, the values ​​of multiple fields of multiple tables describing the three-dimensional visualization model database can be read, and complex calculations can be performed, and the calculation results can be written into the database through the database access interface. Users can also set various complex verification logics to verify the accuracy and correctness of the data.

[0087] 4. Provide a secondary development calling interface to call the dynamic library developed by the user. This interface can and can only call the dynamic library developed according to the above template. After the expansion module is successfully loaded into the dynamic library developed by the user, it will display the operation interface in the dynamic library. The user can perform various user-defined operations according to the prompts of the operation interface. This interface has a fault-tolerant function. If the dynamic library provided by the user does not meet the conditions for successful calling and cannot be recognized by the secondary development general interface, the user will be prompted with the error content to facilitate the user to modify it.

[0088] It should be understood that, in various embodiments of the present invention, the order in which the above-mentioned processes are written does not mean the order of execution, and the execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present invention.

[0089] It should be understood that the above specific embodiments of the present invention are only used to illustrate or explain the principles of the present invention, and do not constitute a limitation of the present invention. Therefore, any modifications, equivalent substitutions, improvements, etc. made without departing from the spirit and scope of the present invention should be included in the protection scope of the present invention. In addition, the appended claims of the present invention are intended to cover all changes and modifications that fall within the scope and boundaries of the appended claims, or the equivalent forms of such scope and boundaries.

Claims

1. A database maintenance method for a three-dimensional visualization model of a power system, characterized in that: The method is performed by a general module and comprises the following steps: Establish the topological and logical relationships between multiple attributes of the three-dimensional visualization model of the power system; receiving an instruction for maintaining an attribute of the plurality of attributes; Determine an attribute among the multiple attributes pointed to by the instruction, and determine a plurality of associated attributes associated with the one of the multiple attributes based on the topological relationship and the logical relationship between the multiple attributes; Determine the value ranges of the plurality of associated attributes, and send the value ranges of the plurality of associated attributes to an output component; After determining one of the multiple attributes pointed to by the instruction, determining changes of other attributes of the three-dimensional visualization model based on topological relationships and logical relationships between the multiple attributes and changes of one of the multiple attributes; If it is determined that an error occurs in the change of one of the plurality of attributes, an error prompt is issued to an output device before rendering the three-dimensional visualization model; Receives instructions for grouping several attributes; After receiving an instruction to group the plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped together can be maintained simultaneously.

2. A database maintenance device for a three-dimensional visualization model of a power system, characterized in that: in, The apparatus comprises a general module, wherein the general module is configured to perform the following operations: Establish the topological and logical relationships between multiple attributes of the three-dimensional visualization model of the power system; receiving an instruction for maintaining an attribute of the plurality of attributes; Determine an attribute among the multiple attributes pointed to by the instruction, and determine a plurality of associated attributes associated with the one of the multiple attributes based on the topological relationship and the logical relationship between the multiple attributes; Determine the value ranges of the plurality of associated attributes, and send the value ranges of the plurality of associated attributes to an output component; The general module is also configured to perform the following operations: After determining one of the multiple attributes pointed to by the instruction, determining changes of other attributes of the three-dimensional visualization model based on topological relationships and logical relationships between the multiple attributes and changes of one of the multiple attributes; If it is determined that an error occurs in the change of one of the plurality of attributes, an error prompt is issued to an output device before rendering the three-dimensional visualization model; Receives instructions for grouping several attributes; After receiving an instruction to group the plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped together can be maintained simultaneously.

Images