TW201901491A - Related information query method, terminal and device - Google Patents

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

Method, terminal and equipment for querying related information

The present invention relates to the field of information technology, and in particular, to a method, terminal, and device for querying related information.

When operating and maintaining personnel of the virtual machine software (VMware) manages a virtual machine (VM), when the server is abnormal, such as a high load or hardware maintenance, or when operating and maintaining the VM, it is necessary to find out where the exception is, such as which server is out abnormal. Department of Existing Technology Operation and maintenance personnel usually spend a lot of time querying related information on the client side of the virtual machine integration container (VSphere client) or the web client of the virtual machine integration container (VSphere web client), and then to locate the problem, in this process, Get a lot of related information table, then analyze and correlate this table, and finally get a useful table. However, in the cloud environment, the number of VMs is large, and the difficulty of locating the operation and maintenance personnel will increase, and the efficiency of the operation and maintenance will naturally decrease. This is very unfavorable to the usual operation and maintenance management and failure analysis.

The invention provides a method and a terminal for querying related information, which can display the query object and all related objects of the query object in a positioning problem in a multi-layer relation tree diagram, and then obtain the query based on the information in the multi-layer relation tree diagram. The query results save time in locating problems and analyzing failures, and improve the efficiency of operation and maintenance management.

The present invention provides a method for querying related information. The method includes:

Receive query objects entered by users in vCenter;

Filter out all object information associated with the query object in vCenter according to the query object;

Create a data table based on the query object and the object information and insert relevant data in the data table, where the class to which each object belongs corresponds to a data table;

Generate a multi-level relationship tree diagram according to the data table and the fields in the data table;

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

Generate a structured query language SQL statement based on the selected data tables and fields, and the query conditions entered;

Execute SQL statements and return query execution results.

The present invention provides a terminal, which includes:

A receiving unit for receiving a query object input by a user in vCenter;

A filtering unit for filtering all object information associated with the query object in vCenter according to the query object;

A table creation unit, configured to create a data table based on the query object and the object information and insert related data into the data table, wherein the class to which each object belongs corresponds to a data table;

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

An input unit for receiving a data table and a field selected by a user in a multi-layer relationship tree and a query condition input by the user;

Query statement generating unit, which is used to generate SQL statements according to the selected data tables and fields and the input query conditions;

The result return unit is used to execute the SQL statement and return the query execution result.

The present invention also provides a device, which includes a processor and a memory connected to the processor;

The memory is used to store a query object including a user input, the query object and all object information associated with the query object, a data table and fields in the data table, a multi-layer relationship tree diagram, and other callable And running program information;

The processor is used to call the program data stored in the memory and execute the following steps:

Receive query objects entered by users in vCenter;

Filter out all object information associated with the query object in vCenter according to the query object;

Create a data table based on the query object and the object information and insert relevant data in the data table, where the class to which each object belongs corresponds to a data table;

Generate a multi-level relationship tree diagram according to the data table and the fields in the data table;

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

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

Execute SQL statements and return query execution results.

The method, terminal, and device provided by the embodiments of the present invention can create a data table based on the query object and all object information associated with the query object, insert relevant data into the data table, generate a multilayer relationship tree diagram according to the data table, and then The data tables and fields selected by the user and the query conditions entered generate SQL statements, execute the SQL statements and return the query execution results. In the embodiment of the present invention, the query object in the positioning problem and all objects associated with the query object can be displayed in a multi-layer relationship tree diagram, and then the query result can be obtained based on the information in the multi-layer relationship tree diagram, thereby saving the positioning problem. And fault analysis time, which improves the efficiency of operation and maintenance management.

In the following, the technical solutions in the embodiments of the present invention will be clearly and completely described with reference to the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the present invention, but not all of them. Based on the embodiments of the present invention, all other embodiments obtained by a person of ordinary skill in the art without creative efforts shall fall within the protection scope of the present invention.

It should be understood that the terms "including" and "comprising" when used in the scope of this specification and the appended patent applications indicate the presence of described features, wholes, steps, operations, elements and / or components, but do not exclude one or The presence or addition of a number of other features, wholes, steps, operations, elements, components, and / or sets thereof.

It should also be understood that the term "and / or" as used in the description of the invention and the scope of the accompanying application patents refers to and includes any combination of one or more of the associated listed items and all possible combinations.

In specific implementation, the terminals described in the embodiments of the present invention include, but are not limited to, non-mobile communication devices such as desktop computers. It should also be understood that, in some embodiments, the device does not only refer to non-mobile communication devices, but may also include other mobile devices such as mobile phones, notebook computers, or tablet computers.

FIG. 1 is a schematic flowchart of an association information query method according to an embodiment of the present invention. The method includes S101 ~ S107.

S101. Receive a query object input by a user in vCenter. Among them, vCenter is the abbreviation of VMware vCenter Server, a virtualization management server platform. 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 entered by the user can be a specific host according to the user's needs. If it cannot be determined as a specific host, the host component can also be used as the query object.

S102: Filter out all object information associated with the query object in vCenter according to the query object. In vCenter, the corresponding classes are abstracted from the host, virtual machine, network, storage, cluster, etc., and the corresponding relationships between these classes are abstracted. The abstracted classes and the relationships between these classes are abstracted. The corresponding relationship is saved. It also saves the specific information of the abstract class, such as the specific information of multiple hosts, including host name, host memory size, host processor, host operating system type, and so on. After receiving the query object input by the user, all object information associated with the query object is filtered according to the saved abstracted classes and the corresponding relationships between the classes. If the query object entered by the user is a host, all the object information associated with the query object includes the host name, the storage connected to the host, the virtual machine on the host, the host memory, the host operating status, the host network system, and the host location Information about the cluster, host connection status, and host-triggered alarms.

S103. Create a data table according to the query object and all object information associated with the query object, and insert related data into the data table. Each of these objects corresponds to a table. In specific implementation, you must first create a data table, and then insert data into the data table. Specifically, as shown in FIG. 2, S103 includes S201-S202. S201. Obtain an attribute of a class to which each object belongs and a value of the attribute. Among them, the attributes of the class here are understood as the member variables of the class. You can use the Java reflection mechanism to obtain the properties of the class to which each object belongs and the value of the property. S202: Convert the attributes of each class into a SQL statement and execute the SQL statement to create a data table. Convert the attributes of each class and the value of the attribute into a SQL statement and execute the SQL statement to insert data into the data table. Among them, when transforming the attributes of each class into SQL statements, you need to add the SQL syntax for creating tables such as create table; when transforming the attributes and attribute values of each class into SQL statements, you need to add SQL such as insert to insert data grammar. The created tables are named according to preset rules, such as t-class names. For example, if the class to which the object whose host name is abc belongs belongs to the host class, the attributes of the host class include the host name, the size of the host memory, the host processor, and the type of the host operating system. To create a host profile, the fields of the created host profile include host name, host memory size, host processor, host operating system type, and so on. Then insert data into the host data table, you can insert one or more rows of data in the host data table at a time. Suppose a row of data is inserted. The corresponding attributes and attribute values 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, insert, etc. Insert the SQL syntax of the data and execute to insert the row of data in the host data table.

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

S105. Receive the data tables and fields selected by the user in the multi-layer relationship tree and the query conditions entered by the user. Because the relationship between the data table to be queried and the related data table and the fields corresponding to each data table are displayed in the multi-layer relational tree diagram, the user can directly select the data table and field to be displayed for easy viewing. Among them, the field to be selected can be empty, so it is understood that all fields of the data table must be displayed, and the query conditions entered at the same time can be empty, which can be understood as all the data of the data table are required.

S106. Generate a SQL statement according to the selected data table and field, and the input query conditions.

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

Specifically, S104 includes S301-S309. S301. Obtain a name of a data table corresponding to a query object input by a user. Specifically, the name of the class corresponding to the query object input by the user is obtained through the java reflection mechanism, because one class corresponds to one table, and the name of the data table can be obtained by the name of the class. S302: Determine whether a name of the data table exists. If the name of the data table exists, execute S303; if it does not exist, return relevant data that does not exist to remind the user. The existence of the name of the data table is understood as the name of the data table existing in vCenter. S303. Obtain all fields of the material table and the types to which each field belongs. Among them, the types to which each field belongs include basic types, types of other classes, and the like. It should be noted that the data structure of each field must be defined first. For example, defining the data structure of a field includes at least: the specific field value and the type to which the field belongs. S304. The name of the data table is used as the root node of the tree diagram, and each field is stored as a child node of the root node. S305. For each field, it is determined whether other data tables are involved in the field according to the type of the field. Among them, if the type to which the field belongs is a basic type, it is judged that the field does not contain other classes, that is, other data tables are not involved; if the type to which the field belongs is a type of other class, it is judged that the field contains There are other categories, that is, other data sheets are involved. If there are other data tables involved in the field, execute S306; if there are no other data tables involved in each field, execute S309. S306: Determine whether there is a name of the corresponding data table. If the name of the corresponding data table exists, execute S307. If the name of the corresponding data table does not exist, relevant data that does not exist is returned to remind the user. The name of the corresponding data table is understood as the name of the corresponding data table in vCenter. S307: Determine whether there is a corresponding data table name in the saved node. If the name of the corresponding data table is not stored in the saved node, that is, if there are one or more fields related to the names of other data tables, as long as at least one of the corresponding data tables does not exist in the saved node, Or it can be understood that at least one of the corresponding data table names is not saved as the corresponding node, execute S308; if there is a corresponding data table name in the saved node, that is, if one or more fields are related to other If the name of the material table and the name of the corresponding material table related to the one or more fields already exists in the saved node, execute S309. If the node corresponding to the name of the corresponding table is the node corresponding to the field of the other table, it can be understood that the node corresponding to the field of the other table is the same as the node corresponding to the name of the corresponding table. node. S308: Save all the fields of the data table as nodes next to the node corresponding to the current field, and so on, until the fields corresponding to the nodes of each layer of the tree diagram do not involve other data tables. S309. Generate a multi-layer relational tree diagram according to all the saved nodes. Through the method shown in FIG. 3, a multi-layer relationship tree diagram is obtained. The multi-layer relationship tree diagram shows the relationship between the classes corresponding to the query object and the classes corresponding to all objects associated with the query object. The properties of each class are shown. That is, the relationship between the data table corresponding to the query object and all the data tables associated with the query object is displayed, and the fields contained in each data table are also displayed. The obtained multi-layer relational tree diagram clearly shows the relationship between the data table to be queried and the related data table and the fields corresponding to each data table, which is convenient for users to perform further query.

In the above method embodiment, the classes corresponding to the query objects in the positioning problem and the classes corresponding to all the objects associated with the query objects can be displayed in a multi-layer relationship tree, and then obtained by querying based on the information in the multi-layer relationship tree. The query results save time in locating problems and analyzing failures, and improve the efficiency of operation and maintenance management.

FIG. 4 is a schematic flowchart of an association information query method according to another embodiment of the present invention. The method includes S401 ~ S408.

S401. Receive a query object input by a user in 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 entered by the user can be a specific host according to the user's needs. If it cannot be determined as a specific host, the host component can also be used as the query object.

S402: Filter out all object information associated with the query object in vCenter according to the query object. In vCenter, the corresponding classes are abstracted from the host, virtual machine, network, storage, cluster, etc., and the corresponding relationships between these classes are abstracted. The abstracted classes and the relationships between these classes are abstracted. The corresponding relationship is saved.幷 Save the specific information of the abstract class at the same time, such as the specific information of multiple hosts, including host name, host memory size, host processor, host operating system type, etc. After receiving the query object input by the user, all object information associated with the query object is filtered according to the saved abstracted classes and the corresponding relationships between the classes. If the query object entered by the user is a host, all the object information associated with the query object includes the host name, the storage connected to the host, the virtual machine on the host, the host memory, the host operating status, the host network system, and the host's location. Cluster, host connection status, host triggered alarm information, etc.

S403. A memory database is established, and the memory database is connected to the vCenter. Preferably, SQLite is used as the memory database. SQLite is an embedded database. It includes the following advantages: (1) Zero configuration. SQlite3 does not need to be installed, configured, or started, shut down, or configured database instances. When the system crashes, there is no need to do any recovery operation, and the next time you use the database, it will automatically recover. (2) Compact. SQLite is designed to be lightweight. A header file and a lib library can be used without starting any system processes. (3) Use the dataless type. Because the data type is used, any type of data can be saved. The dynamic data type used by SQLite is automatically determined based on the stored value. This memory database is connected to vCenter, and as long as the program is not interrupted due to an abnormality, it can always maintain communication with vCenter. And use the wait for update mechanism (waitforUpdate mechanism) to update the data in the memory database, so as long as there are changes in the relevant data in vCenter can be detected immediately, it can be understood that the obtained data in the memory database is the real-time data in vCenter.

S404. Create a data table in the memory database according to the query object and all object information associated with the query object, and insert related data into the data table. Each of these objects corresponds to a table. In specific implementation, you must first create a data table, and then insert data into the data table. Specifically, creating a data table and inserting related data into the data table are as shown in FIG. 2, which will not be repeated here.

S405. Generate a multi-layer relationship tree diagram according to the data table and the fields in the data table. Specifically, as shown in FIG. 3, details are not described herein again. Through the method shown in FIG. 3, a multi-layer relationship tree diagram is obtained. The multi-layer relationship tree diagram shows the relationship between the classes corresponding to the query object and the classes corresponding to all the objects associated with the query object. The properties of each class are shown. That is, the relationship between the data table corresponding to the query object and all the data tables associated with the query object is displayed, and the fields contained in each data table are also displayed. The properties of a class here are understood as member variables of the class. The obtained multi-layer relational tree diagram clearly shows the relationship between the data table to be queried and the related data table and the fields corresponding to each data table, which is convenient for users to perform further query.

S406. Receive the data tables and fields selected by the user in the multi-layer relationship tree and the query conditions entered by the user. Because the relationship between the data table to be queried and the related data table and the fields corresponding to each data table are displayed in the multi-layer relational tree diagram, the user can directly select the data table and field to be displayed for easy viewing. Among them, the field to be selected can be empty, so it is understood that all fields of the data table must be displayed, and the query conditions entered at the same time can be empty, which can be understood as all the data of the data table are required.

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

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

In the above method embodiment, by establishing a memory database, the data table corresponding to the query object and the data tables corresponding to all objects associated with the query object are stored in the memory database. When the related data in vCenter is changed, It will be updated to the memory database in real time, and then the relevant data is taken from the memory database to generate a multi-layered relational tree diagram. There is no need to re-acquire all the required data from vCenter, which speeds up the query speed and saves positioning Time for problem and failure analysis improves the efficiency of operation and maintenance management.

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

S501. After receiving the alarm information sent from the vCenter, a storage container is created. Among them, one or more storage containers can be created. For example, if you receive a warning message that the packet rate suddenly rises in vCenter, after receiving the warning message, create a shopping cart, and then create a shopping basket. Among them, there can be multiple shopping carts created, and one shopping cart can create multiple baskets.

S502. Save the query execution result of the object related to the alarm information in a storage container. If a warning message that the packet rate suddenly rises in a cloud environment is received, the object of the warning message is the network. The specific steps for inputting the objects involved in the alarm information, and obtaining the query execution results according to the objects involved in the alarm information can be found in the embodiment of FIG. 4. Specifically, please refer to the embodiment of FIG. 4. The content is not repeated here. The query execution result is a record, which is a corresponding specific object, such as information of one or more specific hosts, information of one or more specific virtual machines, and information of one or more specific networks. Store the query execution results of a query in the basket of a shopping cart. Save multiple query execution results of 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, a plurality of detection objects are selected. Specifically, multiple objects in a query execution result of a query may be selected, and multiple objects in a query execution result of multiple queries may also be selected. Understandably, for example, multiple objects can be selected in multiple baskets of a shopping cart, or multiple objects can be selected in multiple baskets of multiple shopping carts.

S504: Generate and display the performance curve of the object according to the detection object for searching for the source of the alarm information. Specifically, S504 includes S601-S603. S601. Receive a time period to be detected input by a user. The time to be detected can be a few hours in a day, a few days, a few weeks, etc. S602: Acquire performance data of the detection object within the time period according to the detection object. Among them, the performance data includes one of CPU performance, memory performance, and network performance. S603: Generate and display the performance curve 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 curve graph. When multiple curves are put together and compared, it is easy to find the object corresponding to the abnormal curve. Further investigate the object corresponding to the abnormal curve to find the source of the alarm information.

After receiving the alarm information, the foregoing method embodiment selects the detection object in the query execution result, and generates and displays the performance curve graph of the object, preferably multiple graphs of multiple objects, further facilitating users to query the source of the alarm information. It speeds up the query, saves time for problem location and 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 filtering unit 702, a table creating unit 703, a tree map 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 abbreviation of VMware vCenter Server, a virtualization management server platform. 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 entered by the user can be a specific host according to the user's needs. If it cannot be determined as 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 vCenter according to the query object. In vCenter, the corresponding classes are abstracted from the host, virtual machine, network, storage, cluster, etc., and the corresponding relationships between these classes are abstracted. The abstracted classes and the relationships between these classes are abstracted. The corresponding relationship is saved. It also saves the specific information of the abstract class, such as the specific information of multiple hosts, including host name, host memory size, host processor, host operating system type, and so on. After receiving the query object input by the user, all object information associated with the query object is filtered according to the saved abstracted classes and the corresponding relationships between the classes. If the query object entered by the user is a host, all the object information associated with the query object includes the host name, the storage connected to the host, the virtual machine on the host, the host memory, the host operating status, the host network system, and the host's location. Cluster, host connection status, host triggered alarm information, etc.

The table creating unit 703 is configured to create a material table according to the query object and all object information associated with the query object, and insert related materials in the material table. Each of these objects corresponds to a table. In specific implementation, you must first create a data table, and then insert data into the data table. Specifically, as shown in FIG. 8, the table creation unit includes a first field acquisition unit 801 and a transformation execution unit 802. The first field obtaining unit 801 obtains an attribute of a class to which each object belongs and a value of the attribute. Among them, the attributes of the class here are understood as the member variables of the class. You can use the Java reflection mechanism to obtain the properties of the class to which each object belongs and the value of the property. The conversion execution unit 802 converts the attributes of each class into a SQL statement and executes the SQL statement to create a data table, converts the attributes of each class and the value of the attribute into a SQL statement and executes the SQL statement to be included in the data table Insert data. Among them, when transforming the attributes of each class into SQL statements, you need to add the SQL syntax for creating tables such as create table; when transforming the attributes and attribute values of each class into SQL statements, you need to add SQL such as insert to insert data grammar. The created tables are named according to preset rules, such as t-class names.

A tree diagram generating unit 704 is configured to generate a multi-layer relational tree diagram of the data table and the fields in the data table.

The receiving unit 701 is further 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 a user. Because the relationship between the data table to be queried and the related data table and the fields corresponding to each data table are displayed in the multi-layer relational tree diagram, the user can directly select the data table and field to be displayed for easy viewing. Among them, the field to be selected can be empty, so it is understood that all fields of the data table must be displayed, and the query conditions entered at the same time can be empty, which can be understood as all the data of the data table are required.

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 conditions.

A result return unit 706 is configured to execute a SQL statement and return a query execution result. The query execution result is records, such as information of one or more specific hosts, information of one or more specific virtual machines, and information of one or more specific networks.

Specifically, the tree diagram generating unit includes a table name obtaining unit 901, a judging unit 902, a second field obtaining unit 903, a node saving unit 904, and a multi-layer relationship tree diagram generating unit 905. The table name obtaining unit 901 is configured to obtain a name of a data table corresponding to a query object input by a user. Specifically, the name of the class corresponding to the query object input by the user is obtained through the java reflection mechanism, because one class corresponds to one table, and the name of the data table can be obtained by the name of the class. The determining unit 902 is configured to determine whether a name of the data table exists. The existence of the name of the data table is understood as the name of the data table existing in vCenter. If the name of the table does not exist, relevant information that does not exist is returned to remind the user. A second field obtaining unit 903 is configured to obtain, if a name of the material table exists, all fields of the material table and a type to which each field belongs. Among them, the types to which each field belongs include basic types, types of other classes, and the like. It should be noted that the data structure of each field must be defined first. For example, defining the data structure of a field includes at least: the specific field value and the type to which the field belongs. The node saving unit 904 is configured to save the name of the data table as the root node of the tree diagram, and save each field as a child node of the root node. The judging unit 902 is further configured to determine, for each field, according to a type to which the field belongs, whether other data tables are involved in the field. 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 tables are involved; if the type to which the field belongs is a type of other class, it is determined that the field contains other classes , Which involves other data sheets. The table name obtaining unit 901 is further configured to obtain a name of a corresponding data table if other data tables are involved. If there is only one field related to other data tables, get the name of the corresponding data table related to that one field; if there are multiple fields related to other tables, get the name of the corresponding data table related to the multiple fields. The determining unit 902 is further configured to determine whether a name of a corresponding data table exists. If the name of the corresponding data table does not exist, relevant data that does not exist is returned to remind the user. The name of the corresponding data table is understood as the name of the corresponding data table in vCenter. The judging unit 902 is further configured to judge whether there is a corresponding data table name in the stored node if the corresponding data table name exists. If the name of the corresponding data table is not stored in the saved node, that is, if there are one or more fields related to the names of other data tables, as long as at least one of the corresponding data tables does not exist in the saved node, Or it can be understood that the name of at least one corresponding data table is not saved as the corresponding node; if there is a corresponding data table name in the saved node, 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 save all the fields of the data table as nodes of the next layer of the node corresponding to the current field if the name of the corresponding data table is not stored in the saved node, and so on, until the tree The field corresponding to each layer node of the graph does not involve other data tables. A multi-layer relational tree diagram generating unit 905 is configured to generate a multi-layer relational tree diagram based on all the nodes saved if there is a corresponding table name in the saved node; and if there is no other data involved for each field Table, generates a multi-layer relational tree diagram based on all nodes saved. If the node corresponding to the name of the corresponding table is the node corresponding to the field of the other table, it can be understood that the node corresponding to the field of the other table is the same as the node corresponding to the name of the corresponding table. node. Through the structure shown in FIG. 9, a multi-layer relational tree diagram is obtained. The multi-layer relational tree diagram shows the relationship between the classes corresponding to the query object and the classes corresponding to all the objects associated with the query object. The properties of each class are shown. That is, the relationship between the data table corresponding to the query object and all the data tables associated with the query object is displayed, and the fields contained in each data table are also displayed. Here, the attributes of a class are understood as all member variables of the class. The obtained multi-layer relational tree diagram clearly shows the relationship between the data table to be queried and the related data table and the fields corresponding to each data table, which is convenient for users to perform further query.

In the above embodiment, the classes corresponding to the query objects in the positioning problem and the classes corresponding to all the objects associated with the query objects can be displayed in a multi-layer relationship tree, and then a query can be obtained based on the information in the multi-layer relationship tree. As a result, time for locating problems and failure analysis is saved, and the efficiency of operation and maintenance management is improved.

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, a memory database establishment unit 103, a table creation unit 104, a tree map generation unit 105, a query sentence generation unit 106, and a result return unit 107. Among them, the receiving unit 101, the filtering unit 102, the dendrogram generating unit 105, and the query sentence generating unit 106 refer to the receiving unit 701, the filtering unit 702, the dendrogram generating unit 704, and the query sentence generating 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 a memory database establishment unit 103 is added.

The memory database establishing unit 103 is configured to establish a memory database, and the memory database is connected to the vCenter. Preferably, SQLite is used as the memory database. This memory database is connected to vCenter, and as long as the program is not interrupted due to an abnormality, it can always maintain communication with vCenter. And use the wait for update mechanism (waitforUpdate mechanism) to update the data in the memory database, so as long as there are changes in the relevant data in vCenter can be detected immediately, it can be understood that the obtained data in the memory database is the real-time data in vCenter.

The table creation unit 104 is configured to create a material table in the memory database and insert related materials into the material table according to the query object and all object information associated with the query object. Each of these objects corresponds to a table. In specific implementation, you must first create a data table, and then insert data into the data table. Specifically, creating a data table and inserting related data into the data table are as shown in FIG. 8, which will not be repeated here.

A result return unit 107 is configured to execute a SQL statement in a memory database and return a query execution result. The query execution result is records, such as information of one or more specific hosts, information of one or more specific virtual machines, and information of one or more specific networks.

In the above embodiment, by establishing a memory database, the data tables corresponding to the query object and the data tables corresponding to all objects associated with the query object are stored in the memory database. When the related data in vCenter is changed, it will also Real-time update to the memory database, and then take the relevant data from the memory database to generate a multi-layer relational tree diagram, eliminating the need to re-acquire all the required data from vCenter, speeding up the query speed, and further saving the positioning problem And fault analysis time, which improves 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. FIG. 11 includes a receiving unit 111, a filtering unit 112, a memory database establishment unit 113, a table creation unit 114, a tree map generation unit 115, a query statement generation unit 116, a result return unit 117, a storage container creation unit 118, and a result storage unit. 119. Display unit 120. Among them, the receiving unit 111, the filtering unit 112, the memory database establishing unit 113, the table creating unit 114, the tree map generating unit 115, the query sentence generating unit 116, and the result returning unit 117 refer to the content described in the embodiment of FIG. The embodiment in FIG. 11 is different from the embodiment in FIG. 10 in that a storage container creation unit 118, a result storage unit 119, and a display unit 120 are added.

The storage container creation unit 118 is configured to create a storage container after receiving the alarm information sent from the vCenter. Among them, one or more storage containers can be created. For example, if you receive a warning message that the packet rate suddenly rises in vCenter, after receiving the warning message, create a shopping cart, and then create a shopping basket. Among them, there can be multiple shopping carts created, and one shopping cart can create multiple baskets.

If a warning message that the packet rate suddenly rises in a cloud environment is received, the object of the warning message is the network. According to the receiving unit 111, the filtering unit 112, the memory database establishing unit 113, the table creating unit 114, the tree map generating unit 115, the query sentence generating unit 116, and the result returning unit 117, to input the objects involved in the alarm information, according to Query the object involved in the alarm information to get the query execution result. Specifically, the receiving unit 111, the filtering unit 112, the memory database establishing unit 113, the table creating unit 114, the tree map generating unit 115, the query generating unit 116, and the result returning unit 117 can refer to the embodiment shown in FIG. For details, please refer to the content involved in the embodiment of FIG. 10, and details are not described herein again. The query execution result is a record, which is a corresponding specific object, such as information of one or more specific hosts, information of one or more specific virtual machines, and information of one or more specific networks.

The result saving unit 119 is configured to save a query execution result of the object involved in the alarm information in a storage container. Store the query execution results of a query in the basket of a shopping cart. Save multiple query execution results of 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 from the query execution result. Preferably, a plurality of detection objects are selected. Specifically, multiple objects in a query execution result of a query may be selected, and multiple objects in a query execution result of multiple queries may also be selected. Understandably, for example, multiple objects can be selected in multiple baskets of a shopping cart, or multiple objects can be selected in multiple baskets of multiple shopping carts.

The display unit 120 is configured to generate and display a performance curve 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 acquisition unit 122, and a generation display unit 123. The time period receiving unit 121 is configured to receive a time period to be detected input by a user. The time to be detected can be a few hours in a day, a few days, a few weeks, etc. The performance data obtaining unit 122 is configured to obtain performance data of the detection object within the time period according to the detection object. Among them, the performance data includes one of CPU performance, memory performance, and network performance. The generating and displaying unit 123 is configured to generate and display the performance curve 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 curve graph. When multiple curves are put together and compared, it is easy to find the object corresponding to the abnormal curve. Further investigate the object corresponding to the abnormal curve to find the source of the alarm information.

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

FIG. 13 is a schematic block diagram of a device according to an embodiment of the present invention. The device 130 includes an input device 131, an output device 132, a memory 133, and a processor 134. The input device 131, the output device 132, the memory 133, and the processor 134 are connected through a bus 135. among them:

The input device 131 is used for providing a user to input a query object, a data table and a field to be queried, and a query condition. In specific implementation, the input device 131 in 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 multilayer relational tree diagram, output a query execution result, and a performance curve graph of an object to be detected. In specific implementation, the output device 132 according to the embodiment of the present invention may include a display, a display screen, a touch screen, and the like.

The memory 133 is used for storing program data with various functions. The data stored in the memory 133 in the embodiment of the present invention includes a query object input by a user, a user query object and all object information associated with the query object, a data table and fields in the data table, a multi-layer relationship tree diagram, and an alarm. Information, the storage container created, performance data of the object to be detected, etc., and other program data that can be called and run. In specific implementation, the memory 133 in the embodiment of the present invention may be a system memory, for example, volatile (such as RAM), non-volatile (such as ROM, flash memory, etc.), or a combination of the two. In specific implementation, the memory 133 in the embodiment of the present invention may also be external memory outside the system, such as a magnetic disk, an optical disk, a magnetic tape, and the like.

The processor 134 is configured to call the program data stored in the memory 133 and perform the following operations:

Receiving a query object input by a user in vCenter; filtering out all object information associated with the query object in vCenter according to the query object; creating a data table based on the query object and the object information and inserting relevant data in the data table, Each class corresponds to a data table; generates a multi-level relationship tree diagram according to the data table and the fields in the data table; receives the data tables and fields selected by the user in the multi-level relationship tree, and the query entered by the user Conditions; Generate SQL statements based on selected data tables and fields, and entered query conditions; execute SQL statements and return query execution results.

The processor 134 further performs the following operations:

Get the attribute of the class to which each object belongs and the value of the attribute; convert the attribute of each class into a 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 into the table.

The processor 134 further performs the following operations:

Get the name of the data table corresponding to the query object entered by the user; determine whether the name of the data table exists; if the name of the data table exists, save the name of the data table as a first-level node; get all of the data table Field; save all the fields of this table as the node below the node corresponding to the name of this table; get the type of each field; for each field, determine whether the field is involved according to the type of the field Other data tables; if there are other data tables, get the name of the corresponding data table; determine whether the name of the corresponding data table exists; if the name of the data table exists, determine whether the name of the data table is saved; if Without saving the name of the material table, return to the step of obtaining all the fields of the material table; if the name of the material table is saved or there is no other material table for each field, a multi-layer relationship tree is generated according to all the nodes saved Illustration.

The processor 134 further performs the following operations:

A memory database is established, and the memory database is connected to vCenter; a data table is created in the memory database according to the query object and the object information, and relevant data is inserted in the data table.

The processor 134 further performs the following operations:

After receiving the alarm information sent from vCenter, create a storage container; save the query execution results of the objects involved in the alarm information in the storage container; receive the detection objects selected by the user in the query execution results; according to the detection The object generates and displays the performance curve graph of the detection object for finding the source of the alarm information.

The present invention also provides a computer-readable storage medium. The computer-readable storage medium stores one or more programs, and the one or more programs can be executed by one or more processors to implement the following steps:

Receiving a query object input by a user in vCenter; filtering out all object information associated with the query object in vCenter according to the query object; creating a data table based on the query object and the object information and inserting relevant data in the data table, Each class corresponds to a data table; a multi-layer relational tree diagram is generated according to the data table; receiving the data tables and fields selected by the user in the multi-level relation tree tree and the query conditions entered by the user; Tables and fields, and input query conditions generate SQL statements; execute SQL statements and return query execution results.

Preferably, this step further includes:

Get the attribute of the class to which each object belongs and the value of the attribute; convert the attribute of each class into a SQL statement; 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 into the table.

Preferably, this step further includes:

Get the name of the data table corresponding to the query object entered by the user; determine whether the name of the data table exists; if the name of the data table exists, save the name of the data table as a first-level node; get all of the data table Field; save all the fields of this table as the node below the node corresponding to the name of this table; get the type of each field; for each field, determine whether the field is involved according to the type of the field Other data tables; if there are other data tables, get the name of the corresponding data table; determine whether the name of the corresponding data table exists; if the name of the data table exists, determine whether the name of the data table is saved; if Without saving the name of the material table, return to the step of obtaining all the fields of the material table; if the name of the material table is saved or there is no other material table for each field, a multi-layer relationship tree is generated according to all the nodes saved Illustration.

Preferably, this step further includes:

A memory database is established, and the memory database is connected to vCenter; a data table is created in the memory database according to the query object and the object information, and relevant data is inserted in the data table.

Preferably, this step further includes:

After receiving the alarm information sent from vCenter, create a storage container; save the query execution results of the objects involved in the alarm information in the storage container; receive the detection objects selected by the user in the query execution results; according to the detection The object generates and displays the performance curve graph of the detection object for finding the source of the alarm information.

Those skilled in the art can clearly understand that, for the convenience and brevity of the description, the specific working processes of the terminals and units described above can refer to the corresponding processes in the foregoing method embodiments, and are not repeated here. Those of ordinary skill in the art may realize that the units and algorithm steps of each example described in combination with the embodiments disclosed herein can be implemented by electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the hardware and The interchangeability of software. In the above description, the composition and steps of each example have been described generally in terms of functions. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. A person skilled in the art can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of the present invention.

In the several embodiments provided in this application, it should be understood that the disclosed terminals and methods may be implemented in other ways. For example, the device embodiments described above are merely schematic. 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 may be combined. Integration into another system, or some features can be ignored or not implemented. In addition, the displayed or discussed mutual coupling or direct coupling or communication connection may be indirect coupling or communication connection through some interfaces, devices, or units, or may be electrical, mechanical, or other forms 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, may be located in one place, or may be distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the objectives of the solutions 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 separately physically, or two or more units may be integrated into one unit. The above integrated unit may be implemented in the form of hardware or in the form of software functional unit.

If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention is essentially a part that contributes to the existing technology, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium. , Including a plurality of instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method in each embodiment of the present invention. The aforementioned storage medium includes: various kinds of programs that can be stored, such as a USD flash drive, a removable hard disk, a read-only memory (ROM, Read-Only Memory), a random access memory (RAM, Random Access Memory), a magnetic disk, or an optical disk. The medium of the code.

The above is only a specific embodiment of the present invention, but the scope of protection of the present invention is not limited to this. Any person skilled in the art can easily think of various equivalent modifications or within the technical scope disclosed by the present invention. Instead, these modifications or replacements should be covered within the protection scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

100‧‧‧Terminal

101‧‧‧Receiving unit

102‧‧‧ Screening Unit

103‧‧‧Memory database creation unit

104‧‧‧Table creation unit

105‧‧‧Tree Map Generation Unit

106‧‧‧Query unit

107‧‧‧Result return unit

111‧‧‧Receiving unit

112‧‧‧Screening Unit

113‧‧‧Memory database creation unit

114‧‧‧Table creation unit

115‧‧‧Tree Map Generation Unit

116‧‧‧Query unit

117‧‧‧Result return unit

118‧‧‧Storage Container Creation Unit

119‧‧‧Result storage unit

120‧‧‧display unit

121‧‧‧Time period receiving unit

122‧‧‧Performance data acquisition unit

123‧‧‧ Generate display unit

130‧‧‧ Equipment

131‧‧‧ input device

132‧‧‧Output device

133‧‧‧Memory

134‧‧‧Processor

135‧‧‧Bus

70‧‧‧ terminal

701‧‧‧Receiving unit

702‧‧‧Screening Unit

703‧‧‧Table creation unit

704‧‧‧Tree Map Generation Unit

705‧‧‧Query unit generation unit

706‧‧‧Result return unit

801‧‧‧First field acquisition unit

802‧‧‧ Transformation Execution Unit

901‧‧‧ table name acquisition unit

902‧‧‧judgment unit

903‧‧‧Second field acquisition unit

904‧‧‧node preservation unit

905‧‧‧multi-layer relation tree diagram generating unit

S101‧‧‧ receives the query object input by the user in vCenter

S102‧‧‧ Filter out all object information associated with the query object in vCenter according to the query object

S103‧‧‧ creates a data table based on the query object and all object information associated with the query object and inserts related data in the data table

S104‧‧‧ Generate multi-layer relationship tree diagram based on the data table and the fields in the data table

S105‧‧‧ Receives the data tables and fields selected by the user in the multi-layer relationship tree and the query conditions entered by the user

S106‧‧‧ Generate SQL statements according to the selected data table and field and the input query conditions

S107‧‧‧Execute SQL statement and return query execution result

S301‧‧‧Get the name of the data table corresponding to the query object entered by the user

S302‧‧‧Judging whether the name of the data table exists

S303‧‧‧Get all fields of the data sheet and the type of each field

S304‧‧‧ Use the name of the data table as the root node of the treemap, and save each field as a child node of the root node

S305‧‧‧ For each field, determine whether there are other data tables in the field according to the type of field

S306‧‧‧ Judging whether the name of the corresponding data table exists

S307‧‧‧ judge whether the corresponding data table name exists in the saved 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 field corresponding to each layer node of the tree diagram does not involve other data tables

S309‧‧‧ Generates a multi-layer relational tree diagram based on all saved nodes

S401‧‧‧ receives query objects input by the user in vCenter

S402 ‧‧‧ Filter out all object information associated with the query object in vCenter according to the query object

S403‧‧‧ Establish a memory database, which is connected to vCenter

S404‧‧‧ creates a data table in the memory database according to the query object and all object information associated with the query object and inserts related data in the data table

S405‧‧‧ Generate multi-layer relationship tree diagram based on the data table and the fields in the data table

S406‧‧‧ Receives the data tables and fields selected by the user in the multi-layer relationship tree and the query conditions entered by the user

S407‧‧‧ generates SQL statements according to the selected data table and field and the input query conditions

S408‧‧‧ executes the SQL statement in the memory database and returns the query execution result. The query execution result is a record, such as one or more specific host information, one or more specific virtual machine information, etc., one or more specific network information, etc.

S501‧‧‧ creates a storage container after receiving the alarm information sent from the vCenter. Among them, one or more storage containers can be created

S502‧‧‧ saves the query execution result of the object involved in the alarm information in a storage container

S503‧‧‧ receives the detection object selected by the user in the query execution result

S504‧‧‧ Generates and displays the performance curve of the object according to the detection object for finding the source of the alarm information

[FIG. 1] It is a schematic flowchart of an association information query method according to an embodiment of the present invention. [FIG. 2] It is a schematic diagram of a sub-flow of a method for querying association information according to an embodiment of the present invention. 3 is a schematic diagram of another sub-flow of a method for querying related information according to an embodiment of the present invention. 4 is a schematic flowchart of an association information query method according to another embodiment of the present invention. 5 is a schematic flowchart of an association information query method according to another embodiment of the present invention. [Fig. 6] Fig. 6 is a schematic diagram of a sub-flow of a method for querying association information according to another embodiment of the present invention. 7 is a schematic block diagram of a terminal according to an embodiment of the present invention. 8 is a schematic block diagram of a table creation unit provided by an embodiment of the present invention. [FIG. 9] A schematic block diagram of a tree map generating unit according to an embodiment of the present invention. [FIG. 10] A schematic block diagram of a terminal according to another embodiment of the present invention. [FIG. 11] A schematic block diagram of a terminal according to another embodiment of the present invention. 12 is a schematic block diagram of a display unit according to an embodiment of the present invention. 13 is a schematic block diagram of a device according to an embodiment of the present invention.

Claims (10)

A related information query method, wherein the method includes: receiving a query object input by a user in a virtualized management server platform (VMware vCenter Server, vCenter for short); 筛选 filtering in vCenter based on the query object that is associated with the query object All the object information; 创建 create a data table based on the query object and the object information and insert relevant data in the data table, where each object belongs to a data table; 生成 generate a multi-level relationship based on the data table and the fields in the data table Treemap; Receive the data tables and fields selected by the user in the multi-layer relational treemap and the query conditions entered by the user; 生成 Generate a Structured Query Language (Structured Query Language, based on the selected data tables and fields and the entered query conditions) SQL) statement; Execute SQL statement and return query execution results. For example, the method according to item 1 of the scope of patent application, in which a data table is created according to the query object and the object information and relevant data is inserted in the data table, including: obtaining the attribute of each class to which the object belongs and the value of the attribute; Attributes of each class are converted into SQL statements and the SQL statements are executed to create a data table. Attributes of each class and values of the attributes are converted into SQL statements and the SQL statements are executed to insert data into the data table. For example, the method according to item 1 of the scope of patent application, wherein the multi-layer relationship tree diagram is generated according to the data table and the fields in the data table, including: obtaining the name of the data table corresponding to the query object entered by the user; determining whether the data table exists The name of the data table; If the name of the data table exists, get all the fields of the data table and the type of each field; Use the name of the data table as the root node of the treemap, and use each field as the root The child nodes of the node are saved; 判断 judge whether there are other data tables in the field according to the type of the field; if there are other data tables, determine whether the name of the corresponding data table exists; if the name of the data table exists, determine Whether the saved table has the name of the table; If the saved node does not have the name of the table, all fields of the table are saved as the next-level node of the node corresponding to the current field, and so on, Until the field corresponding to each layer node of the treemap does not involve other resources Table; multi-layer tree is generated according to the relationship between all the nodes stored. The method according to any one of claims 1 to 3, wherein before the step of creating a data table based on the query object and the object information and inserting related data in the data table, the method further includes: establishing a memory Database, the memory database is connected to vCenter; 创建 create a data table based on the query object and the object information and insert relevant data in the data table, including: creating data in the memory database according to the query object and the object information Table and insert relevant information in the data table; execute SQL statements 幷 return query execution results, including: execute SQL statements in the memory database and return query execution results. For example, the method of claim 4 in the scope of patent application, wherein the method further includes: 创建 creating a storage container after receiving the alarm information sent from the vCenter; 保存 saving the query execution result of the object involved in the alarm information in the storage container Medium; receiving the detection object selected by the user in the query execution result; 生成 generating and displaying a performance curve of the detection object according to the detection object for finding the source of the alarm information. A terminal, wherein the terminal includes: a receiving unit for receiving a query object input by a user in vCenter; a filtering unit for filtering all the object information associated with the query object in vCenter according to the query object; A table creation unit is used to create a data table based on the query object and the object information and insert related data into the data table, wherein each object belongs to a class corresponding to a data table; Generate a multi-level relational tree diagram with fields in the data table; The receiving unit is also used to receive the data tables and fields selected by the user in the multi-level relational tree diagram, as well as the query conditions entered by the user; A query statement generating unit, which is used for Generate SQL statements based on selected data tables and fields, and input query conditions; ； Result return unit, used to execute SQL statements and return query execution results. For example, the terminal according to item 6 of the scope of patent application, wherein the table creation unit includes a first field acquisition unit and a transformation execution unit; wherein, the first field acquisition unit is used to acquire the attributes of the class to which each object belongs and the attributes The conversion execution unit is used to convert the attributes of each class into a SQL statement and execute the SQL statement to create a data table, convert the attributes of each class and the value of the attribute into a SQL statement and execute the SQL statement To insert data into the table. For example, the terminal according to item 6 of the scope of patent application, wherein the tree diagram generating unit includes a table name obtaining unit, a judgment unit, a second field obtaining unit, a node saving unit, and a multi-layer relationship tree diagram generating unit; wherein, the table A name obtaining unit is used to obtain the name of the data table corresponding to the query object entered by the user; 判断 the judgment unit is used to determine whether the name of the data table exists; the second field obtaining unit is used to Name, get all the fields of the data table and the type of each field; 节点 The node save unit is used to use the name of the data table as the root node of the treemap, and use each field as a child of the root node Node to save; the judgment unit is also used to determine whether there are other data tables in the field according to the type of the field; if other data tables are involved, determine whether the name of the corresponding data table exists; and if the data exists The name of the table, to determine whether the saved table has the name of the table; The node saving unit is also used to save all the fields of the data table as the node next to the node corresponding to the current field if the saved node does not have the name of the data table, and so on until the tree diagram The field corresponding to each layer of nodes does not involve other data tables; The multi-layer relationship tree diagram generating unit is used to generate a multi-layer relationship tree diagram according to all the nodes saved. For example, the terminal according to any one of claims 6-8 of the scope of patent application, wherein the terminal further includes a storage container creation unit, a result storage unit, and a display unit; wherein, the storage container creation unit is configured to receive a message sent from vCenter Create a storage container after the alarm information is generated; The result storage unit is used to save the query execution result of the object involved in the alarm information in the storage container; The receiving unit is also used to receive the user's query execution result The detection object selected in the method; The display unit is configured to generate and display the performance curve of the detection object according to the detection object for finding the source of the alarm information. A device, wherein the device includes a processor and a memory connected to the processor; the memory is used to store a query object including a user input, the query object, and all objects associated with the query object Information, data tables and fields in the data tables, multi-layer relationship tree diagram, and other program data that can be called and run; 运行 The processor is used to call the program data stored in the memory, and execute the following steps: Receive the Query objects entered by users in vCenter; 筛选 Filter out all object information associated with the query object in vCenter according to the query object; 创建 create a data table based on the query object and the object information and insert relevant data in the data table, where The class to which each object belongs corresponds to a data table; 生成 Generate a multi-level relational tree diagram according to the data table and the fields in the data table; Receive the data tables and fields selected by the user in the multi-level relation tree and the query conditions entered by the user ; According to the selected data sheet and field, And input query conditions to generate SQL statements; Execute SQL statements and return query execution results.