aquila: Partial Behavioural Specification for the Textual Version of the ACEDB Database Management System

aquila is a perl-based benchmarking program for ACEDB. It can be set up to run the tace binary of ACEDB under different machine or code conditions. The program goes through a series of preset test routines and reports on CPU time, speed, and memory utilization. The main purpose of the default test routines are to look for errors in the ACEDB program; it rigorously tests ACEDB. For new curators, it also serves as a tool to learn ACEDB data loading and query syntax by studying the test routines. This program was developed by Detlef Wolf and updated by Jean Thierry-Mieg.

The following are steps for running aquila:

  1. Download in binary format the aquila.avr97.tar.gz file to a specified directory (i.e. $DIR/aquila).
  2. Unpack the gzipped file within the specified with the command:
                       "gunzip -c aquila.avr97.tar.gz | tar xvf -"
  3. Create a test directory within the specified directory for your test conditions (i.e. $DIR/aquila/testmachinename).
  4. Create a /bin directory within your test directory (i.e. $DIR/aquila/testmachinename/bin).
  5. Create a link from the /bin directory to the tace binary that you wish to test (i.e. ln -s /myacedb/bin/tace $DIR/aquila/testmachinename/bin/tace).
  6. Go to the aquila diectory and start your test by typing:
                       "aquila testmachinename"
  7. After test is completed, view results in the file named testmachinename.oneresult

The complete test may take a few minutes up to 30-45 minutes, depending on the machine (see the aquila benchmark results. Results for one test can be compared to results run from a differently compiled binary or a binary setup on another machine. More information about the tests can be found in the $DIR/aquila/config/scripts file. Some the tests conducted by the script are summarized below: