# US 11,907,262 B2 · System and method for data pruning via dynamic partition management

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

- Number: US 11,907,262 B2
- Document ID: US11907262B2
- Status: Granted
- Kind: B2
- Application number: 17/937,454
- Filed: 2022-10-02
- Published: 2023-04-20
- Granted: 2024-02-20
- Earliest claimed: 2021-10-20
- Assignees: BNSF Railway Company
- Applicants: BNSF Railway Company
- Inventors: Robert McKinley Collins, Jr.
- Web page: https://patentgrep.com/patent/US11907262B2

## CPC

- G06F 16/21: Design, administration or maintenance of databases
- G06F 16/278: {Data partitioning, e.g. horizontal or vertical partitioning}
- G06F 16/2282: {Tablespace storage structures; Management thereof}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A system and method for managing data lifecycles that can provide an adaptable data management system configured to optimize the lifecycles of data and the reliability of databases. The system can provide data management systems with the ability to attach, detach, and drop segments of data based on key partitions of the data objects to optimize database utilization. By including the key partitions to the data objects, the database including the data objects can now perform data management operations based on the key partitions. The system, based on the key partitions, can identify a location of the data object to attach row entries, detach row entries from the existing tables, and delete the detached row entries from the database altogether. The system can operate on any relational database management system.

## Claims

### Claim 1

A detach partition system adapted to detach data related to a railroad system, comprising:
a memory including a database with a plurality of partitions, tables, clusters, or jobs;
a configuration file including operations related to database management; and
a processor operably coupled to the memory and capable of executing machine-readable instructions to perform program steps, the program steps comprising:
read and parse operations from a configuration file, wherein the read and parsed operations include an operation to detach data from a data object;
determine whether required file systems are accessible;
determine the number of partitions, tables, and jobs scheduled to be run and created;
generate data structures based on key pattern groups defined for each partition, wherein the key pattern groups are used to identify which group each partition key belongs, wherein generating the data structures based on the key pattern groups includes generating the data structures when each key pattern group in the key pattern groups is determined to be valid and foreclosing generating the data structures when at least one key pattern group in the key pattern groups is determined to be invalid;
determine a table is partitioned when the table is organized according to a predetermined structure, wherein the predetermined structure includes columns of the table being organized based on an event code, an event type, a message, and a row identifier;
disable a table object prior to executing a detach command;
generate a detach data library; and
execute the detach library by generate executable statements to detach partitions from a database.

### Claim 2 (depends on 1)

The system of claim 1, wherein after the detach command is executed, the table objects are enabled.

### Claim 3 (depends on 1)

The system of claim 1, further comprising a user interface configured to identify data for detaching data from the database.

### Claim 4 (depends on 1)

The system of claim 1, wherein the program steps further comprise generating a file including instructions to properly detach a partition and restore the table objects to the normal state.

### Claim 5 (depends on 1)

The system of claim 1, wherein when the data partitions are to be removed, the instructions identify specific data structures using identifications.

### Claim 6 (depends on 1)

The system of claim 1, wherein the key pattern groups include a member value indicating whether the data being added belongs to a particular group, a date indicating the date range to include the data, and a group indicating the particular group for detaching the data.

### Claim 7 (depends on 1)

The system of claim 1, wherein the detach data library includes data to detach.

### Claim 8 (depends on 1)

The system of claim 1, wherein the table is partitioned when columns of the table are organized based on an event code, an event type, a message, or a row identifier.

### Claim 9 (depends on 1)

The system of claim 1, wherein the program steps further comprise generate documents including detach logs.

### Claim 10

A method of detaching data related to a railroad system from a database, comprising:
reading and parsing operations from a configuration file, wherein the read and parsed operations include an operation to detach data from a data object;
determining whether required file systems are accessible;
determining the number of partitions, tables, and jobs scheduled to be run and created;
generating data structures based on key pattern groups defined for each partition, wherein the key pattern groups are used to identify which group each partition key belongs, wherein generating the data structures based on the key pattern groups includes generating the data structures when each key pattern group in the key pattern groups is determined to be valid and foreclosing generating the data structures when at least one key pattern group in the key pattern groups is determined to be invalid;
determining, via a processor, a table is partitioned when the table is organized according to a predetermined structure, wherein the predetermined structure includes columns of the table being organized based on an event code, an event type, a message, and a row identifier;
disabling a table object prior to executing a detach command;
generating, via the processor, a detach data library; and
executing, via the processor, the detach library by generate executable statements to detach partitions from a database.

### Claim 11 (depends on 10)

The method of claim 10, wherein after the detach command is executed, the table objects are enabled.

### Claim 12 (depends on 10)

The method of claim 10, further comprising a user interface configured to identify data for detaching data from the database.

### Claim 13 (depends on 10)

The method of claim 10, further comprising generating a file including instructions to properly detach a partition and restore the table objects to the normal state.

### Claim 14 (depends on 10)

The method of claim 10, wherein when the data partitions are to be removed, the instructions identify specific data structures using identifications.

### Claim 15 (depends on 10)

The method of claim 10, wherein the key pattern groups include a member value indicating whether the data being added belongs to a particular group, a date indicating the date range to include the data, and a group indicating the particular group for detaching the data.

### Claim 16 (depends on 10)

The method of claim 10, wherein the detach data library includes data to detach.

### Claim 17 (depends on 10)

The method of claim 10, wherein the table is partitioned when columns of the table are organized based on an event code, an event type, a message, or a row identifier.

### Claim 18 (depends on 10)

The method of claim 10, further comprising generating documents including detach logs.