Parallel apply processing in data replication with preservation of transaction integrity and source ordering of dependent updates
    11.
    发明授权
    Parallel apply processing in data replication with preservation of transaction integrity and source ordering of dependent updates 失效
    在数据复制中并行应用处理,保留事务完整性和依赖更新的源排序

    公开(公告)号:US07490083B2

    公开(公告)日:2009-02-10

    申请号:US10789775

    申请日:2004-02-27

    IPC分类号: G07F17/30 G06F15/16

    摘要: An improved method for providing parallel apply in asynchronous data replication in a database system is disclosed. The improved method and system provides a high speed parallel apply of transactional changes to a target node such that the parallel nature of the application of changes does not compromise the integrity of the data. The method and system detects, tracks, and handles dependencies between transaction messages to be applied to the target node. If a transaction message has a dependency on one or more preceding transaction messages whose applications have not yet completed, that transaction message is held until the application completes. In addition, the method and system requires significantly less overhead than conventional approaches.

    摘要翻译: 公开了一种用于在数据库系统中异步数据复制中并行应用的改进方法。 改进的方法和系统提供对目标节点的事务性改变的高速并行应用,使得应用改变的并行性质不损害数据的完整性。 该方法和系统检测,跟踪和处理要应用于目标节点的事务消息之间的依赖关系。 如果事务消息对应用程序尚未完成的一个或多个先前的事务消息具有依赖性,那么该事务消息将保持到应用程序完成为止。 此外,与常规方法相比,该方法和系统需要明显更少的开销。

    PARALLEL APPLY PROCESSING IN DATA REPLICATION WITH PRESERVATION OF TRANSACTION INTEGRITY AND SOURCE ORDERING OF DEPENDENT UPDATES
    12.
    发明申请
    PARALLEL APPLY PROCESSING IN DATA REPLICATION WITH PRESERVATION OF TRANSACTION INTEGRITY AND SOURCE ORDERING OF DEPENDENT UPDATES 失效
    数据复制中的并行应用程序保存交易完整性和源依赖性更新顺序

    公开(公告)号:US20080163222A1

    公开(公告)日:2008-07-03

    申请号:US12049196

    申请日:2008-03-14

    IPC分类号: G06F9/46

    摘要: A computer readable medium encoded with a computer program for handling transaction messages in asynchronous data replication in a database system is disclosed. The computer program provides a high speed parallel apply of transactional changes to a target node such that the parallel nature of the application of changes does not compromise the integrity of the data. The computer program detects, tracks, and handles dependencies between transaction messages to be applied to the target node. If a transaction message has a dependency on one or more preceding transaction messages whose applications have not yet completed, that transaction message is held until the application completes. In addition, the computer program requires significantly less overhead than conventional approaches.

    摘要翻译: 公开了一种用于在数据库系统中异步数据复制中处理事务消息的计算机程序编码的计算机可读介质。 计算机程序提供对目标节点的事务更改的高速并行应用,使得应用改变的并行性质不会危及数据的完整性。 计算机程序检测,跟踪和处理要应用于目标节点的事务消息之间的依赖关系。 如果事务消息对应用程序尚未完成的一个或多个先前的事务消息具有依赖性,那么该事务消息将保持到应用程序完成为止。 此外,计算机程序需要比常规方法显着更少的开销。

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

    公开(公告)号:US07203712B2

    公开(公告)日:2007-04-10

    申请号:US10789625

    申请日:2004-02-26

    IPC分类号: G06F17/30 G06F12/00

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

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

    Efficient index-data fetch via callback for table data
    14.
    发明授权
    Efficient index-data fetch via callback for table data 失效
    通过表格数据的回调有效的索引数据提取

    公开(公告)号:US07103587B2

    公开(公告)日:2006-09-05

    申请号:US09757431

    申请日:2001-01-10

    IPC分类号: G06F7/00 G06F17/30

    摘要: A callback to a data manager is carried out from an index manager in a query processing system for an index-data fetch to enable an index page held stabilized by an index manager to remain stabilized during predicate checking or data consumption operations. The index manager locates a data identifier in an index and calls back to a data manager to access the data indicated by the data identifier. The data manager may carry out a predicate check or a data consuming operation on the data and if this is the case the index manager may access the next data identifier in the index when the data manager callback is complete. The index page need not be destabilized in such a case.

    摘要翻译: 在索引数据提取的查询处理系统中从索引管理器执行对数据管理器的回调,以使由索引管理器保持的索引页在谓词检查或数据消耗操作期间保持稳定。 索引管理器将数据标识符定位在索引中,并且回拨给数据管理器以访问由数据标识符指示的数据。 数据管理器可以对数据执行谓词检查或数据消耗操作,如果是这种情况,索引管理器可以在数据管理器回调完成时访问索引中的下一个数据标识符。 在这种情况下,索引页不需要不稳定。

    Methods to support multimethod function overloading with compile-time
type checking
    15.
    发明授权
    Methods to support multimethod function overloading with compile-time type checking 失效
    使用编译时类型检查支持多方法函数重载的方法

    公开(公告)号:US5488727A

    公开(公告)日:1996-01-30

    申请号:US771376

    申请日:1991-09-30

    IPC分类号: G06F9/42 G06F9/45 G06F11/00

    CPC分类号: G06F8/437 G06F9/4431

    摘要: Methods and related apparatus, for use in programming language systems, are set forth which support compile-time type checking for overloaded functions in an environment supporting subtypes with multiple inheritance. At both compile and runtime, the invention considers the type of all actual arguments of a function to select a proper function instance to execute. Furthermore, the methods contemplated by the invention identify at compile time the set of function instances which might be invoked due to subtype substitutions for the actual arguments. Since type errors on function invocations or variable assignments are usually indicative of a programming error, program reliability can be improved and faults that would otherwise result in runtime errors can be corrected through the use of the invention prior to program deployment.

    摘要翻译: 阐述了在编程语言系统中使用的方法和相关设备,其支持在支持具有多重继承的子类型的环境中的重载功能的编译时类型检查。 在编译和运行时,本发明考虑了一个函数的所有实际参数的类型,以选择要执行的正确的函数实例。 此外,本发明考虑的方法在编译时识别由于实际参数的子类型替换而可能调用的一组函数实例。 由于函数调用或变量赋值的类型错误通常表示编程错误,因此程序可靠性可以提高,否则会导致运行时错误的故障可以在程序部署之前通过使用本发明进行修正。

    System and method for space management of multidimensionally clustered tables
    16.
    发明授权
    System and method for space management of multidimensionally clustered tables 失效
    多维集群表的空间管理系统和方法

    公开(公告)号:US07765211B2

    公开(公告)日:2010-07-27

    申请号:US10425781

    申请日:2003-04-29

    IPC分类号: G06F7/00 G06F17/30

    CPC分类号: G06F17/30592

    摘要: An information retrieval system and method are provided for minimizing the number of blocks searched in a cell before recording a new record in the table and determining which block can be assigned if a table has space available to store a new record in the case an additional block should be associated with a cell. Dimensions for a table are identified, and at least one block in the table is associated with a dimension value for each dimension, where each block comprises contiguous storage pages. The block can be further associated with a cell; this associated cell has a unique combination of dimension values comprising an dimension value for each of the dimensions. A unique associated bit list for each dimension value for each dimension has a unique corresponding list entry for each block associated with that dimension value, and a unique associated bit list for each cell has a unique corresponding list entry for each block associated with that cell.

    摘要翻译: 提供了一种信息检索系统和方法,用于在记录表中的新记录之前最小化在小区中搜索的块的数量,并且如果在具有可用于存储新记录的空间的情况下确定可以分配哪个块的附加块 应该与一个单元格相关联。 识别表的尺寸,并且表中的至少一个块与每个维的维度值相关联,其中每个块包括连续的存储页。 该块可以进一步与细胞相关联; 该相关联的单元格具有维度值的唯一组合,其包括每个维度的维度值。 每个维度的每个维度值的唯一关联位列具有与该维度值相关联的每个块的唯一对应列表条目,并且每个单元的唯一关联位列表具有与该单元相关联的每个块的唯一对应列表条目。

    SYSTEM AND PROGRAM PRODUCT FOR SEQUENTIAL COORDINATION OF EXTERNAL DATABASE APPLICATION EVENTS WITH ASYNCHRONOUS INTERNAL DATABASE EVENTS
    17.
    发明申请
    SYSTEM AND PROGRAM PRODUCT FOR SEQUENTIAL COORDINATION OF EXTERNAL DATABASE APPLICATION EVENTS WITH ASYNCHRONOUS INTERNAL DATABASE EVENTS 有权
    使用异步内部数据库事件对外部数据库应用程序进行顺序协调的系统和程序产品

    公开(公告)号:US20080195672A1

    公开(公告)日:2008-08-14

    申请号:US12103538

    申请日:2008-04-15

    IPC分类号: G06F17/00

    CPC分类号: G06F17/30578

    摘要: Database management systems and program products that exploit time dependent sequential database management system processes to ensure presentation of the same data or view to one or a plurality of users through sequencing asynchronous database management operations such as recovery and replication. Sequencing is accomplished through the use of entries in sequential logs, including transaction logs, recovery logs, and other data recovery tools and applications. Uses include managing data migration and data replication.

    摘要翻译: 数据库管理系统和程序产品利用时间依赖的顺序数据库管理系统进程,以通过排序异步数据库管理操作(如恢复和复制)来确保向一个或多个用户呈现相同的数据或视图。 顺序通过使用顺序日志中的条目来完成,包括事务日志,恢复日志和其他数据恢复工具和应用程序。 用途包括管理数据迁移和数据复制。

    Fault tolerant mechanism to handle initial load of replicated object in live system
    18.
    发明授权
    Fault tolerant mechanism to handle initial load of replicated object in live system 有权
    在系统中处理复制对象的初始负载的容错机制

    公开(公告)号:US07330860B2

    公开(公告)日:2008-02-12

    申请号:US10789326

    申请日:2004-02-26

    IPC分类号: G06F12/00 G06F17/30

    摘要: An automatic initial data load to a new table copy concurrently with active replication to existing table copies in an asynchronous replication group includes: initiating a data load of the new table copy; creating spill queue(s) at the new table copy; loading the data from a source table copy to the new table copy, where changes for the active table copies are applied during the loading, but changes to the new table copy are stored in a spill storage area; applying the changes in the spill storage area to the new table copy after the loading of the data is done; and removing the spill storage area after the changes have been applied to the new table copy. Thus, a new table copy is initialized into the replication group without requiring that replication be suspended at the source or any of the existing table copies during the initializing process.

    摘要翻译: 在异步复制组中,将活动复制与现有表副本并发的新表复制的自动初始数据加载包括:启动新表副本的数据加载; 在新表副本上创建溢出队列; 将数据从源表副本加载到新的表副本,其中在加载期间应用活动表副本的更改,但对新表副本的更改将存储在溢出存储区中; 在完成数据的加载之后,将溢出存储区域中的更改应用于新的表格副本; 并且在将更改应用于新的表格副本之后移除溢出存储区域。 因此,将新的表副本初始化为复制组,而不需要在初始化过程中将源复制或任何现有表复制暂停。