专利快速检索-快速检索全球专利，免费商用专利数据库-IPRDB

1. 发明授权

US09483516B2 Multi-version concurrency control across row store and column store 有权
标题翻译：跨存储和列存储的多版本并发控制
公开(公告)号：US09483516B2
公开(公告)日：2016-11-01
申请号：US14213807
申请日：2014-03-14
申请人： Juchang Lee , Ivan Schreter , Chang Gyoo Park , Jaeyun Noh , Eunsang Kim , Sang Kyun Cha
发明人： Juchang Lee , Ivan Schreter , Chang Gyoo Park , Jaeyun Noh , Eunsang Kim , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30353 , G06F17/30356 , G06F17/30371
摘要： Techniques and solutions are provided for performing transactions within a database system that stores database data using a row store and a column store. For example, a transaction that performs operations to update data in both the row store and the column store can use the same transaction object. The state of the transaction can be atomically changed. For example, the state of the transaction object can be atomically changed from uncommitted to committed (e.g., set to a commit identifier to represent the committed state).
摘要翻译：提供了技术和解决方案，用于在使用行存储和列存储来存储数据库数据的数据库系统中执行事务。例如，执行更新行存储和列存储中的数据的操作的事务可以使用相同的事务对象。交易的状态可以原子地改变。例如，可以将事务对象的状态从未提交状态原子地更改为已提交（例如，设置为提交标识符以表示已提交状态）。

2. 发明申请

US20160147906A1 Transaction Control Block for Multiversion Concurrency Commit Status 审中-公开
标题翻译：用于多分支并发提交状态的事务控制块
公开(公告)号：US20160147906A1
公开(公告)日：2016-05-26
申请号：US14552808
申请日：2014-11-25
申请人： Ivan SCHRETER , Chang-Gyoo Park
发明人： Ivan SCHRETER , Chang-Gyoo Park
IPC分类号： G06F17/30
CPC分类号： G06F16/9038 , G06F16/1873 , G06F16/2322
摘要： Disclosed herein are system, method, and computer program product embodiments for utilizing a transaction control block for providing reader-writer access to transaction commit status. An embodiment operates by receiving a row read request and determining that the row is versioned. The system determines that a first timestamp information for a row destroy transaction associated with the row exists in a transaction control block and retrieves the first timestamp information from the transaction control block.
摘要翻译：这里公开了用于利用事务控制块来提供读写器访问事务提交状态的系统，方法和计算机程序产品实施例。实施例通过接收行读请求并确定该行被版本化来操作。系统确定事务控制块中存在与该行相关联的行销毁事务的第一时间戳信息，并从事务控制块检索第一时间戳信息。

3. 发明申请

US20150261805A1 MULTI-VERSION CONCURRENCY CONTROL ACROSS ROW STORE AND COLUMN STORE 有权
标题翻译：多层次的同步控制，围绕着店铺和商店
公开(公告)号：US20150261805A1
公开(公告)日：2015-09-17
申请号：US14213807
申请日：2014-03-14
申请人： Juchang Lee , Ivan Schreter , Chang Gyoo Park , Jaeyun Noh , Eunsang Kim , Sang Kyun Cha
发明人： Juchang Lee , Ivan Schreter , Chang Gyoo Park , Jaeyun Noh , Eunsang Kim , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30353 , G06F17/30356 , G06F17/30371
摘要： Techniques and solutions are provided for performing transactions within a database system that stores database data using a row store and a column store. For example, a transaction that performs operations to update data in both the row store and the column store can use the same transaction object. The state of the transaction can be atomically changed. For example, the state of the transaction object can be atomically changed from uncommitted to committed (e.g., set to a commit identifier to represent the committed state).
摘要翻译：提供了技术和解决方案，用于在使用行存储和列存储来存储数据库数据的数据库系统中执行事务。例如，执行更新行存储和列存储中的数据的操作的事务可以使用相同的事务对象。交易的状态可以原子地改变。例如，可以将事务对象的状态从未提交状态原子地更改为已提交（例如，设置为提交标识符以表示已提交状态）。

4. 发明授权

US09098522B2 Version garbage collection using snapshot lists 有权
标题翻译：使用快照列表的版本垃圾回收
公开(公告)号：US09098522B2
公开(公告)日：2015-08-04
申请号：US13750204
申请日：2013-01-25
申请人： Juchang Lee , Chang Gyoo Park , Yongjae Chuh , Jaeyun Noh , Michael Muehle
发明人： Juchang Lee , Chang Gyoo Park , Yongjae Chuh , Jaeyun Noh , Michael Muehle
IPC分类号： G06F17/30
CPC分类号： G06F17/3015 , G06F17/3023 , G06F17/30353 , G06F17/30356
摘要： Systems, methods and computer program product embodiments for providing version garbage collection using snapshot lists are disclosed herein. Version garbage collection using snapshot lists includes storing, by at least one processor, versions of a record in a database table, the record comprising a record value and a version timestamp, storing, by the at least one processor, active snapshots in two levels of active snapshot lists, an active snapshot comprising a transaction identifier and a snapshot timestamp, determining, by the at least one processor, a minimum active snapshot from the active snapshots in the two levels of active snapshot lists and deleting, by the at least one processor, versions of the record having a version timestamp earlier than a snapshot timestamp of the minimum active snapshot.
摘要翻译：本文公开了使用快照列表提供版本垃圾收集的系统，方法和计算机程序产品实施例。使用快照列表的版本垃圾收集包括通过至少一个处理器存储数据库表中的记录的版本，所述记录包括记录值和版本时间戳，由所述至少一个处理器存储两个级别的活动快照活动快照列表，包括事务标识符和快照时间戳的活动快照，由所述至少一个处理器确定所述两个活动快照列表中的活动快照中的最小主动快照，并且由所述至少一个处理器，该记录的版本的版本时间戳早于最小主动快照的快照时间戳。

5. 发明申请

US20160147858A1 Log Forwarding to Avoid Deadlocks During Parallel Log Replay in Asynchronous Table Replication 有权
标题翻译：日志转发以避免在异步表复制期间的并行日志重放期间的死锁
公开(公告)号：US20160147858A1
公开(公告)日：2016-05-26
申请号：US14657854
申请日：2015-03-13
申请人： Juchang Lee , Chang-Gyoo Park , Hyoung-Jun Na , Deok-Hoe Kim
发明人： Juchang Lee , Chang-Gyoo Park , Hyoung-Jun Na , Deok-Hoe Kim
IPC分类号： G06F17/30
CPC分类号： G06F11/1469 , G06F11/1464 , G06F17/30368 , G06F17/30371 , G06F17/30377 , G06F17/30575 , G06F17/30578 , G06F17/30876 , G06F2201/80
摘要： Disclosed herein are system, method, and computer program product embodiments for removing a deadlock during replication from distributed source tables to a replica node. An embodiment operates by detecting a deadlock at a parallel log replayer at a replica node. A first replication log entry from a queue at the parallel log replayer is then selected based on whether removing the first replication log entry from the queue removes the deadlock. The first replication log entry is then forwarded to a waiting queue. A second replication log entry is then replayed at the parallel log replayer. After replaying the second replication log entry, the first replication log entry is replayed at the parallel log replayer.
摘要翻译：这里公开了用于在从分布式源表复制到复制节点的过程中去除死锁的系统，方法和计算机程序产品实施例。实施例通过检测复制节点处的并行日志重播器处的死锁而进行操作。然后根据是否从队列中删除第一个复制日志条目来删除死锁，来选择并行日志重播器中队列中的第一个复制日志条目。然后将第一个复制日志条目转发到等待队列。然后在并行日志重播器中重播第二个复制日志条目。重播第二个复制日志条目后，第一个复制日志条目将在并行日志重播器中重播。

6. 发明申请

US20160147618A1 RowID-Based Data Synchronization for Asynchronous Table Replication 有权
标题翻译：用于异步表复制的基于RowID的数据同步
公开(公告)号：US20160147618A1
公开(公告)日：2016-05-26
申请号：US14657938
申请日：2015-03-13
申请人： Juchang LEE , Kyu-Hwan Kim , Hyoung-Jun Ne , Chang-Gyoo Park , Hyejeong Lee
发明人： Juchang LEE , Kyu-Hwan Kim , Hyoung-Jun Ne , Chang-Gyoo Park , Hyejeong Lee
IPC分类号： G06F11/14 , G06F17/30
CPC分类号： G06F11/1469 , G06F11/1464 , G06F17/30368 , G06F17/30371 , G06F17/30377 , G06F17/30575 , G06F17/30578 , G06F17/30876 , G06F2201/80
摘要： Disclosed herein are system, method, and computer program product embodiments for synchronizing lost change between a source table and a replica table. An embodiment operates by detecting a restart at a source node or a replica node. Row-ID values of replication log entries are then compared to row-ID column values of rows at a replica table of the replica node. Replication errors at a source table or the replica table are then determined based on the row-ID comparison. The rows of the source table and the replica table are then updated based on the determination.
摘要翻译：这里公开了用于使源表和副本表之间的丢失变化同步的系统，方法和计算机程序产品实施例。实施例通过检测在源节点或副本节点处的重启来操作。然后将复制日志条目的行ID值与副本节点的副本表上的行的行ID列值进行比较。然后根据行ID比较确定源表或副本表上的复制错误。然后基于确定来更新源表和副本表的行。

7. 发明授权

US09965359B2 Log forwarding to avoid deadlocks during parallel log replay in asynchronous table replication 有权
公开(公告)号：US09965359B2
公开(公告)日：2018-05-08
申请号：US14657854
申请日：2015-03-13
申请人： Juchang Lee , Chang-Gyoo Park , Hyoung-Jun Na , Deok-Hoe Kim
发明人： Juchang Lee , Chang-Gyoo Park , Hyoung-Jun Na , Deok-Hoe Kim
IPC分类号： G06F17/30 , G06F11/14
CPC分类号： G06F11/1469 , G06F11/1464 , G06F17/30368 , G06F17/30371 , G06F17/30377 , G06F17/30575 , G06F17/30578 , G06F17/30876 , G06F2201/80
摘要： Disclosed herein are system, method, and computer program product embodiments for removing a deadlock during replication from distributed source tables to a replica node. An embodiment operates by detecting a deadlock at a parallel log replayer at a replica node. A first replication log entry from a queue at the parallel log replayer is then selected based on whether removing the first replication log entry from the queue removes the deadlock. The first replication log entry is then forwarded to a waiting queue. A second replication log entry is then replayed at the parallel log replayer. After replaying the second replication log entry, the first replication log entry is replayed at the parallel log replayer.

8. 发明授权

US09805074B2 Compressed representation of a transaction token 有权
公开(公告)号：US09805074B2
公开(公告)日：2017-10-31
申请号：US13760850
申请日：2013-02-06
申请人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
发明人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30309 , G06F17/30286 , G06F17/30356
摘要： Methods, systems and computer-readable storage mediums encoded with computer programs executed by one or more processors for providing a compressed representation of a transaction token are disclosed. In an embodiment, a transaction token maintains statues of transaction to a database in a first data structure and a second data structure. The first data structure includes a plurality of identifiers respectively corresponding to the transactions to the database and a corresponding status of each identifier indicating whether a given transaction is open or closed, wherein the plurality of identifiers is maintained below a threshold number of identifiers. The second data structure includes a plurality of identifiers of transactions to the database beyond the threshold and whose status is open.

9. 发明申请

US20160147859A1 Transactional and Parallel Log Replay for Asynchronous Table Replication 有权
标题翻译：异步表复制的事务和并行日志重放
公开(公告)号：US20160147859A1
公开(公告)日：2016-05-26
申请号：US14657948
申请日：2015-03-13
申请人： Juchang Lee , Chang-Gyoo Park , Hyoung-Jun Na , Kyu-Hwan Kim
发明人： Juchang Lee , Chang-Gyoo Park , Hyoung-Jun Na , Kyu-Hwan Kim
IPC分类号： G06F17/30
CPC分类号： G06F11/1469 , G06F11/1464 , G06F17/30368 , G06F17/30371 , G06F17/30377 , G06F17/30575 , G06F17/30578 , G06F17/30876 , G06F2201/80
摘要： Disclosed herein are system, method, and computer program product embodiments for replicating a database transaction to a replica table. An embodiment operates by receiving a replication log entry and an associated transaction commit log entry for a database transaction to be replayed to a row at a replica table. A row-ID value of the replication log entry is compared to a row-ID column value of the row at the replica table. The replication log entry is then replayed at a parallel log replayer based on the comparison. The database transaction is then committed to the replica table by replaying the associated transaction commit log entry at a transaction log replayer.
摘要翻译：这里公开了用于将数据库事务复制到副本表的系统，方法和计算机程序产品实施例。一个实施例通过接收复制日志条目和相关联的事务提交日志条目来进行操作，以便数据库事务被重播到副本表的行。将复制日志条目的行ID值与副本表中的行的行ID列值进行比较。然后，基于比较，在并行日志重播器中重播复制日志条目。然后，数据库事务通过在事务日志重播器上重播关联的事务提交日志条目来提交给副本表。

10. 发明申请

US20140149353A1 Version Garbage Collection Using Snapshot Lists 有权
标题翻译：版本垃圾收集使用快照列表
公开(公告)号：US20140149353A1
公开(公告)日：2014-05-29
申请号：US13750204
申请日：2013-01-25
申请人： Juchang Lee , Chang Gyoo Park , Yongjae Chuh , Jaeyun Noh , Michael Muehle
发明人： Juchang Lee , Chang Gyoo Park , Yongjae Chuh , Jaeyun Noh , Michael Muehle
IPC分类号： G06F17/30
CPC分类号： G06F17/3015 , G06F17/3023 , G06F17/30353 , G06F17/30356
摘要： Systems, methods and computer program product embodiments for providing version garbage collection using snapshot lists are disclosed herein. Version garbage collection using snapshot lists includes storing, by at least one processor, versions of a record in a database table, the record comprising a record value and a version timestamp, storing, by the at least one processor, active snapshots in two levels of active snapshot lists, an active snapshot comprising a transaction identifier and a snapshot timestamp, determining, by the at least one processor, a minimum active snapshot from the active snapshots in the two levels of active snapshot lists and deleting, by the at least one processor, versions of the record having a version timestamp earlier than a snapshot timestamp of the minimum active snapshot.
摘要翻译：本文公开了使用快照列表提供版本垃圾收集的系统，方法和计算机程序产品实施例。使用快照列表的版本垃圾收集包括通过至少一个处理器存储数据库表中的记录的版本，所述记录包括记录值和版本时间戳，由所述至少一个处理器存储两个级别的活动快照活动快照列表，包括事务标识符和快照时间戳的活动快照，由所述至少一个处理器确定所述两个活动快照列表中的活动快照中的最小主动快照，并且由所述至少一个处理器，该记录的版本的版本时间戳早于最小主动快照的快照时间戳。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式