A schema definition in the ESP Schema
model represents a data stream in ESP.
The sample ESP Schema 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
SAP Sybase IQ, SAP HANA, and ASE databases
with length and precision where appropriate, lookup table and column
information for columns that are foreign keys, and descriptive notes.