IP Library Granted Patent US 10,095,735
Granted Patent B2
US 10,095,735 · App. 15/675,619 · Granted Oct 9, 2018

System for exploring data in a database

Inventors: Ali Ghodsi (Berkeley, CA); Ion Stoica (Piedmont, CA); Matei Zaharia (Boston, MA)
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 10,095,735
App. No.
15/675,619
Granted
Oct 9, 2018
Kind
B2
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 (56)

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

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 receiving of the result comprises to:

determine a formatted result for the result.

4. The system of claim 3 , wherein the receiving of the result comprises to:

provide the formatted result.

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

provide the formatted result to a user system.

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

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

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

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

10. The system of claim 1 , 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.

11. The system of claim 10 , wherein the determining of the first query comprises to:

provide an indication to stop executing the first query.

12. The system of claim 11 , wherein the determining of the first query comprises to:

provide an indication to execute another query.

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

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

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

Assignments (2)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 26, 2025
From: GHODSI, ALI; STOICA, ION; ZAHARIA, MATEI
To: DATABRICKS, INC.
Reel/Frame 070338/0879 →
SECURITY INTEREST Recorded Jan 6, 2025
From: DATABRICKS, INC.
To: JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT
Reel/Frame 069825/0419 →
Continuity (3)
Continuation 14621950 · Feb 13, 2015
Provisional Application 62072105 · Oct 29, 2014
Related Publication 20180046668A1 · Feb 15, 2018
Cited By (2)
US 12,292,870 US 12,608,366