|
Introduction: |
|
The Database Management Tool serves as a bridge
between a legacy flat files database and an Oracle database. The
DBMT was originally designed for use with the Aurora Financial Model, but
can be used to move any flat files database into an Oracle database.
Only existing flat files are currently served by the DBMT, but future
releases will allow for a flat files database to be created as well.
|
|
| The DBMT provides a simple, graphical interface which
allows people who have no experience with SQL, Oracle, or UNIX to
perform database tasks such as loading and deleting data.
|
|
|
To keep track of the format in which the data in the flat files is kept as well
as describe what the data represents, there is a flat files table
description interface. These descriptions also serve to
create control files used to map the data in a data file to
a table in an Oracle database.
|
|
| Installation: |
|
The DBMT needs to be installed in a directory accessible by the
web server. In order for everything to work properly, all directories
and files in the flat files must have permissions set to allow
the generic web user (usually noone or nobody) full access. This can
be accomplished by adding the generic user to a group such as http and
then changing the group of the flat files directory and its contents
to http.
|