Dimensions CM is highly configurable with a rich set of relationships and properties. To enable high performance and scalability, Dimensions CM uses relational database technology to store and query metadata.
A single server can connect to multiple database instances, and an instance can contain multiple Dimensions CM base databases. For example, one base database is used for production work and another for testing.
Each base database has its own schema, and there is a single common schema (PCMS_SYS) that stores some metadata.