This section describes the RAP data model.
The RAP model includes three diagrams (submodels): RAP, Instrument, and Market Data. Detailed descriptions of each submodel are provided below. No packages are defined in the model.
The entire model contains 51 tables and 271 columns; each table is shown in at least one submodel. All tables and columns have detailed descriptions.
The data types are assigned to table columns via domains; there are 16 domains in the model.
All primary keys and foreign key constraints are named in accordance with standard naming conventions, that is, PK_<table name> and FKnn_<table name> for a primary key and foreign key constraint, respectively (where nn is the constraint number).
In a similar manner, model indexes are named as XKnn_<table name> (where nn is the index number). Domain names are defined as SYB_<domain name>.
Only indexes needed to support the sample queries are included in the model. The VLDBServer data model contains 64 indexes; the RAPCache data model contains 8 indexes. More indexes can be added at the customer site to meet the specific requirements related to the data load and/or query performance.
