-
公开(公告)号: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.
-
公开(公告)号:US10740315B2
公开(公告)日:2020-08-11
申请号:US15794501
申请日:2017-10-26
Applicant: SAP SE
Inventor: Immo-Gert Birn , Kerstin Hoeft , Andrea Neufeld , Uwe Schlarb , Christian Stork , Welf Walter , Volker Driesen
Abstract: The present disclosure teaches solutions for transitioning between database system sharing types. In one example, a tenant container includes a read-only table, a first writable table, and a mixed table for storing read-only and writable data. When transitioning to a sharing setup, a shared container is created and a shared table is created in the shared container. Data is copied from the read-only table to the shared table and the read-only table is dropped. A read-only view is created in the tenant container and a second shared table is created in the shared container. Read-only mixed data is copied from the mixed table to the second shared table and deleted from the mixed table, and after the deletion, the mixed table is renamed as the second writable table. A union view is created that provides unified access to the second shared table and the second writable table.
-
3.
公开(公告)号:US20190130010A1
公开(公告)日:2019-05-02
申请号:US15794424
申请日:2017-10-26
Applicant: SAP SE
Inventor: Ulrich Auer , Ralf-Juergen Hauck , Heiko Konrad , Kerstin Hoeft , Florian Thomas , Volker Driesen
CPC classification number: G06F16/27 , G06F8/65 , G06F11/1464 , G06F15/16 , G06F16/211 , G06F16/2264 , G06F16/2272 , G06F16/2282 , G06F16/2365 , G06F16/2452 , G06F16/24553 , G06F16/248 , G06F16/258 , G06F16/951 , G06F21/6218 , G06F2201/80
Abstract: The present disclosure involves systems, software, and computer implemented methods for patching content in database systems. One example method includes receiving a deployment package for an upgrade of a database system to a new version. Content is deployed to a shared container. Shared objects are identified that are completely stored in the shared container. First shared content is determined for shared objects. Partially-shared objects are identified that have a shared portion in the shared container and a tenant portion in one or more tenant containers. Second shared content is determined for partially-shared objects. The first shared and second shared content are deployed to the shared container. Local content is determined for the partially-shared objects and deployed to each tenant container. Local objects that have no data in the shared container are identified. Local content is identified for the local objects and deployed to each respective tenant container.
-
公开(公告)号:US20190129986A1
公开(公告)日:2019-05-02
申请号:US15794501
申请日:2017-10-26
Applicant: SAP SE
Inventor: Immo-Gert Birn , Kerstin Hoeft , Andrea Neufeld , Uwe Schlarb , Christian Stork , Welf Walter , Volker Driesen
CPC classification number: G06F16/2282 , G06F16/213 , G06F16/217 , G06F16/22 , G06F16/2343 , G06F16/28 , H04L9/0816 , H04L9/085
Abstract: The present disclosure involves systems, software, and computer implemented methods for transitioning between database system sharing types. One example method includes identifying a tenant container that includes a read-only table, a first writable table, and a mixed table for storing read-only and writable data. A shared container is created. A shared table is created in the shared container. Data is copied from the read-only table to the shared table. The read-only table is dropped. A read-only view is created in the tenant container. A second shared table is created in the shared container. Read-only mixed data is copied from the mixed table to the second shared table and deleted from the mixed table. The mixed table is renamed to be the second writable table. A union view is created that provides unified access to the second shared table and the second writable table.
-
公开(公告)号:US12124840B2
公开(公告)日:2024-10-22
申请号:US17411141
申请日:2021-08-25
Applicant: SAP SE
Inventor: Kerstin Hoeft , Volker Driesen
CPC classification number: G06F8/656 , G06F16/213 , G06F16/217
Abstract: Methods, systems, and computer-readable storage media for providing a first access schema in a view layer of the database system, the first access schema including first database objects and projection views, each projection view corresponding to a second database object of second database objects in a data persistency, transitioning access of sessions of an application from the data persistency to the first access schema, executing at least a portion of the maintenance procedure in the database system, the at least a portion of the maintenance procedure changing one or more second database objects within the data persistency, creating a second access schema, and transitioning access of the sessions of the application from the first access schema to the second access schema, transitioning access of the sessions of the application from the second access schema to the data persistency, and removing the second access schema from the database system.
-
公开(公告)号:US11269620B1
公开(公告)日:2022-03-08
申请号:US16952301
申请日:2020-11-19
Applicant: SAP SE
Inventor: Kerstin Hoeft , Steffen Meissner , Martin Mayer , Volker Driesen
Abstract: Implementations include a first application server interacting with a first infrastructure table of a first version through a first access schema, providing, during an upgrade, a second application server to execute a portion of the upgrade by interacting with data schema through the first access schema, adjusting a structure of a second infrastructure table to provide an adjusted structure, the structure of the first version and the adjusted structure of the second version, the second infrastructure table including a copy of the first infrastructure table, providing a second access schema of the second version, providing a third application server configured to interact with data schema through the second access schema, and activating, by the third application server using an activator of the second version, objects of the second version, the activator including features that are different than an activator of the first version.
-
公开(公告)号:US10657276B2
公开(公告)日:2020-05-19
申请号:US15794261
申请日:2017-10-26
Applicant: SAP SE
Inventor: Immo-Gert Birn , Kerstin Hoeft , Andrea Neufeld , Uwe Schlarb , Christian Stork , Welf Walter , Volker Driesen
IPC: G06F21/62 , G06F16/21 , G06F40/177 , G06F16/22 , G06F16/2455 , G06F16/25 , G06F16/23 , G06F16/951 , G06F16/248 , G06F8/65 , H04L29/08 , H04L29/06
Abstract: The present disclosure involves systems, software, and computer implemented methods for enabling multiple system sharing types in multi-tenancy database systems. One example method includes determining a system sharing type configuration for a database system. The system sharing type configuration is one of standard, shared, tenant, or simulated. Tables are created in the database system based on the system sharing type configuration and the table sharing type of each table. Content is deployed to created tables in the database system based on the system sharing type configuration and the table sharing type of each table. Access is provided to at least one application to the database system based on the system sharing type configuration and the table sharing type of each table.
-
公开(公告)号:US20190130121A1
公开(公告)日:2019-05-02
申请号:US15794261
申请日:2017-10-26
Applicant: SAP SE
Inventor: Immo-Gert Birn , Kerstin Hoeft , Andrea Neufeld , Uwe Schlarb , Christian Stork , Welf Walter , Volker Driesen
Abstract: The present disclosure involves systems, software, and computer implemented methods for enabling multiple system sharing types in multi-tenancy database systems. One example method includes determining a system sharing type configuration for a database system. The system sharing type configuration is one of standard, shared, tenant, or simulated. Tables are created in the database system based on the system sharing type configuration and the table sharing type of each table. Content is deployed to created tables in the database system based on the system sharing type configuration and the table sharing type of each table. Access is provided to at least one application to the database system based on the system sharing type configuration and the table sharing type of each table.
-
公开(公告)号:US20230068439A1
公开(公告)日:2023-03-02
申请号:US17411141
申请日:2021-08-25
Applicant: SAP SE
Inventor: Kerstin Hoeft , Volker Driesen
Abstract: Methods, systems, and computer-readable storage media for providing a first access schema in a view layer of the database system, the first access schema including first database objects and projection views, each projection view corresponding to a second database object of second database objects in a data persistency, transitioning access of sessions of an application from the data persistency to the first access schema, executing at least a portion of the maintenance procedure in the database system, the at least a portion of the maintenance procedure changing one or more second database objects within the data persistency, creating a second access schema, and transitioning access of the sessions of the application from the first access schema to the second access schema, transitioning access of the sessions of the application from the second access schema to the data persistency, and removing the second access schema from the database system.
-
公开(公告)号:US11237821B1
公开(公告)日:2022-02-01
申请号:US16952191
申请日:2020-11-19
Applicant: SAP SE
Inventor: Kerstin Hoeft , Volker Driesen
Abstract: Implementations include, during development of a second version within a development environment, tracing activities to determine development tables, the second version including changes that are incompatible with the first version, the development tables including deploy tables, activation tables, and troubleshooting tables, computing, by a configuration generator, an upgrade configuration based on the development tables, the upgrade configuration defining tables to deploy the changes during an upgrade, the tables being computed based on the development tables, during the upgrade: continuing production use of a first version using a first runtime at least partially including a first data schema, and establishing a second runtime at least partially by defining a second data schema within the database system using the upgrade configuration, the second data schema including the tables, and completing the upgrade by switching production use to the second version from the first version.
-
-
-
-
-
-
-
-
-