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

1. 发明申请

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

2. 发明授权

US09165010B2 Logless atomic data movement 有权
标题翻译：无原则的原子数据运动
公开(公告)号：US09165010B2
公开(公告)日：2015-10-20
申请号：US13843986
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F7/00 , G06F17/00 , 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.
摘要翻译：无原子数据运动的系统和方法。内部事务在多级存储架构内启动，内部事务将数据从第一级存储结构合并到第二级存储结构。从内部事务指定的多级存储架构的第一级存储结构读取提交的数据。来自第一级存储结构的提交的数据被插入到批量插入过程中的第二级存储结构中，并且所提交的数据被标记为从第一级存储器中删除。当提交的数据已插入到第二级存储结构中时，内部事务将被提交到多级存储架构。

3. 发明授权

US09465844B2 Unified table query processing 有权
标题翻译：统一表查询处理
公开(公告)号：US09465844B2
公开(公告)日：2016-10-11
申请号：US13843898
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30501 , G06F17/30297 , G06F17/30315 , G06F17/30386 , G06F17/30477 , G06F17/30498
摘要： A system and method of query processing in a multi-level storage system having a unified table architecture. A query is received by a common query execution engine connected with the unified table architecture, the query specifying a data record. The common query execution engine performs a look-up for the data record based on the query at the first level storage structure. If the data record is not present at the first level storage structure, the common query execution engine performs separate look-ups in each of the second level storage structure and the main store.
摘要翻译：具有统一表架构的多级存储系统中的查询处理系统和方法。与统一表架构相连的通用查询执行引擎接收到查询，查询指定数据记录。普通查询执行引擎根据第一级存储结构的查询执行数据记录的查找。如果第一级存储结构中不存在数据记录，则公共查询执行引擎在第二级存储结构和主存储中的每一个中执行单独的查找。

4. 发明申请

US20140136473A1 PARTIAL MERGE 有权
标题翻译：部分合并
公开(公告)号：US20140136473A1
公开(公告)日：2014-05-15
申请号：US13843841
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F17/30
CPC分类号： G06F17/30315 , G06F17/30321 , G06F17/30339 , G06F17/30483 , G06F17/30592
摘要： A multi-level storage architecture and method of performing a partial merge are disclosed. A main store is partitioned into a passive main part and an active main part, the active main part being empty at a start of the partial merge, the passive main part storing encoded data records of the main store that are not subject to the partial merge. A values index corresponding to a sorted dictionary of the passive main part is set to a cardinality of n. The data records of a second level storage structure is merged into the active main part, the active main part having a dictionary that starts with a value of n+1, such that the merging into the active main part continues an encoding scheme according to the values index of the passive main part.
摘要翻译：公开了一种执行部分合并的多级存储架构和方法。主店分为被动主体和活动主体，主动部分在部分合并开始时为空，被动主体部分存储不存在部分合并的主店铺的编码数据记录。将被动主体的排序词典对应的值索引设为n的基数。第二级存储结构的数据记录被合并到活动主体部分中，活动主体部分具有以n + 1的值开始的字典，使得合并到活动主体部分继续根据被动主体的价值指数。

5. 发明授权

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.
摘要翻译：公开了从第二级存储或主存储器中删除数据记录。对第一级存储器中的数据记录执行查找，其中数据记录由行标识符定义。如果在第一级存储器中找到行标识符，则对表示第二级存储器和主存储器中的数据记录的更新的更新行标识符执行查找，数据记录的更新由更新的行标识符。如果在第二级存储器中找到更新的行标识符，则从第一级存储器生成撤销日志以使行标识符的行标识符无效。生成表示无效的更新行标识符的标志，并且生成重做日志以恢复第一级存储器中的数据记录。

6. 发明申请

US20140122452A1 UNIFIED TABLE QUERY PROCESSING 有权
标题翻译：统一表查询处理
公开(公告)号：US20140122452A1
公开(公告)日：2014-05-01
申请号：US13843898
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F17/30
CPC分类号： G06F17/30501 , G06F17/30297 , G06F17/30315 , G06F17/30386 , G06F17/30477 , G06F17/30498
摘要： A system and method of query processing in a multi-level storage system having a unified table architecture. A query is received by a common query execution engine connected with the unified table architecture, the query specifying a data record. The common query execution engine performs a look-up for the data record based on the query at the first level storage structure. If the data record is not present at the first level storage structure, the common query execution engine performs separate look-ups in each of the second level storage structure and the main store.
摘要翻译：具有统一表架构的多级存储系统中的查询处理系统和方法。与统一表架构相连的通用查询执行引擎接收到查询，查询指定数据记录。普通查询执行引擎根据第一级存储结构的查询执行数据记录的查找。如果第一级存储结构中不存在数据记录，则公共查询执行引擎在第二级存储结构和主存储中的每一个中执行单独的查找。

7. 发明申请

US20140122439A1 DELETING RECORDS IN A MULTI-LEVEL STORAGE ARCHITECTURE 有权
标题翻译：在多层次的存储架构中删除记录
公开(公告)号：US20140122439A1
公开(公告)日：2014-05-01
申请号：US13844070
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： 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.
摘要翻译：公开了从第二级存储或主存储器中删除数据记录。对第一级存储器中的数据记录执行查找，其中数据记录由行标识符定义。如果在第一级存储器中找到行标识符，则对表示第二级存储器和主存储器中的数据记录的更新的更新行标识符执行查找，数据记录的更新由更新的行标识符。如果在第二级存储器中找到更新的行标识符，则从第一级存储器生成撤销日志以使行标识符的行标识符无效。生成表示无效的更新行标识符的标志，并且生成重做日志以恢复第一级存储器中的数据记录。

8. 发明授权

US10162766B2 Deleting records in a multi-level storage architecture without record locks 有权
公开(公告)号：US10162766B2
公开(公告)日：2018-12-25
申请号：US13844044
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F12/12 , G06F12/128 , G06F17/30
摘要： 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.

9. 发明授权

US09465829B2 Partial merge 有权
标题翻译：部分合并
公开(公告)号：US09465829B2
公开(公告)日：2016-10-11
申请号：US13843841
申请日：2013-03-15
申请人： Franz Faerber , Juchang Lee , Ivan Schreter
发明人： Franz Faerber , Juchang Lee , Ivan Schreter
IPC分类号： G06F7/00 , G06F17/00 , G06F17/30
CPC分类号： G06F17/30315 , G06F17/30321 , G06F17/30339 , G06F17/30483 , G06F17/30592
摘要： A multi-level storage architecture and method of performing a partial merge are disclosed. A main store is partitioned into a passive main part and an active main part, the active main part being empty at a start of the partial merge, the passive main part storing encoded data records of the main store that are not subject to the partial merge. A values index corresponding to a sorted dictionary of the passive main part is set to a cardinality of n. The data records of a second level storage structure is merged into the active main part, the active main part having a dictionary that starts with a value of n+1, such that the merging into the active main part continues an encoding scheme according to the values index of the passive main part.
摘要翻译：公开了一种执行部分合并的多级存储架构和方法。主店分为被动主体和活动主体，主动部分在部分合并开始时为空，被动主体部分存储不存在部分合并的主店的编码数据记录。将被动主体的排序词典对应的值索引设为n的基数。第二级存储结构的数据记录被合并到活动主体部分中，活动主体部分具有以n + 1的值开始的字典，使得合并到活动主体部分继续根据被动主体的价值指数。

10. 发明申请

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.
摘要翻译：多级存储系统和删除第一级存储结构页面或记录的方法，无记录锁。该方法包括确定要从第一级存储结构中删除的记录是否具有任何未提交的写入操作，并且如果记录具有未提交的写入操作，则将记录保存在第一级存储结构中。记录移动的版本信息被添加到记录中以指定从第一级存储结构移动到第二级存储结构的记录。基于记录移动的版本信息对记录执行数据更改操作，而不等待直到记录从第一级存储结构向第二级存储结构的移动结束。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式