-
公开(公告)号:US20190129990A1
公开(公告)日:2019-05-02
申请号:US15794335
申请日:2017-10-26
Applicant: SAP SE
Inventor: Uwe Schlarb , Andrea Neufeld , Immo-Gert Birn , Volker Driesen
CPC classification number: G06F16/2365 , G06F16/21 , G06F16/211 , G06F16/2264 , G06F16/2272 , G06F16/2282 , G06F16/2452 , G06F16/24553 , G06F16/248 , G06F16/258 , G06F16/951 , G06F21/6218
Abstract: The present disclosure involves systems, software, and computer implemented methods for deploying changes in a multi-tenancy database system. One example method includes upgrading at least one tenant database container in a database system. Table structure differences and table sharing type differences are determined by comparing tables in a current-version shared container to tables in a next-version shared container. A current key pattern configuration in the current-version shared container is compared to an updated key pattern configuration in the next-version shared container to identify key pattern configuration differences. Each table in the at least one tenant database container is upgraded based on the table structure differences, the table sharing type differences, and the key pattern configuration differences.
-
公开(公告)号:US09891909B2
公开(公告)日:2018-02-13
申请号:US14981137
申请日:2015-12-28
Applicant: SAP SE
Inventor: Heiko Konrad , Edgar Lott , Andrea Neufeld
CPC classification number: G06F8/656 , G06F8/65 , G06F8/70 , G06F8/72 , G06F8/73 , G06F8/75 , G06F17/30377 , G06F17/30578
Abstract: The disclosure generally describes methods, software, and systems, including a method for updating an application. At least one application instance of an application is managed. Each application instance is associated with a plurality of executing work processes connected with a first database schema. A bridge database schema is generated that is related to the first database schema. The bridge database schema represents a copy of the first database schema and is generated in response to initiation of an update to the application. In response to determining that the generation of the bridge database schema is complete, for each of the plurality of work processes, a commit work action performed by the particular work process is determined. In response to determining performance of the commit work action, the particular work process is connected to the bridge database schema.
-
公开(公告)号:US10452646B2
公开(公告)日:2019-10-22
申请号:US15794335
申请日:2017-10-26
Applicant: SAP SE
Inventor: Uwe Schlarb , Andrea Neufeld , Immo-Gert Birn , Volker Driesen
IPC: G06F16/21 , G06F16/22 , G06F16/23 , G06F16/2452 , G06F16/2455 , G06F16/248 , G06F16/25 , G06F16/951 , G06F21/62
Abstract: The present disclosure involves systems, software, and computer implemented methods for deploying changes in a multi-tenancy database system. One example method includes upgrading at least one tenant database container in a database system. Table structure differences and table sharing type differences are determined by comparing tables in a current-version shared container to tables in a next-version shared container. A current key pattern configuration in the current-version shared container is compared to an updated key pattern configuration in the next-version shared container to identify key pattern configuration differences. Each table in the at least one tenant database container is upgraded based on the table structure differences, the table sharing type differences, and the key pattern configuration differences.
-
公开(公告)号:US20190129985A1
公开(公告)日:2019-05-02
申请号:US15794381
申请日:2017-10-26
Applicant: SAP SE
Inventor: Uwe Schlarb , Andrea Neufeld , Immo-Gert Birn , Volker Driesen
CPC classification number: G06F16/2272 , G06F8/65 , G06F16/211 , G06F16/213 , G06F16/2264 , G06F16/2282 , G06F16/2365 , G06F16/2452 , G06F16/24553 , G06F16/248 , G06F16/256 , G06F16/258 , G06F16/278 , G06F16/951 , G06F21/6218
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.
-
公开(公告)号: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.
-
公开(公告)号:US20170185392A1
公开(公告)日:2017-06-29
申请号:US14981137
申请日:2015-12-28
Applicant: SAP SE
Inventor: Heiko Konrad , Edgar Lott , Andrea Neufeld
CPC classification number: G06F8/656 , G06F8/65 , G06F8/70 , G06F8/72 , G06F8/73 , G06F8/75 , G06F17/30377 , G06F17/30578
Abstract: The disclosure generally describes methods, software, and systems, including a method for updating an application. At least one application instance of an application is managed. Each application instance is associated with a plurality of executing work processes connected with a first database schema. A bridge database schema is generated that is related to the first database schema. The bridge database schema represents a copy of the first database schema and is generated in response to initiation of an update to the application. In response to determining that the generation of the bridge database schema is complete, for each of the plurality of work processes, a commit work action performed by the particular work process is determined. In response to determining performance of the commit work action, the particular work process is connected to the bridge database schema.
-
公开(公告)号: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.
-
公开(公告)号:US10733168B2
公开(公告)日:2020-08-04
申请号:US15794381
申请日:2017-10-26
Applicant: SAP SE
Inventor: Uwe Schlarb , Andrea Neufeld , Immo-Gert Birn , Volker Driesen
IPC: G06F16/00 , G06F16/22 , G06F16/21 , G06F16/25 , G06F16/27 , G06F16/2452 , G06F16/2455 , G06F16/23 , G06F16/951 , G06F16/248 , G06F21/62 , G06F8/65
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.
-
公开(公告)号: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.
-
-
-
-
-
-
-
-
-