Granted Patent B2

US 12,602,356 · App. 18/981,089 · Granted Apr 14, 2026

Inventors: Stephan Buehne (Essen, DE); Elmar Spiegelberg (Bedburg, DE)

Assignee: Oracle International Corporation

G06F16/214G06F16/182G06F16/275

Abstract

Claims (66)

1 . A computer-implemented method comprising:

accessing, by an adaptive migration infrastructure that includes one or more processors, information associated with a plurality of source databases and a plurality of target databases, wherein the information includes performance data, configuration data, client-specified constraints, or production load;

analyzing, by the adaptive migration infrastructure, the information associated with the plurality of source databases and the plurality of target databases;

determining, based on the analyzing of the information, a migration score for each source database of the plurality of source databases;

generating a plurality of linked sets of the plurality of source databases based at least in part on the migration score for each source database of the plurality of source databases;

selecting, for each set of the plurality of linked sets of the plurality of source databases, one or more migration methods based at least in part on a migration score range associated with the set;

generating, for each set of the plurality of linked sets and by the adaptive migration infrastructure, a migration plan that specifies parallel migration of two or more source databases by utilizing the one or more migration methods associated with the set, wherein the migration plan includes a plurality of migration scripts;

initiating, by executing the plurality of migration scripts using the adaptive migration infrastructure, the parallel migration of the two or more source databases to one or more target databases of the plurality of target databases;

monitoring, by the adaptive migration infrastructure, the parallel migration in real time;

detecting, by the adaptive migration infrastructure, one or more conditions comprising a critical error in the migration plan and/or a user attempt to alter the migration plan; and

implementing, by the adaptive migration infrastructure and in response to the detection of the one or more conditions, dynamic adjustments to the migration plan.

2 . The computer-implemented method of claim 1 , wherein the migration score for each source database of the plurality of source databases comprises a weighted sum of individual scores corresponding to different factors or characteristics that include database metrics, database specifications, the configuration data, information on data objects to be migrated, and the client-specified constraints.

3 . The computer-implemented method of claim 2 , wherein the individual scores corresponding to the different factors further include an extent of reorganization and processing of the data objects to be migrated through reordering, partitioning, compression, encryption, or fragmentation.

4 . The computer-implemented method of claim 1 , wherein generating the plurality of linked sets of the plurality of source databases further based on correlation based scoring.

5 . The computer-implemented method of claim 1 , wherein monitoring the parallel migration in real time further includes:

receiving, by the adaptive migration infrastructure, one or more signals relating to the monitoring of one or more ongoing operations of the parallel migration, wherein the one or more signals correspond to indications of:

processing resources or capacities available at a source system or a target system,

database metrics of at least one database of the plurality of source databases or at least one database of the plurality of target databases, and

export performance, import performance, or network speed.

6 . The computer-implemented method of claim 1 , further comprising: generating, by the adaptive migration infrastructure, recommendations based on the analyzing of the information, wherein the recommendations include combining specific source databases into a single database, a partitioning of a particular source database, a compression of a particular source database, or an indication of invalid objects in a source database.

7 . The computer-implemented method of claim 1 , wherein the client-specified constraints include selections of operating systems, platforms, hardware, security specifications, or time constraints including a downtime and a migration time.

8 . The computer-implemented method of claim 1 , wherein the adaptive migration infrastructure is located remotely from the plurality of source databases and the plurality of target databases and is configured to provide a cloud-based migration service.

9 . A system comprising:

one or more data processors; and

a non-transitory computer-readable storage medium containing instructions which, when executed on the one or more data processors, cause the one or more data processors to perform a set of operations including:

accessing, by an adaptive migration infrastructure that includes one or more processors, information associated with a plurality of source databases and a plurality of target databases, wherein the information includes performance data, configuration data, client-specified constraints, or production load;

analyzing, by the adaptive migration infrastructure, the information associated with the plurality of source databases and the plurality of target databases;

determining, based on the analyzing of the information, a migration score for each source database of the plurality of source databases;

generating a plurality of linked sets of the plurality of source databases based at least in part on the migration score for each source database of the plurality of source databases;

selecting, for each set of the plurality of linked sets of the plurality of source databases, one or more migration methods based at least in part on a migration score range associated with the set;

generating, for each set of the plurality of linked sets and by the adaptive migration infrastructure, a migration plan that specifies parallel migration of two or more source databases by utilizing the one or more migration methods associated with the set, wherein the migration plan includes a plurality of migration scripts;

initiating, by executing the plurality of migration scripts using the adaptive migration infrastructure, the parallel migration of the two or more source databases to one or more target databases of the plurality of target databases;

monitoring, by the adaptive migration infrastructure, the parallel migration in real time;

detecting, by the adaptive migration infrastructure, one or more conditions comprising a critical error in the migration plan and/or a user attempt to alter the migration plan; and

implementing, by the adaptive migration infrastructure and in response to the detection of the one or more conditions, dynamic adjustments to the migration plan.

10 . The system of claim 9 , wherein the migration score for each source database of the plurality of source databases comprises a weighted sum of individual scores corresponding to different factors or characteristics that include database metrics, database specifications, the configuration data, information on data objects to be migrated, and the client-specified constraints.

11 . The system of claim 10 , wherein the individual scores corresponding to the different factors further include an extent of reorganization and processing of the data objects to be migrated through reordering, partitioning, compression, encryption, or fragmentation.

12 . The system of claim 9 , wherein monitoring the parallel migration in real time further includes:

receiving, by the adaptive migration infrastructure, one or more signals relating to the monitoring of one or more ongoing operations of the parallel migration, wherein the one or more signals correspond to indications of:

processing resources or capacities available at a source system or a target system,

database metrics of at least one database of the plurality of source databases or at least one database of the plurality of target databases, and

export performance, import performance, or network speed.

13 . The system of claim 9 , the set of operations further comprises:

generating, by the adaptive migration infrastructure, recommendations based on the analyzing of the information, wherein the recommendations include combining specific source databases into a single database, a partitioning of a particular source database, a compression of a particular source database, or an indication of invalid objects in a source database.

14 . The system of claim 9 , wherein the client-specified constraints include selections of operating systems, platforms, hardware, security specifications, or time constraints including a downtime and a migration time.

15 . The system of claim 9 , wherein the adaptive migration infrastructure is located remotely from the plurality of source databases and the plurality of target databases and is configured to provide a cloud-based migration service.

16 . A computer-program product tangibly embodied in a non-transitory machine-readable storage medium, including instructions configured to cause one or more data processors to perform a set of operations comprising:

accessing, by an adaptive migration infrastructure that includes one or more processors, information associated with a plurality of source databases and a plurality of target databases, wherein the information includes performance data, configuration data, client-specified constraints, or production load;

analyzing, by the adaptive migration infrastructure, the information associated with the plurality of source databases and the plurality of target databases;

determining, based on the analyzing of the information, a migration score for each source database of the plurality of source databases;

generating a plurality of linked sets of the plurality of source databases based at least in part on the migration score for each source database of the plurality of source databases;

selecting, for each set of the plurality of linked sets of the plurality of source databases, one or more migration methods based at least in part on a migration score range associated with the set;

generating, for each set of the plurality of linked sets and by the adaptive migration infrastructure, a migration plan that specifies parallel migration of two or more source databases by utilizing the one or more migration methods associated with the set, wherein the migration plan includes a plurality of migration scripts;

initiating, by executing the plurality of migration scripts using the adaptive migration infrastructure, the parallel migration of the two or more source databases to one or more target databases of the plurality of target databases;

monitoring, by the adaptive migration infrastructure, the parallel migration in real time;

detecting, by the adaptive migration infrastructure, one or more conditions comprising a critical error in the migration plan and/or a user attempt to alter the migration plan; and

implementing, by the adaptive migration infrastructure and in response to the detection of the one or more conditions, dynamic adjustments to the migration plan.

17 . The computer-program product of claim 16 , wherein the migration score for each source database of the plurality of source databases comprises a weighted sum of individual scores corresponding to different factors or characteristics that include database metrics, database specifications, the configuration data, information on data objects to be migrated, and the client-specified constraints.

18 . The computer-program product of claim 17 , wherein the individual scores corresponding to the different factors further include an extent of reorganization and processing of the data objects to be migrated through reordering, partitioning, compression, encryption, or fragmentation.

19 . The computer-program product of claim 16 , wherein monitoring the parallel migration in real time further includes:

receiving, by the adaptive migration infrastructure, one or more signals relating to the monitoring of one or more ongoing operations of the parallel migration, wherein the one or more signals correspond to indications of:

processing resources or capacities available at a source system or a target system,

database metrics of at least one database of the plurality of source databases or at least one database of the plurality of target databases, and

export performance, import performance, or network speed.

20 . The computer-program product of claim 16 , the set of operations further comprises:

generating, by the adaptive migration infrastructure, recommendations based on the analyzing of the information, wherein the recommendations include combining specific source databases into a single database, a partitioning of a particular source database, a compression of a particular source database, or an indication of invalid objects in a source database.

Assignments (2)

Continuity (4)

References Cited (400)