Key pattern management in multi-tenancy database systems

    公开(公告)号:US11561956B2

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

    申请号:US16860532

    申请日:2020-04-28

    Applicant: SAP SE

    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.

    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.

    Deploying changes to key patterns in multi-tenancy database systems

    公开(公告)号:US10733168B2

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

    申请号:US15794381

    申请日:2017-10-26

    Applicant: SAP SE

    Abstract: The present disclosure involves systems, software, and computer implemented methods for deploying changes to key patterns in database systems. One example method includes receiving a new shared container that includes a new key pattern for a logical split table and an updated read-only-portion physical table for a logical split table. The updated read-only-portion physical table includes records that match a complement of the new key pattern. Records that match the new key pattern are identified in the read-only-portion physical table of the logical split table in a current shared container. The identified records are moved from the read-only-portion physical table in the current shared container to a writable-portion physical table in a tenant container. Records not matching the new key pattern are deleted from the writable-portion physical table of the logical split table in the tenant container.

    KEY PATTERN MANAGEMENT IN MULTI-TENANCY DATABASE SYSTEMS

    公开(公告)号:US20190129988A1

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

    申请号:US15794368

    申请日:2017-10-26

    Applicant: SAP SE

    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.

    KEY PATTERN MANAGEMENT IN MULTI-TENANCY DATABASE SYSTEMS

    公开(公告)号:US20200257673A1

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

    申请号:US16860532

    申请日:2020-04-28

    Applicant: SAP SE

    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.

    Exchanging shared containers and adapting tenants in multi-tenancy database systems

    公开(公告)号:US10482080B2

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

    申请号:US15794362

    申请日:2017-10-26

    Applicant: SAP SE

    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.

Patent Agency Ranking