System and method for accessing database design information

• US 6,996,574 B2
• Filed: 04/16/2002
• Issued: 02/07/2006
• Est. Priority Date: 04/18/2001
• Status: Expired due to Fees

• Current Assignee: CSG Systems Incorporated (CSG Systems International Incorporated)
• Original Assignee: CSG Systems Incorporated (CSG Systems International Incorporated)
• Inventors: Gluckman, Howard
• Primary Examiner(s): Wong, Leslie
• Application Number:
  US10/123,707
• Publication Number:
  US 20020161744A1
• Time in Patent Office: 1,393 Days
• Field of Search: 707 3- 5, 707/9, 707/10, 707/101, 707/102, 707/104.1, 707/201, 709/203, 709/219, 717/104
• US Class Current: 707/781
• 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 retrieved application system, and a list of entities for each retrieved model detail;

displaying in a tree-menu structure the list of retrieved application systems, the list of retrieved model details, and the list of retrieved entities wherein the retrieved entities are displayed under their corresponding retrieved model details and the retrieved model details are displayed under their corresponding retrieved application systems;

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.

17. The method as recited in claim 1, comprising displaying mandatory relationships within the tree-menu structure in a manner different from a manner in which optional relationships within the tree-menu structure are displayed.

18. The method as recited in claim 17, wherein mandatory relationships are displayed utilizing solid lines while optional relationships are displayed utilizing non-solid lines.

19. The method as recited in claim 1, comprising allowing a user to display a children or parent hierarchy for a designated entity.

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 retrieved application system, and a list of entities for each retrieved model detail;

displaying in a tree-menu structure the list of retrieved application systems, the list of retrieved model details, and the list of retrieved entities wherein the retrieved entities are displayed under their corresponding retrieved model details and the retrieved model details are displayed under their corresponding retrieved application systems;

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.

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 retireved application system, and a list of entities for each retrieved model detail;

displaying in a tree-menu structure the list of retrieved application systems, the list of retrieved model details, and the list of retrieved entities wherein the retrieved entities are displayed under their corresponding retrieved model details and the retrieved model details are displayed under their corresponding retrieved application systems;

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.

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.