Method and apparatus for managing updates to a catalog

• US 7,555,503 B1
• Filed: 06/30/2000
• Issued: 06/30/2009
• Est. Priority Date: 06/30/2000
• Status: Active Grant

• Current Assignee: International Business Machines Corporation
• Original Assignee: Click Commerce, Inc. (Huron Consulting Group Incorporated)
• Inventors: Neal, Michael Renn, Wykes, Nathan Eric, Wilmsen, James Michael, Straub, Ian
• Primary Examiner(s): Le, Debbie M.
• Application Number:
  US09/608,494
• Time in Patent Office: 3,287 Days
• Field of Search: 707 1- 3, 707/9, 707/10, 707100-204, 705/1, 705/16, 705/20, 705/22, 705 26- 29, 705/13, 709200-203, 709217-219
• US Class Current: 1/1
• CPC Class Codes: G06F 16/23 Updating
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: G06Q 30/02 Marketing; Price estimation or determination; Fundraising
• CPC Class Codes: Y10S 707/99954 Version management

Abstract

The present invention provides a method and apparatus for managing updates to a catalog based on a reference electronic catalog. The reference catalog has a reference format and a plurality of items, each with associated characteristics and the second catalog has a second format and a plurality of items, each with associated characteristics. The reference catalog is maintained with updates and revisions to the items and associated characteristics and the second catalog is maintained by repeating the mapping of at least a portion of the reference catalog into the second catalog after maintaining the reference catalog. Preferably, the maintenance times for both catalogs are recorded and the second catalog is maintained by comparing the recorded times and mapping only portions of the reference catalog that have been maintained into the second catalog.

Claims

1. A method of maintaining a catalog based on a reference electronic catalog, the method comprising:

providing a reference catalog that has a reference format and a plurality of items, with each item having associated characteristics stored in one or more data fields associated with the item, wherein the reference catalog is not a list of pointers to data access structures that are used to control access to data;

maintaining the reference catalog with updates and revisions to the items and associated characteristics;

establishing a second catalog format for a second catalog;

mapping at least a portion of the items and associated characteristics of the reference catalog into the second format to create the second catalog;

maintaining, independently of maintaining the reference catalog, the second catalog by repeating the mapping of at least a portion of the reference catalog into the second catalog after maintaining the reference catalog, wherein the second catalog format may be different than the reference format; and

recording the time of each maintenance of the reference catalog and recording the time of each maintenance of the second catalog and wherein maintaining the second catalog comprises comparing the recorded times and mapping only portions of the reference catalog that have been maintained into the second catalog.

2. The method of claim 1 wherein repeating the mapping comprises mapping only portions of the reference catalog that have been maintained into the second catalog.

3. The method of claim 1 wherein recording comprises associating a record with each item of the reference catalog and second catalog, respectively, and wherein maintaining the second catalog comprise comparing the recorded times for each item in the second catalog to the recorded times for each corresponding item in the reference catalog and mapping any changes in the reference catalog that occur after the last change in the second catalog to the second catalog.

6. The method of claim 1 wherein maintaining the second catalog comprises recreating the second catalog by mapping at least a portion of the reference catalog into the second format after maintaining the reference catalog.

7. The method of claim 1 wherein the second format comprises a series of items with associated characteristics, the characteristics being expressed in accordance with a specified style.

8. The method of claim 7 wherein the second catalog characteristics include attributes and categories.

9. The method of claim 7 wherein values for the categories must be selected from a list of possible choices and the list is determined by the format of the second catalog.

10. The method of claim 1 wherein maintaining the reference catalog comprises changing values of characteristics for items in the catalog.

11. The method of claim 1 wherein maintaining the reference catalog comprises mapping values for characteristics into other characteristics.

12. The method of claim 1 wherein maintaining the reference catalog comprises mapping categories for items into other categories.

13. The method of claim 1 wherein maintaining the reference catalog comprises adding new items and associated characteristics to the reference catalog.

4. A method of maintaining a catalog based on a reference electronic catalog, the method comprising:

providing a reference catalog that has a reference format and a plurality of items, with each item having associated characteristics stored in one or more data fields associated with the item, wherein the reference catalog is not a list of pointers to data access structures that are used to control access to data;

maintaining the reference catalog with updates and revisions to the items and associated characteristics;

establishing a second catalog format for a second catalog;

mapping at least a portion of the items and associated characteristics of the reference catalog into the second format to create the second catalog; and

maintaining, independently of maintaining the reference catalog, the second catalog by repeating the mapping of at least a portion of the reference catalog into the second catalog after maintaining the reference catalog, wherein the second catalog format may be different than the reference format;

wherein maintaining the second catalog comprises;

compiling a record of operations performed on the reference catalog and the time that each operation was performed;

compiling a record of operations performed on the second catalog and the time that each operation was performed;

performing the operations on the second catalog that are performed on the reference catalog and that also have a later time than the last operation performed on the second catalog.

5. The method of claim 4 wherein an operation comprises at least one of updating, revising and reformatting characteristics of an item and adding new items.

14. A machine readable medium having stored thereon data representing sequences of instructions, which when executed by the processor cause the processor to perform operations comprising:

providing a reference electronic catalog that has a reference format and a plurality of items, with each item having associated characteristics stored in one or more data fields associated with the item, wherein the reference catalog is not a list of pointers to data access structures that are used to control access to data;

maintaining the reference electronic catalog with updates and revisions to the items and associated characteristics that are stored in one or more data fields associated with the items;

establishing a second electronic catalog format for a second catalog;

mapping at least a portion of the items and associated characteristics of the reference catalog into the second format to create the second catalog;

maintaining the second catalog by repeating the mapping of at least a portion of the reference catalog into the second catalog after maintaining the reference catalog;

establishing a third electronic catalog format for a third catalog;

mapping at least a portion of the items and associated characteristics of the reference catalog into the third format to create the third catalog; and

maintaining the third catalog, independently of maintaining the second catalog and independently of maintaining the reference catalog, by repeating the mapping of at least a portion of the reference catalog into the third catalog after maintaining the reference catalog, wherein the reference format may be different than the second electronic catalog format and the third electronic catalog format; and

recording the time of each maintenance of the reference catalog and recording the time of each maintenance of the second catalog and wherein maintaining the second catalog comprises comparing the recorded times and mapping only portions of the reference catalog that have been maintained into the second catalog.

15. The medium of claim 14 wherein repeating the mapping comprises mapping only portions of the reference catalog that have been maintained into the second catalog.

16. The medium of claim 14 wherein recording comprises associating a record with each item of the reference catalog and second catalog, respectively, and wherein maintaining the second catalog comprise comparing the recorded times for each item in the second catalog to the recorded times for each corresponding item in the reference catalog and mapping any changes in the reference catalog that occur after the last change in the second catalog to the second catalog.

17. The medium of claim 14 wherein maintaining the second catalog comprises recreating the second catalog by mapping at least a portion of the reference catalog into the second format after maintaining the reference catalog.

18. The medium of claim 14 wherein the second format comprises a series of items with associated characteristics, the characteristics being expressed in accordance with a specified style.

19. The medium of claim 18 wherein the second catalog characteristics include attributes and categories.

20. The medium of claim 18 wherein values for the categories must be selected from a list of possible choices and the list is determined by the format of the second catalog.

21. The medium of claim 14 wherein maintaining the reference catalog comprises changing values of characteristics for items in the catalog.

22. The medium of claim 14 wherein maintaining the reference catalog comprises mapping values for characteristics into other characteristics.

23. The medium of claim 14 wherein maintaining the reference catalog comprises mapping categories for items into other categories.

24. The medium of claim 14 wherein maintaining the reference catalog comprises adding new items and associated characteristics to the reference catalog.

25. A machine readable medium having stored thereon data representing, sequences of instructions which, when executed by a processor, cause the processor to perform operations comprising:

providing a reference electronic catalog that has a reference format and a plurality of items, with each item having associated characteristics stored in one or more data fields associated with the item, wherein the reference catalog is not a list of pointers to data access structures that are used to control access to data;

maintaining the reference electronic catalog with updates and revisions to the items and associated characteristics that are stored in one or more data fields associated with the items;

establishing a second electronic catalog format for a second catalog;

mapping at least a portion of the items and associated characteristics of the reference catalog into the second format to create the second catalog;

maintaining the second catalog by repeating the mapping of at least a portion of the reference catalog into the second catalog after maintaining the reference catalog;

establishing a third electronic catalog format for a third catalog;

mapping at least a portion of the items and associated characteristics of the reference catalog into the third format to create the third catalog; and

maintaining the third catalog, independently of maintaining the second catalog and independently of maintaining the reference catalog, by repeating the mapping of at least a portion of the reference catalog into the third catalog after maintaining the reference catalog, wherein the reference format may be different than the second electronic catalog format and the third electronic catalog format;

wherein maintaining the second catalog comprises;

compiling a record of operations performed on the reference catalog and the time that each operation was performed;

compiling a record of operations performed on the second catalog and the time that each operation was performed;

performing the operations on the second catalog that are performed on the reference catalog and that also have a later time than the last operation performed on the second catalog.

26. The medium of claim 25 wherein an operation comprises at least one of updating, revising and reformatting characteristics of an item and adding new items.