Enhanced user view/update capability for managing data from relational tables

• US 6,058,391 A
• Filed: 12/17/1997
• Issued: 05/02/2000
• Est. Priority Date: 12/17/1997
• Status: Expired due to Term

• Current Assignee: Verizon Patent and Licensing Incorporated (Verizon Communications Inc.)
• Original Assignee: MCI Communications Corporation (Verizon Communications Inc.)
• Inventors: Gardner, Jonathan
• Primary Examiner(s): Choules, Jack M.
• Assistant Examiner(s): ALAM, SHAHID AL
• Application Number:
  US08/992,048
• Time in Patent Office: 867 Days
• Field of Search: 707/1-3, 707/8, 707/103, 707/200, 707/4, 707/10, 707/100, 707/102, 705/26
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system and method for creating customizable views of a database so that database users may view and update tables in a manner that requires no knowledge of the underlying database schema or of the database commands. The system includes a view database and a view/update utility. The view database includes database tables for associating a relational table with a particular view and for associating one or more fields of the relational table with the view. The view/update utility utilizes the view database in performing the processes of creating, displaying, and updating views.

Claims

1. A system for creating views of data stored in a relational database, comprising:

a view database for storing one or more views; and

a view utility;

said view utility having access to said view database and the relational database;

wherein said view utility comprises;

a graphical user interface for enabling the user to interact with said view utility;

view creation window for creating one or more views, wherein a user inputs data to be displayed by the one or more views in fields of said window; and

storing means for storing said one or more views in said view database.

2. The system of claim 1, wherein said view database includes assigning means for assigning the user to a set of views, wherein the user will have access only to said set of assigned views.

3. The system of claim 2, wherein said view utility further comprises:

selecting means for enabling the user to select a view from among only said set of assigned views; and

retrieving means for retrieving data from the relational database corresponding to said selected view.

4. The system of claim 3, wherein said selecting means includes a graphical user interface window for displaying a list of view descriptions corresponding to said set of assigned views.

5. The system of claim 3, wherein said retrieving means includes a database command generator for creating a database command to retrieve data from the relational database corresponding to said selected view.

6. The system of claim 1, wherein said view creation means includes a graphical user interface display screen for enabling said view utility to receive view information from an administrator, wherein said view information defines a view.

7. The system of claim 6, wherein said view information includes:

a name of a table within the relational database; and

a view name.

8. The system of claim 7, wherein said view information further includes a filter specification.

9. The system of claim 8, wherein said view information further includes a name of a field within said table and the attributes of said field.

10. The system of claim 9, wherein said attributes of said field include said field'"'"'s read-only status.

11. The system of claim 10, wherein said attributes of said field further include a lookup table, a lookup field, and a display field if said field is a look up field.

12. The system of claim 1, wherein said view database is a relational database.

13. The system of claim 12, wherein said view database comprises a table for linking a name of a table within the relational database with a view identifier.

14. The system of claim 12, wherein said view database comprises a table for linking a field of a table within the relational database with a view identifier.

15. The system of claim 12, wherein said view database comprises a table for linking a filter with a view identifier.

16. A method for creating a view of a relational database, comprising the steps of:

generating a view identifier to identify the view;

displaying a window requesting input of a table to associate with the view identifier;

receiving input of a table to associate with the view identifier;

associating said table within the relational database with said view identifier;

displaying a window requesting input of one or more fields in said table to associate with the view identifier;

receiving input of one or more fields of said table to associate with the view identifier;

associating one or more fields of said table with said view identifier;

determining which of said fields are lookup fields; and

for each of said lookup fields, associating a corresponding lookup table, lookup field and display field with said lookup field.

17. The method of claim 16, further comprising the step of associating a filter with said view identifier.

18. The method of claim 16, further comprising the step of associating a read-only status with each of said one or more fields associated with said view identifier.

19. In a system having a view database that stores a plurality of views, a method for enabling a user unfamiliar with relational database commands to display data that is stored in a relational database, comprising the steps of:

determining which of the plurality of views are assigned to the user;

displaying a list of view descriptions corresponding to said views assigned to the user;

waiting for the user to select a view description from among said list of displayed view descriptions;

creating a database command corresponding to said selected view description; and

executing said command.