Back to results
US 8,150,811 B1Granted
Parallel migration of data between systems
AssigneeTeradata US, Inc.
InventorsHerbert J. Tarenskeen, Joseph Craig McPhie
Life of this patent
Estimating the term…
Abstract
A system and method for migrating data, in parallel, from a source database system into a target database system includes storing data in groups (e.g., clusters) in the source database system. The groups of data are transferred, in parallel, to respective temporary staging tables in the target database system. The data in the temporary staging tables are then inserted, in parallel, into a target table in the target database system to complete the migration.
Claims9
A target database system comprising:
- a memory device adapted to store a storage subsystem, the storage subsystem adapted to store a plurality of temporary tables and a target table;
- a processor in communication with the memory device;
- and
- an access management subsystem executable on the processor, the access management subsystem adapted to receive, in parallel, groups of data from a source database system for storage in corresponding temporary tables, the access management subsystem adapted to further insert data from the temporary tables into the target table and to make data in the target table available for execution of database queries against that data.
1 more element
Dependencies are inferred from the claim text.