Method and System for Implementing Parallel Transformations of Records
    1.
    发明申请
    Method and System for Implementing Parallel Transformations of Records 有权
    实现记录并行转换的方法和系统

    公开(公告)号:US20100036861A1

    公开(公告)日:2010-02-11

    申请号:US12188521

    申请日:2008-08-08

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30

    摘要: An improved approach is described for implementing transformations of data records in high concurrency environments. Each transformation is performed in parallel at the source when the data record is first generated. According to one approach for data integrity validation, record generators compute an integrity checksum for a newly generated record before copying into a data unit in shared memory. Subsequent generators may aggregate integrity checksums for data records into checksums for data units incrementally. This approach achieves end-to-end protection of data records against corruption using an efficient method of maintaining verifiable data integrity. In another approach, compression and encryption data transformations may be performed by themselves, or in combination with an integrity checksum transformation.

    摘要翻译: 描述了一种用于在高并发环境中实现数据记录转换的改进方法。 当数据记录首次生成时,每个变换在源处并行执行。 根据数据完整性验证的一种方法,记录生成器在复制到共享存储器中的数据单元之前计算新生成的记录的完整性校验和。 随后的生成器可以将数据记录的完整性校验和聚集到数据单元的校验和中。 这种方法使用有效的维护可验证数据完整性的方法来实现端到端的数据记录保护。 在另一种方法中,压缩和加密数据转换可以自己执行,或者与完整性校验和转换相结合。

    Controlling data lag in a replicated computer system
    2.
    发明授权
    Controlling data lag in a replicated computer system 有权
    控制复制计算机系统中的数据滞后

    公开(公告)号:US08838919B2

    公开(公告)日:2014-09-16

    申请号:US12871805

    申请日:2010-08-30

    IPC分类号: G06F12/00 G06F11/20 G06F17/30

    摘要: A method and system is provided for measuring, guaranteeing, and reducing replication data lag time between a primary system and one or more standby systems. Each standby system determines the lag time between the generation of a consistent version of data on the primary system and the time that the consistent version is applied on the standby system. Applications can request and be guaranteed to receive data from a standby system that is identical to the state on the primary system at the time of the query, or lag the primary state only by a maximum tolerable amount. A standby system may also publish a service that guarantees a maximum lag time and withdraw the service offer when the actual lag time exceeds the guaranteed lag time.Implications for implementing synchronous and asynchronous replication as well as performance optimizations are also discussed.

    摘要翻译: 提供了一种方法和系统,用于测量,保证和减少主系统与一个或多个备用系统之间的复制数据滞后时间。 每个备用系统确定在主系统上生成一致版本的数据与在备用系统上应用一致版本的时间之间的滞后时间。 应用程序可以请求并保证从查询时与主系统上的状态相同的备用系统接收数据,或仅以最大可容忍的数量滞后于主状态。 备用系统还可以发布保证最大延迟时间的服务,并且当实际滞后时间超过保证滞后时间时撤回服务报价。 还讨论了实现同步和异步复制以及性能优化的意义。

    Controlling Data Lag in a Replicated Computer System
    3.
    发明申请
    Controlling Data Lag in a Replicated Computer System 有权
    控制复制计算机系统中的数据滞后

    公开(公告)号:US20120054533A1

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

    申请号:US12871805

    申请日:2010-08-30

    IPC分类号: G06F17/30 G06F11/20 G06F11/07

    摘要: A method and system is provided for measuring, guaranteeing, and reducing replication data lag time between a primary system and one or more standby systems. Each standby system determines the lag time between the generation of a consistent version of data on the primary system and the time that the consistent version is applied on the standby system. Applications can request and be guaranteed to receive data from a standby system that is identical to the state on the primary system at the time of the query, or lag the primary state only by a maximum tolerable amount. A standby system may also publish a service that guarantees a maximum lag time and withdraw the service offer when the actual lag time exceeds the guaranteed lag time.Implications for implementing synchronous and asynchronous replication as well as performance optimizations are also discussed.

    摘要翻译: 提供了一种方法和系统,用于测量,保证和减少主系统与一个或多个备用系统之间的复制数据滞后时间。 每个备用系统确定在主系统上生成一致版本的数据与在备用系统上应用一致版本的时间之间的滞后时间。 应用程序可以请求并保证从查询时与主系统上的状态相同的备用系统接收数据,或仅以最大可容忍的数量滞后于主状态。 备用系统还可以发布保证最大延迟时间的服务,并且当实际滞后时间超过保证滞后时间时撤回服务报价。 还讨论了实现同步和异步复制以及性能优化的意义。

    Method for maximizing throughput and minimizing transactions response times on the primary system in the presence of a zero data loss standby replica
    4.
    发明授权
    Method for maximizing throughput and minimizing transactions response times on the primary system in the presence of a zero data loss standby replica 有权
    在存在零数据丢失备用副本的情况下,在主系统上最大化吞吐量并最小化事务响应时间的方法

    公开(公告)号:US08868492B2

    公开(公告)日:2014-10-21

    申请号:US13161315

    申请日:2011-06-15

    IPC分类号: G06F17/00 G06F17/30

    CPC分类号: G06F17/30575

    摘要: A method and system is provided for reducing delay to applications connected to a database server that guarantees no data loss during failure or disaster. After storing a log record persistently in a local primary log, the log writer returns control to the application which continues running concurrently with the database server sending the session's log records to a standby database. A separate back channel is used by the standby to communicate, out-of-band to the primary, the location of the last log record stored persistently to the standby log. An application waiting for a transaction to commit may wait until the transaction's commit record has been persisted. Also described is a technique for reducing application delay when there is contention between nodes of a multi-node cluster for updating the same block. The technique provides for an asynchronous ping protocol that guarantees zero data loss during failure or disaster.

    摘要翻译: 提供了一种方法和系统,用于减少连接到数据库服务器的应用程序的延迟,保证在故障或灾难期间无数据丢失。 将日志记录永久存储在本地主日志中后,日志记录器将返回到与数据库服务器并发运行的应用程序,该应用程序将会话的日志记录发送到备用数据库。 备用数据库使用一个单独的后置通道,将主持续端口的持续存储的最后一个日志记录的位置进行通信。 等待事务提交的应用程序可能会等到事务的提交记录被持久化。 还描述了当用于更新相同块的多节点簇的节点之间存在竞争时减少应用延迟的技术。 该技术提供了异步ping协议,保证在故障或灾难期间零数据丢失。

    Database system configured for automatic failover with user-limited data loss
    5.
    发明授权
    Database system configured for automatic failover with user-limited data loss 有权
    数据库系统配置为自动故障切换,具有用户限制的数据丢失

    公开(公告)号:US08423515B2

    公开(公告)日:2013-04-16

    申请号:US13018328

    申请日:2011-01-31

    IPC分类号: G06F17/00 G06F7/00

    摘要: Techniques used in an automatic failover configuration having a primary database system, a standby database system, and an observer. In the automatic failover configuration, the primary database system remains available even in the absence of both the standby and the observer as long as the standby and the observer become absent sequentially. The failover configuration may use asynchronous transfer modes to transfer redo to the standby and permits automatic failover only when the observer is present and the failover will not result in data loss due to the asynchronous transfer mode beyond a specified maximum. The database systems and the observer have copies of failover configuration state and the techniques include techniques for propagating the most recent version of the state among the databases and the observer and techniques for using carefully-ordered writes to ensure that state changes are propagated in a fashion which prevents divergence.

    摘要翻译: 在具有主数据库系统,备用数据库系统和观察者的自动故障转移配置中使用的技术。 在自动故障切换配置中,只要备用和观察器顺序不存在,主数据库系统即使没有备用和观察器也保持可用。 故障转移配置可能会使用异步传输模式将重做传输到备用数据库,并且只有当观察者存在时才允许自动故障转移,并且由于超出指定最大值的异步传输模式,故障转移不会导致数据丢失。 数据库系统和观察者具有故障切换配置状态的副本,并且技术包括用于在数据库和观察者之间传播最新版本的状态的技术以及使用仔细排序的写入的技术,以确保状态改变以一种方式传播 防止发散。

    Reduced Disk Space Standby
    7.
    发明申请
    Reduced Disk Space Standby 有权
    减少磁盘空间待机

    公开(公告)号:US20120054158A1

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

    申请号:US12871795

    申请日:2010-08-30

    IPC分类号: G06F17/30 G06F12/08

    摘要: A method and system for replicating database data is provided. One or more standby database replicas can be used for servicing read-only queries, and the amount of storage required is scalable in the size of the primary database storage. One technique is described for combining physical database replication to multiple physical databases residing within a common storage system that performs de-duplication. Having multiple physical databases allows for many read-only queries to be processed, and the de-duplicating storage system provides scalability in the size of the primary database storage. Another technique uses one or more diskless standby database systems that share a read-only copy of physical standby database files. Notification messages provide consistency between each diskless system's in-memory cache and the state of the shared database files. Use of a transaction sequence number ensures that each database system only accesses versions of data blocks that are consistent with a transaction checkpoint.

    摘要翻译: 提供了一种用于复制数据库数据的方法和系统。 一个或多个备用数据库副本可用于维护只读查询,并且所需的存储量可在主数据库存储的大小上扩展。 描述了一种将物理数据库复制与驻留在执行重复数据删除的公共存储系统中的多个物理数据库进行组合的技术。 拥有多个物理数据库可以处理许多只读查询,并且重复存储系统提供主数据库存储大小的可扩展性。 另一种技术使用一个或多个共享物理备用数据库文件的只读副本的无盘备用数据库系统。 通知消息提供每个无盘系统的内存缓存与共享数据库文件的状态之间的一致性。 使用事务序列号确保每个数据库系统只能访问与事务检查点一致的数据块版本。

    Reduced disk space standby
    10.
    发明授权

    公开(公告)号:US08589361B2

    公开(公告)日:2013-11-19

    申请号:US12871795

    申请日:2010-08-30

    IPC分类号: G06F17/00

    摘要: A method and system for replicating database data is provided. One or more standby database replicas can be used for servicing read-only queries, and the amount of storage required is scalable in the size of the primary database storage. One technique is described for combining physical database replication to multiple physical databases residing within a common storage system that performs de-duplication. Having multiple physical databases allows for many read-only queries to be processed, and the de-duplicating storage system provides scalability in the size of the primary database storage. Another technique uses one or more diskless standby database systems that share a read-only copy of physical standby database files. Notification messages provide consistency between each diskless system's in-memory cache and the state of the shared database files. Use of a transaction sequence number ensures that each database system only accesses versions of data blocks that are consistent with a transaction checkpoint.