Authoring Database
The RCKMS platform is dependent upon a relational database management system (RBDMS) for maintaining data state in the Authoring environment. The primary use cases for this database are:
User records and credentials for accessing the CAT web application.
Storing relational records related to rules generation, such as jurisdictions, reporting specifications, code systems, and other facets of generating Knowledge Modules.
Queuing deployment entries in support of Synchronization activities.
Database Software
Workloads dependent upon the Authoring Database expect a Postgres or Postgres-compatible database engine. Due to the volume of data stored, it is recommended to use a cloud platform managed solution, such as AWS RDS or Google Cloud SQL for Postgres.
Specifications
AIMS Environments
AWS Relational Database Service (RDS) is deployed with a single (1) primary instance of SKU db.r4.4xlarge, sized with a minimum of 16 vCPU, 122 GB RAM, and a minimum of 50 GB of SSD storage dedicated to the RCKMS platform schemas.
Rolling backups or point-in-time recovery snapshots should be enabled with a minimum 14 day retention period.
As data state stored in the Authoring Database is human-generated, and necessary for all aspects of operating the platform, it is paramount that data loss be avoided.
Furthermore, while end-user credentials are encrypted-in-transit and in-rest in the Authoring Database, additional security safeguards are recommended to prevent third-party exfiltration of data stored within.
Last updated