# US 2020/0349156 A1 · Dynamically normalizing intervals in a table

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2020/0349156 A1
- Document ID: US20200349156A1
- Status: Published application
- Kind: A1
- Application number: 16/862,869
- Filed: 2020-04-30
- Published: 2020-11-05
- Earliest claimed: 2019-05-01
- Assignees: Sigma Computing, Inc.
- Applicants: Sigma Computing, Inc.
- Inventors: JASON D. FRANTZ; MAX H. SEIDEN; JAMES L. GALE; JOSEPH BATES
- Web page: https://patentgrep.com/patent/US20200349156A1

## CPC

- G06F 16/2465: {Query processing support for facilitating data mining operations in structured databases}
- G06F 40/18: of spreadsheets (form-filling G06F40/174)
- G06F 16/211: {Schema design and management}
- G06F 16/2282: {Tablespace storage structures; Management thereof}
- G06F 16/2428: {Query predicate definition using graphical user interfaces, including menus and forms (G06F16/2423 takes precedence)}
- G06F 16/2445: {Data retrieval commands; View definitions}
- G06F 16/2456: {Join operations}
- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Dynamically normalizing intervals in a table including receiving, from a client computing system, a request to normalize intervals for a data set on a cloud-based data warehouse, wherein the request comprises a reference to the data set and a data range; generating, on the cloud-based data warehouse, an interval table using the data range; joining, into a joined table on the cloud-based data warehouse, the interval table and the data set; receiving the joined table from the cloud-based data warehouse; and presenting, via a graphical user interface on the client computing system, the joined table as a worksheet.

## Claims

### Claim 1

A method of dynamically normalizing intervals in a table, the method comprising:
receiving, from a client computing system, a request to normalize intervals for a data set on a cloud-based data warehouse, wherein the request comprises a reference to the data set and a data range;
generating, on the cloud-based data warehouse, an interval table using the data range;
joining, into a joined table on the cloud-based data warehouse, the interval table and the data set;
receiving the joined table from the cloud-based data warehouse; and
presenting, via a graphical user interface on the client computing system, the joined table as a worksheet.

### Claim 2 (depends on 1)

The method of claim 1, wherein generating, on the cloud-based data warehouse, the interval table using the data range comprises storing the interval table in a schema storage location on the cloud-based data warehouse, wherein the data set is external to the schema storage location.

### Claim 3 (depends on 1)

The method of claim 1, wherein the generating, on the cloud-based data warehouse, the interval table using the data range comprises dynamically generating the interval table using a query statement.

### Claim 4 (depends on 1)

The method of claim 1, wherein generating, on the cloud-based data warehouse, the interval table using the data range comprises generating rows of integers and converting the integers based on the data range.

### Claim 5 (depends on 1)

The method of claim 1, wherein generating, on the cloud-based data warehouse, the interval table using the data range and joining, into the joined table on the cloud-based data warehouse, the interval table and the data set comprise:
composing a database query to generate, on the cloud-based data warehouse, the interval table using the data range and join, into the joined table on the cloud-based data warehouse, the interval table and the data set; and
sending the database query to the cloud-based data warehouse.

### Claim 6 (depends on 1)

The method of claim 1, wherein the data range comprises a minimum value, a maximum value, and an interval.

### Claim 7 (depends on 1)

The method of claim 1, wherein the joined table comprises at least one row that is not included in the data set.

### Claim 8

An apparatus for dynamically normalizing intervals in a table, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of: receiving, from a client computing system, a request to normalize intervals for a data set on a cloud-based data warehouse, wherein the request comprises a reference to the data set and a data range;
generating, on the cloud-based data warehouse, an interval table using the data range;
joining, into a joined table on the cloud-based data warehouse, the interval table and the data set;
receiving the joined table from the cloud-based data warehouse; and
presenting, via a graphical user interface on the client computing system, the joined table as a worksheet.

### Claim 9 (depends on 8)

The apparatus of claim 8, wherein generating, on the cloud-based data warehouse, the interval table using the data range comprises storing the interval table in a schema storage location on the cloud-based data warehouse, wherein the data set is external to the schema storage location.

### Claim 10 (depends on 8)

The apparatus of claim 8, wherein the generating, on the cloud-based data warehouse, the interval table using the data range comprises dynamically generating the interval table using a query statement.

### Claim 11 (depends on 8)

The apparatus of claim 8, wherein generating, on the cloud-based data warehouse, the interval table using the data range comprises generating rows of integers and converting the integers based on the data range.

### Claim 12 (depends on 8)

The apparatus of claim 8, wherein generating, on the cloud-based data warehouse, the interval table using the data range and joining, into the joined table on the cloud-based data warehouse, the interval table and the data set comprise:
composing a database query to generate, on the cloud-based data warehouse, the interval table using the data range and join, into the joined table on the cloud-based data warehouse, the interval table and the data set; and
sending the database query to the cloud-based data warehouse.

### Claim 13 (depends on 8)

The apparatus of claim 8, wherein the data range comprises a minimum value, a maximum value, and an interval.

### Claim 14 (depends on 8)

The apparatus of claim 8, wherein the joined table comprises at least one row that is not included in the data set.

### Claim 15

A computer program product for dynamically normalizing intervals in a table, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving, from a client computing system, a request to normalize intervals for a data set on a cloud-based data warehouse, wherein the request comprises a reference to the data set and a data range;
generating, on the cloud-based data warehouse, an interval table using the data range;
joining, into a joined table on the cloud-based data warehouse, the interval table and the data set;
receiving the joined table from the cloud-based data warehouse; and
presenting, via a graphical user interface on the client computing system, the joined table as a worksheet.

### Claim 16 (depends on 15)

The computer program product of claim 15, wherein generating, on the cloud-based data warehouse, the interval table using the data range comprises storing the interval table in a schema storage location on the cloud-based data warehouse, wherein the data set is external to the schema storage location.

### Claim 17 (depends on 15)

The computer program product of claim 15, wherein the generating, on the cloud-based data warehouse, the interval table using the data range comprises dynamically generating the interval table using a query statement.

### Claim 18 (depends on 15)

The computer program product of claim 15, wherein generating, on the cloud-based data warehouse, the interval table using the data range comprises generating rows of integers and converting the integers based on the data range.

### Claim 19 (depends on 15)

The computer program product of claim 15, wherein generating, on the cloud-based data warehouse, the interval table using the data range and joining, into the joined table on the cloud-based data warehouse, the interval table and the data set comprise:
composing a database query to generate, on the cloud-based data warehouse, the interval table using the data range and join, into the joined table on the cloud-based data warehouse, the interval table and the data set; and
sending the database query to the cloud-based data warehouse.

### Claim 20 (depends on 15)

The computer program product of claim 15, wherein the data range comprises a minimum value, a maximum value, and an interval.
