Risk Analytics Platform includes separate data models for the VLDBServer and RAPCache databases. Although these data models target different databases, they share an identical data structure.
Depending on your business environment, you may need to create additional tables or columns. If you modify the data model, the RAPCache database schema must match the VLDBServer schema, if both databases are targets of the same data loading process, or support the same queries, or both. After you make your changes, you can use PowerDesigner to produce a set of data definition language (DDL) statements directly from the data model. PowerDesigner saves the DDL in a SQL script that you can run to generate the tables and other objects for the target databases.
Note
You need to install Sybase PowerDesigner 11.1 on Windows before
you generate DDL for the Risk Analytics databases. You can also
use PowerDesigner to view and update the data model.
For information on installing PowerDesigner, see “Installing PowerDesigner PhysicalArchitect” in Chapter 2, “Installing RAP Core Components” of the Risk Analytics Platform Installation and Configuration Guide.
For information on using PowerDesigner, refer to the PowerDesigner 11.1 product documentation.
Risk Analytics Platform includes the DDL scripts you need to create database objects in both your RAPCache database (an Adaptive Server Enterprise database) and your VLDBServer database (a Sybase IQ database). The instructions in this chapter are optional, unless you customize the data models. In this case, the following instructions guide you through the PowerDesigner DDL generation process for both the VLDBServer and RAPCache databases.
Note
Your system administrator must copy the data models from the
subdirectories of $RAP30/Model on
the server to a target directory on the Windows machine where PowerDesigner
is installed. As a convention, this document refers to the model
directories on the target machine as Model\VLDB and Model\RAPCache.
The environment variable $RAP30 refers to the RAP 3.0 installation
directory.
