Database Administration

The CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers. database holds a complete representation of the customerClosed In the context of the Cloud Monetisation Platform, an individual or organisation who has signed an agreement to take goods and services from a service provider. A customer receives a bill associated with one or more subscriptions, and can be a single end user or a large company with many subscriptions assigned to one agreement. including all personal/business details, proposition, billing, payments and credit control data. The CMP database provides a central view of all CMP data, without the need to maintain/synchronise data across multiple databases.

The CMP database also holds the configuration used by CMP including all propositions, business process rules and reference data.

Deployment

CMP does not have a strong dependency on the proprietary features of any particular relational database management system (RDBMS). The product is currently certified and tested using PostgreSQL. For information on how to deploy the CMP database, see the CMP Installation Guide.

Starting

To start the database service, use the following command:

sudo systemctl start postgresql-16

To restart the database service, use the following command:

sudo systemctl restart postgresql-16

Stopping

To stop the database service, use the following command:

sudo systemctl stop postgresql-16

Monitoring Status

To check the status of the PostgreSQL service, use the following command:

sudo systemctl status postgresql-16

The PostgreSQL database must be monitored and managed in day-to-day operation using standard tools. For more information, see the topic System Monitoring

Configuration

For a list of the properties that must be configured during installation and configuration, see the Database Properties section of the CMP Installation Guide.

Database Purging

Data purging helps to keep obsolete and unwanted data to a minimum - subject to regulatory constraints - and can improve the application's performance. CMP provides a suite of purge batch jobs that run in SABRE server.

For more information on the purge routines and how to run them, see:

Other Database Administration Considerations

Other considerations when managing the CMP database include: