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

51. 发明授权

US09720992B2 DML replication with logical log shipping 有权
公开(公告)号：US09720992B2
公开(公告)日：2017-08-01
申请号：US14302320
申请日：2014-06-11
申请人： Joo Yeon Lee , Juchang Lee , Kyu Hwan Kim , Chul Won Lee , Yong Sik Kwon , Sang Kyun Cha
发明人： Joo Yeon Lee , Juchang Lee , Kyu Hwan Kim , Chul Won Lee , Yong Sik Kwon , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30575
摘要： Technologies are described for performing replication within a database environment. For example, replication of database data can be performed using data manipulation language (DML) statements and logical logs. A database node can execute a DML statement, create a logical log comprising the DML statement, and insert the logical log into a logical log queue. The logical log can be sent to one or more other database nodes for execution of the DML statement stored within the logical log. Logical logs can be grouped for sending to other nodes. Logical logs can be executed on a first node and one or more other nodes within the same transaction boundary. Execution of DML statements can be decoupled from sending, receiving, grouping, and/or processing of logical logs.

52. 发明授权

US09558229B2 Transaction private log buffering for high performance of transaction processing 有权
标题翻译：事务处理专用日志缓存，用于高性能的事务处理
公开(公告)号：US09558229B2
公开(公告)日：2017-01-31
申请号：US14244686
申请日：2014-04-03
申请人： Juchang Lee , Beomsoo Kim , Kyu Hwan Kim , Jaeyun Noh , Sang Kyun Cha
发明人： Juchang Lee , Beomsoo Kim , Kyu Hwan Kim , Jaeyun Noh , Sang Kyun Cha
IPC分类号： G06F12/08 , G06F17/30 , G06F9/46
CPC分类号： G06F17/30368 , G06F9/466 , G06F12/08 , G06F2206/1014
摘要： For each data change occurring transaction created as part of a write operation initiated for one or more tables in a main-memory-based DBMS, a transaction log entry can be written to a private log buffer corresponding to the transaction. All transaction log entries in the private log buffer can be flushed to a global log buffer upon completion of the transaction to which the private log buffer corresponds.
摘要翻译：对于作为在基于主内存的DBMS中的一个或多个表启动的写入操作的一部分而创建的每个数据更改发生的事务，事务日志条目可以写入对应于事务的专用日志缓冲区。专用日志缓冲区中的所有事务日志条目可以在私有日志缓冲区对应的事务完成后刷新到全局日志缓冲区。

53. 发明授权

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.
摘要翻译：具有统一表架构的多级存储系统中的查询处理系统和方法。与统一表架构相连的通用查询执行引擎接收到查询，查询指定数据记录。普通查询执行引擎根据第一级存储结构的查询执行数据记录的查找。如果第一级存储结构中不存在数据记录，则公共查询执行引擎在第二级存储结构和主存储中的每一个中执行单独的查找。

54. 发明授权

US09465843B2 Hybrid database table stored as both row and column store 有权
标题翻译：混合数据库表存储为行和列存储
公开(公告)号：US09465843B2
公开(公告)日：2016-10-11
申请号：US14543022
申请日：2014-11-17
申请人： Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
发明人： Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30345 , G06F17/30312 , G06F17/30339 , G06F17/30442 , G06F17/30466 , G06F17/30477 , G06F17/30584 , G06F17/30867
摘要： A hybrid database table is stored as both a row and a column store. One or more techniques may be employed alone or in combination to enhance performance of the hybrid table by regulating access to, and/or the size of, the processing-intensive column store data. For example during an insert operation, the column store data may be searched for a uniqueness violation only after certain filtering and/or boundary conditions have been considered. In another technique, a hybrid table manager may control movement of data to the column store based upon considerations such as frequency of access, or underlying business logic. In still another technique, querying of the hybrid table may result in a search of the column store data only after an initial search of row store data fails to return a result.
摘要翻译：混合数据库表存储为行和列存储。可以单独使用或组合使用一种或多种技术，以通过调节处理密集型列存储数据的访问和/或大小来增强混合表的性能。例如，在插入操作期间，只有在考虑了某些过滤和/或边界条件之后，才能搜索列存储数据以获得唯一性违规。在另一技术中，混合表管理器可以基于诸如访问频率或基础业务逻辑等考虑来控制数据到列存储的移动。在另一种技术中，对混合表的查询可以仅在行存储数据的初始搜索不能返回结果之后才能搜索列存储数据。

55. 发明申请

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.
摘要翻译：在数据库中处理多个事务。每个事务包括对数据库中的至少一个记录的多个操作，其中至少两个事务被同时处理。此后，至少部分基于对应的事务将每个记录分配临时时间戳。随后提交了多个交易中的第一笔交易。之后，委派对由第一个事务修改的至少一个提交时间戳的重新戳记。还描述了相关设备，系统，技术和物品。

56. 发明申请

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

57. 发明申请

US20160147813A1 DISTRIBUTED TRANSACTION COMMIT PROTOCOL 审中-公开
标题翻译：分布式交易委托协议
公开(公告)号：US20160147813A1
公开(公告)日：2016-05-26
申请号：US14656280
申请日：2015-03-12
申请人： Juchang LEE , Changgyoo PARK
发明人： Juchang LEE , Changgyoo PARK
IPC分类号： G06F17/30
CPC分类号： G06F16/2322 , G06F16/128 , G06F16/2365
摘要： Disclosed herein are system, method, and computer program product embodiments for implementing a distributed transaction commit protocol with low latency read and write transactions. An embodiment operates by first receiving a transaction, distributed across partial transactions to be processed at respective cohort nodes, from a client at a coordinator node. The coordinator node requests the cohort nodes to prepare to commit respective partial transactions. Upon receiving prepare commit results, the coordinator node generates a global commit timestamp for the transaction. Coordinator node then simultaneously sends the global commit timestamp to the cohort nodes and commit the transaction to a coordinator disk storage. Upon receiving both sending results from the cohort nodes and a committing result from the coordinator disk storage, the coordinator node provides a transaction commit result of the transaction to the client.
摘要翻译：本文公开了用于实现具有低延迟读写事务的分布式事务提交协议的系统，方法和计算机程序产品实施例。实施例通过首先从协调器节点处的客户端接收分布在要在各个队列节点处处理的部分事务的事务。协调器节点请求队列节点准备提交相应的部分事务。在收到准备提交结果后，协调器节点为事务生成一个全局提交时间戳。协调器节点然后同时将全局提交时间戳发送到队列节点，并将事务提交给协调器磁盘存储。在从队列节点接收到发送结果和协调器磁盘存储的提交结果时，协调器节点向客户端提供事务的事务提交结果。

58. 发明申请

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.
摘要翻译：这里公开了用于在源表和副本表之间的丢失变化重新同步期间最小化表锁持续时间的系统，方法和计算机程序产品实施例。实施例通过检测在源节点或副本节点处的重启来操作。然后源节点上的源表基于检测被锁定。然后为丢失的更改重新同步操作创建数据库事务，并且将源表解锁。然后将数据库事务与其他数据库事务基于其时间戳进行比较。基于比较，执行丢失变更重新同步操作的数据库事务或其他数据库事务。

59. 发明授权

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来执行数据库的记录级锁定以执行事务，并且与每个事务管理器一起执行数据库的多个事务。

60. 发明授权

US08918436B2 Hybrid database table stored as both row and column store 有权
标题翻译：混合数据库表存储为行和列存储
公开(公告)号：US08918436B2
公开(公告)日：2014-12-23
申请号：US13334711
申请日：2011-12-22
申请人： Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
发明人： Yongsik Yoon , Chanho Jeong , Juchang Lee , Chang Bin Song , Yong Sik Kwon , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30345 , G06F17/30312 , G06F17/30339 , G06F17/30442 , G06F17/30466 , G06F17/30477 , G06F17/30584 , G06F17/30867
摘要： A hybrid database table is stored as both a row and a column store. One or more techniques may be employed alone or in combination to enhance performance of the hybrid table by regulating access to, and/or the size of, the processing-intensive column store data. For example during an insert operation, the column store data may be searched for a uniqueness violation only after certain filtering and/or boundary conditions have been considered. In another technique, a hybrid table manager may control movement of data to the column store based upon considerations such as frequency of access, or underlying business logic. In still another technique, querying of the hybrid table may result in a search of the column store data only after an initial search of row store data fails to return a result.
摘要翻译：混合数据库表存储为行和列存储。可以单独使用或组合使用一种或多种技术，以通过调节处理密集型列存储数据的访问和/或大小来增强混合表的性能。例如，在插入操作期间，只有在考虑了某些过滤和/或边界条件之后，才能搜索列存储数据以获得唯一性违规。在另一技术中，混合表管理器可以基于诸如访问频率或基础业务逻辑等考虑来控制数据到列存储的移动。在另一种技术中，对混合表的查询可以仅在行存储数据的初始搜索不能返回结果之后才能搜索列存储数据。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式