-
公开(公告)号: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.
-
22.
公开(公告)号:US20180150539A1
公开(公告)日:2018-05-31
申请号:US15365396
申请日:2016-11-30
Applicant: SAP SE
Inventor: Mihnea Andrei , Rolando Blanco , Shiping Chen , Martin Heidel , Vivek Kandiyanallur , Thomas Peh , Joern Schmidt , Liang Song , Peter Steinemann
IPC: G06F17/30
CPC classification number: G06F16/2379 , G06F16/2358
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. If the data objects are not in the main memory, they are copied from persistence data volumes to the main memory. The data objects 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.
-
公开(公告)号:US20170364554A1
公开(公告)日:2017-12-21
申请号:US15186300
申请日:2016-06-17
Applicant: SAP SE
Inventor: Anisoara Nica , Peter Bumbulis , Reza Sherkat , Mihnea Andrei , Anil K. Goel
IPC: G06F17/30
CPC classification number: G06F16/24534 , G06F16/2228 , G06F16/2455
Abstract: Cracking page-loadable columns for in-memory data management is described herein. An embodiment operates by accessing a column according to a received query, determining that the received query requires a non-critical data structure associated with the column, and rebuilding the non-critical data structure from data associated with the column.
-
公开(公告)号:US20170154061A1
公开(公告)日:2017-06-01
申请号:US14954736
申请日:2015-11-30
Applicant: SAP SE
Inventor: Reza SHERKAT , Ivan Schreter , Robert Schulze , Mihnea Andrei , Colin Florendo , Christian Lemke , Sebastian Seifert
CPC classification number: G06F17/30339 , G06F17/30336 , G06F17/30424 , G06F17/30622 , H03M7/60
Abstract: Disclosed herein are system and method embodiments for generating a paged inverted index. An embodiment is generated by storing a first data structure and the second data structure in a plurality of pages, where the plurality of pages are stored in the one or more memories. The first data structure is stored in the plurality of pages and includes a plurality of value identifiers, where a value identifier corresponds to an offset. The second data structure stored in the plurality of pages includes a plurality of row positions, wherein a row position is at a location that corresponds to the offset in the first data structure and identifies a position of row in a table that stores data associated with the value ID.
-
公开(公告)号:US20250165453A1
公开(公告)日:2025-05-22
申请号:US18515731
申请日:2023-11-21
Applicant: SAP SE
Inventor: Janardhan Hungund , Amit Pathak , Amit Saonerker , Deepak Shrivastava , Souvik Pal , Sebastian Seifert , Robert Schulze , Mihnea Andrei
Abstract: A database system detects an operation to move a first database object from an in-memory store to a persistence store, wherein the first database object is in either a page-loadable or column-loadable format in the in-memory store, and wherein the first database object comprises a plurality of subcomponents. Each subcomponent of the first database object is examined separately from other subcomponents of the plurality of subcomponents. In response to determining that a first subcomponent of the plurality of subcomponents has a datatype and a compression type supported by a unified persistence format, the first subcomponent is stored in a unified persistence format in the persistence store. In response to determining that a second subcomponent of the plurality of subcomponents has either a datatype or a compression type which is not supported by the unified persistence format, the second subcomponent is stored in a serial persistence format in the persistence store.
-
公开(公告)号:US12242359B2
公开(公告)日:2025-03-04
申请号:US18185872
申请日:2023-03-17
Applicant: SAP SE
Inventor: Uwe Hahn , Eunsang Kim , Mihnea Andrei , Werner Thesing , Patrick Voelker , Ruediger Karl , Yong Sik Kwon , Jaeyoung Choi , Jian Luo , Hyunjun Kim , Andre Schefe , Urs Klingsporn , Norman May
Abstract: Systems and methods include reception of an instruction to recover a first database tenant of a first database instance to a first point in time, the first database tenant associated with first database artifacts of the first database instance, and the first database instance including two or more database tenants and, in response to the instruction, creation of a second database instance, selection of backup data of the first database instance based on the first point in time, execution of a recovery of the backup data on the second database instance, export of second database artifacts of the first database tenant from the second database instance to a storage, truncation of the first database artifacts from the first database instance, import of the second database artifacts from the storage to the first database instance, and deletion of the second database instance.
-
公开(公告)号:US20230259522A1
公开(公告)日:2023-08-17
申请号:US18137693
申请日:2023-04-21
Applicant: SAP SE
Inventor: Ruediger Karl , Mihnea Andrei , Juchang Lee , Stefan Baeuerle , Seyeong Bae , Joo Yeon Lee
IPC: G06F16/25 , G06F16/23 , G06F16/22 , G06F16/2455 , G06F16/21
CPC classification number: G06F16/256 , G06F16/23 , G06F16/2282 , G06F16/24552 , G06F16/214
Abstract: Techniques and solutions are described for implementing virtual table schemas. A virtual table schema includes a logical pointer that is used to target a table that includes data and is defined according to the virtual table schema. Values assigned to the logical pointer can be used to target tables at different locations, such as in a federated database system or in a cache of a database management system of a central computing system. When data associated with the virtual table is requested, or prior to receiving the request, the data can be stored in a table in the cache. The logical pointer can be updated to reference the cache. If the cache is full, the table can be removed from the cache, and the logical pointer can be updated to reference a table at the federated database system.
-
公开(公告)号:US11669539B2
公开(公告)日:2023-06-06
申请号:US17646982
申请日:2022-01-04
Applicant: SAP SE
Inventor: Ruediger Karl , Mihnea Andrei , Juchang Lee , Stefan Baeuerle , Seyeong Bae , Joo Yeon Lee
IPC: G06F16/25 , G06F16/23 , G06F16/22 , G06F16/2455 , G06F16/21
CPC classification number: G06F16/256 , G06F16/214 , G06F16/2282 , G06F16/23 , G06F16/24552
Abstract: Techniques and solutions are described for implementing virtual table schemas. A virtual table schema includes a logical pointer that is used to target a table that includes data and is defined according to the virtual table schema. Values assigned to the logical pointer can be used to target tables at different locations, such as in a federated database system or in a cache of a database management system of a central computing system. When data associated with the virtual table is requested, or prior to receiving the request, the data can be stored in a table in the cache. The logical pointer can be updated to reference the cache. If the cache is full, the table can be removed from the cache, and the logical pointer can be updated to reference a table at the federated database system.
-
公开(公告)号:US11567969B2
公开(公告)日:2023-01-31
申请号:US15991115
申请日:2018-05-29
Applicant: SAP SE
Inventor: Gerrit Graefe , Friedrich Keller , Mihnea Andrei
Abstract: Provided is a database system and method in which storage is partitioned in an unbalanced format for faster access. In one example, the method may include one or more of receiving a request to store a data record, identifying a partition from among a plurality of partitions of a database based on a shard identifier in the request, automatically determining a unique range of data identifiers designated to the partition from the plurality of partitions, respectively, based on an unbalanced partitioning, determining whether the data identifier is available within the unique range of data identifiers of the identified partition, and storing the data record at the identified partition in response to determining the data identifier is available. The unbalanced partitioning according to various embodiments reduces the partitions that need to be checked during a data insert/access operation of the database.
-
公开(公告)号:US11500928B2
公开(公告)日:2022-11-15
申请号:US16734907
申请日:2020-01-06
Applicant: SAP SE
Inventor: Panfeng Zhou , Mihnea Andrei , Vivek Kandiyanallur , Xin Liu , Neeraj Kulkarni
IPC: G06F16/835 , G06F16/84 , G06F16/25 , G06F16/174 , G06F16/21 , G06F16/90 , G06F16/907
Abstract: A system and method, including determining, by a processor, a data type for each column of a database table; determining, by the processor and based on the determined data type for each column of the database table, an indication of a size of the database table; calculating, by the processor and based on the determined indication of the size of the database table, a start nbit size for a nbit compression process to be used on the database table; specifying, by the processor, the calculated start nbit size for the nbit compression process; and compressing the database table by executing the nbit data compression process using the specified start nbit size.
-
-
-
-
-
-
-
-
-