# US 2008/0189639 A1 · Dynamically detecting exceptions based on data changes

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

- Number: US 2008/0189639 A1
- Document ID: US20080189639A1
- Status: Published application
- Kind: A1
- Application number: 11/670,783
- Filed: 2007-02-02
- Published: 2008-08-07
- Earliest claimed: 2007-02-02
- Assignees: Microsoft Corporation
- Inventors: Raman S. Iyer; C. James MacLennan; Ioan Bogdan Crivat
- Web page: https://patentgrep.com/patent/US20080189639A1

## CPC

- G06F 40/177: of tables; using ruled lines
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

Fields contained in data expressed as tabular data having columns and rows can initially be marked as exceptions, wherein a column within a row can be the potential cause of the exception. A user configurable parameter can be utilized to change the sensitivity or allowable exceptions for each row and/or column, to increase or decrease the number of exceptions detected. As data within each field are modified, added or deleted, or when the configurable parameter is changed, the exceptions marked can be automatically updated. Such updated exceptions can be the same or different from the initially marked exceptions. As such, a user can evaluate data and determine whether various changes within the data will change various outcomes.

## Claims

### Claim 1

A system that facilitates dynamically detecting data exceptions in tabular data, comprising:
a predictive analysis component that receives tabular data from an application and marks one or more rows that are exceptions within the tabular data; and
a comparison component that receives changes to one or more parameters of the tabular data and automatically evaluates the one or more parameters against the one or more marked rows and selectively updates the one or more marked rows.

### Claim 2 (depends on 1)

The system of claim 1, further comprising an interface component that provides a user configurable parameter that defines a threshold for marking the one or more rows as an exception.

### Claim 3 (depends on 1)

The system of claim 1, the one or more parameters is at least one of a data modification, a data addition, a data deletion, or a sensitivity parameter change or combinations thereof.

### Claim 4 (depends on 1)

The system of claim 1, further comprising a sensitivity value that has a low value and a high value, the low value results in less exceptions being marked in the tabular data and the high value represents more exceptions being marked in the tabular data.

### Claim 5 (depends on 1)

The system of claim 1, the comparison component utilizes conditional formatting to update the one or more rows that are displayed.

### Claim 6 (depends on 1)

The system of claim 1, further comprising a notification component that automatically invokes the comparison component when a data change occurs.

### Claim 7 (depends on 1)

The system of claim 1 further comprising a display component that presents the tabular data and the one or more marked rows.

### Claim 8 (depends on 1)

The system of claim 1, the predictive analysis component and the comparison component are executed on a server independent of the location of the tabular data.

### Claim 9 (depends on 1)

The system of claim 1, further comprising a scoring component that utilizes data mining techniques to update the one or more marked rows.

### Claim 10 (depends on 1)

The system of claim 1, the one or more rows are marked by a highlighting scheme.

### Claim 11 (depends on 1)

The system of claim 1, the tabular data is contained in a spreadsheet application.

### Claim 12 (depends on 1)

The system of claim 1, the tabular data is contained in an XML application.

### Claim 13

A method for dynamically detecting and presenting exception data;
comprising:
receiving a data change notification;
evaluating a changed row;
returning an exception score for a current row;
comparing the exception score with a sensitivity metric; and
presenting the exception result to a user.

### Claim 14 (depends on 13)

The method of claim 13, comparing the exception score with a sensitivity metric comprising providing a configurable set point.

### Claim 15 (depends on 13)

The method of claim 13, presenting the exception result to a user comprising highlighting a row and a column within the row with a highlighting scheme.

### Claim 16 (depends on 13)

The method of claim 13, evaluating a changed row comprising utilizing a data mining system that contains a pattern model.

### Claim 17 (depends on 13)

The method of claim 13, presenting the exception result to a user is on the fly as data change notifications are received.

### Claim 18 (depends on 13)

The method of claim 13, further comprising accepting a user change to at least one of a data modification, a data addition, a data deletion or a sensitivity metric parameter, or combinations thereof.

### Claim 19

A computer executable system that provides dynamic exception detection in tabular data, comprising:
means for receiving a change to a database;
means for evaluating the database change against existing data; and
means for dynamically updating at least one row exception data or column exception data based in part on the evaluated database change.

### Claim 20 (depends on 19)

The computer executable system of claim 19, further comprising means for automatically displaying the updated at least one or row exception data or column exception.
