Skip to content

Viewing provenance in a relational database

Jump to bottom
Raza Ahmad edited this page Aug 25, 2017 · 10 revisions

H2

SQL Workbench/J is a free tool that can be downloaded from Thomas Kellerer. To use SQL Workbench/J for viewing H2 SQL databases generated by SPADE, perform the following steps:

Initial setup (this only needs to be performed once):

  1. The H2 Java library is required for use with SQL Workbench/J. This will be located in the lib directory of your SPADE installation. If you do not have SPADE downloaded/installed, the library can be downloaded from here.
  2. Start SQL Workbench/J.
  3. Go to File --> Manage Drivers.
  4. Select H2 Database Engine from the list.
  5. For Library, enter the path to the H2 Java library.

Viewing H2 SQL databases:

  1. Go to File --> Connect.
  2. Select H2 Database Engine from the Driver list.
  3. For URL, enter the path to the H2 SQL database without the extension. For example, if the database file is located at /tmp/database.mv.db, enter /tmp/database in the URL field.
  4. Enter sa for Username.
  5. Leave the password blank.
  6. Click OK to connect to the H2 SQL database.

The Database Explorer tab can now be used to view/browse the data:

The Statement tab can be used to execute SQL statements in the database:

This material is based upon work supported by the National Science Foundation under Grants OCI-0722068, IIS-1116414, and ACI-1547467. Any opinions, findings, and conclusions or recommendations expressed in this material are those of the author(s) and do not necessarily reflect the views of the National Science Foundation.

Clone this wiki locally