Tracking physical inventory of data storage media

• US 7,660,812 B2
• Filed: 09/02/2005
• Issued: 02/09/2010
• Est. Priority Date: 09/02/2005
• Status: Expired due to Fees

• Current Assignee: Imation Corporation (Glassbridge Enterprises, Inc.)
• Original Assignee: Imation Corporation (Glassbridge Enterprises, Inc.)
• Inventors: Findlay, Brian D., Lala Balaji, Purushotham G.
• Primary Examiner(s): Vital; Pierre M
• Assistant Examiner(s): Vo; Truong V
• Application Number:
  US11/219,044
• Publication Number:
  US 20070055686A1
• Time in Patent Office: 1,621 Days
• Field of Search: 707/102
• US Class Current: 1/1
• CPC Class Codes: G06Q 10/087 Inventory or stock management, e.g. order filling, procurement or balancing against orders

Abstract

The invention is directed to a business technique for supplying customers with a set of data storage media and a database for tracking physical inventory of the set of data storage media. The media tracking database is generated by the media supplier from a proprietary manufacturer database that stores a unique identification number, volume/serial (VolSer) number, purchase order data, and other manufacturing data. Accordingly, the media tracking database includes a subset of the plurality of fields that form the manufacturer database. Specifically, the media tracking database is populated with the manufacturer assigned unique identification umber, VolSer number, and purchase order data for each of the data storage media prior to selling the database to the customer. When the customer receives the media tracking database, it can be relationally linked to tape management, library management, and off-site storage software thereby providing complete cradle-to-grave traceability of the set of data storage media.

Claims

1. A method comprising:

generating a non-proprietary media tracking database for tracking a set of data storage media;

populating one or more fields of the non-proprietary media tracking database with manufacturer-assigned unique identification numbers for each of the data storage media, wherein the manufacturer-assigned unique identification numbers are unique for all media manufactured by a media supplier, and wherein the unique identification numbers for each of the data storage media are stored in readable radio frequency identification (RFID) tags affixed to or within housings of the data storage media, the RFID tags being selected from a group consisting of international organization for standardization (ISO) 18000 tags and AutoID Center electronic product code (EPC) tags;

populating one or more fields of the non-proprietary media tracking database with VolSer numbers for each of the data storage media, wherein the VolSer numbers are not unique for all media manufactured by the media supplier;

populating one or more fields of the non-proprietary media tracking database with purchase order numbers for each of the storage media;

populating one or more fields of the non-proprietary media tracking database with manufacturing data for each of the data storage media;

populating one or more fields of the non-proprietary media tracking database with one or more performance data, usage data, and physical inventory data;

defining the manufacturer-assigned unique identification numbers as primary keys of the non-proprietary media tracking database for each of the data storage media such that the manufacturer-assigned unique identification numbers are relationally linked to the VolSer numbers, the purchase order numbers and the manufacturing data for each of the data storage media; and

selling the set of data storage media with the non-proprietary media tracking database to an end user.

2. The method of claim 1, wherein the non-proprietary media tracking database is relationally linked to at least one of a customer tape management software, library management software, and off-site storage software.

3. The method of claim 1, wherein the non-proprietary media tracking database comprises a subset of fields of a proprietary manufacturer database that stores manufacturing information for the set of data storage media and wherein the non-proprietary media tracking database is relationally linked to the proprietary manufacturer database.

4. The method of claim 1, wherein generating and populating the non-proprietary media tracking database comprises generating and populating the non-proprietary media tracking database prior to selling the non-proprietary media tracking database and the set of data storage media.

5. The method of claim 1, further comprising maintaining the non-proprietary media tracking database to track physical inventory of the set of data storage media, wherein maintaining the media tracking database comprises:

reading identification tags that store the unique identification numbers on each data storage media; and

populating appropriate fields of the non-proprietary media tracking database with one or more of physical inventory data, performance data, and usage data.

13. The method of claim 1, wherein generating the non-proprietary media tracking database is performed by a computer system, populating the non-proprietary media tracking database is performed by the computer system, and defining the manufacturer-assigned unique identification numbers as the primary keys is performed by the computer system.

6. A system for tracking physical inventory of a set of data storage media comprising:

a set of data storage media wherein the data storage media include unique identifiers that store manufacturer-assigned unique identification numbers, wherein the manufacturer-assigned unique identification numbers are unique for all media manufactured by a media supplier, and wherein the unique identifiers comprise identifiers associated with readable radio frequency identification (RFID) tags affixed to or within housings of the data storage media, the RFID tags being selected from a group consisting of international organization for standardization (ISO) 18000 tags and an AutoID Center electronic product code (EPC) tags; and

a non-proprietary media tracking database comprising a first field that includes manufacturer-assigned unique identification numbers, wherein the manufacturer-assigned unique identification numbers are unique for all media manufactured by a media supplier, wherein a second field of the non-proprietary media tracking database includes VolSer numbers for each of the data storage media, wherein the VolSer numbers are not unique for all media manufactured by the media supplier, wherein a third field of the non-proprietary media tracking database includes purchase order numbers for each of the data storage media, wherein a fourth field of the non-proprietary media tracking database includes manufacturing data for each of the data storage media, wherein one or more additional fields of the non-proprietary media tracking database include one or more of performance data, usage data, and physical inventory data, wherein the manufacturer-assigned unique identification numbers are defined as primary keys of the non-proprietary media tracking database for each of the data storage media such that the manufacturer-assigned unique identification numbers are relationally linked to the VolSer numbers, the purchase order numbers and the manufacturing data for each of the data storage media.

7. The system of claim 6, further comprising at least one of a customer tape management software, library management software, and off-site storage software that is relationally linked to the non-proprietary media tracking database.

8. The system of claim 6 wherein the non-proprietary media tracking database is relationally linked to a proprietary media tracking database, wherein the fields of the non-proprietary media tracking comprise a subset of fields of the proprietary media tracking database.

9. The system of claim 6, wherein the first field of the non-proprietary media tracking database is populated with the unique identification numbers prior to selling the set of data storage media to the end user with the non-proprietary media tracking database.

10. The system of claim 6, further comprising:

means for reading the unique identifiers on each data storage media to identify the data storage media.

11. The system of claim 6, wherein the non-proprietary media tracking database provides cradle-to-grave traceability of the data storage media.

12. The system of claim 6, further comprising a physical inventory system that updates one or more fields of the non-proprietary media tracking database in real-time when the data storage media are transported into and out of drives, when data is read from and written to the data storage media, and when the data storage media is transferred to a storage facility.