Patent ID: 7685170
Filing Date: 2010-03-23
Classification: G06F

Abstract:
1. A first computer system comprising: at least one processor; a memory coupled to the at least one processor; a first database residing in the memory; a database journal for the first database residing in the memory that stores changes to the first database, the stored changes to the first database comprising a first plurality of row operations corresponding to a first plurality of database queries to the first database and a second plurality of database queries to the first database; a database journal mechanism residing in the memory and executed by the at least one processor, the database journal mechanism storing a selected database query to the first database in the database journal as one of the second plurality of database queries when the selected database query is executed on the first database if a number of rows affected by the selected database query exceeds a predetermined threshold, and if the number of rows affected by the selected database query does not exceed the predetermined threshold, storing a plurality of row operations corresponding to the selected database query in the database journal as some of the first plurality of row operations; and a database replication send mechanism residing in the memory and executed by the at least one processor, the database replication send mechanism selecting an entry in the database journal, determining whether the selected entry in the database journal comprises the selected database query, and if the selected entry in the database journal comprises the selected database query, transmitting the selected entry to a second computer system that comprises a second database that replicates the first database using database journal entries received from the first computer system, and if the selected entry in the database journal comprises a row operation and the row operation does not correspond to any database query previously transmitted to the second computer system, transmitting the selected entry to the second computer system.