IP Library › Granted Patent US 6,988,111
Granted Patent B2
US 6,988,111 · App. 09/998,459 · Granted Jan 17, 2006

Mapping between part numbers that are based on different part numbering schemes

View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 6,988,111
App. No.
09/998,459
Granted
Jan 17, 2006
Kind
B2
Abstract

A computer-implemented method for mapping between part numbers that are based on different part numbering schemes includes receiving a first part number associated with an item, the first part number associated with the item being defined according to a first part numbering scheme. A database is searched for one or more second part numbers that are associated with the item and also cross-referenced to the first part number associated with the item, the one or more second part numbers associated with the item being defined according to one or more corresponding second part numbering schemes. In response to identifying the one or more second part numbers associated with the item, a database is searched for a third part number that is associated with the item and also cross-referenced to at least one second part number associated with the item, the third part number associated with the item being defined according to a third part numbering scheme, the first part number associated with the item being mapped to the third part number associated with the item through the at least one second part number associated with the item.

Claims (51)

1. A computer-implemented method for mapping between part numbers that are based on different part numbering schemes, comprising:

receiving a first part number associated with an item, the first part number associated with the item being defined according to a first part numbering scheme;

searching a database for one or more second part numbers that are associated with the item and also cross-referenced to the first part number associated with the item, the one or more second part numbers associated with the item being defined according to one or more corresponding second cart numbering schemes; and

in response to identifying the one or more second part numbers associated with the item, searching a database for a third part number that is associated with the item and also cross-referenced to at least one second part number associated with the item, the third part number associated with the item being defined according to a third part numbering scheme, the first part number associated with the item being mapped to the third part number associated with the item through the at least one second part number associated with the item,

wherein:

the first part number is not completely mapped to the third part number in that a plurality of second part numbers are associated with the item, at least some of these second part numbers are cross-referenced to the first part number but not cross-referenced to the third part number, and at least some of these second part numbers are cross-referenced to the third part number but not cross-referenced to the first part number; and

the method further comprises:

determining a percentage of second part numbers to which both the first part number and the third part number are cross-referenced; and

if the determined percentage is greater than a predetermined value, considering the third part number equivalent to the first part number for purposes of a particular application for the first part number.

2. A computer-implemented method for mapping between part numbers that are based on different part numbering schemes, comprising:

receiving a first part number associated with an item, the first part number associated with the item being defined according to a first part numbering scheme;

searching a database for one or more second part numbers that are associated with the item and also cross-referenced to the first part number associated with the item, the one or more second part numbers associated with the item being defined according to one or more corresponding second part numbering schemes;

in response to identifying the one or more second part numbers associated with the item, searching a database for a third part number that is associated with the item and also cross-referenced to at least one second part number associated with the item, the third part number associated with the item being defined according to a third part numbering scheme, the first part number associated with the item being mapped to the third part number associated with the item through the at least one second part number associated with the item;

accessing a first item to item specification to map the first part number to specification information for the item associated with the first part number, the first item to item specification having a first pointer to information identifying the item associated with the first part number and a second pointer to the specification information for the item associated with the first part number; and

accessing a second item to item specification to map the specification information for the item associated with the third part number to the third part number, the second item to item specification having a first pointer to information identifying the item associated with the third part number and a second pointer to specification information for the item associated with the third part number, the specification information for the item associated with the third part number substantially matching the specification information for the item associated with the first part number.

3. A computer-implemented system for mapping between part numbers that are based on different part numbering schemes, comprising:

one or more databases containing a plurality of part numbers associated with a plurality of items;

one or more processors coupled to the database and collectively operable to receive a first part number associated with an item, the first part number associated with the item being defined according to a first part numbering scheme;

search a database for one or more second part numbers that are associated with the item and also cross-referenced to the first part number associated with the item, the one or more second part numbers associated with the item being defined according to one or more corresponding second part numbering schemes; and

in response to identifying the one or more second part numbers associated with the item, search a database for a third part number that is associated with the item and also cross-referenced to at least one second part number associated with the item, the third part number associated with the item being defined according to a third part numbering scheme, the first part number associated with the item being mapped to the third part number associated with the item through the at least one second part number associated with the item,

wherein:

the first part number is not completely mapped to the third part number in that a plurality of second part numbers are associated with the item, at least some of these second part numbers are cross-referenced to the first part number but not cross-referenced to the third part number, and at least some of these second part numbers are cross-referenced to the third part number but not cross-referenced to the first part number; and

the one or more processors are further operable to:

determine a percentage of second part numbers to which both the first part number and the third part number are cross-referenced; and

if the determined percentage is greater than a predetermined value, consider the third part number equivalent to the first part number for purposes of a particular application for the first part number.

4. A computer-implemented system for mapping between part numbers that are based on different part numbering schemes, comprising:

one or more databases containing a plurality of part numbers associated with a plurality of items;

one or more processors coupled to the database and collectively operable to receive a first part number associated with an item, the first part number associated with the item being defined according to a first part numbering scheme;

search a database for one or more second part numbers that are associated with the item and also cross-referenced to the first part number associated with the item, the one or more second part numbers associated with the item being defined according to one or more corresponding second part numbering schemes;

in response to identifying the one or more second part numbers associated with the item, search a database for a third part number that is associated with the item and also cross-referenced to at least one second part number associated with the item, the third part number associated with the item being defined according to a third part numbering scheme, the first part number associated with the item being mapped to the third part number associated with the item through the at least one second part number associated with the item;

access a first item to item specification to map the first part number to specification information for the item associated with the first part number, the first item to item specification having a first pointer to information identifying the item associated with the first part number and a second pointer to the specification information for the item associated with the first part number; and

access a second item to item specification to map the specification information for the item associated with the third part number to the third part number, the second item to item specification having a first pointer to information identifying the item associated with the third part number and a second pointer to specification information for the item associated with the third part number, the specification information for the item associated with the third part number substantially matching the specification information for the item associated with the first part number.

5. Software for mapping between part numbers that are based on different part numbering schemes, the software being embodied in computer-readable media and when executed operable to:

receive a first part number associated with an item, the first part number associated with the item being defined according to a first part numbering scheme;

search a database for one or more second part numbers that are associated with the item and also cross-referenced to the first part number associated with the item, the one or more second part numbers associated with the item being defined according to one or more corresponding second part numbering schemes; and

in response to identifying the one or more second part numbers associated with the item, search a database for a third cart number that is associated with the item and also cross-referenced to at least one second part number associated with the item, the third part number associated with the item being defined according to a third part numbering scheme, the first part number associated with the item being mapped to the third part number associated with the item through the at least one second part number associated with the item,

wherein:

the first part number is not completely mapped to the third part number in that a plurality of second part numbers are associated with the item, at least some of these second part numbers are cross-referenced to the first part number but not cross-referenced to the third part number, and at least some of these second part numbers are cross-referenced to the third part number but not cross-referenced to the first part number; and

the software is further operable to:

determine a percentage of second part numbers to which both the first part number and the third part number are cross-referenced; and

if the determined percentage is greater than a predetermined value, consider the third part number equivalent to the first part number for purposes of a particular application for the first part number.

6. Software for mapping between part numbers that are based on different part numbering schemes, the software being embodied in computer-readable media and when executed operable to:

receive a first part number associated with an item, the first part number associated with the item being defined according to a first part numbering scheme;

search a database for one or more second part numbers that are associated with the item and also cross-referenced to the first part number associated with the item, the one or more second part numbers associated with the item being defined according to one or more corresponding second part numbering schemes;

in response to identifying the one or more second part numbers associated with the item, search a database for a third part number that is associated with the item and also cross-referenced to at least one second part number associated with the item, the third part number associated with the item being defined according to a third part numbering scheme, the first part number associated with the item being mapped to the third part number associated with the item through the at least one second part number associated with the item;

access a first item to item specification to map the first part number to specification information for the item associated with the first part number, the first item to item specification having a first pointer to information identifying the item associated with the first part number and a second pointer to the specification information for the item associated with the first part number; and

access a second item to item specification to map the specification information for the item associated with the third part number to the third part number, the second item to item specification having a first pointer to information identifying the item associated with the third part number and a second pointer to specification information for the item associated with the third part number, the specification information for the item associated with the third part number substantially matching the specification information for the item associated with the first part number.

7. A computer-implemented method for mapping between part numbers that are based on different part numbering schemes, comprising:

receiving a customer part number associated with an item, the customer part number associated with the item being defined according to a part numbering scheme of a corresponding customer;

searching a database for one or more manufacturer part numbers that are associated with the item and also cross-referenced to the customer part number associated with the item, the one or more manufacturer part numbers associated with the item each being defined according to a part numbering schemes of a corresponding manufacturer, a first item to item specification mapping the customer part number to specification information for the item associated with the customer part number, the first item to item specification having a first pointer to information identifying the item associated with the customer part number and a second pointer to the specification information for the item associated with the customer part number; and

in response to identifying the one or more manufacturer part numbers associated with the item, searching a database for an internal part number that is associated with the item and also cross-referenced to at least one manufacturer part number associated with the item, the internal part number associated with the item being defined according to a part numbering scheme of a corresponding seller, a second item to item specification mapping the specification information for the item associated with the internal part number to the internal part number, the second item to item specification having a first pointer to information identifying the item associated with the internal part number and a second pointer to specification information for the item associated with the internal part number, the specification information for the item associated with the internal part number substantially matching the specification information for the item associated with the customer part number, the customer part number being mapped to the internal part number through the at least one manufacturer part number.

Assignments (17)
RELEASE OF SECURITY INTEREST IN PATENTS PREVIOUSLY RECORDED AT REEL/FRAME (053383/0117) Recorded Nov 3, 2021
From: U.S. BANK NATIONAL ASSOCIATION, AS COLLATERAL AGENT
To: BLUE YONDER GROUP, INC.
Reel/Frame 058794/0776 →
RELEASE OF SECURITY INTEREST Recorded Sep 16, 2021
From: JPMORGAN CHASE BANK, N.A.
To: BLUE YONDER GROUP, INC.; BLUE YONDER, INC.; JDA SOFTWARE SERVICES, INC.; I2 TECHNOLOGIES INTERNATIONAL SERVICES, LLC; MANUGISTICS SERVICES, INC.; MANUGISTICS HOLDINGS DELAWARE II, INC.; REDPRAIRIE COLLABORATIVE FLOWCASTING GROUP, LLC; JDA SOFTWARE RUSSIA HOLDINGS, INC.; REDPRAIRIE SERVICES CORPORATION; BY BOND FINANCE, INC.; BY NETHERLANDS HOLDING, INC.; BY BENELUX HOLDING, INC.
Reel/Frame 057724/0593 →
CORRECTIVE ASSIGNMENT TO CORRECT THE REEL 026468 FRAME NUMBER FROM 0199 TO 0119 PREVIOUSLY RECORDED ON REEL 055136 FRAME 0623. ASSIGNOR(S) HEREBY CONFIRMS THE CORRECTION ASSIGNMENT. Recorded Apr 19, 2021
From: I2 TECHNOLOGIES US, INC.
To: JDA TECHNOLOGIES US, INC.
Reel/Frame 056813/0110 →
CORRECTIVE ASSIGNMENT TO CORRECT THE NAME OF THE CONVEYING AND RECEIVING PARTIES TO INCLUDE A PERIOD AFTER THE TERM INC PREVIOUSLY RECORDED AT REEL: 026740 FRAME: 0676. ASSIGNOR(S) HEREBY CONFIRMS THE ASSIGNMENT. Recorded Feb 8, 2021
From: JDA TECHNOLOGIES US, INC.
To: JDA SOFTWARE GROUP, INC.
Reel/Frame 055257/0747 →
CORRECTIVE ASSIGNMENT TO CORRECT THE NAME OF THE CONVEYING AND RECEIVING PARTIES TO INCLUDE A PERIOD AFTER THE TERM INC PREVIOUSLY RECORDED ON REEL 026468 FRAME 0199. ASSIGNOR(S) HEREBY CONFIRMS THE CHANGE OF NAME FROM I2 TECHNOLOGIES US, INC. TO JDA TECHNOLOGIES US, INC.. Recorded Dec 12, 2020
From: I2 TECHNOLOGIES US, INC.
To: JDA TECHNOLOGIES US, INC.
Reel/Frame 055136/0623 →
SECURITY AGREEMENT Recorded Aug 3, 2020
From: BLUE YONDER GROUP, INC.
To: U.S. BANK NATIONAL ASSOCIATION
Reel/Frame 053383/0117 →
CHANGE OF NAME Recorded Apr 14, 2020
From: JDA SOFTWARE GROUP, INC.
To: BLUE YONDER GROUP, INC.
Reel/Frame 052392/0760 →
RELEASE OF SECURITY INTEREST IN PATENTS AT REEL/FRAME NO. 29556/0697 Recorded Oct 12, 2016
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
To: JDA SOFTWARE GROUP, INC.
Reel/Frame 040337/0053 →
RELEASE OF SECURITY INTEREST IN PATENTS AT REEL/FRAME NO. 29556/0809 Recorded Oct 12, 2016
From: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
To: JDA SOFTWARE GROUP, INC.
Reel/Frame 040337/0356 →
SECURITY AGREEMENT Recorded Oct 12, 2016
From: RP CROWN PARENT, LLC; RP CROWN HOLDING LLC; JDA SOFTWARE GROUP, INC.
To: JPMORGAN CHASE BANK, N.A., AS COLLATERAL AGENT
Reel/Frame 040326/0449 →
FIRST LIEN PATENT SECURITY AGREEMENT Recorded Jan 2, 2013
From: JDA SOFTWARE GROUP, INC.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
Reel/Frame 029556/0809 →
FIRST LIEN PATENT SECURITY AGREEMENT Recorded Jan 2, 2013
From: JDA SOFTWARE GROUP, INC.
To: CREDIT SUISSE AG, CAYMAN ISLANDS BRANCH
Reel/Frame 029556/0697 →
RELEASE OF SECURITY INTEREST IN PATENT COLLATERAL Recorded Dec 21, 2012
From: WELLS FARGO CAPITAL FINANCE, LLC
To: JDA TECHNOLOGIES US, INC.
Reel/Frame 029529/0812 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Aug 12, 2011
From: JDA TECHNOLOGIES US, INC.
To: JDA SOFTWARE GROUP, INC.
Reel/Frame 026740/0676 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jun 21, 2011
From: I2 TECHNOLOGIES US, INC
To: JDA TECHNOLOGIES US, INC
Reel/Frame 026468/0119 →
PATENT SECURITY AGREEMENT Recorded Apr 4, 2011
From: JDA TECHNOLOGIES US, INC.
To: WELLS FARGO CAPITAL FINANCE, LLC, AS AGENT
Reel/Frame 026072/0353 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 29, 2001
From: CHOW, ROLAND W.; PRAKASH, ARUN B.
To: I2 TECHNOLOGIES US, INC.
Reel/Frame 012344/0601 →