Reconfiguring Propagation Streams in Distributed Information Sharing
    11.
    发明申请
    Reconfiguring Propagation Streams in Distributed Information Sharing 有权
    在分布式信息共享中重新构建传播流

    公开(公告)号:US20090037442A1

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

    申请号:US11831798

    申请日:2007-07-31

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30575

    摘要: Splitting and merging database object information sharing streams. Streams are also referred to herein as “propagations”. Splitting and merging information sharing streams can be used to improve performance in a information sharing environment when a failed or slow DBS impacts the performance. In one embodiment, an auto split process monitors the progress of applying changes at each node and detects the presence of a failed or a slow node. Once the failed or slow node is identified, the auto split process splits the propagation such that the offending node is sent through a separate propagation. Furthermore, an auto merge process can be started to monitor the newly created separate propagation. At a later point, the new propagation can be merged back into the original stream. For example, if the offending node catches up with other nodes, the auto merge process merges the newly created propagation back to the original propagation.

    摘要翻译: 分割和合并数据库对象信息共享流。 流在本文中也称为“传播”。 当失败或缓慢的DBS影响性能时,可以使用分割和合并信息共享流来提高信息共享环境中的性能。 在一个实施例中,自动拆分过程监视在每个节点处应用变化的进度,并检测故障或慢节点的存在。 一旦确定了故障或慢节点,自动拆分过程就会分裂传播,从而通过单独的传播发送违规节点。 此外,可以开始自动合并处理来监视新创建的单独传播。 稍后,新的传播可以合并回原始流。 例如,如果违规节点赶上其他节点,则自动合并过程将新创建的传播合并到原始传播。

    Management of a distributed database
    12.
    发明授权
    Management of a distributed database 有权
    管理分布式数据库

    公开(公告)号:US07925674B2

    公开(公告)日:2011-04-12

    申请号:US11604529

    申请日:2006-11-27

    IPC分类号: G06F7/00 G06F17/30

    摘要: Systems, methodologies, media, and other embodiments associated with managing of a distributed database are described. One exemplary system embodiment includes an input logic configured to obtain information associated with a distributed database where the distributed database comprises a plurality of databases. An analysis logic analyzes the information obtained from the distributed database to determine performance information associated with the distributed database and, an output logic can provide information regarding the performance information associated with the distributed database.

    摘要翻译: 描述了与分布式数据库的管理相关联的系统,方法,介质和其他实施例。 一个示例性系统实施例包括被配置为获得与分布式数据库相关联的信息的输入逻辑,其中分布式数据库包括多个数据库。 分析逻辑分析从分布式数据库获得的信息以确定与分布式数据库相关联的性能信息,并且输出逻辑可以提供关于与分布式数据库相关联的性能信息的信息。

    Automatic resizing of shared memory for messaging
    16.
    发明申请
    Automatic resizing of shared memory for messaging 有权
    自动调整共享内存的大小,以进行消息传递

    公开(公告)号:US20070118600A1

    公开(公告)日:2007-05-24

    申请号:US11247976

    申请日:2005-10-10

    申请人: Nimar Arora

    发明人: Nimar Arora

    IPC分类号: G06F15/16

    摘要: Methods and systems for estimating the hypothetical performance of a messaging application are disclosed. A number of pool sizes may be identified, each pool size being a potential size for the memory allocated to the messaging application. An online simulation is running during the execution of the messaging application. The online simulation tracks the requests made by the messaging application and predicts the operation of the messaging application for each pool size. The data predicted includes the number of spill and unspill operations that read and write to disk. In addition, a method for calculating the age of the oldest message in a memory pool is disclosed. The age is used in determining the number of spill and unspill operations.

    摘要翻译: 公开了用于估计消息应用的假设性能的方法和系统。 可以识别多个池大小,每个池大小是分配给消息收发应用的存储器的潜在大小。 在执行消息应用程序期间,正在运行在线仿真。 在线模拟跟踪消息传递应用程序所做的请求,并预测每个池大小的消息传递应用程序的操作。 预测的数据包括读取和写入磁盘的溢出和卸载操作的数量。 此外,公开了一种用于计算存储器池中最早消息的年龄的方法。 该年龄用于确定溢出和卸妆操作的数量。

    Method of applying changes to a standby database system
    17.
    发明授权
    Method of applying changes to a standby database system 有权
    将更改应用于备用数据库系统的方法

    公开(公告)号:US06980988B1

    公开(公告)日:2005-12-27

    申请号:US10260547

    申请日:2002-10-01

    IPC分类号: G06F17/30

    摘要: A method for applying changes to a standby system is described in which multiple apply tasks or “slaves” are scheduled to changes from redo logs, especially those changes in large transactions, in parallel and as soon as they are encountered in the logs. To foster data convergence, a partial ordering may be imposed on the transactions so that those transactions that actually depend on others are forced to wait on the transactions they are dependent upon commit. To foster read consistency, synchronization points may be periodically established, at which points a read consistent state of the standby database system can be obtained-all without adversely impact the throughput of the system.

    摘要翻译: 描述了对备用系统应用更改的方法,其中多个应用任务或“从属”被调度为从重做日志中更改,特别是大事务中的这些更改并行并且一旦在日志中遇到即可。 为了促进数据收敛,可能会对事务施加部分排序,以使实际上依赖于其他事务的事务被迫等待其依赖于提交的事务。 为了促进读取一致性,可以周期性地建立同步点,从而可以获得备用数据库系统的读取一致状态,而不会对系统的吞吐量产生不利影响。

    Incremental refresh of materialized views for many-to-many relationships
    18.
    发明授权
    Incremental refresh of materialized views for many-to-many relationships 有权
    逐渐刷新多对多关系的物化视图

    公开(公告)号:US06708179B1

    公开(公告)日:2004-03-16

    申请号:US09969938

    申请日:2001-10-02

    申请人: Nimar Arora

    发明人: Nimar Arora

    IPC分类号: G06F1730

    摘要: A framework for the incrementally refreshing a materialized view is provided. The materialized view is based on a query that references a projected table and another set of base tables. The query projects the columns of the projected table. To refresh the materialized view, a set of tuples is computed that identify rows to delete, insert, or otherwise modify in the materialized view in order to refresh it. The set of tuples is computed by computing a set of intersections, (1) one for the intersection between the query and the change log of the projected table, and (2) at least one other between the equijoin of the change log for one of the other base tables and the projected table. The query may define an equijoin between the projected table and at least one base table based on equijoin conditions that define a many-to-many relationship or a one-to-many relationship.

    摘要翻译: 提供了用于逐渐刷新物化视图的框架。 物化视图基于引用投影表和另一组基表的查询。 查询投影投影表的列。 要刷新物化视图,计算一组元组,以识别要在物化视图中删除,插入或以其他方式修改的行,以刷新它。 通过计算一组交点来计算一组元组,(1)一个用于查询和投影表的更改日志之间的交集,以及(2)在变更日志的等价之间的至少一个, 其他基表和投影表。 查询可以基于定义多对多关系或一对多关系的等价条件来定义投影表和至少一个基表之间的等价。