Siemens V 4.0 Manuel D’Utilisation

36

GINA V4.0 System Administrator Guide – September 2000

Customizing the database layout

name

Name of the table to which the specialist model classes are to be mapped.
The default value is the class name.

Optional entry

resource

Entry to identify a dbspace in which the tables are to be stored. Such a
dbspace is a storage area which is based on the physical storage media.
Additional storage instructions are entered using the “fr definition lines” and
result in the fragmentation of the table.

Assigning tables to storage structures allows for the implementation of opti-
mization strategies for backing up data and for access functions. The default
value for storing a table is the dbspace in which the database is generated
(

-d

dbspace

option for the

 mgendb

generator [14]).

Optional entry

firstExtent

Entry for defining settings for the size of physically related storage areas,
which are reserved with the first entry in the table. Like

 resource,

this

function serves to optimize the storage layout and enables it to be adapted
to the volume of data involved. The minimum, maximum and default values
depend on the database system and on the layout of the storage media.
They are specified as integer multiples of pages (generally 2 Kb).

Optional entry

nextExtent

Optional entry for defining settings for the size of physically related storage
areas, which are reserved with each extension to a table. As with the

firstExtent

 entry, this function serves to optimize the storage layout.

t |

myClassname1 | myNewTableName1 | dbspaceName | 4 | 4 |

t |

myClassname2 | myNewTableName2 | | | |