Method and system for database browsing

摘要

A method of enabling browsing of database tables on a computer system includes providing a configuration file to identify database table characteristics and to develop a graphical user interface (GUI) in communication with a database. The method further includes displaying on the GUI a main screen including: a record as a row from a specified database table; a related database table name, the table name being related to the specified database table; and a detail as a value in a column from the specified database table for the record displayed. The method still further includes receiving a selection from the GUI of the table. The method also includes navigating to another main screen on the GUI in response to the selection from the GUI.

主权项

1. A method of enabling browsing of database tables on a computer system, the method comprising:
providing a configuration file by a database administrator without an end user supplied configuration to automatically identify database table characteristics and to automatically develop a graphical user interface (GUI) in communication with a database, wherein the GUI display is automatically built without application programming by the end user, wherein:
the database administrator is a person distinct from the end user;the configuration file defines a filter for displayed information;the filter passes a predetermined database table or detail; andthe configuration file includes data that is supplemental to metadata of the database, the data including a set of soft relationships; displaying on the GUI a main screen responsive to the configuration file, including:
a record as a row from the predetermined database table;a related database table name, the related database table name being related to the predetermined database table;a detail as a value in a column from the predetermined database table for the record displayed; andexternal hyperlinks, the external hyperlinks created from information in the configuration file and in the database wherein the external hyperlinks are extra-referential to an other database or an internet site; receiving a selection from the GUI of the table; and navigating to an other main screen on the GUI in response to the selection from the GUI.