Specifications

Agilent ChemStore C/S — Database Administration, Backup and Recovery
web-based application that can be
run from any PC on the network.
The Admin Client performs the
following main tasks on the server
database using a service running
on the server.
• Schedule archive, dearchive
and delete operations.
• Modify scheduled operations.
• View reports detailing pending
operations.
• Review archive and dearchive
history.
• View information about
archives, runs and other
objects, including a list of all
runs in the archive unit.
• Execute archive, dearchive and
delete operations immediately.
• Keep an audit trail of all
archive and archive delete
operations.
• Add and modify database con-
nections to offer connection to
a second Oracle database.
Database backup and recovery
One of the most important IT rou-
tines is the implementation of a
Backup and Restore concept.
Backups and – equally as important
– the ability to restore a backup are
important tasks in order to protect
business data and laboratory
investments.
Agilent Technologies can provide
assistance in creating, implement-
ing and testing a ChemStore C/S
Server Backup and Restore strate-
gy. This strategy should ideally be
planned before the implementation
but Agilent offers both, a service
prior to the installation as well as a
post implementation service.
For this purpose a ChemStore C/S
Backup & Recovery strategy paper
has been developed. With this
strategy paper and by working
with a customer’s ChemStore C/S
administrator Agilent provides a
consulting service to plan and
implement the right backup and
recovery strategy for your busi-
ness.
With a working knowledge of
implementing solutions Agilent
uses software from Veritas called
Veritas Backup Exec™ for
Windows NT and Windows 2000,
Backup Exec Agent for Oracle™
and Backup Exec Intelligent
Disaster Recovery.
14
Database administration
The review client provides the
graphical user interface (GUI)
through which the user can accom-
plish the following administrative
tasks. Although the capabilities of
the entry-level and client/server
versions are to some extent differ-
ent, the GUI is identical.
• Create a new database–(entry
level database only),
• Compact (defragment) a data
base–(entry level database only),
• Create or modify a study or
custom fields,
• Administer system settings,
• Administer users and security,
• Manual or automatic archive,
delete and de-archive data
(server-only),
• Assign studies to users,
• Email notification on
security violations (server-only).
The client/server version offers
supplementary tools for administra-
tors in the Admin Client to per-
form proper maintenance of the
server database, archive/ dearchive
or archive/delete functions and
other setup tasks. The Agilent
ChemStore C/S Admin Client is a
Agilent ChemStore C/S — Archiving Data
The client-server version provides
for manual or automatic archiving
to a separate file on disk or tape
of runs present in the database.
Manual archiving is done from the
“Archive/Delete” view in the
ChemStore C/S review client and
is based on the selected data set.
An administrator with archival
permission can set up a list of
individual archive queries for
automatic archiving, which are
executed at predefined time inter-
vals. Each custom query is put
together from a set of criteria,
including for example, injection
time, sample name, instrument
name, operator name, sequence
name, method name, study name,
custom field values, approval sta-
tus and so on (figure 9a). The
available operands depend on the
data category (text, numeric val-
ues, date) including wildcards and
relative values (for example, runs
“older than x days”). For perfor-
mance reasons the number of
clauses that can be defined for