System for exploring data in a database

Patent metadata

Field	Value
Publication number	US-2018046668-A1
Application number	US-201715675619-A
Country	US
Kind code	A1
Filing date	Aug 11, 2017
Priority date	Oct 29, 2014
Publication date	Feb 15, 2018
Grant date	—

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.

First claim

What is claimed is:

1 . (canceled)

2 . 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;
provide an indication to execute the first query; and
receive a result associated with the indication to execute the first query.

3 . The system of claim 2 , wherein the indication to execute the first query is provided to a data system.

4 . The system of claim 2 , wherein the receiving of the result comprises to:
determine a formatted result for the result.

5 . The system of claim 4 , wherein the receiving of the result comprises to:
provide the formatted result.

6 . The system of claim 5 , wherein the receiving of the result comprises to:
provide the formatted result to a user system.

7 . The system of claim 2 , wherein the input parameter is one of a plurality of input parameters.

8 . The system of claim 2 , wherein the first request for a value for the input parameter is provided to a user.

9 . The system of claim 2 , where the value for the input parameter comprises an input substring.

10 . The system of claim 9 , wherein the first query comprises a set of queries based at least in part on the input substring.

11 . The system of claim 2 , where the value for the input parameter comprises a wild card.

12 . The system of claim 11 , wherein the first query comprises a set of queries based at least in part on the wild card.

13 . The system of claim 2 , wherein the processor further comprises to:
receive another value for the input parameter in response to the second request prior to the receiving of the result associated with the indication to execute the first query.

14 . The system of claim 13 , wherein the determining of the first query comprises to:
provide an indication to stop executing the first query.

15 . The system of claim 14 , wherein the determining of the first query comprises to:
provide an indication to execute another query.

16 . The system of claim 2 , wherein the input parameter has an associated default value.

17 . 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 providing an indication to execute the first query; and receiving a result associated with the indication to execute the first query.

18 . 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; providing an indication to execute the first query; and receiving a result associated with the indication to execute the first query.

Assignees

• Databricks Inc

Inventors

• Ghodsi Ali
• Stoica Ion
• Zaharia Matei

Classifications

• G06F17/30424 Primary

  Physics · mapped topic

• G06F16/245 Primary

  Query processing · CPC title

• G06F16/242

  Query formulation · CPC title