Taxonomy and data structure for an electronic procurement system

• US 8,359,245 B1
• Filed: 09/09/2008
• Issued: 01/22/2013
• Est. Priority Date: 01/15/2008
• Status: Active Grant

• Current Assignee: SciQuest Incorporated
• Original Assignee: SciQuest Incorporated
• Inventors: Ballaro, Charles A., Lef, Alexey, Frink, David W.
• Primary Examiner(s): HAQ, NAEEM U
• Application Number:
  US12/283,276
• Time in Patent Office: 1,596 Days
• Field of Search: 705/26.1, 705/26.2, 705/26.25, 705/26.3, 705/26.35, 705/26.4, 705 2641- 2644, 705/26.5, 705 2661- 2664, 705/26.7, 705/26.8, 705/26.81, 705/26.82, 705/26.9, 705/27.1, 705/27.2
• US Class Current: 705/27.1
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: G06Q 30/0603 Catalogue ordering
• CPC Class Codes: G06Q 30/0635 Processing of requisition or of purchase orders
• CPC Class Codes: G06Q 50/163 Real estate management

Abstract

A computer-implemented method is described, performed at a server hosting an electronic procurement system. Supplier catalog data is received at the server from a plurality of respective suppliers associated with the electronic procurement system. The supplier catalog data is in a plurality of formats. The supplier catalog data is converted from the respective plurality of formats to respective common format catalog data. The respective common format catalog data is added to a database.

Claims

1. A computer-implemented method, comprising:

at a server hosting an electronic procurement system,

receiving supplier catalog data from a plurality of respective suppliers associated with the electronic procurement system, where the supplier catalog data is in a plurality of formats;

converting the supplier catalog data from the respective plurality of formats to respective common format catalog data,

adding the respective common format catalog data to a database, wherein the database is stored at the server hosting the electronic procurement system and the database is a staging database; and

wherein;

upon a syndication operation, data in the staging database is transferred to a live catalog database accessible by purchaser users of the system; and

supplier catalog data is mapped into the staging database in a plurality of data blocks, wherein some of the plurality of data blocks are syndicated individually.

2. The method of claim 1, further comprising associating the respective common format catalog data with the respective supplier catalog data.

3. The method of claim 2, wherein associating includes linking the respective supplier catalog data and the respective common format data, such that when the supplier catalog data received at the server changes, the common format catalog data updates accordingly.

4. The method of claim 1, wherein the electronic procurement system is a single instance multi-tenant system.

5. The method of claim 1, wherein the electronic procurement system is a web-based system.

6. The method of claim 1, wherein the server is located independently from suppliers and purchasers of the electronic procurement system.

7. The method of claim 1, wherein the server is located at a supplier of the electronic procurement system.

8. The method of claim 1, wherein the server is located at a purchaser of the electronic procurement system.

9. The method of claim 1, wherein the staging database forms a table in a larger electronic procurement system database.

10. The method of claim 1, wherein the staging database is a stand-alone database.

11. The method of claim 1, wherein the common format catalog data is a stockroom format.

12. The method of claim 1, wherein the supplier catalog data includes item data, standard attributes, and custom attributes.

13. A computer-implemented method, comprising:

at a server hosting an electronic procurement system,

receiving first data from a plurality of respective users associated with the electronic procurement system, where the first data is in a plurality of formats;

converting the first data from the respective plurality of formats to common format second data; and

adding the respective common format second data to a database, wherein the database is stored at the server hosting the electronic procurement system and the database is a staging database; and

transferring data in the staging database to a live database accessible by users of the system;

wherein data is mapped into the staging database in a plurality of data blocks, wherein some of the plurality of data blocks are transferred individually.

14. The method of claim 13, further comprising associating the respective common format second data with the respective user data.

15. The method of claim 13 wherein the first data is one selected from a group consisting of seller catalog data and buyer data.

16. The method of claim 13 wherein the common format second data is in a format native to the electronic procurement system.

17. The method of claim 16, wherein the database is stored at the server hosting the electronic procurement system.

18. The method of claim 17, wherein the database forms a table in a larger electronic procurement system database.

19. The method of claim 17, wherein the database is a stand-alone database.

20. A server system, comprising:

one or more processors;

memory; and

one or more programs stored in the memory, the one or more programs comprising instructions to;

at a server hosting an electronic procurement system;

receive supplier catalog data from a plurality of respective suppliers associated with the electronic procurement system, where the supplier catalog data is in a plurality of formats;

convert the supplier catalog data from the respective plurality of formats to respective common format catalog data, and

add the respective common format catalog data to a database, wherein the database is stored at the server hosting the electronic procurement system and the database is a staging database; and

wherein;

upon a syndication operation, data in the staging database is transferred to a live catalog database accessible by purchaser users of the system; and

supplier catalog data is mapped into the staging database in a plurality of data blocks, wherein some of the plurality of data blocks are syndicated individually.

21. The system of claim 20, further comprising instructions to associate the respective common format catalog data with the respective supplier catalog data.

22. A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer, the one or more programs comprising instructions to:

at a server hosting an electronic procurement system;

receive supplier catalog data from a plurality of respective suppliers associated with the electronic procurement system, where the supplier catalog data is in a plurality of formats;

convert the supplier catalog data from the respective plurality of formats to respective common format catalog data, and

add the respective common format catalog data to a database, wherein the database is stored at the server hosting the electronic procurement system and the database is a staging database; and

wherein;

upon a syndication operation, data in the staging database is transferred to a live catalog database accessible by purchaser users of the system; and

supplier catalog data is mapped into the staging database in a plurality of data blocks, wherein some of the plurality of data blocks are syndicated individually.

23. The computer readable storage medium of claim 22, further comprising instructions to associate the respective common format catalog data with the respective supplier catalog data.

24. A server system, comprising:

one or more processors;

memory; and

one or more programs stored in the memory, the one or more programs comprising instructions to;

at a server hosting an electronic procurement system;

receive first data from a plurality of respective users associated with the electronic procurement system, where the first data is in a plurality of formats;

convert the first data from the respective plurality of formats to common format second data; and

add the respective common format second data to a database, wherein the database is stored at the server hosting the electronic procurement system and the database is a staging database; and

transfer data in the staging database to a live database accessible by users of the system;

wherein data is mapped into the staging database in a plurality of data blocks, wherein some of the plurality of data blocks are transferred individually.

25. The system of claim 24, further comprising instructions to associate the respective common format second data with the respective user data.

26. The system of claim 24, wherein the first data is one selected from a group consisting of seller catalog data and buyer data.

27. The system of claim 24, wherein the common format second data is in a format native to the electronic procurement system.

28. The system of claim 27, wherein the database is stored at the server hosting the electronic procurement system.

29. The system of claim 28, wherein the database forms a table in a larger electronic procurement system database.

30. The system of claim 28, wherein the database is a stand-alone database.

31. A non-transitory computer readable storage medium storing one or more programs configured for execution by a computer, the one or more programs comprising instructions to:

at a server hosting an electronic procurement system;

receive first data from a plurality of respective users associated with the electronic procurement system, where the first data is in a plurality of formats;

convert the first data from the respective plurality of formats to common format second data; and

add the respective common format second data to a database, wherein the database is stored at the server hosting the electronic procurement system and the database is a staging database; and

transfer data in the staging database to a live database accessible by users of the system;

wherein data is mapped into the staging database in a plurality of data blocks, wherein some of the plurality of data blocks are transferred individually.

32. The computer readable storage medium of claim 31, further comprising instructions to associate the respective common format second data with the respective user data.

33. The non-transitory computer readable storage medium of claim 31 wherein the first data is one selected from a group consisting of seller catalog data and buyer data.

34. The non-transitory computer readable storage medium of claim 31 wherein the common format second data is in a format native to the electronic procurement system.

35. The non-transitory computer readable storage medium of claim 34, wherein the database is stored at the server hosting the electronic procurement system.

36. The non-transitory computer readable storage medium of claim 35, wherein the database forms a table in a larger electronic procurement system database.

37. The non-transitory computer readable storage medium of claim 35, wherein the database is a stand-alone database.