Documenting modifications to configuration file

Patent metadata

Field	Value
Publication number	US-11200212-B2
Application number	US-201816222226-A
Country	US
Kind code	B2
Filing date	Dec 17, 2018
Priority date	Dec 17, 2018
Publication date	Dec 14, 2021
Grant date	Dec 14, 2021

Abstract

This disclosure describes documenting modifications to configuration file that can affect (e.g., change) behavior of a component of a service provided by a database management system. The service can collect metadata associated with a request to modify a configuration file affecting the behavior of the component of the service. The service can modify the configuration file in response to the request. The modification can change the behavior of the component of the service. The service can generate data representing documentation of the modification to the configuration file and the metadata. The data can represent the documentation being configured for storage by the database management system. Related apparatuses, systems, methods, techniques and articles are also described.

First claim

What is claimed is:

1. A method comprising:
collecting, by a service provided by a database management system, metadata associated with a request to modify a configuration file for changing a behavior of a component of the service provided by the database management system, the database management system including a default configuration layer, a database tenant layer, and a host layer, the configuration file is one of: a first configuration file having a default setting and stored in the default configuration layer, the first configuration file being a global or a service-specific configuration file, a second configuration file configured to override the default setting and stored in the database tenant layer, and a third configuration file configured to modify database behavior of a host within the database management system and stored in the host layer;
modifying, by the service, the configuration file in response to the request, the modification changing behavior of the component of the service; and
generating, by the service, data representing documentation of the modification to the configuration file and the metadata, the data representing the documentation being configured for storage by the database management system.

2. The method of claim 1 , wherein the database management system is a relational database management system.

3. The method of claim 1 , wherein:
the service is one of a plurality of services provided by the database management system; and
the component is one of a plurality of components of the service.

4. The method of claim 1 , wherein the modification of the configuration file is performed by one of:
a first database administrator while configuring the database management system to match hardware settings of a customer serviced by the database management system;
a second database administrator for a tenant of the database management system while adapting the service for a particular use case; and
a support worker while troubleshooting the database management system.

5. The method of claim 1 , wherein the plurality of parameters comprises:
the modification to the configuration file; and
at least one of:
a reason due to which the configuration file was modified;
a time when the configuration file was modified;
an application used for requesting a modification of the configuration file; and
an identification of a user who requested the modification of the configuration file.

6. The method of claim 1 , wherein the generating of the data representing the documentation comprises:
transmitting, by the service, metadata of the modification to the configuration file to a catalog master service that stores the metadata of the modification in an internal database table within the database management system.

7. The method of claim 6 , wherein:
the catalog master service stores the metadata of the modification in a backlog for a duration for which the catalog master file is unavailable; and
the catalog master service transmits the metadata of the modification from the backlog to the catalog master file when the catalog master file becomes available.

8. The method of claim 1 , further comprising:
displaying, by the service, the modification stored in the internal database table from an in-memory storage structure of the database management system.

9. The method of claim 1 , further comprising:
if a lock file exists, recovering, by the service, the lock file; and
if the lock file does not exist, creating, by the service, a new lock file;
wherein:
the recovered lock file or the new lock file is used during performance of the modification of the configuration file.

10. A non-transitory computer-readable medium storing instructions that, when executed by a computer, cause a service provided by a database management system to perform operations comprising:
collecting, by a service provided by a database management system, metadata associated with a request to modify a configuration file for changing a behavior of a component of the service provided by the database management system, the database management system including a default configuration layer, a database tenant layer, and a host layer, the configuration file is one of: a first configuration file having a default setting and stored in the default configuration layer, the first configuration file being a global or a service-specific configuration file, a second configuration file configured to override the default setting and stored in the database tenant layer, and a third configuration file configured to modify database behavior of a host within the database management system and stored in the host layer;
modifying, by the service, the configuration file in response to the request, the modification changing behavior of the component of the service; and
generating, by the service, data representing documentation of the modification to the configuration file and the metadata, the data representing the documentation being configured for storage by the database management system.

11. The non-transitory computer-readable medium of claim 10 , wherein the database management system is a relational database management system.

12. The non-transitory computer-readable medium of claim 10 , wherein the plurality of parameters comprises:
the modification to the configuration file; and
at least one of:
a reason due to which the configuration file was modified;
a time when the configuration file was modified;
an application used for requesting a modification of the configuration file; and
an identification of a user who requested the modification of the configuration file.

13. The non-transitory computer-readable medium of claim 10 , wherein the generating of the data representing the documentation comprises:
transmitting metadata of the modification to the configuration file to a catalog master service that stores the metadata of the modification in an internal database table within the database management system.

14. The non-transitory computer-readable medium of claim 13 , wherein:
the catalog master service stores the metadata of the modification in a backlog for a duration for which the catalog master file is unavailable; and
the catalog master service transmits the metadata of the modification from the backlog to the catalog master file when the catalog master file becomes available.

15. The non-transitory computer-readable medium of claim 10 , wherein the operations further comprise:
if a lock file exists, recovering the lock file; and
if the lock file does not exist, creating a new lock file;
wherein:
the recovered lock file or the new lock file is used during performance of the modification of the configuration file.

16. A database management system comprising:
a programmable processor providing a service; and
a machine-readable medium storing instructions that, when executed by the programmable processor, cause the service to perform at least some of operations comprising:
collecting, by a service provided by a database management system, metadata associated with a request to modify a configuration file for changing a behavior of a component of the service provided by the database management system, the database management system including a default configuration layer, a database tenant layer, and a host layer, the configuration file is one of: a first configuration file having a default setting and stored in the default configuration layer, the first configuration file being a global or a service-specific configuration file, a second configuration file configured to o

Assignees

• Sap Se

Inventors

• Rudolf Michael
• Kook Sebastian
• Morich Kai

Classifications

• G06F16/284

  Relational databases · CPC title

• G06F16/2358

  Change logging, detection, and notification (replication G06F16/27) · CPC title

• G06F16/93

  Document management systems · CPC title

• G06F16/21 Primary

  Design, administration or maintenance of databases · CPC title

• G06F16/1734 Primary

  Details of monitoring file system events, e.g. by the use of hooks, filter drivers, logs · CPC title