IP Library Granted Patent US 11,841,840
Granted Patent B2
US 11,841,840 · App. 17/117,972 · Granted Dec 12, 2023

Technical system settings using a shared database

Inventors: Wulf Kruempelmann (Altlussheim, DE); Susanne Schott (Mannheim, DE); Georg Storz (Hessigheim, DE)
Assignee: SAP SE
G06F16/217G06F9/45558G06F16/2282G06F16/2379G06F16/24558G06F16/27G06F2009/45595
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 11,841,840
App. No.
17/117,972
Filed
Dec 10, 2020
Granted
Dec 12, 2023
Kind
B2
Art Unit
2153
USPC
707/609
Abstract

In some implementations, there is provided a method including receiving, by a centralized controller, data from a plurality of database tables at a plurality of database instances at a cloud service, wherein the data is received via a plurality of database views on the plurality of database tables; in response to receiving the data, performing, by the centralized controller, a union view of the data obtained from the plurality of database views; storing, by the centralized controller, the union view of the data as configuration metadata; and performing, by the centralized controller, at least one calculation view to update a value of the configuration metadata and to provide the updated value to at least one of the plurality of database tables at the cloud service. Related systems and articles of manufacture are also disclosed.

Claims (41)

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.

2. The computer-implemented method of claim 1 further comprising:

receiving, from the client device, a request for monitoring information regarding the plurality of database instances at the cloud service;

providing, by the centralized controller, a response including the monitoring information; and wherein the plurality of database views are stored at the centralized controller.

3. The computer-implemented method of claim 1 , wherein the setting varies at least one of a bandwidth of network interface, a storage amount, or a virtual machine configuration.

4. The computer-implemented method of claim 1 , wherein the triggering the plurality of database views further comprises triggering an odata protocol command to obtain the configuration data from the plurality of database tables.

5. The computer-implemented method of claim 1 , wherein the plurality of database instances are hosted at a plurality of cloud services.

6. The computer-implemented method of claim 1 , wherein the updated value is provided to at least one of the plurality of database tables via an odata protocol.

7. The computer-implemented method of claim 1 , wherein the configuration metadata is stored in a database table at the centralized controller.

8. A system comprising:

at least one processor; and

at least one memory including instructions, which when executed by the at least one processor, cause operations 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.

9. The system of claim 8 further comprising:

receiving, from the client device, a request for monitoring information regarding the plurality of database instances at the cloud service;

providing, by the centralized controller, a response including the monitoring information; and wherein the plurality of database views are stored at the centralized controller.

10. The system of claim 8 , wherein the setting varies at least one of a bandwidth of network interface, a storage amount, or a virtual machine configuration.

11. The system of claim 8 , wherein the triggering the plurality of database views further comprises triggering an odata protocol command to obtain the configuration data from the plurality of database tables.

12. The system of claim 8 , wherein the plurality of database instances are hosted at a plurality of cloud services.

13. The system of claim 8 , wherein the updated value is provided to at least one of the plurality of database tables via an odata protocol.

14. A non-transitory computer-readable storage medium including instructions, which when executed by at least one processor, cause operations 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 Me 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.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 10, 2020
From: KRUEMPELMANN, WULF; SCHOTT, SUSANNE; STORZ, GEORG
To: SAP SE
Reel/Frame 054608/0675 →
Continuity (1)
Related Publication 20220188282A1 · Jun 16, 2022
Cited By (1)
US 12,675,382