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

11. 发明授权

US10452640B2 Distributed transaction management using two-phase commit optimization 有权
公开(公告)号：US10452640B2
公开(公告)日：2019-10-22
申请号：US13869263
申请日：2013-04-24
申请人： Juchang Lee , Michael Muehle
发明人： Juchang Lee , Michael Muehle
IPC分类号： G06F17/30 , G06F16/23 , G06F9/46
摘要： 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.

12. 发明授权

US09098522B2 Version garbage collection using snapshot lists 有权
标题翻译：使用快照列表的版本垃圾回收
公开(公告)号：US09098522B2
公开(公告)日：2015-08-04
申请号：US13750204
申请日：2013-01-25
申请人： Juchang Lee , Chang Gyoo Park , Yongjae Chuh , Jaeyun Noh , Michael Muehle
发明人： Juchang Lee , Chang Gyoo Park , Yongjae Chuh , Jaeyun Noh , Michael Muehle
IPC分类号： G06F17/30
CPC分类号： G06F17/3015 , G06F17/3023 , G06F17/30353 , G06F17/30356
摘要： Systems, methods and computer program product embodiments for providing version garbage collection using snapshot lists are disclosed herein. Version garbage collection using snapshot lists includes storing, by at least one processor, versions of a record in a database table, the record comprising a record value and a version timestamp, storing, by the at least one processor, active snapshots in two levels of active snapshot lists, an active snapshot comprising a transaction identifier and a snapshot timestamp, determining, by the at least one processor, a minimum active snapshot from the active snapshots in the two levels of active snapshot lists and deleting, by the at least one processor, versions of the record having a version timestamp earlier than a snapshot timestamp of the minimum active snapshot.
摘要翻译：本文公开了使用快照列表提供版本垃圾收集的系统，方法和计算机程序产品实施例。使用快照列表的版本垃圾收集包括通过至少一个处理器存储数据库表中的记录的版本，所述记录包括记录值和版本时间戳，由所述至少一个处理器存储两个级别的活动快照活动快照列表，包括事务标识符和快照时间戳的活动快照，由所述至少一个处理器确定所述两个活动快照列表中的活动快照中的最小主动快照，并且由所述至少一个处理器，该记录的版本的版本时间戳早于最小主动快照的快照时间戳。

13. 发明申请

US20130290665A1 STORING LARGE OBJECTS ON DISK AND NOT IN MAIN MEMORY OF AN IN-MEMORY DATABASE SYSTEM 有权
标题翻译：存储磁盘上的大型对象，而不是内存数据库系统的主存储器
公开(公告)号：US20130290665A1
公开(公告)日：2013-10-31
申请号：US13460803
申请日：2012-04-30
申请人： Martin Heidel , Michael Muehle , Thorsten Glebe , Robert Schulze
发明人： Martin Heidel , Michael Muehle , Thorsten Glebe , Robert Schulze
IPC分类号： G06F12/02
CPC分类号： G06F17/30318
摘要： A method, computer program product and system are provided. The method, computer program product and system execute a process for determining a size of an object, the object having raw data that is operable upon by one or more physical operators. If the object is smaller than a threshold size, the object is stored in main memory of an in-memory database system. If the object is equal to or larger than the threshold size, the object is stored in a persistency of a disk storage, where storing the object in a disk storage further includes generating a global container identifier (ID) for the object, the global container ID referencing raw data of the object stored in the persistency of the disk storage.
摘要翻译：提供了一种方法，计算机程序产品和系统。所述方法，计算机程序产品和系统执行用于确定对象的大小的过程，所述对象具有可由一个或多个物理操作者操作的原始数据。如果对象小于阈值大小，则对象存储在内存数据库系统的主存储器中。如果对象等于或大于阈值大小，则对象被存储在磁盘存储器的持久性中，其中将对象存储在磁盘存储器中还包括为对象生成全局容器标识符（ID），全局容器 ID引用存储在磁盘存储器的持久性中的对象的原始数据。

14. 发明申请

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.
摘要翻译：系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一事务的第一查询，与第一事务相关联的第一事务令牌与第一事务的请求相关联的第二数据库节点两个或多个数据库节点，从第一数据库节点处的第二数据库节点接收第一事务令牌，在第一数据库节点处执行第一查询以生成第一结果，以及将第一结果和第一交易令牌从客户端设备的第一个数据库节点。

15. 发明申请

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.
摘要翻译：提供了计算机实现的方法，计算机可读介质和系统。提供了数据库的多个事务中的每一个的事务主体。每个事务主机被配置为与至少一个事务从属单元通信以管理多个事务中的事务的执行。每个事务主机被配置为执行生成事务令牌以指定对数据库上的事务可见的数据，该事务令牌包括用于识别事务是提交的事务还是未提交事务的事务标识符，接收请求以提交事务，根据请求发起一个两阶段提交操作来提交事务。两阶段提交操作包括准备提交事务，将提交的事务写入存储器，通过省略两阶段提交操作的阶段来优化两阶段提交操作，生成已提交事务的确认。数据库的多个事务与每个事务主机一起执行。

16. 发明授权

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.

17. 发明授权

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.

18. 发明授权

US09483513B2 Storing large objects on disk and not in main memory of an in-memory database system 有权
标题翻译：将大型对象存储在磁盘上，而不是存储在内存数据库系统的主内存中
公开(公告)号：US09483513B2
公开(公告)日：2016-11-01
申请号：US13460803
申请日：2012-04-30
申请人： Martin Heidel , Michael Muehle , Thorsten Glebe , Robert Schulze
发明人： Martin Heidel , Michael Muehle , Thorsten Glebe , Robert Schulze
IPC分类号： G06F12/02 , G06F17/30
CPC分类号： G06F17/30318
摘要： A method, computer program product and system are provided. The method, computer program product and system execute a process for determining a size of an object, the object having raw data that is operable upon by one or more physical operators. If the object is smaller than a threshold size, the object is stored in main memory of an in-memory database system. If the object is equal to or larger than the threshold size, the object is stored in a persistency of a disk storage, where storing the object in a disk storage further includes generating a global container identifier (ID) for the object, the global container ID referencing raw data of the object stored in the persistency of the disk storage.
摘要翻译：提供了一种方法，计算机程序产品和系统。所述方法，计算机程序产品和系统执行用于确定对象的大小的过程，所述对象具有可由一个或多个物理操作者操作的原始数据。如果对象小于阈值大小，则对象存储在内存数据库系统的主存储器中。如果对象等于或大于阈值大小，则对象被存储在磁盘存储器的持久性中，其中将对象存储在磁盘存储器中还包括为对象生成全局容器标识符（ID），全局容器 ID引用存储在磁盘存储器的持久性中的对象的原始数据。

19. 发明申请

US20150242451A1 Database Table Re-Partitioning Using Two Active Partition Specifications 审中-公开
标题翻译：使用两个活动分区规范的数据库表重新分区
公开(公告)号：US20150242451A1
公开(公告)日：2015-08-27
申请号：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
CPC分类号： G06F17/30584 , G06F17/30578
摘要： 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.
摘要翻译：启动将数据库表的源分区分区到目标分区。此后，指定了标识源分区和目标分区的转换分区规范。然后将数据从源分区移动（例如异步移动等）到目标分区。同时随着数据的移动，操作使用转换分区规范进行处理。随后，当所有数据已被移动到目标分区并且没有访问源分区的打开事务时，源分区将被丢弃。还描述了相关设备，系统，技术和物品。

20. 发明申请

US20140297686A1 CLIENT-SIDE STATEMENT ROUTING IN DISTRIBUTED DATABASE 有权
标题翻译：分布式数据库中的客户端声明路由
公开(公告)号：US20140297686A1
公开(公告)日：2014-10-02
申请号：US14306963
申请日：2014-06-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.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的两个或多个数据库节点的第二数据库节点，在第一数据库节点处首先查询以生成第一编译代码，以及将第一编译代码和第二数据库节点的第一标识符从第一数据库节点传输到客户端设备。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式