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

11. 发明授权

US08768927B2 Hybrid database table stored as both row and column store 有权
公开(公告)号：US08768927B2
公开(公告)日：2014-07-01
申请号：US13334669
申请日：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/30424 , G06F17/30312 , G06F17/30371 , G06F17/30584
摘要： 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.

12. 发明申请

US20130304714A1 Distributed Transaction Management Using Two-Phase Commit Optimization 审中-公开
标题翻译：使用两阶段提交优化的分布式事务管理
公开(公告)号：US20130304714A1
公开(公告)日：2013-11-14
申请号：US13869263
申请日：2013-04-24
申请人： Juchang Lee , Michael Muehle
发明人： Juchang Lee , Michael Muehle
IPC分类号： G06F17/30
CPC分类号： G06F16/2365 , G06F9/466
摘要： A computer-implemented method, a computer-readable medium and a system are provided. A transaction master for each of a plurality of transactions of a database is provided. Each transaction master is configured to communicate with at least one transaction slave to manage execution of a transaction in the plurality of transactions. Each transaction master configured to perform generating a transaction token to specify data to be visible for a transaction on the database, the transaction token including a transaction identifier for identifying whether the transaction is a committed transaction or an uncommitted transaction, receiving a request to commit the transaction, initiating, based on the request, a two-phase commit operation to commit the transaction. The two-phase commit operation includes preparing for committing the transaction, writing a committed transaction to a memory, optimizing the two-phase commit operation by omitting a phase of the two-phase commit operation, generating an acknowledgement of the committed transaction. The plurality of transactions of the database are executed with each transaction master.
摘要翻译：提供了计算机实现的方法，计算机可读介质和系统。提供了数据库的多个事务中的每一个的事务主体。每个事务主机被配置为与至少一个事务从属单元通信以管理多个事务中的事务的执行。每个事务主机被配置为执行生成事务令牌以指定对数据库上的事务可见的数据，该事务令牌包括用于识别事务是提交的事务还是未提交事务的事务标识符，接收请求以提交事务，根据请求发起一个两阶段提交操作来提交事务。两阶段提交操作包括准备提交事务，将提交的事务写入存储器，通过省略两阶段提交操作的阶段来优化两阶段提交操作，生成已提交事务的确认。数据库的多个事务与每个事务主机一起执行。

13. 发明申请

US20130275467A1 CLIENT-SIDE STATEMENT ROUTING IN DISTRIBUTED DATABASE 有权
标题翻译：分布式数据库中的客户端声明路由
公开(公告)号：US20130275467A1
公开(公告)日：2013-10-17
申请号：US13449044
申请日：2012-04-17
申请人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
发明人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30545 , G06F17/30477
摘要： A system includes reception of a first query from a client device at a first database node of a database instance comprising two or more database nodes, determination of a second database node of the two or more database nodes associated with the first query, compilation of the first query at the first database node to generate first compiled code, and transmission of the first compiled code and a first identifier of the second database node from the first database node to the client device.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的两个或多个数据库节点的第二数据库节点，在第一数据库节点处首先查询以生成第一编译代码，以及将第一编译代码和第二数据库节点的第一标识符从第一数据库节点传输到客户端设备。

14. 发明申请

US20130275457A1 CLIENT-SIDE STATEMENT ROUTING FOR PARTITIONED TABLES 有权
标题翻译：用于分类表的客户端声明路由
公开(公告)号：US20130275457A1
公开(公告)日：2013-10-17
申请号：US13449063
申请日：2012-04-17
申请人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
发明人： Juchang Lee , Jaeyun Noh , Chulwon Lee , Michael Muehle , Alexander Schroeder , Marco Paskamp , Sang Kyun Cha
IPC分类号： G06F17/30 , G06F15/16
CPC分类号： G06F17/30545
摘要： A system includes reception of a first query from a client device at a first database node of a database instance comprising two or more database nodes, the first query specifying a first database table which is partitioned among two or more of the two or more database nodes, determination of first partitioning metadata of the first database table, the first partitioning metadata usable to identify one of the two or more database nodes based on table key values, compilation of the first query at the first database node to generate first compiled code, and transmission of the first compiled code and the first partitioning metadata from the first database node to the client device.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，第一查询指定在两个或多个数据库节点中的两个或更多个数据库节点之间划分的第一数据库表确定所述第一数据库表的第一分区元数据，所述第一分区元数据可用于基于表键值识别所述两个或多个数据库节点中的一个，所述第一数据库节点处的第一查询的编译以生成第一编译代码;以及将第一编译代码和第一分区元数据从第一数据库节点传输到客户端设备。

15. 发明申请

US20130124475A1 System and Method of Performing Snapshot Isolation in Distributed Databases 有权
标题翻译：在分布式数据库中执行快照隔离的系统和方法
公开(公告)号：US20130124475A1
公开(公告)日：2013-05-16
申请号：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.
摘要翻译：在分布式数据库中执行快照隔离的系统和方法。每个节点存储强制该节点的快照隔离的本地快照信息。该方法包括：通过第一节点部分地处理分布式事务，从协调器接收全局提交标识符，并且依照全局提交标识符继续由第一节点和第二节点处理分布式事务。

16. 发明授权

US10185737B2 Distributed transaction management with tokens 有权
公开(公告)号：US10185737B2
公开(公告)日：2019-01-22
申请号：US14642941
申请日：2015-03-10
申请人： Frank Renkes , Juchang Lee
发明人： Frank Renkes , Juchang Lee
IPC分类号： G06F17/30
摘要： 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.

17. 发明授权

US10042910B2 Database table re-partitioning using two active partition specifications 有权
公开(公告)号：US10042910B2
公开(公告)日：2018-08-07
申请号：US14188541
申请日：2014-02-24
申请人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
发明人： Christian Bensberg , Lars Fricke , Juchang Lee , Michael Muehle , Thomas Peh , Wolfgang Stephan
IPC分类号： G06F17/30
摘要： Partitioning of source partitions of a table of a database to target partitions is initiated. Thereafter, a transition partition specification is specified that identifies the source partitions and the target partitions. Data is then moved (e.g., asynchronously moved, etc.) from the source partitions to the target partitions. Concurrently with the moving of the data, operates are handled using the transition partition specification. Subsequently, the source partitions are dropped when all of the data has been moved to the target partitions and there are no open transactions accessing the source partitions. Related apparatus, systems, techniques and articles are also described.

18. 发明授权

US09965513B2 Set-orientated visibility state retrieval scheme 有权
公开(公告)号：US09965513B2
公开(公告)日：2018-05-08
申请号：US14553226
申请日：2014-11-25
申请人： Juchang Lee , Mihnea Andrei , Colin Florendo , Ivan Schreter , Anil Kumar Goel
发明人： Juchang Lee , Mihnea Andrei , Colin Florendo , Ivan Schreter , Anil Kumar Goel
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30339 , G06F17/30345 , G06F17/30353 , G06F17/30548
摘要： Disclosed herein are system, method, and computer program product embodiments for determining row visibility states. An embodiment operates by initializing a result bitmap for rows based on visible row state values of row state bitmaps corresponding to the rows, wherein values of the result bitmap indicate whether the row are visible or not visible; determining one or more rows whose corresponding visible row state values indicate that the one or more rows are not visible; and determining whether to update the result bitmap to indicate that the one or more rows are visible based on one or more versioned row state values, wherein the one or more versioned row state values indicate whether the corresponding rows are not visible or possibly visible.

19. 发明授权

US09792318B2 Supporting cursor snapshot semantics 有权
公开(公告)号：US09792318B2
公开(公告)日：2017-10-17
申请号：US14553790
申请日：2014-11-25
申请人： Ivan Schreter , Juchang Lee , Changgyoo Park , Michael Muehle
发明人： Ivan Schreter , Juchang Lee , Changgyoo Park , Michael Muehle
IPC分类号： G06F7/00 , G06F17/30 , G06F13/14
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.

20. 发明申请

US20160147814A1 In-Memory Database System Providing Lockless Read and Write Operations for OLAP and OLTP Transactions 审中-公开
标题翻译：内存数据库系统为OLAP和OLTP交易提供无锁读写操作
公开(公告)号：US20160147814A1
公开(公告)日：2016-05-26
申请号：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
CPC分类号： G06F17/30383 , G06F3/0619 , G06F3/0665 , G06F3/0689 , G06F17/30008 , G06F17/30171 , G06F17/30309 , G06F17/30348 , G06F17/30353 , G06F17/30356 , G06F17/30359 , G06F17/30368 , G06F17/30575 , G06F17/30592
摘要： 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.
摘要翻译：作为包括磁盘存储和内存存储的组合的数据库系统的一部分，包括表的多个记录被存储在多个片段中，该多个片段至少包括一个delta片段和保存在on上的主片段磁盘存储。每个片段具有可见性数据结构，以实现多版本并发控制。可以使用字典压缩和n位压缩来压缩每个片段。如果对于读取操作或写入操作进行访问，并且尚未存储在内存中，这些碎片将从磁盘存储器加载到内存中的主系统内存中。同时执行多个无锁读取和写入操作，同时在多个片段中的至少一个片段上提供快照隔离，同时多个片段中的至少一个片段在主系统存储器中。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式