Transcript SM_02_Present

A Java Environment for a
Semantic Query Interface for
Relational Databases
Sam Marcellus
Dr. Ramon Lawrence
Computer Science Dept
University of Iowa
Database Querying

Structured Query Language (SQL)
Albums
ID
Album Name
Artist
Genre
Release
1
Highway 61 Revisited
Bob Dylan
Rock
1965
2
Sgt. Pepper’s
Beatles
Rock
1967
SELECT [Album Name] FROM Albums WHERE Artist=“Bob
Dylan” ORDER BY [Album Name] DESC
Album Name
Highway 61 Revisited
Unity




Written by Dr. Ramon Lawrence and Dr.
Ken Barker
Uses semantic naming from a dictionary
to automate SQL generation
Querying is based on semantic names
as opposed to database structure
Written using Microsoft Foundation
Classes (MFC)
Unity’s Graphical User
Interface (GUI)


Query fields are selected from the right-side tree
The query is built on the left-side tree
Overview



Applications written using MFC are
limited in compatibility across multiple
platforms
Unity needs to be ported to a more
universal environment, such as Java
A GUI that resembles Unity was created
in the form of a Java Applet
SELECT [Album Name] FROM Albums WHERE Artist=“Bob
Dylan” ORDER BY [Album Name] DESC
Album Name
Highway 61 Revisited
Applet Structure
Conclusion




GUI was written with modularity in
mind
Tree class is encapsulated
Unity-JDBC Driver is currently being
developed
This GUI will be able integrated with a
backend that handles the advanced
Unity features
Acknowledgments



Dr. Lawrence
Terry Mason
The Decapitated Smurf