Skip to content

rs146/RDBMSExperiments

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

16 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

The SQL file for the creation of the BIND database schema is in the folder 'database' 
and is named: BINDschema.sql. It was constructed to be as similar as possible to the
OO data model for BIND DNS that was designed in the Project Report. The SQL file can
be run on a MySQL server instance as this was the Relational database vendor used in
the experiments.

Maven was used as the building tool for this NetBeans Project. The advantage of 
using Maven is that the examiner does not have to download jar files or libraries.
To download all the relevant libraries, Right-click the Project in NetBeans and
choose the option 'Build with Dependencies'. This will download all relevant 
libraries that were used in these experiments. The 'pom.xml' file is contained
within this very directory and this outlines all the libraries used in these 
experiments.

The hibernate mapping files are in the folder:
'/src/main/java/resources/hibernatemappings'. 

All experiments were conducted as JUnit tests within the 'Test Packages' package 
folder. These java classes are in the folder: '/src/test/java'. Within this 
directory there are two sub-folders: 
1. hibernateexperiments - contains all JUnit experiments that were conducted using
                          hibernate and MySQL.
2. jdbcexperiments - contains all JUnit experiments that were conducted using 
                     embedded SQL with JDBC and a MySQL database. 

Both of these experiments used the same MySQL instance as their datasource.

The Java classes for each experiment are outlined as follows:
Experiment1 - Insertion tests.
Experiment2 - Retrieval tests for objects.
Experiment3 - Retrieval tests using SQL for obtaining primitive data.
Experiment4 - Update tests.
Experiment5 - Deletion tests.
Experiment6 - Join query tests.

About

Code for the Project Experiments with MySQL & Java

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages