Eva Lam Tse

US Patent:

6850952, Feb 1, 2005

Filed:

Aug 28, 2001

Appl. No.:

09/939560

Inventors:

Eva Man-Yan Tse - Sunnyvale CA, US
Michael Dean Lore - Katy TX, US
James Daniel Attaway - Katy TX, US

Assignee:

Computer Associates Think, Inc. - Islandia NY

International Classification:

G06F 1730

US Classification:

707102, 707 10, 707101, 707103, 707104

Abstract:

A method of populating multiple data marts in a single operation from a set of transactional data held in a database in a single aggregation process, in which aggregate values are calculated only once, a determination is made as to which output data marts required the aggregate value, and the aggregate values are output to the appropriate data marts. Dimension data associated with the output aggregate records is also output to the appropriate data marts.

US Patent:

6895471, May 17, 2005

Filed:

Aug 22, 2000

Appl. No.:

09/644280

Inventors:

Eva Man-Yan Tse - Sunnyvale CA, US
Pinaki Mukhopadhyay - Cupertino CA, US
Sumitro Samaddar - Cupertino CA, US

Assignee:

Informatica Corporation - Redwood City CA

International Classification:

G06F012/08
G06F017/30

US Classification:

711118, 711141, 707 8, 707201

Abstract:

A method and apparatus for processing (transporting) data, such as in a data warehouse system. In one embodiment, the data are received from a source and compared to data in a lookup cache comprising a subset of data from a first data set (e. g. , a dimension table). Instances of the data not present in a lookup cache (that is, new data) are identified. Information corresponding to these instances are generated (e. g. , a unique identifier is associated with each of these instances), and the first data set is updated accordingly. The lookup cache is then updated with the new data and the unique identifiers. Accordingly, the information (data) in the lookup cache and in the first data set are in synchronization. The lookup cache does not need to be rebuilt (e. g. , to update a second data set such as a fact table).