Graph search in structured query language style query
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.
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.
2. The method as in claim 1 , further comprising:
receiving an indication of initiating a basic or advanced query.
3. The method as in claim 1 , further comprising:
providing, by the controller, a suggestion for at least a portion of the new query based on the received input.
4. The method as in claim 3 , further comprising:
analyzing a context of at least a portion of the received input to provide the suggestion.
5. The method as in claim 3 , further comprising:
recognizing a pattern of at least a portion of the received input to provide the suggestion.
6. The method as in claim 3 , wherein the provided suggestion includes a list of related entities.
7. The method as in claim 1 , wherein the new query includes the SELECT clause and the WHEREIN clause in SQL style.
8. The method as in claim 1 , wherein the graph traversal path is representative of a chain of relationship between different entities.
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.
10. The non-transitory computer readable storage medium of claim 9 , further comprising:
receiving an indication of initiating a basic or advanced query.
11. The non-transitory computer readable storage medium of claim 9 , further comprising:
providing, by the controller, a suggestion for at least a portion of the new query based on the received input.
12. The non-transitory computer readable storage medium of claim 11 , further comprising:
analyzing a context of at least a portion of the received input to provide the suggestion.
13. The non-transitory computer readable storage medium of claim 11 , further comprising:
recognizing a pattern of at least a portion of the received input to provide the suggestion.
14. The non-transitory computer readable storage medium of claim 11 , wherein the provided suggestion includes a list of related entities.
15. The non-transitory computer readable storage medium of claim 9 , wherein the new query includes the SELECT clause and the WHEREIN clause in SQL style.
16. The computer-readable media as in claim 9 , wherein the graph traversal path is representative of a chain of relationship between different entities.
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.
18. The system of claim 17 , the one or more modules further executable by the processor to:
receive an indication of initiating a basic or advanced query.
19. The system of claim 17 , the one or more modules further executable by the processor to:
provide, by the controller, a suggestion for at least a portion of the new query based on the received input.
20. The system of claim 19 , the one or more modules further executable by the processor to:
analyze a context of at least a portion of the received input to provide the suggestion.
21. The system of claim 19 , the one or more modules further executable by the processor to:
recognize a pattern of at least a portion of the received input to provide the suggestion.
22. The system of claim 19 , wherein the provided suggestion includes a list of related entities.
23. The system of claim 17 , wherein the new query includes the SELECT clause and the WHEREIN clause in SQL style.
24. The system of claim 17 , wherein the graph traversal path is representative of a chain of relationship between different entities.