System and method for accessing database design information

• US 20020161744A1
• Filed: 04/16/2002
• Published: 10/31/2002
• Est. Priority Date: 04/18/2001
• Status: Active Grant

• Current Assignee: CSG Systems Incorporated (CSG Systems International Incorporated)
• Original Assignee: CSG Systems Incorporated (CSG Systems International Incorporated)
• Inventors: Gluckman, Howard
• Granted Patent: US 6,996,574 B2
• Time in Patent Office: Days
• US Class Current: 707/1
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/9574 of access to content, e.g. by caching
• CPC Class Codes: Y10S 707/956 Hierarchical
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

Abstract

A system and method for accessing database design information stored in a database repository. To access the information, the system receives user input designating a workarea of the data repository as being of interest. Using the workarea designation, the system retrieves from the database repository a list of application systems associated with the workarea, a list of model details available for each application system, and a list of entities for each model detail. This retrieved information is displayed to the user using a tree-menu structure. Further design information can be accessed by the user designating an entity as being of interest. The system uses the entity designation to retrieve from the database repository design information for the designated entity which retrieved information is then displayed to the user.

Claims

1. A method for accessing database design information stored in a database repository, comprising:

receiving user input designating a workarea as being of interest;

using the workarea designation to retrieve from the database repository a list of application systems associated with the workarea, a list of model details available for each application system, and a list of entities for each model detail;

displaying the list of application systems, the list of model details available for each application system, and the list of entities for each model detail to the user using a tree-menu;

accepting input from the user designating an entity as being of interest;

using the entity designation to retrieve from the database repository design information for the designated entity; and

displaying the design information to the user.

2. The method as recited in claim 1, wherein the list of model details comprise logical model details.

3. The method as recited in claim 1, wherein the list of model details comprises physical model details.

4. The method as recited in claim 1, further comprising retrieving hierarchical information from the database repository regarding the designated entity and displaying the hierarchical information to the user.

5. The method as recited in claim 1, further comprising displaying to the user a link to a design figure in which the designated entity appears.

6. The method as recited in claim 1, wherein user input is received through a Web browser application.

7. The method as recited in claim 1, wherein the database repository comprises an Oracle database repository.

8. A computer-readable media having instructions for accessing database design information stored in a database repository, the computer-readable media performing steps comprising:

receiving user input designating a workarea as being of interest;

using the workarea designation to retrieve from the database repository a list of application systems associated with the workarea, a list of model details available for each application system, and a list of entities for each model detail;

displaying the list of application systems, the list of model details available for each application system, and the list of entities for each model detail to the user using a tree-menu;

accepting input from the user designating an entity as being of interest;

using the entity designation to retrieve from the database repository design information for the designated entity; and

displaying the design information to the user.

9. The readable-media as recited in claim 8, wherein the list of model details comprise logical model details.

10. The readable-media as recited in claim 8, wherein the list of model details comprise physical model details.

11. The readable-media as recited in claim 8, wherein the instructions further perform the steps of retrieving hierarchical information from the database repository regarding the designated entity and displaying the hierarchical information to the user.

12. The readable-media as recited in claim 8, wherein the instructions further perform the step of displaying to the user a link to a design figure in which the designated entity appears.

13. The readable-media as recited in claim 8, wherein the database repository comprises an Oracle database repository.

15. The method as recited in claim 14, further comprising using permission grants to determine workareas to display in the list of workareas.

16. The method as recited in claim 15, further comprising using permission grants to determine application systems to display in the list of application systems.

14. A method for accessing database design information stored in a database repository, comprising:

receiving user input designating a repository as being of interest;

using the respository designation to display to the user a list of workareas within the repository;

receiving user input designating a workarea as being of interest;

using the workarea designation to retrieve from the database repository a list of application systems associated with the workarea, a list of model details available for each application system, and a list of entities for each model detail;

displaying the list of application systems, the list of model details available for each application system, and the list of entities for each model detail to the user using a tree-menu;

accepting input from the user designating an entity as being of interest;

using the entity designation to retrieve from the database repository design information for the designated entity; and

displaying the design information to the user.