1. Oracle® Enterprise Data Quality Product Data Services User Guide
  2. Key Generation
  3. Key Methods

8.3 Key Methods

The following key methods are provided:

Name Inputs Key Value Creation Example

Description Metaphone (DSM)

StandardizedTextMetaphone:

Array of metaphone of length 4 tokens from each standardized text token of the description, denoised of tokens that are single character or identified as common tokens i.e. “and”, “of”, “with”, “X”, “x”.

Create single key on each element of the array.

Prefix:

DSM

 Input:

{MXNK, PNSL, PRL}

Key Output:

{DSM^MXNK, DSM^PNSL, DSM^PRL}

Defualt:

ON

Key Method Description Metaphone Pairs (DPM)

 StandardizedTextMetaphone:

Metaphone of length 4 on each standardized text token, denoised from tokens that are single char or identified common tokens i.e. “and”, “of”, “with”, “X”, “x”, split into array.

Create key value on each unique pair of tokens (order tokens alphabetically)

Prefix:

DSM

 Input1:

{MXNK, PNSL, PRL}

Key Output:

{DSM^MXNK^PNSL, DSM^PNSL^PRL, DSM^DSM^PRL}

Defualt:

OFF

Key Method Description Simple (DSS)

 DescriptionForDSS.Abbreviated:

Single string reconstructed from the processed product description tokens (prior to metaphones being applied), passed through the EDQ-PDS Abbreviate processor (with default settings), trimmed to 10 characters.

Create key value on input

Prefix:

DPM

 Input1:

{CHSLTPPNYL}

Key Output:

{DSS^CHSLTPPNYL}

Defualt:

ON

Key Method Manufacturer part number (MPN)

ManufacturerPartNumberTrimmed:

Manufacturer part number (whitespace removed).

Create Key value from part number input

Prefix:

MPM

Input1: ManufacturerPartNumberTrimmed

Input1:

PN12956

Output:

MPN^PN12956

Defualt:

ON

Key Method Model number (MDN)

 ModelNumberTrimmed:

Model number (whitespace removed)

Create Key value from model number input

Prefix:

MDM

Input1: ModelNumberTrimmed

Input1:

ADC-245632

Output:

MDN^ADC-245632

Defualt:

ON

Key Method Product name (PRN)

 ProductNameTrimmed:

Productname, with whitespace removed

Create key value from single product name input

Prefix:

PRN

Input1: ProductNameStandardizedTrimmed

Length: Full length

Input1:

ZINCHEXBOLTSUSSPACK

Output:

PRN^ZINCHEXBOLTSUSSPACK

Defualt:

ON

Key Method UID full string (UID1..3)

 unique id 1..3

Create key value from single UID input

Prefix:

UID1..3

Input1:

Input1:Uid1..3

Input1:

ABC123

Prefix:

UID1

Output:

{UID1^ABC123}

Default:

ON