IP Library Granted Patent US 7,083,091
Granted Patent B2
US 7,083,091 · App. 10/785,153 · Granted Aug 1, 2006

Commodity information management program, computer readable medium storing the program, and data structure of commodity classification master database used by the program

Assignee: Fujitsu Limited
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 7,083,091
App. No.
10/785,153
Granted
Aug 1, 2006
Kind
B2
Abstract

In a commodity classification master database for managing commodity classification codes, records containing a commodity classification code showing a current attribute, the level number showing a level of the current attribute in hierarchical structure of attributes and a parent code showing a commodity classification code of the parent code showing the attribute in the immediately higher level defining a broader sense than the current attribute are accumulated. Accepting a commodity classification code and a parent code, a management computer adds a record containing these codes to the commodity classification master database according to a management program.

Claims (21)

1. A commodity information management program for users to retrieve information of their various commodities, said program controlling a computer to be operated as equipment comprising:

first storage that stores a database for defining various attributes, which form a hierarchical structure, of respective commodities, said database including records each of which has fields of a commodity classification code containing the current attribute, a level number containing a level of the current attribute in said hierarchical structure and a parent code containing a commodity classification code showing the parent attribute in the immediately higher level defining a broader sense than the current attribute;

a first accepting portion that accepts information designating said commodity classification code and said parent code through an input device;

an adding portion that adds a record having the commodity classification code and the parent code accepted by said first accepting portion to said first storage as an addition record;

a second accepting portion that accepts information designating one of the other records in said first storage whose parent codes are identical to that of said addition record as a moving-back target record through said input device; and

a moving-back portion that replaces the parent code in said moving-back target record with the commodity classification code in said addition record, increments the level number in said moving-back target record by one, and increments the level numbers in the records that define attributes in lower level defining a narrower sense than that in said moving-back target record by one, respectively.

2. The commodity information management program according to claim 1 controlling a computer to be operated as equipment further comprising:

second storage that stores a database including records each of which has commodity information about each kind of a commodity and a commodity code that consists of said commodity classification codes of the commodity in the respective levels; and

an updating portion that adds the commodity classification code in said addition record to the records in said second storage whose commodity codes include the parent code in said addition record.

3. A commodity information management program for users to retrieve information of their various commodities, said program controlling a computer to be operated as equipment comprising:

first storage that stores a database for defining various attributes, which form a hierarchical structure, of respective commodities, said database including records each of which has fields of a commodity classification code containing a current attribute, a level number containing a level of the current attribute in said hierarchical structure and a parent code containing a commodity classification code showing a parent attribute in the immediately higher level defining a broader sense than the current attribute;

a first accepting portion that accepts information designating the commodity classification code through an input device;

a deleting portion that deletes the records containing the commodity classification code accepted by said third accepting portion as deletion record from said first storage;

a discriminating portion that discriminates whether there is a moving-up target record in said first storage whose parent code is coincident with the commodity classification code in said deletion record; and

a moving-up portion that replaces the parent code in said moving-up target record with the parent code in said deletion record, decrements the level number in said moving-up target record by one, and decrements the level numbers in the records that define attributes in lower level defining a narrower sense than that in said moving-up target record by one, respectively when said discriminating portion discriminated that there is said moving-up target record in said first storage.

4. A computer readable medium that stores a commodity information management program for users to retrieve information of their various commodities, said program controlling a computer to be operated as equipment including:

first storage that stores a database for defining various attributes, which form a hierarchical structure, of respective commodities, said database including records each of which has fields of a commodity classification code containing a current attribute, a level number containing a level of the current attribute in said hierarchical structure and a parent code containing a commodity classification code showing a parent attribute in the immediately higher level defining a broader sense than the current attribute;

a first accepting portion that accepts information designating said commodity classification code and said parent code through an input device;

an addition portion that adds a record recording the commodity classification code and the parent code accepted by said first accepting portion to said first storage as an addition record;

second accepting portion that accepts information designating one of the other records in said first storage whose parent codes are identical to that of said addition record as a moving-back target record through said input device; and

a moving-back portion that replaces the parent code in said moving-back target record with the commodity classification code in said addition record, increments the level number in said moving-back target record by one, and increments the level numbers in the records that define attributes in lower level defining a narrower sense than that in said moving-back target record by one, respectively.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Feb 25, 2004
From: ISHIKAWA, RYUTA; YAMADA, NAOKI
To: FUJITSU LIMITED
Reel/Frame 015020/0955 →
Priority Claims (1)
JP 2003-341303 · Sep 30, 2003 · national
Continuity (1)
Related Publication 20050067491A1 · Mar 31, 2005