Back to results
US 2018/0004796 A1Published application
System performance logging of complex remote query processor query operations
AssigneeDeephaven Data Labs LLC
InventorsDavid R. Kent, IV, Ryan Caudy, Charles Wright, Radu Teodorescu
Life of this patent
Estimating the term…
Abstract
Described are methods, systems and computer readable media for performance logging of complex query operations.
Claims20
A system for improving performance of a remote query computer system by using dynamic query performance logging to identify and remediate efficiency impediments in the remote query computer system, the system comprising:
- one or more processors;
- computer readable storage coupled to the one or more processors, the computer readable storage having stored thereon instructions that, when executed by the one or more processors, cause the one or more processors to perform operations including:
- receiving at a remote query processor on a query server computer a digital request for a remote query processor from a client computer;
- at the query server computer performing operations including:
- receiving a digital request from the client computer to execute a query task;
- executing the query task;
- generating a set of query task data;
- generating a set of query subtask data;
- collecting the set of query task data;
- digitally transmitting the set of query task data to one or more performance table loggers;
- collecting the set of query subtask data;
- transmitting the set of query subtask data to one or more performance table logger processes;
- the one or more performance table logger processes writing the set of query task data to a first set of electronic data systems for subsequent retrieval and analysis;
- the one or more performance table logger processes writing the set of query subtask data to a second set of electronic data systems for subsequent retrieval and analysis;
- with a processor retrieving the set of query task data and the set of query subtask data;
- using a performance-enhancing processor to analyze the retrieved set of query task data and the retrieved set of query subtask data to obtain an analysis result;
- with the performance-enhancing processor, identifying based on the analysis result an efficiency impediment in the query server computer;
- and
- responsive to the identifying, using a processor to make changes to the stored instructions and thereby alleviate the identified efficiency impediment and improve efficiency of the remote query computer system,
- wherein the efficiency impediment is one or more of:
- a dataflow bottleneck, excessive use of processor resources, or excessive use of RAM.
18 more elements
A method comprising:
- executing a query task;
- generating a set of query task data;
- generating a set of query subtask data;
- collecting the set of query task data;
- collecting the set of query subtask data;
- writing the set of query task data to a first set of data systems for subsequent retrieval and analysis;
- and
- writing the set of query subtask data to a second set of data systems for subsequent retrieval and analysis.
5 more elements
A nontransitory computer readable medium having stored thereon software instructions that, when executed by one or more processors, cause the one or more processors to perform operations including:
- receiving a digital request from a client computer to execute a query task;
- executing the query task;
- generating a set of query task data;
- generating a set of query subtask data;
- collecting the set of query task data;
- digitally transmitting the set of query task data to one or more performance table loggers;
- collecting the set of query subtask data;
- transmitting the set of query subtask data to one or more performance table logger processes;
- the one or more performance table logger processes writing the set of query task data to a first set of electronic data systems for subsequent retrieval and analysis;
- the one or more performance table logger processes writing the set of query subtask data to a second set of electronic data systems for subsequent retrieval and analysis;
- retrieving the set of query task data and the set of query subtask data;
- analyzing the retrieved set of query task data and the retrieved set of query subtask data to obtain an analysis result;
- identifying based on the analysis result an efficiency impediment in a query server computer system;
- and
- making changes to the stored instructions and thereby alleviating the identified efficiency impediment and improve efficiency of a remote query computer system,
- wherein the efficiency impediment is one or more of:
- a dataflow bottleneck, excessive use of processor resources, or excessive use of RAM.
14 more elements
Dependencies are inferred from the claim text.