Risk Analytics Platform includes separate data models for the RAP repository and the RAP cache database. Although these data models are targeted to 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 RAP cache database schema must match the RAP repository schema, if both databases are targets of the same data loading process and/or support the same queries. 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 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 RAP cache database (an Adaptive Server Enterprise database) and your RAP repository 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 RAP repository and RAP cache databases.
Note
The pathnames specified in this chapter are relative to the
folder Risk Analytics Platform 2.0, which is
installed on Windows in the folder c:\Program Files\Sybase by
default. So the full default path of a reference such as \Model\IQ is c:\Program Files\Sybase\Risk Analytics Platform 2.0\Model\IQ.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
