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

51. 发明申请

US20150242400A1 Database Table Re-Partitioning Using Trigger-Based Capture and Replay 审中-公开
标题翻译：使用基于触发的捕获和重放的数据库表重新分区
公开(公告)号：US20150242400A1
公开(公告)日：2015-08-27
申请号：US14188543
申请日：2014-02-24
申请人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
发明人： Christian Bensberg , Franz Faerber , Lars Fricke , Juchang Lee , Roland Sedler , Andreas Tonder , Emanuel Ziegler
IPC分类号： G06F17/30
CPC分类号： G06F17/30339
摘要： Partitioning of a source table of a database to a target table is initiated. Thereafter, a replay table is generated that is populated with triggers for database operations performed on the source table for subsequent replay for the target partitions. Data is later moved (e.g., asynchronously moved, etc.) from the source table to the target table. The database operations are replayed on the target table T subsequent to the moving of the data using the replay table. In addition, the source table is dropped when all of the data has been moved to the target table and there are no operations requiring replay. Related apparatus, systems, techniques and articles are also described.
摘要翻译：启动将数据库的源表分区到目标表。此后，生成重播表，其中填充有用于在源表上执行的数据库操作的触发器，用于目标分区的后续重放。数据稍后从源表移动到目标表（例如异步移动等）。在使用重放表移动数据之后，在目标表T上重播数据库操作。此外，当所有数据已被移动到目标表并且没有需要重放的操作时，源表被删除。还描述了相关设备，系统，技术和物品。

52. 发明申请

US20140136788A1 Deleting Records In A Multi-Level Storage Architecture Without Record Locks 审中-公开
标题翻译：在没有记录锁的多级存储架构中删除记录
公开(公告)号：US20140136788A1
公开(公告)日：2014-05-15
申请号：US13844044
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F12/12
CPC分类号： G06F12/128 , G06F17/30315 , G06F17/30345
摘要： The multi-level storage system and method of deleting first level storage structure pages or records without record locks. The method includes determining whether a record to be deleted from the first level storage structure has any uncommitted write operation, and if the record has an uncommitted write operation, the record is kept in the first level storage structure. Record-moved version information is added to the record to designate the record being moved from the first level storage structure to the second level storage structure. Data change operations are executed for the record based on the record-moved version information without waiting until the record's movement from the first level storage structure to the second level storage structure finishes.
摘要翻译：多级存储系统和删除第一级存储结构页面或记录的方法，无记录锁。该方法包括确定要从第一级存储结构中删除的记录是否具有任何未提交的写入操作，并且如果记录具有未提交的写入操作，则将记录保存在第一级存储结构中。记录移动的版本信息被添加到记录中以指定从第一级存储结构移动到第二级存储结构的记录。基于记录移动的版本信息对记录执行数据更改操作，而不等待直到记录从第一级存储结构向第二级存储结构的移动结束。

53. 发明申请

US20130290282A1 Logless Atomic Data Movement 有权
标题翻译：无原则数据运动
公开(公告)号：US20130290282A1
公开(公告)日：2013-10-31
申请号：US13843986
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F17/30
CPC分类号： G06F17/30371 , G06F3/0604 , G06F3/0638 , G06F3/0644 , G06F3/0647 , G06F3/065 , G06F3/0652 , G06F3/0673 , G06F3/0683 , G06F17/30117 , G06F17/30153 , G06F17/30315 , G06F17/30348 , G06F17/30377 , G06F17/30575 , G06F17/30587
摘要： A system and method of logless atomic data movement. An internal transaction is started within a multi-level storage architecture, the internal transaction to merge data from the first level storage structure to the second level storage structure. Committed data is read from a first level storage structure of the multi-level storage architecture as specified by the internal transaction. The committed data from the first level storage structure is inserted into a second level storage structure in a bulk insertion process, and the committed data is marked as being deleted from the first level storage. The internal transaction is then committed to the multi-level storage architecture when the committed data has been inserted into the second level storage structure.
摘要翻译：无原子数据运动的系统和方法。内部事务在多级存储架构内启动，内部事务将数据从第一级存储结构合并到第二级存储结构。从内部事务指定的多级存储架构的第一级存储结构读取提交的数据。来自第一级存储结构的提交的数据被插入到批量插入过程中的第二级存储结构中，并且所提交的数据被标记为从第一级存储器中删除。当提交的数据已插入到第二级存储结构中时，内部事务将被提交到多级存储架构。

54. 发明申请

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

55. 发明授权

US10185737B2 Distributed transaction management with tokens 有权
公开(公告)号：US10185737B2
公开(公告)日：2019-01-22
申请号：US14642941
申请日：2015-03-10
申请人： Frank Renkes , Juchang Lee
发明人： Frank Renkes , Juchang Lee
IPC分类号： G06F17/30
摘要： 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.

56. 发明授权

US09965513B2 Set-orientated visibility state retrieval scheme 有权
公开(公告)号：US09965513B2
公开(公告)日：2018-05-08
申请号：US14553226
申请日：2014-11-25
申请人： Juchang Lee , Mihnea Andrei , Colin Florendo , Ivan Schreter , Anil Kumar Goel
发明人： Juchang Lee , Mihnea Andrei , Colin Florendo , Ivan Schreter , Anil Kumar Goel
IPC分类号： G06F17/30
CPC分类号： G06F17/30463 , G06F17/30339 , G06F17/30345 , G06F17/30353 , G06F17/30548
摘要： Disclosed herein are system, method, and computer program product embodiments for determining row visibility states. An embodiment operates by initializing a result bitmap for rows based on visible row state values of row state bitmaps corresponding to the rows, wherein values of the result bitmap indicate whether the row are visible or not visible; determining one or more rows whose corresponding visible row state values indicate that the one or more rows are not visible; and determining whether to update the result bitmap to indicate that the one or more rows are visible based on one or more versioned row state values, wherein the one or more versioned row state values indicate whether the corresponding rows are not visible or possibly visible.

57. 发明申请

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位压缩来压缩每个片段。如果对于读取操作或写入操作进行访问，并且尚未存储在内存中，这些碎片将从磁盘存储器加载到内存中的主系统内存中。同时执行多个无锁读取和写入操作，同时在多个片段中的至少一个片段上提供快照隔离，同时多个片段中的至少一个片段在主系统存储器中。

58. 发明申请

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请求进行分组作业。

59. 发明申请

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.
摘要翻译：本文描述的主题涉及在基于列的存储器内数据库中实现字典，其中值不直接存储，而是对于每一列，创建具有所有不同值的字典。对于每一行，存储对字典中对应值的引用。在一个方面，数据被存储在以由多个列和多行定义的列存储格式组织的存储器结构中。生成内存结构中每列的字典。字典对于每一列都有不同的值。为存储器结构中的每个列生成对字典的引用。字典和对字典的引用存储在存储器结构中。

60. 发明申请

US20140149368A1 Compressed Representation of a Transaction Token 有权
标题翻译：压缩表示事务令牌
公开(公告)号：US20140149368A1
公开(公告)日：2014-05-29
申请号：US13760850
申请日：2013-02-06
申请人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
发明人： Juchang Lee , Chang Gyoo Park , Hyoungjun Na , Kyuhwan Kim
IPC分类号： G06F17/30
CPC分类号： G06F17/30309 , G06F17/30286 , G06F17/30356
摘要： Methods, systems and computer-readable storage mediums encoded with computer programs executed by one or more processors for providing a compressed representation of a transaction token are disclosed. In an embodiment, a transaction token maintains statues of transaction to a database in a first data structure and a second data structure. The first data structure includes a plurality of identifiers respectively corresponding to the transactions to the database and a corresponding status of each identifier indicating whether a given transaction is open or closed, wherein the plurality of identifiers is maintained below a threshold number of identifiers. The second data structure includes a plurality of identifiers of transactions to the database beyond the threshold and whose status is open.
摘要翻译：公开了由用于提供交易令牌的压缩表示的一个或多个处理器执行的计算机程序编码的方法，系统和计算机可读存储介质。在一个实施例中，交易令牌将事务的雕像以第一数据结构和第二数据结构维护到数据库。第一数据结构包括分别对应于数据库的事务的多个标识符以及指示给定事务是打开还是关闭的每个标识符的对应状态，其中多个标识符被维持在阈值数量的标识符之下。第二数据结构包括多个到数据库的事务的标识符超出阈值并且其状态是开放的。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式