US 2025/0053551 A1Published application

Techniques for transitioning database tables from production to non-production environments

AssigneeInsight Direct USA, Inc.

InventorAbhijit Moharil

Life of this patent

Estimating the term…

Loading patent…

Abstract

A name conversion system includes computer-readable memory encoded with instructions that, when executed by one or more processors, cause the name conversion system to make name changes identified in a list of name conversions to tables of data by identifying name changes for records in the tables in a database, identifying each table in the database, determining whether each table has an index, searching a column of a table designated in the index and changing one or more names of records in the column as identified in the list of name conversions so that any column not included in the index is not searched when the table has an index, and searching an entirety of a table and changing one or more names of records in the table as identified in the list of name conversions when the table does not have an index.

Claims20

Dependent claims

A name conversion system comprising:

a first database for storing raw data;
a second database for storing converted data;
one or more processors;
and
computer-readable memory encoded with instructions that, when executed by the one or more processors, cause the name conversion system to:
access raw data from the first database;
copy the raw data from the first database to the second database;
access a list of name conversions;
make name changes identified in the list of name conversions in parallel to tables of data that has been copied to the second database to complete name conversions by performing steps (a)-(e) to more than one table of data that has been copied to the second database in parallel, wherein:
(a) comprises identifying name changes for records in the tables in the second database;
(b) comprises identifying each table of the tables in the second database;
(c) comprises determining indices associated with the tables;
(d) comprises searching tables associated with the indices, wherein the searching comprises:
searching a column of a respective table designated in the associated index and changing one or more names of records in the column as identified in the list of name conversions so that any column not included in the index is not searched when the table has an index;
and
(e) comprises searching an entirety of a table and changing one or more names of records in the table as identified in the list of name conversions when the table is not associated with an index;
and
store converted data comprising the data that has been copied to the second database and has undergone name changes and non-converted data comprising the data that has been copied to the second database and has not undergone name changes in the second database for access via a user interface.

15 more elements

A method of converting names for a non-production database, the method comprising:

accessing raw data from a production database;
copying the raw data from the production database to a non-production database;
accessing a list of name conversions;
making name changes identified in the list of name conversions in parallel to tables of data that has been copied to the non-production database to complete name conversions by performing steps (a)-(e) to more than one table of data that has been copied to the non-production database in parallel, wherein:
(a) comprises identifying name changes for records in the tables in the non-production database;
(b) comprises identifying each table of the tables in the non-production database;
(c) comprises determining indices associated with the tables;
(d) comprises searching tables associated with the indices, wherein the searching comprises:
searching a column of a respective table designated in the associated index and changing one or more names of records in the column as identified in the list of name conversions so that any column not included in the index is not searched when the table has an index;
and
(e) comprises searching an entirety of a table and changing one or more names of records in the table as identified in the list of name conversions when the table is not associated with an index;
and
storing converted data and non-converted data in the non-production database for access via a user interface.

10 more elements

Dependencies are inferred from the claim text.