Relational database drill-down convention and reporting tool

• US 6,993,533 B1
• Filed: 03/25/2002
• Issued: 01/31/2006
• Est. Priority Date: 03/25/2002
• Status: Active Grant

• Current Assignee: BIF Technologies Corp.
• Original Assignee: BIF Technologies Corp.
• Inventors: Barnes, Roderick Leon
• Primary Examiner(s): Wassum, Luke S
• Assistant Examiner(s): Black, Linh
• Application Number:
  US10/063,145
• Time in Patent Office: 1,408 Days
• Field of Search: 707 1-1041
• US Class Current: 1/1
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A system generates linked sets of drill-down-enabled reports of increasing levels of detail from one or more databases. Linking relationships between reports are defined using the query language of the databases. Result sets are obtained that includes (1) the sought-after data, and (2) metadata that identifies drill-down reports to be generated if related report elements are selected. When the query is executed, the system passes the sought-after data to a reporting application programming interface, which generates a report (e.g., a pie chart, 3-D bar chart, cross-tabbed table). If an end-user selects one of the report elements (e.g., a bar on the chart), the system maps the reported event to the associated data of the result set. If the associated data has corresponding meta-data containing a drill-down directive, the system then generates the report identified by the drill-down directive.

Claims

1. A computer implemented method to provide linked first and second reports to a user, the second report being provided in response to the user'"'"'s selection of an element of a first report, the method comprising the actions of:

retrieve a first object that defines characteristics of the first report, the first object including a first query language instruction operable to retrieve a first data set from a database, the first query language instruction also including a linking instruction that specifies a linking relationship between at least a portion of the first data set and the second report, the first object further specifying a first report template to which the first data set is operable to be bound;

retrieve the first data set in response to the first query language instruction;

bind at least a portion of the first data set to the first report template;

publish the first report;

wait for the user to select an element of the first report;

if the user selects an element of the first report, map the user'"'"'s selection to a corresponding portion of the first data set;

if the linking instruction specifies a linking relationship between the second report and the portion of the first data set corresponding to the user'"'"'s selection, then

retrieve a second object that defines characteristics of the second report, the second object including a second query language instruction operable to retrieve a second data set from said database or another database, the second object further specifying a second report template to which the second data set is operable to be bound;

retrieve the second data set in response to the second query language instruction;

bind the second data set to the second report template; and

publish the second report.

2. The method of claim 1, where the linking instruction also includes a parameter to pass to the second object and to modify the second query language instruction therein, the method further comprising the following action if the action of retrieving the second object is performed:

translate the second query language instruction to incorporate the parameter passed by the linking instruction.

3. A reporting apparatus for a database comprising:

a computer;

a plurality of report pattern objects residing on the computer, each object defining characteristics of a report, including a query language statement operable to retrieve a result set from the database;

a data retrieving module operable to retrieve the result set specified by the query language statement;

a result set handling module operable to identify drill-down-report a linking identifier in the result set; and

an event handling module operable to retrieve, in response to user requests, report pattern objects corresponding to drill-down reports specified in the linking identifier of the result set.

4. The reporting apparatus of claim 3, further comprising an editing module operable to enable the editing of the report pattern objects.

5. The reporting apparatus of claim 3, further comprising a translating module operable to incorporate parameters passed by the event handling module into the query language expressions of report pattern objects retrieved in response to user requests for drill-down reports.

6. The reporting apparatus of claim 3, further comprising a reporting module operable to generate report code corresponding to the result set on a user interface.

7. The reporting apparatus of claim 6, further comprising a presentation handler operable to display reports in accordance with the report code generated by the reporting module.

8. The reporting apparatus of claim 3, wherein the data retrieving module comprises at least a portion of a relational database management system.