Daylight Summer School 1999, June 15-17, St. John's College, Santa Fe, NM

Daylight Worksheet - Building a database with scripts ...SHOW HINTS

By using scripts to build a database, you can automate the process for greater ease and repeatibility. The script is thus both a tool and a record of the steps taken.

  1. Locate the script MakeDB in your admin directory. This is a sample. MakeDB includes a typical set of steps for converting a database from a non-Daylight format, to creating the database and loading the data. The fingerprint program is used to add fingerprints, necessary for Merlin searching. The clogp program is used to add data. Inspect the script and study how these tasks are accomplished.

    DestroyDB simply destroys the database and its auxilliary databases safely and conveniently.

  2. Copy MakeDB to MakeDB-original and then modify MakeDB to double the primary hash table size and cross-reference hash table size. Also add a command to thorload a second data file generated from test2.mol.

  3. (OPTIONAL) Other possible enhancements to the script:
    1. Cluster the compounds using the Clustering Package (nearneighbors, etc.); add this cluster data to the database.
    2. Add CMR data as well as ClogP data.
    3. Add molecular formulae using the contrib program addmf.c.

  4. Run your edited script and verify that no errors occur and the database is useable with Thor and Merlin.

Daylight Chemical Information Systems Inc.