JP2000289813A - Management tag, stock management system, and method thereof - Google Patents

Abstract

PROBLEM TO BE SOLVED: To save labor and shorten a time of grasping the present state of a stock by recording a bar code discriminating the stock, and making the bar code small to an extent that it can be fitted to an exposed part at storing the stock without injuring the stored object. SOLUTION: A bar code discriminating a stock is given to the stock. The bar code together with data related to the stock are registered in a data base, to construct the data base. For the data related to the stock, for example, stock control data and stock place data are mentioned (S1). A management tag recording the bar code discriminating the stock is issued (S2). The management is fitted to the stock to be discriminated by it. When the stock is book or a video tape and the management tag is a bar code label, the management tag is favorably stuck to the place to the stock being harmless in the exposed part at storing it.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a tag, a system and a method for managing a collection using a database system, and more particularly to a management of a collection such as a library, a museum, a museum, and a rental video store. An individual or an organization that can be suitably used for inventory work.

[0002]

2. Description of the Related Art Hitherto, there has been a system and method for attaching a management tag in which a code for identifying a stored item is recorded to the stored item and managing the stored item using a database system. However, the conventional management tag is large compared to the stored items, and the installation place is often restricted.

[0003] For example, when the stored article is a book and the management tag is a barcode label, the barcode label is often larger than the spine of the book and cannot be attached to the spine. In such a case, as shown in FIG. 1, the barcode label is attached to the back cover of the book. However, in general, when storing books in a library or the like, the books are placed on a bookshelf.
If the barcode label is attached to the back cover of the book, the barcode is hidden as shown in FIG. 2, and the barcode cannot be read unless the book is taken out. As a result, when inventorying books at a library or the like, it was necessary to take out the books one by one and read the barcode in order to grasp the current state of the stored items, which required a lot of labor and time. .

[0004] Further, for example, when the storage object is a video tape and the management tag is also a bar code label, it is possible to put a bar code label on the back of the video tape. However, as shown in FIG. 3, the video tape has an erroneous erasure preventing claw 1 as shown in FIG. 3, and a bar code label must be stuck to avoid this to prevent erroneous erasure. Then, a bar code must be attached to the portion of the video tape where title 2 is described,
In the conventional barcode label, a part of the title 2 is obscured and cannot be read. In the end, sticking a conventional barcode label on the back of a videotape would be impossible,
A problem similar to a book will occur.

[0005]

SUMMARY OF THE INVENTION The present invention has been made in order to solve the problems of the prior art, and provides a management system and a management method capable of grasping the current state of a stored item in a stored state. That is the task.

[0006]

In order to achieve the above object, according to the first aspect of the present invention, a bar code for identifying a stored item is recorded, and when a stored item is stored. The management tag is characterized in that it is small enough to be attached to a portion exposed to the outside so as not to harm the stored material.

According to a second aspect of the present invention, there is provided a database system for storing data relating to a stored article including a bar code for identifying the stored article and issuing the management tag according to the first aspect, and the management tag attached to the stored article. A storage management system comprising: a wireless barcode reader that reads a barcode of a stored item. The barcode reader transmits the read barcode to a database system, and the database system transmits the transmitted barcode and the barcode. To collate the data on the collections determined from the data on the work units of reading with the data on the collections stored in the database system, and point out the data on the collections that are inconsistent with each other. The storage management system is characterized by the following.

According to a third aspect of the present invention, there is provided a storage management method using the storage management system according to the second aspect, wherein data relating to the storage including a barcode for identifying the storage is stored by the database system. A step of constructing a database to be executed, a step of issuing the management tag according to claim 1 by a database system, a step of attaching the management tag to an exposed portion of the stored item without damaging the stored item, and a barcode reader. A procedure for reading the barcode of the management tag attached to the storage for each work unit, a procedure for transmitting the barcode read by the barcode reader to the database system, and a procedure for reading the barcode transmitted by the database system. Stored goods determined from data on the unit of work for reading barcodes The procedure for collating data related to stored items in the database system with data related to stored items in the database system and pointing out stored items that are inconsistent with each other, And a procedure for resolving the inconsistency.

[0009]

BEST MODE FOR CARRYING OUT THE INVENTION Management Tag The management tag of the present invention will be described with reference to two embodiments. First, if the stored item is a book and the management tag is a barcode label, the spine will be exposed when the book is stored on the bookshelf, so as shown in FIG. 4, the spine is printed there. Any barcode label that is small enough to be stuck so as not to obscure the information such as the book title or the like is sufficient.
By doing so, when the books are stored in the bookshelf, FIG.
As shown in (1), the barcode is exposed, so that the barcode can be read by a wireless barcode reader without removing the book.

[0010] Next, when the stored material is a video tape and the management tag is a bar code label, the back of the video tape is exposed when stored on a shelf.
As shown in FIG. 7, any barcode label that is small enough to be stuck on the back without covering the erroneous erasure prevention nail 1 and the title 2 may be used. By doing so, the same effect as in the case of a book can be obtained.

2. Storage Management System The storage management system of the present invention includes a database system and a wireless barcode reader. The wireless barcode reader reads the barcode of the management tag attached to the storage and transmits it to the database management system. After the read barcode is temporarily stored in the barcode reader, the barcode may be transmitted collectively and collectively by wire or wireless, or may be transmitted wirelessly each time it is read.

The database system is a computer on which a database management system is installed,
It has a display device such as a liquid crystal display or a CRT display, an input device such as a keyboard and a mouse, as well as an auxiliary storage device for recording a database, and an output device such as a printer and a barcode labeler for issuing a management tag. There is also provided a device and an input device for receiving a barcode transmitted from the barcode reader. The functions of the database system will become apparent in the description of the stored article management method of the present invention.

3. Collection management method The collection management method of the present invention includes a procedure for registering the collection,
It can be broadly divided into the steps for inventory. First, the procedure for registering a stored item will be described with reference to the flowchart of FIG.

STEP 1: Construction of Database First, a bar code for identifying the stored object is given to the stored object. Then, the data relating to the stored item is registered in the database together with the barcode, and the database is constructed. The data on the stored items include, for example, stored item management data and stored item location data. The collection management data includes not only basic data such as the name of the collection, but also data for managing lending such as lending, prohibited lending, and valuables that are being repaired. There is data for managing the state of a stored item, such as being at a certain storage location. The storage location data is data relating to the location where the storage is stored, for example, data indicating on which shelf the storage is stored.

STEP 2: Issuing a management tag A management tag in which a bar code for identifying a stored item is recorded is issued. The management tag may be issued as a barcode label on an output device such as a printer or a barcode labeler attached to the database system.

STEP3: Attachment of the management tag The management tag is attached to the storage identified by the management tag. In the case where the stored object is a book or a video tape and the management tag is a barcode label, the management tag may be attached to a portion that is exposed when the stored object is stored without damaging the stored object. If the object has irregular irregularities such as a sculpture, a barcode label may be attached to a small plastic plate and the plastic plate may be tied to the object with a string.

Next, a procedure for performing an inventory will be described with reference to a flowchart of FIG.

STEP 1: Register a work unit A bar code reading work unit to be performed is registered in the database system. For example, when the stored items are stored on shelves and the barcode of the stored items is read in units of shelves, the shelves are the work units.

STEP 2: Reading a Bar Code A wireless bar code reader reads a bar code of a management tag attached to a storage belonging to a work unit.

STEP 3: Transmit Barcode The barcode read by the barcode reader is transmitted to the database system.

STEP4: Pointing out inconsistency Data relating to the stored items determined from the transmitted barcode and data relating to the bar code reading operation unit by the database system, and data relating to the stored items stored in the database system. Are collated, and data on the stored items that are inconsistent with each other are pointed out. The stored data determined from the transmitted barcode and the data on the barcode reading operation unit is, for example, the storage object existing on the shelf when the shelf is the operation unit. In this case, since the shelf where the collection should exist is registered as the storage location data in the database system, there is no storage that should exist on the shelf or the storage should not exist on the shelf. An inconsistency that an object exists is found, and the inconsistent stored item is displayed on a display or printed by a printer to notify the inventory worker.

SETP5: Resolve inconsistency Resolve inconsistency pointed out by the database system. For example, when the unit of work is a shelf, the inventory worker should move the collection in which the inconsistency was pointed to the original shelf, or correct the storage location data to a shelf that actually exists. To eliminate the inconsistency.

[0023]

As a result of the above, according to the present invention, a bar code for identifying a stored item can be read without taking out the stored item. There is an effect that is performed. As a result, there is an effect that it is easier to resolve the inconsistency between the database system storing the data on the stored items and the actual storage state of the stored items as compared with the conventional technology. .

[Brief description of the drawings]

FIG. 1 is a diagram illustrating that a conventional barcode label is attached to the back cover of a book.

FIG. 2 is a diagram illustrating that a conventional barcode label attached to a back cover is hidden when a book is stored in a bookshelf.

FIG. 3 is a view for explaining inconvenience when a conventional barcode label is attached to a video tape.

FIG. 4 is a diagram illustrating that the management tag of the present invention is attached to the back of a book.

FIG. 5 is a view for explaining that a management tag of the present invention attached to a back is exposed when a book is stored in a bookshelf.

FIG. 6 is a view for explaining how to attach the management tag of the present invention to a video tape.

FIG. 7 is a flowchart illustrating a procedure for registering a stored item.

FIG. 8 is a flowchart illustrating a procedure for performing inventory.

[Explanation of symbols]

 1 ... nails to prevent accidental erasure 2 ... title

Claims (3)

[Claims] 1. A management tag on which a barcode for identifying a stored item is recorded, and which is small enough to be attached to a portion exposed when the stored item is stored without damaging the stored item. 2. A database system for storing management data according to claim 1, storing data relating to the storage including a barcode for identifying the storage, and wirelessly reading the barcode of the management tag attached to the storage. And a bar code reader, wherein the bar code reader transmits the read bar code to a database system, and the database system transmits the transmitted bar code and data relating to a bar code reading operation unit. Collating the data on the stored items determined from the above with the data on the stored items stored in the database system, and pointing out the stored items inconsistent with the data on the stored items. Management system. 3. A storage management method using the storage management system according to claim 2, wherein a database system stores a database for storing data related to the storage including a barcode for identifying the storage. A step of issuing the management tag according to claim 1 by a database system; a step of attaching the management tag to an exposed portion of the collection without damaging the collection; and a step of attaching the management tag to the collection by a barcode reader. Reading the barcode of the management tag obtained for each work unit, transmitting the barcode read by the barcode reader to the database system, and transmitting the barcode and barcode read by the database system Data related to collections determined from data Database data stored in the database system and collating data on those collections to identify inconsistent collections, and inconsistent collections for inconsistent collections. A collection management method, comprising: