# US 2021/0342324 A1 · Determining additions, deletions and updates to database tables

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

- Number: US 2021/0342324 A1
- Document ID: US20210342324A1
- Status: Published application
- Kind: A1
- Application number: 16/863,597
- Filed: 2020-04-30
- Published: 2021-11-04
- Earliest claimed: 2020-04-30
- Assignees: International Business Machines Corporation
- Applicants: International Business Machines Corporation
- Inventors: Donnie Allen Smith, JR.; Kenneth L. Greenlee; Venkatapathi Rao Kaka; Sahil Arora; Mukesh Kumar
- Web page: https://patentgrep.com/patent/US20210342324A1

## CPC

- G06F 16/219: {Managing data history or versioning (querying versioned data G06F16/2474; querying temporal data G06F16/2477)}
- G06F 16/2457: with adaptation to user needs
- G06F 16/17: Details of further file system functions
- G06F 16/2477: {Temporal data queries}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method, system and computer program product for determining changes to database tables. In an embodiment, the method comprises loading a first group of records in a first time period in a database; loading a second group of records in a second time period in the database; selecting one or more of the records in the database; and for each of the selected records, determining whether it was loaded into the database during the first time period or the second time period, and providing the each record with a specified designation based on the time period during which the each record was loaded into the database. In an embodiment, identified times when the records were loaded in the database are used to determine the time period during which the each record was loaded in the database.

## Claims

### Claim 1

A computer-implemented method comprising:
loading a first group of records in a first time period in a database;
loading a second group of records in a second time period in the database;
selecting one or more of the records in the database; and
for each of the selected records, determining whether it was loaded into the database during the first time period or the second time period, and providing the each record with a specified designation based on the time period during which the each record was loaded into the database.

### Claim 2 (depends on 1)

The method according to claim 1, wherein:
the loading a first group of records in the database includes for each record of the first group of records, identifying a time when the each record was loaded in the database;
the loading a second group of records in the database includes for each record of the second group of records, identifying a time when the each record was loaded in the database; and
the determining whether the each selected record was loaded into the database during the first time period or the second time period includes using the identified time when the each record was loaded in the database to determine whether the each selected record was loaded into the database during the first time period or the second time period.

### Claim 3 (depends on 2)

The method according to claim 2, wherein:
each of the first and second time periods has a start time and an end time;
the loading a first group of records in the database includes storing the start time and the end time of the first time period in a metadata table; and
the loading a second group of records in the database includes storing the start time and the end time of the second time period in the metadata table.

### Claim 4 (depends on 3)

The method according to claim 3, wherein:
the selecting one or more of the records in the database includes selecting one or more records of the second group of records;
the using the identified time when the each record was loaded in the database to determine whether the each record was loaded into the database during the first time period or the second time period includes for each of the selected records of the second group of records, comparing the time when said each record was loaded in the database to the start and end times of the second time period; and
the providing the each record with a specified designation based on the time period during which the each record was loaded into the database includes providing the each of the selected records of the second group of records with one of a specified group of designations based on the comparison.

### Claim 5 (depends on 4)

The method according to claim 4, wherein:
the selecting one or more of the records in the database includes selecting one or more records of the first group of records;
the using the identified time when the each record was loaded in the database to determine whether the each record was loaded into the database during the first time period or the second time period includes for each of the selected records of the first group of records, comparing the time when said each record was loaded in the database to the start and end times of the first time period; and
the providing the each record with a specified designation based on the time period during which the each record was loaded into the database includes providing the each of the selected records of the first group of records with one of the specified group of designations based on the comparison.

### Claim 6 (depends on 1)

The method according to claim 1, wherein:
each record of the first group of records has an associated identification; and
each record of the second group of records has an associated identification.

### Claim 7 (depends on 6)

The method according to claim 6, wherein the providing the each record with a specified designation based on the time periods during which the each record was loaded in the database includes providing the each record with a specified designation based on the time period during which the each record was loaded into the database and the associated identification of the each record.

### Claim 8 (depends on 7)

The method according to claim 7, wherein the providing the each record with a specified designation based on the time period during which the each record was loaded into the database includes, when one record of the second group of records has a same associated identification as one record of the first group of records, designating said one record of the first group of records as deleted.

### Claim 9 (depends on 8)

The method according to claim 8, wherein the providing the each record with a specified designation based on the time period during which the each record was loaded into the database includes, for each record of the second group of records that has an associated identification different than the associated identifiers of the first group of records, designating said each record of the second group of records as an addition.

### Claim 10 (depends on 8)

The method according to claim 8, wherein the providing the each record with a specified designation based on the time period during which the each record was loaded into the database includes, when one record of the second group of records has a same associated identification as one record of the first group of records and given conditions are met, designating said one record of the second group of records as a version of the one record of the first group of records.

### Claim 11

A system comprising:
one or more processors; and
a memory coupled to the one or more processors;
said one or more processors configured for:
loading a first group of records in a first time period in a database;
loading a second group of records in a second time period in the database;
selecting one or more of the records in the database; and
for each of the selected records, determining whether it was loaded into the database during the first time period or the second time period, and providing the each record with a specified designation based on the time period during which the each record was loaded into the database.

### Claim 12 (depends on 11)

The system according to claim 11, wherein:
the loading a first group of records in the database includes for each record of the first group of records, identifying a time when the each record was loaded in the database;
the loading a second group of records in the database includes for each record of the second group of records, identifying a time when the each record was loaded in the database; and
the determining whether it was loaded into the database during the first time period or the second time period includes using the identified time when the each record was loaded in the database to determine whether the each selected record was loaded into the database during the first time period or the second time period.

### Claim 13 (depends on 12)

The system according to claim 12, wherein:
each of the first and second time periods has a start time and an end time;
the loading a first group of records in the database includes storing the start time and the end time of the first time period in a metadata table; and
the loading a second group of records in the database includes storing the start time and the end time of the second time period in the metadata table.

### Claim 14 (depends on 11)

The system according to claim 11, wherein:
each record of the first group of records has an associated identification; and
each record of the second group of records has an associated identification.

### Claim 15 (depends on 14)

The system according to claim 14, wherein the providing the each record with a specified designation based on the time period during which the each record was loaded in the database includes providing the each record with a specified designation based on the time period during which the each record was loaded in the database and the associated identification of the each record.

### Claim 16

A computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processor to cause the processor to:
load a first group of records in a first time period in a database;
load a second group of records in a second time period in the database;
select one or more of the records in the database; and
for each of the selected records, determine whether it was loaded into the database during the first time period or the second time period, and provide the each record with a specified designation based on the time period during which the each record was loaded into the database.

### Claim 17 (depends on 16)

The computer program product according to claim 16, wherein:
the loading a first group of records in the database includes for each record of the first group of records, identifying a time when the each record was loaded in the database;
the loading a second group of records in the database includes for each record of the second group of records, identifying a time when the each record was loaded in the database; and
the determining whether the each selected record was loaded into the database during the first time period or the second time period includes using the identified time when the each record was loaded in the database to determine whether the each selected record was loaded into the database during the first time period or the second time period.

### Claim 18 (depends on 17)

The computer program product according to claim 17, wherein:
each of the first and second time periods has a start time and an end time;
the loading a first group of records in the database includes storing the start time and the end time of the first time period in a metadata table; and
the loading a second group of records in the database includes storing the start time and the end time of the second time period in the metadata table.

### Claim 19 (depends on 16)

The computer program product according to claim 16, wherein:
each record of the first group of records has an associated identification; and
each record of the second group of records has an associated identification.

### Claim 20 (depends on 19)

The computer program product according to claim 19, wherein the providing the each record with a specified designation based on the time period during which the each record was loaded in the database includes providing the each record with a specified designation based on the time period during which the each record was loaded in the database and the associated identification of the each record.
