Data processing: database and file management or data structures – Database design – Data structure types
Patent
1997-04-30
1998-08-11
Black, Thomas G.
Data processing: database and file management or data structures
Database design
Data structure types
707 3, 707 4, 707 7, G06F 1500
Patent
active
057942463
ABSTRACT:
A method of performing incremental aggregation of dynamically increasing database data sets. An embodiment of the present invention operates within a data mart or data warehouse to aggregate data stored within an operational database corresponding to newly received data to provide current information. Initially, a computer server creates an intermediate file which is initialized by the server with an aggregate data set. The aggregate data set consists of data values and count values that each correspond to specific group identifiers. The computer determines if any group identifiers within a new set of inputs data are identical to any group identifiers stored within the intermediate file. If an inputted group identifier matches a stored group identifier, the inputted data value is aggregated with the stored data value and the count value corresponding to the specific stored group identifier is incremented by one. If an inputted group identifier does not match any of the stored group identifiers, the inputted group identifier and corresponding data value are stored within the intermediate file and a count value of one is appended to that specific group identifier. Once all the group identifiers within the new set of input data have been determined, the computer stores all the changes that were made to the intermediate file into the aggregate data set.
REFERENCES:
patent: 5455945 (1995-10-01), Vanderdrift
patent: 5511190 (1996-04-01), Sharma et al.
patent: 5519859 (1996-05-01), Grace
patent: 5537589 (1996-07-01), Dalal
patent: 5675785 (1997-10-01), Hall et al.
patent: 5713020 (1998-01-01), Reiter et al.
Nesamoney Diaz
Sankaran Mohan
Suresh Sankaran
Wong Mon
Black Thomas G.
Homere Jean R.
Informatica Corporation
LandOfFree
Method for incremental aggregation of dynamically increasing dat 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 incremental aggregation of dynamically increasing dat, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method for incremental aggregation of dynamically increasing dat will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-403987