Instructions for
Building OSP Databases:
Examine the two data files
'Dssetup' and
'Dsunload' in the
OSP demo directory. These files along with the
customer orders, demand history, and demand forecasts files show all the
data necessary to build the OSP.MDB demo model. The latter files are located in the demo directory under the names
'CustOrd.dat',
'DemHist.dat', and
'DemFcst.dat' respectively.
A careful analysis of
these five data files will provide a good basis for understanding the
structure of the OSP database system. Any new database created for a
manufacturing operation must conform to this very robust structure.
It requires relating the operational data to the
terms:
Processes, Products, Machine Types, Functions, Product Constructions,
Standards, Resources, etc. as illustrated in the five data files above.
The main files Dssetup and
Dsunload are tightly formatted
in specific fields or columns, and a single missed column will abort the
loading. It is highly recommended that the data for testing operational databases be
kept to a minimum and the forms filled out and sent to
scopellc@ntelos.net
for setting up.
For creating full operational databases, it is recommended that
the Primary Method be used to first create a database named Primary.mdb
containing the 12 primary tables. This database completely contain the
OSP database structure. A utility program is available to create and
maintain Primary.mdb. An alternate
means of creating new OSP databases by this method is to electronically map and transfer
existing databases and data files
onto the 12 primary tables in Primary.mdb.
The OSP database programs
will complete the building of the OSP database from this Primary
database.
See
Primary Method for instructions
on maintaining Primary.mdb.
