Methods for hypertext reporting in a relational database management system

• US 5,787,416 A
• Filed: 02/06/1997
• Issued: 07/28/1998
• Est. Priority Date: 07/29/1994
• Status: Expired due to Fees

• Current Assignee: Borland Software Corporation (Open Text Corporation)
• Original Assignee: Borland International, Inc. (Open Text Corporation)
• Inventors: Herrmann, Conrad, Tabb, Lloyd
• Primary Examiner(s): AMSBURY, WAYNE P
• Application Number:
  US08/796,671
• Time in Patent Office: 537 Days
• Field of Search: 395/61, 707/2, 707/102
• US Class Current: 707/738
• 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 publishing database information to a hypertext database report, the method comprising:

(a) receiving first input specifying information taken from a first set comprising at least one database table;

(b) receiving second input specifying information taken from a second set comprising at least one database table; and

(c) if information is relatable between said first and second sets, publishing database information to a hypertext database report by generating a hypertext report having at least one hypertext link for cross-referencing relatable information in the two sets, such that user invocation of said at least one hypertext link invokes display of cross-referenced relatable information.

2. The method of claim 1, wherein information of said first and second sets is relatable as a one-to-many relation.

3. The method of claim 1, wherein information of said first and second sets is relatable as a many-to-one relation.

4. The method of claim 1, wherein information of said first and second sets is relatable as a one-to-one relation.

5. The method of claim 1, wherein said report 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 said 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 said 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 said report 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 of information stored in a database management system, the method comprising:

(a) receiving input specifying a first set of database information;

(b) receiving input specifying a second set of database information;

(c) determining whether information of the second set can be linked through a foreign key to information of the first set; and

(d) if information of the first set can be linked to information of the second set, generating a hypertext report including at least one hypertext link for cross-referencing in the hypertext report information from the second set to that of the first set, such that user selection of said at least one hypertext link, while viewing display of information of the first set invokes display of hypertext report information from the second set which is cross-referenced to that of the first set.

14. The method of claim 13, wherein step (d) includes generating a unique topic identifier for identifying the information of the first set as a topic.

15. The method of claim 14, wherein the unique topic identifier is based on a name of the first set and a value taken from information of the first set.

16. The method of claim 14, wherein step (d) further includes generating a hypertext jump to said topic of the first set.

17. The method of claim 13, wherein said first and second sets define a one-to-many relation.

18. The method of claim 13, wherein said first and second sets define a many-to-one relation.

19. The method of claim 13, wherein said first and second sets define a one-to-one relation.

20. The method of claim 13, wherein step (c) includes:

automatically determining by the system whether information of the second set can be related to information of the first set.

21. The method of claim 20, wherein step (c) includes:

determining whether a foreign key relation exists between information of the second set and information of the first set.

22. A hypertext report system comprising:

(a) input means for specifying first and second sets of database information, each set comprising at least one database table, each database table having at least one database column;

(b) comparison means for determining whether information of the second set can be linked to information of the first set, through one or more database columns; and

(c) means for generating a hypertext document which cross-references information in the second set to information in the first set by providing at least a hypertext link for information of the first set which can be linked to information of the second set, such that user selection of said at least one hypertext link while viewing display of information of the first set invokes display of hypertext report information from the second set which is cross-referenced to that of the first set.

23. The system of claim 22, wherein the hypertext link comprises a unique topic identifier for identifying the information of the first set 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 second set can be related to information of the first set.

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 second set and information of the first set.