Systems and methods for monitoring user-defined metrics

A computer system for monitoring metrics, the computer system comprising:

• a memory storing instructions;
• and
• one or more processors configured to execute the instructions to perform operations including;
• receiving a plurality of metric definitions, each of the plurality of metric definitions being usable to generate queries to obtain data for a respective metric to be monitored;
• storing the plurality of metric definitions in a metric definition database;
• and
• scheduling and performing a plurality of metric monitoring processes respectively associated with the plurality of metric definitions, such that each of the plurality of metric monitoring processes is periodically performed at a respective user-specified frequency, wherein each of the plurality of metric monitoring processes includes:
• retrieving the respective metric definition from the metric definition database;
• generating a database query based on the respective metric definition, the database query including one or more executable database statements defined by the respective metric definition;
• executing the database query to obtain query result data, the query result data being data for the respective metric;
• and
• storing the query result data.

A computer system for monitoring metrics, the computer 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 metric definition usable to generate queries to obtain data for a metric to be monitored, the metric being a measure or evaluation of events described by data recorded in a data warehouse;
• 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 including:
• 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 being based on the data recorded in the data warehouse;
• and
• storing the query result data as part of collected metric data associated with the metric;
• and
• executing a web service enabling the user device and other user devices to retrieve the collected metric data.