Database Examples

DatabaseLink contains a number of example databases (many use HSQLDB). These allow you to try examples in the documentation and learn the details of working with databases in Mathematica. The examples are configured to run in $UserBaseDirectory/DatabaseResources/Examples (they cannot reside inside the main Mathematica installation directory). If you want to run these examples you will need to install them. You can do this by copying the files or by running the command DatabaseExamplesBuild from the DatabaseLink`DatabaseExamples` package. This function will install the examples (if necessary), it will also restore them so that the examples in the documentation will work.

The following shows the location of the database examples on this computer.

In[1]:=

Out[1]=

You must run DatabaseExamplesBuild the first time you want to use the documentation, and after you have been working with the example databases and want to restore them to their original state.

This demonstrates the operation of the package. First, the package is loaded.

In[2]:=

The following command restores the database examples to their original state. This will also install them if necessary.

In[3]:=

If you want to install the examples by hand you would copy the Examples directory from inside the DatabaseLink installation directory (typically this is $InstallationDirectory/AddOns/Applications/DatabaseLink) to $UserBaseDirectory/DatabaseResources.