Algorithm to find LOB value in a relational table after key columns have been modified
    2.
    发明申请
    Algorithm to find LOB value in a relational table after key columns have been modified 有权
    在关键列修改后,在关系表中查找LOB值的算法

    公开(公告)号:US20050193040A1

    公开(公告)日:2005-09-01

    申请号:US10789625

    申请日:2004-02-26

    IPC分类号: G06F17/30

    摘要: A method and system for asynchronously replicating data changes in a database system captures update information for a data update in a source table from a database log, where the data value from the data update is not in the database log. A query is built to obtain the data value from the source table using the update information, including a key column value that identifies the row of the source table in which the data resides. When the key column is also updated in the same or different transaction, the data update information is stored, and the updated key column value is replaced with a later captured key column update value. The query is built and executed, and the data update is replicated at a target table. In this manner, data objects whose values are not recorded in a database log can be asynchronously replicated in a database system.

    摘要翻译: 用于在数据库系统中异步复制数据更改的方法和系统从数据库日志捕获源表中的数据更新的更新信息,其中数据更新中的数据值不在数据库日志中。 构建查询以使用更新信息从源表获取数据值,包括标识数据所在的源表的行的键列值。 当密钥列也在相同或不同的事务中被更新时,存储数据更新信息,并且更新的密钥列值被替换为稍后捕获的密钥列更新值。 构建并执行查询,并在目标表中复制数据更新。 以这种方式,可以在数据库系统中异步复制其值未记录在数据库日志中的数据对象。