jAdmin: Remote database admin tool

download report

Transcript jAdmin: Remote database admin tool

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!