IP Library › Granted Patent US 8,150,811
Granted Patent B1
US 8,150,811 · App. 12/465,826 · Granted Apr 3, 2012

Parallel migration of data between systems

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,150,811
App. No.
12/465,826
Granted
Apr 3, 2012
Kind
B1
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.

Claims (12)

1. 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.

2. The database system of claim 1 , wherein the access management system comprises plural access managers adapted to manage access of respective portions of the storage subsystem.

3. The database system of claim 2 , wherein the temporary tables are defined according to definitions for a source table in the source system.

4. The database system of claim 2 , wherein the plural access managers are adapted to insert data from the temporary tables in parallel to the target table.

5. The database system of claim 4 , the storage subsystem adapted to store the definitions for the source table copied from the source system.

6. The database system of claim 2 , wherein the plural access managers comprise access module processors, the storage subsystem divided into plural storage modules managed by respective access module processors.

7. The database system of claim 6 , wherein the target table is distributed across the plural storage modules.

8. The database system of claim 1 , wherein the temporary tables are relational tables.

9. The database system of claim 1 , wherein the access management subsystem has a configuration different from a configuration of an access management system in the source system.