WO2018205376A1

WO2018205376A1 - Association information querying method, terminal, server management system, and computer readable storage medium

Info

Publication number: WO2018205376A1
Application number: PCT/CN2017/090923
Authority: WO
Inventors: 戴开云; 林博
Original assignee: 平安科技（深圳）有限公司
Priority date: 2017-05-10
Filing date: 2017-06-29
Publication date: 2018-11-15
Also published as: CN107665228B; TW201901491A; CN107665228A; TWI650659B

Abstract

Embodiments of the present invention provide an association information querying method, a terminal, a server management system, and a computer readable storage medium. The method comprises: receiving querying objects input in vCenter by a user; screening, according to the querying objects, all object information associated with the querying objects in vCenter; creating data tables according to the querying objects and the object information and inserting related data in the data tables, the class of each object corresponding to a data table; generating a multi-layer relation tree diagram according to the data tables and fields in the data tables; receiving a data table and a field selected by the user in the multi-layer relation tree diagram, and a querying condition input by the user; generating a SQL statement according to the selected data table and field and the input querying condition; and executing the SQL statement and returning a querying execution result. The embodiments save the time for positioning and fault analysis, and improve the operation and maintenance management efficiency.

Description

Associated information query method, terminal, server management system and computer readable storage medium

Technical field

The present invention relates to the field of information technology, and in particular, to a related information query method, a terminal, a server management system, and a computer readable storage medium.

Background technique

When the operation and maintenance personnel of the virtual machine software (VMware) manage the virtual machine (VM), when the server is abnormal, such as when the load is too high or the hardware is maintained or the VM is operated and operated normally, it is necessary to find out where the abnormality is, such as which server is abnormal. . In the prior art, the operation and maintenance personnel usually have to be in the client of the virtual machine integration container (VSphere). Client) or the web client of the virtual machine integration container (VSphere web) Client) spends a lot of time querying relevant information, then locates the problem, in the process to obtain a table of many related information, then analyze and correlate the table, and finally get a useful table. However, in the cloud environment, the number of VMs is large, and the difficulty of the operation and maintenance personnel positioning problem is increased, and the efficiency of operation and maintenance is naturally reduced. This is very unfavorable for normal operation and maintenance management and fault analysis.

Summary of the invention

The embodiment of the invention provides a related information query method, a terminal, a server management system and a computer readable storage medium, which can display the query object in the positioning problem and all associated objects of the query object in a multi-layer relationship tree diagram. Then, according to the information in the multi-layer relationship tree diagram, the query result is obtained, which saves the positioning problem and the time of fault analysis, and improves the efficiency of operation and maintenance management.

In a first aspect, an embodiment of the present invention provides a method for querying related information, where the method includes:

Receive query objects entered by users in vCenter;

Filtering, in the vCenter, all object information associated with the query object according to the query object;

Creating a data table according to the query object and the object information, and inserting related data in the data table, wherein each class to which the object belongs corresponds to one data table;

Generating a multi-layer relationship tree according to the fields in the data table and the data table;

Receiving data tables and fields selected by the user in the multi-layer relationship tree, and query conditions input by the user;

Generate a structured query language SQL statement according to the selected data table and field, and the input query condition;

Execute the SQL statement and return the query execution result.

In a second aspect, an embodiment of the present invention provides a terminal, where the terminal includes:

a receiving unit, configured to receive a query object input by a user in the vCenter;

a filtering unit, configured to filter, in the vCenter, all object information associated with the query object according to the query object;

a table creation unit, configured to create a data table according to the query object and the object information, and insert related data in the data table, wherein each class to which the object belongs corresponds to one data table;

a tree diagram generating unit, configured to generate a multi-layer relationship tree according to the data table and the fields in the data table;

An input unit, configured to receive a data table and a field selected by a user in a multi-layer relationship tree, and a query condition input by the user;

a query statement generating unit, configured to generate an SQL statement according to the selected data table and the field, and the input query condition;

The result is returned to the unit for executing the SQL statement and returning the query execution result.

In a third aspect, an embodiment of the present invention provides a server management system, where the server management system includes a processing device and a storage device.

The storage device is configured to store a program and data information for implementing related information query in the server management system;

The processing device is configured to execute a program stored in the storage device to perform the method described in the first aspect above.

In a fourth aspect, an embodiment of the present invention provides a computer readable storage medium storing one or more programs, the one or more programs being executable by one or more processors To achieve the method described in the first aspect above.

In the embodiment of the present invention, a data table may be created according to all object information associated with the query object and the query object, and related data is inserted in the data table, and a multi-layer relationship tree diagram is generated according to the data table, and then according to the data table selected by the user. And the field, as well as the input query conditions to generate SQL statements, execute SQL statements and return query execution results. In the embodiment of the present invention, the query object in the positioning problem and all the objects associated with the query object are displayed in a multi-layer relationship tree diagram, and then the query result is obtained according to the information in the multi-layer relationship tree view, thereby saving the query result. The problem of positioning problems and failure analysis improves the efficiency of operation and maintenance management.

DRAWINGS

In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings used in the description of the embodiments will be briefly described below. It is obvious that the drawings in the following description are some embodiments of the present invention. For the ordinary technicians, other drawings can be obtained based on these drawings without any creative work.

FIG. 1 is a schematic flowchart of a method for querying related information according to an embodiment of the present invention;

2 is a schematic diagram of a sub-flow of a method for querying related information according to an embodiment of the present invention;

FIG. 3 is a schematic diagram of another sub-flow of a method for querying related information according to an embodiment of the present invention; FIG.

FIG. 4 is a schematic flowchart of a method for querying associated information according to another embodiment of the present invention; FIG.

FIG. 5 is a schematic flowchart of a method for querying related information according to another embodiment of the present invention; FIG.

FIG. 6 is a schematic diagram of a sub-flow of a method for querying related information according to another embodiment of the present invention; FIG.

FIG. 7 is a schematic block diagram of a terminal according to an embodiment of the present disclosure;

FIG. 8 is a schematic block diagram of a table creation unit according to an embodiment of the present invention;

FIG. 9 is a schematic block diagram of a tree diagram generating unit according to an embodiment of the present invention; FIG.

FIG. 10 is a schematic block diagram of a terminal according to another embodiment of the present invention; FIG.

FIG. 11 is a schematic block diagram of a terminal according to another embodiment of the present invention; FIG.

FIG. 12 is a schematic block diagram of a display unit according to an embodiment of the present disclosure;

FIG. 13 is a schematic block diagram of a server management system according to an embodiment of the present invention.

detailed description

The technical solutions in the embodiments of the present invention are clearly and completely described in the following with reference to the accompanying drawings in the embodiments of the present invention. It is obvious that the described embodiments are a part of the embodiments of the present invention, but not all embodiments. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without creative efforts are within the scope of the present invention.

It will be understood that the terms "comprise" and "the" when used in the specification and the appended claims "Comprising" indicates the existence of the described features, integers, steps, operations, elements and/or components, but does not exclude the presence of one or more other features, integers, steps, operations, elements, components and/or combinations thereof Add to.

It should also be understood that the term "and / is used in the description of the invention and the appended claims. Or "" refers to any combination of one or more of the associated listed items and all possible combinations, and includes such combinations.

In a specific implementation, the terminal described in the embodiments of the present invention includes, but is not limited to, a non-portable communication device such as a desktop computer. It should also be understood that in some embodiments, the device is not limited to only non-portable communication devices, but may also include other portable devices such as mobile phones, laptop computers, or tablet computers.

FIG. 1 is a schematic flowchart diagram of a method for querying related information according to an embodiment of the present invention. The method includes S101~S107.

S101. Receive a query object input by a user in the vCenter. Among them, vCenter is the virtualization management server platform VMware vCenter Abbreviation for Server. In vCenter, the components involved mainly include hosts, virtual machines, networks, storage, clusters, and so on. For the user, if the user wants to query the host, the query object input by the user can be a specific host according to the needs of the user. If it is not determined to be a specific host, the host component can also be used as the query object.

S102. Filter all the object information associated with the query object in the vCenter according to the query object. In vCenter, abstract hosts, virtual machines, networks, storage, clusters, etc. into corresponding classes, and abstract the corresponding relationships between these classes, and abstract these classes and the phases between these classes. The corresponding relationship is saved. At the same time, the specific information of the abstracted class is saved, such as saving specific information of multiple hosts, including host name, host memory size, host processor, host operating system type, and the like. After receiving the query object input by the user, all the object information associated with the query object is filtered according to the saved abstracted class and the corresponding relationship between the classes. If the query object input by the user is a host, all object information associated with the query object includes a host name, a storage connected to the host, a virtual machine on the host, a host memory, a host running state, a host network system, and a host. Cluster, host connection status, information triggered by the host, etc.

S103. Create a data table according to the query object and all object information associated with the query object, and insert related data in the data table. Each class to which each object belongs corresponds to a data table. In the specific implementation, you must first create a data table, and then insert data in the data table. Specifically, as shown in FIG. 2, S103 includes S201-S202. S201. Acquire an attribute of a class to which each object belongs and a value of the attribute. Among them, the properties of the class here are understood as member variables of the class. The properties of the class to which each object belongs and the value of the property can be obtained through the Java reflection mechanism. S202, converting each class attribute into a SQL statement and executing the SQL statement to create a data table, converting each class attribute and the value of the attribute into a SQL statement and executing the SQL statement to insert in the data table data. Among them, when you convert the properties of each class into SQL statements, you need to add create Table and other SQL syntax to create a data table; when converting the values of each class's properties and properties into SQL statements, you need to add the SQL syntax for inserting data such as insert. The created table is named according to the preset rules, such as t-class name. For example, the class to which the object whose host name is abc belongs is the host class. The attributes of the host class include the host name, host memory size, host processor, host operating system type, and so on. The table creates the SQL syntax of the data table and executes to create the host data table. The fields of the created host data table include the host name, the host memory size, the host processor, the host operating system type, and the like. Then insert data in the host data table, you can insert one or more rows of data at a time in the host data table. Suppose you insert a row of data. The corresponding attributes and attributes of this row of data are: host name is xyz, host memory size is 4GB, host processor is Intel 4GHz, host operating system type is 32-bit operating system, add insert, etc. Insert the SQL syntax of the data and execute to insert the row data in the host data table.

S104. Generate a multi-layer relationship tree according to the fields in the data table and the data table.

S105. Receive a data table and a field selected by the user in the multi-layer relationship tree, and a query condition input by the user. Because the relationship between the data table to be queried and the associated data table and the corresponding field of each data table are displayed in the multi-level relationship tree, the user can directly select the data table and field to be displayed for convenient viewing. . Among them, the field to be selected can be empty, then it is understood that all the fields of the data table should be displayed, and the input query condition can be empty, which can be understood as all the data of the data table is needed.

S106: Generate an SQL statement according to the selected data table and field, and the input query condition.

S107, executing the SQL statement and returning the query execution result. The query execution result is a record of one strip, such as information of one or more specific hosts, information of one or more specific virtual machines, information of one or more specific networks, and the like.

Specifically, S104 includes S301-S309. S301. Acquire a name of a data table corresponding to the query object input by the user. Specifically, the name of the class corresponding to the query object input by the user is obtained through the java reflection mechanism. Because a class corresponds to a table, the name of the data table can be obtained by the name of the class. S302. Determine whether the name of the data table exists. If the name of the data table exists, S303 is performed; if not, the relevant data that does not exist is returned to remind the user. The name of the data table exists as the name of the data table exists in the vCenter. S303. Acquire all fields of the data table and types of the respective fields. The types to which each field belongs include a basic type, a type of another class, and the like. It should be noted that the data structure of each field should be defined first. For example, the data structure defining a field includes at least: a specific field value, a type to which the field belongs, and the like. S304, the name of the data table is taken as the root node of the tree diagram, and each field is saved as a child node of the root node. S305. For each field, determine whether other data tables are involved in the field according to the type of the field. If the type of the field is a basic type, it is determined that the field does not contain other classes, that is, no other data table is involved; if the type to which the field belongs is a type of another class, it is determined that the field includes There are other classes, that is, there are other data tables involved. If there are other data tables involved in the field, execute S306; if there is no other data table for each field, execute S309. S306. Determine whether there is a name of a corresponding data table. If the name of the corresponding data table exists, S307 is executed. If the name of the corresponding data table does not exist, the relevant data that does not exist is returned to remind the user. The name of the corresponding data table exists as the name of the corresponding data table exists in the vCenter. S307. Determine whether there is a name of the corresponding data table in the saved node. If the name of the corresponding data table is not saved in the saved node, that is, if one or more fields involve the names of other data tables, at least one of the corresponding data table names in the saved node does not exist. Or it can be understood that at least one of the corresponding data table names is not saved as a corresponding node, and S308 is performed; if the saved node has a corresponding data table name, that is, if one or more fields are related to other The name of the data table, and the name of the corresponding data table related to the one or more fields already exists in the saved node, and S309 is performed. If the node corresponding to the name of the corresponding data table is a node corresponding to the field of the other data table, it can be understood that the node corresponding to the field of the other data table is the same as the node corresponding to the name of the corresponding data table. node. S308, save all the fields of the data table as the next layer node of the node corresponding to the current field, and so on, until the fields corresponding to each layer node of the tree diagram do not involve other data tables. S309. Generate a multi-level relationship tree according to all the saved nodes. Through the method shown in Figure 3, a multi-layer relationship tree diagram is obtained, which shows the relationship between the class corresponding to the query object and the class corresponding to all objects associated with the query object, wherein Also shows the properties of each class. That is, the relationship between the data table corresponding to the query object and all the data tables associated with the query object is shown, and the fields contained in each data table are also displayed. The obtained multi-level relation tree diagram shows the relationship between the data table to be queried and the associated data table and the corresponding fields of each data table at a glance, so that the user can perform further query.

In the foregoing method embodiment, the class corresponding to the query object in the positioning problem and the class corresponding to all the objects of the query object are displayed in the multi-level relation tree, and then according to the information in the multi-layer relationship tree. The query obtains the query result, which saves the positioning problem and the time of fault analysis, and improves the efficiency of operation and maintenance management.

FIG. 4 is a schematic flowchart diagram of a method for querying related information according to another embodiment of the present invention. The method includes S401~S408.

S401. Receive a query object input by a user in the vCenter. In vCenter, the components involved mainly include hosts, virtual machines, networks, storage, clusters, and so on. For the user, if the user wants to query the host, the query object input by the user can be a specific host according to the needs of the user. If it is not determined to be a specific host, the host component can also be used as the query object.

S402. Filter all the object information associated with the query object in the vCenter according to the query object. In vCenter, abstract hosts, virtual machines, networks, storage, clusters, etc. into corresponding classes, and abstract the corresponding relationships between these classes, and abstract these classes and the phases between these classes. The corresponding relationship is saved. At the same time, the specific information of the abstracted class is saved, such as saving specific information of multiple hosts, including host name, host memory size, host processor, host operating system type, and the like. After receiving the query object input by the user, all the object information associated with the query object is filtered according to the saved abstracted class and the corresponding relationship between the classes. If the query object input by the user is a host, all object information associated with the query object includes a host name, a storage connected to the host, a virtual machine on the host, a host memory, a host running state, a host network system, and a host. Cluster, host connection status, information triggered by the host, etc.

S403. Establish an in-memory database, where the in-memory database is connected to the vCenter. Preferably, SQLite is used as the in-memory database. SQLite is an embedded database. It includes the following advantages: (1) Zero configuration. SQlite3 does not need to be installed, no configuration, no need to start, shut down or configure the database instance. When the system crashes, you don't need to do any recovery operations, and then automatically restore the next time you use the database. (2) Compact. SQLite is designed to be lightweight. A header file, a lib library, can be used without any system processes being started. (3) Adopt no data type. Because no data type is used, any type of data can be saved. SQLite uses a dynamic data type, which is automatically determined based on the stored value. The in-memory database is connected to vCenter and can be kept in communication with the vCenter as long as the program is not interrupted due to an exception. And use the wait update mechanism (waitforUpdate mechanism) to update the data in the in-memory database, so as long as there is relevant data change in the vCenter, it can be detected immediately. It can be understood that the data in the acquired in-memory database is the real-time data in the vCenter.

S404. Create a data table in the in-memory database according to the query object and all object information associated with the query object, and insert related data in the data table. Each class to which each object belongs corresponds to a data table. In the specific implementation, you must first create a data table, and then insert data in the data table. Specifically, the data table is created and the related data is inserted in the data table as described in FIG. 2, and details are not described herein again.

S405. Generate a multi-layer relationship tree according to the fields in the data table and the data table. Specifically, as shown in FIG. 3, details are not described herein again. Through the method shown in Figure 3, a multi-layer relationship tree diagram is obtained, which shows the relationship between the class corresponding to the query object and the class corresponding to all objects associated with the query object, wherein Also shows the properties of each class. That is, the relationship between the data table corresponding to the query object and all the data tables associated with the query object is shown, and the fields contained in each data table are also displayed. The properties of the class here are understood as member variables of the class. The obtained multi-level relation tree diagram shows the relationship between the data table to be queried and the associated data table and the corresponding fields of each data table at a glance, so that the user can perform further query.

S406. Receive a data table and a field selected by the user in the multi-layer relationship tree, and a query condition input by the user. Because the relationship between the data table to be queried and the associated data table and the corresponding field of each data table are displayed in the multi-level relationship tree, the user can directly select the data table and field to be displayed for convenient viewing. . Among them, the field to be selected can be empty, then it is understood that all the fields of the data table should be displayed, and the input query condition can be empty, which can be understood as all the data of the data table is needed.

S407. Generate an SQL statement according to the selected data table and the field, and the input query condition.

S408. Execute the SQL statement in the in-memory database and return the query execution result. The query execution result is a record of one strip, such as information of one or more specific hosts, information of one or more specific virtual machines, information of one or more specific networks, and the like.

The foregoing method embodiment saves the data table corresponding to the data table corresponding to the query object and all the objects associated with the query object in the in-memory database by establishing an in-memory database, and the real-time data in the vCenter may also be changed in real time. Update to the in-memory database, and then retrieve relevant data from the in-memory database to generate a multi-layer relationship tree, eliminating the need to re-fetch all the required data from vCenter, speeding up the query, and further saving positioning problems and failures. The time of analysis improves the efficiency of operation and maintenance management.

FIG. 5 is a schematic flowchart of a method for querying association information according to another embodiment of the present invention. The method includes S501-S504.

S501: After receiving the alarm information sent by the vCenter, create a storage container. Among them, the created storage container can be one or more. If receiving a warning message that the packet loss rate suddenly rises in the vCenter, after receiving the alarm information, create a shopping cart and create a shopping cart basket. Among them, there can be more than one shopping cart, and one shopping cart can create multiple baskets.

S502. The query execution result of the object involved in the alarm information is saved in a storage container. If the alarm information in the cloud environment suddenly increases, the object involved in the alarm information is the network. For the specific steps of the object to be queried according to the object involved in the alarm information, the specific steps of the query execution result may be referred to the embodiment shown in FIG. 4, and specifically, refer to the embodiment of FIG. The content of this will not be repeated here. The result of the query execution is a record of a specific object, such as information of one or more specific hosts, information of one or more specific virtual machines, information of one or more specific networks, and the like. Save the query execution results of one query in a shopping cart basket. Save multiple query execution results from multiple queries in multiple baskets of a shopping cart, or in multiple shopping cart baskets.

S503. Receive a detection object selected by the user in the query execution result. Preferably, the selected detection object is a plurality. Specifically, multiple objects in the query execution result of one query may be selected, or multiple objects in the query execution result of multiple queries may be selected. It will be appreciated that multiple objects may be selected in multiple baskets of one shopping cart or multiple objects in multiple baskets of multiple shopping carts.

S504. Generate and display a performance graph of the object according to the detection object for searching for a source of the alarm information. Specifically, S504 includes S601-S603. S601. Receive a time period to be detected by the user. The time to be detected can be several hours in a day, or several days, or several weeks. S602. Acquire performance data of the detection object in the time period according to the detection object. Among them, the performance data includes one of CPU performance, memory performance, network performance, and the like. S603. Generate and display a performance graph of the detection object according to the performance data for searching for a source of the alarm information. If there are multiple detection objects, then there will be multiple curves in the performance graph. When multiple curves are put together, it is easy to find the object corresponding to the abnormal curve. The object corresponding to the abnormal curve is further checked for finding the source of the alarm information.

After receiving the alarm information, the foregoing method embodiment selects the detection object in the query execution result, generates and displays a performance graph of the object, preferably multiple graphs of multiple objects, to further facilitate the user to query the source of the alarm information. It speeds up the query, saves the positioning problem and the time of fault analysis, and improves the efficiency of operation and maintenance management.

FIG. 7 is a schematic block diagram of a terminal according to an embodiment of the present invention. The terminal 70 includes a receiving unit 701, a screening unit 702, a table creating unit 703, a tree diagram generating unit 704, a query sentence generating unit 705, and a result returning unit 706.

The receiving unit 701 is configured to receive a query object input by a user in the vCenter. Among them, vCenter is the virtualization management server platform VMware vCenter Abbreviation for Server. In vCenter, the components involved mainly include hosts, virtual machines, networks, storage, clusters, and so on. For the user, if the user wants to query the host, the query object input by the user can be a specific host according to the needs of the user. If it is not determined to be a specific host, the host component can also be used as the query object.

The filtering unit 702 filters out all the object information associated with the query object in the vCenter according to the query object. In vCenter, abstract hosts, virtual machines, networks, storage, clusters, etc. into corresponding classes, and abstract the corresponding relationships between these classes, and abstract these classes and the phases between these classes. The corresponding relationship is saved. At the same time, the specific information of the abstracted class is saved, such as saving specific information of multiple hosts, including host name, host memory size, host processor, host operating system type, and the like. After receiving the query object input by the user, all the object information associated with the query object is filtered according to the saved abstracted class and the corresponding relationship between the classes. If the query object input by the user is a host, all object information associated with the query object includes a host name, a storage connected to the host, a virtual machine on the host, a host memory, a host running state, a host network system, and a host. Cluster, host connection status, information triggered by the host, etc.

The table creation unit 703 is configured to create a data table according to the query object and all object information associated with the query object and insert relevant data in the data table. Each class to which each object belongs corresponds to a data table. In the specific implementation, you must first create a data table, and then insert data in the data table. Specifically, as shown in FIG. 8, the table creation unit includes a first field acquisition unit 801 and a conversion execution unit 802. The first field obtaining unit 801 is configured to acquire an attribute of a class to which each object belongs and a value of the attribute. Among them, the properties of the class here are understood as member variables of the class. The properties of the class to which each object belongs and the value of the property can be obtained through the Java reflection mechanism. The conversion execution unit 802 is configured to convert the attributes of each class into SQL statements and execute the SQL statements to create a data table, convert the attributes of each class and the values of the attributes into SQL statements and execute the SQL statements to Insert data into the data table. Among them, when you convert the properties of each class into SQL statements, you need to add create Table and other SQL syntax to create a data table; when converting the values of each class's properties and properties into SQL statements, you need to add the SQL syntax for inserting data such as insert. The created table is named according to the preset rules, such as t-class name.

The tree diagram generation unit 704 is configured to generate a multi-layer relationship tree diagram of the fields in the data table and the data table.

The receiving unit 701 is further configured to receive a data table and a field selected by the user in the multi-layer relationship tree, and a query condition input by the user. Because the relationship between the data table to be queried and the associated data table and the corresponding field of each data table are displayed in the multi-level relationship tree, the user can directly select the data table and field to be displayed for convenient viewing. . Among them, the field to be selected can be empty, then it is understood that all the fields of the data table should be displayed, and the input query condition can be empty, which can be understood as all the data of the data table is needed.

The query statement generating unit 705 is configured to generate an SQL statement according to the selected data table and field, and the input query condition.

The result return unit 706 is for executing the SQL statement and returning the query execution result. The query execution result is a record of one strip, such as information of one or more specific hosts, information of one or more specific virtual machines, information of one or more specific networks, and the like.

Specifically, the tree diagram generation unit includes a table name acquisition unit 901, a determination unit 902, a second field acquisition unit 903, a node preservation unit 904, and a multi-layer relationship tree diagram generation unit 905. The table name obtaining unit 901 is configured to acquire the name of the data table corresponding to the query object input by the user. Specifically, the name of the class corresponding to the query object input by the user is obtained through the java reflection mechanism. Because a class corresponds to a table, the name of the data table can be obtained by the name of the class. The determining unit 902 is configured to determine whether the name of the data table exists. The name of the data table exists as the name of the data table exists in the vCenter. If the name of the data table does not exist, the relevant data that does not exist is returned to remind the user. The second field obtaining unit 903 is configured to acquire all the fields of the data table and the types to which the respective fields belong if the name of the data table exists. The types to which each field belongs include a basic type, a type of another class, and the like. It should be noted that the data structure of each field should be defined first. For example, the data structure defining a field includes at least: a specific field value, a type to which the field belongs, and the like. The node holding unit 904 is configured to use the name of the data table as the root node of the tree diagram, and store each field as a child node of the root node. The determining unit 902 is further configured to determine, for each field, whether other data tables are involved in the field according to the type to which the field belongs. If the type to which the field belongs is a basic type, it is determined that the field does not contain other classes, that is, no other data table is involved; if the type to which the field belongs is a type of another class, it is determined that the field contains other classes. , that is, there are other data tables involved. The table name obtaining unit 901 is further configured to acquire the name of the corresponding data table if other data tables are involved. If only one field refers to other data tables, obtain the name of the corresponding data table involved in the one field; if there are multiple fields involved in other tables, obtain the names of the corresponding data tables involved in the multiple fields. The determining unit 902 is further configured to determine whether there is a name of the corresponding data table. If the name of the corresponding data table does not exist, the relevant data that does not exist is returned to remind the user. The name of the corresponding data table exists as the name of the corresponding data table exists in the vCenter. The determining unit 902 is further configured to determine, if the name of the corresponding data table exists, whether the name of the corresponding data table exists in the saved node. If the name of the corresponding data table is not saved in the saved node, that is, if one or more fields involve the names of other data tables, at least one of the corresponding data table names in the saved node does not exist. Or it can be understood that at least one corresponding data table name is not saved as a corresponding node; if the saved node has a corresponding data table name, that is, if one or more fields are related to other data tables Name, and the name of the corresponding data table involved in the one or more fields already exists in the saved node. The node saving unit 904 is further configured to: if the saved node does not save the name of the corresponding data table, save all the fields of the data table as the next layer node of the node corresponding to the current field, and so on, until the tree The fields corresponding to each layer of the graph do not involve other data tables. The multi-layer relationship tree diagram generating unit 905 is configured to generate a multi-layer relationship tree diagram according to all the saved nodes if the name of the corresponding data table is saved in the saved node; and if there is no other field for each field A data table that generates a multi-level relationship tree based on all nodes saved. If the node corresponding to the name of the corresponding data table is a node corresponding to the field of the other data table, it can be understood that the node corresponding to the field of the other data table is the same as the node corresponding to the name of the corresponding data table. node. Through the structure shown in Figure 9, a multi-layer relationship tree diagram is obtained, which shows the relationship between the class corresponding to the query object and the class corresponding to all objects associated with the query object, wherein Also shows the properties of each class. That is, the relationship between the data table corresponding to the query object and all the data tables associated with the query object is shown, and the fields contained in each data table are also displayed. Here, the properties of the class are understood as all member variables of the class. The obtained multi-level relation tree diagram shows the relationship between the data table to be queried and the associated data table and the corresponding fields of each data table at a glance, so that the user can perform further query.

In the above embodiment, the class corresponding to the query object in the positioning problem and the class corresponding to all the objects of the query object are displayed in the multi-layer relation tree, and then the query is performed according to the information in the multi-layer relationship tree. The query result is obtained, which saves the positioning problem and the time of fault analysis, and improves the efficiency of operation and maintenance management.

FIG. 10 is a schematic block diagram of a terminal according to another embodiment of the present invention. The terminal 100 includes a receiving unit 101, a screening unit 102, an in-memory database establishing unit 103, a table creating unit 104, a tree diagram generating unit 105, a query sentence generating unit 106, and a result returning unit 107. The receiving unit 101, the filtering unit 102, the tree diagram generating unit 105, and the query statement generating unit 106 refer to the receiving unit 701, the filtering unit 702, the tree diagram generating unit 704, and the query statement generation in the embodiment shown in FIG. Unit 705. The difference between the embodiment shown in FIG. 10 and the embodiment shown in FIG. 7 is that the in-memory database establishing unit 103 is added.

The in-memory database establishing unit 103 is configured to establish an in-memory database, which is connected to the vCenter. Preferably, SQLite is used as the in-memory database. The in-memory database is connected to vCenter and can be kept in communication with the vCenter as long as the program is not interrupted due to an exception. And use the wait update mechanism (waitforUpdate mechanism) to update the data in the in-memory database, so as long as there is relevant data change in the vCenter, it can be detected immediately. It can be understood that the data in the acquired in-memory database is the real-time data in the vCenter.

The table creation unit 104 is further configured to create a data table in the in-memory database according to the query object and all object information associated with the query object, and insert relevant data in the data table. Each class to which each object belongs corresponds to a data table. In the specific implementation, you must first create a data table, and then insert data in the data table. Specifically, the data table is created and the related data is inserted in the data table as shown in FIG. 8 , and details are not described herein again.

The result return unit 107 is also used to execute the SQL statement in the in-memory database and return the query execution result. The query execution result is a record of one strip, such as information of one or more specific hosts, information of one or more specific virtual machines, information of one or more specific networks, and the like.

The foregoing embodiment saves the data table corresponding to the data table corresponding to the query object and all the objects associated with the query object in the in-memory database by establishing an in-memory database, and the real-time update is also performed when the related data in the vCenter changes. Go to the in-memory database, and then retrieve the relevant data from the in-memory database to generate a multi-layer relationship tree, eliminating the need to re-fetch all the required data from vCenter, speeding up the query, and saving positioning problems and failure analysis. Time has improved the efficiency of operation and maintenance management.

FIG. 11 is a schematic block diagram of a terminal according to another embodiment of the present invention. 11 includes a receiving unit 111, a filtering unit 112, an in-memory database establishing unit 113, a table creating unit 114, a tree diagram generating unit 115, a query sentence generating unit 116, a result returning unit 117, a storage container creating unit 118, and a result holding unit 119. And display unit 120. The receiving unit 111, the filtering unit 112, the in-memory database establishing unit 113, the table creating unit 114, the tree diagram generating unit 115, the query sentence generating unit 116, and the result returning unit 117 refer to the contents described in the embodiment of FIG. The difference between the embodiment of FIG. 11 and the embodiment of FIG. 10 is that the storage container creating unit 118, the result holding unit 119, and the display unit 120 are added.

The storage container creating unit 118 is configured to create a storage container after receiving the alarm information sent in the vCenter. Among them, the created storage container can be one or more. If receiving a warning message that the packet loss rate suddenly rises in the vCenter, after receiving the alarm information, create a shopping cart and create a shopping cart basket. Among them, there can be more than one shopping cart, and one shopping cart can create multiple baskets.

If the alarm information in the cloud environment suddenly increases, the object involved in the alarm information is the network. According to the receiving unit 111, the filtering unit 112, the in-memory database establishing unit 113, the table creating unit 114, the tree diagram generating unit 115, the query sentence generating unit 116, and the result returning unit 117, the object related to the alarm information is input, according to the The object involved in the alarm information is queried to obtain the query execution result. Specifically, the receiving unit 111, the filtering unit 112, the in-memory database establishing unit 113, the table creating unit 114, the tree diagram generating unit 115, the query sentence generating unit 116, and the result returning unit 117 can refer to the embodiment described in FIG. Please refer to the content of the embodiment of FIG. 10, and details are not described herein again. The result of the query execution is a record of a specific object, such as information of one or more specific hosts, information of one or more specific virtual machines, information of one or more specific networks, and the like.

The result saving unit 119 is configured to save the query execution result of the object involved in the alarm information in the storage container. Save the query execution results of one query in a shopping cart basket. Save multiple query execution results from multiple queries in multiple baskets of a shopping cart, or in multiple shopping cart baskets.

The receiving unit 111 is further configured to receive a detection object selected by the user in the query execution result. Preferably, the selected detection object is a plurality. Specifically, multiple objects in the query execution result of one query may be selected, or multiple objects in the query execution result of multiple queries may be selected. It will be appreciated that multiple objects may be selected in multiple baskets of one shopping cart or multiple objects in multiple baskets of multiple shopping carts.

The display unit 120 is configured to generate and display a performance graph of the object according to the detection object for searching for the source of the alarm information. Specifically, as shown in FIG. 12, the display unit includes a time period receiving unit 121, a performance data acquiring unit 122, and a generating display unit 123. The time period receiving unit 121 is configured to receive a time period to be detected input by the user. The time to be detected can be several hours in a day, or several days, or several weeks. The performance data obtaining unit 122 is configured to acquire performance data of the detection object during the time period according to the detection object. Among them, the performance data includes one of CPU performance, memory performance, network performance, and the like. The generation display unit 123 is configured to generate and display a performance graph of the detection object according to the performance data for searching for the source of the alarm information. If there are multiple detection objects, then there will be multiple curves in the performance graph. When multiple curves are put together, it is easy to find the object corresponding to the abnormal curve. The object corresponding to the abnormal curve is further checked for finding the source of the alarm information.

After receiving the alarm information, the foregoing method embodiment selects the detection object in the query execution result, generates and displays a performance graph of the detection object, in particular, multiple graphs of the plurality of detection objects, further facilitating the user to query the source of the alarm information. . It speeds up the query, saves the positioning problem and the time of fault analysis, and improves the efficiency of operation and maintenance management.

FIG. 13 is a schematic block diagram of a server management system according to an embodiment of the present invention. The server management system 130 includes an input device 131, an output device 132, a storage device 133, and a processing device 134. The input device 131, the output device 132, the storage device 133, and the processing device 134 are connected to each other. among them:

The input device 131 is configured to provide a user input query object, input a data table and field to be queried, input query conditions, and the like. In a specific implementation, the input device 131 of the embodiment of the present invention may include a keyboard, a mouse, a photoelectric input device, a sound input device, a touch input device, and the like.

The output device 132 is configured to output a multi-layer relationship tree, output a query execution result, a performance graph of the object to be detected, and the like. In a specific implementation, the output device 132 of the embodiment of the present invention may include a display, a display screen, a touch screen, and the like.

The storage device 133 is configured to store a program and data information for implementing the related information query in the server management system. The data information stored by the storage device 133 in the embodiment of the present invention includes a query object input by the user, all object information associated with the query object, a field in the data table and the data table, a multi-layer relationship tree diagram, Alarm information, created storage container, performance data of the object to be detected, and so on. In a specific implementation, the storage device 133 and the processing device 134 of the embodiment of the present invention may be on the same terminal or different terminals.

The processing device 134 is configured to run a program stored in the storage device 133 to perform the following operations:

Receiving a query object input by the user; filtering all object information associated with the query object in the storage device according to the query object; creating a data table according to the query object and the object information, and in the data table Inserting relevant data, wherein each object belongs to a class corresponding to a data table; generating a multi-level relation tree according to the fields in the data table and the data table; receiving a data table selected by the user in the multi-layer relationship tree And the field, and the query condition input by the user; generate a SQL statement according to the selected data table and field, and the input query condition; execute the SQL statement and return the query execution result.

Processing device 134 also performs the following operations:

Obtaining the attributes of the class to which each object belongs and the value of the attribute; converting the attributes of each class into SQL statements and executing the SQL statement to create a data table, converting the attributes of each class and the values of the attributes into The SQL statement executes the SQL statement to insert data into the data table.

Processing device 134 also performs the following operations:

Obtaining a name of a data table corresponding to the query object input by the user; determining whether the name of the data table exists; if the name of the data table exists, saving the name of the data table as a first layer node; acquiring the All fields of the data table; all fields of the data table are saved as nodes of a node corresponding to the name of the data table; obtaining the type to which each field belongs; for each field, according to the field The type determines whether there are other data tables involved in the field; if other data tables are involved, obtain the name of the corresponding data table; determine whether there is a name of the corresponding data table; if the name of the data table exists, determine Whether the name of the data table is saved; if the name of the data table is not saved, the step of obtaining all the fields of the data table is returned; if the name of the data table is saved or not for each field Other data tables generate a multi-level relationship tree based on all saved nodes.

Processing device 134 also performs the following operations:

Establishing an in-memory database, the in-memory database is connected to the storage device; creating a data table in the in-memory database according to the query object and the object information, and inserting related data in the data table.

Processing device 134 also performs the following operations:

After receiving the alarm information sent by the vCenter, the storage container is created; the query execution result of the object involved in the alarm information is saved in the storage container; and the detection object selected by the user in the query execution result is received; Generating and displaying a performance graph of the detected object according to the detection object for searching for a source of the alarm information.

The invention also provides a computer readable storage medium storing one or more programs, the one or more programs being executable by one or more processors to implement the steps of:

Receiving a query object input by a user in the vCenter; filtering all object information associated with the query object in the vCenter according to the query object; creating a data table according to the query object and the object information, and in the data table Inserting related data, wherein each object belongs to a class corresponding to a data table; generating a multi-level relation tree according to the data table; receiving data tables and fields selected by the user in the multi-layer relationship tree, and user input Query conditions; generate SQL statements according to selected data tables and fields, and input query conditions; execute SQL statements and return query execution results.

Preferably, the step further comprises:

Establishing an in-memory database, where the in-memory database is connected to the vCenter; creating a data table in the in-memory database according to the query object and the object information, and inserting related data in the data table.

Preferably, the step further comprises:

A person skilled in the art can clearly understand that, for the convenience and brevity of the description, the specific working process of the terminal and the unit described above can be referred to the corresponding process in the foregoing method embodiment, and details are not described herein again. Those of ordinary skill in the art will appreciate that the elements and algorithm steps of the various examples described in connection with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of both, for clarity of hardware and software. Interchangeability, the composition and steps of the various examples have been generally described in terms of function in the above description. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the solution. A person skilled in the art can use different methods for implementing the described functions for each particular application, but such implementation should not be considered to be beyond the scope of the present invention.

In the several embodiments provided by the present application, it should be understood that the disclosed terminal and method may be implemented in other manners. For example, the terminal embodiments described above are merely illustrative. For example, the division of the unit is only a logical function division. In actual implementation, there may be another division manner, for example, multiple units or components may be combined or Can be integrated into another system, or some features can be ignored or not executed. In addition, the mutual coupling or direct coupling or communication connection shown or discussed may be an indirect coupling or communication connection through some interface, device or unit, or an electrical, mechanical or other form of connection.

The units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, may be located in one place, or may be distributed to multiple network units. Some or all of the units may be selected according to actual needs to achieve the objectives of the embodiments of the present invention.

In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above integrated unit can be implemented in the form of hardware or in the form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a standalone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention contributes in essence or to the prior art, or all or part of the technical solution may be embodied in the form of a software product stored in a storage medium. Including several instructions to make a computer device (may be a personal computer, server, or network device, etc.) Performing all or part of the steps of the method described in various embodiments of the present invention. The foregoing storage medium includes: a USB flash drive, a mobile hard disk, and a read only memory. (ROM, Read-Only Memory), random access memory (RAM, Random Access) A variety of media that can store program code, such as a memory, a disk, or an optical disk.

The above is only the specific embodiment of the present invention, but the scope of the present invention is not limited thereto, and any equivalent person can be easily conceived within the technical scope of the present invention by any person skilled in the art. Modifications or substitutions are intended to be included within the scope of the invention. Therefore, the scope of protection of the present invention should be determined by the scope of the claims.

Claims

A method for querying related information, characterized in that the method comprises:

Received on a virtualization management server platform (VMware vCenter Server, referred to as vCenter), the query object input by the user;

Filtering, in the vCenter, all object information associated with the query object according to the query object;

Creating a data table according to the query object and the object information, and inserting related data in the data table, wherein each class to which the object belongs corresponds to one data table;

Generating a multi-layer relationship tree according to the fields in the data table and the data table;

Receiving data tables and fields selected by the user in the multi-layer relationship tree, and query conditions input by the user;

Generate structured query language based on selected data tables and fields, and input query conditions (Structured Query Language, SQL) statement;

Execute the SQL statement and return the query execution result.
The method of claim 1, wherein creating a data table according to the query object and the object information and inserting related data in the data table comprises:

Obtaining the attributes of the class to which each object belongs and the value of the attribute;

Converting the properties of each class into SQL statements and executing the SQL statements to create a data table, converting the properties of each class and the values of the properties into SQL statements and executing the SQL statements to insert data into the data table .
The method of claim 1 wherein generating a multi-level relationship tree based on the fields in the data table and the data table comprises:

Obtaining the name of the data table corresponding to the query object input by the user;

Determining whether the name of the data table exists;

If the name of the data table exists, all the fields of the data table and the types to which the respective fields belong are obtained;

Using the name of the data table as a root node of the tree diagram, and saving the respective fields as child nodes of the root node;

Determining, according to the type of the field, whether other data tables are involved in the field;

If there is another data table, it is determined whether there is a name of the corresponding data table; if the name of the data table exists, it is determined whether the name of the data table exists in the saved node;

If the name of the data table is not in the saved node, all the fields of the data table are saved as the next layer node of the node corresponding to the current field, and so on, until each layer of the tree diagram The fields corresponding to the nodes do not involve other data tables;

Generate a multi-level relationship tree based on all saved nodes.
The method according to any one of claims 1 to 3, wherein before the step of creating a data table according to the query object and the object information and inserting related data in the data table, the method further comprises:

Establish an in-memory database that is connected to the vCenter;

Creating a data table according to the query object and the object information and inserting related data in the data table, comprising: creating a data table in the in-memory database according to the query object and the object information, and inserting a correlation in the data table data;

Execute the SQL statement and return the query execution result, including: executing the SQL statement in the in-memory database and returning the query execution result.
The method of claim 4, wherein the method further comprises:

After receiving the alarm information sent from the vCenter, create a storage container.

Saving the query execution result of the object involved in the alarm information in the storage container;

Receiving a detection object selected by the user in the query execution result;

Generating and displaying a performance graph of the detected object according to the detection object for searching for a source of the alarm information.
A terminal, wherein the terminal comprises:

a receiving unit, configured to receive a query object input by a user in the vCenter;

a filtering unit, configured to filter, in the vCenter, all object information associated with the query object according to the query object;

a table creation unit, configured to create a data table according to the query object and the object information, and insert related data in the data table, wherein each class to which the object belongs corresponds to one data table;

a tree diagram generating unit, configured to generate a multi-layer relationship tree according to the data table and the fields in the data table;

The receiving unit is further configured to receive a data table and a field selected by the user in the multi-layer relationship tree, and a query condition input by the user;

a query statement generating unit, configured to generate an SQL statement according to the selected data table and the field, and the input query condition;

The result is returned to the unit for executing the SQL statement and returning the query execution result.
The terminal according to claim 6, wherein the table creation unit comprises a first field acquisition unit and a conversion execution unit;

The first field obtaining unit is configured to acquire an attribute of a class to which each object belongs and a value of the attribute;

The conversion execution unit is configured to convert an attribute of each class into an SQL statement and execute the SQL statement to create a data table, convert the attribute of each class and the value of the attribute into a SQL statement and execute the SQL statement To insert data in the data table.
The terminal according to claim 6, wherein the tree diagram generation unit includes a table name acquisition unit, a determination unit, a second field acquisition unit, a node storage unit, and a multi-layer relationship tree diagram generation unit;

The table name obtaining unit is configured to obtain a name of a data table corresponding to the query object input by the user;

The determining unit is configured to determine whether a name of the data table exists;

The second field obtaining unit is configured to acquire, if the name of the data table exists, all fields of the data table and types to which the respective fields belong;

The node holding unit is configured to use the name of the data table as a root node of the tree diagram, and save the respective fields as child nodes of the root node;

The determining unit is further configured to determine, according to the type of the field, whether other data tables are involved in the field; if other data tables are involved, determine whether there is a name of the corresponding data table; and if the data table exists Name, determine whether there is a name of the data table in the saved node;

The node holding unit is further configured to: if the saved node does not have the name of the data table, save all the fields of the data table as a node of a node corresponding to the current field, and so on, until The fields corresponding to each layer node of the tree diagram do not involve other data tables;

The multi-layer relationship tree diagram generating unit is configured to generate a multi-layer relationship tree according to all the saved nodes.
The terminal according to any one of claims 6 to 8, wherein the terminal further comprises an in-memory database establishing unit.

The in-memory database establishing unit is configured to establish an in-memory database, where the in-memory database is connected to the vCenter;

The table creation unit is further configured to create a data table in the in-memory database according to the query object and the object information, and insert relevant data in the data table;

The result return unit is further configured to execute the SQL statement in the in-memory database and return the query execution result.
The terminal according to claim 9, wherein the terminal further comprises a storage container creation unit, a result storage unit, and a display unit;

The storage container creating unit is configured to: after receiving the alarm information sent by the vCenter, create a storage container;

The result saving unit is configured to save a query execution result of the object involved in the alarm information in the storage container;

The receiving unit is further configured to receive a detection object selected by the user in the query execution result;

The display unit is configured to generate and display a performance graph of the detection object according to the detection object for searching for a source of the alarm information.
A server management system, characterized in that the server management system comprises a processing device and a storage device;

The storage device is configured to store a program and data information for implementing related information query in the server management system;

The processing device is configured to run a program stored in the storage device to perform the following steps:

Receiving a query object input by a user;

Filtering, in the storage device, all object information associated with the query object according to the query object;

Creating a data table according to the query object and the object information, and inserting related data in the data table, wherein each class to which the object belongs corresponds to one data table;

Generating a multi-layer relationship tree according to the fields in the data table and the data table;

Receiving data tables and fields selected by the user in the multi-layer relationship tree, and query conditions input by the user;

Generate SQL statements based on selected data tables and fields, and input query conditions;

Execute the SQL statement and return the query execution result.
The server management system according to claim 11, wherein said processing device further performs the following steps:

Obtaining the attributes of the class to which each object belongs and the value of the attribute;

Converting the properties of each class into SQL statements and executing the SQL statements to create a data table, converting the properties of each class and the values of the properties into SQL statements and executing the SQL statements to insert data into the data table .
The server management system according to claim 11, wherein said processing device further performs the following steps:

Obtaining the name of the data table corresponding to the query object input by the user;

Determining whether the name of the data table exists;

If the name of the data table exists, all the fields of the data table and the types to which the respective fields belong are obtained;

Using the name of the data table as a root node of the tree diagram, and saving the respective fields as child nodes of the root node;

Determining, according to the type of the field, whether other data tables are involved in the field;

If there is another data table, it is determined whether there is a name of the corresponding data table; if the name of the data table exists, it is determined whether the name of the data table exists in the saved node;

If the name of the data table is not in the saved node, all the fields of the data table are saved as the next layer node of the node corresponding to the current field, and so on, until each layer of the tree diagram The fields corresponding to the nodes do not involve other data tables;

Generate a multi-level relationship tree based on all saved nodes.
The server management system according to any one of claims 11 to 13, wherein the processing device further performs the following steps:

Establishing an in-memory database, the in-memory database being connected to the storage device;

Creating a data table according to the query object and the object information and inserting related data in the data table, comprising: creating a data table in the in-memory database according to the query object and the object information, and inserting a correlation in the data table data;

Execute the SQL statement and return the query execution result, including: executing the SQL statement in the in-memory database and returning the query execution result.
The server management system according to claim 14, wherein said processing device further performs the following steps:

After receiving the alarm information sent from the vCenter, create a storage container.

Saving the query execution result of the object involved in the alarm information in the storage container;

Receiving a detection object selected by the user in the query execution result;

Generating and displaying a performance graph of the detected object according to the detection object for searching for a source of the alarm information.
A computer readable storage medium, characterized in that the computer readable storage medium stores one or more programs, the one or more programs being executable by one or more processors to implement the following steps:

Receive query objects entered by users in vCenter;

Filtering, in the vCenter, all object information associated with the query object according to the query object;

Creating a data table according to the query object and the object information, and inserting related data in the data table, wherein each class to which the object belongs corresponds to one data table;

Generating a multi-layer relationship tree according to the fields in the data table and the data table;

Receiving data tables and fields selected by the user in the multi-layer relationship tree, and query conditions input by the user;

Generate SQL statements based on selected data tables and fields, and input query conditions;

Execute the SQL statement and return the query execution result.
The computer readable storage medium of claim 16 wherein said step further comprises:

Obtaining the attributes of the class to which each object belongs and the value of the attribute;

Converting the properties of each class into SQL statements and executing the SQL statements to create a data table, converting the properties of each class and the values of the properties into SQL statements and executing the SQL statements to insert data into the data table .
The computer readable storage medium of claim 16 wherein said step further comprises:

Obtaining the name of the data table corresponding to the query object input by the user;

Determining whether the name of the data table exists;

If the name of the data table exists, all the fields of the data table and the types to which the respective fields belong are obtained;

Using the name of the data table as a root node of the tree diagram, and saving the respective fields as child nodes of the root node;

Determining, according to the type of the field, whether other data tables are involved in the field;

If there is another data table, it is determined whether there is a name of the corresponding data table; if the name of the data table exists, it is determined whether the name of the data table exists in the saved node;

If the name of the data table is not in the saved node, all the fields of the data table are saved as the next layer node of the node corresponding to the current field, and so on, until each layer of the tree diagram The fields corresponding to the nodes do not involve other data tables;

Generate a multi-level relationship tree based on all saved nodes.
The computer readable storage medium of any of claims 16-18, wherein the step further comprises:

Establish an in-memory database that is connected to the vCenter;

Creating a data table according to the query object and the object information and inserting related data in the data table, comprising: creating a data table in the in-memory database according to the query object and the object information, and inserting a correlation in the data table data;

Execute the SQL statement and return the query execution result, including: executing the SQL statement in the in-memory database and returning the query execution result.
The computer readable storage medium of claim 19, wherein the step further comprises:

After receiving the alarm information sent from the vCenter, create a storage container.

Saving the query execution result of the object involved in the alarm information in the storage container;

Receiving a detection object selected by the user in the query execution result;

Generating and displaying a performance graph of the detected object according to the detection object for searching for a source of the alarm information.