1 / 20

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.

kaz
Download Presentation

jAdmin: Remote database admin tool

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. jAdmin:Remote 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 • iSQL*Plus • 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!

More Related