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

61. 发明授权

US07305421B2 Parallelized redo-only logging and recovery for highly available main memory database systems 有权
标题翻译：用于高可用性主内存数据库系统的并行重做唯一记录和恢复
公开(公告)号：US07305421B2
公开(公告)日：2007-12-04
申请号：US10195822
申请日：2002-07-15
申请人： Sang K. Cha , Juchang Lee , Kihong Kim
发明人： Sang K. Cha , Juchang Lee , Kihong Kim
IPC分类号： G06F17/30
CPC分类号： G06F11/2094 , G06F11/1471 , G06F11/1662 , G06F2201/80 , Y10S707/99933 , Y10S707/99953
摘要： A parallel logging and recovery scheme for highly available main-memory database systems is presented. A preferred embodiment called parallel redo-only logging (“PROL”) combines physical logging and selective replay of redo-only log records. During physical logging, log records are generated with an update sequence number representing the sequence of database update. The log records are replayed selectively during recovery based on the update sequence number. Since the order of replaying log records doesn't matter in physical logging, PROL makes parallel operations possible. Since the physical logging does not depend on the state of the object to which the log records are applied, the present invention also makes it easy to construct a log-based hot standby system.
摘要翻译：提出了一种用于高可用性主内存数据库系统的并行日志记录和恢复方案。称为并行重做日志记录（“PROL”）的优选实施例组合物理记录和仅重做日志记录的选择性重放。在物理日志记录期间，生成日志记录，其中更新序列号表示数据库更新的顺序。基于更新序列号在恢复期间有选择地重播日志记录。由于重放日志记录的顺序在物理日志记录中无关紧要，因此PROL使并行操作成为可能。由于物理日志记录不依赖于应用日志记录的对象的状态，本发明还使得易于构建基于日志的热备用系统。

62. 发明授权

US10055440B2 Database table re-partitioning using trigger-based capture and replay 有权
公开(公告)号：US10055440B2
公开(公告)日：2018-08-21
申请号：US14188543
申请日：2014-02-24
申请人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
发明人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
IPC分类号： G06F17/30
CPC分类号： G06F16/2282
摘要： Partitioning of a source table of a database to a target table is initiated. Thereafter, a replay table is generated that is populated with triggers for database operations performed on the source table for subsequent replay for the target partitions. Data is later moved (e.g., asynchronously moved, etc.) from the source table to the target table. The database operations are replayed on the target table T subsequent to the moving of the data using the replay table. In addition, the source table is dropped when all of the data has been moved to the target table and there are no operations requiring replay. Related apparatus, systems, techniques and articles are also described.

63. 发明授权

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.

64. 发明授权

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.

65. 发明授权

US09465844B2 Unified table query processing 有权
标题翻译：统一表查询处理
公开(公告)号：US09465844B2
公开(公告)日：2016-10-11
申请号：US13843898
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30501 , G06F17/30297 , G06F17/30315 , G06F17/30386 , G06F17/30477 , G06F17/30498
摘要： A system and method of query processing in a multi-level storage system having a unified table architecture. A query is received by a common query execution engine connected with the unified table architecture, the query specifying a data record. The common query execution engine performs a look-up for the data record based on the query at the first level storage structure. If the data record is not present at the first level storage structure, the common query execution engine performs separate look-ups in each of the second level storage structure and the main store.
摘要翻译：具有统一表架构的多级存储系统中的查询处理系统和方法。与统一表架构相连的通用查询执行引擎接收到查询，查询指定数据记录。普通查询执行引擎根据第一级存储结构的查询执行数据记录的查找。如果第一级存储结构中不存在数据记录，则公共查询执行引擎在第二级存储结构和主存储中的每一个中执行单独的查找。

66. 发明申请

US20160147862A1 Delegation of Database Post-Commit Processing 有权
标题翻译：数据库后处理处理委托
公开(公告)号：US20160147862A1
公开(公告)日：2016-05-26
申请号：US14553535
申请日：2014-11-25
申请人： Ivan Schreter , Juchang Lee , Mihnea Andrei
发明人： Ivan Schreter , Juchang Lee , Mihnea Andrei
IPC分类号： G06F17/30
CPC分类号： G06F17/30348
摘要： A plurality of transactions are handled in a database. Each transaction comprises a plurality of operations on at least one record in the database with at least two of the transactions being handled concurrently. Thereafter, a temporary timestamp is assigned to each record that is based, at least in part, on the corresponding transaction. A first transaction among the plurality of transactions is subsequently committed. Afterwards, re-stamping of at least one commit timestamp modified by the first transaction is delegated. Related apparatus, systems, techniques and articles are also described.
摘要翻译：在数据库中处理多个事务。每个事务包括对数据库中的至少一个记录的多个操作，其中至少两个事务被同时处理。此后，至少部分基于对应的事务将每个记录分配临时时间戳。随后提交了多个交易中的第一笔交易。之后，委派对由第一个事务修改的至少一个提交时间戳的重新戳记。还描述了相关设备，系统，技术和物品。

67. 发明申请

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列值进行比较。然后，基于比较，在并行日志重播器中重播复制日志条目。然后，数据库事务通过在事务日志重播器上重播关联的事务提交日志条目来提交给副本表。

68. 发明申请

US20160147617A1 Data Synchronization with Minimal Table Lock Duration in Asynchronous Table Replication 审中-公开
标题翻译：数据同步与异步表复制中的最小表锁持续时间
公开(公告)号：US20160147617A1
公开(公告)日：2016-05-26
申请号：US14657865
申请日：2015-03-13
申请人： Juchang Lee , Joo-Yeon Lee , Kyu-Hwan Kim , Deck-Hoe Kim , Kyungyul Park
发明人： Juchang Lee , Joo-Yeon Lee , Kyu-Hwan Kim , Deck-Hoe Kim , Kyungyul Park
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 minimizing table lock duration during lost change resynchronization between a source table and a replica table. An embodiment operates by detecting a restart at a source node or a replica node. A source table at the source node is then locked based on the detection. A database transaction is then created for a lost change resynchronization operation and the source table is unlocked. The database transaction is then compared to another database transaction based on its timestamp. Based on the comparison, either the database transaction for the lost change resynchronization operation or the other database transaction is executed.
摘要翻译：这里公开了用于在源表和副本表之间的丢失变化重新同步期间最小化表锁持续时间的系统，方法和计算机程序产品实施例。实施例通过检测在源节点或副本节点处的重启来操作。然后源节点上的源表基于检测被锁定。然后为丢失的更改重新同步操作创建数据库事务，并且将源表解锁。然后将数据库事务与其他数据库事务基于其时间戳进行比较。基于比较，执行丢失变更重新同步操作的数据库事务或其他数据库事务。

69. 发明授权

US09009182B2 Distributed transaction management with tokens 有权
标题翻译：使用令牌进行分布式事务管理
公开(公告)号：US09009182B2
公开(公告)日：2015-04-14
申请号：US12898633
申请日：2010-10-05
申请人： Frank Renkes , Juchang Lee
发明人： Frank Renkes , Juchang Lee
IPC分类号： G06F7/00 , G06F17/30
CPC分类号： G06F17/30362 , G06F17/30321 , G06F17/30371
摘要： A system, method and computer product for managing distributed transactions of a database. A transaction manager is provided for each of a plurality of transactions of the database. Each transaction manager is configured to perform functions that include generating a transaction token that specifies data to be visible for a transaction on the database. The database contains both row and column storage engines, and the transaction token includes a transaction identifier (TID) for identifying committed transactions and uncommitted transactions. A last computed transaction is designated with a computed identifier (CID), record-level locking of records of the database is performed using the TID and CID to execute the transaction, and the plurality of transactions of the database are executed with each transaction manager.
摘要翻译：一种用于管理数据库的分布式事务的系统，方法和计算机产品。为数据库的多个事务中的每一个提供事务管理器。每个事务管理器被配置为执行包括生成事务令牌的功能，该事务令牌指定对于数据库上的事务可见的数据。数据库包含行和列存储引擎，并且事务令牌包括用于识别已提交事务和未提交事务的事务标识符（TID）。用计算的标识符（CID）指定最后计算的事务，使用TID和CID来执行数据库的记录级锁定以执行事务，并且与每个事务管理器一起执行数据库的多个事务。

70. 发明申请

US20140136473A1 PARTIAL MERGE 有权
标题翻译：部分合并
公开(公告)号：US20140136473A1
公开(公告)日：2014-05-15
申请号：US13843841
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30321 , G06F17/30339 , G06F17/30483 , G06F17/30592
摘要： A multi-level storage architecture and method of performing a partial merge are disclosed. A main store is partitioned into a passive main part and an active main part, the active main part being empty at a start of the partial merge, the passive main part storing encoded data records of the main store that are not subject to the partial merge. A values index corresponding to a sorted dictionary of the passive main part is set to a cardinality of n. The data records of a second level storage structure is merged into the active main part, the active main part having a dictionary that starts with a value of n+1, such that the merging into the active main part continues an encoding scheme according to the values index of the passive main part.
摘要翻译：公开了一种执行部分合并的多级存储架构和方法。主店分为被动主体和活动主体，主动部分在部分合并开始时为空，被动主体部分存储不存在部分合并的主店铺的编码数据记录。将被动主体的排序词典对应的值索引设为n的基数。第二级存储结构的数据记录被合并到活动主体部分中，活动主体部分具有以n + 1的值开始的字典，使得合并到活动主体部分继续根据被动主体的价值指数。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式