US5864856A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Process and apparatus for simplifying access to information stored in databases
Assignee: Actuate Software Inc
•
Filing: 1995-04-21
•
Granted: 1999-01-26
•
Expires: 2015-04-21
Abstract
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.
Inventors
- 👤 Carl Young
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 16:11
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/955; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99939
Claims Analysis
Total Claims: 37
Claim 1
Independent Claim
139 words
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.
Claim 2
Dependent Claim
139 words
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.
Claim 3
Dependent Claim
37 words
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.
Claim 4
Dependent Claim
31 words
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.
Claim 5
Dependent Claim
37 words
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.
Claim 6
Dependent Claim
31 words
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.
Claim 7
Dependent Claim
34 words
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.
Claim 8
Dependent Claim
36 words
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.
Claim 9
Dependent Claim
45 words
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.
Claim 10
Dependent Claim
45 words
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.
Claim 11
Dependent Claim
104 words
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.
Claim 12
Dependent Claim
27 words
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.
Claim 13
Dependent Claim
28 words
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.
Claim 14
Dependent Claim
21 words
The data processing system of claim 11, further comprising means for building forms and menus from information contained in the dictionary.
Claim 15
Dependent Claim
31 words
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.
Claim 16
Dependent Claim
25 words
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.
Claim 17
Dependent Claim
27 words
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.
Claim 18
Dependent Claim
28 words
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.
Claim 19
Dependent Claim
21 words
The data processing system of claim 8, further comprising means for building forms and menus from information contained in the dictionary.
Claim 20
Independent Claim
40 words
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.
Claim 21
Independent Claim
40 words
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.
Claim 22
Dependent Claim
94 words
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.
Claim 23
Dependent Claim
13 words
The method of claim 19, further comprising the step of editing the dictionary.
Claim 24
Dependent Claim
23 words
The method of claim 20, further comprising the step of mapping each attribute contained in the dictionary to an object of the database.
Claim 25
Dependent Claim
20 words
The method of claim 21, further comprising a step of creating forms and menus from information contained within the dictionary.
Claim 26
Dependent Claim
24 words
The method of claim 19, further comprising a step of generating one of an item attribute and a list attribute for each join key.
Claim 27
Dependent Claim
24 words
The method of claim 23, further comprising a step of mapping each item attribute and each list attribute to an object of the database.
Claim 28
Dependent Claim
13 words
The method of claim 18, further comprising the step of editing the dictionary.
Claim 29
Dependent Claim
23 words
The method of claim 18, further comprising the step of mapping each attribute contained in the dictionary to an object of the database.
Claim 30
Dependent Claim
20 words
The method of claim 18, further comprising a step of creating forms and menus from information contained within the dictionary.
Claim 31
Dependent Claim
105 words
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.
Claim 32
Dependent Claim
105 words
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.
Claim 33
Dependent Claim
75 words
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.
Claim 34
Dependent Claim
31 words
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.
Claim 35
Dependent Claim
30 words
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.
Claim 36
Dependent Claim
31 words
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.
Claim 37
Dependent Claim
24 words
The dictionary builder of claim 30, further comprising a form and menu module that creates forms and menus from information contained in the dictionary.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-01-25 | 2002-07-27 | 2003-01-26 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-01-25 | 2006-07-27 | 2007-01-26 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-01-25 | 2010-07-27 | 2011-01-26 | $7700.00 | Window Closed / Lapsed |