SYSTEM AND METHOD FOR CAPTURING AND STORING RFID/SERIALIZED ITEM TRACKING INFORMATION IN A RELATIONAL DATABASE SYSTEM

• US 20070114279A1
• Filed: 09/01/2006
• Published: 05/24/2007
• Est. Priority Date: 09/01/2005
• Status: Abandoned Application

• Current Assignee: Teradata US, Inc. (Teradata Corporation)
• Original Assignee: Teradata US, Inc. (Teradata Corporation)
• Inventors: Jeng, Dennis, Crosby, Mark, Lessing, Pieter, Srikant, Sreedhar
• Application Number:
  US11/469,510
• Publication Number:
  US 20070114279A1
• Time in Patent Office: Days
• US Class Current: 235/385
• CPC Class Codes: G06Q 10/08 Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders
• CPC Class Codes: G06Q 20/203 Inventory monitoring
• CPC Class Codes: G06Q 30/06 Buying, selling or leasing transactions

Abstract

A computer implemented method of and system for capturing, storing and organizing serialized tracking information associated with products sold by a retail enterprise. The serialized tracking information, available through the use of RFID technology, is stored and organized within a relational database in accordance with a logical data model comprising a plurality of entities and relationships defining the manner in which serialized item tracking information associated is stored and organized within the relational database. The relational database, populated with serialized tracking information, provides the retail enterprise with the means to analyze and improve supply chain operations, to better manage store inventory, and more efficiently manage product sales and returns.

Claims

1. A logical data model for managing serialized item tracking information for a retail enterprise, the logical data model including:

a plurality of entities and relationships defining the manner in which serialized item tracking information associated with products sold by said retail enterprise is stored and organized within a relational database.

2. The logical data model in accordance with claim 1, wherein said serialized item tracking information comprises at least one information type selected from the group consisting of:

tracking information concerning movement of products between said retail enterprise and product suppliers;

tracking information concerning movement between internal locations of said retail enterprise; and

tracking information concerning movement of products between said retail enterprise and customers of said retail enterprise.

3. The logical data model in accordance with claim 1, wherein said serialized item tracking information is obtained utilizing RFID technology.

4. The logical data model in accordance with claim 1, wherein said products are tracked by electronic product codes (EPC) affixed to said products.

5. The logical data model in accordance with claim 4, wherein said electronic product codes (EPC) are encoded in RFID tags affixed to said products.

6. A relational database system for storing and managing serialized tracking information for a retail enterprise, said serialized tracking information being organized within said relational database system in accordance with a logical data model, said logical data model comprising:

a plurality of entities and relationships defining the manner in which serialized item tracking information associated with products sold by said retail enterprise is stored and organized within a relational database.

7. The relational database system in accordance with claim 6, wherein said serialized item tracking information comprises at least one information type selected from the group consisting of:

tracking information concerning movement of products between said retail enterprise and product suppliers;

tracking information concerning movement between internal locations of said retail enterprise; and

tracking information concerning movement of products between said retail enterprise and customers of said retail enterprise.

8. The relational database system in accordance with claim 6, wherein said serialized item tracking information is obtained utilizing RFID technology.

9. The relational database system in accordance with claim 6, further wherein said products are identified within said database system by electronic product codes (EPC) affixed to said products.

10. The relational database system in accordance with claim 9, wherein said electronic product codes (EPC) are encoded in RFID tags affixed to said products.

11. A method for storing and managing serialized tracking information for a retail enterprise, said method comprising the steps of:

establishing a relational database for storing and organizing serialized tracking information associated with products sold by said retail enterprise; and

establishing a logical data model including a plurality of entities and relationships defining the manner in which said serialized tracking information is stored and organized within said relational database.

12. The method in accordance with claim 11, wherein said serialized item tracking information comprises at least one information type selected from the group consisting of:

tracking information concerning movement of products between said retail enterprise and product suppliers;

tracking information concerning movement between internal locations of said retail enterprise; and

tracking information concerning movement of products between said retail enterprise and customers of said retail enterprise.

13. The method in accordance with claim 11, further comprising the step of:

identifying said products in said relational database by electronic product codes (EPC) affixed to said products.

14. The method in accordance with claim 13, wherein said electronic product codes (EPC) are encoded in RFID tags affixed to said products;

said method further comprising the step of;

obtaining said serialized item tracking information from said products utilizing RFID technology.