GRAPH SEARCH IN STRUCTURED QUERY LANGUAGE STYLE QUERY

• US 20180219752A1
• Filed: 01/31/2017
• Published: 08/02/2018
• Est. Priority Date: 01/31/2017
• Status: Active Grant

• Current Assignee: Cisco Technology, Inc. (Cisco Systems, Inc.)
• Original Assignee: AppDynamics, Inc. (Cisco Systems, Inc.)
• Inventors: Wang, Tao, Finch, Ellen, Rassouli, Arash
• Granted Patent: US 10,644,971 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 16/2428 Query predicate definition using graphical user interfaces, including menus and forms G06F16/2423 takes precedence
• CPC Class Codes: G06F 16/2445 Data retrieval commands; View definitions
• CPC Class Codes: H04L 41/22 comprising specially adapted graphical user interfaces [GUI]
• CPC Class Codes: H04L 41/5025 by proactively reacting to service quality change, e.g. by reconfiguration after service quality degradation or upgrade
• CPC Class Codes: H04L 43/045 for graphical visualisation of monitoring data
• CPC Class Codes: H04L 43/067 using time frame reporting
• CPC Class Codes: H04L 43/16 Threshold monitoring
• CPC Class Codes: H04L 67/025 for remote control or remote monitoring of applications

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.

Claims

1. A system for automatic detection of webpage loading at a web browser of a client device in a monitored environment, the system including:

a processor;

a memory; and

one or more modules stored in the memory and executable by a processor to perform operations including;

detect start of loading of a webpage at the web browser of the client device in the monitored environment;

set a dynamic watchdog repeating timer at a value;

start the timer;

recursively check for completion of the loading of the webpage;

when determined that the loading of the webpage has completed, determine whether a Java script engine of the web browser loading the webpage is idle; and

when determined that the Java script engine of the web browser loading the webpage is idle, stop the timer and generate a report of the webpage.

2. The system of claim 1, wherein when determining that that the loading of the webpage has not completed, the one or more modules are executable to perform operations including:

reset the timer;

restart the reset timer; and

perform the recursively check for completion of the loading of the webpage.

3. The system of claim 1, wherein when determining whether the Java script engine of the web browser loading the webpage is idle, the one or more modules are executable to perform operations including:

determine whether any network requests have ended in a most recent pre-determined time period.

4. The system of claim 1, wherein the one or more modules are executable to perform the recursively check for completion of the loading of the webpage including:

determine whether all pending network requests have finished;

or

determine whether a global ceiling has been reached;

or

determine both that all pending network requests have finished and a global ceiling has been reached.

5. The system of claim 1, wherein the one or more modules are executable to perform the recursively check for completion of the loading of the webpage including:

check for iframes; and

attach load listeners to the iframes when found.

6. The system of claim 1, wherein the one or more modules are executable to perform operations including:

receive data associated with the monitored environment including applications performed over a distributed system of interconnected nodes of machines;

receive the generated report; and

correlate the received data with the generated report.

7. The system of claim 6, wherein the one or more modules are executable to perform operations including:

identify performance issues with the monitored applications from the received data; and

determine a relationship between the identified performance issues and the generated report of the webpage.

8. The system of claim 6, wherein the one or more modules are executable to perform operations including:

identify nodes of interest and one or more chains of nodes connected to the nodes of interest from the interconnected nodes based on the received data;

generate an interactive flow map of the interconnected nodes in the distributed system;

provide a user interface for displaying the interactive flow map; and

automatically display the interactive flow map and the correlated report through the provided user interface.

9. A method for automatic detection of webpage loading at a web browser of a client device in a monitored environment, the method including:

detecting start of loading of a webpage at the web browser of the client device in the monitored environment;

setting a dynamic watchdog repeating timer at a value;

starting the timer;

recursively checking for completion of the loading of the webpage;

when determined that the loading of the webpage has completed, determining whether a Java script engine of the web browser loading the webpage is idle; and

when determined that the Java script engine of the web browser loading the webpage is idle, stopping the timer and generating a report of the webpage.

10. The method of claim 9, wherein when determining that that the loading of the webpage has not completed, performing operations including:

resetting the timer;

restarting the reset timer; and

performing the recursively check for completion of the loading of the webpage.

11. The method of claim 9, wherein when determining whether the Java script engine of the web browser loading the webpage is idle, performing operations including:

determining whether any network requests have ended in a most recent pre-determined time period.

12. The method of claim 9, wherein recursively checking for completion of the loading of the webpage include:

determining whether all pending network requests have finished;

or

determining whether a global ceiling has been reached;

or

determining that both all pending network requests have finished and a global ceiling has been reached.

13. The method of claim 9, wherein recursively checking for completion of the loading of the webpage includes:

checking for iframes; and

attaching load listeners to the iframes when found.

14. The method of claim 9, including:

receiving data associated with the monitored environment including applications performed over a distributed system of interconnected nodes of machines;

receiving the generated report; and

correlating the received data with the generated report.

15. The method of claim 14, including:

identifying performance issues with the monitored applications from the received data; and

determining a relationship between the identified performance issues and the generated report of the webpage.

16. The method of claim 14, including:

identifying nodes of interest and one or more chains of nodes connected to the nodes of interest from the interconnected nodes based on the received data;

generating an interactive flow map of the interconnected nodes in the distributed system;

provide a user interface for displaying the interactive flow map; and

automatically displaying the interactive flow map and the correlated report through the provided user interface.

19. The non-transitory computer readable medium of claim 14, wherein when determining whether the Java script engine of the web browser loading the webpage is idle, performing operations including:

determining whether any network requests have ended in a most recent pre-determined time period.

17. A non-transitory computer readable medium embodying instructions when executed by a processor to cause operations to be performed for automatic detection of webpage loading at a web browser of a client device in a monitored environment, the operations including:

detecting start of loading of a webpage at the web browser of the client device in the monitored environment;

setting a dynamic watchdog repeating timer at a value;

starting the timer;

recursively checking for completion of the loading of the webpage;

when determined that the loading of the webpage has completed, determining whether a Java script engine of the web browser loading the webpage is idle; and

when determined that the Java script engine of the web browser loading the webpage is idle, stopping the timer and generating a report of the webpage.

18. The non-transitory computer readable medium of claim 17, wherein when determining that that the loading of the webpage has not completed, performing operations including:

resetting the timer;

restarting the reset timer; and

performing the recursively check for completion of the loading of the webpage.

20. The non-transitory computer readable medium of claim 17, wherein recursively checking for completion of the loading of the webpage include:

determining whether all pending network requests have finished;

or

determining whether a global ceiling has been reached;

or

determining that both all pending network requests have finished and a global ceiling has been reached.

21. The non-transitory computer readable medium of claim 17, wherein recursively checking for completion of the loading of the webpage includes:

checking for iframes; and

attaching load listeners to the iframes when found.

22. The non-transitory computer readable medium of claim 17, the operations including:

receiving data associated with the monitored environment including applications performed over a distributed system of interconnected nodes of machines;

receiving the generated report; and

correlating the received data with the generated report.

23. The non-transitory computer readable medium of claim 22, the operations including:

identifying performance issues with the monitored applications from the received data; and

determining a relationship between the identified performance issues and the generated report of the webpage.

24. The non-transitory computer readable medium of claim 22, the operations including:

identifying nodes of interest and one or more chains of nodes connected to the nodes of interest from the interconnected nodes based on the received data;

generating an interactive flow map of the interconnected nodes in the distributed system;

provide a user interface for displaying the interactive flow map; and

automatically displaying the interactive flow map and the correlated report through the provided user interface.