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

1. 发明申请

US20140149353A1 Version Garbage Collection Using Snapshot Lists 有权
标题翻译：版本垃圾收集使用快照列表
公开(公告)号：US20140149353A1
公开(公告)日：2014-05-29
申请号：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.
摘要翻译：本文公开了使用快照列表提供版本垃圾收集的系统，方法和计算机程序产品实施例。使用快照列表的版本垃圾收集包括通过至少一个处理器存储数据库表中的记录的版本，所述记录包括记录值和版本时间戳，由所述至少一个处理器存储两个级别的活动快照活动快照列表，包括事务标识符和快照时间戳的活动快照，由所述至少一个处理器确定所述两个活动快照列表中的活动快照中的最小主动快照，并且由所述至少一个处理器，该记录的版本的版本时间戳早于最小主动快照的快照时间戳。

2. 发明申请

US20160147776A1 ALTERING DATA TYPE OF A COLUMN IN A DATABASE 审中-公开
标题翻译：更改数据库中的列的数据类型
公开(公告)号：US20160147776A1
公开(公告)日：2016-05-26
申请号：US14552902
申请日：2014-11-25
申请人： Colin Florendo , Ivan Schreter , Panfeng Zhou , David Wein , Steffen Geissinger , Michael Muehle
发明人： Colin Florendo , Ivan Schreter , Panfeng Zhou , David Wein , Steffen Geissinger , Michael Muehle
IPC分类号： G06F17/30
摘要： Disclosed herein are system, method, and computer program product embodiments for altering the data type of a column in a database. An embodiment operates by converting an original dictionary associated with a column into a new dictionary. The new dictionary stores the values of the original dictionary using a different data type. An index vector containing the keys of the original dictionary is then updated to contain the associated keys of the new dictionary. Because the size of the original dictionary is often substantially smaller than the number of rows in the associated column, this dictionary conversion decreases the computation cost to the database system of altering the data type of the column and reduces or even minimizes database downtime for users.
摘要翻译：这里公开了用于改变数据库中的列的数据类型的系统，方法和计算机程序产品实施例。实施例通过将与列相关联的原始字典转换为新字典来操作。新字典使用不同的数据类型存储原始字典的值。然后，将包含原始字典的键的索引向量更新为包含新字典的相关键。由于原始字典的大小通常远小于相关列中的行数，因此该字典转换会降低数据库系统的更改列数据类型的计算成本，并减少或甚至最小化用户数据库停机时间。

3. 发明授权

US09336284B2 Client-side statement routing in distributed database 有权
标题翻译：分布式数据库中的客户端语句路由
公开(公告)号：US09336284B2
公开(公告)日：2016-05-10
申请号：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.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的两个或多个数据库节点的第二数据库节点，在第一数据库节点处首先查询以生成第一编译代码，以及将第一编译代码和第二数据库节点的第一标识符从第一数据库节点传输到客户端设备。

4. 发明授权

US09063969B2 Distributed transaction management using optimization of local transactions 有权
标题翻译：使用优化本地交易的分布式事务管理
公开(公告)号：US09063969B2
公开(公告)日：2015-06-23
申请号：US12980208
申请日：2010-12-28
申请人： Juchang Lee , Michael Muehle , Jaeyun Noh
发明人： Juchang Lee , Michael Muehle , Jaeyun Noh
IPC分类号： G06F9/46 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30377
摘要： A computer-implemented method, a computer program product, 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 a transaction in the plurality of transactions. A transaction token that specifies data to be visible for the transaction on the database is generated. The transaction token includes a transaction identifier for identifying whether the transaction is a committed transaction or an uncommitted transaction. The transaction master is configured to update the transaction token after execution of the transaction. A determination whether the transaction can be executed on the at least one transaction slave without accessing data specified by the transaction token is made. The transaction is executed on the at least one transaction slave using a transaction token stored at the at least one transaction slave.
摘要翻译：提供了计算机实现的方法，计算机程序产品和系统。提供了数据库的多个事务中的每一个的事务主体。每个事务主机被配置为与至少一个事务从属单元通信以管理多个事务中的事务的执行。生成一个事务令牌，用于指定对数据库上的事务可见的数据。交易令牌包括用于识别交易是承诺交易还是未提交交易的交易标识符。事务主机被配置为在执行事务之后更新事务令牌。确定是否可以在不访问由交易令牌指定的数据的情况下在至少一个事务从属方上执行事务。使用存储在所述至少一个事务从属单元处的事务令牌在所述至少一个事务从属单元上执行事务。

5. 发明申请

US20130275550A1 UPDATE PROTOCOL FOR CLIENT-SIDE ROUTING INFORMATION 有权
标题翻译：用于客户端路由信息的更新协议
公开(公告)号：US20130275550A1
公开(公告)日：2013-10-17
申请号：US13449081
申请日：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分类号： G06F15/16 , G06F17/30
CPC分类号： G06F17/30545
摘要： A system includes reception of a first query from a client device at a first database node of a database instance, determination of routing information associated with the first query, compilation of the first query at the first database node to generate first compiled code, transmission of the first compiled code and the routing information to the client device, reception of the compiled code from the client device at a second database node, determination, at the second database node, that data associated with the compiled query is associated with a third database node, transmission of the compiled code from the second database node to the third database node, reception of query results at the second database node from the third database node, and transmission of the query results and an indication to update the routing information from the second database node to the client device.
摘要翻译：系统包括在数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的路由信息，在第一数据库节点处编译第一查询以生成第一编译代码，传输第一编译代码和到客户端设备的路由信息，在第二数据库节点从客户端设备接收编译代码，在第二数据库节点确定与编译查询相关联的数据与第三数据库节点将编译代码从第二数据库节点传输到第三数据库节点，从第三数据库节点接收第二数据库节点处的查询结果，以及发送查询结果以及从第二数据库更新路由信息的指示节点到客户端设备。

6. 发明授权

US09037677B2 Update protocol for client-side routing information 有权
标题翻译：更新客户端路由信息协议
公开(公告)号：US09037677B2
公开(公告)日：2015-05-19
申请号：US13449081
申请日：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分类号： G06F15/16 , G06F17/30
CPC分类号： G06F17/30545
摘要： A system includes reception of a first query from a client device at a first database node of a database instance, determination of routing information associated with the first query, compilation of the first query at the first database node to generate first compiled code, transmission of the first compiled code and the routing information to the client device, reception of the compiled code from the client device at a second database node, determination, at the second database node, that data associated with the compiled query is associated with a third database node, transmission of the compiled code from the second database node to the third database node, reception of query results at the second database node from the third database node, and transmission of the query results and an indication to update the routing information from the second database node to the client device.
摘要翻译：系统包括在数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的路由信息，在第一数据库节点处编译第一查询以生成第一编译代码，传输第一编译代码和到客户端设备的路由信息，在第二数据库节点从客户端设备接收编译代码，在第二数据库节点确定与编译查询相关联的数据与第三数据库节点将编译代码从第二数据库节点传输到第三数据库节点，从第三数据库节点接收第二数据库节点处的查询结果，以及发送查询结果以及从第二数据库更新路由信息的指示节点到客户端设备。

7. 发明授权

US08793276B2 Client-side statement routing in distributed database 有权
标题翻译：分布式数据库中的客户端语句路由
公开(公告)号：US08793276B2
公开(公告)日：2014-07-29
申请号：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.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的两个或多个数据库节点的第二数据库节点，在第一数据库节点处首先查询以生成第一编译代码，以及将第一编译代码和第二数据库节点的第一标识符从第一数据库节点传输到客户端设备。

8. 发明申请

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

9. 发明申请

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.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，确定与第一查询相关联的两个或多个数据库节点的第二数据库节点，在第一数据库节点处首先查询以生成第一编译代码，以及将第一编译代码和第二数据库节点的第一标识符从第一数据库节点传输到客户端设备。

10. 发明申请

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.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，第一查询指定在两个或多个数据库节点中的两个或更多个数据库节点之间划分的第一数据库表确定所述第一数据库表的第一分区元数据，所述第一分区元数据可用于基于表键值识别所述两个或多个数据库节点中的一个，所述第一数据库节点处的第一查询的编译以生成第一编译代码;以及将第一编译代码和第一分区元数据从第一数据库节点传输到客户端设备。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式