Patent US1530552A successfully refreshed from Google Patents.
Patent EP0432929A2 successfully refreshed from Google Patents.
Patent US4517561A successfully refreshed from Google Patents.
Patent US5603025A successfully refreshed from Google Patents.
US5603025A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Methods for hypertext reporting in a relational database management system
Assignee: Borland Software Corp
•
Filing: 1994-07-29
•
Granted: 1997-02-11
•
Expires: 2014-07-29
Abstract
Abstract A system of the present invention includes a relational database management system (RDBMS) having a hypertext report writing module. Methods are described for automatically recognizing relations between reports which are generated from the same or related database tables. The system automatically embeds (or assists the user in embedding) appropriate hypertext links so that information from one report may be cross-referenced immediately with information in another, related report. Drill-down hypertext reports of increasing level of detail are illustrated. In addition to drill-down reports, the system may create comprehensive hypertext reports for automatically tying together information which is related through underlying table relations but which ordinarily appears in different reports. By automatically placing hypertext links or cross-indexes between reports, the system ties together relatable information into a single, cross-indexed hypertext report.
Inventors
- 👤 Lloyd Tabb
- 👤 Conrad Herrmann
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-25 10:43
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/90; G06F16/93; G06F16/94; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/953; Y10S707/954; Y10S707/99931; Y10S707/99932; Y10S707/99941; Y10S707/99943
Claims Analysis
Total Claims: 46
Claim 1
Independent Claim
270 words
In a computer system, a method for generating a hypertext report, the method comprising: receiving input specifying a first report, said first report being based on information taken from a first subset of a set of relational database tables, said set of relational database tables including records that provide access to stored information; said first report being a design document separate from said set of relational database tables and specifying display of a plurality of information items associated with records in said first subset of tables, said information items being differentiated by being associated with records having different values of a particular field in said first subset of tables; receiving input specifying a second report, said second report being based on information taken from a second subset of said set of relational database tables, said second report being a design document separate from said set of relational database tables and specifying display of information associated with records in said second subset of tables; combing the information items from said first report and the information from said second report into the hypertext report; and if information in said first report is relatable to information in said second report by virtue of at least one of said second subset of tables having the particular field, generating at least one hypertext link and placing said at least one hypertext link in the hypertext report for cross-referencing relatable information in the two reports, the hypertext report, when displayed to a user, allowing the user to navigate between related information at different locations in the hypertext report by invoking said at least one hypertext link.
Claim 2
Dependent Claim
270 words
In a computer system, a method for generating a hypertext report, the method comprising: receiving input specifying a first report, said first report being based on information taken from a first subset of a set of relational database tables, said set of relational database tables including records that provide access to stored information; said first report being a design document separate from said set of relational database tables and specifying display of a plurality of information items associated with records in said first subset of tables, said information items being differentiated by being associated with records having different values of a particular field in said first subset of tables; receiving input specifying a second report, said second report being based on information taken from a second subset of said set of relational database tables, said second report being a design document separate from said set of relational database tables and specifying display of information associated with records in said second subset of tables; combing the information items from said first report and the information from said second report into the hypertext report; and if information in said first report is relatable to information in said second report by virtue of at least one of said second subset of tables having the particular field, generating at least one hypertext link and placing said at least one hypertext link in the hypertext report for cross-referencing relatable information in the two reports, the hypertext report, when displayed to a user, allowing the user to navigate between related information at different locations in the hypertext report by invoking said at least one hypertext link.
Claim 3
Dependent Claim
16 words
The method of claim 1, wherein at least one of said reports includes a one-to-many relation.
Claim 4
Dependent Claim
16 words
The method of claim 1, wherein at least one of said reports includes a many-to-one relation.
Claim 5
Dependent Claim
16 words
The method of claim 1, where at least one of said reports includes a one-to-one relation.
Claim 6
Dependent Claim
44 words
The method of claim 1, wherein at least one of said reports includes a grouping of information based on a unique index, said grouping including at least one group header serving as a hypertext jump destination based on the value of its unique index.
Claim 7
Dependent Claim
40 words
The method of claim 1, wherein at least one report includes a grouping of information based on an index which is not unique, said grouping including a single group header having a jump destination based on the non-unique index value.
Claim 8
Dependent Claim
21 words
The method of claim 6, wherein members of the grouping which are not unique are placed into a hypertext browse sequence.
Claim 9
Dependent Claim
41 words
The method of claim 1, wherein at least one report includes a detail band ordered by a unique index, so that any other band in the hypertext report can contain a link object for accessing the detail band of the report.
Claim 10
Dependent Claim
19 words
The method of claim 8, wherein said link object is synthesized by the system based on a unique identifier.
Claim 11
Dependent Claim
23 words
The method of claim 9, wherein said unique identifier is based on a report name and a key value of the unique index.
Claim 12
Dependent Claim
42 words
The method of claim 1, wherein at least one of said reports includes a grouping of information based on a grouping expression which is a unique index, the grouping of information being associated with a topic expression which is a unique identifier.
Claim 13
Dependent Claim
23 words
The method of claim 11, wherein said unique identifier is based on a report name and a key value of the unique index.
Claim 14
Independent Claim
255 words
A method for creating hypertext reports in a relational database management system, the method comprising: receiving input specifying a first report of database information, said first report being based on information from a first subset of a set of relational database tables, said set of database tables including records being provide access to stored information, said first report being separate from said set of relational database tables and specifying display of information associated with records in said first subset of tables; receiving input specifying a second report of database information, said second report being separate from said set of relational database tables and being based on information taken from a second subset of said set of relational database tables, said second report specifying display of information associated with records in said second subset of tables; combining the information from said first report and the information from said second report into the hypertext report; determining whether information of the first report can be linked to information of the second report by virtue of at least one common field between said first and second subsets of table; and if information of the first report can be linked to information of the second report, generating a hypertext link and placing said hypertext link in the hypertext report for cross-referencing information in the second report to information in the first report, the hypertext report, when displayed to a user, allowing the user to navigate between related information at different locations in the hypertext report by invoking said hypertext link.
Claim 15
Independent Claim
255 words
A method for creating hypertext reports in a relational database management system, the method comprising: receiving input specifying a first report of database information, said first report being based on information from a first subset of a set of relational database tables, said set of database tables including records being provide access to stored information, said first report being separate from said set of relational database tables and specifying display of information associated with records in said first subset of tables; receiving input specifying a second report of database information, said second report being separate from said set of relational database tables and being based on information taken from a second subset of said set of relational database tables, said second report specifying display of information associated with records in said second subset of tables; combining the information from said first report and the information from said second report into the hypertext report; determining whether information of the first report can be linked to information of the second report by virtue of at least one common field between said first and second subsets of table; and if information of the first report can be linked to information of the second report, generating a hypertext link and placing said hypertext link in the hypertext report for cross-referencing information in the second report to information in the first report, the hypertext report, when displayed to a user, allowing the user to navigate between related information at different locations in the hypertext report by invoking said hypertext link.
Claim 16
Dependent Claim
30 words
The method of claim 13, wherein said step of generating a hypertext link includes generating a unique topic identifier for identifying the information of the second report as a topic.
Claim 17
Dependent Claim
29 words
The method of claim 14, wherein the unique topic identifier is based on a name of the second report and a value taken from information of the second report.
Claim 18
Dependent Claim
26 words
The method of claim 14, wherein said step of generating a hypertext link further includes generating a hypertext jump to said topic of the second report.
Claim 19
Dependent Claim
16 words
The method of claim 13, wherein at least one of the reports includes a one-to-many relation.
Claim 20
Dependent Claim
16 words
The method of claim 13, wherein at least one of the reports includes a many-to-one relation.
Claim 21
Dependent Claim
16 words
The method of claim 13, wherein at least one of the reports includes a one-to-one relation.
Claim 22
Dependent Claim
27 words
The method of claim 13, wherein said step of determining includes: determining whether information of the first report can be related to information of the second report.
Claim 23
Dependent Claim
30 words
The method of claim 20, wherein said step of determining includes: determining whether a foreign key relation exists between information of the first report and information of the second report.
Claim 24
Dependent Claim
186 words
A hypertext report system comprising: input means for specifying a first report of relational database information from a set of relational database tables and a second report of relational database information from the set of relational database tables, said set of relational database tables including records that provide access to stored information, each of said reports representing the relational database information but being separate from the relational database tables; means for combining said first and second reports into the hypertext report; comparison means for determining whether information of the first report can be linked to information of the second report by virtue of at least one common field between tables in said first and second reports; and means for generating a hypertext link and placing said hypertext link in the hypertext report for cross-referencing information in the second report to information in the first report if information of the-first report can be linked to information of the second report, the hypertext report, when displayed to a user, allowing the user to navigate between related information at different locations in the report by invoking said hypertext link.
Claim 25
Dependent Claim
186 words
A hypertext report system comprising: input means for specifying a first report of relational database information from a set of relational database tables and a second report of relational database information from the set of relational database tables, said set of relational database tables including records that provide access to stored information, each of said reports representing the relational database information but being separate from the relational database tables; means for combining said first and second reports into the hypertext report; comparison means for determining whether information of the first report can be linked to information of the second report by virtue of at least one common field between tables in said first and second reports; and means for generating a hypertext link and placing said hypertext link in the hypertext report for cross-referencing information in the second report to information in the first report if information of the-first report can be linked to information of the second report, the hypertext report, when displayed to a user, allowing the user to navigate between related information at different locations in the report by invoking said hypertext link.
Claim 26
Dependent Claim
36 words
The system of claim 22, wherein the hypertext link comprises a unique topic identifier for identifying the information of the second report as a topic and a hypertext jump for jumping to the unique topic identifier.
Claim 27
Dependent Claim
28 words
The system of claim 22, wherein the comparison means includes means for determining whether information of the first report can be related to information of the second report.
Claim 28
Dependent Claim
32 words
The system of claim 24, wherein the comparison means further includes means for determining whether a foreign key relation exists between information of the first report and information of the second report.
Claim 29
Independent Claim
313 words
A method of presenting information from a plurality of reports based on, but separate from, a set of tables in a relational database system wherein each table includes a number of records, each record having a number of fields for storing information, said plurality of reports includes first and second reports containing information derived from respective first and second subsets of said set of tables, and each respective subset of tables has a structure defined by fields in common between pairs of tables in the respective subset, the method comprising: determining a particular field in said first subset of tables that corresponds to a field in said second subset of tables; combining said plurality of reports into a hypertext report that is separate form said set of tables; generating hypertext links and placing said hypertext links in portions of said hypertext report that correspond to said first report, which hypertext links specify said second report and respective values for the particular field; displaying a portion of said hypertext report corresponding to at least a portion of said first report with information based on records in said first subset of tables, the displayed information being correlated with the particular field, at least a portion of the displayed information for each record denoting a respective one of said hypertext links; and in response to user input specifying a given hypertext link in said hypertext report corresponding to a given value of the particular field, displaying a portion of said hypertext report corresponding to at least a portion of said second report with information based on records in said second subset of tables, the displayed information for said second report being correlated with records having the given value of the particular field, the hypertext report thus allowing the user to navigate between related information at different locations in the hypertext report by invoking said hypertext links.
Claim 30
Independent Claim
313 words
A method of presenting information from a plurality of reports based on, but separate from, a set of tables in a relational database system wherein each table includes a number of records, each record having a number of fields for storing information, said plurality of reports includes first and second reports containing information derived from respective first and second subsets of said set of tables, and each respective subset of tables has a structure defined by fields in common between pairs of tables in the respective subset, the method comprising: determining a particular field in said first subset of tables that corresponds to a field in said second subset of tables; combining said plurality of reports into a hypertext report that is separate form said set of tables; generating hypertext links and placing said hypertext links in portions of said hypertext report that correspond to said first report, which hypertext links specify said second report and respective values for the particular field; displaying a portion of said hypertext report corresponding to at least a portion of said first report with information based on records in said first subset of tables, the displayed information being correlated with the particular field, at least a portion of the displayed information for each record denoting a respective one of said hypertext links; and in response to user input specifying a given hypertext link in said hypertext report corresponding to a given value of the particular field, displaying a portion of said hypertext report corresponding to at least a portion of said second report with information based on records in said second subset of tables, the displayed information for said second report being correlated with records having the given value of the particular field, the hypertext report thus allowing the user to navigate between related information at different locations in the hypertext report by invoking said hypertext links.
Claim 31
Dependent Claim
189 words
The method of claim 26 wherein said plurality of reports includes a third report containing information derived from a third subset of tables, and the method further comprises: determining a further particular field in said second subset of tables that corresponds to a field in said third subset of tables; generating additional hypertext links and placing said hypertext links in portions of said hypertext report that correspond to said second report, which hypertext links specify said third report and values for the further particular field; in connection with said step of displaying said second report, displaying at least a portion of the displayed information correlated with each record with an indication denoting a respective one of said additional hypertext links; and in response to user input specifying a given additional hypertext link in said hypertext report corresponding to a given value of the further particular field displaying a portion of said hypertext report corresponding to said third report with information based on records in said third subset of tables, the displayed information for said third report being correlated with records having the given value of the further particular field.
Claim 32
Dependent Claim
28 words
The method of claim 26 wherein said first and second subsets of tables have at least one table in common, said table in common including said particular field.
Claim 33
Dependent Claim
22 words
The method of claim 26 wherein said information displayed in said first report includes information derived from records in a single table.
Claim 34
Dependent Claim
26 words
The method of claim 26 wherein each of said first and second subsets has at least one table linked to another table in a one-to-many relationship.
Claim 35
Dependent Claim
34 words
The method of claim 26 wherein at least one of said first and second subsets has at least one table that is not a table of the other of said first and second subsets.
Claim 36
Independent Claim
208 words
A method of presenting information based on a set of tables, in a relational database system wherein each table includes a number of records, each record having a number of fields, the method comprising: providing a first report containing information based on records in a first subset of tables, including information that is correlated with a particular field in said first subset of tables; providing a second report containing information based on records in a second subset of tables, including information that is correlated with said particular field; combining said first and second reports into a hypertext report document that is separate from aid set of tables; establishing respective hypertext links and placing said hypertext links in said hypertext reports for portions of information in said first report that correlate with respective given values of the particular field, said hypertext link for a given portion of information in said first report specifying a portion of information of said second report that is characterized by records in said second subset of tables having the value of said particular field in said given such record, the hypertext report, when displayed, allowing the user to navigate between related information at different locations in the hypertext report by invoking said hypertext links.
Claim 37
Independent Claim
208 words
A method of presenting information based on a set of tables, in a relational database system wherein each table includes a number of records, each record having a number of fields, the method comprising: providing a first report containing information based on records in a first subset of tables, including information that is correlated with a particular field in said first subset of tables; providing a second report containing information based on records in a second subset of tables, including information that is correlated with said particular field; combining said first and second reports into a hypertext report document that is separate from aid set of tables; establishing respective hypertext links and placing said hypertext links in said hypertext reports for portions of information in said first report that correlate with respective given values of the particular field, said hypertext link for a given portion of information in said first report specifying a portion of information of said second report that is characterized by records in said second subset of tables having the value of said particular field in said given such record, the hypertext report, when displayed, allowing the user to navigate between related information at different locations in the hypertext report by invoking said hypertext links.
Claim 38
Dependent Claim
28 words
The method of claim 32 wherein said first and second subsets of tables have at least one table in common, said table in common including said particular field.
Claim 39
Dependent Claim
22 words
The method of claim 32 wherein said information displayed in said first report includes information derived from records in a single table.
Claim 40
Dependent Claim
26 words
The method of claim 32 wherein each of said first and second subsets has at least one table linked to another table in a one-to-many relationship.
Claim 41
Dependent Claim
34 words
The method of claim 32 wherein at least one of said first and second subsets has at least one table that is not a table of the other of said first and second subsets.
Claim 42
Independent Claim
289 words
A method of presenting information from a plurality of reports based on, but separate from, a set of tables in a relational database system wherein each table includes a number of records, each record having a number of fields, and said plurality of reports includes first and second reports containing information derived from respective first and second subsets of said set of tables, the method comprising: determining a particular field in said first subset of tables, which particular field has key values that are at least partly matched by values in said second subset of tables; combining said plurality of reports into a hypertext report that is separate from said set of tables; generating hypertext links and placing said hypertext links in portions of said hypertext report that correspond to said first report, which hypertext links specify said second report and respective values for the particular field; displaying a portion of said hypertext report corresponding to at least a portion of said first report with information based on records in said first subset of tables, the displayed information including portions correlated with different values for the particular field; displaying in said first report an indication denoting said hypertext links; and in response to user input specifying a given hypertext link in said hypertext report corresponding to a given value of the particular field, displaying a portion of said hypertext report corresponding to said second report with information based on records in said second subset of tables, the displayed information for said second report being correlated with records having the given value of the particular field, the hypertext report thus allowing the user to navigate between related information at different locations in the hypertext report by invoking said hypertext links.
Claim 43
Independent Claim
289 words
A method of presenting information from a plurality of reports based on, but separate from, a set of tables in a relational database system wherein each table includes a number of records, each record having a number of fields, and said plurality of reports includes first and second reports containing information derived from respective first and second subsets of said set of tables, the method comprising: determining a particular field in said first subset of tables, which particular field has key values that are at least partly matched by values in said second subset of tables; combining said plurality of reports into a hypertext report that is separate from said set of tables; generating hypertext links and placing said hypertext links in portions of said hypertext report that correspond to said first report, which hypertext links specify said second report and respective values for the particular field; displaying a portion of said hypertext report corresponding to at least a portion of said first report with information based on records in said first subset of tables, the displayed information including portions correlated with different values for the particular field; displaying in said first report an indication denoting said hypertext links; and in response to user input specifying a given hypertext link in said hypertext report corresponding to a given value of the particular field, displaying a portion of said hypertext report corresponding to said second report with information based on records in said second subset of tables, the displayed information for said second report being correlated with records having the given value of the particular field, the hypertext report thus allowing the user to navigate between related information at different locations in the hypertext report by invoking said hypertext links.
Claim 44
Dependent Claim
185 words
The method of claim 37 wherein said plurality of reports includes a third report containing information derived from a third subset of tables, and the method further comprises: determining a further particular field in said second subset of tables, which further particular field has key values that are at least partly matched by values in said third subset of tables; generating additional hypertext links and placing said hypertext links in portions of said hypertext report that correspond to said second report, which hypertext links specify said third report and values for the further particular field; in connection with said step of displaying said second report, displaying in said second report an indication denoting said additional hypertext links; and in response to user input specifying an additional hypertext link in said hypertext report corresponding to a given value of the further particular field, displaying a portion of said hypertext report corresponding to said third report with information based on records in said third subset of tables, the displayed information for said third report being correlated with records having the given value of the further particular field.
Claim 45
Dependent Claim
28 words
The method of claim 37 wherein said first and second subsets of tables have at least one table in common, said table in common including said particular field.
Claim 46
Dependent Claim
22 words
The method of claim 37 wherein said information displayed in said first report includes information derived from records in a single table.
References Cited (Backward Citations)
US5133068A
Cited
US5412774A
Cited
US5428776A
Cited
US5263167A
Cited
US5408659A
Cited
US5333327A
Cited
US5423043A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2000-02-11 | 2000-08-12 | 2001-02-11 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2004-02-11 | 2004-08-12 | 2005-02-11 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2008-02-11 | 2008-08-12 | 2009-02-11 | $7700.00 | Window Closed / Lapsed |