Patent ID: 6879984
Filing Date: 2005-04-12
Classification: G06F,Y10S

Abstract:
1. A method for providing an analytical business report that is based on data including data from tables, each table including a plurality of rows and a plurality of columns, each of the plurality of columns corresponding to a data field, the method comprising: inverting said data such that said data fields are stored in separate files that include a row number field and data values corresponding to a single data field, wherein said files include at least a first file with a partition field and a second file with an analytical field; compressing at least one of said files, including files containing repeating data stored in successive rows; traversing said at least one of said compressed files while said compressed file is stored in memory to directly retrieve data stored in said compressed file without decompressing said compressed file; using said retrieved data to generate said analytical business report; processing said partition field by creating sub-rowsets of said partition field and by assigning said sub-rowsets of said partition field to a first set of servers, wherein said first set of servers identify unique partition values contained in said sub-rowsets; merging said unique partition values identified by said first set of servers; transmitting said merged partition values to a second set of servers; and processing said analytical field for said merged partition values by creating sub-rowsets of said analytical field and by assigning said sub-rowsets of said analytical field to said second set of servers.