Jason A Frantz

US Patent:

8554726, Oct 8, 2013

Filed:

Jun 1, 2011

Appl. No.:

13/151203

Inventors:

Jason Frantz - San Francisco CA, US
Sergei Tsarev - San Francisco CA, US
Jim Gale - San Francisco CA, US
Scott Smith - San Francisco CA, US
Dan Adkins - Oakland CA, US

Assignee:

Clustrix, Inc. - San Francisco CA

International Classification:

G06F 17/30

US Classification:

707613, 707799, 707966

Abstract:

Systems and methods for reslicing data in a representation of a relational database are disclosed. In one embodiment, the database includes a representation including a first slice. The database system creates a plurality of new slice and to create a plurality of write queues. The database system copies units of data in the first slice to the new slices according to a distribution function. The distribution function determines, for each unit of data in the first slice, one of the new slices into which to copy the unit of data. The database system asynchronously writes one or more actions of a set of one or more asynchronous database transactions to the first slice when copying the data in the first slice to the new slices. The database asynchronously enqueues the one or more actions of the set of asynchronous database transactions in the write queues according to the distribution function.

US Patent:

20120310986, Dec 6, 2012

Filed:

Jun 1, 2011

Appl. No.:

13/151189

Inventors:

Jason Frantz - San Francisco CA, US
Sergei Tsarev - San Francisco CA, US
Jim Gale - San Francisco CA, US
Scott Smith - San Francisco CA, US

International Classification:

G06F 17/30

US Classification:

707792, 707E17045

Abstract:

Systems and methods for redistributing data in a relational database are disclosed. In one embodiment, the database includes a plurality of rows of data distributed across a plurality of slices of a table in the database. The database system is configured to distribute the rows of data across the slices according to a first function based on one or more columns of the database. The database system monitors at least one database statistic indicative of variation in a distribution of the rows of data across the slices and detects a redistribution condition based on the at least one monitored database statistic. The database system is further configured to respond to the detected redistribution condition by redistributing the rows of data across the slices according to a second function based on a different number of columns than the first function.

US Patent:

20220269690, Aug 25, 2022

Filed:

Mar 3, 2022

Appl. No.:

17/685542

Inventors:

- SAN FRANCISCO CA, US
JASON D. FRANTZ - SAN FRANCISCO CA, US
DONALD HUANG - SAN FRANCISCO CA, US

International Classification:

G06F 16/25
G06F 16/2452

Abstract:

Compiling a database query including receiving, by a query compiler from a client computing system, a state specification of a graphical user interface comprising a worksheet, wherein the worksheet is a presentation of a data set from a data warehouse; converting, by the query compiler, the state specification into a database query including determining a first order of operations for elements within the state specification; and sending the database query to the data warehouse.

US Patent:

20210224288, Jul 22, 2021

Filed:

Jan 17, 2020

Appl. No.:

16/745729

Inventors:

- SAN FRANCISCO CA, US
JASON D. FRANTZ - SAN FRANCISCO CA, US
DONALD HUANG - SAN FRANCISCO CA, US

International Classification:

G06F 16/25
G06F 16/2452

Abstract:

Compiling a database query including receiving, by a query compiler from a client computing system, a state specification of a graphical user interface comprising a worksheet, wherein the worksheet is a presentation of a data set from a data warehouse; converting, by the query compiler, the state specification into a worksheet algebra including determining a first order of operations for elements within the state specification, wherein the worksheet algebra comprises the first order of operations over a nested table; converting, by the query compiler, the worksheet algebra into a database query; and sending the database query to the data warehouse.

US Patent:

20210112066, Apr 15, 2021

Filed:

Jul 20, 2020

Appl. No.:

16/933072

Inventors:

- San Francisco CA, US
JASON D. FRANTZ - SAN FRANCISCO CA, US
JAMES L. GALE - SAN FRANCISCO CA, US
DONALD HUANG - SAN FRANCISCO CA, US

International Classification:

H04L 29/06

Abstract:

Managing worksheet access including receiving a request from a first user account to access a worksheet shared from a second user account, wherein the worksheet comprises a worksheet architecture for at least one data set from a database; determining that the first user account is authorized to access the worksheet architecture of the worksheet; determining that the first user account is authorized to access the at least one data set presented by the worksheet; and granting the first user account access to the worksheet in response to determining that the first user account is authorized to access the worksheet architecture of the worksheet and determining that the first user account is authorized to access the at least one data set presented by the worksheet.

US Patent:

20200409947, Dec 31, 2020

Filed:

Jun 26, 2020

Appl. No.:

16/913058

Inventors:

- SAN FRANCISCO CA, US
JASON D. FRANTZ - SAN FRANCISCO CA, US

International Classification:

G06F 16/242
G06F 16/248
G06F 16/2457

Abstract:

Exposing parameters in referencing worksheets including receiving a request for a referencing worksheet linked from a data source worksheet, wherein the data source worksheet is a presentation of a data set from a database, and wherein the data source worksheet comprises a function utilizing an exposable parameter; generating the referencing worksheet from the data source worksheet, wherein the referencing worksheet exposes the exposable parameter without exposing the function utilizing the exposable parameter; and presenting the referencing worksheet with the exposable parameter without allowing access to the function utilizing the exposable parameter.

US Patent:

20200409980, Dec 31, 2020

Filed:

Jun 26, 2020

Appl. No.:

16/913199

Inventors:

- SAN FRANCISCO CA, US
JASON D. FRANTZ - SAN FRANCISCO CA, US

International Classification:

G06F 16/28
G06F 16/245
G06F 16/21
H04L 29/08

Abstract:

Sharing data across cloud-based data warehouses establishing a link between a first cloud-based data warehouse and a second cloud-based data warehouse, wherein the link facilitates access to data stored in the second cloud-based data warehouse via the first cloud-based data warehouse; receiving, by the first cloud-based data warehouse, a first query referencing first data stored in the second cloud-based data warehouse; accessing, by the first cloud-based data warehouse, from the second cloud-based data warehouse, the first data; and sending a response to the first query based on the accessed first data.

US Patent:

20200372210, Nov 26, 2020

Filed:

May 14, 2020

Appl. No.:

16/874447

Inventors:

- San Francisco CA, US
JASON D. FRANTZ - SAN FRANCISCO CA, US

International Classification:

G06F 40/18

Abstract:

Using lightweight references to present a worksheet including receiving, from a first user account, a request for a worksheet presenting a data set from a database, wherein the worksheet was generated by a second user account; determining that the request was not generated from the second user account; and in response to the determination that the request is not from the second user account, presenting the worksheet in a view mode, wherein permissions in the view mode prevent destructive edits to the worksheet and allow additive edits to the worksheet.