Patents by Inventor Bernhard Scheirle
Bernhard Scheirle has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 12332874Abstract: 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.Type: GrantFiled: December 6, 2023Date of Patent: June 17, 2025Assignee: SAP SEInventors: Bernhard Scheirle, Andreas Tonder, Carsten Thiel, Guenter Radestock, Thomas Legler, Martin Heidel, Robert Schulze, Joern Schmidt, Rolando Blanco
-
Publication number: 20250190416Abstract: A database system detects a query targeting a first database object stored in a unified persistence format in a persistence store, where a first load unit is specified for loading the first database object into an in-memory store. The database system determines whether to convert the first load unit to a second load unit based on one or more conditions. In response to determining to convert the first load unit to the second load unit for the first database object, the first database object is loaded into the in-memory store according to the second load unit without performing a rewrite of the first database object in the persistence store. In an example, the first load unit is a column-loadable unit and the second load unit is a page-loadable unit.Type: ApplicationFiled: December 11, 2023Publication date: June 12, 2025Inventors: Souvik Pal, Deepak Shrivastava, Kantikumar Kantikumar, Janardhan Hungund, Sebastian Seifert, Bernhard Scheirle, Amit Pathak, Amit Saonerker, Amit Sankhla
-
Publication number: 20250181601Abstract: A system for managing data persistence formats in a computing system, comprising, at least one data processor; and at least one memory result in operations comprising: computing an estimated serial size (ES) for a dataset; computing an estimated unified size (EU) for the dataset; selecting, based at least in part on a predefined set of rules, between a serial persistence format and a unified persistence format to store the dataset, wherein the selection is based at least in part on the computed estimated serial size and the computed estimated unified size; storing the selected persistence format in a metadata associated with the stored dataset; and in response to a loading request, loading the stored dataset by referring to the metadata.Type: ApplicationFiled: December 5, 2023Publication date: June 5, 2025Inventors: Ishita Gupta, Janardhan Hungund, Amit Saonerker, Jagadeesha Kanihal, Amit Pathak, Sebastian Seifert, Bernhard Scheirle, Neha Shikha Kachhap
-
Patent number: 12282494Abstract: A primary database system loads database objects into a primary in-memory store according to a given format. The primary database captures, in replay logs, the loading of the database objects according to the given format. The primary database sends the replay logs to a secondary database system. In response to receiving a replay log, the secondary database checks the value of a log replay configuration parameter. If the configuration parameter is a first value, the secondary database replays the replay log to load the corresponding database objects into a secondary in-memory store according to a first format. If the configuration parameter is a second value, the secondary database replays the log to load the objects according to a second format, and if the configuration parameter is a third value, the secondary database replays the log to load the objects in a same format which was used by the primary database.Type: GrantFiled: December 5, 2023Date of Patent: April 22, 2025Assignee: SAP SEInventors: Janardhan Hungund, Neha Shikha Kachhap, Jagadeesha Kanihal, Sebastian Seifert, Bernhard Scheirle, Amit Pathak, Werner Thesing, Thomas Peh
-
Patent number: 12072888Abstract: Embodiments of the present disclosure include techniques for cooperative memory management. In one embodiment, a database management system includes a memory manager for managing a memory buffer. The memory buffer is configured to allocate memory to table data and temporary data dynamically. In some embodiments, table data memory allocations are reduced and temporary data memory allocations are increased to process queries. Temporary data memory allocations may be increased to store temporary data associated with one or more portions of a query. The memory buffer reallocates table data memory allocations and temporary data memory allocations as needed to more efficiently use available memory.Type: GrantFiled: May 12, 2023Date of Patent: August 27, 2024Assignee: SAP SEInventors: Robert Lasch, Thomas Legler, Norman May, Kai-Uwe Sattler, Bernhard Scheirle
-
Publication number: 20240111757Abstract: 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.Type: ApplicationFiled: December 6, 2023Publication date: April 4, 2024Inventors: Bernhard Scheirle, Andreas Tonder, Carsten Thiel, Guenter Radestock, Thomas Legler, Martin Heidel, Robert Schulze, Joern Schmidt, Rolando Blanco
-
Patent number: 11886424Abstract: 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.Type: GrantFiled: September 22, 2021Date of Patent: January 30, 2024Assignee: SAP SEInventors: Bernhard Scheirle, Andreas Tonder, Carsten Thiel, Guenter Radestock, Thomas Legler, Martin Heidel, Robert Schulze, Joern Schmidt, Rolando Blanco
-
Publication number: 20230086162Abstract: 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.Type: ApplicationFiled: September 22, 2021Publication date: March 23, 2023Inventors: Bernhard Scheirle, Andreas Tonder, Carsten Thiel, Guenter Radestock, Thomas Legler, Martin Heidel, Robert Schulze, Joern Schmidt, Rolando Blanco
-
Patent number: 10769075Abstract: 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.Type: GrantFiled: November 21, 2018Date of Patent: September 8, 2020Assignee: SAP SEInventors: Carsten Thiel, Guenter Radestock, Martin Richtarsky, Bernhard Scheirle
-
Patent number: 10628325Abstract: A system includes a volatile random access memory storing first header data and a first data block, the first header data including descriptive information and a first pointer to the first data block, and a non-volatile random access memory. The system includes 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 the descriptive information and a binary copy of the first data block at the address of the non-volatile random access memory.Type: GrantFiled: November 21, 2018Date of Patent: April 21, 2020Assignee: SAP SEInventors: Carsten Thiel, Guenter Radestock, Sebastian Seifert, Christian Lemke, Rolando Blanco, Muhammed Sharique, Surendra Vishnoi, Mihnea Andrei, Bernhard Scheirle
-
Publication number: 20190347208Abstract: A system includes a volatile random access memory storing first header data and a first data block, the first header data including descriptive information and a first pointer to the first data block, and a non-volatile random access memory. The system includes 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 the descriptive information and a binary copy of the first data block at the address of the non-volatile random access memory.Type: ApplicationFiled: November 21, 2018Publication date: November 14, 2019Inventors: Carsten Thiel, Guenter Radestock, Sebastian Seifert, Christian Lemke, Rolando Blanco, Muhammed Sharique, Surendra Vishnoi, Mihnea Andrei, Bernhard Scheirle
-
Publication number: 20190347022Abstract: 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.Type: ApplicationFiled: November 21, 2018Publication date: November 14, 2019Inventors: Carsten Thiel, Guenter Radestock, Martin Richtarsky, Bernhard Scheirle