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.
Claims15
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, wherein the value for the input parameter comprises an input substring, and wherein the determining of the first query comprises to:
- determine that the value for the input parameter includes the input substring;
- determine a set of parameters based on the input substring, the set of parameters including the input substring, the input substring being followed by each of a set of text string, the set of text strings comprises all possible text strings, all possible text strings up to a certain length, all legal text strings, all possible strings matching database entries, or any combination thereof;
- and
- determine a set of queries based on the base query and the set of parameters, the set of queries including the first query;
- provide an indication to execute the first query;
- and
- receive a result associated with the indication to execute the first query.
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;
- and
- 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, wherein the value for the input parameter comprises an input substring, and wherein the determining of the first query comprises:
- determining that the value for the input parameter includes the input substring;
- determining a set of parameters based on the input substring, the set of parameters including the input substring, the input substring being followed by each of a set of text string, the set of text strings comprises all possible text strings, all possible text strings up to a certain length, all legal text strings, all possible strings matching database entries, or any combination thereof;
- and
- determining a set of queries based on the base query and the set of parameters, the set of queries including the first query;
- providing an indication to execute the first query;
- and
- receiving a result associated with the indication to execute the first query.
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, wherein the value for the input parameter comprises an input substring, and wherein the determining of the first query comprises:
- determining that the value for the input parameter includes the input substring;
- determining a set of parameters based on the input substring, the set of parameters including the input substring, the input substring being followed by each of a set of text string, the set of text strings comprises all possible text strings, all possible text strings up to a certain length, all legal text strings, all possible strings matching database entries, or any combination thereof;
- and
- determining a set of queries based on the base query and the set of parameters, the set of queries including the first query;
- providing an indication to execute the first query;
- and
- receiving a result associated with the indication to execute the first query.
Dependencies are inferred from the claim text.