-
公开(公告)号:US11514027B2
公开(公告)日:2022-11-29
申请号:US16857982
申请日:2020-04-24
Applicant: SAP SE
Inventor: Reza Sherkat , Chaitanya Gottipati , Colin Florendo , Martin Heidel
IPC: G06F16/22 , G06F16/23 , G06F12/02 , G06F3/06 , G06F12/0882 , G06F16/2455 , G06F12/0875 , G06F9/48
Abstract: Disclosed herein are system, method, and computer program product embodiments for storing a large object (LOB) in a database. An embodiment operates by identifying the LOB to be stored in an on-disk store of the database and determining the size of the LOB. Thereafter, an index vector for the on-disk store to include an identifier corresponding to the LOB is created. Additionally, a dictionary for the on-disk store to include a copy of the identifier and corresponding LOB data is also created. The LOB data corresponds to the LOB itself or a LOB location inside of the on-disk store based on the LOB's size.
-
公开(公告)号:US20170371909A1
公开(公告)日:2017-12-28
申请号:US15361337
申请日:2016-11-25
Applicant: SAP SE
Inventor: Mihnea Andrei , Christian Bensberg , Alexander Boehm , Adrian Draguseanu , Xun Chen , Reza Sherkat , Ani Nica , Martin Heidel , Rolando Blanco
IPC: G06F17/30
CPC classification number: G06F16/282 , G06F16/21
Abstract: Persisting data in logical tiers of an in-memory database based on aging rules of the database system. The database system can be configured to age data by moving the data from a first logical tier supporting high performance data access to a second logical tier supporting lower performance data access, thereby improving the operational efficiency of the database system.
-
公开(公告)号:US20170083538A1
公开(公告)日:2017-03-23
申请号:US14861438
申请日:2015-09-22
Applicant: SAP SE
Inventor: Andreas Tonder , Martin Heidel , Edward-Robert Tyercha , Juchang Lee
IPC: G06F17/30
Abstract: Disclosed herein are system, method, and computer program product embodiments for performing database processing after a lock condition. An embodiment operates by receiving a release of a lock on data of a database. It is determined whether the data was modified by a processing of a first transaction associated with the first request. The lock is provided to a second transaction associated with a second request to access the data. If the first transaction did not modify the data, a second transaction associated with the second request is retried without refreshing a snapshot of the data. If the first transaction modified the data, the snapshot of the data is refreshed before the second transaction is retried.
-
公开(公告)号:US11176004B2
公开(公告)日:2021-11-16
申请号:US16371889
申请日:2019-04-01
Applicant: SAP SE
Inventor: Stephan Kottler , Martin Heidel , Peter Steinemann , Thorsten Glebe , Johannes Haeussler
Abstract: A method, a system, and a computer program product for performing testing of continuous log replays in a database system. A redo log generated for a data record in a database is received. The redo log is indicative of a change in persistency of the data record in the database. Based on the change in persistency recorded in the redo log, a redo handler in the plurality of handlers is selected for execution of a replay of the received redo log. Using the selected redo log, replay of the redo log is executed to generate a state of the data record prior to the change in persistency recoded in the redo log.
-
公开(公告)号:US20200310925A1
公开(公告)日:2020-10-01
申请号:US16371889
申请日:2019-04-01
Applicant: SAP SE
Inventor: Stephan Kottler , Martin Heidel , Peter Steinemann , Thorsten Glebe , Johannes Haeussler
Abstract: A method, a system, and a computer program product for performing testing of continuous log replays in a database system. A redo log generated for a data record in a database is received. The redo log is indicative of a change in persistency of the data record in the database. Based on the change in persistency recorded in the redo log, a redo handler in the plurality of handlers is selected for execution of a replay of the received redo log. Using the selected redo log, replay of the redo log is executed to generate a state of the data record prior to the change in persistency recoded in the redo log.
-
公开(公告)号:US20190317865A1
公开(公告)日:2019-10-17
申请号:US15953856
申请日:2018-04-16
Applicant: SAP SE
Inventor: Martin Heidel , Xin Liu , Christoph Roterring , Shiping Chen , Vivek Kandiyanallur , Stephan Kottler , Joern Schmidt
Abstract: Disclosed herein are system, method, and computer program product embodiments for a database recovery and optimization with batch processing system. An embodiment operates by retrieving a database log that includes a plurality of operations for modifying data of a database stored across a plurality of tables. From the database log, a plurality of consecutive insert operations for inserting data into the database are identified. The consecutive insert operations are sorted by table. The sorted insert operations are grouped into a batch message. The batch message is transmit to the database for replay. An acknowledgement is received that the replay has completed.
-
公开(公告)号:US20180246948A1
公开(公告)日:2018-08-30
申请号:US15445593
申请日:2017-02-28
Applicant: SAP SE
Inventor: Colin Florendo , Michael Muehle , Thorsten Glebe , Rolando Blanco , Chaitanya Gottipati , Nirvik Basak , Martin Heidel , Peter Steinemann , Vivek Kandiyanallur , Shiping Chen , Sarika Iyer , Jörn Schmidt
IPC: G06F17/30
CPC classification number: G06F16/273 , G06F11/2094 , G06F11/2097 , G06F16/2365 , G06F16/2455 , G06F2201/80 , G06F2201/855
Abstract: A computer implemented method for manipulating data comprises receiving log transaction information from a primary database system at a secondary database system and parsing the log transaction information to identify data objects that have been modified on the primary database system. The secondary database system determines whether the data objects are present in main memory on the secondary database system and whether the log transaction corresponds to a data manipulation language (DML) query or a data definition language (DDL) query. If the data objects are not in the main memory and the query is a DML query, they are copied from persistence data volumes to the main memory. The data objects in main memory are modified by replaying the log transactions on the data objects in the main memory. Then, the data objects in the persistence data volumes are modified. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US10915413B2
公开(公告)日:2021-02-09
申请号:US15410701
申请日:2017-01-19
Applicant: SAP SE
Inventor: Martin Heidel , Andreas Tonder , Shiping Chen
Abstract: Restoring of a database table in the database system (e.g., an in-memory insert-only database system, etc.) is initiated. Thereafter, a transaction log volume storing data log records and multi-version concurrency control (MVCC) log records corresponding to the database table is accessed. Based on such access, data log records corresponding to the database table are replayed while insert and update MVCC log records corresponding to the database table are skipped. Subsequently, restoring of the database table in the database system is finalized. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US10824519B2
公开(公告)日:2020-11-03
申请号:US15953856
申请日:2018-04-16
Applicant: SAP SE
Inventor: Martin Heidel , Xin Liu , Christoph Roterring , Shiping Chen , Vivek Kandiyanallur , Stephan Kottler , Joern Schmidt
IPC: G06F11/14 , G06F16/21 , G06F16/22 , G06F16/23 , G06F16/2455
Abstract: Disclosed herein are system, method, and computer program product embodiments for a database recovery and optimization with batch processing system. An embodiment operates by retrieving a database log that includes a plurality of operations for modifying data of a database stored across a plurality of tables. From the database log, a plurality of consecutive insert operations for inserting data into the database are identified. The consecutive insert operations are sorted by table. The sorted insert operations are grouped into a batch message. The batch message is transmit to the database for replay. An acknowledgement is received that the replay has completed.
-
公开(公告)号:US10706019B2
公开(公告)日:2020-07-07
申请号:US14861438
申请日:2015-09-22
Applicant: SAP SE
Inventor: Andreas Tonder , Martin Heidel , Edward-Robert Tyercha , Juchang Lee
IPC: G06F17/30 , G06F16/176 , G06F16/23
Abstract: Disclosed herein are system, method, and computer program product embodiments for performing database processing after a lock condition. An embodiment operates by receiving a release of a lock on data of a database. It is determined whether the data was modified by a processing of a first transaction associated with the first request. The lock is provided to a second transaction associated with a second request to access the data. If the first transaction did not modify the data, a second transaction associated with the second request is retried without refreshing a snapshot of the data. If the first transaction modified the data, the snapshot of the data is refreshed before the second transaction is retried.
-
-
-
-
-
-
-
-
-