公开(公告)号：US20070033181A1

公开(公告)日：2007-02-08

申请号：US11197604

申请日：2005-08-04

申请人： Eric Barsness ,  John Santosuosso ,  John Stroh

发明人： Eric Barsness ,  John Santosuosso ,  John Stroh

IPC分类号： G06F17/30

CPC分类号： G06F17/30368

摘要： 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.

摘要翻译： 数据库日志机制将行操作和数据库查询都存储在数据库日志中。 期刊中的数据库查询提供可以以多种不同方式使用的重要附加信息。 例如，根据优选实施例的数据库复制发送机制可以读取日志中的数据库查询，并确定查询影响多行。 然后，数据库复制发送机制可以将数据库查询传送到承载复制数据库的计算机系统。 根据优选实施例的数据库复制接收机制接收数据库查询，并对复制数据库执行数据库查询。 因此，单个数据库查询的传输可以替代许多行操作的传输。