Graph search in structured query language style query
First Claim
1. A method for performing graph searches in a structured query language (SQL) for monitored data, comprising:
- receiving, by a controller in communication with agents installed at machines connected over a network, monitored data regarding business applications running over the machines;
identifying, by the controller, performance issues from the received monitored data;
providing, by the controller, an interactive user interface to enable creation of a query for the monitored data and the identified performance issues;
receiving, through the provided interactive user interface, input associated with a new query including a SELECT clause, a FROM clause, and a WHEREIN clause;
creating the new query based on the received input;
converting at least a portion of the new query to contain a graph traversal path entirely within the FROM clause, wherein the graph traversal path represents a set of nodes the query must traverse, wherein the set of nodes are particular machines of the machines connected over that network that perform at least part of a business application of the business application, wherein the business application is indicated by the received input;
executing the new query; and
returning a result of the executed new query.
3 Assignments
0 Petitions
Accused Products
Abstract
In one aspect, a system for performing graph searches in an SQL style query for monitored data includes a processor; a memory; and one or more modules stored in the memory and executable by a processor to perform operations including: receive, by a controller in communication with agents installed at machines connected over a network, monitored data regarding applications running over the machines; identify performance issues from the received monitored data; provide an interactive user interface to enable creation of a query for the monitored data and the identified performance issues; receive input associated with a new query including a SELECT clause, a FROM clause, and a WHEREIN clause; create the new query based on the received input; convert at least a portion of the new query to contain a graph traversal path entirely within the FROM clause; execute the new query; and return a result.
11 Citations
24 Claims
-
1. A method for performing graph searches in a structured query language (SQL) for monitored data, comprising:
-
receiving, by a controller in communication with agents installed at machines connected over a network, monitored data regarding business applications running over the machines; identifying, by the controller, performance issues from the received monitored data; providing, by the controller, an interactive user interface to enable creation of a query for the monitored data and the identified performance issues; receiving, through the provided interactive user interface, input associated with a new query including a SELECT clause, a FROM clause, and a WHEREIN clause; creating the new query based on the received input; converting at least a portion of the new query to contain a graph traversal path entirely within the FROM clause, wherein the graph traversal path represents a set of nodes the query must traverse, wherein the set of nodes are particular machines of the machines connected over that network that perform at least part of a business application of the business application, wherein the business application is indicated by the received input; executing the new query; and returning a result of the executed new query. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A non-transitory computer readable storage medium having embodied thereon a program, the program being executable by a processor to perform a method for performing graph searches in a structured query language (SQL) for monitored data, the method comprising:
-
receiving, by a controller in communication with agents installed at machines connected over a network, monitored data regarding business applications running over the machines; identifying, by the controller, performance issues from the received monitored data; providing, by the controller, an interactive user interface to enable creation of a query for the monitored data and the identified performance issues; receiving, through the provided interactive user interface, input associated with a new query including a SELECT clause, a FROM clause, and a WHEREIN clause; creating the new query based on the received input; converting at least a portion of the new query to contain a graph traversal path entirely within the FROM clause, wherein the graph traversal path represents a set of nodes the query must traverse, wherein the set of nodes are particular machines of the machines connected over that network that perform at least part of a business application of the business application, wherein the business application is indicated by the received input; executing the new query; and returning a result of the executed new query. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A system for performing graph searches in a structured query language (SQL) for monitored data, the system comprising:
-
a server including a processor and memory, one or more modules stored in them memory and executable by the processor to; receive, by a controller in communication with agents installed at machines connected over a network, monitored data regarding business applications running over the machines; identify, by the controller, performance issues from the received monitored data; provide, by the controller, an interactive user interface to enable creation of a query for the monitored data and the identified performance issues; receive, through the provided interactive user interface, input associated with a new query including a SELECT clause, a FROM clause, and a WHEREIN clause; create the new query based on the received input; convert at least a portion of the new query to contain a graph traversal path entirely within the FROM clause, wherein the graph traversal path represents a set of nodes the query must traverse, wherein the set of nodes are particular machines of the machines connected over that network that perform at least part of a business application of the business application, wherein the business application is indicated by the received input; execute the new query; and return a result of the executed new query. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24)
-
Specification