Invention Grant
US07644112B2 Apparatus, system, and method for initializing a synchronized remote database
失效
用于初始化同步远程数据库的设备,系统和方法
- Patent Title: Apparatus, system, and method for initializing a synchronized remote database
- Patent Title (中): 用于初始化同步远程数据库的设备,系统和方法
-
Application No.: US11670336Application Date: 2007-02-01
-
Publication No.: US07644112B2Publication Date: 2010-01-05
- Inventor: David Randall Blea , Errol Jay Calder , Gregory Edward McBride , Todd Benjamin Schlomer , John Jay Wolfgang
- Applicant: David Randall Blea , Errol Jay Calder , Gregory Edward McBride , Todd Benjamin Schlomer , John Jay Wolfgang
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Kunzler & McKenzie
- Main IPC: G06F17/30
- IPC: G06F17/30 ; G06F12/00

Abstract:
An apparatus, system, and method are disclosed for initializing a synchronized remote database. A creation module creates a first backup table of a backup database from a schema for a primary table of a primary database. A read module reads each row from the primary table with an application server configured to manage access to the primary database by a database application. A construction module constructs a SQL command for each row of the primary table. Each SQL command inserts data of a primary table row in the first backup table. An application module applies each SQL command to the first backup table to mirror the primary table at the first backup table.
Public/Granted literature
- US20080189341A1 APPARATUS, SYSTEM, AND METHOD FOR INITIALIZING A SYNCHRONIZED REMOTE DATABASE Public/Granted day:2008-08-07
Information query