Next: Sybase 11 Database
Up: OPM Schema Translator
Previous: Mapping Data Files
The Sybase DBMS specifications generated by the OPM Schema Translator
are contained in six files consisting of:
- specifications for tables (relations), user defined types,
and views;
the name of this file consists of
the database name or
the name of the file containing the
input OPM schema, followed by _relations.[ Z];
- specifications of
rules for maintaining valid values for user defined types;
the name of this file consists of
the database name or the name of the file containing the
input OPM schema, followed by _datarules.[ Z];
- specifications regarding
data dictionary definitions for primary and foreign keys;
the name of this file consists of
the database name or the name of the file containing the
input OPM schema, followed by _spkeys.[ Z];
- specifications regarding index definitions;
the name of this file consists of
the database name or the name of the file containing the
input OPM schema, followed by _indexes.[ Z];
- procedural specifications for maintaining
referential integrity constraints and rules;
the name of this file consists of
the database name or the name of the file containing the
input OPM schema, followed by _ritriggers.[ Z];
- procedures for verifying (off-line) the referential integrity
of an existing database;
the name of this file consists of
the database name or the name of the file containing the
input OPM schema, followed by _check.[ Z];
Z in the file names mentioned above
is SYB11 (for Sybase 11),
SYB10 (for Sybase 10), or
SYB4 (for Sybase 4.0-4.9).
The files generated by the OPM Schema Translator can be loaded together.
However, if data loading utilities provided by the DBMS (such as
the bcp utility of Sybase) are going to be employed for
loading data into the database, for efficiency reasons
it is preferable to load only the table definitions,
then load the data into the database and use the verification procedures
for checking the referential integrity of the data, and then
load the index and referential integrity definitions.
Next: Sybase 11 Database
Up: OPM Schema Translator
Previous: Mapping Data Files