公开(公告)号：US11928489B2

公开(公告)日：2024-03-12

申请号：US17209852

申请日：2021-03-23

申请人： SAP SE

发明人： Marco Kroll ,  Lutz Gericke ,  Michael Perscheid ,  Alexander Boehm

IPC分类号： G06F9/455 ,  G06F9/38 ,  G06F9/4401 ,  G06F9/50

CPC分类号： G06F9/45554 ,  G06F9/3885 ,  G06F9/4406 ,  G06F9/45558 ,  G06F9/5016 ,  G06F9/5022 ,  G06F2009/45575 ,  G06F2009/45583

摘要： 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.

公开(公告)号：US20220269658A1

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

申请号：US17324874

申请日：2021-05-19

申请人： SAP SE

发明人： Michael Brendle ,  Norman May ,  Robert Schulze ,  Alexander Boehm ,  Guido Moerkotte ,  Michael Grossniklaus

IPC分类号： G06F16/215 ,  H03M7/30

摘要： 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.

公开(公告)号：US20210216564A1

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

申请号：US16739352

申请日：2020-01-10

申请人： SAP SE

发明人： Stefan Noll ,  Jens Teubner ,  Norman May ,  Alexander Boehm

IPC分类号： G06F16/25 ,  G06F16/23

摘要： The present disclosure involves systems, software, and computer implemented methods for efficient shared bulk loading into optimized storage. One example method includes identifying a data set on a client to load to a server. Load steps that can be performed either on the client or the server are identified. Values for load factors are determined. Load rules are determined that are based on load factors and are for determining processing locations for the load steps. A processing location of either the client or the server is determined for each load step, based on the load rules. Load steps that have a processing location of the client are executed on the data set, on the client. The data set is transferred from the client to the server, over a network. Load steps that have a processing location of the server are executed on the data set, at the server.

公开(公告)号：US10482085B2

公开(公告)日：2019-11-19

申请号：US14975086

申请日：2015-12-18

申请人： SAP SE

发明人： Guido Moerkotte ,  Norman May ,  Alexander Boehm

IPC分类号： G06F7/00 ,  G06F16/2453 ,  G06F16/174 ,  G06F16/22 ,  G06F16/28

摘要： 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.

公开(公告)号：US20180341679A1

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

申请号：US15603325

申请日：2017-05-23

申请人： SAP SE

发明人： Guido Moerkotte ,  Alexander Boehm ,  Norman May

IPC分类号： G06F17/30

摘要： A system for cardinality estimation for database query planning is provided. In some implementations, the system performs operations comprising determining, based on a first bounds and a second bounds for a combination of query predicates, whether a solution for the combination of the query predicates exists which includes both the first and second bounds. When the solution is determined to exist, the operations can further comprise determining at least one selectivity estimate for the combination of the query predicates. A query plan for execution of a database query comprising the query predicates can be generated based on the at least one selectivity estimate, and the database query can be executed through execution of the query plan. Related systems, methods, and articles of manufacture are also described.

公开(公告)号：US20180253473A1

公开(公告)日：2018-09-06

申请号：US15601815

申请日：2017-05-22

申请人： SAP SE

发明人： Torsten Ziegler ,  Christian Hansen ,  Frank-Martin Haas ,  Stefan Baeuerle ,  Mihnea Andrei ,  Alexander Boehm

IPC分类号： G06F17/30

CPC分类号： G06F16/24537 ,  G06F16/24564

摘要： The present disclosure involves systems, software, and computer implemented methods for using declarative rules for optimized access to data. One example method includes receiving a structured query language (SQL) query, the SQL query associated with at least one database table and at least one predicate. A determination is made as to whether the SQL query is associated with at least one declarative rule based on the at least one database table and the at least one predicate. In response to determining that the SQL query is associated with at least one declarative rule, the at least one associated declarative rule is applied, during optimization of the SQL query. The at least one declarative rule defines a transformation to the SQL query to be performed during query optimization. An updated SQL query is generated based on the applied at least one associated declarative rule and the updated SQL query is provided.

公开(公告)号：US20170371909A1

公开(公告)日：2017-12-28

申请号：US15361337

申请日：2016-11-25

申请人： SAP SE

发明人： Mihnea Andrei ,  Christian Bensberg ,  Alexander Boehm ,  Adrian Draguseanu ,  Xun Chen ,  Reza Sherkat ,  Ani Nica ,  Martin Heidel ,  Rolando Blanco

IPC分类号： G06F17/30

CPC分类号： G06F16/282 ,  G06F16/21

摘要： 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.

公开(公告)号：US11550762B2

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

申请号：US17316901

申请日：2021-05-11

申请人： SAP SE

发明人： 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

摘要： 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.

公开(公告)号：US11487762B2

公开(公告)日：2022-11-01

申请号：US16928951

申请日：2020-07-14

申请人： SAP SE

发明人： Norman May ,  Alexander Boehm ,  Guido Moerkotte ,  Michael Brendle ,  Mahammad Valiyev ,  Nick Weber ,  Robert Schulze ,  Michael Grossniklaus

IPC分类号： G06F16/24 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/27 ,  G06F9/50

摘要： Techniques and solutions are described for partitioning data among different types of computer-readable storage media, such as between RAM and disk-based storage. A measured workload can be used to estimate data access for one or more possible partition arrangements. The partitions arrangements can be automatically enumerated. Scores for the partition arrangements can be calculated, where a score can indicate how efficiently a partition arrangement places frequently accessed data into storage specified for frequently-accessed data and placed infrequently accessed data into storage specified for infrequently accessed data.

公开(公告)号：US20220269655A1

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

申请号：US17316901

申请日：2021-05-11

申请人： SAP SE

发明人： Michael Brendle ,  Norman May ,  Robert Schulze ,  Alexander Boehm ,  Guido Moerkotte ,  Michael Grossniklaus

IPC分类号： G06F16/21 ,  G06F16/22 ,  G06F16/2453 ,  G06F16/2455 ,  G06F11/34

摘要： 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.