# US 2010/0250566 A1 · Method and Computer System for Aggregating Data from a Plurality of Operational Databases

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2010/0250566 A1
- Document ID: US20100250566A1
- Status: Published application
- Kind: A1
- Application number: 12/750,296
- Filed: 2010-03-30
- Published: 2010-09-30
- Earliest claimed: 2009-03-31
- Assignees: Trapeze Software Inc.
- Inventors: Chacko Kattithara PAUL
- Web page: https://patentgrep.com/patent/US20100250566A1

## CPC

- G06F 16/283: {Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A method and computer system for aggregating data from a plurality of operational databases are provided. It is determined if a transformation script stored in storage of a computer system has been modified. Delta data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified. All data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified.

## Claims

### Claim 1

A method for aggregating data from a plurality of operational databases, comprising:
determining if a transformation script stored in storage of a computer system has been modified;
automatically merging and transforming delta data extracted from said operational databases and specified by said transformation script if said transformation script is unmodified; and
automatically merging and transforming all data extracted from said operational databases and specified by said transformation script if said transformation script is modified.

### Claim 2 (depends on 1)

The method of claim 1, wherein said determining comprises:
comparing a version number for said transformation script to a registered version number for said transformation script when previously executed.

### Claim 3 (depends on 1)

The method of claim 1, wherein said determining comprises:
comparing the value of a hash function of said transformation script to a registered value of said hash function for said transformation script when previously executed.

### Claim 4 (depends on 1)

The method of claim 1, wherein said automatically merging and transforming is performed during a regularly-scheduled update to a data mart.

### Claim 5

A computer system for aggregating data from a plurality of operational databases, comprising:
computer-executable instructions stored in storage of said computer system, said computer-executable instructions, when executed by a processor of said computer system:
determining if a transformation script stored in storage of a computer system has been modified;
automatically merging and transforming delta data extracted from said operational databases and specified by said transformation script if said transformation script is unmodified; and
automatically merging and transforming all data extracted from said operational databases and specified by said transformation script if said transformation script is modified.

### Claim 6 (depends on 5)

The computer system of claim 5, wherein said determining comprises:
comparing a version number for said transformation script to a registered version number for said transformation script when previously executed.

### Claim 7 (depends on 5)

The computer system of claim 5, wherein said determining comprises:
comparing the value of a hash function of said transformation script to a registered value of said hash function for said transformation script when previously executed.

### Claim 8 (depends on 5)

The computer system of claim 5, wherein said automatically merging and transforming is performed during a regularly-scheduled update to a data mart.
