System and method for migrating data in an electronic commerce system

• US 7,299,255 B2
• Filed: 12/22/2000
• Issued: 11/20/2007
• Est. Priority Date: 09/26/2000
• Status: Expired due to Fees

• Current Assignee: JDA Software Group Incorporated (RedPrairie Holding Incorporated)
• Original Assignee: i2 Technologies US Incorporated (Panasonic Holdings Corporation)
• Inventors: Tenorio, Manoel
• Primary Examiner(s): WORJLOH, JALATEE
• Application Number:
  US09/745,374
• Publication Number:
  US 20020082945A1
• Time in Patent Office: 2,524 Days
• Field of Search: 705/1, 705/26, 707/1, 707/200, 709/201, 709/218
• US Class Current: 709/201
• CPC Class Codes: G06F 16/2228 Indexing structures
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 30/0639 Item locations
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A method for migrating product data within an electronic commerce system (10) includes monitoring requests for products by users (20) of a global content directory (42). The global content directory (42) includes a directory structure (44) including a number of product classes organized in a hierarchy. Each product class categorizes a plurality of products and defines one or more attributes of the products categorized in the product class. The directory (44) also includes one or more pointers associated with each product class. Each pointer identifies a seller database (32) in which product data enabling a product transaction is stored for products associated with the product class. The method further includes identifying the location of a user (20) and determining that product data associated with a product requested by the user (20) should be migrated from a seller database (32) to a storage location closer to the user than the seller database (32). The method also includes initiating the migration of the product data from the seller database (32) to the storage location.

Claims

1. A method for migrating product data within an electronic commerce system, comprising:

monitoring requests for product data by users of a global content directory, the global content directory comprising;

a directory structure comprising a plurality of product classes organized in a hierarchy, each product class categorizing a plurality of products and defining one or more attributes of the products categorized in the product class; and

one or more pointers associated with each product class, each pointer identifying a seller database in which product data enabling a product transaction is stored for products associated with the product class;

generating a request history for each of the users based on a prediction from the request history, the request history comprises the number of requests by each of the users that result in the user accessing a particular seller database;

identifying the location of a particular user;

determining, based at least in part on the request history for the particular user and a relative size of an organization associated with the particular user, whether some or all of the product data requested by the particular user should be migrated from a seller database to a storage location that is located closer to the identified location of the particular user than the seller database, the determination is based at least in part on the number of times the particular user has requested the product data within a specified period of time; and

initiating the migration of some or all of the product data requested by the particular user from the seller database to the storage location, determined for the particular user, that is located closer to the identified location of the particular user than the seller database.

2. The method of claim 1, wherein a request for product data by a user comprises a selection of a product from search results obtained from one or more seller databases by the global content directory and communicated to the user.

3. The method of claim 1, wherein the product data that is migrated to the storage location determined for the particular user comprises product data associated with a particular product.

4. The method of claim 1, wherein the product data that is migrated to the storage location determined for the particular user comprises product data associated with each of a plurality of products included in a product class.

5. The method of claim 1, further comprising:

determining that the product data should no longer be stored at the storage location determined for the particular user; and

allowing the product data to be deleted or overwritten with other product data at the storage location determined for the particular user.

6. The method of claim 5, wherein determining that the product data should no longer be stored at the storage location determined for the particular user comprises determining that the particular user has not requested the product data for a specified period of time.

7. The method of claim 5, wherein determining that the product data should no longer be stored at the storage location determined for the particular user comprises determining that the storage location determined for the particular user is needed for migration and storage of product data for a second user.

8. The method of claim 1, wherein the migrated product data is stored for access by each of a subset of the users and the method comprises:

identifying the location of each of the users in the subset of users; and

determining the storage location for the product data based on the identified locations of each of the subset of users.

9. The method of claim 8, wherein the location of each of the subset of users is weighted in the determination of the storage location based on the relative frequency with which each of the subset of users requests the product data.

10. The method of claim 1, wherein determining that product data should be migrated comprises determining that product data from a plurality of seller databases should be migrated to the same storage location.

11. The method of claim 10, further comprising merging the data from the plurality of seller databases into a single database at the storage location.

12. The method of claim 1, wherein the product data is migrated to a computer associated with the particular user of the global content directory.

13. The method of claim 12, wherein the product data is stored inside a firewall of the computer.

14. The method of claim 1, wherein initiating the migration of the product data comprises instructing the seller database to copy the product data for caching at the storage location determined for the particular user.

15. The method of claim 14, further comprising instructing the seller database to create a pointer to the storage location determined for the particular user and to update the migrated product data using the pointer when the product data is updated in the seller database.

16. Software for migrating product data within an electronic commerce system, the software embodied in a computer-readable medium and operable to:

monitor requests for product data by users of a global content directory, the global content directory comprising;

a directory structure comprising a plurality of product classes organized in a hierarchy, each product class categorizing a plurality of products and defining one or more aftributes of the products categorized in the product class; and

one or more pointers associated with each product class, each pointer identifying a seller database in which product data enabling a product transaction is stored for products associated with the product class;

generate a request history for each of the users based on the monitoring of the requests for product data by the users;

identify the location of a particular user;

determine, based at least in part on the request history for the particular user and a relative size of an organization associated with the particular user, whether some or all of the product data requested by the particular user should be migrated from a seller database to a storage location that is located closer to the identified location of the particular user than the seller database, the determination is based at least in part on the number of times the particular user has requested the product data within a specified period of time; and

initiate the migration of some or all of the product data requested by the particular user from the seller database to the storage location, determined for the particular user, that is located closer to the identified location of the particular user than the seller database.

17. The software of claim 16, wherein a request for product data by a user comprises a selection of a product from search results obtained from one or more seller databases by the global content directory and communicated to the user.

18. The software of claim 16, wherein the product data that is migrated to the storage location determined for the particular user comprises product data associated with a particular product.

19. The software of claim 16, wherein the product data that is migrated to the storage location determined for the particular user comprises product data associated with each of a plurality of products included in a product class.

20. The software of claim 16, further operable to:

determine that the product data should no longer be stored at the storage location determined for the particular user; and

allowing the product data to be deleted or overwritten with other product data at the storage location determined for the particular user.

21. The software of claim 20, wherein determining that the product data should no longer be stored at the storage location determined for the particular user comprises determining that the particular user has not requested the associated product for a selected period of time.

22. The software of claim 20, wherein determining that the product data should no longer be stored at the storage location determined for the particular user comprises determining that the storage location determined for the particular user is needed for migration and storage of product data for a second user.

23. The software of claim 16, wherein the migrated product data is stored for access by each of a subset of the users and the software is operable to:

identify the location of each of the users in the subset of users; and

determine the storage location for the product data based on the identified locations of each of the subset of users.

24. The software of claim 23, wherein the location of each of the subset of users is weighted in the determination of the storage location based on the relative frequency with which each of the subset of users requests the product data.

25. The software of claim 16, wherein determining that product data should be migrated comprises determining that product data from a plurality of seller databases should be migrated to the same storage location.

26. The software of claim 25, further operable to merge the data from the plurality of seller databases into a single database at the storage location.

27. The software of claim 16, wherein the product data is migrated to a computer associated with the particular user of the global content directory.

28. The software of claim 27, wherein the product data is stored inside a firewall of the computer.

29. The software of claim 16, wherein initiating the migration of the product data comprises instructing the seller database to copy the product data for caching at the storage location determined for the particular user.

30. The software of claim 29, further operable to instruct the seller database to create a pointer to the storage location determined for the particular user and to update the migrated product data using the pointer when the product data is updated in the seller database.

31. A method for migrating product data in an electronic commerce system, comprising:

monitoring requests for product data by users of a global content directory, the requests each comprising a selection of a product from search results obtained from one or more seller databases by the global content directory and communicated to the user, the global content directory comprising;

a directory structure comprising a plurality of product classes organized in a hierarchy, each product class categorizing a plurality of products and defining one or more attributes of the products categorized in the product class; and

one or more pointers associated with each product class, each pointer identifying a seller database in which product data enabling a product transaction is stored for products associated with the product class;

generating a request history for each of the users based on the monitoring of the requests for product data by the users;

identifying the location of a particular user;

determining, based at least in part on the request history for the particular user and a relative size of an organization associated with the particular user, whether some or all of the product data requested by the particular user should be migrated from a seller database to a storage location that is located closer to the identified location of the particular user than the seller database based at least in part on the number of times the particular user has requested the product data within a specified period of time; and

instructing the seller database to;

copy some or all of the product data requested by the particular user for caching at the storage location, determined for the particular user, that is located closer to the identified location of the particular user than the seller database;

create a pointer to the storage location, determined for the particular user, that is located closer to the identified location of the particular user than the seller database;

update the migrated product data using the pointer when the product data is updated in the seller database.

32. Software for migrating product data within an electronic commerce system, the software embodied in a computer-readable medium and operable to:

monitor requests for product data by users of a global content directory, the requests each comprising a selection of a product from search results obtained from one or more seller databases by the global content directory and communicated to the user, the global content directory comprising;

a directory structure comprising a plurality of product classes organized in a hierarchy, each product class categorizing a plurality of products and defining one or more attributes of the products categorized in the product class; and

one or more pointers associated with each product class, each pointer identifying a seller database in which product data enabling a product transaction is stored for products associated with the product class;

generate a request history for each of the users based on the monitoring of the requests for product data by the users;

identify the location of a particular user;

determine, based at least in part on the request history for the particular user and a relative size of an organization associated with the particular user, whether some or all of the product data requested by the particular user should be migrated from a seller database to a storage location that is located closer to the identified location of the particular user than the seller database based at least in part on the number of times the particular user has requested the product data within a specified period of time; and

instruct the seller database to;

copy some or all of the product data requested by the particular user for caching at the storage location, determined for the particular user, that is located closer to the identified location of the particular user than the seller database;

create a pointer to the storage location, determined for the particular user, that is located closer to the identified location of the particular user than the seller database;

update the migrated product data using the pointer when the product data is updated in the seller database.