# US 2003/0212679 A1 · Multi-category support for apply output

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

- Number: US 2003/0212679 A1
- Document ID: US20030212679A1
- Status: Published application
- Kind: A1
- Application number: 10/419,922
- Filed: 2003-04-22
- Published: 2003-11-13
- Earliest claimed: 2002-05-10
- Assignees: Oracle International Corporation
- Inventors: Sunil Venkayala; Hankil Yoon
- Web page: https://patentgrep.com/patent/US20030212679A1

## CPC

- G06F 16/35: Clustering; Classification
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)

## Abstract

A system, method, and computer program product provides a multi-category apply operation in a data mining system that produces output with multiple class values, their associated measures including probabilities in case of supervised models, quality of fit and distance in case of clustering models, and the relative ranks of the predictions. A method for multi-category apply in a data mining system comprises the steps of receiving input data for scoring including a plurality of rows of data applied to a data mining model and generating multi-category apply output including a plurality of class values and their associated probabilities based on the received input data, the selected class values having probabilities meeting a selection criterion and their ranks.

## Claims

### Claim 1

A method for multi-category apply in a data mining system, the method comprising the steps of:
receiving scoring data including a plurality of rows of data applied to a data mining model and associated measures, including probabilities of predictions, ranks, quality of fit, or distance; and
generating multi-category apply data including a plurality of class values meeting a selection criterion and their associated measures including probabilities of predictions, ranks, quality of fit or distance based on the received scoring data.

### Claim 2 (depends on 1)

The method of claim 1, wherein the step of generating multi-category apply data comprises the steps of:
generating input data tables including active attributes and source attributes;
evaluating measures including probabilities and ranks of categories of a target attribute to determine those meeting the selection criterion for supervised models;
evaluating measures including probabilities, ranks, quality of fit, and distance of predicted values, to determine those meeting the selection criterion, for unsupervised models; and
generating an output data table including a plurality of class values of the target attribute meeting the selection criterion and their associated measures including probabilities, ranks, quality of fit and distance.

### Claim 3 (depends on 2)

The method of claim 2, wherein the step of generating multi-category apply data further comprises the steps of:
receiving the scoring data in a transactional format; and
preparing the scoring data in the transactional format to generate input data tables including active attributes and source attributes.

### Claim 4 (depends on 3)

The method of claim 3, further comprising the step of:
validating the received scoring data to ensure active attributes and a target attribute specified for the data mining model are present in the received scoring data and the source attributes specified for the multi-category apply output are present in the input data.

### Claim 5 (depends on 4)

The method of claim 4, wherein the selection criterion comprises one of:
a topmost category including a class value or predicted value having a highest associated probability, top N categories including N class values having highest associated probabilities, bottom N categories including N class values having lowest associated probabilities, or all categories including all class values with associated probabilities.

### Claim 6 (depends on 2)

The method of claim 2, wherein the step of generating multi-category apply data further comprises the steps of:
receiving the scoring data in a non-transactional format; and
preparing the scoring data in the non-transactional format to generate input data tables including active attributes and source attributes.

### Claim 7 (depends on 6)

The method of claim 6, further comprising the step of:
validating the received scoring data to ensure active attributes and a target attribute specified for the data mining model are present in the received scoring data and the source attributes specified for the multi-category apply output are present in the input data.

### Claim 8 (depends on 7)

The method of claim 7, wherein the selection criterion comprises one of:
a topmost category including a class value or predicted value having a highest associated probability, top N categories including N class values having highest associated probabilities, bottom N categories including N class values having lowest associated probabilities, or all categories including all class values with associated probabilities.

### Claim 9 (depends on 2)

The method of claim 2, wherein the step of generating multi-category apply data further comprises the steps of:
receiving a portion of the scoring data in a transactional format and a portion of the scoring data in a non-transactional format;
preparing the portion of the scoring data in the transactional format to generate input data tables including active attributes and source attributes; and
preparing the portion of the scoring data in the non-transactional format to generate input data tables including active attributes and source attributes.

### Claim 10 (depends on 9)

The method of claim 9, further comprising the step of:
validating the received scoring data to ensure active attributes and a target attribute specified for the data mining model are present in the received scoring data and the source attributes specified for the multi-category apply output are present in the input data.

### Claim 11 (depends on 10)

The method of claim 10, wherein the selection criterion comprises one of:
a topmost category including a class value or predicted value having a highest associated probability, top N categories including N class values having highest associated probabilities, bottom N categories including N class values having lowest associated probabilities, or all categories including all class values with associated probabilities.

### Claim 12

A system for multi-category apply in a data mining system comprising:
a processor operable to execute computer program instructions;
a memory operable to store computer program instructions executable by the processor; and
computer program instructions stored in the memory and executable to perform the steps of:
receiving scoring data including a plurality of rows of data applied to a data mining model and associated measures including probabilities of predictions, ranks, quality of fit or distance; and
generating multi-category apply data including a plurality of class values and their associated measures including probabilities of predictions, ranks, quality of fit or distance, based on the received scoring data.

### Claim 13 (depends on 12)

The system of claim 12, wherein the step of generating multi-category apply data comprises the steps of:
generating input data tables including active attributes and source attributes;
evaluating measures including probabilities and ranks of categories of a target attribute to determine those meeting the selection criterion for supervised models;
evaluating measures including probabilities, ranks, quality of fit, and distance of predicted values to determine those meeting the selection criterion for unsupervised models; and
generating an output data table including a plurality of class values of the target attribute meeting the selection criterion and their associated measures including probabilities, ranks, quality of fit, and distance.

### Claim 14 (depends on 13)

The system of claim 13, wherein the step of generating multi-category apply data further comprises the steps of:
receiving the scoring data in a transactional format; and
preparing the scoring data in the transactional format to generate input data tables including active attributes and source attributes.

### Claim 15 (depends on 14)

The system of claim 14, further comprising the step of:
validating the received scoring data to ensure active attributes and a target attribute specified for the data mining model are present in the received scoring data and the source attributes specified for the multi-category apply output are present in the input data.

### Claim 16 (depends on 15)

The system of claim 15, wherein the selection criterion comprises one of:
a topmost category including a class value or predicted value having a highest associated probability, top N categories including N class values having highest associated probabilities, bottom N categories including N class values having lowest associated probabilities, or all categories including all class values with associated probabilities.

### Claim 17 (depends on 13)

The system of claim 13, wherein the step of generating multi-category apply data further comprises the steps of:
receiving the scoring data in a non-transactional format; and
preparing the scoring data in the non-transactional format to generate input data tables including active attributes and source attributes.

### Claim 18 (depends on 17)

The system of claim 17, further comprising the step of:
validating the received scoring data to ensure active attributes and a target attribute specified for the data mining model are present in the received scoring data and the source attributes specified for the multi-category apply output are present in the input data.

### Claim 19 (depends on 18)

The system of claim 18, wherein the selection criterion comprises one of:
a topmost category including a class value predicted value having a highest associated probability, top N categories including N class values having highest associated probabilities, bottom N categories including N class values having lowest associated probabilities, or all categories including all class values with associated probabilities.

### Claim 20 (depends on 13)

The system of claim 13, wherein the step of generating multi-category apply data further comprises the steps of:
receiving a portion of the scoring data in a transactional format and a portion of the scoring data in a non-transactional format;
preparing the portion of the scoring data in the transactional format to generate input data tables including active attributes and source attributes; and
preparing the portion of the scoring data in the non-transactional format to generate input data tables including active attributes and source attributes.

### Claim 21 (depends on 20)

The system of claim 20, further comprising the step of:
validating the received scoring data to ensure active attributes and a target attribute specified for the data mining model are present in the received scoring data and the source attributes specified for the multi-category apply output are present in the input data.

### Claim 22 (depends on 21)

The system of claim 21, wherein the selection criterion comprises one of:
a topmost category including a class value predicted value having a highest associated probability, top N categories including N class values having highest associated probabilities, bottom N categories including N class values having lowest associated probabilities, or all categories including all class values with associated probabilities.

### Claim 23

A computer program product for multi-category apply in a data mining system comprising:
a computer readable medium;
computer program instructions, recorded on the computer readable medium, executable by a processor, for performing the steps of
receiving scoring data including scores of rows of data applied to a data mining model and associated measures, including probabilities of predictions, ranks, quality of fit, or distance; and
generating multi-category apply data including a plurality of class values meeting a selection criterion and their associated measures including probabilities, ranks, quality of fit or distance, based on the received scoring data.

### Claim 24 (depends on 23)

The computer program product of claim 23, wherein the step of generating multi-category apply data comprises the steps of:
generating input data tables including active attributes and source attributes;
evaluating measures including probabilities and ranks of categories of a target attribute to determine those meeting the selection criterion for supervised models; and
evaluating measures including probabilities, ranks, quality of fit, and distance of predicted values to determine those meeting the selection criterion for unsupervised models; and
generating an output data table including a plurality of class values of the target attribute meeting the selection criterion and their associated measures including probabilities, ranks, quality of fit and distance.

### Claim 25 (depends on 24)

The computer program product of claim 24, wherein the step of generating multi-category apply data further comprises the steps of:
receiving the scoring data in a transactional format; and
preparing the scoring data in the transactional format to generate input data tables including active attributes and source attributes.

### Claim 26 (depends on 25)

The computer program product of claim 25, further comprising the step of:
validating the received scoring data to ensure active attributes and a target attribute specified for the data mining model are present in the received scoring data and the source attributes specified for the multi-category apply output are present in the input data.

### Claim 27 (depends on 26)

The computer program product of claim 26, wherein the selection criterion comprises one of:
a topmost category including a class value predicted value having a highest associated probability, top N categories including N class values having highest associated probabilities, bottom N categories including N class values having lowest associated probabilities, or all categories including all class values with associated probabilities.

### Claim 28 (depends on 24)

The computer program product of claim 24, wherein the step of generating multi-category apply data further comprises the steps of:
receiving the scoring data in a non-transactional format; and
preparing the scoring data in the non-transactional format to generate input data tables including active attributes and source attributes.

### Claim 29 (depends on 28)

The computer program product of claim 28, further comprising the step of:
validating the received scoring data to ensure active attributes and a target attribute specified for the data mining model are present in the received scoring data and the source attributes specified for the multi-category apply output are present in the input data.

### Claim 30 (depends on 29)

The computer program product of claim 29, wherein the selection criterion comprises one of:
a topmost category including a class value predicted value having a highest associated probability, top N categories including N class values having highest associated probabilities, bottom N categories including N class values having lowest associated probabilities, or all categories including all class values with associated probabilities.

### Claim 31 (depends on 24)

The computer program product of claim 24, wherein the step of generating multi-category apply data further comprises the steps of:
receiving a portion of the scoring data in a transactional format and a portion of the scoring data in a non-transactional format;
preparing the portion of the scoring data in the transactional format to generate input data tables including active attributes and source attributes; and
preparing the portion of the scoring data in the non-transactional format to generate input data tables including active attributes and source attributes.

### Claim 32 (depends on 31)

The computer program product of claim 31, further comprising the step of:
validating the received scoring data to ensure active attributes and a target attribute specified for the data mining model are present in the received scoring data and the source attributes specified for the multi-category apply output are present in the input data.

### Claim 33 (depends on 32)

The computer program product of claim 32, wherein the selection criterion comprises one of:
a topmost category including a class value predicted value having a highest associated probability, top N categories including N class values having highest associated probabilities, bottom N categories including N class values having lowest associated probabilities, or all categories including all class values with associated probabilities.
