Client-side handling of transient duplicates for row-level replication

    公开(公告)号:US09965535B2

    公开(公告)日:2018-05-08

    申请号:US13622276

    申请日:2012-09-18

    CPC classification number: G06F17/30575 G06F17/30309

    Abstract: Transient duplicate key violations of unique key constraints are handled during row updates. Row changes are buffered until a point is reached that those changes are safe to execute. Row changes are effectively reordered to avoid constraint violations during execution of updates. In response to receiving a constraint key violation from a server after an attempted update, a client locally stores a record containing information regarding the failed update. Later, in response to the lack of receipt of an error in response to another update to the same column of the same table, the client uses the information in this record to instruct the server to attempt to repeat a failed update that previously attempted to change the value of a row to a value that was present in a uniqueness-constrained column at the time of the failure, but is no longer present due to the successful update.

    Scalable coordination aware static partitioning for database replication

    公开(公告)号:US09830372B2

    公开(公告)日:2017-11-28

    申请号: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.

    SCALABLE TRI-POINT ARBITRATION AND CLUSTERING

    公开(公告)号:US20170316079A1

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

    申请号:US15140358

    申请日:2016-04-27

    CPC classification number: G06F17/30598

    Abstract: Techniques are described for performing cluster analysis on a set of data points using tri-point arbitration. In one embodiment, a first cluster that includes a set of data points is generated within volatile and/or non-volatile storage of a computing device. A set of tri-point arbitration similarity values are computed where each similarity value in the set of similarity values corresponds to a respective data point pair and is computed based, at least in part, on a distance between the respective data point pair and a set of one or more arbiter data points. The first cluster is partitioned within volatile and/or non-volatile storage of the computing device into a set of two or more clusters. A determination is made, based at least in part on the set of similarity values in the tri-arbitration similarity matrix, whether to continue partitioning the set of data points.

    SUPERVISED METHOD FOR CLASSIFYING SEASONAL PATTERNS

    公开(公告)号:US20170249562A1

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

    申请号:US15057060

    申请日:2016-02-29

    CPC classification number: G06N20/00

    Abstract: Techniques are described for classifying seasonal patterns in a time series. In an embodiment, a set of time series data is decomposed to generate a noise signal and a dense signal. Based on the noise signal, a first classification is generated for a plurality of seasonal instances within the set of time series data, where each respective instance of the plurality of instances corresponds to a respective sub-period within the season and the first classification associates a first set of one or more instances from the plurality of instances with a particular class of seasonal pattern. Based on the dense signal, a second classification is generated that associates a second set of one or more instances with the particular class. Based on the first classification and the second classification, a third classification is generated, where the third classification associates a third set of one or more instances with the particular class.

    Eager replication of uncommitted transactions

    公开(公告)号:US09747356B2

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

    申请号:US14162053

    申请日:2014-01-23

    CPC classification number: G06F17/30575 G06F17/30368 G06F17/30377

    Abstract: Techniques are provided for eager replication of uncommitted transactions. A first plurality of change records is received, corresponding to database changes applied to a source database in a first transaction. First transaction dependency data is computed based on the first transaction. At least a portion of the first plurality of change records is applied to the target database before processing a commit record indicating that has been committed on the source database. Target dependency data is updated after processing the first commit record to reflect completion of the first transaction, the target dependency data including dependency data for a plurality of transactions applied or scheduled to be applied on a target database.

    Client and server integration for replicating data
    69.
    发明授权
    Client and server integration for replicating data 有权
    用于复制数据的客户端和服务器集成

    公开(公告)号:US09589041B2

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

    申请号:US13951281

    申请日:2013-07-25

    CPC classification number: G06F17/30578 G06F17/00

    Abstract: Techniques are provided for client and server integration for scalable replication. A replication client transmits change records to a database server over a stream. The database server determines at least one batch comprising change records for at least one transaction. The database server generates dependency data for at least one change record in a batch based on at least one constraint identifier for at least one column. The database server determines an ordered grouping of the change records based on an operation type of each change record and the dependency data of each change record, wherein change records sharing operation types are grouped together unless a division based on the dependency data is determined. The database server generates a reordered transaction comprising a plurality of reordered operations based on the ordered grouping of the change records of the particular batch.

    Abstract translation: 为客户端和服务器集成提供了可扩展复制的技术。 复制客户端通过流将更改记录传输到数据库服务器。 数据库服务器至少确定一个包含至少一个交易的更改记录的批次。 数据库服务器基于至少一个列的至少一个约束标识符来为批次中的至少一个改变记录生成依赖性数据。 数据库服务器基于每个改变记录的操作类型和每个改变记录的依赖性数据来确定改变记录的有序分组,其中改变记录共享操作类型被分组在一起,除非确定基于依赖性数据的划分。 数据库服务器基于特定批次的改变记录的有序分组来生成包括多个重新排序的操作的重排序事务。

    Statement-level and procedural-level replication
    70.
    发明授权
    Statement-level and procedural-level replication 有权
    语句级和程序级复制

    公开(公告)号:US09569514B2

    公开(公告)日:2017-02-14

    申请号:US14052531

    申请日:2013-10-11

    CPC classification number: G06F17/30575 G06F17/30578

    Abstract: Techniques for replicating data in database systems are described. In an example embodiment, a set of changes is received at a destination database, where the set of changes has been applied at a source database and is being replicated from the source database to the destination database. The set of changes is analyzed and it is determined that the set of changes includes two or more of: a subset of row-level changes, a subset of statement-level changes, and a subset of procedure-level changes. A set of dependencies is determined at least between the changes that are included in the subsets of changes. The changes, in the subsets of changes, are assigned to two or more processing elements. The set of changes is applied to the destination database by executing the two or more processing elements in parallel to each other and based on the set of dependencies.

    Abstract translation: 描述了在数据库系统中复制数据的技术。 在示例实施例中,在目的地数据库处接收一组改变,其中该变更集合已经在源数据库处应用并且正在从源数据库复制到目的地数据库。 分析一组变化,并且确定该组更改包括以下两个或多个:行级更改的子集,语句级更改的子集以及过程级更改的子集。 至少在更改子集中包含的更改之间确定一组依赖关系。 更改子集中的更改分配给两个或多个处理元素。 通过相互并行并基于一组依赖关系执行两个或多个处理元件,将该组更改应用于目的地数据库。

Patent Agency Ranking