Relationship perspective – tree view

Relationship tree view provides a better way to visualize multi-level data relationships. You can switch to the perspective using the toolbar button or “Window” menu.

Double-click any table, view or synonym node to create and execute a query. The query result records are displayed in the “Relationship Tree View” as top-level tree nodes. You can expand any tree-nodes to see its related records, or click any node to display the corresponding data in the bottom grid.

The above screen shot shows the query result contains two records in Customer table. Each customer table record has related PurchaseOrder records, which in turn has related Shipment, LineItem and OrderTaxInfo records.

If you implement an object-oriented program to retrieve these data, you will find that the table relationships are matched nicely to object-relationships. This is because that for a well-designed relational schema supporting object-oriented applications, the object-relationships are always reflected in the foreign key references among the objects mapping tables.

SQL Edge® not only allows you to see individual database records by executing SQL queries, but also provides a powerful way to visualize the data relationship. It is a must-have database query tool for developers writing object-oriented applications that access relational databases.