公开(公告)号：US10909090B2

公开(公告)日：2021-02-02

申请号：US15349736

申请日：2016-11-11

Applicant: SAP SE

Inventor： Martin Mayer ,  Ulrich Auer ,  Arne Harren ,  Volker Driesen

IPC: G06F16/21 ,  G06F16/28 ,  G06F16/2455 ,  G06F16/901 ,  G06F8/41

Abstract: In an example embodiment, a proxy object is delivered to a first schema having a first logical name and stored in the software object database, the proxy object referencing an object in a second schema having a second logical name. Any dependencies from the object in the second schema to the proxy object in the first schema are removed a cycle-free graph of dependencies between objects the software object database is generated. Objects are delivered the software object database using the cycle-free graph. A definition for the proxy object is created including the logical name for the first schema. The proxy object is delivered by replacing, at a time subsequent to the proxy object being delivered to the software object database, the logical name for the first schema stored in the definition with a physical name for the first schema.

公开(公告)号：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.

公开(公告)号：US10713277B2

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

申请号：US15794424

申请日：2017-10-26

Applicant: SAP SE

Inventor： Ulrich Auer ,  Ralf-Juergen Hauck ,  Heiko Konrad ,  Kerstin Hoeft ,  Florian Thomas ,  Volker Driesen

IPC: G06F16/00 ,  G06F16/27 ,  G06F16/23 ,  G06F15/16 ,  G06F16/22 ,  G06F16/2452 ,  G06F16/2455 ,  G06F16/21 ,  G06F16/25 ,  G06F16/951 ,  G06F16/248 ,  G06F11/14 ,  G06F21/62 ,  G06F8/65

Abstract: The present disclosure teaches solutions for patching content in database systems. In one example, a deployment package for an upgrade of a database system to a new system is received, and the content is deployed to a shared container. Shared objects are identified that are completely stored in the shared container, and partially-shared objects are identified where those objects have a shared portion in the shared container and a tenant portion in one or more tenant containers. First shared content is determined for the shared objects, while second shared content is determined for partially-shared objects. The first and second shared content is then deployed to the shared container. Local content is determined for the partially-shared objects and is deployed to each tenant container. Local content is then identified for local objects and is also deployed to each respective tenant container. Accordingly, both shared and tenant content is deployed.

公开(公告)号：US20180137145A1

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

申请号：US15349704

申请日：2016-11-11

Applicant: SAP SE

Inventor： Martin Mayer ,  Ulrich Auer ,  Arne Harren ,  Volker Driesen

IPC: G06F17/30

CPC classification number: G06F16/211 ,  G06F16/21 ,  G06F16/22 ,  G06F16/25 ,  G06F16/284

Abstract: In an example embodiment, software objects of a first database type are delivered to a first schema having a first physical name and stored in the software object database. A definition is created for the first schema including a logical name for the first schema. The first schema is activated by replacing, at a time subsequent to the first schema being delivered to the software object database, the logical name for the first schema stored in the definition with a physical name for the first schema.

公开(公告)号：US10482080B2

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

申请号：US15794362

申请日：2017-10-26

Applicant: SAP SE

Inventor： Ulrich Auer ,  Ralf-Juergen Hauck ,  Uwe Schlarb ,  Volker Driesen

IPC: G06F16/21 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2452 ,  G06F16/2455 ,  G06F16/248 ,  G06F16/25 ,  G06F16/28 ,  G06F16/951 ,  G06F21/62 ,  G06F8/65

Abstract: The present disclosure involves systems, software, and computer implemented methods for exchanging shared containers and adapting tenants in database systems. One example method includes receiving a request to deploy a new version of a database system. A deployment package is received that includes new version data. A new shared container is installed in parallel to a current shared container. The new version is deployed to each of multiple tenant containers. Each of the tenant containers is individually linked to the new shared container, including dropping at least one view in each respective tenant container to shared content in the current shared container and adding at least one view in each respective tenant container to the updated shared content in the new shared container. Changed tenant content is deployed to each tenant container. The current shared container is dropped after deployment to each of the multiple tenant containers has completed.

公开(公告)号：US10915551B2

公开(公告)日：2021-02-09

申请号：US15996804

申请日：2018-06-04

Applicant: SAP SE

Inventor： Ralf-Juergen Hauck ,  Ulrich Auer ,  Volker Driesen

IPC: G06F16/22 ,  G06F16/27

Abstract: Methods, systems, and computer-readable storage media for, in response to initiation of a deployment to a multi-tenant system, cloning a shared table in a shared container of a database system to provide a cloned table, the shared table corresponding to a plurality of table views in respective tenant containers, providing, within each tenant container of the tenant containers, an updated view to the cloned table, for a data object of the deployment, determining a previous location of the data object within the database system from an object catalog, and a new location of the data object within the database system from a deploy file, and storing the data object in one of the shared container, and a tenant container of a respective tenant based on one or both of the previous location, and the new location of the data object.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：US20180137146A1

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

申请号：US15349736

申请日：2016-11-11

Applicant: SAP SE

Inventor： MARTIN MAYER ,  Ulrich Auer ,  Arne Harren ,  Volker Driesen

IPC: G06F17/30

CPC classification number: G06F16/211 ,  G06F8/433 ,  G06F16/2455 ,  G06F16/284 ,  G06F16/9024

Abstract: In an example embodiment, a proxy object is delivered to a first schema having a first logical name and stored in the software object database, the proxy object referencing an object in a second schema having a second logical name. Any dependencies from the object in the second schema to the proxy object in the first schema are removed a cycle-free graph of dependencies between objects the software object database is generated. Objects are delivered the software object database using the cycle-free graph. A definition for the proxy object is created including the logical name for the first schema. The proxy object is delivered by replacing, at a time subsequent to the proxy object being delivered to the software object database, the logical name for the first schema stored in the definition with a physical name for the first schema.

公开(公告)号：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.