Method for online analytical processing (OLAP)

Details Method for online analytical processing (OLAP) Method for online analytical processing (OLAP)

2008-03-04

2008-03-04

Wong, Don (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

07340476

ABSTRACT:
Disclosed are a method and system for generating user-defined pivot views of data records contained in a database where, as depicted in FIG.2a, an underlying real facts table at first is extended by continuous index values (200) which provides a continuous numbering of the facts from ‘1’ to ‘x’ (x=20 in the present example). In the resulting pivot view shown in FIG.2b, in each cell (210) the indices of those facts are presented which sales value has to be summed-up in the corresponding cell. The pivot view is generated by means of a sequence vector. The underlying sequence vector for the pivot view in FIG.2bis depicted in FIG.2cand consists of two columns (260, 270), the left column (260) containing continuous numbers from again ‘1’ to ‘x’ and the right column (270) containing the mentioned index values (275) depicted in FIG.2ain an ordered arrangement that enables sequentially building-up the pivot view of FIG.2b.

REFERENCES:
patent: 5767854 (1998-06-01), Anwar
patent: 5787279 (1998-07-01), Rigoutsos
patent: 5875108 (1999-02-01), Hoffberg et al.
patent: 5978796 (1999-11-01), Malloy et al.
patent: 6003036 (1999-12-01), Martin
patent: 6049804 (2000-04-01), Burgess et al.
patent: 6334125 (2001-12-01), Johnson et al.
patent: 6427123 (2002-07-01), Sedlar
patent: 2002/0095421 (2002-07-01), Koskas

Affiliated with

Also associated with

Rating

Method for online analytical processing (OLAP) does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method for online analytical processing (OLAP), we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for online analytical processing (OLAP) will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2797797