jAdmin:Remote database admin tool

Introduction

• Growing demand for large scale, multi-user applications– Persistent, efficient, data storage

• Databases!

• With databases come tools to use them

Motivation

• Major database admin tools– MyPHPAdmin– iSQL*Plus– Microsoft Access

My Project

• jAdmin– Remote database admin tool– Designed for “newbie” users unfamiliar with

databases and their tools

Goals

• User-friendly!– Intuitive, graphical interface– Minimalistic design– Take the load off the user

What should it do?

• All the standard things…– Table creation & viewing– Data entry– SQL query handling

• And more!– Guided queries

Technology

• Java 5.0– Swing package– SQL package

• MySQL Server

• MySQL Connector/J

Design

• Table view (data entry mode)

• SQL query handling

• Guided queries

• Table creation

Design

• Main window

Toolbar

• Buttons v. menu

Main frame

• Houses display

Table view

• Most integral part

• Houses all data

• Data entry

SQL query

• Query handling

Guided query

• Designed for users unfamiliar with SQL

• Uses drop down menus to allow users to structure their own basic SQL queries

Table creation

• Access-like creation

Data entry

• Double click and type!

• Data validation as you type

Behind-the-scenes

• Data validation– Type formatting– Constraints

• Local data changes updated to database

Demo!

Future work

• Finish constraints– Foreign keys– Auto-increment?

• More extensive guided queries

• DBMS independence– Type 3 JDBC driver

Thoughts

• Start earlier!