READ-WRITE PROTOCOL FOR APPEND-ONLY DISTRIBUTED DATABASES

    公开(公告)号:EP3356958A1

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

    申请号:EP16778603.7

    申请日:2016-09-26

    IPC分类号: G06F17/30

    摘要: Performing a distributed database transaction using parallel writes to a distributed append-only database system is provided. A central database and a plurality of distributed databases, also known as “shards”, may be used. A request made to implement a distributed transaction, requiring updates to one or more shards, results in a monotonically increasing identification (ID) number being assigned to a change set. The request and change set may be registered at the central database. Once the change set is completely written to all of the appropriate shards, the change set is marked as completed in the central database. After write completion, a change set ID boundary at the central database is advanced to indicate the current fully changed status of the distributed database.

    EFFICIENT METHODS AND SYSTEMS FOR CONSISTENT READ IN RECORD-BASED MULTI-VERSION CONCURRENCY CONTROL
    36.
    发明公开
    EFFICIENT METHODS AND SYSTEMS FOR CONSISTENT READ IN RECORD-BASED MULTI-VERSION CONCURRENCY CONTROL 审中-公开
    为了获得一致的读取同时多重版本记录为基础的控制有效方法和系统

    公开(公告)号:EP3111347A4

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

    申请号:EP15768720

    申请日:2015-03-16

    发明人: ZHANG GUOGEN

    IPC分类号: G06F17/30

    摘要: System and method embodiments are provided for consistent read in a record-based multi-version concurrency control (MVCC) in database (DB) management systems. In an embodiment, a method in a record-based multi-version concurrent control (MVCC) database (DB) management system for a snapshot consistent read includes copying a system commit transaction identifier (TxID) and a current log record sequence number (LSN) from a transaction log at a start of a reader without backfilling of a commit LSN of a transaction to records that are changed and without copying an entire transaction table by the reader; and determining whether a record is visible according to a record TxID, the commit TxID and a current LSN, wherein a transaction table is consulted only when the record TxID is equal to or larger than a commit TxID at a transaction start.

    摘要翻译: 提供了用于在数据库(DB)管理系统中的基于记录的多版本并发控制(MVCC)一致读取系统和方法实施例。 ,实施例中,以在基于记录的多版本并发控制(MVCC)数据库(DB)管理快照一致的读取系统的方法包括在复制系统提交事务标识符(TxID添加)和电流日志记录序号(LSN) 从读者的开始事务日志没有提交事务,以记录做了改变,并没有复制到受读者整个事务表的LSN的回填; 和确定性采矿记录是否是可见的雅鼎创纪录的TxID添加,提交TxID添加和当前LSN,worin交易表被咨询只有当记录TxID添加等于或大于提交TxID添加在事务开始变大。

    Converting a serial transaction schedule to a parallel transaction schedule
    37.
    发明公开
    Converting a serial transaction schedule to a parallel transaction schedule 审中-公开
    Umwandlung einer serieller Transaktionszeitplanung auf eine parallele Transaktionszeitplanung

    公开(公告)号:EP2998863A1

    公开(公告)日:2016-03-23

    申请号:EP14004184.9

    申请日:2014-12-11

    申请人: Sybase, Inc.

    摘要: A method and system for transforming a serial schedule of transactions into a parallel schedule of transaction is disclosed. In one example, a computer system stores a list of data transactions in a transaction log. The computer system then reads a respective data transaction from the transaction log. The computer system determines whether the respective data transaction is dependent on any other currently pending data transaction. In accordance with a determination that the respective data transaction is not dependent on any other currently pending data transaction, the computer system applies the data changes to a reconstructed data set. In accordance with a determination that the respective data transaction is dependent on a currently pending second data transaction, the computer system delays commitment of the respective data transaction until the second data transaction has been applied to the reconstructed data set.

    摘要翻译: 公开了一种用于将事务的串行调度转换为并行交易计划的方法和系统。 在一个示例中,计算机系统将数据事务的列表存储在事务日志中。 计算机系统然后从事务日志读取相应的数据事务。 计算机系统确定相应的数据事务是否依赖于任何其他当前待处理的数据事务。 根据确定相应的数据事务不依赖于任何其他当前待处理的数据事务,计算机系统将数据改变应用于重构数据集。 根据确定相应的数据事务取决于当前待决的第二数据事务,计算机系统延迟相应数据事务的承诺,直到第二数据事务已被应用于重建的数据集。

    MAINTENANCE OF ACTIVE DATABASE QUERIES
    39.
    发明公开
    MAINTENANCE OF ACTIVE DATABASE QUERIES 审中-公开
    护理活性数据库查询

    公开(公告)号:EP2936351A1

    公开(公告)日:2015-10-28

    申请号:EP13863961.2

    申请日:2013-12-19

    申请人: Logicblox, Inc.

    IPC分类号: G06F17/30

    摘要: An aspect includes a method for maintaining active queries. The method includes executing a query based on data items in at least two relations in a database. The executing includes outputting a query result and control information associated with the query. The query result and the control information are recorded. A notification that at least one of the data items has been updated subsequent to the executing is received. The query result is modified, responsive to the control information, to reflect the data items that were updated subsequent to the executing.

    System and method of a shared memory hash table with notifications
    40.
    发明公开
    System and method of a shared memory hash table with notifications 审中-公开
    系统与Verfahrenfüreine gemeinsam genutzte Speicher-Hash-Tabelle mit Benachrichtigungen

    公开(公告)号:EP2802109A1

    公开(公告)日:2014-11-12

    申请号:EP14167803.7

    申请日:2014-05-09

    IPC分类号: H04L12/743 G06F17/30

    摘要: A method and apparatus of a device that includes a shared memory hash table that notifies one or more readers of changes to the shared memory hash table is described. In an exemplary embodiment, a device modifies a value in the shared memory hash table, where the value has a corresponding key. The device further stores a notification in a notification queue that indicates the value has changed. In addition, the device invalidates a previous entry in the notification queue that indicates the value has been modified. The device signals to the reader that a notification is ready to be processed.

    摘要翻译: 描述了一种包括共享存储器散列表的装置的方法和装置,该共享存储器散列表向一个或多个读取器通知对共享存储器散列表的改变。 在示例性实施例中,设备修改共享存储器散列表中的值,其中该值具有对应的密钥。 设备还将通知存储在指示值已更改的通知队列中。 此外,设备使通知队列中的先前条目无效,表示该值已被修改。 该设备向读写器发信号通知已准备好处理。