-
11.
公开(公告)号:US20180246947A1
公开(公告)日:2018-08-30
申请号:US15445505
申请日:2017-02-28
Applicant: SAP SE
Inventor: Colin Florendo , Michael Muehle , Thorsten Glebe , Rolando Blanco , Chaitanya Gottipati , Nirvik Basak , Günter Radestock
Abstract: A computer implemented method for initializing a secondary database system includes receiving table state information from a primary database system at a secondary database system. The table state information includes information identifying which tables had an open operation during a savepoint event. Metadata associated with the tables is parsed to identify table state information from the metadata and a lock is created for each table identified as having an open operation during the savepoint event. Afterwards, log transaction information is sequentially parsed. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US20180150540A1
公开(公告)日:2018-05-31
申请号:US15409234
申请日:2017-01-18
Applicant: SAP SE
Inventor: Colin Florendo , Chaitanya Gottipati , Michael Muehle , Nirvik Basak , Mihnea Andrei , Thoms Peh
IPC: G06F17/30
Abstract: A computer implemented method for updating a secondary database includes receiving transaction log information from a primary database system at a secondary database system. The transaction log information comprises a first marker identifying a beginning of an operation comprising a plurality of sub-operations and a second marker identifying an end of the operation. The transaction log information is sequentially parsed, a first marker is identified, and a lock state is created after replaying the first marker to ensure proper serialization of the plurality of sub-operations. The lock state is terminated after replaying the second marker. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US11249968B2
公开(公告)日:2022-02-15
申请号:US15150301
申请日:2016-05-09
Applicant: SAP SE
Inventor: Thorsten Glebe , Martin Heidel , Michael Muehle , Felix Knittel , Reza Sherkat
Abstract: A method, computer program product and system are provided. The method, computer program product and system execute a process for storing an object in an object container that is stored in a persistency of a disk storage. The object container has size criteria whereby objects meeting the size criteria of the object container can be assigned to the object container. The object container can facilitate storing multiple objects to optimize disk storage usage by facilitating the assigning of multiple objects to the same disk storage page.
-
公开(公告)号:US11170023B2
公开(公告)日:2021-11-09
申请号: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: G06F16/27 , G06F16/23 , G06F16/2455 , G06F11/20
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.
-
公开(公告)号:US20200257672A1
公开(公告)日:2020-08-13
申请号:US16730528
申请日:2019-12-30
Applicant: SAP SE
Inventor: Juchang Lee , Joo Yeon Lee , Michael Muehle , Myung Sun Park , Hyoung Jun Na
IPC: G06F16/23 , G06F16/21 , G06F15/167 , G06F9/46
Abstract: Technologies are described for facilitating transaction processing within a database environment. A commit protocol provides for the atomic commit or rollback of a transaction that includes an operation that modifies a metadata entity of the database system and one or more other operations that modify metadata entities or data records of the database system. Innovations are provided for detecting and resolving deadlocks that may arise during transaction processing. Innovations are also provided for providing versioning of metadata entities, including invalidating metadata entities cached at a slave node during the commit at a master node of a transaction that creates a new version of the metadata entity.
-
公开(公告)号:US10585873B2
公开(公告)日:2020-03-10
申请号:US15589740
申请日:2017-05-08
Applicant: SAP SE
Inventor: Juchang Lee , Joo Yeon Lee , Michael Muehle , Myung Sun Park , Hyoung Jun Na
IPC: G06F16/23 , G06F9/46 , G06F15/167 , G06F16/21
Abstract: Technologies are described for facilitating transaction processing within a database environment. A commit protocol provides for the atomic commit or rollback of a transaction that includes an operation that modifies a metadata entity of the database system and one or more other operations that modify metadata entities or data records of the database system. Innovations are provided for detecting and resolving deadlocks that may arise during transaction processing. Innovations are also provided for providing versioning of metadata entities, including invalidating metadata entities cached at a slave node during the commit at a master node of a transaction that creates a new version of the metadata entity.
-
公开(公告)号:US20180150496A1
公开(公告)日:2018-05-31
申请号:US15361760
申请日:2016-11-28
Applicant: SAP SE
Inventor: Kyu Hwan Kim , Juchang Lee , Beomsoo Kim , Chang Gyoo Park , Reiner Singer , Christoph Rottering , Werner Thesing , Michael Muehle
IPC: G06F17/30
CPC classification number: G06F16/2322 , G06F16/2365 , G06F16/2379 , G06F16/2386 , G06F16/245 , G06F16/27 , G06F16/273
Abstract: A computer implemented method is provided comprising receiving a group of transaction logs from a first database, allocating transaction logs from the group of transaction logs to a first queue and to a second queue, generating an end-of-group transaction log indicative of an end of the group of transaction logs, allocating the end-of-group log to the first queue and the second queue; replaying transaction logs from the first queue including the end-of-group transaction log allocated to the first queue, replaying transaction logs from the second queue including the end-of-group transaction log allocated to the second queue; and changing visibility of one or more transactions in response to replaying the end-of-group transaction log allocated to the first queue and the end-of-group transaction log allocated to the second queue. Related apparatus, systems, techniques and articles are also described.
-
公开(公告)号:US20170322960A1
公开(公告)日:2017-11-09
申请号:US15150301
申请日:2016-05-09
Applicant: SAP SE
Inventor: Thorsten Glebe , Martin Heidel , Michael Muehle , Felix Knittel , Reza Sherkat
CPC classification number: G06F16/2228 , G06F3/0608 , G06F3/064 , G06F3/0674 , G06F16/2219
Abstract: A method, computer program product and system are provided. The method, computer program product and system execute a process for storing an object in an object container that is stored in a persistency of a disk storage. The object container has size criteria whereby objects meeting the size criteria of the object container can be assigned to the object container. The object container can facilitate storing multiple objects to optimize disk storage usage by facilitating the assigning of multiple objects to the same disk storage page.
-
公开(公告)号:US12147558B2
公开(公告)日:2024-11-19
申请号:US17968136
申请日:2022-10-18
Applicant: SAP SE
Inventor: Patrick Voelker , Holger Mack , Meinolf Block , Thorsten Glebe , Mihnea Andrei , Yong Sik Kwon , Dirk Thomsen , Martin Schindewolf , Martin Kittel , Myung Sun Park , Beomsoo Kim , Martin Heidel , Christian Bensberg , Fabian Garagnon , Michael Muehle , Sergej Hardock , Johannes Beigel , Sascha Zorn , Christoph Hohner , Andreas Hartel
Abstract: A database system includes a persistent storage system, a memory storing metadata defining a tenant object and a plurality of database artifacts, a first instance of the tenant object, the first instance associated with a first plurality of the database artifacts including first data associated with the first instance of the tenant object, and a second instance of the tenant object, the second instance associated with a second plurality of the database artifacts including second data associated with the second instance of the tenant object. A processing unit is to execute program code of a database instance to cause the database system to encrypt the first data associated with the first instance of the tenant object using a first public encryption key and store the encrypted first data in the persistent storage system, and encrypt the second data associated with the second instance of the tenant object using a second public encryption key and store the encrypted second data in the persistent storage system.
-
公开(公告)号:US11314716B2
公开(公告)日:2022-04-26
申请号:US16730528
申请日:2019-12-30
Applicant: SAP SE
Inventor: Juchang Lee , Joo Yeon Lee , Michael Muehle , Myung Sun Park , Hyoung Jun Na
IPC: G06F16/23 , G06F9/46 , G06F15/167 , G06F16/21
Abstract: Technologies are described for facilitating transaction processing within a database environment. A commit protocol provides for the atomic commit or rollback of a transaction that includes an operation that modifies a metadata entity of the database system and one or more other operations that modify metadata entities or data records of the database system. Innovations are provided for detecting and resolving deadlocks that may arise during transaction processing. Innovations are also provided for providing versioning of metadata entities, including invalidating metadata entities cached at a slave node during the commit at a master node of a transaction that creates a new version of the metadata entity.
-
-
-
-
-
-
-
-
-