Loading a database

In order to populate a database, go through the following steps:

  1. Create a schema file which contains MQL statements which create all the enumerations and object types and features necessary. Use the CREATE ENUMERATION and CREATE OBJECT TYPE statements for this. See the MQL User's Guide for how to use these statements. The schema file should contain a CREATE DATABASE statement and a USE DATABASE statement at the top of the file.

  2. Run this schema file through the mql(1) program.

  3. Populate the database. This can be done in two ways:

    1. Write and run a program which takes any existing data and uses the MQL query language to create new objects. In particular, use the CREATE OBJECT FROM MONADS statement, or the CREATE OBJECTS WITH OBJECT TYPE statement.

    2. Create the database on-the-fly using some analysis program you have created.


Previous:Your application
Up:Part III: Tips
Next:Speeding up population