EAGER REPLICATION OF UNCOMMITTED TRANSACTIONS

    公开(公告)号:US20170364571A1

    公开(公告)日:2017-12-21

    申请号:US15692141

    申请日:2017-08-31

    CPC classification number: G06F16/27 G06F16/2358 G06F16/2379

    Abstract: Techniques are provided for eager replication of uncommitted transactions. In embodiments, a replication client receives, in a data stream, change records corresponding to database changes applied to a source database in a transaction. The change records does not include a commit record that indicates that the transaction is committed on the source database. Before receiving the commit record, the replication client computes transaction dependency data based on the change records and detects, based on the transaction dependency data, that the transaction can be at least partially applied to a target database. Also before receiving the commit record, the replication client applies, to a target database and based on the detecting, at least some of the change records. Upon receiving the commit record of the transaction, the replication client completes applying the change records and commits the transaction on the target database.

    SYSTEM FOR DETECTING AND CHARACTERIZING SEASONS

    公开(公告)号:US20170249376A1

    公开(公告)日:2017-08-31

    申请号:US15057065

    申请日:2016-02-29

    Abstract: Techniques are described for characterizing and summarizing seasonal patterns detected within a time series. According to an embodiment, a set of time series data is analyzed to identify a plurality of instances of a season, where each instance corresponds to a respective sub-period within the season. A first set of instances from the plurality of instances are associated with a particular class of seasonal pattern. After classifying the first set of instances, a second set of instances may remain unclassified or otherwise may not be associated with the particular class of seasonal pattern. Based on the first and second set of instances, a summary may be generated that identifies one or more stretches of time that are associated with the particular class of seasonal pattern. The one or more stretches of time may span at least one sub-period corresponding to at least one instance in the second set of instances.

    AUTOMATIC PARALLELISM TUNING FOR APPLY PROCESSES
    5.
    发明申请
    AUTOMATIC PARALLELISM TUNING FOR APPLY PROCESSES 有权
    自动并行调谐应用程序

    公开(公告)号:US20150033232A1

    公开(公告)日:2015-01-29

    申请号:US13949594

    申请日:2013-07-24

    CPC classification number: G06F9/466 G06F9/5083 G06F17/30371

    Abstract: Techniques are provided for automatic parallelism tuning. At least one batch of change records is assigned to one or more apply processes in a set of active apply processes. A first throughput value is periodically determined based on a number of processed change records in a first time interval. An increment adjustment is periodically performed, including adding an additional apply process, determining a second throughput value, and removing the additional apply process from the set of active apply processes if the second throughput value is not greater than a previous first throughput value by at least an increment threshold. A decrement adjustment is periodically performed, including removing an apply process, determining a third throughput value, and replacing the removed apply process in the set of active apply processes if the third throughput value is not greater than the previous first throughput value by at least a decrement threshold.

    Abstract translation: 提供了自动并行调谐技术。 至少一批更改记录被分配给一组活动应用进程中的一个或多个应用进程。 基于在第一时间间隔中的处理的改变记录的数量来周期性地确定第一吞吐量值。 定期执行增量调整,包括添加附加的应用过程,确定第二吞吐量值,以及如果第二吞吐量值不大于先前的第一吞吐量值至少至少在一组活动应用进程中移除附加应用进程 增量阈值。 如果第三吞吐量值不大于先前的第一吞吐量值,则定期执行递减调整,包括去除应用进程,确定第三吞吐量值,以及替换所述一组活动应用进程中的所移除的应用进程, 递减阈值

    Scalable Coordination Aware Static Partitioning For Database Replication
    6.
    发明申请
    Scalable Coordination Aware Static Partitioning For Database Replication 有权
    可扩展协调感知数据库复制的静态分区

    公开(公告)号:US20150032694A1

    公开(公告)日:2015-01-29

    申请号:US13950207

    申请日:2013-07-24

    CPC classification number: G06F17/30581 G06F17/30368

    Abstract: Parallel logical replication involves multiple apply threads running on a destination database server applying, in parallel, changes made by source transactions, where the changes of a single source transaction may be applied in parallel by multiple apply threads. An apply transaction for a source transaction may be committed by an apply thread independently of the commitment of any other apply transaction of the source transaction, that is, without coordinating the committing of another apply transaction executed by another apply thread for the source transaction. A configuration language is used to configure parallel logical replication. The language facilitates the configuration of various aspects of parallel logical replication, including the number of apply threads, partitioning schemes for the apply threads for partitioning change records between the apply threads, and various other aspects of parallel logical replication.

    Abstract translation: 并行逻辑复制涉及在目标数据库服务器上运行的多个应用线程,并行地应用源事务所做的更改,其中单个源事务的更改可以由多个应用线程并行应用。 源事务的应用事务可以由应用线程提交,独立于源事务的任何其他应用事务的承诺,即,不协调由源事务的另一应用线程执行的另一应用事务的提交。 配置语言用于配置并行逻辑复制。 该语言有助于并行逻辑复制的各个方面的配置,包括应用线程的数量,应用线程的分区方案,用于分区应用线程之间的更改记录以及并行逻辑复制的各种其他方面。

    DATA DEFINITION LANGUAGE (DDL) EXPRESSION ANNOTATION
    7.
    发明申请
    DATA DEFINITION LANGUAGE (DDL) EXPRESSION ANNOTATION 有权
    数据定义语言(DDL)表达式

    公开(公告)号:US20150032689A1

    公开(公告)日:2015-01-29

    申请号:US13949969

    申请日:2013-07-24

    CPC classification number: G06F17/30575

    Abstract: Techniques are provided for data definition language (DDL) expression annotation. DDL expression text is captured. The DDL expression text corresponds to a DDL change in a source database. A component set is determined. The component set includes at least one component in the DDL expression text. An annotation set is generated. The annotation set includes at least one annotation for at least one component of the component set. Each annotation includes hierarchical data describing at least one hierarchical relationship in the component set. For example, an annotation may include a component ID, a component position, a component length, a component type, and a parent component ID. The annotation set and a change record comprising the DDL expression text are transmitted to a replication client.

    Abstract translation: 为数据定义语言(DDL)表达式注释提供了技术。 捕获DDL表达式文本。 DDL表达式文本对应于源数据库中的DDL更改。 确定组件集。 组件集包含DDL表达式文本中的至少一个组件。 生成注释集。 注释集合包括至少一个组件集合的一个组件的注释。 每个注释包括描述组件集中的至少一个分层关系的分层数据。 例如,注释可以包括组件ID,组件位置,组件长度,组件类型和父组件ID。 注释集和包含DDL表达式文本的更改记录被发送到复制客户端。

    RECOVERY FROM LOSS OF LEADER DURING ASYNCHRONOUS DATABASE TRANSACTION REPLICATION

    公开(公告)号:US20240126783A1

    公开(公告)日:2024-04-18

    申请号:US18372006

    申请日:2023-09-22

    CPC classification number: G06F16/273 G06F11/1469 G06F16/2379 G06F2201/80

    Abstract: A lead-sync log record is used to synchronize the replication logs of follower shards to the leader shard. In response to a failure to determine that there is a consensus for a database transaction commit operation after a shard server becomes a new leader, the new leader shard performs a sync operation using the lead-sync log record to synchronize replication logs of the follower shards to the replication log of the new leader. A shard server identifies a first transaction having a first log record but not a post-commit log record in the replication log, defines a recovery window in the replication log starting at the first log record of the identified first transaction and ending at the lead-sync log record, identifies a set of transactions to be recovered, and performs a recovery action on the set of transactions to be recovered.

Patent Agency Ranking