Cross tab analysis and reporting method

Details Cross tab analysis and reporting method Cross tab analysis and reporting method

1996-12-24

1999-06-22

Fetting, Anton

Data processing: database and file management or data structures

Database design

Data structure types

G06F 1730

Patent

active

059152575

ABSTRACT:
A method of and apparatus for preparing and modifying cross-tabulation analysis and reporting utilizes a data structure for storing aggregate data, gathered or input from a stream of data records. The data structure stores the aggregates of the data values, so that as cross-tab reports are generated, access to the original stream of data records is not necessary. Preferably, a tree-type data structure is utilized. The tree-type data structure is arranged relative to a root. The root of the tree is the first node in the tree. It has no parent node and no sibling nodes. Directly related to the root of the tree are labels of a first level. Labels of a second level and then labels of succeeding levels may follow, as required. Each level includes multiple nodes corresponding to the arrangement of the data. Each node has an array of accompanying cell in which the aggregates of the data values are stored. As the cross-tab report is modified, the tree-type data structure is also correspondingly modified by either changing the pointers between levels and nodes or by rearranging the levels. The aggregate values are then updated accordingly. A cross-tree is also maintained with the same structure as the main tree except that the cross-tree does not include the side label levels or nodes. When the labels of the cross-tab report are rearranged or removed, preferably the data structure is modified in place. Alternatively, a separate data structure may be constructed from the original data structure.

REFERENCES:
patent: 5359724 (1994-10-01), Earle
patent: 5406477 (1995-04-01), Harhen
patent: 5442784 (1995-08-01), Powers et al.
patent: 5555354 (1996-09-01), Strasnick et al.
patent: 5604854 (1997-02-01), Glassey
Brio Technology, Inc., DataPivot, Version 1.0, Reference and User Guide, Palo Alto, California, 1991.
Brio Technology, Inc., DataPivot, Version 1.1, Reference and User Guide, Palo Alto, California, 1991, 1992.

Affiliated with

Also associated with

Rating

Cross tab analysis and reporting method does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Cross tab analysis and reporting method, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Cross tab analysis and reporting method will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-1715837