Rel359 icon

Rel359


A Relational Database Tool for M359 Students

System Requirements

  1. Rel359 requires Java 6 (also known as Java 1.6.x) or higher. The Sun Microsystems implementation is available at http://java.sun.com. Other vendors' JDK implementations may work, but have not been tested.
  2. Rel359 requires the Java 6 JRE (Java Runtime Environment) platform to be installed. You can also use the Java 6 JDK (Java Development Kit) and this may provide additional functionality (Java-based user-defined OPERATORs or TYPEs), but these features have not been tested in Rel359.
  3. Depending on the operating system you use, you may need to configure your system PATH (or equivalent) in order to recognise Java from any directory or folder. Unfortunately, instructions for doing this are beyond the scope of this document.

Note that Rel359 has been built and tested on Microsoft Windows XP but should work on all platforms supported by Java.

Download

Download the Rel359 installer here:

Rel359 is supplied with an empty database. Scripts to populate this database with data used in the M359 course will be provided below.

Scripts

After you have downloaded the scripts below, start Rel359, click the "Load" button in the lower pane, select the appropriate script file, click "Open", then click the "Execute (F5)" button.

Note that these .r359 files are plain text files and can be edited with any plain text editor.

  • University.r359     12.24kb    updated Thursday, December 31, 2015
  • Hospital.r359     10.82kb    updated Thursday, December 31, 2015
  • Others.r359     1.46kb    updated Thursday, December 31, 2015

In these scripts all dates are rendered in ISO 8601 format (YYYY-MM-DD) so that they sort and compare properly. In the Drug relation in the Hospital script, the Type attribute has been renamed DrugType because Type is a reserved word in Rel359.

Installation

  1. Download the installer .jar file above.
  2. Execute the .jar file. On most platforms, you should merely have to click on the .jar file to run it. If your platform does not support this, type the following at the command line:
    java -jar Rel359Install.jar
  3. Follow the instructions provided in the installer. Unfortunately, at this time the installer only creates "Start" menu items and shortcuts for Linux and Microsoft Windows. Under other operating systems, you will have to invoke the programs from the installation directory and/or create your own shortcuts.
  4. To get started, select "Rel359 | Rel359" from the "Start" menu. Or, go to the installation directory and execute DBrowser.jar, either by clicking on DBrowser.jar (all OSs that support one-click invocation of Java programs), DBrowser.bat (Windows), DBrowser (UNIX or UNIX-like operating systems), or by typing the following at the command line:
    java -jar DBrowser.jar

page last updated: Thursday, December 31, 2015