Invention Grant
- Patent Title: Journaling database queries for database replication
- Patent Title (中): 日记数据库查询数据库复制
-
Application No.: US11197604Application Date: 2005-08-04
-
Publication No.: US07685170B2Publication Date: 2010-03-23
- Inventor: Eric Lawrence Barsness , John Matthew Santosuosso , John A. Stroh
- Applicant: Eric Lawrence Barsness , John Matthew Santosuosso , John A. Stroh
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Martin & Associates, LLC
- Main IPC: G06F12/00
- IPC: G06F12/00

Abstract:
A database journal mechanism stores both row operations and database queries in a database journal. The database queries in the journal provide significant additional information that may be used in a number of different ways. For example, a database replication send mechanism in accordance with the preferred embodiments could read a database query in the journal and determine that the query affects several rows. The database replication send mechanism could then transmit the database query to the computer system that hosts the replicated database. A database replication receive mechanism in accordance with the preferred embodiments receives the database query, and executes the database query on the replicated database. As a result, the transmission of a single database query can replace the transmission of many row operations.
Public/Granted literature
- US20070033181A1 Apparatus and method for journaling database queries Public/Granted day:2007-02-08
Information query