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

41. 发明申请

US20150149413A1 CLIENT-SIDE PARTITION-AWARE BATCHING OF RECORDS FOR INSERT OPERATIONS 有权
标题翻译：客户端分配 - 插入操作记录的记录
公开(公告)号：US20150149413A1
公开(公告)日：2015-05-28
申请号：US14271218
申请日：2014-05-06
申请人： Chul Won Lee , Juchang Lee , Alexander Schroeder , Myunggon Park , Sang Kyun Cha
发明人： Chul Won Lee , Juchang Lee , Alexander Schroeder , Myunggon Park , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30345 , G06F17/3038
摘要： Client-side partition-aware batch insert operations are presented. For example, a server generates partition metadata, which is provided to a client. The client uses the partition metadata to determine the database nodes to which to send batch insert requests. For example, the client divides batch insert data, such as records for a partitioned table, among multiple database nodes having partitions of the table. The client issues batch insert requests to the respective database nodes for execution. When executed by the database nodes, batch insert operations can be performed in parallel.
摘要翻译：介绍了客户端分区感知批量插入操作。例如，服务器生成提供给客户端的分区元数据。客户端使用分区元数据来确定要向其发送批量插入请求的数据库节点。例如，客户端在具有表分区的多个数据库节点之间划分批量插入数据，例如分区表的记录。客户端向相应的数据库节点发出批量插入请求以执行。当数据库节点执行时，可以并行执行批量插入操作。

42. 发明申请

US20140136788A1 Deleting Records In A Multi-Level Storage Architecture Without Record Locks 审中-公开
标题翻译：在没有记录锁的多级存储架构中删除记录
公开(公告)号：US20140136788A1
公开(公告)日：2014-05-15
申请号：US13844044
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F12/12
CPC分类号： G06F12/128 , G06F17/30315 , G06F17/30345
摘要： The multi-level storage system and method of deleting first level storage structure pages or records without record locks. The method includes determining whether a record to be deleted from the first level storage structure has any uncommitted write operation, and if the record has an uncommitted write operation, the record is kept in the first level storage structure. Record-moved version information is added to the record to designate the record being moved from the first level storage structure to the second level storage structure. Data change operations are executed for the record based on the record-moved version information without waiting until the record's movement from the first level storage structure to the second level storage structure finishes.
摘要翻译：多级存储系统和删除第一级存储结构页面或记录的方法，无记录锁。该方法包括确定要从第一级存储结构中删除的记录是否具有任何未提交的写入操作，并且如果记录具有未提交的写入操作，则将记录保存在第一级存储结构中。记录移动的版本信息被添加到记录中以指定从第一级存储结构移动到第二级存储结构的记录。基于记录移动的版本信息对记录执行数据更改操作，而不等待直到记录从第一级存储结构向第二级存储结构的移动结束。

43. 发明申请

US20130290282A1 Logless Atomic Data Movement 有权
标题翻译：无原则数据运动
公开(公告)号：US20130290282A1
公开(公告)日：2013-10-31
申请号：US13843986
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , G06F3/0604 , G06F3/0638 , G06F3/0644 , G06F3/0647 , G06F3/065 , G06F3/0652 , G06F3/0673 , G06F3/0683 , G06F17/30117 , G06F17/30153 , G06F17/30315 , G06F17/30348 , G06F17/30377 , G06F17/30575 , G06F17/30587
摘要： A system and method of logless atomic data movement. An internal transaction is started within a multi-level storage architecture, the internal transaction to merge data from the first level storage structure to the second level storage structure. Committed data is read from a first level storage structure of the multi-level storage architecture as specified by the internal transaction. The committed data from the first level storage structure is inserted into a second level storage structure in a bulk insertion process, and the committed data is marked as being deleted from the first level storage. The internal transaction is then committed to the multi-level storage architecture when the committed data has been inserted into the second level storage structure.
摘要翻译：无原子数据运动的系统和方法。内部事务在多级存储架构内启动，内部事务将数据从第一级存储结构合并到第二级存储结构。从内部事务指定的多级存储架构的第一级存储结构读取提交的数据。来自第一级存储结构的提交的数据被插入到批量插入过程中的第二级存储结构中，并且所提交的数据被标记为从第一级存储器中删除。当提交的数据已插入到第二级存储结构中时，内部事务将被提交到多级存储架构。

44. 发明申请

US20130275468A1 CLIENT-SIDE CACHING OF DATABASE TRANSACTION TOKEN 审中-公开
标题翻译：客户端数据库交易托盘的缓存
公开(公告)号：US20130275468A1
公开(公告)日：2013-10-17
申请号：US13449099
申请日：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分类号： G06F16/2329
摘要： A system includes reception of a first query of a first transaction from a client device at a first database node of a database instance comprising two or more database nodes, request of a first transaction token associated with the first transaction from a second database node of the two or more database nodes, reception of the first transaction token from the second database node at the first database node, execution of the first query at the first database node to generate first results, and transmission of the first results and the first transaction token from the first database node to the client device.
摘要翻译：系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一事务的第一查询，与第一事务相关联的第一事务令牌与第一事务的请求相关联的第二数据库节点两个或多个数据库节点，从第一数据库节点处的第二数据库节点接收第一事务令牌，在第一数据库节点处执行第一查询以生成第一结果，以及将第一结果和第一交易令牌从客户端设备的第一个数据库节点。

45. 发明申请

US20130166534A1 Hybrid Database Table Stored as Both Row and Column Store 有权
公开(公告)号：US20130166534A1
公开(公告)日：2013-06-27
申请号：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.

46. 发明申请

US20120166407A1 Distributed Transaction Management Using Two-Phase Commit Optimization 有权
标题翻译：使用两阶段提交优化的分布式事务管理
公开(公告)号：US20120166407A1
公开(公告)日：2012-06-28
申请号：US12980178
申请日：2010-12-28
申请人： Juchang Lee , Michael Muehle
发明人： Juchang Lee , Michael Muehle
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , 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.
摘要翻译：提供了计算机实现的方法，计算机可读介质和系统。提供了数据库的多个事务中的每一个的事务主体。每个事务主机被配置为与至少一个事务从属单元通信以管理多个事务中的事务的执行。每个事务主机被配置为执行生成事务令牌以指定对数据库上的事务可见的数据，该事务令牌包括用于识别事务是提交的事务还是未提交事务的事务标识符，接收请求以提交事务，根据请求发起一个两阶段提交操作来提交事务。两阶段提交操作包括准备提交事务，将提交的事务写入存储器，通过省略两阶段提交操作的阶段来优化两阶段提交操作，生成已提交事务的确认。数据库的多个事务与每个事务主机一起执行。

47. 发明申请

US20120084274A1 Distributed Transaction Management With Tokens 有权
标题翻译：具有令牌的分布式事务管理
公开(公告)号：US20120084274A1
公开(公告)日：2012-04-05
申请号：US12898633
申请日：2010-10-05
申请人： 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来执行数据库的记录级锁定以执行事务，并且与每个事务管理器一起执行数据库的多个事务。

48. 发明授权

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.

49. 发明授权

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.

50. 发明授权

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.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式