WO2018205376A1 - Procédé d'interrogation d'informations d'association, terminal, système de gestion de serveur et support de stockage lisible par ordinateur - Google Patents
Procédé d'interrogation d'informations d'association, terminal, système de gestion de serveur et support de stockage lisible par ordinateur Download PDFInfo
- Publication number
- WO2018205376A1 WO2018205376A1 PCT/CN2017/090923 CN2017090923W WO2018205376A1 WO 2018205376 A1 WO2018205376 A1 WO 2018205376A1 CN 2017090923 W CN2017090923 W CN 2017090923W WO 2018205376 A1 WO2018205376 A1 WO 2018205376A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data table
- query
- data
- name
- unit
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2423—Interactive query statement specification based on a database schema
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2452—Query translation
- G06F16/24522—Translation of natural language queries to structured queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24549—Run-time optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
- G06F9/45533—Hypervisors; Virtual machine monitors
- G06F9/45558—Hypervisor-specific management and integration aspects
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/455—Emulation; Interpretation; Software simulation, e.g. virtualisation or emulation of application or operating system execution engines
- G06F9/45533—Hypervisors; Virtual machine monitors
- G06F9/45558—Hypervisor-specific management and integration aspects
- G06F2009/45591—Monitoring or debugging support
Definitions
- 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.
- the operation and maintenance personnel of the virtual machine software manage the virtual machine (VM)
- 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.
- 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.
- 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.
- 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.
- an embodiment of the present invention provides a method for querying related information, where the method includes:
- 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.
- 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.
- 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.
- 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.
- 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.
- FIG. 1 is a schematic flowchart of a method for querying related information according to an embodiment of the present invention
- FIG. 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. 4 is a schematic flowchart of a method for querying associated information according to another embodiment of the present invention.
- FIG. 5 is a schematic flowchart of a method for querying related information according to another embodiment of the present invention.
- 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. 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. 10 is a schematic block diagram of a terminal according to another embodiment of the present invention.
- FIG. 11 is a schematic block diagram of a terminal according to another embodiment of the present invention.
- 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.
- 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.
- vCenter is the virtualization management server platform VMware vCenter Abbreviation for Server.
- the components involved mainly include hosts, virtual machines, networks, storage, clusters, and so on.
- 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.
- 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.
- 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.
- 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.
- the created table is named according to the preset rules, such as t-class name.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- vCenter Receives a query object input by a user in the vCenter.
- the components involved mainly include hosts, virtual machines, networks, storage, clusters, and so on.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- vCenter is the virtualization management server platform VMware vCenter Abbreviation for Server.
- the components involved mainly include hosts, virtual machines, networks, storage, clusters, and so on.
- 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.
- 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.
- 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.
- all the object information associated with the query object is filtered according to the saved abstracted class and the corresponding relationship between the classes.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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 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.
- 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.
- 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.
- 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.
- 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.
- the object involved in the alarm information is the network.
- 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.
- 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.
- the selected detection object is a plurality.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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:
- Processing device 134 also performs the following operations:
- Processing device 134 also performs the following operations:
- Processing device 134 also performs the following operations:
- 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:
- the storage container 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:
- the step further comprises:
- the step further comprises:
- the step further comprises:
- the step further comprises:
- the storage container 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 disclosed terminal and method may be implemented in other manners.
- the terminal embodiments described above are merely illustrative.
- the division of the unit is only a logical function division.
- 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.
- 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.
- 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.
- 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.
- 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)
- ROM Read-Only Memory
- RAM Random Access
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Artificial Intelligence (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710326709.4A CN107665228B (zh) | 2017-05-10 | 2017-05-10 | 一种关联信息查询方法、终端及设备 |
CN201710326709.4 | 2017-05-10 |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2018205376A1 true WO2018205376A1 (fr) | 2018-11-15 |
Family
ID=61122524
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/CN2017/090923 WO2018205376A1 (fr) | 2017-05-10 | 2017-06-29 | Procédé d'interrogation d'informations d'association, terminal, système de gestion de serveur et support de stockage lisible par ordinateur |
Country Status (3)
Country | Link |
---|---|
CN (1) | CN107665228B (fr) |
TW (1) | TWI650659B (fr) |
WO (1) | WO2018205376A1 (fr) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112818007A (zh) * | 2021-02-03 | 2021-05-18 | 中科驭数(北京)科技有限公司 | 数据处理方法、装置及可读存储介质 |
CN114116866A (zh) * | 2021-11-22 | 2022-03-01 | 广州新科佳都科技有限公司 | 一种数据获取方法、装置、终端设备及存储介质 |
Families Citing this family (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108363785A (zh) * | 2018-02-12 | 2018-08-03 | 平安科技(深圳)有限公司 | 数据关系展示方法、装置、计算机设备及存储介质 |
CN108389079A (zh) * | 2018-02-13 | 2018-08-10 | 腾讯科技(深圳)有限公司 | 计费策略的制定与查询方法、装置、终端及可读存储介质 |
CN109144997A (zh) * | 2018-06-11 | 2019-01-04 | 玖富金科控股集团有限责任公司 | 数据关联方法、装置及存储介质 |
CN109840257B (zh) * | 2018-12-15 | 2023-11-21 | 中国平安人寿保险股份有限公司 | 数据库查询方法、装置、计算机装置及可读存储介质 |
CN109918394B (zh) * | 2019-01-23 | 2023-11-28 | 中国平安人寿保险股份有限公司 | 数据查询方法、系统、计算机装置及计算机可读存储介质 |
CN109933602B (zh) * | 2019-02-28 | 2021-05-04 | 武汉大学 | 一种自然语言与结构化查询语言的转换方法及装置 |
CN111723245B (zh) * | 2019-03-18 | 2024-04-26 | 阿里巴巴集团控股有限公司 | 数据存储系统中建立不同类型存储对象关联关系的方法 |
CN112559538A (zh) * | 2020-11-11 | 2021-03-26 | 中广核工程有限公司 | 关联关系生成方法、装置、计算机设备和存储介质 |
CN112597171A (zh) * | 2020-12-31 | 2021-04-02 | 平安银行股份有限公司 | 表格关系可视化方法、装置、电子设备及存储介质 |
CN113392105B (zh) * | 2021-05-24 | 2023-03-24 | 国网河北省电力有限公司衡水供电分公司 | 业务数据处理方法和终端设备 |
CN113468003B (zh) * | 2021-06-18 | 2023-06-02 | 上海芷锐电子科技有限公司 | 一种芯片测试数据的树形显示与操作系统和方法 |
CN113297255B (zh) * | 2021-06-23 | 2023-01-24 | 建信金融科技有限责任公司 | 一种数据处理方法和装置 |
CN113407548B (zh) * | 2021-08-18 | 2021-11-19 | 南京网觉软件有限公司 | 基于ClickHouse字典表的大数据查询方法、系统和介质 |
CN115757400B (zh) * | 2022-11-07 | 2023-06-13 | 北京国电通网络技术有限公司 | 数据表处理方法、装置、电子设备和计算机可读介质 |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101145162A (zh) * | 2007-10-31 | 2008-03-19 | 金蝶软件(中国)有限公司 | 一种数据库动态查询的方法和系统 |
CN102646111A (zh) * | 2012-02-16 | 2012-08-22 | 中国测绘科学研究院 | 一种基于知识库的通用关联信息查询树的快速构建方法 |
CN104615602A (zh) * | 2013-11-05 | 2015-05-13 | 深圳中兴力维技术有限公司 | 查询界面自动生成实现装置及其方法 |
US20150254307A1 (en) * | 2014-03-10 | 2015-09-10 | Interana, Inc. | System and methods for rapid data analysis |
Family Cites Families (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
AU5755300A (en) * | 1999-06-22 | 2001-01-09 | Internet Dynamics, Inc. | Query interface to policy server |
US6950823B2 (en) * | 2002-12-23 | 2005-09-27 | International Business Machines Corporation | Transparent edge-of-network data cache |
US7844608B2 (en) * | 2006-12-15 | 2010-11-30 | Yahoo! Inc. | Clustered query support for a database query engine |
US8392473B2 (en) * | 2010-09-07 | 2013-03-05 | Microgen Aptitude Limited | Fast hierarchical enrichment |
-
2017
- 2017-05-10 CN CN201710326709.4A patent/CN107665228B/zh active Active
- 2017-06-29 WO PCT/CN2017/090923 patent/WO2018205376A1/fr active Application Filing
- 2017-11-03 TW TW106138204A patent/TWI650659B/zh active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101145162A (zh) * | 2007-10-31 | 2008-03-19 | 金蝶软件(中国)有限公司 | 一种数据库动态查询的方法和系统 |
CN102646111A (zh) * | 2012-02-16 | 2012-08-22 | 中国测绘科学研究院 | 一种基于知识库的通用关联信息查询树的快速构建方法 |
CN104615602A (zh) * | 2013-11-05 | 2015-05-13 | 深圳中兴力维技术有限公司 | 查询界面自动生成实现装置及其方法 |
US20150254307A1 (en) * | 2014-03-10 | 2015-09-10 | Interana, Inc. | System and methods for rapid data analysis |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112818007A (zh) * | 2021-02-03 | 2021-05-18 | 中科驭数(北京)科技有限公司 | 数据处理方法、装置及可读存储介质 |
CN112818007B (zh) * | 2021-02-03 | 2021-10-19 | 中科驭数(北京)科技有限公司 | 数据处理方法、装置及可读存储介质 |
CN114116866A (zh) * | 2021-11-22 | 2022-03-01 | 广州新科佳都科技有限公司 | 一种数据获取方法、装置、终端设备及存储介质 |
Also Published As
Publication number | Publication date |
---|---|
TWI650659B (zh) | 2019-02-11 |
TW201901491A (zh) | 2019-01-01 |
CN107665228B (zh) | 2019-12-20 |
CN107665228A (zh) | 2018-02-06 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2018205376A1 (fr) | Procédé d'interrogation d'informations d'association, terminal, système de gestion de serveur et support de stockage lisible par ordinateur | |
WO2019100638A1 (fr) | Procédé, dispositif et équipement de synchronisation de données, et support d'informations | |
WO2018107610A1 (fr) | Procédé, système et dispositif de traitement de données de service, et support d'informations lisible par ordinateur | |
WO2019037396A1 (fr) | Procédé, dispositif et équipement de suppression de compte et support d'informations | |
WO2019104876A1 (fr) | Procédé et système de poussée de produit d'assurance, terminal, terminal client et support d'informations | |
WO2018233370A1 (fr) | Procédé, système, dispositif et support de stockage lisible par ordinateur de synchronisation d'une image | |
WO2018014567A1 (fr) | Procédé servant à améliorer les performances d'une machine virtuelle, et terminal, dispositif et support de stockage lisible par ordinateur | |
WO2019075973A1 (fr) | Procédé et dispositif de test de programme d'application | |
WO2015144089A1 (fr) | Procédé et appareil de recommandation d'application | |
WO2019174375A1 (fr) | Procédé, appareil et dispositif de test d'interface, et support de stockage lisible par ordinateur | |
WO2019169814A1 (fr) | Procédé, appareil et dispositif de génération automatique d'annotation en chinois, et support d'informations | |
WO2015131803A1 (fr) | Procédé et système de recommandation d'application | |
WO2018120430A1 (fr) | Procédé de construction de page, terminal, support de stockage lisible par ordinateur et dispositif de construction de page | |
WO2018149300A1 (fr) | Procédé, appareil et dispositif de détection de probabilité de maladie, et support de stockage lisible par ordinateur | |
WO2014026526A1 (fr) | Procédé de réglage d'informations de personne naturelle et dispositif électronique | |
WO2019041832A1 (fr) | Procédé, serveur et système de modification de structure de table de base de données source, et support de stockage | |
WO2018233301A1 (fr) | Procédé, appareil et dispositif de recommandation de produit et support d'informations lisible par ordinateur | |
WO2014000635A1 (fr) | Procédé permettant à un lecteur de fournir un service, lecteur, terminal et support de stockage d'ordinateur | |
WO2016000560A1 (fr) | Procédé et appareil de transmission de fichier et appareil de réception de fichier | |
WO2015106497A1 (fr) | Procédé dynamique de mappage équilibré d'interruption en fonction d'un état de programmation de vcpu en cours | |
WO2019024219A1 (fr) | Procédé et appareil de génération automatique de document, générateur automatique de document et support | |
WO2018076811A1 (fr) | Dispositif électronique, support d'informations, système, dispositif et procédé de partage de données | |
WO2019052164A1 (fr) | Procédé, dispositif, appareil et support d'informations d'appel vidéo de suivi | |
WO2019109521A1 (fr) | Procédé, appareil et dispositif de validation d'identité pour un entretien vidéo et support d'enregistrement lisible | |
WO2018188196A1 (fr) | Procédé de commande de version de données, contrôleur de version de données, dispositif et support de stockage lisible par ordinateur |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 17909132 Country of ref document: EP Kind code of ref document: A1 |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 17909132 Country of ref document: EP Kind code of ref document: A1 |
|
32PN | Ep: public notification in the ep bulletin as address of the adressee cannot be established |
Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 17.03.2020) |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 17909132 Country of ref document: EP Kind code of ref document: A1 |