Methods for hypertext reporting in a relational database management system

• US 5,603,025 A
• Filed: 07/29/1994
• Issued: 02/11/1997
• Est. Priority Date: 07/29/1994
• Status: Expired due to Term

• Current Assignee: Borland Software Corporation (Open Text Corporation)
• Original Assignee: Borland International, Inc. (Open Text Corporation)
• Inventors: Tabb, Lloyd, Herrmann, Conrad
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/283,127
• Time in Patent Office: 928 Days
• Field of Search: 395/600, 395/602
• US Class Current: 1/1
• CPC Class Codes: G06F 16/284 Relational databases
• CPC Class Codes: G06F 16/94 Hypermedia Hyperlinking G06F40/134
• CPC Class Codes: Y10S 707/954 Relational
• CPC Class Codes: Y10S 707/99932 Access augmentation or optimizing
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface

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.

Claims

1. 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.

2. The method of claim 1, wherein at least one of said reports includes a one-to-many relation.

3. The method of claim 1, wherein at least one of said reports includes a many-to-one relation.

4. The method of claim 1, where at least one of said reports includes a one-to-one relation.

5. 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.

6. 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.

7. The method of claim 6, wherein members of the grouping which are not unique are placed into a hypertext browse sequence.

8. 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.

9. The method of claim 8, wherein said link object is synthesized by the system based on a unique identifier.

10. The method of claim 9, wherein said unique identifier is based on a report name and a key value of the unique index.

11. 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.

12. The method of claim 11, wherein said unique identifier is based on a report name and a key value of the unique index.

13. 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.

14. 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.

15. 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.

16. 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.

17. The method of claim 13, wherein at least one of the reports includes a one-to-many relation.

18. The method of claim 13, wherein at least one of the reports includes a many-to-one relation.

19. The method of claim 13, wherein at least one of the reports includes a one-to-one relation.

20. 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.

21. 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.

22. 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.

23. 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.

24. 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.

25. 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.

26. 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.

27. 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.

28. 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.

29. The method of claim 26 wherein said information displayed in said first report includes information derived from records in a single table.

30. 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.

31. 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.

32. 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.

33. 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.

34. The method of claim 32 wherein said information displayed in said first report includes information derived from records in a single table.

35. 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.

36. 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.

37. 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.

38. 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.

39. 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.

40. The method of claim 37 wherein said information displayed in said first report includes information derived from records in a single table.