公开(公告)号：EP4113314A1

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

申请号：EP21182689.6

申请日：2021-06-30

Applicant: SAP SE

Inventor： VOELKER, Patrick ,  BOEHM, Alexander ,  ANDREI, Mihnea ,  ALBERTI, Johannes

IPC: G06F16/21 ,  G06F16/23

Abstract: A computer-implemented method for database management is provided. The method comprises: receiving, from a client device (20), first data to be stored in a database system (10) that comprises first data storage (150, 160) configured to store a data table and a deletion history table; storing the first data in second data storage (30) that is external to the database system (10) and that is in communication with the database system (10) via a network; obtaining a link that enables access, via the network, to the first data stored in the second data storage (30); 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 (20) to delete the first data from the database system (10), wherein the deletion operation comprises: deleting the link from the data table without deleting the first data from the second data storage (30); 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.

公开(公告)号：EP3413214A1

公开(公告)日：2018-12-12

申请号：EP18173559.8

申请日：2018-05-22

Applicant: SAP SE

Inventor： MOERKOTTE, Guido ,  BOEHM, Alexander ,  MAY, Norman

IPC: G06F17/30

CPC classification number: G06F17/30469 ,  G06F17/30451 ,  G06F17/30477

Abstract: 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.

公开(公告)号：EP3401807A1

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

申请号：EP18171431.2

申请日：2018-05-09

Applicant: SAP SE

Inventor： BENSBERG, Christian ,  BOEHM, Alexander ,  DRAGUSANU, Adrian ,  CHENG, Xun ,  SHERKAT, Reza ,  NICA, Anisoara ,  ANDREI, Mihnea

IPC: G06F17/30

CPC classification number: G06F17/30584 ,  G06F17/30002 ,  G06F17/30303 ,  G06F17/30339 ,  G06F17/3051

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.

公开(公告)号：EP4293533A1

公开(公告)日：2023-12-20

申请号：EP22204505.6

申请日：2022-10-28

Applicant: SAP SE

Inventor： ANDREI, Mihnea ,  BOEHM, Alexander ,  MAY, Norman ,  KLINGSPORN, Urs ,  BLOCK, Meinolf ,  VOELKER, Patrick ,  KIM, Hyunjun ,  GLEBE, Thorsten ,  BREGLER, Jonathan ,  CHOI, Jaeyoung ,  KITTEL, Martin ,  KWON, Yong Sik ,  HAHN, Uwe ,  ZAHN, Henning ,  HANDRECK, Melanie ,  MACK, Holger ,  KIM, Eunsang ,  RENKES, Frank ,  LEE, Juchang ,  SCHINDEWOLF, Martin ,  BOWMAN, Ivan ,  DANNECKER, Lars

IPC: G06F16/27 ,  G06F21/62

Abstract: Systems and methods include creation of a first instance of a tenant object in a database instance, association of the first instance of the tenant object with a first plurality of database artifacts including first data associated with the first instance of the tenant object, creation of a second instance of the tenant object in the database instance, association of the second instance of the tenant object with a second plurality of database artifacts including second data associated with the second instance of the tenant object, and reception and response to queries on the first data associated with the first instance of the tenant object and to queries on the second data associated with the second instance of the tenant object.

公开(公告)号：EP3719645A1

公开(公告)日：2020-10-07

申请号：EP19189077.1

申请日：2019-07-30

Applicant: SAP SE

Inventor： KROLL, Marco ,  GERICKE, Lutz ,  PERSCHEID, Michael ,  BOEHM, Alexander

IPC: G06F9/455 ,  G06F21/53 ,  G06F9/445

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.

公开(公告)号：EP4053710A1

公开(公告)日：2022-09-07

申请号：EP22157240.7

申请日：2022-02-17

Applicant: SAP SE

Inventor： BRENDLE, Michael ,  MAY, Norman ,  SCHULZE, Robert ,  BOEHM, Alexander ,  MOERKOTTE, Guido ,  GROSSNIKLAUS, Michael

IPC: G06F16/21 ,  G06F16/22

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.

公开(公告)号：EP3270301A1

公开(公告)日：2018-01-17

申请号：EP17001142.3

申请日：2017-07-03

Applicant: SAP SE

Inventor： BENSBERG, Christian ,  BAEUERLE, Stefan ,  RENKES, Frank ,  STRAHL, Torsten ,  BOEHM, Alexander

IPC: G06F17/30 ,  G06F11/14 ,  G06F21/60

CPC classification number: G06F17/30241 ,  G06F11/14 ,  G06F11/1451 ,  G06F17/30339 ,  G06F17/30584

Abstract: A system includes reception of a first query at a first host, determination, at the first host, that the first query is associated with a first table, the first table including geographically-restricted data and a partitioning column storing identifiers of geographic restrictions, determination, at the first host and based on the partitioning column of the first table and on the first query, a first partition of the first table and a storage location of the first partition, and execution of the first query at the first host in conjunction with the storage location of the first partition.

Abstract translation: 系统包括在第一主机处接收第一查询，在第一主机处确定第一查询与第一表格相关联，第一表格包括地理上受限的数据和存储地理限制的标识符的分区列，确定 ，在第一主机上并基于第一表的分区列和第一查询，确定第一表的第一分区和第一分区的存储位置，并且在第一主机处执行第一查询并结合 第一个分区的存储位置。