US 11,989,183 B2
Linking data sets
Jason D. Frantz, San Francisco, CA (US); Robert C. Woollen, San Rafael, CA (US); Massimo D. Siboldi, San Francisco, CA (US); and Max H. Seiden, San Francisco, CA (US)
Assigned to SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed by SIGMA COMPUTING, INC., San Francisco, CA (US)
Filed on Jul. 9, 2020, as Appl. No. 16/925,137.
Claims priority of provisional application 62/912,878, filed on Oct. 9, 2019.
Prior Publication US 2021/0109933 A1, Apr. 15, 2021
Int. Cl. G06F 16/24 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24553 (2019.01) [G06F 16/221 (2019.01)] 18 Claims
OG exemplary drawing
 
1. A method of linking data sets, the method comprising:
receiving, from a client application by a linking module, an indication of a relationship between a first column of a first data set and a second column of a second data set, wherein the client application is on a client computing system separate from a data access computing system hosting the linking module, and wherein the indication further indicates one or more columns of the second data set to be included in a JOIN with the first data set and, based on if the first column of the first data set is either hidden or not selected for presentation, an associated column such that selection of the associated column serves to select the first column;
storing the indication in metadata associated with one of: the first data set and the second data set;
receiving, from the client application by the linking module a selection of the first column of the first data set related to the second column of the second data set;
in response to the selection, generating, by the linking module, a query based on a relationship between the first column of the first data set and the second column of the second data set, wherein the query targets a database on a cloud-based data warehouse separate from the data access computing system and the client computing system; and presenting, on the client application on the client computing system by the linking module, a third data set based on a response to the query from the cloud-based data warehouse, wherein the third data set comprises the first data set and at least a portion of the second data set.