Introduction

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 defined by foreign key constraints, which naturally mapped to object relationships.

SQL Edge® has six perspectives. The “Query Perspective” allows users run any SQL queries, while the “Schema perspective” displays table schema information.

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 entity relationship diagrams, and also allows users to define the master-detail relationships among those tables.

The “Execution Plan Perspective” shows the execution plan of a query so that users can optimize query performance.