# US 2008/0307262 A1 · System for Validating Data for Processing and Incorporation in a Report

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

- Number: US 2008/0307262 A1
- Document ID: US20080307262A1
- Status: Published application
- Kind: A1
- Application number: 12/131,965
- Filed: 2008-06-03
- Published: 2008-12-11
- Earliest claimed: 2007-06-05
- Assignees: Siemens Medical Solutions USA, Inc.
- Inventors: James T. Carlin, III
- Web page: https://patentgrep.com/patent/US20080307262A1

## CPC

- G06F 16/215: Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
- G06F 16/254: {Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A system automates the process of isolating incorrect, corrupt, or sensitive data and skipping duplicate records caused by violations of application business rules during report generation, for example. A data processor provides data for processing for incorporation in a report by, processing received report data to identify data objects in the report data likely to generate errors in preparation of a report based on the report data and providing validated report data by collating received report data and omitting identified data objects likely to generate errors. The data processor communicates the validated report data for storage in a repository for use in preparation of a report. An error data processor provides information indicating identified data objects in the report data likely to generate errors and a corresponding reason an individual data object is likely to cause an error.

## Claims

### Claim 1

A system for processing data for incorporation in a report, comprising:
a data processor for,
acquiring report data by,
processing received report data to identify data objects in said report data, said data objects being likely to generate errors in preparation of a report based on said report data;
providing validated report data by collating received report data and omitting identified data objects likely to generate errors and
communicating said validated report data for storage in a repository for use in preparation of a report; and
an error data processor for providing information indicating identified data objects in said report data likely to generate errors and a corresponding reason an individual data object is likely to cause an error.

### Claim 2 (depends on 1)

A system according to claim 1, wherein
said data processor uses said information indicating identified data objects likely to generate errors, to identify data objects in said report data and omit identified data objects likely to generate errors from said validated report data derived from said report data.

### Claim 3 (depends on 2)

A system according to claim 2, wherein
said data objects in said report data likely to generate errors in preparation of a report comprise replicated data objects.

### Claim 4 (depends on 1)

A system according to claim 1, wherein
said error data processor provides information indicating identified data objects in said report data likely to generate errors and a date of detection of said data objects in said report data likely to generate errors.

### Claim 5 (depends on 1)

A system according to claim 1, wherein
said error data processor provides information indicating identified data objects in said report data likely to generate errors and a date of resolution of an error associated with an individual identified data object.

### Claim 6

A system for processing data for incorporation in a report, comprising:
a first repository of report data;
a data processor for,
parsing report data in said first repository to identify data objects likely to generate errors during preparation of a report based on said report data,
generating a second repository of error information indicating identified data objects in said first repository likely to generate errors,
transferring report data from said first repository to a validated report data repository by excluding data objects from transfer indicated as data objects likely to generate errors in said second repository; and
an error data processor for providing summary information indicating identified data objects in said error information and a corresponding reason an individual data object is likely to cause an error.

### Claim 7 (depends on 6)

A system according to claim 6, wherein
said data processor copies said report data from a data source for storage in said first repository.

### Claim 8 (depends on 6)

A system according to claim 6, wherein
said error data processor includes in said summary information, at least one of, (a) a date of detection of said data objects in said report data likely to generate errors and (b) a date of resolution of an error associated with an individual identified data object.

### Claim 9 (depends on 6)

A system according to claim 6, including
a search processor for searching said error information to find one or more data objects indicated as likely to generate errors during preparation of a report in response to user entered text.

### Claim 10 (depends on 6)

A system according to claim 6, wherein
said data processor performs a data integrity check on data during transferring said report data from said first repository to said validated report data repository.

### Claim 11

A system for processing data for incorporation in a report comprising:
a first repository of report data;
a data processor for,
parsing report data in said first repository to identify replicate data objects likely to generate errors during preparation of a report based on said report data,
generating a second repository of error information indicating identified replicate data objects in said first repository likely to generate errors,
transferring report data from said first repository to a validated report data repository by excluding replicate data objects from transfer indicated as replicate data objects in said second repository; and
a report generator for generating a report using data in said validated report data repository.

### Claim 12 (depends on 11)

A system according to claim 11, wherein
said first repository is an Online Transaction Processing database.

### Claim 13 (depends on 11)

A system according to claim 11, wherein
said validated report data repository is an Online Analytic Processing database.

### Claim 14 (depends on 11)

A system according to claim 11, wherein
said first repository, said second repository and said validated data repository comprise one or more databases.
