公开(公告)号：US10803031B1

公开(公告)日：2020-10-13

申请号：US14985084

申请日：2015-12-30

Applicant: Amazon Technologies, Inc.

Inventor： Jeremiah Wilton ,  Ilia Gilderman ,  John MacDonald Winford

IPC: G06F16/30 ,  G06F16/21 ,  G06F16/25

Abstract: Data is migrated between a source database and a target database. The source database management system (“DBMS”) remains operational during the migration. A user selects the source DBMS and target DBMS, provides connection information used to connect to the database management systems and selects a virtual machine instance to perform the migration in conjunction with a database migration service. After the setup is complete, the virtual machine instance in conjunction with the database migration service performs data type transformations, and other operations, without user intervention. The database migration service also converts, without user intervention, the source schema and code to a format compatible with the target DBMS. Any code that is not converted is marked to assist the user of the database migration service identify where manual re-coding is required. The database migration service can also provide recommendations as to a target DBMS that is a suitable target DBMS.

公开(公告)号：US11016954B1

公开(公告)日：2021-05-25

申请号：US15694624

申请日：2017-09-01

Applicant: Amazon Technologies, Inc.

Inventor： Rostislav Babocichin ,  Alexey Gershun ,  Ilia Gilderman ,  Parker J. Lord ,  John MacDonald Winford

IPC: G06F16/21 ,  G06F16/25

Abstract: Distributed extraction of data for migration may be implemented for migrating data sets from a first data store to a second data store. Assignments may be determined for different migration agents to obtain and store the data set in the second data store along with a format for storing the assigned data set portions. The migration agents may then be caused to obtain the assigned portions and store the assigned portions in the second data store according to the identified format. Further operations to request or direct the ingestion of the data set from the second data store may be performed by migration agents with respect to a third data store that performs data ingestion.

公开(公告)号：US10963435B1

公开(公告)日：2021-03-30

申请号：US15653871

申请日：2017-07-19

Applicant: Amazon Technologies, Inc.

Inventor： Grant Alexander Macdonald McAlister ,  Edward Paul Murray ,  Nicolas Anton Medhurst Hertl ,  Ilia Gilderman ,  Jeremiah C. Wilton ,  John MacDonald Winford ,  Satheesh Peringandookaran Subramanian

IPC: G06F16/21 ,  G06F11/07 ,  G06F11/16 ,  G06F16/11

Abstract: A method and system for validating data migrated from a source database to a target database and storing validation metrics resulting from validating the data are described. The system receives validation information to be used to validate data to be migrated from a source database to a target database. The system validates the data using the validation information and stores validation metrics resulting from validating the data.

公开(公告)号：US11853273B1

公开(公告)日：2023-12-26

申请号：US16145093

申请日：2018-09-27

Applicant: Amazon Technologies, Inc.

Inventor： Roy Edward Stephan ,  Benjamin Snively ,  John MacDonald Winford ,  John Calhoun ,  Nathan McGuirt

IPC: G06F16/24 ,  G06F16/21 ,  G06N20/00 ,  G06F16/25 ,  G06F16/2452 ,  G06F16/2455 ,  H04L67/56

CPC classification number: G06F16/214 ,  G06F16/2452 ,  G06F16/2455 ,  G06F16/252 ,  G06N20/00 ,  H04L67/56

Abstract: Systems and methods are provided to enable a partial migration of applications from one database system to another without modifying the applications. In embodiments, a proxy server is configured to monitor the application's usage of a current database, and generate a migration plan to partially migrate database objects used by the application to a different type of database. An object may be selected for migration based on its usage level or its portability. After the partial migration, the proxy server may remain in place as a request router to route the application's requests to the two databases. In embodiments, the migration system may forward queries to both databases and compare the query results received from the two. Based on the comparison results, the migration system may programmatically determine adjustments to its query handling configuration settings.

公开(公告)号：US10185727B1

公开(公告)日：2019-01-22

申请号：US14985132

申请日：2015-12-30

Applicant: Amazon Technologies, Inc.

Inventor： Jeremiah Wilton ,  Ilia Gilderman ,  John MacDonald Winford

IPC: G06F17/30

Abstract: Data is migrated between a source database and a target database. The source database management system (“DBMS”) remains operational during the migration. A user selects the source DBMS and target DBMS, provides connection information used to connect to the database management systems and selects a virtual machine instance to perform the migration in conjunction with a database migration service. After the setup is complete, the virtual machine instance in conjunction with the database migration service performs data type transformations, and other operations, without user intervention. The database migration service also converts, without user intervention, the source schema and code to a format compatible with the target DBMS. Any code that is not converted is marked to assist the user of the database migration service identify where manual re-coding is required. The database migration service can also provide recommendations as to a target DBMS that is a suitable target DBMS.

公开(公告)号：US11360951B1

公开(公告)日：2022-06-14

申请号：US15826295

申请日：2017-11-29

Applicant: Amazon Technologies, Inc.

Inventor： Ilia Gilderman ,  Eran Schitzer ,  John MacDonald Winford

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/23

Abstract: A system such as a service of a computing resource service provider includes executable code that, if executed by one or more processors, causes the one or more processors to identify a set of resources associated with a first database system, determine, based at least in part on the set of resources, an expected outcome of an operation of a second database system, and generate, executable code that, if executed, verifies an actual outcome of the operation of the second database system against the expected outcome. The system may be utilized as part of a database migration process where data from a first database system is transferred to a second database system.

公开(公告)号：US11269823B1

公开(公告)日：2022-03-08

申请号：US16252273

申请日：2019-01-18

Applicant: Amazon Technologies, Inc.

Inventor： Jeremiah Wilton ,  Ilia Gilderman ,  John MacDonald Winford

IPC: G06F16/00 ,  G06F16/21 ,  G06F16/958

Abstract: Data is migrated between a source database and a target database. The source database management system (“DBMS”) remains operational during the migration. A user selects the source DBMS and target DBMS, provides connection information used to connect to the database management systems and selects a virtual machine instance to perform the migration in conjunction with a database migration service. After the setup is complete, the virtual machine instance in conjunction with the database migration service performs data type transformations, and other operations, without user intervention. The database migration service also converts, without user intervention, the source schema and code to a format compatible with the target DBMS. Any code that is not converted is marked to assist the user of the database migration service identify where manual re-coding is required. The database migration service can also provide recommendations as to a target DBMS that is a suitable target DBMS.

公开(公告)号：US10740286B1

公开(公告)日：2020-08-11

申请号：US15688655

申请日：2017-08-28

Applicant: Amazon Technologies, Inc.

Inventor： Ilia Gilderman ,  Nicolas Anton Medhurst Hertl ,  Gal Eliraz Levonai ,  Edward Paul Murray ,  Michael J. Russo ,  John MacDonald Winford

IPC: G06F16/11 ,  G06F9/50 ,  G06F16/16 ,  G06F16/21

Abstract: Validation of a migration task to migrate data from one data store to another may be performed prior to the migration of the data. Parameters associated with the migration may be evaluated according to one or more types of validations for the migration task. In some embodiments, users may specify the validations to perform for the migration task. A determination as to whether the migration task is valid may be performed for the migration task based on the parameter evaluations. A result indicating whether the migration task is valid may be provided to a user.

公开(公告)号：US10509696B1

公开(公告)日：2019-12-17

申请号：US15679107

申请日：2017-08-16

Applicant: Amazon Technologies, Inc.

Inventor： Ilia Gilderman ,  Arun Kumar Thiagarajan ,  John MacDonald Winford

IPC: G06F11/00 ,  G06F11/07

Abstract: Errors may be detected and mitigated during the migration of data. Migration of data from a source data store to a target data store may be monitored for errors. When an error is detected, one or more responsive actions may be identified to modify performance of the migration. In some embodiments, responsive actions may include further analyses to validate the migration. In some embodiments, the responsive actions may be corrective actions to correct the detected error. Once identified, the responsive actions may be performed to modify performance of the migration.