MS SQL Server Filegroups
The Core Database of SAP Convergent Charging includes the following database filegroups. They are defined to optimize the storage of data in the database system (MS SQL Server).
The database always includes filegroups dedicated to the data and relating filegroups that include the database indexes.
A-Z Index
To optimize the data storage, the database administrator (dba) creates and maintains the following filegroups in the database:
| Name | Description |
|---|---|
| ACCESS_DATA | This filegroup contains the tables used to store the chronologies of the mappings |
| ACCESS_INDX | This filegroup contains the indexes used to store the chronologies of the mappings |
| ALLOWANCE_DATA | This filegroup contains the tables used to store data related to the allowances |
| ALLOWANCE_INDX | This filegroup contains the indexes used for the allowances |
| CATALOG_DATA | This filegroup contains the tables used to store the objects belonging to the catalog |
| CATALOG_INDX | This filegroup contains the indexes used for the objects belonging to the catalog |
| COUNTER_DATA | This filegroup contains the table used to store the counters declared in subscriptions and provider contracts |
| COUNTER_INDX | This filegroup contains the indexes used for counters |
| C_SNAPSHOT_DATA | This filegroup contains the table used to store counter values for subscriptions and provider contracts |
| C_SNAPSHOT_INDX | This filegroup contains the indexes used for counter values |
| OBJECT_CHANGE_DATA | This filegroup contains the tables used to store data related to the object change log of detailed audit |
| OBJECT_CHANGE_INDX | This filegroup contains the indexes used for object change log of detailed audit |
| PRERATING_DATA | This filegroup contains the tables used to store prerating data |
| PRERATING_INDX | This filegroup contains the indexes used for prerating data |
| SESSION_RATING_DATA | This filegroup contains the tables used to store session-based events and charging session histories for failover purposes |
| SESSION_RATING_INDX | This filegroup contains the indexes used for session-based events and charging session histories for failover purposes |
| SUBSCRIBER_DATA | This filegroup is used to store the tables containing objects belonging to provider contracts and subscriptions |
| SUBSCRIBER_INDX | This filegroup contains the indexes used for the objects belonging to provider contracts and subscriptions |
Additional Information
Implementation Project Phase
- Refer to the SAP CC Sizing and Performance Tuning Guide for more information about the hardware sizing with SAP Convergent Charging.
- Refer to the SAP CC Installation Guide for more information about the installation preparations.
Production Operation Phase
Refer to the SAP CC Operations Guide for more information about the database monitoring, maintenance, or purging and archiving operations.
- The SAP CC Admin+ Tool user interface provides you with some purge commands to maintain the back-end database.