A schema definition in the ESP Schema model represents a data stream in
ESP.
The sample ESPSchema model contains a schema definition for each market data
table. You can customize any schema definition, or create a new one.
To create new schema in the ESP Schema model, you can either:
- Create schema in PowerDesigner, and then generate a CCL file
from it, or,
- Import schema definitions that are defined in a CCL file.
Each schema definition contains:
- identifiers – associate schema with columns that are keys in the
associated table.
- attributes – associate schema with a destination column name in the
Sybase IQ and ASE with length and precision where appropriate, lookup table
and column information for columns that are foreign keys, and descriptive
notes.