Database, Administrative work on the database, O_613 – BUCHI DuMaster D-480 User Manual

Page 94: O_614

Advertising
background image

Operation Manual D-480

©BÜCH Labortechnik AG

5 - Work performed by the system administrator

94

Database

What is a database?

A database is characterized by the following:

A database is an organized collection of data managed by a data management system.

Different users can access shared data in a database.

Databases allow the user to input, edit and delete data.

Databases permit searching and selecting data with the aid of filters.

Databases allow the user to create evaluations and statistics.

Databases allow the user to output data in the form of reports.

Maximum database size

The maximum size of the database is limited to 2 gigabytes. The software displays a warning if the
size of the database exceeds 1 gigabyte or if available disk space is less than 1 gigabyte. In this case
the database should be reorganized. See Administrative work on the database (on page 94).

Database protection

If 21 CFR Part 11 functionality is enabled, the database protects you from:

Data loss. The sample data can only be overwritten as long as these samples have not yet been
analyzed. Afterwards, a new file version is created retaining the same file name and the previous
version. This allows you to track all changes to the sample data.

Data distortion. Authorized individuals can add an electronic signature to data documents; the
authenticity of this signature can be verified. In addition, the activities of the indivdiual users are
recorded in a logbook for tracking purposes along with a timestamp and user name.

Unauthorized access to data. There are various password-protected user levels. This allows you
to restrict access to the various menu functions.

See 21 CFR Part 11 functionality (on page 73).

Administrative work on the database

Reorganizing the database

The software always works with one and the same database. Because the size of the database is
limited to 2 gigabytes, it is necessary to reorganize the database regularly. Database reorganization
removes all sample data and the contents of the logbook from the database file, but retains the other
data such as settings, coefficients, etc.

Datebase backup

"Backup" copies the complete existing database file to a certain directory under a different name,
thereby "capturing" a certain state.

Export and import

It is not possible to load and save data from/to a database in the usual way. However, by using the
File > Export/Import > Export and File > Export/Import > Import menu functions it is possible to
transport documents "out of" the database and to transport external documents "into" the database.

Restoring the database

"Restore" reloads an old database file and irrevocably deletes the current data.

Advertising