公开(公告)号：US11061897B2

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

申请号：US15973147

申请日：2018-05-07

Applicant: SAP SE

Inventor： Andreas Zimmermann ,  Volker Driesen ,  Markus Gebhard ,  Torsten Ziegler ,  Frank-Martin Haas

IPC: G06F16/2453 ,  G06F16/22

Abstract: Techniques and solutions are described for facilitating the distribution of tables and table data between a shared container and one or more tenant containers. The tables can include a sharing indicator that can designate a table (or a view on a table) as having a materializable type. Materializable types can initially be deployed in the shared container, and a tenant container can have read access to the table via a view. If the tenant attempts to modify the materializable table, the table can be materialized in the tenant container. Metadata for a materializable table can include materialization instructions. Techniques and solutions are also provided for converting between sharing types, and for updating shared containers or table schemas.

公开(公告)号：US20200257673A1

公开(公告)日：2020-08-13

申请号：US16860532

申请日：2020-04-28

Applicant: SAP SE

Inventor： Ulrich Auer ,  Immo-Gert Birn ,  Ralf-Juergen Hauck ,  Uwe Schlarb ,  Christian Stork ,  Welf Walter ,  Torsten Ziegler ,  Volker Driesen

IPC: G06F16/23 ,  H04L29/06 ,  H04L9/08 ,  G06F16/2455 ,  G06F16/215

Abstract: The present disclosure involves systems, software, and computer implemented methods for key pattern management. One example method includes receiving a query for a logical database table from an application. A determination is made as to whether the query is a write query. In response to determining that the query is a write query, a determination is made as to whether the query complies with a key pattern configuration that describes keys of records included in a physical database table that is part of a logical table implementation. The physical table includes records of the logical database table that are allowed to be written by the application. The write query is redirected to the physical database table in response to determining that the query complies with the key pattern definition. The query is rejected in response to determining that the query does not comply with the key pattern configuration.

公开(公告)号：US20190340282A1

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

申请号：US15973147

申请日：2018-05-07

Applicant: SAP SE

Inventor： Andreas Zimmermann ,  Volker Driesen ,  Markus Gebhard ,  Torsten Ziegler ,  Frank-Martin Haas

IPC: G06F17/30

Abstract: Techniques and solutions are described for facilitating the distribution of tables and table data between a shared container and one or more tenant containers. The tables can include a sharing indicator that can designate a table (or a view on a table) as having a materializable type. Materializable types can initially be deployed in the shared container, and a tenant container can have read access to the table via a view. If the tenant attempts to modify the materializable table, the table can be materialized in the tenant container. Metadata for a materializable table can include materialization instructions. Techniques and solutions are also provided for converting between sharing types, and for updating shared containers or table schemas.

公开(公告)号：US20180253473A1

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

申请号：US15601815

申请日：2017-05-22

Applicant: SAP SE

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

IPC: G06F17/30

CPC classification number: G06F16/24537 ,  G06F16/24564

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

公开(公告)号：US11561956B2

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

申请号：US16860532

申请日：2020-04-28

Applicant: SAP SE

Inventor： Ulrich Auer ,  Immo-Gert Birn ,  Ralf-Juergen Hauck ,  Uwe Schlarb ,  Christian Stork ,  Welf Walter ,  Torsten Ziegler ,  Volker Driesen

IPC: G06F16/23 ,  G06F16/215 ,  G06F16/2455 ,  H04L9/08 ,  H04L9/40

Abstract: The present disclosure involves systems, software, and computer implemented methods for key pattern management. One example method includes receiving a query for a logical database table from an application. A determination is made as to whether the query is a write query. In response to determining that the query is a write query, a determination is made as to whether the query complies with a key pattern configuration that describes keys of records included in a physical database table that is part of a logical table implementation. The physical table includes records of the logical database table that are allowed to be written by the application. The write query is redirected to the physical database table in response to determining that the query complies with the key pattern definition. The query is rejected in response to determining that the query does not comply with the key pattern configuration.

公开(公告)号：US20190129988A1

公开(公告)日：2019-05-02

申请号：US15794368

申请日：2017-10-26

Applicant: SAP SE

Inventor： Ulrich Auer ,  Immo-Gert Birn ,  Ralf-Juergen Hauck ,  Uwe Schlarb ,  Christian Stork ,  Welf Walter ,  Torsten Ziegler ,  Volker Driesen

IPC: G06F17/30 ,  H04L29/06 ,  H04L9/08

Abstract: The present disclosure involves systems, software, and computer implemented methods for key pattern management. One example method includes receiving a query for a logical database table from an application. A determination is made as to whether the query is a write query. In response to determining that the query is a write query, a determination is made as to whether the query complies with a key pattern configuration that describes keys of records included in a physical database table that is part of a logical table implementation. The physical table includes records of the logical database table that are allowed to be written by the application. The write query is redirected to the physical database table in response to determining that the query complies with the key pattern definition. The query is rejected in response to determining that the query does not comply with the key pattern configuration.

公开(公告)号：US11481366B2

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

申请号：US16742458

申请日：2020-01-14

Applicant: SAP SE

Inventor： Timm Falter ,  Torsten Ziegler ,  Arne Harren

IPC: G06F16/21 ,  G06F16/906 ,  G06F21/62 ,  G06F9/54

Abstract: Disclosed herein are system, method, and device embodiments for consuming application-owned database objects via an API schema. An embodiment operates by determining that an application-owned database object is classified as API exposable, creating an API schema for proxy access to database objects that have been identified as API exposable, generating an API object within the API schema based on assigning the database object to the API schema, and providing, via the API schema and independent of the application, access to the API object by a privileged consumer.

公开(公告)号：US10740318B2

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

申请号：US15794368

申请日：2017-10-26

Applicant: SAP SE

Inventor： Ulrich Auer ,  Immo-Gert Birn ,  Ralf-Juergen Hauck ,  Uwe Schlarb ,  Christian Stork ,  Welf Walter ,  Torsten Ziegler ,  Volker Driesen

IPC: G06F16/00 ,  G06F16/23 ,  G06F16/2455 ,  G06F16/215 ,  H04L9/08 ,  H04L29/06

Abstract: The present disclosure involves systems, software, and computer implemented methods for key pattern management. One example method includes receiving a query for a logical database table from an application. A determination is made as to whether the query is a write query. In response to determining that the query is a write query, a determination is made as to whether the query complies with a key pattern configuration that describes keys of records included in a physical database table that is part of a logical table implementation. The physical table includes records of the logical database table that are allowed to be written by the application. The write query is redirected to the physical database table in response to determining that the query complies with the key pattern definition. The query is rejected in response to determining that the query does not comply with the key pattern configuration.

公开(公告)号：US10592509B2

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

申请号：US15601815

申请日：2017-05-22

Applicant: SAP SE

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

IPC: G06F16/00 ,  G06F16/2453 ,  G06F16/2455

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

公开(公告)号：US20190129997A1

公开(公告)日：2019-05-02

申请号：US15794305

申请日：2017-10-26

Applicant: SAP SE

Inventor： Ulrich Auer ,  Immo-Gert Birn ,  Ralf-Juergen Hauck ,  Uwe Schlarb ,  Christian Stork ,  Welf Walter ,  Torsten Ziegler ,  Volker Driesen

IPC: G06F17/30 ,  G06F21/62

Abstract: The present disclosure involves systems, software, and computer implemented methods for data separation and write redirection in multi-tenancy database systems. One example method includes providing access to at least one application to a database system. A query is received from an application. A determination is made that the query is associated with a union view that provides unified access to a first read-only table in a shared database container and a first writable table in a tenant database container. A determination is made as to whether the query is a read query or a write query. In response to determining that the query is a read query, the query is processed using the union view. In response to determining that the query is a write query, the query is modified to use the first writable table and the query is processed using the writable table.