US 11,841,840 B2
Technical system settings using a shared database
Wulf Kruempelmann, Altlussheim (DE); Susanne Schott, Mannheim (DE); and Georg Storz, Hessigheim (DE)
Assigned to SAP SE, Walldorf (DE)
Filed by SAP SE, Walldorf (DE)
Filed on Dec. 10, 2020, as Appl. No. 17/117,972.
Prior Publication US 2022/0188282 A1, Jun. 16, 2022
Int. Cl. G06F 16/21 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/23 (2019.01); G06F 9/455 (2018.01); G06F 16/27 (2019.01)
CPC G06F 16/217 (2019.01) [G06F 9/45558 (2013.01); G06F 16/2282 (2019.01); G06F 16/2379 (2019.01); G06F 16/24558 (2019.01); G06F 16/27 (2019.01); G06F 2009/45595 (2013.01)] 14 Claims
OG exemplary drawing
 
1. A computer-implemented method, comprising:
receiving, by a centralized controller and from a client device, an indication to modify a setting of at least one database instance of a plurality of database instances at a cloud service, wherein the setting varies, at the cloud service, at least one of a memory allocation for the at least one database instance or a processor capacity for the at least one database instance;
in response to receiving the indication, triggering, by the centralized controller, a plurality of database views to obtain configuration data from a plurality of database tables at the plurality of database instances at the cloud service, wherein each of the plurality of database tables provides the configuration data for configuring a corresponding one of the plurality of database instances, wherein each of the plurality of database views provides a pre-established query in a corresponding one of the plurality of database tables to enable reception of the configuration data used to modify the setting of the at least one database instance;
receiving, by the centralized controller, the configuration data from the plurality of database tables at the plurality of database instances at the cloud service, wherein the configuration data is received via the plurality of database views on the plurality of database tables;
in response to receiving the configuration data, performing, by the centralized controller, a union view of the configuration data obtained from the plurality of database views, wherein the union view of the configuration data forms a table of configuration metadata that includes, for each of the plurality of database instances, a system identifier identifying corresponding database instance, a network identifier identifying the cloud service, the configuration data for configuring the corresponding database instance, and a group identifier indicating a group of users associated with the database instances;
storing, by the centralized controller, the union view of the configuration data in the table of the configuration metadata;
performing, by the centralized controller, an attribute view on the configuration metadata to select, based at least on the group identifier associated with the at least one database instance being modified, a subset of the configuration metadata; and
performing, by the centralized controller, at least one calculation view on the subset to modify a value of the configuration metadata and to provide the modified value to at least one of the plurality of database tables associated with the configuration of the at least one database instance at the cloud service.