jAdmin: Remote database admin tool

1
jAdminRemote database admin tool
2
Introduction

• Growing demand for large scale, multi-user
  applications
• Persistent, efficient, data storage
• Databases!
• With databases come tools to use them

3
Motivation

• Major database admin tools
• MyPHPAdmin
• iSQLPlus
• Microsoft Access

4
My Project

• jAdmin
• Remote database admin tool
• Designed for newbie users unfamiliar with
  databases and their tools

5
Goals

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

6
What should it do?

• All the standard things
• Table creation viewing
• Data entry
• SQL query handling
• And more!
• Guided queries

7
Technology

• Java 5.0
• Swing package
• SQL package
• MySQL Server
• MySQL Connector/J

8
Design

• Table view (data entry mode)
• SQL query handling
• Guided queries
• Table creation

9
Design

• Main window

10
Toolbar

• Buttons v. menu

11
Main frame

• Houses display

12
Table view

• Most integral part
• Houses all data
• Data entry

13
SQL query

• Query handling

14
Guided query

• Designed for users unfamiliar with SQL
• Uses drop down menus to allow users to structure
  their own basic SQL queries

15
Table creation

• Access-like creation

16
Data entry

• Double click and type!
• Data validation as you type

17
Behind-the-scenes

• Data validation
• Type formatting
• Constraints
• Local data changes updated to database

18
Demo!
19
Future work

• Finish constraints
• Foreign keys
• Auto-increment?
• More extensive guided queries
• DBMS independence
• Type 3 JDBC driver

20
Thoughts

• Start earlier!