Browse Prior Art Database

Automatic Tracking System for Transferring Data between two Databases

IP.com Disclosure Number: IPCOM000033371D
Original Publication Date: 2004-Dec-08
Included in the Prior Art Database: 2004-Dec-08
Document File: 1 page(s) / 27K

Publishing Venue

IBM

Abstract

Failure or manual stop in the middle of transferring data from one database to another database often require processing the data from the very beginning or manual interpretation of which record should be transferred. This is a time consuming process especially when the database is huge. We minimize this process by writing the primary key of every predefined number of data record in a sorted table into a temporary table in the source database. Restarting the transfer will only start with the record in the temporary table.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 100% of the total text.

Page 1 of 1

Automatic Tracking System for Transferring Data between two Databases

Problem:

Transferring large amount of data from one database to another database always require a lot of time. Failure or manual stop in the middle of transferring data often require processing the data from the very beginning or manual interpretation of which record should be transferred. This is a time consuming process especially when the database is huge.

Solution:

During transferring data, for every predefined number of data record (say 100), we write the primary key of every 100 record into a temporary table in the source database which is sorted before the transfer. When the process is stopped in the middle of transfer, we only start with the record in the temporary table when the transfer process start again. This will save time since we don't need to check one by one to see whether they have been transferred or not.

Process Flow:
1. Sort the data in the source database using the primary key
2. Check if the temporary table(say tempTable) exist in the source database or not.

if it exists(that means the transfer is somehow stopped before), we start transfer data from the record in tempTable. if not exist(that means the transfer has not started yet), create it
3. During transfer, for every predefined data record(say 100), we write the primary key of every 100 record into tempTable

1