Desensitizing data in cloning
AssigneeOracle International Corporation
InventorsIan Lawler, Yali Wu
Life of this patent
Estimating the term…
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.
Claims25
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.
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.
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.
Dependencies are inferred from the claim text.