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

41. 发明授权

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.

42. 发明申请

US20160147814A1 In-Memory Database System Providing Lockless Read and Write Operations for OLAP and OLTP Transactions 审中-公开
标题翻译：内存数据库系统为OLAP和OLTP交易提供无锁读写操作
公开(公告)号：US20160147814A1
公开(公告)日：2016-05-26
申请号：US14553950
申请日：2014-11-25
申请人： Anil Kumar Goel , Ivan Schreter , Juchang Lee , Mihnea Andrei , Steffen Geissinger , Thomas Legler
发明人： Anil Kumar Goel , Ivan Schreter , Juchang Lee , Mihnea Andrei , Steffen Geissinger , Thomas Legler
IPC分类号： G06F17/30 , G06F3/06
CPC分类号： G06F17/30383 , G06F3/0619 , G06F3/0665 , G06F3/0689 , G06F17/30008 , G06F17/30171 , G06F17/30309 , G06F17/30348 , G06F17/30353 , G06F17/30356 , G06F17/30359 , G06F17/30368 , G06F17/30575 , G06F17/30592
摘要： As part of a database system comprising a combination of on-disk storage and in-memory storage, a plurality of records that comprise a table are stored in a plurality of fragments that include at least a delta fragment and a main fragment retained in the on-disk storage. Each fragment has visibility data structures to enable multi-version concurrency control. Each fragment can be compressed using dictionary compression and n-bits compression. The fragments are loaded into main system memory in the in-memory storage from the on-disk storage if they are accessed for read operations or write operations and are not already in memory. A plurality of lockless read and write operations are concurrently performed, while providing snapshot isolation, on the at least one of the plurality of fragments while the at least one of the plurality of fragments is in the main system memory.
摘要翻译：作为包括磁盘存储和内存存储的组合的数据库系统的一部分，包括表的多个记录被存储在多个片段中，该多个片段至少包括一个delta片段和保存在on上的主片段磁盘存储。每个片段具有可见性数据结构，以实现多版本并发控制。可以使用字典压缩和n位压缩来压缩每个片段。如果对于读取操作或写入操作进行访问，并且尚未存储在内存中，这些碎片将从磁盘存储器加载到内存中的主系统内存中。同时执行多个无锁读取和写入操作，同时在多个片段中的至少一个片段上提供快照隔离，同时多个片段中的至少一个片段在主系统存储器中。

43. 发明申请

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.
摘要翻译：启动将数据库表的源分区分区到目标分区。此后，指定了标识源分区和目标分区的转换分区规范。然后将数据从源分区移动（例如异步移动等）到目标分区。同时随着数据的移动，操作使用转换分区规范进行处理。随后，当所有数据已被移动到目标分区并且没有访问源分区的打开事务时，源分区将被丢弃。还描述了相关设备，系统，技术和物品。

44. 发明申请

US20150149426A1 TRANSACTION COMMIT OPERATIONS WITH THREAD DECOUPLING AND GROUPING OF I/O REQUESTS 审中-公开
标题翻译：具有螺纹解除和I / O要求分组的交易提交操作
公开(公告)号：US20150149426A1
公开(公告)日：2015-05-28
申请号：US14255807
申请日：2014-04-17
申请人： Kyu Hwan Kim , Juchang Lee
发明人： Kyu Hwan Kim , Juchang Lee
IPC分类号： G06F9/46 , G06F3/06 , G06F17/30
CPC分类号： G06F9/467 , G06F3/0604 , G06F3/0655 , G06F3/0674 , G06F17/30312 , G06F17/30371 , G06F17/30377 , G06F2003/0697
摘要： Innovations in the area of server-side processing when committing transactions to disk in a distributed database system can improve computational efficiency at database nodes and/or reduce network bandwidth utilization. For example, when transactions are committed in a database system, at a master node of the database system, a server uses different threads for certain processor-intensive operations and certain I/O-intensive operations. Or, as another example, when transactions are committed in a database system, at a master node of the database system, a server groups jobs for I/O requests.
摘要翻译：在分布式数据库系统中将事务交付到磁盘时，服务器端处理领域的创新可以提高数据库节点的计算效率和/或降低网络带宽利用率。例如，当在数据库系统中提交事务时，在数据库系统的主节点处，服务器使用不同的线程进行某些处理器密集型操作和某些I / O密集型操作。或者，作为另一个例子，当在数据库系统中提交事务时，在数据库系统的主节点处，服务器对I / O请求进行分组作业。

45. 发明申请

US20150149409A1 DML REPLICATION WITH LOGICAL LOG SHIPPING 有权
标题翻译： DML代理与LOGICAL LOG船运
公开(公告)号：US20150149409A1
公开(公告)日：2015-05-28
申请号：US14302320
申请日：2014-06-11
申请人： Joo Yeon Lee , Juchang Lee , Kyu Hwan Kim , Chul Won Lee , Yong Sik Kwon , Sang Kyun Cha
发明人： Joo Yeon Lee , Juchang Lee , Kyu Hwan Kim , Chul Won Lee , Yong Sik Kwon , Sang Kyun Cha
IPC分类号： G06F17/30
CPC分类号： G06F17/30575
摘要： Technologies are described for performing replication within a database environment. For example, replication of database data can be performed using data manipulation language (DML) statements and logical logs. A database node can execute a DML statement, create a logical log comprising the DML statement, and insert the logical log into a logical log queue. The logical log can be sent to one or more other database nodes for execution of the DML statement stored within the logical log. Logical logs can be grouped for sending to other nodes. Logical logs can be executed on a first node and one or more other nodes within the same transaction boundary. Execution of DML statements can be decoupled from sending, receiving, grouping, and/or processing of logical logs.
摘要翻译：描述了在数据库环境中执行复制的技术。例如，可以使用数据操作语言（DML）语句和逻辑日志来执行数据库数据的复制。数据库节点可以执行DML语句，创建包含DML语句的逻辑日志，并将逻辑日志插入到逻辑日志队列中。可以将逻辑日志发送到一个或多个其他数据库节点，以执行逻辑日志中存储的DML语句。逻辑日志可以分组发送到其他节点。逻辑日志可以在同一事务边界内的第一个节点和一个或多个其他节点上执行。 DML语句的执行可以与逻辑日志的发送，接收，分组和/或处理分离。

46. 发明申请

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

47. 发明申请

US20140222418A1 FIXED STRING DICTIONARY 审中-公开
标题翻译：固定字典
公开(公告)号：US20140222418A1
公开(公告)日：2014-08-07
申请号：US13874327
申请日：2013-04-30
申请人： Martin Richtarsky , Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Martin Richtarsky , Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F17/27
CPC分类号： G06F16/367 , G06F16/22 , G06F16/221 , G06F16/2228 , G06F16/313 , G06F16/36
摘要： The subject matter described herein relates to implementation of a dictionary in a column-based, in-memory database where values are not stored directly, rather, for each column, a dictionary is created with all distinct values. For each row, a reference to the corresponding value in the dictionary is stored. In one aspect, data is stored in a memory structure organized in a column store format defined by a plurality of columns and a plurality of rows. A dictionary for each column in the memory structure is generated. The dictionary has distinct values for each column. A reference to the dictionary is generated for each column in the memory structure. The dictionary and the reference to the dictionary are stored in the memory structure.
摘要翻译：本文描述的主题涉及在基于列的存储器内数据库中实现字典，其中值不直接存储，而是对于每一列，创建具有所有不同值的字典。对于每一行，存储对字典中对应值的引用。在一个方面，数据被存储在以由多个列和多行定义的列存储格式组织的存储器结构中。生成内存结构中每列的字典。字典对于每一列都有不同的值。为存储器结构中的每个列生成对字典的引用。字典和对字典的引用存储在存储器结构中。

48. 发明授权

US08700660B2 Client-side statement routing for partitioned tables 有权
标题翻译：分区表的客户端语句路由
公开(公告)号：US08700660B2
公开(公告)日：2014-04-15
申请号：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
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.
摘要翻译：一种系统包括在包括两个或多个数据库节点的数据库实例的第一数据库节点处从客户端设备接收第一查询，第一查询指定在两个或多个数据库节点中的两个或更多个数据库节点之间划分的第一数据库表确定所述第一数据库表的第一分区元数据，所述第一分区元数据可用于基于表键值识别所述两个或多个数据库节点中的一个，所述第一数据库节点处的第一查询的编译以生成第一编译代码;以及将第一编译代码和第一分区元数据从第一数据库节点传输到客户端设备。

49. 发明授权

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

50. 发明申请

US20120167098A1 Distributed Transaction Management Using Optimization Of Local Transactions 有权
标题翻译：使用优化本地事务的分布式事务管理
公开(公告)号：US20120167098A1
公开(公告)日：2012-06-28
申请号：US12980208
申请日：2010-12-28
申请人： Juchang Lee , Michael Muehle , Jaeyun Noh
发明人： Juchang Lee , Michael Muehle , Jaeyun Noh
IPC分类号： G06F9/46
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.
摘要翻译：提供了计算机实现的方法，计算机程序产品和系统。提供了数据库的多个事务中的每一个的事务主体。每个事务主机被配置为与至少一个事务从属单元通信以管理多个事务中的事务的执行。生成一个事务令牌，用于指定对数据库上的事务可见的数据。交易令牌包括用于识别交易是承诺交易还是未提交交易的交易标识符。事务主机被配置为在执行事务之后更新事务令牌。确定是否可以在不访问由交易令牌指定的数据的情况下在至少一个事务从属方上执行事务。使用存储在所述至少一个事务从属单元处的事务令牌在所述至少一个事务从属单元上执行事务。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式