A databank is the physical file where a collection of tables is stored. A Mimer SQL database may include any number of databanks. There are two types of databanks - system databanks and user databanks.
System databanks contain system information used by the database manager. These databanks are defined when the system is created.
The system databanks are:
- SYSDB containing the data dictionary tables
- TRANSDB used for transaction handling
- LOGDB used for transaction logging
- SQLDB used in transaction handling and for temporary storage of internal work tables.
User databanks contain the user tables. These databanks are defined by the user(s) responsible for setting up the database. See the Mimer SQL Reference Manual, Specifying the Location of User Databanks, for details concerning path names.
The division of tables between different user databanks is a physical file storage issue and does not affect the way the database contents are presented to the user. Except in special situations (such as when creating tables), databanks are completely invisible to the user.
Note: In Mimer SQL, backup and restore can be performed on a per-databank basis rather than on the entire database file base, see the Mimer SQL System Management Handbook, Backing-up and Restoring Data for more information.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40