Overview
Today, developers implementing object-oriented applications with relational database backend still using
traditional SQL query tools to access and analyze relational data. To debug an
issue, most often than not, an object and several of its related objects have
to be retrieved using several queries. It is a tedious task to create and
maintain these queries.
With SQL Edge®,
users can use only one query to retrieve data in a table, and then browse data
in all related tables. The relationships are retrieved from foreign key
constraints and can also be custom defined even between tables in different databases.
SQL Edge® has six perspectives.
The Query Perspective
allows users run any SQL statements or scripts.
The Schema Perspective
displays database schema information and allows users to create tables, views, synonyms and sequences. There are two relationship perspectives.
The Relationship Table View
displays data in the master-detail style.
The Relationship Tree View
displays master table records as top-level tree nodes.
The nodes can be expanded to reveal any level of related detail records. In
addition, clicking any node will display the corresponding data in a detail grid.
The
Model Perspective
displays tables and their relationships in ER-diagrams. It supports auto-layout, outline view, rulers, grid,
and multi-page print preview.
The
Execution Plan Perspective
displays the execution plan of a query.
The following summarizes SQL Edge's major features:
- Support Oracle, DB2, Microsoft SQL Server, Sybase, MySQL, PostgreSQL, MaxDB and any JDBC compatible databases.
- Support Windows, Linux and Mac OS X operating systems.
- Allow users to specify JDBC drivers at run-time, and provide wizards
to help setup JDBC connections. Easy to install, and easy to setup.
- SQL editor supports syntax highlighting and SQL statement formatting.
- SQL editor allows users to execute SQL statements and scripts asynchronously. Users can cancel the execution by click the "Cancel" button
or just close the SQL Editor.
- SQL editor supports Oracle PL/SQL, PostgreSQL PL/pgSQL, DB2, MySQL,
SQL Anywhere Watcom-SQL and Transact-SQL scripts.
- Query result window is editable if all the selected columns are from one table and include the primary key of the table.
- Schema perspective displays database schema information and allows users
to create tables, views, synonyms and sequences. For Oracle, DB2, Microsoft SQL Server, Sybase, MySQL and PostgreSQL databases, it also displays the script information of
views, synonyms, sequences, stored procedures, triggers and packages based on whether the database supports these objects.
- Relationship table view displays the related data in master-detail style, with master table data shown in the top grid,
and all related detail table data in a list of bottom grids.
- Relationship tree view displays the master table records as top-level tree nodes, and the related detail records as
child nodes. Click any of these tree nodes will display the corresponding record data in a detail grid.
- Allow users to insert, edit, and delete records in the master and detail grids of the relationship table view
and relationship tree view.
- Allow users to define master-detail relationships even between tables in different databases.
This enables the relationship table view and relationship tree view to display data relationships
between tables in different databases or without pre-defined foreign keys.
- Model perspective displays tables and their relationships in ER diagrams. It supports auto-layout, outline view, rulers,
grid and multi-page print preview. It also allows users to customize fonts and colors of diagram objects. The diagram can be saved in an XML file and shared
between different users, or exported to GIF, JPEG, SVG or PNG format image files.
- Execution plan perspective displays the execution plan of a query. It supports Oracle and PostgreSQL execution plans.
