Generating DDL Scripts

The data models for the RAPStore and RAPCache databases target different databases; however, they share almost an identical structure. Modify data models by creating additional tables or columns to suit your business environment.

Although the RAPStore and RAPCache data models target different databases, their data structures are nearly identical. The RAPCache database schema must match the RAPStore schema for all tables in which data will be inserted. 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. You can also use PowerDesigner to view and update the data model.

Sybase RAP includes the DDL scripts you need to create database objects in both your RAPCache database (an Adaptive Server Enterprise database) and your RAPStore database (a Sybase IQ database). The instructions in this chapter are optional, unless you customize the data models.

Note:

Your system administrator must copy the data models from $RAP/RAPCache/datamodel/MarketData on the RAPCache server and $RAP/RAPStore/datamodel/MarketData on the RAPStore server to a target directory on the Windows machine where PowerDesigner is installed. This document refers to the model directories on the target machine as $RAP/RAPCache/datamodel/MarketData and $RAP/RAPStore/datamodel/MarketData. The environment variable $RAP refers to the Sybase RAP installation directory.

Generating Database Schema with PowerDesigner
PowerDesigner includes all the resources you need to generate a set of data definition language (DDL) statements in SQL scripts directly from the Sybase RAP data models. Run these scripts to generate a schema for your RAPStore and RAPCache databases.
Generating DDL Scripts for the RAPStore Database
Follow these instructions to generate DDL for RAPStore, which is a Sybase IQ database. The data model for RAPStore is RAPStore.pdm, which is located in the $RAP/RAPStore/datamodel/MarketData folder.
Generating DDL Scripts for the RAPCache Database
The RAPCache database is an Adaptive Server Enterprise (ASE) database. The data model for RAPCache is RAPCache.pdm , located in the $RAP/RAPCache/datamodel/MarketData directory.