摘要 |
A computer controlled user display interface with a tree that has a plurality of nodes to represent table records in relational databases, and the parent-child arrangements between those nodes to represent relationships between the table records. The nodes can either represent one record or a list of records from a table. A user can select the expand icon in front of a node representing one record to display all its related records as sub-nodes of this node. The related records are defined either by foreign key constraints or user-defined table relationships. The system also includes an implementation to generate search queries dynamically based on the table relationships. A preferred display layout will also include a grid next to the tree to display the table records with complete data for all columns when a user selects a tree node. In this manner, the user can execute a search query to populate the tree with initial set of table records, and then keep expanding the nodes to browse all the related table records.
|