Process and apparatus for simplifying access to information stored in databases

• US 5,864,856 A
• Filed: 04/21/1995
• Issued: 01/26/1999
• Est. Priority Date: 04/21/1995
• Status: Expired due to Term

• Current Assignee: Actuate Corporation (Open Text Corporation)
• Original Assignee: Actuate Software Incorporated
• Inventors: Young, Carl
• Primary Examiner(s): Black, Thomas G.
• Assistant Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US08/426,788
• Time in Patent Office: 1,376 Days
• Field of Search: 395/600, 364/513, 707/100, 707/4, 707/9
• US Class Current: 707/740
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: Y10S 707/955 Object-oriented
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99939 Privileged access

Abstract

Simplified access to relational databases is achieved. The inherent relationships that exist between tables in a relational database are detected and a dictionary is constructed that contains attributes that defines the relationships that exist within the database. The attributes of the database contained within the dictionary are mapped to objects of the database so that a user can navigate the database without using a database programming language using menus created from the dictionary.

Claims

1. A data processing system for accessing a database comprising:

a central processing unit;

a user interface coupled to the central processing unit; and

a dictionary builder, coupled to the central processing unit, that scans the database, creates a dictionary containing attributes that define relationships between tables in the database, and couples the dictionary to the database;

wherein the tables include columns having column names, and wherein the dictionary builder includes a catalog analysis module that selects a table within the database, creates an ID key for each set of one or more columns in the table identified as a unique set, and creates a join key, referencing the selected table, in any other tables in the database having a set of columns with column names that match the column names of a set of columns of an ID key.

2. The data processing system of claim 1, wherein the dictionary builder includes a user customization module that interacts with the user interface to allow a user of the data processing system to view and edit the dictionary.

3. The data processing system of claim 2, wherein the dictionary builder includes a mapping module that creates a map index and a map column for each attribute contained in the dictionary.

4. The data processing system of claim 1, wherein the dictionary builder includes a user customization module that interacts with the user interface to allow a user of the data processing system to view and edit the dictionary.

5. The data processing system of claim 1, wherein the dictionary builder includes a mapping module that creates a map index and a map column for each attribute contained in the dictionary.

6. The data processing system of claim 1, further comprising a dictionary construction module that generates one of an item attribute and a list attribute for each join key created by the catalog analysis module.

7. The data processing system of claim 6, further comprising a mapping module that creates a map index and a map column for each item attribute and for each list attribute generated by the dictionary construction module.

8. A data processing system for accessing information contained within a database comprising:

means for scanning the information contained within the database;

means for creating a dictionary containing attributes that define relationships between tables in the database; and

means for coupling the dictionary to the database.

9. The data processing system of claim 8, wherein the information in the database is arranged in tables having columns with column names, and wherein the means for scanning includes:

means for selecting a table;

means for creating an ID key for each set of one or more columns of the selected table identified as a unique set; and

means for creating a join key, referencing the selected table, in any other tables within the database having a set of columns with column names that match the column names of columns of a set of columns corresponding to an ID key of the selected table.

10. The data processing system of claim 9, further comprising user interaction means for allowing a user of the data processing system to view and edit the dictionary.

11. The data processing system of claim 10, wherein the means for coupling includes means for mapping each attribute contained in the dictionary to an object of the database.

12. The data processing system of claim 11, further comprising means for building forms and menus from information contained in the dictionary.

13. The data processing system of claim 9, further comprising means for generating one of an item attribute and a list attribute for each join key created by the catalog analysis module.

14. The data processing system of claim 13, further comprising means for mapping each item attribute and each list attribute to an object of the database.

15. The data processing system of claim 8, further comprising user interaction means for allowing a user of the data processing system to view and edit the dictionary.

16. The data processing system of claim 8, wherein the means for coupling includes means for mapping each attribute contained in the dictionary to an object of the database.

17. The data processing system of claim 8, further comprising means for building forms and menus from information contained in the dictionary.

18. A method for accessing information contained within a database comprising the steps of:

scanning the information contained within the database;

creating a dictionary containing attributes that define relationships between tables in the database; and

coupling the dictionary to the database.

19. The method of claim 18, wherein the information in the database is arranged in tables having columns with column names, the method further comprising the steps of:

selecting a table;

creating an ID key for each set of one or more columns of the selected table identified as a unique set; and

creating a join key, referencing the selected table, in any other tables within the database having a set of columns with column names that match the column names of a set of columns corresponding to an ID key of the selected table.

20. The method of claim 19, further comprising the step of editing the dictionary.

21. The method of claim 20, further comprising the step of mapping each attribute contained in the dictionary to an object of the database.

22. The method of claim 21, further comprising a step of creating forms and menus from information contained within the dictionary.

23. The method of claim 19, further comprising a step of generating one of an item attribute and a list attribute for each join key.

24. The method of claim 23, further comprising a step of mapping each item attribute and each list attribute to an object of the database.

25. The method of claim 18, further comprising the step of editing the dictionary.

26. The method of claim 18, further comprising the step of mapping each attribute contained in the dictionary to an object of the database.

27. The method of claim 18, further comprising a step of creating forms and menus from information contained within the dictionary.

28. A dictionary builder for building a dictionary of, and connecting the dictionary to, a database having information arranged in tables, each of the tables having at least one column with a column name, the dictionary builder comprising:

a catalog analysis module that analyzes the information contained within the database and generates analysis results;

a dictionary construction module, coupled to the catalog analysis module, that generates the dictionary of the information contained in the database based on the analysis results created by the catalog analysis module; and

a mapping module, coupled to the dictionary construction module, that maps information contained in the dictionary to the database.

29. The dictionary builder of claim 28, wherein the catalog analysis module selects a table within the database, creates an ID key for each set of one or more columns in the table identified as a unique set, and creates a join key, referencing the selected table, in any other tables in the database having a set of columns with column names that match the column names of a set of columns of an ID key.

30. The dictionary builder of claim 29, wherein the dictionary construction module generates one of an item attribute and a list attribute for each join key created by the catalog analysis module.

31. The dictionary builder of claim 30, further comprising:

a user customization module that interacts with a user interface coupled to the database to allow viewing and editing of the dictionary.

32. The dictionary builder of claim 30, wherein the mapping module creates a map index and a map column for each item attribute and list attribute generated by the dictionary construction module.

33. The dictionary builder of claim 30, further comprising a form and menu module that creates forms and menus from information contained in the dictionary.