Querying operating system state on multiple machines declaratively
First Claim
1. A method of querying operating system states of multiple hosts in a cluster, comprisingreceiving a Structure Query Language (SQL) query to determine the operating system states of the multiple hosts in the cluster;
- aggregating, from each of the multiple hosts, operating system state information in response to receiving the SQL query;
wherein aggregating includes, for each of the multiple hosts;
identifying a dataset applicable to the SQL query by parsing the SQL query;
requesting the identified dataset; and
receiving the dataset including the operating system state information in response to the request;
creating a temporary database for storing the operating system state information by converting the datasets received from the multiple hosts into a queriable form; and
executing the SQL query on the temporary database to obtain as results the operating system states of the multiple hosts.
5 Assignments
0 Petitions
Accused Products
Abstract
A sysSQL technology for querying operating system states of multiple hosts in a cluster using a Structured Query Language (SQL) query is disclosed. An administrator of a cluster can use a graphical or text-based user interface to submit an SQL query to determine the operating system states of multiple hosts in parallel. The technology parses the SQL query to determine the datasets needed to execute the SQL query and aggregates those datasets from the multiple hosts. The technology then creates a temporary database to execute the SQL query and provides the results from the SQL query for display on the user interface.
133 Citations
20 Claims
-
1. A method of querying operating system states of multiple hosts in a cluster, comprising
receiving a Structure Query Language (SQL) query to determine the operating system states of the multiple hosts in the cluster; -
aggregating, from each of the multiple hosts, operating system state information in response to receiving the SQL query; wherein aggregating includes, for each of the multiple hosts; identifying a dataset applicable to the SQL query by parsing the SQL query; requesting the identified dataset; and receiving the dataset including the operating system state information in response to the request; creating a temporary database for storing the operating system state information by converting the datasets received from the multiple hosts into a queriable form; and executing the SQL query on the temporary database to obtain as results the operating system states of the multiple hosts. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A method, comprising:
-
receiving a system Structure Query Language (sysSQL) query directed to multiple machines in a cluster; wherein the sysSQL query is submitted by a user using a user interface; and wherein the sysSQL query is a request for system information associated with the multiple machines; and creating a database, in response to receiving the sysSQL query, by aggregating system information from some or all of the multiple machines, wherein aggregating includes, for some or all of the multiple machines; identifying a dataset applicable to the sysSQL query by parsing the sysSQL query; requesting the identified dataset; receiving the dataset including the system information in response to the request; and converting the received dataset into a queriable form; and executing the sysSQL query on the database to obtain as results system information associated with some or all of the multiple machines. - View Dependent Claims (7, 8, 9, 10, 11, 12, 13)
-
-
14. A system comprising:
-
a server; and multiple hosts in a cluster; the server being configured to; receive a Structure Query Language (SQL) query requesting operating system state information associated with the multiple hosts in the cluster, the SQL query being submitted via a user interface; aggregate, from each of the multiple hosts, operating system state information in response to receiving the SQL query, wherein aggregating includes; identifying datasets applicable to the SQL query by parsing the SQL query; requesting the identified datasets from agents of the multiple hosts; and receiving the requested datasets including the operating state information in response to the requests; create a temporary database by converting the received datasets into a queriable form; and execute the SQL query on the temporary database to obtain the operating system state information associated with the multiple hosts in the cluster. - View Dependent Claims (15, 16, 17, 18, 19, 20)
-
Specification