System and method for retrieving and normalizing product information

Patent metadata

Field	Value
Publication number	US-9613373-B2
Application number	US-201615196398-A
Country	US
Kind code	B2
Filing date	Jun 29, 2016
Priority date	Dec 7, 2000
Publication date	Apr 4, 2017
Grant date	Apr 4, 2017

Abstract

Systems and a method for retrieving and normalizing product information are described. The system identifies a threshold overlap value defining a value of attribute overlap that triggers a merging of item records. The system accesses a first item record and a second item record stored in a network database, the first item record and the second item record each comprising one or more attributes. The system identifies at least one attribute that is common in both the first item record and the second item record. Finally, the system merges the first item record and second item record into a single item record in response to a level of the at least one attribute identified as being common transgressing the threshold overlap value.

First claim

We claim:

1. A system comprising:
one or more processors and executable instructions accessible on a computer-readable medium that, when executed, cause the one or more processors to perform operations comprising:
identifying a threshold overlap value defining a value of attribute overlap that triggers a merging of item records;
accessing a first item record and a second item record stored in a network database, the first item record and the second item record each comprising one or more attributes;
identifying at least one attribute that is common in both the first item record and the second item record; and
merging the first item record and second item record into a single item record in response to a level of the at least one attribute identified as being common transgressing the threshold overlap value.

2. A method comprising:
identifying a threshold overlap value defining a value of attribute overlap that triggers a merging of item records;
accessing a first item record and a second item record stored in a network database, the first item record and the second item record each comprising one or more attributes;
identifying at least one attribute that is common in both the first item record and the second item record; and
merging the first item record and second item record into a single item record in response to a level of the at least one attribute identified as being common transgressing the threshold overlap value.

3. A non-transitory machine-readable storage medium having embodied thereon instructions executable by one or more processors of a machine that cause the machine to perform operations comprising:
identifying a threshold overlap value defining a value of attribute overlap that triggers a merging of item records;
accessing a first item record and a second item record stored in a network database, the first item record and the second item record each comprising one or more attributes;
identifying at least one attribute that is common in both the first item record and the second item record; and
merging the first item record and second item record into a single item record in response to a level of the at least one attribute identified as being common transgressing the threshold overlap value.

4. The system of claim 1 , wherein the network database is configured to store identifiers for items of each item record, the identifiers selected from a group consisting of a model number, a part number, and a stock keeping number.

5. The system of claim 1 , wherein the network database is configured to store information about attributes of an item of each item record.

6. The system of claim 1 , wherein the database is configured to be utilized in assigning a universal stock keeping number to each item of each item record.

7. The system of claim 1 , wherein the network database is contained in a server coupled to a distributed network.

8. The method of claim 2 , further comprising storing an identifier for an item associated with the single item record, the identifier selected from a group consisting of a model number, a part number, and a stock keeping number.

9. The method of claim 2 , further comprising storing information about attributes of the item associated with the single item record.

10. The method of claim 2 , further comprising assigning a universal stock keeping number to the item associated with the single item record.

11. The non-transitory machine-readable storage medium of claim 3 , further comprising storing an identifier for an item associated with the single item record, the identifier selected from a group consisting of a model number, a part number, and a stock keeping number.

12. The non-transitory machine-readable storage medium of claim 3 , further comprising storing information about attributes of the item associated with the single item record.

13. The non-transitory machine-readable storage medium of claim 3 , further comprising assigning a universal stock keeping number to the item associated with the single item record.

14. The system of claim 4 , wherein the network database comprises a relational database, relationships between the identifiers for the products being stored as a tuple.

15. The system of claim 7 , wherein the distributed network is the Internet.

16. The method of claim 8 , further comprising storing as a tuple, in the network database, a relationship between the identifier for the item associated with the single item record and an identifier for a different item.

17. The method of claim 9 , further comprising transmitting the information to a third-party server, wherein the transmitted information contains the identifier.

18. The non-transitory machine-readable storage medium of claim 11 , further comprising storing as a tuple, in the network database, a relationship between the identifier for the item associated with the single item record and an identifier for a different item.

19. The non-transitory machine-readable storage medium of claim 12 , further comprising transmitting the information to a third-party server, wherein the transmitted information contains the identifier.

20. The system of claim 14 , wherein the network database is controlled by Structured English Query Language.

Assignees

• Paypal Inc

Inventors

• Clendinning Kerry
• Mccartney Michael
• Mengerink Matthew
• Robinette Iv Fred Garfield
• Wilson David J

Classifications

• G06Q30/0641

  utilising user interfaces specially adapted for shopping · CPC title

• G06Q30/0629 Primary

  by pre-processing results, e.g. ranking or ordering results · CPC title

• G06Q10/087

  Inventory or stock management, e.g. order filling, procurement or balancing against orders · CPC title

• G06Q30/0631

  Recommending goods or services · CPC title

• G06F16/211

  Schema design and management · CPC title