Inventory managing method for automatic inventory retrieval and apparatus thereof

a management method and inventory technology, applied in the field of inventory retrieval process, can solve the problems that the inventory retrieval process cannot be always flexibly performed and is difficult to be designated to the databas

Inactive Publication Date: 2001-11-15
FUJITSU LTD
View PDF0 Cites 52 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

In other words, the inventory retrieving process cannot be always flexibly performed.
Thus, conventionally, it is difficult to designate to the database an automa

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Inventory managing method for automatic inventory retrieval and apparatus thereof
  • Inventory managing method for automatic inventory retrieval and apparatus thereof
  • Inventory managing method for automatic inventory retrieval and apparatus thereof

Examples

Experimental program
Comparison scheme
Effect test

second embodiment

[0265] Inventory Information Tree DB

[0266] FIG. 25(A) is a table showing an inventory information tree DB stored in the inventory information tree DB storing unit 101 according to a second embodiment of the present invention.

first embodiment

[0267] In the inventory information tree DB according to the present invention shown in FIG. 2 or 9, a smaller value of node ID is designated to a node in a higher hierarchical level of the inventory information tree. In addition, a smaller node ID is designated to a node at a leftmost position in the same hierarchical level. Thus, a navigation of the inventory retrieving process based on the inventory information tree is configured so that the node ID which has a smaller value will be higher in the order of priority.

[0268] On the other hand, in the second embodiment shown in FIG. 25(A), the priority between different hierarchical levels is defined with the relation of settings in a parent ID field. Moreover, the priority in the same hierarchical level is defined with the relation of settings in a preceding node ID field.

[0269] Thus, corresponding to the settings in the preceding node ID field, the priority of the navigation can be defined as shown in FIG. 25(B).

[0270] With such a s...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

Individual attributes are designated to individual hierarchical levels of an inventory information tree stored in an inventory information tree on-memory structure storing unit. Each node that structures the inventory information tree defines at least the type of an attribute of a commodity, the value thereof, the inventory quantity of the commodity that satisfies a classification condition corresponding to the position on the tree, and the relation with another node. While an inventory retrieving unit is searching each node on the inventory information tree corresponding to a retrieving condition designated with a combination of the attribute of the commodity and the value thereof, the unit executes an inventory retrieving process for updating the inventory quantity of each node. The unit searches nodes with priority corresponding to their positions in hierarchical levels with attributes that are not included in a retrieving condition.

Description

[0001] 1. Field of the Invention[0002] The present invention relates to an inventory retrieving process in a sales circulation business.[0003] 2. Description of the Related Art[0004] An inventory managing technology using a database system is becoming common in sales circulation businesses.[0005] In a table of an inventory management database, each commodity item is registered as one record entry. Each record is composed of a plurality of fields of attributes such as color and size.[0006] When an inventory retrieving process is performed for extracting a desired commodity item that satisfies a particular condition from the database table, inquiry conditions are designated for individual attributes (fields) of the table.[0007] In such a conventional inventory retrieving process, designated attributes affect the result of the inventory retrieving process. In other words, attributes that have not been designated do not affect the result.[0008] Thus, all conditions for an inventory retr...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): B65G1/137B65G61/00G06F17/30G06Q10/08G06Q30/06G06Q50/00G06Q50/10G06Q50/28
CPCG06F17/30595G06Q10/087G06Q10/0875G06Q20/203Y10S707/99931G06F16/284
Inventor UEHARA, TADAHIROYOSHIDA, HIROYUKIYAMAMOTO, RIEKOSAKURAI, HIROSHI
Owner FUJITSU LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap