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

31. 发明申请

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

32. 发明申请

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

33. 发明授权

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.

34. 发明申请

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

35. 发明授权

US09501502B2 Locking protocol for partitioned and distributed tables 有权
标题翻译：分区表和分布式表的锁定协议
公开(公告)号：US09501502B2
公开(公告)日：2016-11-22
申请号：US13750194
申请日：2013-01-25
申请人： Juchang Lee , Jin Yeon Lee , Yongjae Chuh , Jaeyun Noh
发明人： Juchang Lee , Jin Yeon Lee , Yongjae Chuh , Jaeyun Noh
IPC分类号： G06F17/30
CPC分类号： G06F17/30289 , G06F17/30008 , G06F17/30362
摘要： Systems, methods and computer program product embodiments for providing a locking protocol for partitioned and distributed database tables are disclosed herein. A locking method includes executing, by at least one processor, a first database transaction on a second node, attempting to acquire and acquiring a lock on the second node in intentional exclusive mode, executing, by the at least one processor, a second database transaction on a first node, acquiring a lock on the first node in exclusive mode and waiting to acquire a lock on the second node in exclusive mode, routing, by the at least one processor, the first database transaction to the first node and unsuccessfully trying to acquire a lock on the first node and committing, by the at least one processor, the first database transaction.
摘要翻译：本文公开了用于为分区和分布式数据库表提供锁定协议的系统，方法和计算机程序产品实施例。锁定方法包括由至少一个处理器执行第二节点上的第一数据库事务，尝试以有意的排他模式获取和获取第二节点上的锁定，由至少一个处理器执行第二数据库事务在第一节点上，以独占模式获取第一节点上的锁定，并且以排他模式等待获取第二节点上的锁定，由至少一个处理器将第一数据库事务路由到第一节点，并且不成功地尝试获得第一节点上的锁并由至少一个处理器提交第一数据库事务。

36. 发明申请

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

37. 发明授权

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.

38. 发明申请

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

39. 发明授权

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.

40. 发明授权

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.

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式