Database design Technical implementation
U929-J-Z125-9-76 51
Dokuschablonen 19x24 Version 7.3us für FrameMaker V7.x vom 14.02.2007 © cognitas GmbH 2001-2007 18. Oktober 2007 Stand 11:29.49 Pfad: G:\vogt\fsc\ud s\Manuale\en\udsent_e\uds ent.k03
3.3.2 Defining the physical structure of a UDS/SQL database To define the physical data structure, you use the SSL (Storage Structure Language).
The SSL is used to specify mainly:
– set information
– data placement
– optimization
– links: internal tables, chains, lists.
The data is essentially distributed over database areas via the SSL, taki ng the following
aspects into account:
– depending on access frequency,
– according to physical storage options (disk capacity) and
– according to the backup procedures used.
3.3.3 Views Subschema
With the subschema DDL, the user selects sections from the database which are required
for a particular application.
For a detailed description of the subschema DDL, see page 183.
Relational schema
A relational schema is used in an SQL application. A re lational schema is the relational view
of an actual subschema. Such a view can be derived from a subschema with the aid of the
utility BPSQLSIA.
For further information on the relational schema, see page 196.