System and method for improving resolution of channel data

• US 7,921,115 B2
• Filed: 11/20/2009
• Issued: 04/05/2011
• Est. Priority Date: 10/23/2002
• Status: Expired due to Term

• Current Assignee: Model N, Inc.
• Original Assignee: Infonow Corporation
• Inventors: Hsieh, Yuan Che, Kark, Donald, Rand, Nahum
• Primary Examiner(s): FILIPCZYK, MARCIN R
• Application Number:
  US12/623,186
• Publication Number:
  US 20100138447A1
• Time in Patent Office: 501 Days
• Field of Search: 705/50, 705/51, 705/57, 705/75, 705/76, 707/724, 707/743, 707/755, 707/999.003, 707/999.006, 715/50, 715/51, 715/57, 715/75, 715/76
• US Class Current: 707/743
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: Y10S 707/99931 Database or file accessing
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99936 Pattern matching access

Abstract

Disclosed are methods for processing distribution channel data integrating business information with geographic data to produce integrated data, wherein the integrated data has greater resolution than the business information. Distribution channel data is captured and correlated with the integrated data to increase the resolution of the distribution channel data.

Claims

1. A system for managed product distribution, comprising:

one or more reference record databases, each data base having a plurality of reference records with each reference record regarding a product providing an association between business information and geo-coded spatial data;

transaction data including geo-coded spatial data;

a processor operable to match reference records from one of the reference record databases with transaction data and to perform lexical matching;

a set of matched records created from matching one or more reference records from one of the reference record databases with the transaction data using geo-coded spatial data;

one or more candidate reference records identified using lexical matching process from the set of matched records as having an association between business information and transaction data, wherein the one or more identified candidate reference records is associated with the transaction data using a unique identifier; and

a memory operable to store the unique identifier.

2. The system of claim 1 further comprising a geo-coding mechanism operable to determine street-level spatial data from the transaction data.

3. The system of claim 1 further comprising a candidate identification mechanism operable to match one or more reference records with the transaction data using geo-coded spatial data.

4. The system of claim 3 wherein the candidate identification mechanism determines postal code information from the transaction data.

5. The system of claim 3 wherein the candidate identification mechanism determines location information from the transaction data.

6. The system of claim 5 wherein the candidate identification mechanism further comprises a selection mechanism for retrieving records that have spatial data matching the spatial data obtained from the transaction record.

7. The system of claim 1 wherein the lexical matching process is operable to correlate non-spatial data in the transaction record with non-spatial data in the candidate reference records.

8. The system of claim 1 wherein the lexical matching process is operable to correlate spatial data in the transaction record with spatial data in the candidate reference records.

9. A method for identifying participants in a distribution channel, comprising:

receiving a transaction record comprising business and spatial data that identifies at least one channel participant, wherein the spatial data is geo-coded;

accessing a reference record database, said reference record database comprising a plurality of reference records wherein each reference record comprises business and geo-coded spatial information;

conducting by a processor a lexical comparison of the transaction record to the plurality of reference records to identify one or more lexical matches;

comparing by said processor geo-coded spatial data of the reference record to geo-coded spatial information of the one or more lexical matches identifying at least one match between the transaction record and the plurality of reference records wherein the at least one match is associated with a unique identifier; and

storing in a memory the unique identifier.

10. The method of claim 9 wherein the at least one channel participant is an end customer.

11. The method of claim 10 further comprising:

using the one or more reference records to attribute transactions to another channel participant, wherein the transaction record itself has insufficient precision to accurately attribute the transactions and wherein the reference record database is updated based on attributing transactions to another channel participant.