Disclosure of Invention
The invention aims to provide a database maintenance method and device for a three-dimensional visual model of an electric power system.
In order to achieve the above object, the present invention provides a method for maintaining a database of a three-dimensional visualization model of an electric power system, wherein the method is executed by a general module, and the method comprises the steps of:
Establishing a topological relation and a logical relation among a plurality of attributes of a three-dimensional visual model of the power system;
receiving an instruction for maintaining one of a plurality of attributes;
Determining one of a plurality of attributes to which the instruction is directed, and determining a number of associated attributes associated with the one of the plurality of attributes based on a topological relationship and a logical relationship between the plurality of attributes;
determining the value ranges of the plurality of associated attributes, and sending the value ranges of the plurality of associated attributes to the output component.
In a preferred embodiment, the method further comprises the steps of:
after determining one of the plurality of attributes to which the instruction is directed, determining a change in the other attribute of the three-dimensional visualization model based on the topological and logical relationships between the plurality of attributes and the change in the one of the plurality of attributes;
If it is determined that an error occurred to a change in one of the plurality of attributes, issuing an error prompt to an output device prior to rendering the three-dimensional visualization model;
receiving an instruction for grouping a plurality of attributes;
After receiving an instruction to group a plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped into a group can be maintained simultaneously.
The invention provides a database maintenance device of a three-dimensional visualization model of an electric power system, which is characterized by comprising a general module, wherein the general module is configured to:
Establishing a topological relation and a logical relation among a plurality of attributes of a three-dimensional visual model of the power system;
receiving an instruction for maintaining one of a plurality of attributes;
Determining one of a plurality of attributes to which the instruction is directed, and determining a number of associated attributes associated with the one of the plurality of attributes based on a topological relationship and a logical relationship between the plurality of attributes;
determining the value ranges of the plurality of associated attributes, and sending the value ranges of the plurality of associated attributes to the output component.
In a preferred embodiment, the universal module is further configured to:
after determining one of the plurality of attributes to which the instruction is directed, determining a change in the other attribute of the three-dimensional visualization model based on the topological and logical relationships between the plurality of attributes and the change in the one of the plurality of attributes;
If it is determined that an error occurred to a change in one of the plurality of attributes, issuing an error prompt to an output device prior to rendering the three-dimensional visualization model;
receiving an instruction for grouping a plurality of attributes;
After receiving an instruction to group a plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped into a group can be maintained simultaneously.
The invention provides a database maintenance method of a three-dimensional visual model of an electric power system, which is characterized in that the method is executed by an expansion module and comprises the following steps:
providing a database access interface, wherein the database access interface is used for limiting the authority of a user to access a database, and the database access interface is also used for receiving operation instructions of adding, deleting, modifying and inquiring the database by the user;
Providing a template for a user to secondarily develop a dynamic library, wherein the template defines a set of functions having specific names, wherein the functions can be re-implemented by the user and allow the user to add custom content, wherein the definition of the functions cannot be modified and deleted;
developing a dynamic library based on a database access interface, a template and instructions of a user, wherein in the dynamic library, various methods and rules for maintaining a three-dimensional visualized database model of the power system are defined by the user, wherein the user can read values of a plurality of fields of a plurality of tables describing the three-dimensional visualized database model through the database access interface in the dynamic library, perform complex calculation and write the obtained calculation result into the database through the database access interface;
and providing a secondary development calling interface, wherein the secondary development calling interface is used for calling the dynamic library.
In a preferred embodiment, the database access interface has atomicity to access the database, wherein a database transaction is automatically created each time the database is operated, if a failure occurs in the middle of writing, a database rollback operation is executed, and the written content of the database is invalid, wherein the database access interface records an operation log and an error log.
In a preferred embodiment, if the dynamic library provided by the user does not meet the condition of successful invocation, the secondary development generic interface does not identify the dynamic library and prompts the user for incorrect content.
The invention provides a database maintenance device of a three-dimensional visual model of an electric power system, which is characterized by comprising an expansion module, wherein the expansion module is configured to:
providing a database access interface, wherein the database access interface is used for limiting the authority of a user to access a database, and the database access interface is also used for receiving operation instructions of adding, deleting, modifying and inquiring the database by the user;
Providing a template for a user to secondarily develop a dynamic library, wherein the template defines a set of functions having specific names, wherein the functions can be re-implemented by the user and allow the user to add custom content, wherein the definition of the functions cannot be modified and deleted;
developing a dynamic library based on a database access interface, a template and instructions of a user, wherein in the dynamic library, various methods and rules for maintaining a three-dimensional visualized database model of the power system are defined by the user, wherein the user can read values of a plurality of fields of a plurality of tables describing the three-dimensional visualized database model through the database access interface in the dynamic library, perform complex calculation and write the obtained calculation result into the database through the database access interface;
and providing a secondary development calling interface, wherein the secondary development calling interface is used for calling the dynamic library.
In a preferred embodiment, the database access interface has atomicity to access the database, wherein a database transaction is automatically created each time the database is operated, if a failure occurs in the middle of writing, a database rollback operation is executed, and the written content of the database is invalid, wherein the database access interface records an operation log and an error log.
In a preferred embodiment, if the dynamic library provided by the user does not meet the condition of successful invocation, the secondary development generic interface does not identify the dynamic library and prompts the user for incorrect content.
Compared with the prior art, the invention has the advantages that the universal module can prompt information to the user in real time without waiting for the setting error of a certain attribute after the whole three-dimensional visual model is rendered. The universal module allows a user to drag the positions of the plurality of attributes in the maintenance interface in a configuration mode, the user can divide the plurality of attributes into a group, put the plurality of attributes together for maintenance, put the attributes with correlation together for maintenance, allow the user to define the grouping of the attributes, and reduce omission and errors of attribute maintenance. The expansion module capable of reading the dynamic library developed by the user for the second time provides a mechanism capable of calling the user-defined dynamic library, the maximum database access flexibility is given to the user, the user can develop the functions required by the user to the greatest extent, and the functions are expanded into the database maintenance software. The maintenance work of the user on the database of the three-dimensional visualization model of the power system is not limited by the maintenance software, and the user can develop any maintenance strategies and realize the strategies in the form of a dynamic library.
Detailed Description
The following detailed description of embodiments of the invention is, therefore, to be taken in conjunction with the accompanying drawings, and it is to be understood that the scope of the invention is not limited to the specific embodiments.
Throughout the specification and claims, unless explicitly stated otherwise, the term "comprise" or variations thereof such as "comprises" or "comprising", etc. will be understood to include the stated element or component without excluding other elements or components.
The invention provides a database maintenance method of a three-dimensional visual model of an electric power system, which is characterized in that the method is executed by a general module and comprises the following steps:
Establishing a topological relation and a logical relation among a plurality of attributes of a three-dimensional visual model of the power system;
receiving an instruction for maintaining one of a plurality of attributes;
Determining one of a plurality of attributes to which the instruction is directed, and determining a number of associated attributes associated with the one of the plurality of attributes based on a topological relationship and a logical relationship between the plurality of attributes;
determining the value ranges of the plurality of associated attributes, and sending the value ranges of the plurality of associated attributes to the output component.
In a preferred embodiment, the method further comprises the steps of:
after determining one of the plurality of attributes to which the instruction is directed, determining a change in the other attribute of the three-dimensional visualization model based on the topological and logical relationships between the plurality of attributes and the change in the one of the plurality of attributes;
If it is determined that an error occurred to a change in one of the plurality of attributes, issuing an error prompt to an output device prior to rendering the three-dimensional visualization model;
receiving an instruction for grouping a plurality of attributes;
After receiving an instruction to group a plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped into a group can be maintained simultaneously.
The invention provides a database maintenance device of a three-dimensional visualization model of an electric power system, which is characterized by comprising a general module, wherein the general module is configured to:
Establishing a topological relation and a logical relation among a plurality of attributes of a three-dimensional visual model of the power system;
receiving an instruction for maintaining one of a plurality of attributes;
Determining one of a plurality of attributes to which the instruction is directed, and determining a number of associated attributes associated with the one of the plurality of attributes based on a topological relationship and a logical relationship between the plurality of attributes;
determining the value ranges of the plurality of associated attributes, and sending the value ranges of the plurality of associated attributes to the output component.
In a preferred embodiment, the universal module is further configured to:
after determining one of the plurality of attributes to which the instruction is directed, determining a change in the other attribute of the three-dimensional visualization model based on the topological and logical relationships between the plurality of attributes and the change in the one of the plurality of attributes;
If it is determined that an error occurred to a change in one of the plurality of attributes, issuing an error prompt to an output device prior to rendering the three-dimensional visualization model;
receiving an instruction for grouping a plurality of attributes;
After receiving an instruction to group a plurality of attributes, the plurality of attributes are grouped, wherein the plurality of attributes grouped into a group can be maintained simultaneously.
The invention provides a database maintenance method of a three-dimensional visual model of an electric power system, which is characterized in that the method is executed by an expansion module and comprises the following steps:
providing a database access interface, wherein the database access interface is used for limiting the authority of a user to access a database, and the database access interface is also used for receiving operation instructions of adding, deleting, modifying and inquiring the database by the user;
Providing a template for a user to secondarily develop a dynamic library, wherein the template defines a set of functions having specific names, wherein the functions can be re-implemented by the user and allow the user to add custom content, wherein the definition of the functions cannot be modified and deleted;
developing a dynamic library based on a database access interface, a template and instructions of a user, wherein in the dynamic library, various methods and rules for maintaining a three-dimensional visualized database model of the power system are defined by the user, wherein the user can read values of a plurality of fields of a plurality of tables describing the three-dimensional visualized database model through the database access interface in the dynamic library, perform complex calculation and write the obtained calculation result into the database through the database access interface;
and providing a secondary development calling interface, wherein the secondary development calling interface is used for calling the dynamic library.
In a preferred embodiment, the database access interface has atomicity to access the database, wherein a database transaction is automatically created each time the database is operated, if a failure occurs in the middle of writing, a database rollback operation is executed, and the written content of the database is invalid, wherein the database access interface records an operation log and an error log.
In a preferred embodiment, if the dynamic library provided by the user does not meet the condition of successful invocation, the secondary development generic interface does not identify the dynamic library and prompts the user for incorrect content.
The invention provides a database maintenance device of a three-dimensional visual model of an electric power system, which is characterized by comprising an expansion module, wherein the expansion module is configured to:
providing a database access interface, wherein the database access interface is used for limiting the authority of a user to access a database, and the database access interface is also used for receiving operation instructions of adding, deleting, modifying and inquiring the database by the user;
Providing a template for a user to secondarily develop a dynamic library, wherein the template defines a set of functions having specific names, wherein the functions can be re-implemented by the user and allow the user to add custom content, wherein the definition of the functions cannot be modified and deleted;
developing a dynamic library based on a database access interface, a template and instructions of a user, wherein in the dynamic library, various methods and rules for maintaining a three-dimensional visualized database model of the power system are defined by the user, wherein the user can read values of a plurality of fields of a plurality of tables describing the three-dimensional visualized database model through the database access interface in the dynamic library, perform complex calculation and write the obtained calculation result into the database through the database access interface;
and providing a secondary development calling interface, wherein the secondary development calling interface is used for calling the dynamic library.
In a preferred embodiment, the database access interface has atomicity to access the database, wherein a database transaction is automatically created each time the database is operated, if a failure occurs in the middle of writing, a database rollback operation is executed, and the written content of the database is invalid, wherein the database access interface records an operation log and an error log.
In a preferred embodiment, if the dynamic library provided by the user does not meet the condition of successful invocation, the secondary development generic interface does not identify the dynamic library and prompts the user for incorrect content.
In one embodiment, as shown in fig. 2, the general module of the present invention functions as follows:
1. The method comprises the steps of abstracting out the topological relation and the logical relation among a plurality of attributes of the three-dimensional visual model of the power system, arranging the topological relation and the logical relation in a maintenance program, limiting a user by other associated attributes when maintaining one attribute, prompting the user in real time about the range of the current attribute, and how the current attribute can influence other attributes of the three-dimensional visual model, if the user inputs unsuitable attributes, prompting information to the user in real time, and knowing that one attribute is set incorrectly after the whole three-dimensional visual model is rendered.
2. The user is allowed to drag the positions of the plurality of attributes in the maintenance interface in the form of configuration, the user can divide the plurality of attributes into a group, the plurality of attributes are put together for maintenance, and the attributes with the correlation relationship are put together for maintenance. Allowing users to define groupings of attributes reduces omission and errors in attribute maintenance.
In a specific embodiment, as shown in fig. 3, the expansion module of the dynamic library of the invention, which can be read for secondary development by a user, has the following functions:
1. A database access interface is provided. This interface may define the rights of the user to access the database and, within the specified rights, allow the user to add, delete, modify and query the database. The interface has atomicity to the access of the database, namely, a database transaction is automatically created every operation, so that the condition that the writing operation fails after half data is written when a user operates a plurality of database tables can be ensured. If the writing fails in the middle, the database rollback operation is executed, and all the written contents of the time fail. Meanwhile, the interface also records an operation log and an error log so as to provide enough information for a user to record the operation content and search the error reason.
2. A template of a dynamic library developed by a user for a second time is provided, the template defining a set of functions of specific names that can be re-implemented by the user and added to the custom content. These particular function definitions may not be modified or deleted, otherwise the dynamic library that would result in the user's secondary development cannot be identified by the expansion module. The template of the dynamic library is the basis for developing the dynamic library which can be identified by the expansion module by the user.
3. And developing a dynamic library for maintaining the database of the three-dimensional visual model by the user according to the template and by using the database access interface. In the dynamic library, an operation interface needs to be designed and developed, and various methods and rules for maintaining the three-dimensional visual database model of the power system are defined by a user, and are not limited by the rules in the universal module. In the dynamic library developed by the user for the second time, values of a plurality of fields of a plurality of tables describing the three-dimensional visual model database can be read, complex calculation is performed, and the obtained calculation result is written into the database through a database access interface. The user may also set various complex verification logic to verify the quasimilitude and correctness of the data.
4. And providing a secondary development calling interface, and calling a dynamic library secondarily developed by a user. The interface can only call the dynamic library developed according to the template, and the expansion module can display the operation interface in the dynamic library after being successfully loaded into the dynamic library developed by the user for the second time, so that the user can perform various user-defined operations according to the prompt of the operation interface. The interface has fault tolerance function, if the dynamic library provided by the user does not meet the condition of successful call and can not be identified by the secondary development universal interface, the user can be prompted for wrong content, and the user is convenient to modify.
It should be understood that, in various embodiments of the present invention, the written order of the processes described above does not mean that the processes are performed sequentially, and the order in which the processes are performed should be determined by their functions and inherent logic, and should not constitute any limitation on the implementation of the embodiments of the present invention.
It is to be understood that the above-described embodiments of the present invention are merely illustrative of or explanation of the principles of the present invention and are in no way limiting of the invention. Accordingly, any modification, equivalent replacement, improvement, etc. made without departing from the spirit and scope of the present invention should be included in the scope of the present invention. Furthermore, the appended claims are intended to cover all such changes and modifications that fall within the scope and boundary of the appended claims, or equivalents of such scope and boundary.