System, method and apparatus for locating and merging data fields of lost records with found records

• US 9,626,645 B2
• Filed: 01/17/2014
• Issued: 04/18/2017
• Est. Priority Date: 01/17/2014
• Status: Active Grant

• Current Assignee: Chargerback, Inc.
• Original Assignee: Chargerback, Inc.
• Inventors: Colodny, Brian, McLaughlin, Michael
• Primary Examiner(s): Chau, Dung K
• Application Number:
  US14/158,658
• Publication Number:
  US 20150205835A1
• Time in Patent Office: 1,187 Days
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/244 Grouping and aggregation
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/955 using information identifiers, e.g. uniform resource locators [URL]
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

In one embodiment, a system, method, and apparatus to generate a merged record comprises: a client server configured to generate a first report and a recovery server configured to: receive the first report, determine if a descriptive term matches a generic term, associate a generic code to the at least one descriptive term if there is a match; determine if the descriptive term matches a product term if there is no match; associate a product code to the descriptive term if there is a matches; and associate the descriptive term with a main code, the main code based upon the generic code or product code.

Claims

1. A system to generate a merged record, comprising:

a client server configured to generate a first report; and

a recovery server configured to;

receive the first report, the first report including first report information, the first report information including at least one descriptive term and a customer identification (ID);

determine if the at least one descriptive term matches one of a plurality of generic terms stored in a terms database, each of the plurality of generic terms associated with a generic code;

associate the generic code to the at least one descriptive term if it is determined that the at least one descriptive term matches one of the plurality of generic terms;

determine if the at least one descriptive term matches one of a plurality of product terms if it is determined that the at least one descriptive term does not match one of the plurality of generic terms, each of the plurality of product terms associated with a product code;

associate the product code to the descriptive term if it is determined that the at least one descriptive term matches one of the plurality of product terms; and

associate the at least one descriptive term with at least one main code, the associated main code based upon the associated generic code or product code.

2. The system of claim 1, wherein the recover server is further configured to:

locate a second report having second report information, the second report information including at least a customer ID and at least one main code; and

determine whether the second report customer ID and main code matches the first report customer ID and main code.

3. The system of claim 2, wherein the recover server is further configured to:

compare the first report information with the second report information to identify one or more differences, the first report information and the second report information having a plurality of data fields;

determining if there are one or more differences between the at least one of the plurality of first report data fields and the at least one of the plurality of second report data fields;

produce a single combined data field if the determining determines there are one or more differences; and

generate a merged record using the combined data field.

4. The system of claim 3, wherein the single combined data field includes information from the first report data field and information from the second report data field, and

wherein the information from the second report data field is presented differently or separate from the information from the first report data field.

5. The system of claim 4, wherein the information from the second report data field is presented in a different font than the information from the first report data field.

6. The system of claim 4, wherein the information from the second report data field is presented in a different color than the information from the first report data field.

7. The system of claim 4, wherein the information from the second report data field is presented in italics.

8. A method for generating a merged report, comprising:

receiving, at a server, a first report, the first report including first report information, the first report information including at least one descriptive term and a customer identification (ID);

determining if the at least one descriptive term matches one of a plurality of generic terms stored in a terms database, each of the plurality of generic terms associated with a generic code;

associating the generic code to the at least one descriptive term if it is determined that the at least one descriptive term matches one of the plurality of generic terms;

determining if the at least one descriptive term matches one of a plurality of product terms if it is determined that the at least one descriptive term does not match one of the plurality of generic terms, each of the plurality of product terms associated with a product code;

associating the product code to the descriptive term if it is determined that the at least one descriptive term matches one of the plurality of product terms; and

associating the at least one descriptive term with at least one main code, the associated main code based upon the associated generic code or product code.

9. The method of claim 8, comprising locating a second report having second report information, the second report information including at least a customer ID and at least one main code;

and

determining whether the second report customer ID and main code matches the first report customer ID and main code.

10. The method of claim 9, comprising:

comparing the first report information with the second report information to identify one or more differences, the first report information and the second report information having a plurality of data fields;

determining if there are one or more differences between the at least one of the plurality of first report data fields and the at least one of the plurality of second report data fields;

generating a single combined data field if the determining determines there are one or more differences; and

forming a merged report using the combined data field.

11. The method of claim 10, wherein the single combined data field includes information from the first report data field and information from the second report data field, and

wherein the information from the second report data field is presented differently or separate from the information from the first report data field.

12. The method of claim 11, wherein the information from the second report data field is presented in a different font than the information from the first report data field.

13. The method of claim 11, wherein the information from the second report data field is presented in a different color than the information from the first report data field.

14. The method of claim 11, wherein the information from the second report data field is presented in italics.

15. A method for generating a merged lost report, comprising:

receiving, at a server, a lost report, the lost report including lost report information, the lost report information including at least one descriptive term and a customer identification (ID);

determining if the at least one descriptive term matches one of a plurality of generic terms stored in a terms database, each of the plurality of generic terms associated with a generic code;

associating the generic code to the at least one descriptive term if it is determined that the at least one descriptive term matches one of the plurality of generic terms;

determining if the at least one descriptive term matches one of a plurality of product terms if it is determined that the at least one descriptive term does not match one of the plurality of generic terms, each of the plurality of product terms associated with a product code;

associating the product code to the descriptive term if it is determined that the at least one descriptive term matches one of the plurality of product terms; and

associating the at least one descriptive term with at least one main code, the associated main code based upon the associated generic code or product code.

16. The method of claim 15, further comprising locating a found report having found report information, the found report information including at least a customer ID and at least one main code;

and

determining whether the found report customer ID and main code matches the first report customer ID and main code.

17. The method of claim 16, comprising:

comparing the first report information with the found report information to identify one or more differences, the first report information and the found report information having a plurality of data fields;

determining if there are one or more differences between the at least one of the plurality of first report data fields and the at least one of the plurality of found report data fields;

generating a single combined data field if the determining determines there are one or more differences; and

forming a merged report using the combined data field.

18. The method of claim 17, wherein the single combined data field includes information from the first report data field and information from the found report data field, and

wherein the information from the found report data field is presented differently or separate from the information from the first report data field.

19. The method of claim 18, wherein the information from the found report data field is presented in a different font than the information from the first report data field.

20. A program storage device readable by a machine tangibly embodying a program of instructions executable by the machine to perform a method for generating a merged record, the method comprising:

receiving a first report, the first report including first report information, the first report information including at least one descriptive term and a customer identification (ID);

determining if the at least one descriptive term matches one of a plurality of generic terms, each of the plurality of generic terms associated with a generic code

associating the generic code to the at least one descriptive term if it is determined that the at least one descriptive term matches one of the plurality of generic terms;

determining if the at least one descriptive term matches one of a plurality of product terms if it is determined that the at least one descriptive term does not match one of the plurality of generic terms, each of the plurality of product terms associated with a product code;

associating the product code to the descriptive term if it is determined that the at least one descriptive term matches one of the plurality of product terms; and

associating the at least one descriptive term with at least one main code, the associated main code based upon the associated generic code or product code.