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

71. 发明申请

US20160147821A1 Supporting Cursor Snapshot Semantics 有权
标题翻译：支持光标快照语义
公开(公告)号：US20160147821A1
公开(公告)日：2016-05-26
申请号：US14553790
申请日：2014-11-25
申请人： Ivan Schreter , Juchang Lee
发明人： Ivan Schreter , Juchang Lee
IPC分类号： G06F17/30 , G06F9/46
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.
摘要翻译：数据库在打开事务的至少一个游标中的每一个时，分配构成事务的每个语句的涉及数据库的至少一行的语句序列号（SSN）。此后，使用事务标识符和对应的SSN将临时时间戳分配给至少一行。此外，监视活动光标，使得最终时间戳被阻止与每行相关联，直到其没有剩余的游标。还描述了相关设备，系统，技术和物品。

72. 发明授权

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

73. 发明授权

US09171020B2 Deleting records in a multi-level storage architecture 有权
标题翻译：删除多级存储架构中的记录
公开(公告)号：US09171020B2
公开(公告)日：2015-10-27
申请号：US13844070
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30303 , G06F17/30289 , G06F17/30306 , G06F17/30315 , G06F17/30345 , G06F17/30371
摘要： Deleting a data record from the second level storage or main store is disclosed. A look-up is performed for the data record in the first level storage, where the data record is defined by a row identifier. If the row identifier is found in the first level storage, a look-up is performed for an updated row identifier representing an update of the data record in the second level storage and the main store, the update of the data record being defined by an updated row identifier. If the updated row identifier is found in the second level storage, an undo log is generated from the first level storage to invalidate a row identifier of the row identifier. A flag is generated representing an invalid updated row identifier, and a redo log is generated to restore the data record in the first level storage.
摘要翻译：公开了从第二级存储或主存储器中删除数据记录。对第一级存储器中的数据记录执行查找，其中数据记录由行标识符定义。如果在第一级存储器中找到行标识符，则对表示第二级存储器和主存储器中的数据记录的更新的更新行标识符执行查找，数据记录的更新由更新的行标识符。如果在第二级存储器中找到更新的行标识符，则从第一级存储器生成撤销日志以使行标识符的行标识符无效。生成表示无效的更新行标识符的标志，并且生成重做日志以恢复第一级存储器中的数据记录。

74. 发明申请

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

75. 发明授权

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.
摘要翻译：提供了计算机实现的方法，计算机程序产品和系统。提供了数据库的多个事务中的每一个的事务主体。每个事务主机被配置为与至少一个事务从属单元通信以管理多个事务中的事务的执行。生成一个事务令牌，用于指定对数据库上的事务可见的数据。交易令牌包括用于识别交易是承诺交易还是未提交交易的交易标识符。事务主机被配置为在执行事务之后更新事务令牌。确定是否可以在不访问由交易令牌指定的数据的情况下在至少一个事务从属方上执行事务。使用存储在所述至少一个事务从属单元处的事务令牌在所述至少一个事务从属单元上执行事务。

76. 发明申请

US20150149704A1 Transaction Private Log Buffering for High Performance of Transaction Processing 有权
标题翻译：事务处理的高性能的事务私有日志缓冲
公开(公告)号：US20150149704A1
公开(公告)日：2015-05-28
申请号：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分类号： G06F3/06
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中的一个或多个表启动的写入操作的一部分而创建的每个数据更改发生的事务，事务日志条目可以写入对应于事务的专用日志缓冲区。专用日志缓冲区中的所有事务日志条目可以在私有日志缓冲区对应的事务完成后刷新到全局日志缓冲区。

77. 发明申请

US20150074082A1 Hybrid Database Table Stored as Both Row and Column Store 审中-公开
标题翻译：混合数据库表存储为行和列存储
公开(公告)号：US20150074082A1
公开(公告)日：2015-03-12
申请号：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.
摘要翻译：混合数据库表存储为行和列存储。可以单独使用或组合使用一种或多种技术，以通过调节处理密集型列存储数据的访问和/或大小来增强混合表的性能。例如，在插入操作期间，只有在考虑了某些过滤和/或边界条件之后，才能搜索列存储数据以获得唯一性违规。在另一技术中，混合表管理器可以基于诸如访问频率或基础业务逻辑等考虑来控制数据到列存储的移动。在另一种技术中，对混合表的查询可以仅在行存储数据的初始搜索不能返回结果之后才能搜索列存储数据。

78. 发明授权

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

79. 发明申请

US20140304219A1 Hybrid Database Table Stored as Both Row and Column Store 有权
标题翻译：混合数据库表存储为行和列存储
公开(公告)号：US20140304219A1
公开(公告)日：2014-10-09
申请号：US14299843
申请日：2014-06-09
申请人： 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/30592 , G06F17/245 , G06F17/30312 , G06F17/30315 , G06F17/30321 , G06F17/30377 , 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.
摘要翻译：混合数据库表存储为行和列存储。可以单独使用或组合使用一种或多种技术，以通过调节处理密集型列存储数据的访问和/或大小来增强混合表的性能。例如，在插入操作期间，只有在考虑了某些过滤和/或边界条件之后，才能搜索列存储数据以获得唯一性违规。在另一技术中，混合表管理器可以基于诸如访问频率或基础业务逻辑等考虑来控制数据到列存储的移动。在另一种技术中，对混合表的查询可以仅在行存储数据的初始搜索不能返回结果之后才能搜索列存储数据。

80. 发明授权

US08782100B2 Hybrid database table stored as both row and column store 有权
公开(公告)号：US08782100B2
公开(公告)日：2014-07-15
申请号：US13334777
申请日：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分类号： G06F7/00 , G06F17/24 , G06F17/30
CPC分类号： G06F17/30592 , G06F17/245 , G06F17/30312 , G06F17/30315 , G06F17/30321 , G06F17/30377 , 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

热门服务

关于我们

友情链接

联系方式