# US 8,280,869 B1 · Sharing intermediate results

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

- Number: US 8,280,869 B1
- Document ID: US8280869B1
- Status: Granted
- Kind: B1
- Application number: 12/500,680
- Filed: 2009-07-10
- Granted: 2012-10-02
- Earliest claimed: 2009-07-10
- Assignees: Teradata US, Inc.
- Inventors: Louis Martin Burger; Thomas Patrick Julien; Douglas P. Brown; Jeffrey S. Shelton
- Web page: https://patentgrep.com/patent/US8280869B1

## CPC

- G06F 16/24561: {Intermediate data storage techniques for performance improvement}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A temporary computer-stored first-unit intermediate result is generated while executing a first unit of work on a computer-based database management system. The first-unit intermediate result has properties. It is determined that the properties of the first-unit intermediate result are similar to properties of a second-unit intermediate result to be generated for a second unit of work when the second unit of work is executed on the computer-based database management system. In response, the first-unit intermediate result is saved for use in executing the second unit of work.

## Claims

### Claim 1

A computer-based method, comprising:
generating a temporary computer-stored first-unit intermediate result while executing a first unit of work on a computer-based database management system, the first-unit intermediate result having properties;
determining that the properties of the first-unit intermediate result are similar to properties of a second-unit intermediate result to be generated for a second unit of work when the second unit of work is executed on the computer-based database management system, and, in response:
saving the first-unit intermediate result for use in executing the second unit of work;
delaying execution of the second unit of work;
placing a definition of the second-unit intermediate result on a needs list;
placing a definition of the first-unit intermediate result on a saved list; and
mapping in an assignments list the definition of the second-unit intermediate result in the needs list to the definition of the first-unit intermediate result in the saved list;
determining that a definition for a no-longer-useful intermediate result in the saved list is not mapped to any definitions of intermediate results on the needs list, and, in response:
deleting the definition for the no-longer-useful intermediate result from the saved list; and
deleting the no-longer-useful intermediate result;
the first unit of work being part of a first request; and
the second unit of work being part of a second request different from the first request.

### Claim 2 (depends on 1)

The computer-based method of claim 1 wherein the first-unit intermediate result is an intermediate result selected from the group consisting of a definition of a materialized view and a spool file.

### Claim 3 (depends on 1)

The computer-based method of claim 1 wherein determining that the properties of the first-unit intermediate result are similar to the properties of the second-unit intermediate result comprises:
defining properties of a spool file that will be required when executing the second unit of work; and
finding that the properties of the temporary computer-stored intermediate result are identical to the properties of the spool file.

### Claim 4 (depends on 1)

The computer-based method of claim 1 further comprising:
determining that intermediate-result-dropping conditions have been met with respect to the first-unit intermediate result and, in response, deleting the first-unit intermediate result.

### Claim 5 (depends on 1)

The computer-based method of claim 1 further comprising:
transferring ownership of the first-unit intermediate result from the first unit of work to the second unit of work.

### Claim 6

A database system comprising:
one or more nodes;
a plurality of CPUs, each of the one or more nodes providing access to one or more CPUs;
a plurality of virtual processes, each of the one or more CPUs providing access to one or more virtual processes;
each virtual process configured to manage data, including rows from the set of database table rows, stored in one of a plurality of data-storage facilities;
a process to:
generate a temporary computer-stored first-unit intermediate result while executing a first unit of work on a computer-based database management system, the first-unit intermediate result having properties;
determine that the properties of the first-unit intermediate result are similar to properties of a second-unit intermediate result to be generated for a second unit of work when the second unit of work is executed on the computer-based database management system, and, in response:
save the first-unit intermediate result for use in executing the second unit of work;
delay execution of the second unit of work;
place a definition of the second-unit intermediate result on a needs list;
place a definition of the first-unit intermediate result on a saved list;
map in an assignments list the definition of the second-unit intermediate result in the needs list to the definition of the first-unit intermediate result in the saved list;
determine that a definition for a no-longer-useful intermediate result in the saved list is not mapped to any definitions of intermediate results on the needs list, and, in response:
delete the definition for the no-longer-useful intermediate result from the saved list; and
delete the no-longer-useful intermediate result;
the first unit of work being part of a first request; and
the second unit of work being part of a second request different from the first request.

### Claim 7 (depends on 6)

The database system of claim 6 wherein the first-unit intermediate result is an intermediate result selected from the group consisting of a definition of a materialized view and a spool file.

### Claim 8 (depends on 6)

The database system of claim 6 wherein to determine that the properties of the first-unit intermediate result are similar to the properties of the second-unit intermediate result, the process:
defines properties of a spool file that will be required when executing the second unit of work; and
finds that the properties of the temporary computer-stored intermediate result are identical to the properties of the spool file.

### Claim 9 (depends on 6)

The database system of claim 6 wherein the process further:
determines that intermediate-result-dropping conditions have been met with respect to the first-unit intermediate result and, in response, deletes the first-unit intermediate result.

### Claim 10 (depends on 6)

The database system of claim 6 wherein the process further:
transfers ownership of the first-unit intermediate result from the first unit of work to the second unit of work.

### Claim 11

A computer program, stored in a non-transitory computer readable storage medium, the program comprising executable instructions that cause a computer to:
generate a temporary computer-stored first-unit intermediate result while executing a first unit of work on a computer-based database management system, the first-unit intermediate result having properties;
determine that the properties of the first-unit intermediate result are similar to properties of a second-unit intermediate result to be generated for a second unit of work when the second unit of work is executed on the computer-based database management system, and, in response:
save the first-unit intermediate result for use in executing the second unit of work;
delay execution of the second unit of work;
place a definition of the second-unit intermediate result on a needs list;
place a definition of the first-unit intermediate result on a saved list;
map in an assignments list the definition of the second-unit intermediate result in the needs list to the definition of the first-unit intermediate result in the saved list;
determine that a definition for a no-longer-useful intermediate result in the saved list is not mapped to any definitions of intermediate results on the needs list, and, in response:
delete the definition for the no-longer-useful intermediate result from the saved list; and
delete the no-longer-useful intermediate result;
the first unit of work being part of a first request; and
the second unit of work being part of a second request different from the first request.

### Claim 12 (depends on 11)

The computer program of claim 11 wherein the first-unit intermediate result is an intermediate result selected from the group consisting of a definition of a materialized view and a spool file.

### Claim 13 (depends on 11)

The computer program of claim 11 wherein when determining that the properties of the first-unit intermediate result are similar to the properties of the second-unit intermediate result, the computer:
defines properties of a spool file that will be required when executing the second unit of work; and
finds that the properties of the temporary computer-stored intermediate result are identical to the properties of the spool file.

### Claim 14 (depends on 11)

The computer program of claim 11 wherein the computer program further includes executable instructions that cause the computer to:
determine that intermediate-result-dropping conditions have been met with respect to the first-unit intermediate result and, in response, delete the first-unit intermediate result.

### Claim 15 (depends on 11)

The computer program of claim 11 wherein the computer program further includes executable instructions that cause the computer to:
transfer ownership of the first-unit intermediate result from the first unit of work to the second unit of work.
