-
公开(公告)号：US20240111757A1
公开(公告)日：2024-04-04
申请号：US18530819
申请日：2023-12-06
Applicant: SAP SE
Inventor： Bernhard Scheirle , Andreas Tonder , Carsten Thiel , Guenter Radestock , Thomas Legler , Martin Heidel , Robert Schulze , Joern Schmidt , Rolando Blanco
IPC: G06F16/23
CPC classification number: G06F16/2379
Abstract: A method may include receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database. A validity period for the record may be determined based on a first commit time at which the first transaction is committed and a second commit time at which the second transaction is committed. A current table and/or a history table of a system versioned table may be updated to include the record based on the validity period of the record. One or more temporal operations may be performed based on the system versioned table. For example, a time travel operation may be performed to retrieve, based on the system versioned table, one or more records that are valid at a given point in time. Related systems and computer program products are also provided.
-
公开(公告)号：US11886424B2
公开(公告)日：2024-01-30
申请号：US17481644
申请日：2021-09-22
Applicant: SAP SE
Inventor： Bernhard Scheirle , Andreas Tonder , Carsten Thiel , Guenter Radestock , Thomas Legler , Martin Heidel , Robert Schulze , Joern Schmidt , Rolando Blanco
CPC classification number: G06F16/2379
Abstract: A method may include receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database. A validity period for the record may be determined based on a first commit time at which the first transaction is committed and a second commit time at which the second transaction is committed. A current table and/or a history table of a system versioned table may be updated to include the record based on the validity period of the record. One or more temporal operations may be performed based on the system versioned table. For example, a time travel operation may be performed to retrieve, based on the system versioned table, one or more records that are valid at a given point in time. Related systems and computer program products are also provided.
-
公开(公告)号：US20230086162A1
公开(公告)日：2023-03-23
申请号：US17481644
申请日：2021-09-22
Applicant: SAP SE
Inventor： Bernhard Scheirle , Andreas Tonder , Carsten Thiel , Guenter Radestock , Thomas Legler , Martin Heidel , Robert Schulze , Joern Schmidt , Rolando Blanco
IPC: G06F16/23
Abstract: A method may include receiving a first transaction inserting a record into a database and a second transaction deleting the record from the database. A validity period for the record may be determined based on a first commit time at which the first transaction is committed and a second commit time at which the second transaction is committed. A current table and/or a history table of a system versioned table may be updated to include the record based on the validity period of the record. One or more temporal operations may be performed based on the system versioned table. For example, a time travel operation may be performed to retrieve, based on the system versioned table, one or more records that are valid at a given point in time. Related systems and computer program products are also provided.
-
公开(公告)号：US10761994B2
公开(公告)日：2020-09-01
申请号：US16197803
申请日：2018-11-21
Applicant: SAP SE
Inventor： Carsten Thiel , Guenter Radestock
Abstract: A system in which first header data and a first logical array are stored in a volatile random access memory, the first logical array stored in a first contiguous memory block, with each array position of the first logical array representing a position in a database table and storing a value identifier of a value associated with the position in the database table, and with the first header data indicating a number of bits used to encode the value identifiers and comprising a first pointer to the first contiguous memory block. A memory size associated with the first header data and the first contiguous memory block is determined, a first memory block of the non-volatile random access memory is allocated based on the determined memory size, an address of the non-volatile random access memory associated with the allocated first memory block is determined, and the number of bits and a binary copy of the first contiguous memory block are written at the address of the non-volatile random access memory.
-
Patent Agency Ranking
公开(公告)号：US09612945B1
公开(公告)日：2017-04-04
申请号：US14949780
申请日：2015-11-23
Applicant: SAP SE
Inventor： Daniel Booss , Guenter Radestock , Mehul Wagle
CPC classification number: G06F11/3688 , G06F8/443 , G06F9/4484 , G06F11/3409 , G06F11/3419 , G06F11/3466 , G06F11/3612
Abstract: Instances of a call stack executing in a database management system and separated by a sampling interval can be compared and upwardly traversed until reaching a point of difference between the instances. A call counter can be incremented for each new frame identified in the second instance of the call stack since the point of difference such that relative call count frequencies of multiple frames (which can include function calls) can be determined. Systems, methods, and computer program products are described.
-
公开(公告)号：US10884987B2
公开(公告)日：2021-01-05
申请号：US15231621
申请日：2016-08-08
Applicant: SAP SE
Inventor： Franz Faerber , Guenter Radestock , Andrew Ross
IPC: G06F16/00 , G06F16/174 , G06F16/22 , H03M7/30
Abstract: 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.
-
公开(公告)号：US10769075B2
公开(公告)日：2020-09-08
申请号：US16197851
申请日：2018-11-21
Applicant: SAP SE
Inventor： Carsten Thiel , Guenter Radestock , Martin Richtarsky , Bernhard Scheirle
Abstract: A system includes storage, in a volatile random access memory, of a first data block comprising an array of distinct values of a database table column, and first header data comprising a first pointer to the first data block, determination of a memory size associated with the first header data and the first data block, allocation of a first memory block of the non-volatile random access memory based on the determined memory size, determination of an address of the non-volatile random access memory associated with the allocated first memory block, and writing of an indicator of the number of distinct values of the array and a binary copy of the first data block at the address of the non-volatile random access memory.
-
公开(公告)号：US10740246B2
公开(公告)日：2020-08-11
申请号：US16197969
申请日：2018-11-21
Applicant: SAP SE
Inventor： Carsten Thiel , Guenter Radestock
Abstract: A system in which first header data, second header data, a first logical array and a second logical array are stored in volatile random access memory. Each array position of the first logical array represents an identifier of a database column value and stores an offset value associated with an array position of the second logical array, and each array position of the second logical array stores a row position of the database column value. A memory size associated with the first header data, the second header data, the first logical array and the second logical array is determined, a first memory block of a non-volatile random access memory is allocated based on the determined memory size, an address of the non-volatile random access memory associated with the allocated first memory block is determined, and a portion of the first header data, a portion of the second header data, a binary copy of the first logical array and a binary copy of the second logical array are written at the address of the non-volatile random access memory.
-
公开(公告)号：US20170031944A1
公开(公告)日：2017-02-02
申请号：US15231621
申请日：2016-08-08
Applicant: SAP SE
Inventor： Franz Faerber , Guenter Radestock , Andrew Ross
IPC: G06F17/30
CPC classification number: G06F16/1744 , G06F16/221 , G06F16/2228 , H03M7/3084 , H03M7/3088
Abstract: 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.
Abstract translation: 方法和装置，包括计算机程序产品，用于块重复值压缩表。 通常，表示压缩数据列的值标识符可以被排序以使重复值连续，并且可以生成块字典。 可以为每个值标识符块生成块字典。 每个块字典可以包括块标识符的列表，其中每个块标识符与值标识符相关联，并且在块中存在每个唯一值的块标识符。 块可以具有标准尺寸，并且块字典可以重用于多个块。
-
-
-
-
-
-
-
-
Search Results
9
records
(took 0.012 seconds)
