App Brainstorm & Ideas

Here we can brainstorm ideas on features for the application and how a user might use this application.

Features

Searching

• Ability to save searches
• Ability to remove saved searches
• Show most recent searches
• Ability to have basic and advanced searches (filters)
• Ability to sort the search results in ascending and descending order
• Data can be sorted based on the type of data present.(Numerical, alphabetical, most, least, etc.)

Tooling

• Syntax and spelling checker
• Embedded scripting environment to interact with the application and the database (jython, jruby, luaj)

SQL

• Have an SQL editor
• SQL Query output window for query results
• SQL console
• SQL Code completion
• Preset/built in query functions based on what may be commonly searched for.
• Import/Export/Execute SQL Query files

Database Management

• Backup/Restore/Convert entire databases
• Option to delete the entire database
• Triggers

History

• List/keep a record of previous actions such as add/remove and edits made
• A "Diff" feature to show changes that will be made or that were made to a table
• Compare database back up files (diff and history)
• Have an audit trail that tracks the changes and shows the before and after edit or deletion, by who (username), and the date and time this change was made.

Interface

• User friendly connection window / wizard (initialize driver, login credentials, create connection)
• A GUI that displays the database structure
• A display window to allow easy viewing of what users are searching/changing
• Provide breadcrumb to let the users know where they are
• Prompt user with an "Are you sure you want to delete the selected item" message box when the user chooses to delete an item
• Tabs to maintain multiple sets of searches simultaneously

Configuration

• A "Users" feature. Save different user profiles within the application, keeping their preferred connections to different databases.
  • Perhaps just called profile and not user. One user may wish to have several profiles.

Security

• An option to give some users more or less permission than usual, controlled by a designated admin
• Have user credentials to keep unwanted users out
• Encrypt and store user credentials securely

Other

• Options to flag for things such as duplicate entries or missing info that is required

Uses for the Application

• Search the JDBC database
• Add/Remove/Edit information in the database
• Save, commit, and the ability to backtrack if not committed
• Flag/warn for duplicate entries
• Store and manage connections to different databases

Design

• Create an ADA (Americans with disability ) compliant portal
• Ability to edit the View of the browser to show desirable data in the same window.
• Platform-independent (Cross-platform)
• Multi-language approach: Auto-translation tools is available when users search database in any other languages.