System for exploring data in a database
AssigneeDatabricks, Inc.
InventorsAli Ghodsi, Ion Stoica, Matei Zaharia
Life of this patent
Estimating the term…
Abstract
A system for exploring data in a database comprises a query parser, a parameter manager, a query submitter, and a result formatter. The query parser is to receive a base query and determine an input parameter from the base query. The parameter manager is to provide a first request for a value for the input parameter; receive the value for the input parameter; and provide a second request for the value for the input parameter. The query submitter is to determine a first query using the base query and the value for the input parameter; and provide an indication to execute the first query. The result formatter is to receive a result associated with the indication to execute the first query.
Claims12
A system for exploring data in a database, comprising:
- a processor;
- and
- a memory coupled with the processor, wherein the memory is configured to provide the processor with instructions which when executed cause the processor to:
- receive a base query;
- determine an input parameter from the base query;
- provide a first request for a value for the input parameter;
- receive the value for the input parameter;
- provide a second request for the value for the input parameter;
- determine a first query using the base query and the value for the input parameter, comprising to:
- determine that the value for the input parameter includes a wild card or an input substring to:
- in the event that the value for the input parameter includes the wild card:
- determine a first set of parameters based on the wild card, wherein the wild card is replaced with a first set of text strings;
- and
- determine a first set of queries based on the base query and the first set of parameters;
- and
- in the event that the value for the input parameter includes the input substring:
- determine a second set of parameters based on the input substring, wherein the input substring is replaced with a second set of text strings;
- and
- determine a second set of queries based on the base query and the second set of parameters;
- provide an indication to execute the first query;
- receive a result associated with the indication to execute the first query;
- and
- determine a formatted result for the result.
A method for exploring data in a database, comprising:
- receiving a base query;
- determining, using a processor, an input parameter from the base query;
- providing a first request for a value for the input parameter;
- receiving the value for the input parameter;
- providing a second request for the value for the input parameter;
- determining a first query using the base query and the value for the input parameter, comprising:
- determining that the value for the input parameter includes a wild card or an input substring to:
- in the event that the value for the input parameter includes the wild card:
- determining a first set of parameters based on the wild card, wherein the wild card is replaced with a first set of text strings;
- and
- determining a first set of queries based on the base query and the first set of parameters;
- and
- in the event that the value for the input parameter includes the input substring:
- determining a second set of parameters based on the input substring, wherein the input substring is replaced with a second set of text strings;
- and
- determining a second set of queries based on the base query and the second set of parameters;
- providing an indication to execute the first query;
- receiving a result associated with the indication to execute the first query;
- and
- determining a formatted result for the result.
A computer program product for exploring data in a database, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions for:
- receiving a base query;
- determining, using a processor, an input parameter from the base query;
- providing a first request for a value for the input parameter;
- receiving the value for the input parameter;
- providing a second request for the value for the input parameter;
- determining a first query using the base query and the value for the input parameter, comprising:
- determining that the value for the input parameter includes a wild card or an input substring to:
- in the event that the value for the input parameter includes the wild card:
- determining a first set of parameters based on the wild card, wherein the wild card is replaced with a first set of text strings;
- and
- determining a first set of queries based on the base query and the first set of parameters;
- and
- in the event that the value for the input parameter includes the input substring:
- determining a second set of parameters based on the input substring, wherein the input substring is replaced with a second set of text strings;
- and
- determining a second set of queries based on the base query and the second set of parameters;
- providing an indication to execute the first query;
- receiving a result associated with the indication to execute the first query;
- and
- determining a formatted result for the result.
Dependencies are inferred from the claim text.