# US 2008/0288548 A1 · Desensitizing data in cloning

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

- Number: US 2008/0288548 A1
- Document ID: US20080288548A1
- Status: Published application
- Kind: A1
- Application number: 11/803,399
- Filed: 2007-05-14
- Published: 2008-11-20
- Earliest claimed: 2007-05-14
- Assignees: Oracle International Corporation
- Inventors: Ian Lawler; Yali Wu
- Web page: https://patentgrep.com/patent/US20080288548A1

## CPC

- G06F 21/6245: {Protecting personal data, e.g. for financial or medical purposes}
- G06F 21/6227: {where protection concerns the structure of data, e.g. records, types, queries}
- G06F 11/1662: {the resynchronized component or unit being a persistent storage device (re-synchronization of failed mirror storage G06F11/2082; rebuild or reconstruction of parity RAID storage G06F11/1008)}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Systems, methods, media, and other embodiments associated with desensitizing data in cloning are described. One example method embodiment includes identifying a column to be desensitized and preparing a set of executable instructions to desensitize the column. The example method may also include organizing the set of executable instructions based on table-oriented relationships between instructions and then further organizing the set of executable instructions based on determinations concerning execution efficiency. The example method may be performed contemporaneously with the cloning of a database to produce a desensitized clone.

## Claims

### Claim 1

A computer-readable medium storing processor executable instructions that when executed by a processor cause the processor to perform a method, the method comprising:
identifying a column to be desensitized, the column being a portion of a table in a database;
preparing a set of executable instructions to desensitize the column; and
controlling a set of threads to desensitize the column;
where the method is to be integrated with the cloning of a database.

### Claim 2 (depends on 1)

The computer-readable medium of claim 1, where to desensitize a column includes one or more of, preventing a value from being copied from an original column to a cloned column, masking an original value from an original column in a cloned column, placing an altered value in a cloned column, replacing an original value from an original column with the result of a SQL (structured query language) statement in a cloned column, and replacing an original value from an original column with the result of a PL/SQL (procedural language/SQL) function call in a cloned column.

### Claim 3 (depends on 2)

The computer-readable medium of claim 2, where a desensitization is irreversible and where a desensitized column is not identifiable by viewing the desensitized column in isolation.

### Claim 4 (depends on 1)

The computer-readable medium of claim 1, where the set of executable instructions is to include one or more of, an SQL statement, and a PL/SQL statement and where the set of threads includes a PL/SQL thread.

### Claim 5 (depends on 1)

The computer-readable medium of claim 1, where preparing a set of executable instructions includes resolving a desensitizing algorithm associated with a column to be desensitized.

### Claim 6 (depends on 5)

The computer-readable medium of claim 5, where preparing a set of executable instructions includes producing a complete set of instructions based, at least in part, on the resolved desensitizing algorithm, and selectively grouping members of the complete set of instructions into one or more subsets of instructions, where all the instructions in a single subset are to operate on a single table or set of tables.

### Claim 7 (depends on 6)

The computer-readable medium of claim 6, the method including selectively assigning a weight to one or more of, an instruction, and a subset of instructions based on one or more of, an operation to be performed by an instruction, and a table size on which an operation is to be performed.

### Claim 8 (depends on 7)

The computer-readable medium of claim 7, the method including selectively splitting a subset of instructions into two or more subsets of instructions based on a likelihood of the two or more subsets of instructions being executed in parallel.

### Claim 9 (depends on 1)

The computer-readable medium of claim 1, where identifying a column to be desensitized includes examining one or more of, a column identification data, and a column metadata, and
where the column identification data and the column metadata describe one or more of, an actual column, a functional column, a column sensitivity level, a column desensitizing level, and a column desensitizing algorithm.

### Claim 10 (depends on 6)

The computer-readable medium of claim 6, the method including identifying a database table to desensitize and preparing additional executable instructions to desensitize the table.

### Claim 11 (depends on 10)

The computer-readable medium of claim 10, the method including adding one or more of, a truncate request for a table, and a purge request for the table, to a subset of instructions configured to operate on the table.

### Claim 12 (depends on 6)

The computer-readable medium of claim 6, the method including selectively adding a PL/SQL program configured to operate on one or more tables to a subset of executable instructions configured to operate on the one or more tables upon determining that the subset of executable instructions overlap.

### Claim 13 (depends on 1)

The computer-readable medium of claim 1, the method including controlling a thread to identify an instruction to execute based, at least in part, on a determination that having the thread execute the instruction will improve an execution efficiency measure.

### Claim 14 (depends on 13)

The computer-readable medium of claim 13, the method including controlling a thread to identify an instruction to execute based on one or more of, a weight assigned to an instruction, a size of a table upon which an instruction will act, a number of threads available to execute the instruction, and a number of threads assigned to execute a group of instructions.

### Claim 15 (depends on 14)

The computer-readable medium of claim 14, the method including controlling a thread to selectively split a table upon which an instruction will act into one or more contiguous sets of rows upon determining that one or more threads may operate on the table in parallel.

### Claim 16 (depends on 1)

The computer-readable medium of claim 1, the method including controlling a thread to provide one or more statistics concerning an operation the thread is to perform on a column and controlling a thread to provide one or more of, a success signal, an error signal, and a failure signal concerning an operation the thread is to perform.

### Claim 17 (depends on 16)

The computer-readable medium of claim 16, the method including selectively controlling the desensitizing based on one or more of, the statistics, the success signal, the error signal, and the failure signal.

### Claim 18 (depends on 1)

The computer-readable medium of claim 1, where preparing a set of executable instructions includes populating a set of tables based, at least in part, on information stored in a policy, and where controlling a set of threads includes providing information from the set of tables to the threads.

### Claim 19

A system, comprising:
an identification logic to identify a column in database table, where the column is to be desensitized in association with a database being cloned, where desensitizing the column includes one or more of, not placing a value from an original column in a cloned column, and placing an altered value in a cloned column, where the altered value may be one of, a constant, a random value within a defined range, the result of a SQL statement, and the result of a PL/SQL function call, where the desensitizing is irreversible and where the desensitizing is not detectable by viewing a desensitized column in isolation;
a preparation logic to prepare a first set of executable instructions to be used to desensitize a column, the members of the first set of executable instructions being selected based, at least in part, on a desensitizing algorithm resolved for the column, the preparation logic also to prepare a second set of executable instructions to desensitize a table, the preparation logic to create one or more bundles of tasks containing executable instructions from the first set of instructions and the second set of instructions, where a task is to contain instructions that operate on a single table; and
an execution logic to provide a set of threads to execute the bundles of tasks containing executable instructions, where a thread is to select a bundle to execute based on one or more of, a number of threads available to work on the bundle, a total number of threads available to work on the bundles, and a prediction concerning a parallelism measure associated with the thread executing the bundle.

### Claim 20 (depends on 19)

The system of claim 19, where the identification logic is to identify a column based on column identification data and column metadata that describe one or more of, an actual column, a functional column, a column sensitivity level, a column desensitizing level, and a column desensitizing algorithm, where the column identification data is to be available in a data store, and where the column metadata is to be logically attached to the column, and where the identification logic is to provide a policy that describes the column to be desensitized.

### Claim 21 (depends on 20)

The system of claim 20, where the preparation logic is to read the policy and to selectively assign a weight to an instruction based on an operation to be performed by the instruction and the size of a table on which the operation is to be performed.

### Claim 22 (depends on 21)

The system of claim 21, where the preparation logic is to selectively organize instructions into a group of instructions when the group of instructions may be executed in parallel with another group of instructions.

### Claim 23 (depends on 22)

The system of claim 22, where a thread is to selectively re-organize a first group of instructions into two or more second groups of instructions upon determining that the second groups of instructions may be executed in parallel.

### Claim 24 (depends on 23)

The system of claim 23, where a thread is to selectively split a table upon which a thread is to act into one or more contiguous sets of rows upon which one or more threads may then act in parallel.

### Claim 25

A system, comprising:
means for collecting information concerning data to desensitize in a database that is to be cloned;
means for identifying data to desensitize based, at least in part, on the collected information;
means for establishing a set of executable instructions to desensitize the data to desensitize;
means for organizing the executable instructions into sets of instructions that operate on individual tables;
means for dynamically re-organizing the sets of instructions upon determining that two or more subsets of instructions may be executed in parallel; and
means for monitoring and controlling the executable instructions while a database cloning process is in progress.
