Specifications of Admistration Tool for Open Source Databases(ATOS-DB)

ATOS-DB empowers developers and DBAs to be more productive by providing an intuitive
graphical user interface to Open Source Database (Postgresql and Mysql particularly).
ATOS-DB will be a powerful, low-overhead tool that makes Database programming development
faster and easier and simplifies database administration tasks.

ATOS-DB can work with multiple databases, sessions, submodules and windows of a same module
at the same time.

ATOS-DB consists of following submodules:

Advanced SQL Editor
Advanced SQL Editor is fully configurable Syntax-Highlighting editor for SQL.
Includes hot keys, auto-correct and type-ahead features for faster coding.
Has the follwing functionalities:
-create/drop databases
-create/edit/drop tables
-Write and execute SQL-queries

Procedure Editor
Multi-tabbed Procedure Editor allows developers to work on multiple files in parallel using CVS-compliant version control.
-Write and execute database procedures.
-Edit existing procedures in the database.
-Show coding errors before execution(Local spell checking).
-Use cvs commands such as commit, update etc. while editing.

Schema Browser
Compact, multi-tabbed Schema Browser allows you to quickly navigate and manage database objects
Has the follwing functionalities;
-Show tables, procedures, sequences, triggers and constraints exists in the Database currently
-Show table's data.
-Show tables', procedures', sequences', constraints' sql code.

SQL Modeler
SQL Modeler enables quick building of complex queries with an easy-to-use GUI
Has the follwing functionalities;
-Generate create, insert, update and select queries.
-Show performance of select queries in msec.
-Show indexes used in the existing query.

Server and session statistics
Server and session statistics, including calculated statistics and tuning hints, provide quick viewing of the server environment

Quest DBA Module
Quest DBA Module allows users to compare and synchronize database schemas, manage space, import/ export data and much more

Output Window
Output Window displaies the outputs of the database server.