Systems and methods for monitoring user-defined metrics

Abstract

Disclosed are systems and methods for monitoring user-defined metrics. A method may include: receiving, from a user device, a metric definition usable to generate queries to obtain data for a metric to be monitored; receiving, from the user device, a monitoring configuration indicative of a manner in which a metric monitoring process associated with the metric definition is to be repeatedly performed; storing the metric definition in a metric definition database; and repeatedly performing the metric monitoring process in accordance with the monitoring configuration. The metric monitoring process may include: retrieving the metric definition from the metric definition database; generating a database query based on the metric definition, the database query including one or more executable database statements defined by the metric definition; executing the database query to obtain query result data, the query result data being data for the metric; and storing the query result data.

1 - 20 . (canceled) 
     
     
         21 . A computer-implemented method for monitoring metrics, the method comprising:
 receiving, from a user device, a query definition for a metric to be monitored via a metric monitoring process, the metric measuring an event having event data recorded in a data warehouse, and the query definition including one or more variables to be resolved;   automatically scheduling the metric monitoring process to be repeatedly performed at a particular frequency; and   automatically performing the metric monitoring process based on the scheduling, wherein performing each metric monitoring process includes:
 generating a query to be executed based on the query definition, the generating including resolving the one or more variables based on an execution context of the query; and 
 providing the query to the data warehouse for execution to obtain query result data based on the recorded event data, wherein the query result data includes a value, for the metric, and the query result data is stored in a table of the data warehouse that is accessible by the user device. 
   
     
     
         22 . The computer-implemented method of  claim 21 , wherein receiving the query definition comprises:
 generating and providing, to the user device, a user interface enabling submission of a new query definition for display on the user device, wherein the query definition received is a new query definition submitted via the user interface.   
     
     
         23 . The computer-implemented method of  claim 21 , wherein receiving the query definition comprises;
 generating and providing, to the user device, a user interface comprising a plurality of previously submitted query definitions for display on the user device, wherein the query definition received is selected from the plurality of previously submitted query definitions via the user interface.   
     
     
         24 . The computer-implemented method of  claim 21 , further comprising:
 providing the query definition to a definition database for storage; and   for each metric monitoring process performed, receiving the query definition from the definition database to generate the query based on the query definition.   
     
     
         25 . The computer-implemented method of  claim 21 , wherein the query definition defines one or more executable database statements, and at least one of the one or more executable database statements includes the one or more variables to be resolved. 
     
     
         26 . The computer-implemented method of  claim 25 , wherein generating the query comprises:
 determining an execution value of each of the one or more variables based on the execution context of the query to resolve the one or more variables; and   determining the at least one executable database statement by setting each of the one or more variables to the respective execution value, such that the at least one executable database statement includes the execution value of the variable.   
     
     
         27 . The computer-implemented method of  claim 21 , wherein the one or more variables to be resolved include one or more of a target schema, a table name, a start date, or an end date associated with the event data recorded in the data warehouse. 
     
     
         28 . The computer-implemented method of  claim 21 , wherein the execution context of the query includes one or more of a date, a time, or an environment associated with the execution. 
     
     
         29 . The computer-implemented method of  claim 21 , wherein event data associated with a plurality of events of different event types, including the event data associated with the event, are recorded in the data warehouse, and automatically scheduling the metric monitoring process to be repeatedly performed at the particular frequency comprises;
 scheduling the metric monitoring process to be performed sequentially with at least one other metric monitoring process for monitoring a metric to measure another event from the plurality of events.   
     
     
         30 . The computer-implemented method of  claim 21 , further comprising:
 receiving, from the user device, a monitoring configuration that includes the particular frequency at which the metric monitoring process is to be repeatedly performed.   
     
     
         31 . The computer-implemented method of  claim 21 , wherein:
 the metric is associated with a particular period of time,   query result data obtained as part of one or more initial performances of the metric monitoring process and stored in the table includes values for the metric for a first period of time corresponding to the particular period of time, and   query result data obtained as part of one or more later performances of the metric monitoring process and stored in the table as an appendage to the table includes values for the metric for a second period of time corresponding to the particular period of time and different from the first period of time,   
     
     
         32 . A system for monitoring metrics, the system comprising:
 a memory storing instructions; and   one or more processors configured to execute the instructions to perform operations including:
 receiving, from a user device, a query definition usable to generate a query to obtain data for a metric associated with an event from a plurality of events having event data recorded in a data warehouse, the query definition including one or more variables to be resolved at a time of query execution; 
 automatically scheduling the query to be repeatedly executed at a particular frequency; and 
 in accordance with the scheduling, automatically initiating an execution of the query by:
 generating the query to be executed based on the query definition, the generating including resolving the one or more variables based on an execution context of the query; and 
 providing the query to the data warehouse for execution to obtain query result data based on the recorded event data for the event, wherein the query result data includes data for the metric, and the query result data is stored in a table of the data warehouse that is accessible by the user device. 
 
   
     
     
         33 . The system of  claim 32 , wherein the query definition defines one or more executable database statements, and at least one of the one or more executable database statements includes the one or more variables to be resolved. 
     
     
         34 . The system of  claim 33 , wherein generating the query comprises:
 determining an execution value of each of the one or more variables based on the execution context of the query to resolve the one or more variables; and   determining the at least one executable database statement by setting each of the one or more variables to the respective execution value, such that the at least one executable database statement includes the execution value of the variable.   
     
     
         35 . The system of  claim 32 , wherein the one or more variables to be resolved include one or more of a target schema, a table name, a start date, or an end date associated with the event data recorded in the data warehouse. 
     
     
         36 . The system of  claim 32 , wherein the execution context of the query includes one or more of a date, a time, or an environment associated with the execution. 
     
     
         37 . The system of  claim 32  wherein:
 the metric is associated with a particular period of time, 
 query result data obtained as part of one or more initial query executions and stored in the table includes data for the metric for a first period of time corresponding to the particular period of time, and 
 query result data obtained as part of one or more later query executions and stored in the table as an appendage to the table includes data for the metric for a second period of time corresponding to the particular period of time and different from the first period of time. 
 
     
     
         38 . A computer-implemented method for monitoring metrics, the method comprising:
 receiving, from a user device, a query definition for a metric to be monitored via a metric monitoring process, the metric being a measure of an event having event data recorded in a data warehouse and the metric being associated with a particular period of time;   automatically scheduling the metric monitoring process to be repeatedly performed at a particular frequency; and   automatically performing the metric monitoring process based on the scheduling, wherein performing each metric monitoring process includes:
 generating a query to be executed based on the query definition; and 
 providing the query to the data warehouse for execution to obtain query result data based on the recorded event data, the query result data including data for the metric for a first period of time corresponding to the particular period of time, 
   wherein the query result data is stored in a table of the data warehouse that is accessible by the user device, and as the metric monitoring process is repeatedly performed, additional query result data obtained is appended to the table of the data warehouse, the additional query result data including data for the metric for a second period of time corresponding to the particular period of time.   
     
     
         39 . The computer-implemented method of  claim 38 , wherein the query definition defines one or more executable database statements, and each of the one or more executable database statements are explicit database statements. 
     
     
         40 . The computer-implemented method of  claim 38 , wherein the query definition defines one or more executable database statements, and at least one of the one or more executable database statements includes one or more variables to be resolved at a time of query execution.