beautypg.com

Database maintenance, Atabase, Aintenance – Keri Systems BioPointe User Manual

Page 63

background image

Biopointe Central User’s Manual

Advance Features 59

P.

Database Maintenance

The application provides the features like re-index, pack, empty, backup, restore and setting the database
path as tasks for database maintenance. Re-index operation should be carried out when the database sorting
or filtering function is not working. Packing operation should be carried out when there are many delete
operations done on the device user database. This is because a delete operation does not remove records
completely from the database until a packing operation is carried out. As for backup operation, users
should it carry out periodically. The database being backed up include system database, event logs
database, device user database and device users’ access right database. All the database files will be
compressed into 1 zip file. The default zip file name is YYYYMMDD.zip. (Eg: User did a backup on 08-
11-2000, the default backup file name will be 20001108.zip.) If user does not want to name the zip file this
way, system allows user to change the zip filename before zipping all the database files. The zip file will
be stored in the default backup directory or in the directory specified by the user. Make sure all the
database files are closed before backing up. Restore Option allows user to restore all the database files from
a zip file. All the files will be restored to Data directory. The restored system files will overwrite the current
system files located in the data directory. User needs to select which zip file to restore. This function is only
enabled if the logon user has supervisor right.

To re-index the database file:

(1) Click Database from the top menu and select ReIndex from the drop-down menu.
(2) Click on the Include column to select the item to be re-indexed.

(3) Click OK to start the re-index operation.

To pack the database:

(1) Click Database from the top menu and select Pack from the drop-down menu.
(2) Click on the Include column to select the item to be packed.