US 6,970,876 B2 · Method and arrangement for the management of database schemas

Abstract

A management of distributed databases, and a method and an arrangement associated with managing database schemas and configuration of software that uses those schemas. A method and a system, which allows managing database schemas and application software in large distributed multi-database systems and avoiding problems that are related to the prior art systems preferably by using a configuration manager apparatus (231), which is external to the configuration and databases being managed (200) or by providing a mechanism for keeping multiple, possibly different database schemas and application software in synchronization. The external configuration management node (231) manages the configuration management replicas (203, 213, 223) in each part (201, 211, 221) of the distributed database system (200). These synchronized configuration management replicas comprise scripts that are used for creating and/or updating the schemas of the database nodes and configuration of software that uses these database nodes (202, 212, 222).

Claims21

Dependent claims

A method for managing database application configuration data in at least one database system comprising at least one application master database node, at least one application replica database node, at least one application having access to the application master database node or the replica database node, at least one configuration management master database node and at least one configuration management replica database node, wherein the at least one configuration management master database node and at least one configuration management replica database node are for managing at least one of the at least one application master database node, the at least one application replica database node and/or at least one application, the method which comprises the steps of:

storing new configuration data in the configuration management master database node,
synchronizing at least part of the configuration data to the at least one configuration management replica database node, and
altering the configuration of the at least one application master database node and/or at least one application replica database node and/or application on the basis of at least part of the configuration data of the at least one configuration management replica database.

An arrangement for managing database application configuration data in at least one database system, wherein the database system comprises at least one application master database node, at least one application replica database node, and at least one application having access to the application master database node or to the replica database node, wherein the arrangement comprises:

at least one configuration management master database node, and
at least one configuration management replica database node, wherein the at least one configuration management master database node and at least one configuration management replica database node are for managing at least one of the at least one application master database node, the at least one application replica database node and/or at least one application;
a means for storing new configuration data in the configuration management master database node,
a means for synchronizing at least part of the configuration data to the at least one configuration management replica database node, and
a means for altering the configuration of the at least one application master database node and/or at least one application replica database node and/or application on the basis of at least part of the configuration data of the at least one configuration management replica database.

2 more elements

Dependencies are inferred from the claim text.

Method and arrangement for the management of database schemas

Life of this patent

Method and arrangement for the management of database schemas

Life of this patent

Abstract

Claims21