System and program product for sequential coordination of external database application events with asynchronous internal database events
    1.
    发明授权
    System and program product for sequential coordination of external database application events with asynchronous internal database events 有权
    用于使用异步内部数据库事件顺序协调外部数据库应用程序事件的系统和程序产品

    公开(公告)号:US07953707B2

    公开(公告)日:2011-05-31

    申请号:US12103538

    申请日:2008-04-15

    IPC分类号: G06F7/00 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.

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

    Parallel apply processing in data replication with preservation of transaction integrity and source ordering of dependent updates
    3.
    发明授权
    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
    4.
    发明申请
    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
    5.
    发明授权
    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
    6.
    发明授权
    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
    7.
    发明授权
    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.

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

    INDEX PARTITION MAINTENANCE OVER MONOTONICALLY ADDRESSED DOCUMENT SEQUENCES
    9.
    发明申请
    INDEX PARTITION MAINTENANCE OVER MONOTONICALLY ADDRESSED DOCUMENT SEQUENCES 有权
    索引分割维护在单个寻址的文档序列中

    公开(公告)号:US20120059823A1

    公开(公告)日:2012-03-08

    申请号:US12875615

    申请日:2010-09-03

    IPC分类号: G06F17/30

    摘要: Provided are techniques for partitioning a physical index into one or more physical partitions; assigning each of the one or more physical partitions to a node in a cluster of nodes; for each received document, assigning an assigned-doc-ID comprising an integer document identifier; and, in response to assigning the assigned-doc-ID to a document, determining a cut-off of assignment of new documents to a current virtual-index-epoch comprising a first set of physical partitions and placing the new documents into a new virtual-index-epoch comprising a second set of physical partitions by inserting each new document to a specific one of the physical partitions in the second set using one or more functions that direct the placement based on one of the assigned-doc-id, a field value derived from a set of fields obtained from the document, and a combination of the assigned-doc-id and the field value.

    摘要翻译: 提供了用于将物理索引分割成一个或多个物理分区的技术; 将一个或多个物理分区中的每一个分配给节点簇中的节点; 对于每个接收到的文档,分配包括整数文档标识符的分配文档ID; 并且响应于将分配的文档ID分配给文档,确定新文档的分配到当前虚拟索引时期的截断,该当前虚拟索引时期包括第一组物理分区,并将新文档放入新的虚拟 - 指数 - 历元包括第二组物理分区,通过使用一个或多个基于所分配的文档ID中的一个来指导所述布局的功能,将每个新文档插入第二组中的特定一个物理分区 从文档获得的一组字段中导出的值以及分配的doc-id和字段值的组合。

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

    公开(公告)号:US20080195673A1

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

    申请号:US12103548

    申请日:2008-04-15

    IPC分类号: G06F12/00

    CPC分类号: G06F17/30578

    摘要: Database management systems, methods, 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.

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