Database - Architecture Advanced Design and Setup Guide - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

Architecture Advanced Design and Setup Guide

Platform
Perceptive Content
Product
Architecture Advanced Design and Setup Guide
Release
Foundation 24.1
License

The Perceptive Content database stores the metadata information related to the content stored in the OSM, as well as system information. The Perceptive Content database uses the optimal number of indexes necessary to increase read performance without negatively impacting record inserts. Thorough index auditing supports this design, where the Perceptive Content database leverages the unique database tuning tools of the chosen platform.

The Perceptive Content Server performs all database transactions, a factor that contributes to scalability. The Perceptive Content Server creates a pool of database connections, which eliminates any client-side database connectivity requirements. By establishing a connection pool to the database on behalf of the clients, Perceptive Content maximizes system resources on the server, which enables it to handle increasing user loads while ensuring linear performance.

All internal database communication occurs through industry-standard SQL, instead of DBMS-specific code used in stored procedures. This design streamlines the code for all DBMSs and increases performance by taking advantage of the power and flexibility of an integrated programming language versus a database-specific interface language. An additional advantage this design provides is that no maintenance is required to port stored procedures when manufacturers release new database versions.