Pattern-based query result enhancement

A computer-implemented method comprising:

• receiving a first query, the first query comprising at least one of one or more dimensions and one or more measures of data of a data store;
• in response to reception of the first query, identifying whether a first stored query set includes a query matching the first query, the first stored query set comprising a plurality of queries;
• in response to identification of the first stored query set, determining a first plurality of query result sets, each of the first plurality of query result sets comprising a respective:
• result set ef based on an execution of the first query, an execution of each query of the plurality of queries of the first stored query set, and metadata defining the first query and the plurality of queries of the first stored query set;
• in response to reception of the first query, identifying whether a first stored set of query patterns includes a query pattern matching a pattern of the at least one of one or more dimensions and one or more measures of the first query;
• in response to identification of the first stored set of query patterns, determining a second plurality of queries based on the identified stored set of query patterns and on the one or more dimensions and one or more measures of the first query;
• determining a second plurality of query result sets based on an execution of the second plurality of queries and metadata defining measures and dimensions of the second plurality of queries, each of the second plurality of query result sets comprising a result set of each of the identified stored set of query patterns where measures and dimensions of the identified stored set of query patterns are replaced with the at least one of one or more dimensions and one or more measures of the first query;
• and
• presenting a visualization of each of the determined first plurality of query result sets and second plurality of query result sets.

A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:

• receive a first query, the first query comprising at least one of one or more dimensions and one or more measures of data of a data store;
• in response to reception of the first query, identify whether a first stored query set includes a query matching the first query, the first stored query set comprising a plurality of queries;
• in response to identification of the first stored query set, determine a first plurality of query result sets, each of the first plurality of query result sets comprising a respective:
• result set based on an execution of the first query, an execution of each query of the plurality of queries of the first stored query set, and metadata defining the first query and the plurality of queries of the first stored query set;
• in response to reception of the first query, identify whether a first stored set of query patterns includes a query pattern matching a pattern of the at least one of one or more dimensions and one or more measures of the first query;
• in response to identification of the first stored set of query patterns, determine a second plurality of queries based on the identified stored set of query patterns and on the one or more dimensions and one or more measures of the first query;
• determine a second plurality of query result sets based on an execution of the second plurality of queries and metadata defining measures and dimensions of the second plurality of queries, each of the second plurality of query result sets comprising a result set of each of the identified stored set of query patterns where measures and dimensions of the identified stored set of query patterns are replaced with the at least one of one or more dimensions and one or more measures of the first query;
• and
• present a visualization of each of the determined first plurality of query result sets and second plurality of query result sets.