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

1. 发明公开

EP1995878A2 Block compression of tables with repeated values 有权转让
标题翻译：表的块压缩与重复值
公开(公告)号：EP1995878A2
公开(公告)日：2008-11-26
申请号：EP08008447.8
申请日：2008-05-05
申请人： SAP AG
发明人： Faerber, Franz , Radestock, Guenter , Ross, Andrew
IPC分类号： H03M7/30
CPC分类号： G06F17/30153 , G06F17/30315 , G06F17/30321 , H03M7/3084 , H03M7/3088
摘要： Methods and apparatus, including computer program products, for block compression of tables with repeated values. In general, value identifiers representing a compressed column of data may be sorted to render repeated values contiguous, and block dictionaries may be generated. A block dictionary may be generated for each block of value identifiers. Each block dictionary may include a list of block identifiers, where each block identifier is associated with a value identifier and there is a block identifier for each unique value in a block. Blocks may have standard sizes and block dictionaries may be reused for multiple blocks.

2. 发明公开

EP2660734A1 Deleting records in a multi-level storage architecture without record locks 审中-公开
标题翻译： LöschenvonDatensätzen在einer mehrstufigen Speicherarchitektur ohne Aufzeichnungssperren
公开(公告)号：EP2660734A1
公开(公告)日：2013-11-06
申请号：EP13002237.9
申请日：2013-04-26
申请人： SAP AG
发明人： Faerber, Franz , Lee, Juchang , Schreter, Ivan , Richtarsky, Martin
IPC分类号： G06F17/30
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.
摘要翻译：多级存储系统和删除第一级存储结构页面或记录的方法，无记录锁。该方法包括确定要从第一级存储结构中删除的记录是否具有任何未提交的写入操作，并且如果记录具有未提交的写入操作，则该记录保存在第一级存储结构中。记录移动的版本信息被添加到记录中以指定从第一级存储结构移动到第二级存储结构的记录。基于记录移动版本信息对记录执行数据更改操作，而不等待直到记录从第一级存储结构向第二级存储结构的移动结束。

3. 发明公开

EP2660732A1 Unified table query processing 有权转让
标题翻译： Einheitliche Tabellenabfrageverarbeitung
公开(公告)号：EP2660732A1
公开(公告)日：2013-11-06
申请号：EP13002235.3
申请日：2013-04-26
申请人： SAP AG
发明人： Faerber, Franz , Lee, Juchang , Schreter, Ivan , Richtarsky, Martin
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.
摘要翻译：具有统一表架构的多级存储系统中的查询处理系统和方法。与统一表架构相连的通用查询执行引擎接收到查询，查询指定数据记录。普通查询执行引擎根据第一级存储结构的查询执行数据记录的查找。如果数据记录不存在于第一级存储结构中，则常见查询执行引擎在第二级存储结构和主存储中的每一个中执行单独的查找。

4. 发明公开

EP1995877A1 Compression of tables based on occurence of values 有权
标题翻译： Komprimierung von Tabellen basierend auf derWerthäufigkeit
公开(公告)号：EP1995877A1
公开(公告)日：2008-11-26
申请号：EP08005176.6
申请日：2008-03-19
申请人： SAP AG
发明人： Faerber, Franz , Radestock, Guenter , Ross, Andrew
IPC分类号： H03M7/30 , G06F17/30
CPC分类号： G06F17/30324 , G06F17/30477 , H03M7/30
摘要： Methods and apparatus, including computer program products, for compression of tables based on occurrence of values. In general, a number representing an amount of occurrences of a frequently occurring value in a group of adjacent rows of a column is generated (428), a vector representing whether the frequently occurring value exists in a row of the column is generated (422), and the number and the vector are stored to enable searches of the data represented by the number and the vector. The vector may omit a portion representing the group of adjacent rows (424). The values maybe dictionary-based compression values representing business data such as business objects. The values of the column may be sorted in order to increase the compression (416,418). The compression may be performed in-memory, in parallel, to improve memory utilization, network bandwidth consumption, and processing performance.
摘要翻译：方法和设备，包括计算机程序产品，用于根据值的发生压缩表。通常，生成表示列的相邻行的频繁出现值的出现次数（428），生成表示频繁出现的值是否存在于列的行中的矢量（422），并且存储数字和矢量以便能够搜索由数字和矢量表示的数据。矢量可以省略表示相邻行组（424）的部分。这些值可能是基于字典的压缩值，表示业务数据，如业务对象。可以对列的值进行排序以增加压缩（416,418）。可以并行地在内存中执行压缩，以提高存储器利用率，网络带宽消耗和处理性能。

5. 发明公开

EP2660735A1 Deleting records in a multi-level storage architecture 审中-公开
标题翻译： LöschenvonDatensätzen在einer mehrstufigen Speicherarchitektur
公开(公告)号：EP2660735A1
公开(公告)日：2013-11-06
申请号：EP13002283.3
申请日：2013-04-29
申请人： SAP AG
发明人： Faerber, Franz , Lee, Juchang , Schreter, Ivan , Richtarsky, Martin
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 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. 发明公开

EP2608066A3 Many core algorithms for in-memory column store databases 有权转让
标题翻译：许多核心算法，基于列的内存数据库
公开(公告)号：EP2608066A3
公开(公告)日：2013-09-04
申请号：EP12006185.8
申请日：2012-08-31
申请人： SAP AG
发明人： Dees, Jonathan , Sanders, Peter , Faerber, Franz , Seidel, Jochen
IPC分类号： G06F17/30
CPC分类号： G06F16/24544 , G06F16/24542
摘要： A pattern can be identified in at least part of a query whose definition is received in a query request. The identified pattern can be matched with a set of pre-defined patterns, each of which has associated therewith at least one pre-compiled query execution sub-component of a plurality of pre-compiled query execution sub-components retained in a library. A plan for executing the query can be generated, for example by incorporating the pre-compiled query execution sub-component associated with the matched pattern into the plan based on a pseudo code representation of the plan derived from the definition.

7. 发明公开

EP2386964A1 Integrated application server and data server processes with matching data formats 审中-公开
标题翻译： Integrierte Anwendungsserver- und Datenserverprozesse mitübereinstimmendenDatenformaten
公开(公告)号：EP2386964A1
公开(公告)日：2011-11-16
申请号：EP11003862.7
申请日：2011-05-11
申请人： SAP AG
发明人： Block, Meinolf , Strenge, Martin , Mohr, Christian , Gruschko, Boris , Faerber, Franz
IPC分类号： G06F17/30
CPC分类号： G06F17/30557
摘要： In one embodiment, the present invention includes a computer-implemented method comprising storing data in an application using an application custom data type and application custom data structure. The data is stored in a database using the application custom data type and the application custom data structure. In one embodiment, a request is sent to access the data from the application to the database. The data is retrieved from the database in response to the request in the application custom data type and the application custom data structure. In one embodiment, the data is sent from the database to a shared memory in the application custom data type and the application custom data structure and the data is retrieved by the application from the shared memory in the application custom data type and the application custom data structure.
摘要翻译：在一个实施例中，本发明包括计算机实现的方法，其包括使用应用定制数据类型和应用定制数据结构在应用中存储数据。使用应用程序自定义数据类型和应用程序自定义数据结构将数据存储在数据库中。在一个实施例中，发送请求以将数据从应用程序访问到数据库。响应于应用程序自定义数据类型和应用程序自定义数据结构中的请求，从数据库检索数据。在一个实施例中，将数据从数据库发送到应用程序自定义数据类型和应用程序自定义数据结构中的共享存储器，并且应用程序从应用程序从应用程序自定义数据类型和应用程序自定义数据中的共享存储器检索数据结构体。

8. 发明公开

EP2270684A1 Dictionary-based order-preserving string compression for main-memory column stores 有权转让
标题翻译： Wörterbuchbasierte，die Reihenfolge bewahrende String-Kompressionfürspaltenbasierte Hauptspeicherdatenbanken
公开(公告)号：EP2270684A1
公开(公告)日：2011-01-05
申请号：EP10004976.6
申请日：2010-05-11
申请人： SAP AG
发明人： Binnig, Carsten , Faerber, Franz , Hildenbrand, Stefan
IPC分类号： G06F17/30 , H03M7/30
CPC分类号： G06F17/30501 , G06F17/30454 , G06F17/30492
摘要： Methods and systems are described that involve usage of dictionaries for compressing a large set of variable-length string values with fixed-length integer keys in column stores. The dictionary supports updates (e.g., inserts of new string values) without changing codes for existing values. Furthermore, a shared-leaves approach is described for indexing such a dictionary that compresses the dictionary itself while offering access paths for encoding and decoding.
摘要翻译：描述了涉及使用字典来在列存储中压缩具有固定长度的整数键的大量可变长度字符串值的方法和系统。字典支持更新（例如插入新字符串值），而不更改现有值的代码。此外，描述了共享叶子方法，用于索引这样的字典，其压缩字典本身，同时提供用于编码和解码的访问路径。

9. 发明公开

EP1995878A3 Block compression of tables with repeated values 有权转让
标题翻译：遏制Vell Tabellen mit Wiederholten Werten
公开(公告)号：EP1995878A3
公开(公告)日：2009-07-08
申请号：EP08008447.8
申请日：2008-05-05
申请人： SAP AG
发明人： Faerber, Franz , Radestock, Guenter , Ross, Andrew
IPC分类号： H03M7/30
CPC分类号： G06F17/30153 , G06F17/30315 , G06F17/30321 , H03M7/3084 , H03M7/3088
摘要： Methods and apparatus, including computer program products, for block compression of tables with repeated values. In general, value identifiers representing a compressed column of data may be sorted to render repeated values contiguous, and block dictionaries may be generated. A block dictionary may be generated for each block of value identifiers. Each block dictionary may include a list of block identifiers, where each block identifier is associated with a value identifier and there is a block identifier for each unique value in a block. Blocks may have standard sizes and block dictionaries may be reused for multiple blocks.
摘要翻译：方法和装置，包括计算机程序产品，用于块重复值压缩表。通常，表示压缩数据列的值标识符可以被排序以使得重复值连续，并且可以生成块字典。可以为每个值标识符块生成块字典。每个块字典可以包括块标识符的列表，其中每个块标识符与值标识符相关联，并且对于块中的每个唯一值存在块标识符。块可以具有标准尺寸，并且块字典可以被重复用于多个块。

10. 发明公开

EP2595068A3 System and method of performing snapshot isolation in distributed databases 有权转让
标题翻译：系统与Verfahren zurDurchführungvon Snapshot-Isolierung in verteilten Datenbanken
公开(公告)号：EP2595068A3
公开(公告)日：2014-06-11
申请号：EP12006286.4
申请日：2012-09-06
申请人： SAP AG
发明人： Hildenbrand, Stefan , Binnig, Carsten , Faerber, Franz , Kossmann, Donald , Lee, Juchang , May, Norman
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.
摘要翻译：在分布式数据库中执行快照隔离的系统和方法。每个节点存储强制该节点的快照隔离的本地快照信息。该方法包括由第一节点部分地处理分布式事务，从协调器接收全局提交标识符，并且依照全局提交标识符继续由第一节点和第二节点处理分布式事务。

你已经成功收藏专利！

检索式保存成功!

IPRDB

热门服务

关于我们

友情链接

联系方式