Database persistence
The database persistence system relies on relational SQL schemas.
The database persistence system relies on relational SQL schemas, represented by diagrams that
use the following legend:
- The key icon marks primary keys (PK).
- Bold denotes NOT NULL values.
- Arrows start directly from foreign key (FK) names.
When connecting to a database, Rule Execution Server relies on the persistence services offered by the application servers or a web server. In Java™™ SE mode, it uses a direct JDBC connection. Application servers provide the following facilities:
- Connection pools to manage connections to the database.
- Data source access to manage the data between the application server and the database.
JDBC drivers handle the connection to the database. The readme file of the product distribution provides the list of tested database drivers.
The following diagram shows the relational tables for RuleApps and rulesets.
The following diagram shows the relational tables for execution traces.
The following diagram shows the relational tables for XOM resources and libraries.
