-
公开(公告)号：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.
-
公开(公告)号：US11954081B1
公开(公告)日：2024-04-09
申请号：US17960991
申请日：2022-10-06
Applicant: SAP SE
Inventor： Welf Walter , Volker Driesen
CPC classification number: G06F16/219 , G06F8/65 , G06F16/2282 , G06F16/2393
Abstract: Systems and methods include configuration of a first database view to read from common versions of rows of a database table or from rows of the database table associated with a first version of the application, the database table storing application content, configuration of a first application server to write to the common versions of rows of the database table, configuration of a second database view to read from common versions of rows of the database table or from rows of the database table associated with a second version of the application, configuration of a second application server to write to rows of the database table associated with the second version of the application, modification of the database table to include rows associated with the second version of the application while the first application server executes the first version of the application and incoming user requests are directed to the first application server, configuration of the second application server to write to common versions of the rows of the database table, and re-direction of incoming user requests to the second application server executing the second version of the application.
-
公开(公告)号：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.
-
公开(公告)号：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.
-
公开(公告)号：US20190129988A1
公开(公告)日：2019-05-02
申请号：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
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.
-
Patent Agency Ranking
公开(公告)号：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.
-
公开(公告)号：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.
-
公开(公告)号：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.
-
公开(公告)号：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
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.
-
-
-
-
-
-
-
-
-
Search Results
10
records
(took 0.024 seconds)
