公开(公告)号：US20220269655A1

公开(公告)日：2022-08-25

申请号：US17316901

申请日：2021-05-11

Applicant: SAP SE

Inventor： Michael Brendle ,  Norman May ,  Robert Schulze ,  Alexander Boehm ,  Guido Moerkotte ,  Michael Grossniklaus

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/2453 ,  G06F16/2455 ,  G06F11/34

Abstract: The present disclosure involves systems, software, and computer implemented methods for improved design and implementation of data access metrics for automated physical database design. An example method includes identifying a database workload for which index advisor access counters are to be tracked. Each SQL statement in the database workload is executed. For each SQL statement, attribute sets are determined for which a selection predicate filters a result for an SQL statement. An output cardinality of each selection predicate is determined. A logarithmic counter for an attribute set corresponding to the selection predicate is determined based on the output cardinality of the selection predicate. The determined logarithmic counter is incremented. Respective values for logarithmic counters of the determined attributes are provided to an index advisor. The index advisor determines attribute sets for which to propose an index based on the logarithmic counters of the respective attribute sets.

公开(公告)号：US10885062B2

公开(公告)日：2021-01-05

申请号：US15361337

申请日：2016-11-25

Applicant: SAP SE

Inventor： Mihnea Andrei ,  Christian Bensberg ,  Alexander Boehm ,  Adrian Dragusanu ,  Xun Chen ,  Reza Sherkat ,  Anisoara Nica ,  Martin Heidel ,  Rolando Blanco

IPC: G06F16/28 ,  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.

公开(公告)号：US10824673B2

公开(公告)日：2020-11-03

申请号：US15695621

申请日：2017-09-05

Applicant: SAP SE

Inventor： Oliver Rebholz ,  Ivan Schreter ,  Abdelkader Sellami ,  Daniel Booss ,  Gunter Radestock ,  Peter Bumbulis ,  Alexander Boehm ,  Frank Renkes ,  Werner Thesing ,  Thomas Willhalm

IPC: G06F16/901 ,  G06F3/06

Abstract: A system includes a non-volatile random access memory storing a column store main fragment of a column of a database table, and a processing unit to read the column store main fragment from the non-volatile random access memory. A volatile random access memory storing a column store delta fragment of the column of the database table may also be included, in which the processing unit is to write to the column store delta fragment. According to some systems, the stored column store main fragment is byte-addressable, and is copied from the volatile random access memory to the non-volatile random access memory without using a filesystem cache.

公开(公告)号：US20180329974A1

公开(公告)日：2018-11-15

申请号：US15796365

申请日：2017-10-27

Applicant: SAP SE

Inventor： Christian Bensberg ,  Alexander Boehm ,  Adrian Dragusanu ,  Xun Cheng ,  Reza Sherkat ,  Anisoara Nica ,  Mihnea Andrei

IPC: G06F17/30

CPC classification number: G06F17/30303

Abstract: Disclosed herein are system, method, and computer program product embodiments for determining a constraint data statistics object is consistent. An embodiment operates by receiving a query for a database table. The embodiment determines a constraint data statistic object associated with a partition of the database table. The embodiment determines the constraint data statistics object is consistent with a data state of the partition of the database table based on consistency metadata of the constraint data statistics object. The embodiment processes the query for the database table based on the determining the constraint data statistics object is consistent with the data state of the partition of the database table.

公开(公告)号：US20170177663A1

公开(公告)日：2017-06-22

申请号：US14975086

申请日：2015-12-18

Applicant: SAP SE

Inventor： Guido Moerkotte ,  Norman May ,  Alexander Boehm

IPC: G06F17/30

CPC classification number: G06F16/24534 ,  G06F16/1744 ,  G06F16/2246 ,  G06F16/2453 ,  G06F16/283

Abstract: A method, medium, and system to generate cardinality estimates for at least one query execution plan for a query by representing a given set of multidimensional data including a plurality of data points having a value by a hierarchical tree data structure including nodes, each node representing a distribution of a subset of the points in the data set and being partitioned into tiles; calculating a bounding rectangle of the data points in each node; entering all non-empty tiles into a queue; processing of the queue can continue until a computational memory space limit is reached or until a desired estimation resolution is met; and encoding the resulting tree structure.

公开(公告)号：US11803521B2

公开(公告)日：2023-10-31

申请号：US17324896

申请日：2021-05-19

Applicant: SAP SE

Inventor： Michael Brendle ,  Norman May ,  Robert Schulze ,  Alexander Boehm ,  Guido Moerkotte ,  Michael Grossniklaus

IPC: G06F16/21 ,  G06F16/22 ,  G06F11/34 ,  G06F16/2455 ,  G06F16/2457 ,  G06F16/2453 ,  G06F16/215 ,  H03M7/30

CPC classification number: G06F16/21 ,  G06F11/3414 ,  G06F11/3428 ,  G06F16/213 ,  G06F16/215 ,  G06F16/217 ,  G06F16/2272 ,  G06F16/2282 ,  G06F16/2455 ,  G06F16/24545 ,  G06F16/24552 ,  G06F16/24575 ,  H03M7/6064

Abstract: The present disclosure involves systems, software, and computer implemented methods for improved design and implementation of data access metrics for automated physical database design. An example method includes identifying a database workload for which index advisor access counters are to be tracked. Each SQL statement in the database workload is executed. For each SQL statement, attribute sets are determined for which a selection predicate filters a result for an SQL statement. An output cardinality of each selection predicate is determined. A logarithmic counter for an attribute set corresponding to the selection predicate is determined based on the output cardinality of the selection predicate. The determined logarithmic counter is incremented. Respective values for logarithmic counters of the determined attributes are provided to an index advisor. The index advisor determines attribute sets for which to propose an index based on the logarithmic counters of the respective attribute sets.

公开(公告)号：US11593338B2

公开(公告)日：2023-02-28

申请号：US17410234

申请日：2021-08-24

Applicant: SAP SE

Inventor： Patrick Voelker ,  Alexander Boehm ,  Mihnea Andrei ,  Johannes Alberti

IPC: G06F16/22 ,  G06F16/23 ,  G06F16/21 ,  G06F16/25 ,  G06F11/14

Abstract: A computer-implemented method for database management is provided. The method comprises: receiving, from a client device , first data to be stored in a database system that comprises first data storage configured to store a data table and a deletion history table; storing the first data in second data storage that is external to the database system and that is in communication with the database system via a network; obtaining a link that enables access, via the network, to the first data stored in the second data storage; storing the link in the data table; and performing a deletion operation of the first data, in response to a request from the client device to delete the first data from the database system, wherein the deletion operation comprises: deleting the link from the data table without deleting the first data from the second data storage; and storing the link in the deletion history table with a timestamp corresponding to a point in time when the link is deleted from the data table.

公开(公告)号：US20220269684A1

公开(公告)日：2022-08-25

申请号：US17324896

申请日：2021-05-19

Applicant: SAP SE

Inventor： Michael Brendle ,  Norman May ,  Robert Schulze ,  Alexander Boehm ,  Guido Moerkotte ,  Michael Grossniklaus

IPC: G06F16/2457 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/21 ,  G06F11/34

Abstract: The present disclosure involves systems, software, and computer implemented methods for improved design and implementation of data access metrics for automated physical database design. An example method includes identifying a database workload for which index advisor access counters are to be tracked. Each SQL statement in the database workload is executed. For each SQL statement, attribute sets are determined for which a selection predicate filters a result for an SQL statement. An output cardinality of each selection predicate is determined. A logarithmic counter for an attribute set corresponding to the selection predicate is determined based on the output cardinality of the selection predicate. The determined logarithmic counter is incremented. Respective values for logarithmic counters of the determined attributes are provided to an index advisor. The index advisor determines attribute sets for which to propose an index based on the logarithmic counters of the respective attribute sets.

公开(公告)号：US20210232416A1

公开(公告)日：2021-07-29

申请号：US17209852

申请日：2021-03-23

Applicant: SAP SE

Inventor： Marco Kroll ,  Lutz Gericke ,  Michael Perscheid ,  Alexander Boehm

IPC: G06F9/455 ,  G06F9/38 ,  G06F9/4401 ,  G06F9/50

Abstract: The present disclosure relates to computer-implemented methods, software, and systems for providing extension application mechanisms. Memory is allocated for a virtual environment to run in an address space of an application that is to be extended with extension logic in a secure manner. The virtual environment is configured for execution of commands related to an extension functionality of the application. A virtual processor for an execution of a command of the commands is initialized at the virtual environment. The virtual processor is operable to manage one or more guest operating systems (OS). A first guest OS is loaded at the allocated memory and application logic of the extension functionality is copied into the allocated memory. The virtual environment is started to execute the first guest OS and the application logic of the extension functionality in relation to associated data of the application in the allocated memory.

公开(公告)号：US10275508B2

公开(公告)日：2019-04-30

申请号：US14946757

申请日：2015-11-19

Applicant: SAP SE

Inventor： Christian Bensberg ,  Norman May ,  Alexander Boehm ,  Juchang Lee ,  Sung Heun Wi ,  Jeong Ae Han ,  Ki Hong Kim ,  Kyu Hwan Kim ,  Chul Won Lee ,  Andreas Kemmler ,  Christoph Glania ,  Armin Risch ,  Kai Morich

IPC: G06F17/30

Abstract: A method may include receiving a query for data to be provided by a database server, wherein the query includes an indication of a maximum lag. The method may further include determining whether a hint is available to apply to the query, wherein the hint affects an execution of the query. When no hint is available, a baseline database server may be selected to be the database server. When the hint is available, a replication server or a cache server may be selected to be the database server based on the hint and the maximum lag. The query may be processed at the selected database server.