IP Library Granted Patent US 9,760,602
Granted Patent B1
US 9,760,602 · App. 14/621,950 · Granted Sep 12, 2017

System for exploring data in a database

Inventors: Ali Ghodsi (Berkeley, CA); Ion Stoica (Piedmont, CA); Matei Zaharia (Berkeley, CA)
Assignee: Databricks Inc.
G06F17/30424
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,760,602
App. No.
14/621,950
Granted
Sep 12, 2017
Kind
B1
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.

Claims (62)

1. 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.

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

3. The system of claim 1 , wherein the processor is further configured to provide the formatted result.

4. The system of claim 3 , wherein the processor is further configured to provide the formatted result to a user system.

5. The system of claim 1 , wherein the input parameter is one of a plurality of input parameters.

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

7. The system of claim 1 , wherein the processor is further configured 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.

8. The system of claim 7 , wherein the processor is further configured to provide an indication to stop executing the first query.

9. The system of claim 8 , wherein the processor is further configured to provide an indication to execute another query.

10. The system of claim 1 , wherein the input parameter has an associated default value.

11. 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.

12. 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.

Assignments (3)
CORRECTIVE ASSIGNMENT TO CORRECT THE ASSIGNEE NAME FROM DATABRICKS INC. TO DATABRICKS, INC. AND ASSIGNEE STREET ADDRESS FROM 160 SPEAR STREET, SUITE 1300 TO 160 SPEAR STREET, 15TH FLOOR PREVIOUSLY RECORDED ON REEL 35480 FRAME 607. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT. Recorded Feb 21, 2025
From: GHODSI, ALI; STOICA, ION; ZAHARIA, MATEI
To: DATABRICKS, INC.
Reel/Frame 070291/0524 →
SECURITY INTEREST Recorded Jan 6, 2025
From: DATABRICKS, INC.
To: JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT
Reel/Frame 069825/0419 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Apr 23, 2015
From: GHODSI, ALI; STOICA, ION; ZAHARIA, MATEI
To: DATABRICKS INC.
Reel/Frame 035480/0607 →
Continuity (1)
Provisional Application 62072105 · Oct 29, 2014