Transitioning between system sharing types in multi-tenancy database systems

    公开(公告)号:US10740315B2

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

    申请号:US15794501

    申请日:2017-10-26

    Applicant: SAP SE

    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.

    Using view layer in database system for zero downtime upgrade

    公开(公告)号:US12124840B2

    公开(公告)日:2024-10-22

    申请号:US17411141

    申请日:2021-08-25

    Applicant: SAP SE

    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.

    Zero downtime upgrade through delta deployment procedure using target software stack

    公开(公告)号:US11269620B1

    公开(公告)日:2022-03-08

    申请号:US16952301

    申请日:2020-11-19

    Applicant: SAP SE

    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.

    SYSTEM SHARING TYPES IN MULTI-TENANCY DATABASE SYSTEMS

    公开(公告)号:US20190130121A1

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

    申请号:US15794261

    申请日:2017-10-26

    Applicant: SAP SE

    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.

    USING VIEW LAYER IN DATABASE SYSTEM FOR ZERO DOWNTIME UPGRADE

    公开(公告)号:US20230068439A1

    公开(公告)日:2023-03-02

    申请号:US17411141

    申请日:2021-08-25

    Applicant: SAP SE

    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.

    Configuring zero-downtime upgrades using automated development and test analysis

    公开(公告)号:US11237821B1

    公开(公告)日:2022-02-01

    申请号:US16952191

    申请日:2020-11-19

    Applicant: SAP SE

    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.

Patent Agency Ranking