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

71. 发明申请

US20120084273A1 Accelerated Transactions With Precommit-Time Early Lock Release 有权
标题翻译：加速交易与预提早时锁定释放
公开(公告)号：US20120084273A1
公开(公告)日：2012-04-05
申请号：US12898617
申请日：2010-10-05
申请人： Juchang Lee , Frank Renkes , Sangyong Hwang
发明人： Juchang Lee , Frank Renkes , Sangyong Hwang
IPC分类号： G06F17/30
CPC分类号： G06F17/30377 , G06F17/30351 , G06F17/30362 , G06F17/30445
摘要： A system, method and computer product for accelerating parallel database transactions. One or more data processors execute a first transaction on a database. The first transaction includes a transactional lock associated with each of one or more records to update the one or more records during the first transaction, and a pre-commit command to request acknowledgement of committing the updating of the one or more records during the first transaction. The one or more data processors execute a second transaction on the database in parallel with the first transaction. The second transaction includes a transactional lock associated with each of one or more records to update the one or more records during the second transaction, and a pre-commit command to request acknowledgement of committing the updating of the one or more records during the second transaction. The transactional locks of the first and second transactions are released before flushing log records associated with the first and second transactions.
摘要翻译：一种用于加速并行数据库事务的系统，方法和计算机产品。一个或多个数据处理器在数据库上执行第一个事务。第一事务包括与一个或多个记录中的每一个相关联的事务锁，以在第一事务期间更新一个或多个记录;以及预提交命令，用于在第一个事务期间请求确认提交一个或多个记录的更新。一个或多个数据处理器与第一事务并行地执行数据库上的第二事务。第二事务包括与一个或多个记录中的每一个相关联的事务锁，以在第二事务期间更新一个或多个记录;以及预提交命令，用于在第二次事务期间请求确认提交一个或多个记录的更新。在刷新与第一和第二事务相关联的日志记录之前，释放第一和第二事务的事务锁。

72. 发明授权

US10191765B2 Transaction commit operations with thread decoupling and grouping of I/O requests 有权
公开(公告)号：US10191765B2
公开(公告)日：2019-01-29
申请号：US14255807
申请日：2014-04-17
申请人： Kyu Hwan Kim , Juchang Lee
发明人： Kyu Hwan Kim , Juchang Lee
IPC分类号： G06F17/30 , G06F9/46 , G06F3/06
摘要： Innovations in the area of server-side processing when committing transactions to disk in a distributed database system can improve computational efficiency at database nodes and/or reduce network bandwidth utilization. For example, when transactions are committed in a database system, at a master node of the database system, a server uses different threads for certain processor-intensive operations and certain I/O-intensive operations. Or, as another example, when transactions are committed in a database system, at a master node of the database system, a server groups jobs for I/O requests.

73. 发明授权

US10127260B2 In-memory database system providing lockless read and write operations for OLAP and OLTP transactions 有权
公开(公告)号：US10127260B2
公开(公告)日：2018-11-13
申请号：US14553950
申请日：2014-11-25
申请人： Anil Kumar Goel , Ivan Schreter , Juchang Lee , Mihnea Andrei , Steffen Geissinger , Thomas Legler
发明人： Anil Kumar Goel , Ivan Schreter , Juchang Lee , Mihnea Andrei , Steffen Geissinger , Thomas Legler
IPC分类号： G06F17/30 , G06F3/06
摘要： As part of a database system comprising a combination of on-disk storage and in-memory storage, a plurality of records that comprise a table are stored in a plurality of fragments that include at least a delta fragment and a main fragment retained in the on-disk storage. Each fragment has visibility data structures to enable multi-version concurrency control. Each fragment can be compressed using dictionary compression and n-bits compression. The fragments are loaded into main system memory in the in-memory storage from the on-disk storage if they are accessed for read operations or write operations and are not already in memory. A plurality of lockless read and write operations are concurrently performed, while providing snapshot isolation, on the at least one of the plurality of fragments while the at least one of the plurality of fragments is in the main system memory.

74. 发明授权

US09635093B2 Slave side transaction ID buffering for efficient distributed transaction management 有权
公开(公告)号：US09635093B2
公开(公告)日：2017-04-25
申请号：US13763920
申请日：2013-02-11
申请人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
发明人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
IPC分类号： G06F15/16 , H04L29/08 , G06F17/30
CPC分类号： H04L67/10 , 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, upon a receipt of a request for a write transaction at a slave server it is determined whether there exists an unassigned transaction identifier (TID) stored locally at the slave server as provided by a master server to the slave server prior to the receipt of the write request by the slave server. If there exists an unassigned TID at the slave server, the slave server is configured to assign the unassigned TID to the write transaction, otherwise the slave server is configured to request a plurality of unassigned TIDs from the master server, receive the plurality of unassigned TIDs, and assign one of the received unassigned TIDs to the write transaction. The write transaction is processed.

75. 发明申请

US20160147861A1 Database System With Transaction Control Block Index 有权
标题翻译：具有事务控制块索引的数据库系统
公开(公告)号：US20160147861A1
公开(公告)日：2016-05-26
申请号：US14553494
申请日：2014-11-25
申请人： Ivan Schreter , Juchang Lee , Mihnea Andrei
发明人： Ivan Schreter , Juchang Lee , Mihnea Andrei
IPC分类号： G06F17/30
CPC分类号： G06F17/30592 , G06F17/30353
摘要： A plurality of transactions is handled in a database. Each transaction includes 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. The temporary timestamp are based, at least in part, on the corresponding transaction. Further, a final timestamp is assigned to each record with a commit operation. It can later be determined, using a visibility function and based on the assigned temporary timestamps and final timestamps, which of the records are visible in a consistent view for a first transaction. Based on such determination, access can be provided to those records determined to be visible to be accessed to the first transaction.
摘要翻译：在数据库中处理多个事务。每个事务包括在数据库中的至少一个记录上的多个操作，其中至少两个事务被同时处理。此后，将临时时间戳分配给每个记录。临时时间戳至少部分地基于相应的事务。此外，通过提交操作将最终时间戳分配给每个记录。稍后可以使用可见性功能并基于分配的临时时间戳和最终时间戳来确定哪个记录在第一个事务的一致视图中可见。基于这样的确定，可以向确定为可见以被访问到第一交易的那些记录提供访问。

76. 发明申请

US20160147821A1 Supporting Cursor Snapshot Semantics 有权
标题翻译：支持光标快照语义
公开(公告)号：US20160147821A1
公开(公告)日：2016-05-26
申请号：US14553790
申请日：2014-11-25
申请人： Ivan Schreter , Juchang Lee
发明人： Ivan Schreter , Juchang Lee
IPC分类号： G06F17/30 , G06F9/46
CPC分类号： G06F17/30371
摘要： A database upon opening each of at least one cursor for a transaction, assigns each statement forming part of a transaction a statement sequence number (SSN) involving at least one row of the database. Thereafter, temporary timestamps are assigned to the at least one row using a transaction identifier and the corresponding SSN. Further, active cursors are monitored such that a final timestamp is prevented from being associated with each row until it has no remaining cursors. Related apparatus, systems, techniques and articles are also described.
摘要翻译：数据库在打开事务的至少一个游标中的每一个时，分配构成事务的每个语句的涉及数据库的至少一行的语句序列号（SSN）。此后，使用事务标识符和对应的SSN将临时时间戳分配给至少一行。此外，监视活动光标，使得最终时间戳被阻止与每行相关联，直到其没有剩余的游标。还描述了相关设备，系统，技术和物品。

77. 发明授权

US09171020B2 Deleting records in a multi-level storage architecture 有权
标题翻译：删除多级存储架构中的记录
公开(公告)号：US09171020B2
公开(公告)日：2015-10-27
申请号：US13844070
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30303 , G06F17/30289 , G06F17/30306 , G06F17/30315 , G06F17/30345 , G06F17/30371
摘要： Deleting a data record from the second level storage or main store is disclosed. A look-up is performed for the data record in the first level storage, where the data record is defined by a row identifier. If the row identifier is found in the first level storage, a look-up is performed for an updated row identifier representing an update of the data record in the second level storage and the main store, the update of the data record being defined by an updated row identifier. If the updated row identifier is found in the second level storage, an undo log is generated from the first level storage to invalidate a row identifier of the row identifier. A flag is generated representing an invalid updated row identifier, and a redo log is generated to restore the data record in the first level storage.
摘要翻译：公开了从第二级存储或主存储器中删除数据记录。对第一级存储器中的数据记录执行查找，其中数据记录由行标识符定义。如果在第一级存储器中找到行标识符，则对表示第二级存储器和主存储器中的数据记录的更新的更新行标识符执行查找，数据记录的更新由更新的行标识符。如果在第二级存储器中找到更新的行标识符，则从第一级存储器生成撤销日志以使行标识符的行标识符无效。生成表示无效的更新行标识符的标志，并且生成重做日志以恢复第一级存储器中的数据记录。

78. 发明申请

US20150178343A1 Distributed Transaction Management With Tokens 审中-公开
标题翻译：具有令牌的分布式事务管理
公开(公告)号：US20150178343A1
公开(公告)日：2015-06-25
申请号：US14642941
申请日：2015-03-10
申请人： Frank Renkes , Juchang Lee
发明人： Frank Renkes , Juchang Lee
IPC分类号： 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来执行数据库的记录级锁定以执行事务，并且与每个事务管理器一起执行数据库的多个事务。

79. 发明授权

US08935205B2 System and method of performing snapshot isolation in distributed databases 有权
标题翻译：在分布式数据库中执行快照隔离的系统和方法
公开(公告)号：US08935205B2
公开(公告)日：2015-01-13
申请号：US13298048
申请日：2011-11-16
申请人： Stefan Hildenbrand , Carsten Binnig , Franz Faerber , Donald Kossmann , Juchang Lee , Norman May
发明人： Stefan Hildenbrand , Carsten Binnig , Franz Faerber , Donald Kossmann , Juchang Lee , Norman May
IPC分类号： G06F17/30
CPC分类号： G06F17/30351
摘要： A system and method of performing snapshot isolation in distributed databases. Each node stores local snapshot information that enforces snapshot isolation for that node. The method includes partially processing a distributed transaction by a first node, receiving a global commit identifier from a coordinator, and continuing to process the distributed transaction, by the first node and a second node, in accordance with the global commit identifier.
摘要翻译：在分布式数据库中执行快照隔离的系统和方法。每个节点存储强制该节点的快照隔离的本地快照信息。该方法包括由第一节点部分地处理分布式事务，从协调器接收全局提交标识符，并且依照全局提交标识符继续由第一节点和第二节点处理分布式事务。

80. 发明申请

US20140149527A1 Slave Side Transaction ID Buffering for Efficient Distributed Transaction Management 有权
标题翻译：从属端事务ID缓存用于高效的分布式事务管理
公开(公告)号：US20140149527A1
公开(公告)日：2014-05-29
申请号：US13763920
申请日：2013-02-11
申请人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
发明人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
IPC分类号： H04L29/08
CPC分类号： H04L67/10 , 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, upon a receipt of a request for a write transaction at a slave server it is determined whether there exists an unassigned transaction identifier (TID) stored locally at the slave server as provided by a master server to the slave server prior to the receipt of the write request by the slave server. If there exists an unassigned TID at the slave server, the slave server is configured to assign the unassigned TID to the write transaction, otherwise the slave server is configured to request a plurality of unassigned TIDs from the master server, receive the plurality of unassigned TIDs, and assign one of the received unassigned TIDs to the write transaction. The write transaction is processed.
摘要翻译：公开了由用于提供交易令牌的压缩表示的一个或多个处理器执行的计算机程序编码的方法，系统和计算机可读存储介质。在一个实施例中，在从属服务器接收到写入事务的请求时，确定是否存在在主服务器本地存储在从服务器处的本地存储的未分配事务标识符（TID）从服务器接收写请求。如果在从服务器处存在未分配的TID，则从服务器被配置为将未分配的TID分配给写事务，否则从服务器被配置为从主服务器请求多个未分配的TID，接收多个未分配的TID 并将所接收的未分配的TID中的一个分配给写入事务。处理写事务。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式