Database Partitioning

TIBCO Order Management maintains a large number of orders, models, plan fragments, and other business-related data. To manage this growing data, the database is partitioned into logically independent units. The TIBCO Order Management database supports two databases out of the box: Oracle and PostgreSQL.

The database is partitioned using the PARTITIONDATE column. Implementation of the PARTITIONDATE column differs for Oracle and PostgreSQL databases.

For both database back-ends, scripts are provided to complete the following tasks: