JPH0267677A - Low level code maintenance system - Google Patents

Low level code maintenance system

Info

Publication number
JPH0267677A
JPH0267677A JP63220127A JP22012788A JPH0267677A JP H0267677 A JPH0267677 A JP H0267677A JP 63220127 A JP63220127 A JP 63220127A JP 22012788 A JP22012788 A JP 22012788A JP H0267677 A JPH0267677 A JP H0267677A
Authority
JP
Japan
Prior art keywords
information
article
updating
parts list
item
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
JP63220127A
Other languages
Japanese (ja)
Inventor
Tetsuo Makishima
牧島 哲夫
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
NEC Corp
Original Assignee
NEC Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by NEC Corp filed Critical NEC Corp
Priority to JP63220127A priority Critical patent/JPH0267677A/en
Publication of JPH0267677A publication Critical patent/JPH0267677A/en
Pending legal-status Critical Current

Links

Abstract

PURPOSE:To attain updating reducing the frequency of retrieval and that of updating in a parts list and having high processing efficiency by substituting information storing order, generating an updating instruction and optimizing the deleting order of article constituting information of an article past its term of validity. CONSTITUTION:A parts table updating part 1 changes and deletes the registration of corresponding information in accordance with the input of updating information such as article information or the like. When a retrieval request 20 is inputted from the external, a parts list retrieving part 4 retrieves expired article constituting information A-B, B-C, C-D in the parts list from an article constituting information storage part 3 and stores the retrieved result in an extracted information storage part 5 as extracted information together with the low level code of the article. An extracted information arranging part 6 arranges the stored extracted information in the order of slave article low level codes and slave article numbers. The updating part 1 deletes the expired article constituting information in the order of arrangement. Consequently, the updating frequency of the low level code can be sharply reduced as compared to an ordinary method.

Description

【発明の詳細な説明】 〔産業上の利用分野〕 本発明はローレベルコードメンテナンス方式、特に仕様
変更の多発する部品表の管理におけるローレベルコード
メンテナンス方式に関する。
DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a low-level code maintenance method, and particularly to a low-level code maintenance method for managing a parts list that undergoes frequent specification changes.

〔従来の技術〕[Conventional technology]

部品表とは1つの物品を構成するに必要な部分品の情報
表である。部品表は品目(部品そのものの)情報と品目
構成(品目の親子関係の)情報から成る。また、ローレ
ベルコードとは、品目情報の一つとして保持される「最
上位品目からたどって最高で何階層目になるか」の番号
であり、部品表を利用する処理において重要な役割をは
たしている。第3図は部品表とローレベルコードの例を
示している。
A parts list is an information list of parts necessary to construct one article. A parts list consists of item (parts themselves) information and item structure (parent-child relationships of items) information. Furthermore, the low-level code is a number that is kept as part of the item information and indicates the maximum level of the hierarchy from the top-level item, and plays an important role in processing using the bill of materials. There is. FIG. 3 shows an example of a parts list and low-level code.

第3図の部品表は、品目AはBとCから構成され、品目
BはDで構成され、品目CはEで構成され、品目りはE
で構成されている。ローレベルコード(図中でLLCと
表記)は、品目Aは上位品目が無いのでLLC=1 、
品目B、Cのローレベルコードは、共に上位品目Aから
数えて2番目なのでLLC=2、品目りは同様にしてL
LC=3、品目Eは品目Cをたどると3番目だが品目B
、Dでたどると4番目なのでLLC=4になる。
In the parts list in Figure 3, item A is composed of B and C, item B is composed of D, item C is composed of E, and the item number is E.
It is made up of. The low level code (denoted as LLC in the figure) is LLC = 1 because item A has no higher order item.
The low-level codes of items B and C are both second from the higher-level item A, so LLC = 2, and the item number is L in the same way.
LC=3, item E is third after item C, but item B
, D is the fourth location, so LLC=4.

従来から品目構成情報として、このような親子関係の有
効期間を保持しているが、部品表関連の処理効率を向上
させる為には有効期限のきれた品目構成情報を定期的に
削除する必要がある。
Conventionally, the validity period of such parent-child relationships has been retained as item structure information, but in order to improve processing efficiency related to bill of materials, it is necessary to periodically delete item structure information whose validity period has expired. be.

従来のローレベルコードメンテナンス方式では、有効期
限のきれた品目構成情報を検出する度に品目構成情報を
削除し、従ってその度にローレベルコードを更新してい
た。
In the conventional low-level code maintenance method, each time item structure information with an expiration date was detected, the item structure information was deleted, and the low-level code was accordingly updated each time.

例えば、第4図に示すような、単純な部品表11におい
て、全ての品目構成情報(A−BB−C,C−D)が有
効期限されてあり、かつA−B、B−C,C−Dの順で
検出、削除された場合、ローレベルコード更新は部品表
22〜部品表24に示すように6回行われることになる
。しかも、品目C,Dについては繰り返し更新が行なわ
れているだけでなく、そのために部品表の検索を多用す
る。
For example, in a simple parts list 11 as shown in FIG. 4, all item configuration information (A-BB-C, CD) has an expiration date, and If the parts are detected and deleted in the order of -D, the low-level code will be updated six times as shown in the parts list 22 to parts table 24. Moreover, not only are items C and D repeatedly updated, but searches for parts lists are frequently used for this purpose.

〔発明が解決しようとする課題〕[Problem to be solved by the invention]

上述した従来のローレベルコードメンテナンス方式では
、有効期限のきれた品目構成情報を検出する度に削除し
ていたので、共通品目に対するローレベルコードの更新
が多数重複して発生し、処理効率の低下(処理に時間が
かかる)という問題点がある。
In the conventional low-level code maintenance method described above, item configuration information with an expiration date was deleted every time it was detected, which resulted in many duplicate low-level code updates for common items, reducing processing efficiency. There is a problem that (processing takes time).

そこで、本発明は有効期限ぎれの品目構成情報の削除順
序を最適にすることにより、部品表の更新、検索回数を
削減する処理効率のよい方式を提供するものである。
Therefore, the present invention provides an efficient method for reducing the number of parts list updates and searches by optimizing the deletion order of item configuration information whose expiration date has expired.

〔課題を解決するための手段〕[Means to solve the problem]

本発明のローレベルコードメンテナンス方式は、部品表
を構成する複数の品目の間の構成情報を格納する品目構
成情報記憶手段と、 前記部品表の更新指示に応じて前記品目構成情報記憶手
段の更新を行う部品表更新手段と、外部から与えられる
前記部品表の検索要求に応じて前記品目構成情報記憶手
段に格納されてbする情報から対応する情報を検索・抽
出する部品表検索手段と、 前記部品表検索手段によって検索・抽出された情報を格
納する抽出情報記憶手段と、 前記抽出情報記憶手段に格納されている情報の格納順序
を入れ替え、かつ前記更新指示を発する抽出情報整列手
段とを含むことを特徴とする。
The low-level code maintenance method of the present invention includes: an item configuration information storage means for storing configuration information between a plurality of items constituting a bill of materials; and updating of the item configuration information storage means in response to an instruction to update the bill of materials. a parts list updating means for searching and extracting corresponding information from the information stored in the item configuration information storage means in response to a search request for the parts list given from the outside; Extracted information storage means for storing information searched and extracted by the parts list retrieval means; Extracted information sorting means for changing the storage order of the information stored in the extracted information storage means and issuing the update instruction. It is characterized by

〔実施例〕〔Example〕

次に、本発明の実施例について図面を参照して説明する
Next, embodiments of the present invention will be described with reference to the drawings.

第1図は本発明の一実施例を示すブロック図であり、外
部からの更新要求10または抽出情報整列部6からの指
示により、部品表を構成する品目情報及び品目構成情報
の更新を行う部品表更新部1と、部品表の品目情報を格
納する品目情報記憶部2と、部品表の品目構成情報を格
納する品目構成情報記憶部3と、外部からの検索要求2
0に応じて対応する部品表を検索する部品表検索部4と
、検索した部品表のうち品目構成情報とローレベルコー
ドを記憶する抽出情報記憶部5と、抽出情報に格納され
た内容を子品番のローレベルコード順に並べ替える抽出
情報整列部6と、抽出情報記憶部に格納された内容を順
次取り出す抽出情報検索部7とから構成される。
FIG. 1 is a block diagram showing one embodiment of the present invention, in which the item information and item configuration information constituting the parts list are updated in response to an external update request 10 or an instruction from the extracted information sorting unit 6. A table update unit 1, an item information storage unit 2 that stores item information in a bill of materials, an item configuration information storage unit 3 that stores item configuration information in a bill of materials, and a search request 2 from the outside.
0, an extraction information storage unit 5 that stores item configuration information and low-level codes from the searched parts list, and extracts the contents stored in the extracted information as a child. It is composed of an extracted information sorting section 6 that sorts items in the order of low-level codes of product numbers, and an extracted information searching section 7 that sequentially retrieves the contents stored in the extracted information storage section.

品目情報とは品目自体に関する固有の情報、例えば品目
番号1品目名称、製造に要する時間、ローレベルコード
等のデータである。また品目構成情報とは品目と品目の
親子関係に関する固有の情報、例えば親品目番号、子品
目番号、数量関係。
Item information is unique information about the item itself, such as item number, item name, time required for manufacturing, and low-level code. In addition, item structure information is unique information regarding the parent-child relationship between items, such as parent item number, child item number, and quantity relationship.

有効期間等のデータである。This is data such as validity period.

部品表更新部1は上記品目情報1品目構成情報の少なく
とも何れか1つに関する更新情報の入力に応じて、対応
する情報の登録変更および削除を行うものであり、これ
は公知の、メモリ内容の読出し、書込み2部分書込みの
技術により行なわれる。部品表検索部4.抽抽出情報列
部6.抽出情報検索部7も同様の技術により実現される
The parts list update unit 1 changes the registration and deletes the corresponding information in response to the input of update information regarding at least one of the above-mentioned item information and 1-item configuration information. A read/write two-part write technique is used. Parts list search section 4. Extraction information string part 6. The extracted information retrieval unit 7 is also realized by a similar technique.

第2図に本実施例による第4図の部品表の更新処理を示
す。以下第2図を参照しながら本実施例の動作を説明す
る。
FIG. 2 shows the process of updating the parts list shown in FIG. 4 according to this embodiment. The operation of this embodiment will be explained below with reference to FIG.

まず外部から検索要求20が入力すると、部品表検索部
4は品目構成情報記憶部3から部品表より有効期限のき
れた品目構成情報A−B、BC2およびC−Dを検索し
、品目のローレベルコードと共に抽出情報として抽出情
報記憶部5に格納する。
First, when a search request 20 is input from the outside, the parts list search section 4 searches the item structure information storage section 3 for item structure information A-B, BC2, and CD whose expiration date has expired, and loads the item. It is stored in the extraction information storage unit 5 as extraction information together with the level code.

次に、抽出情報整列部6は格納した抽出情報を子品目の
ローレベルコード及び子品目番号の順に整列させる。そ
して、部品表更新部1は品目構成情報記憶部3において
、その整列順に有効期限のきれた品目構成情報の削除を
行う。この結果、本例においてはローレベルコードの更
新回数量だけでも、従来方式の最高6回から、3回に減
らすことができることがわかる。
Next, the extracted information sorting section 6 sorts the stored extracted information in the order of the low level code of the child item and the child item number. Then, the parts list updating unit 1 deletes the item configuration information whose expiration date has expired in the item configuration information storage unit 3 in the sorted order. As a result, it can be seen that in this example, the number of times the low-level code is updated can be reduced from the maximum of six times in the conventional method to three times.

〔発明の効果〕〔Effect of the invention〕

本発明には、有効期限ぎれの品目構成情報の削除順序を
最適化することにより、部品表の検索及び更新回数の少
ない処理対重のよい更新をすることができるという効果
がある。
The present invention has the advantage that by optimizing the deletion order of item configuration information whose expiration date has expired, it is possible to search and update a parts list with less processing and weight.

【図面の簡単な説明】[Brief explanation of the drawing]

第1図は本発明の一実施例を示すブロック図、第2図は
本実施の動作を説明するための図、第3図は部品表とロ
ーレベルコードの概念図、第4図は従来方式によるロー
レベルコード更新例を示す図である。 1・・・部品表更新部、2・・・品目情報記憶部、3・
・・品目構成情報記憶部、4・・・部品表検索部、5・
・・抽出情報記憶部、6・・・抽出情報整列部、7・・
・抽出情報検索部。
Figure 1 is a block diagram showing one embodiment of the present invention, Figure 2 is a diagram for explaining the operation of this implementation, Figure 3 is a conceptual diagram of a parts list and low-level code, and Figure 4 is a conventional system. FIG. 3 is a diagram illustrating an example of low-level code update by. 1... Parts list update section, 2... Item information storage section, 3.
...Item configuration information storage section, 4...Parts list search section, 5.
... Extracted information storage unit, 6... Extracted information alignment unit, 7...
- Extracted information search section.

Claims (1)

【特許請求の範囲】 部品表を構成する複数の品目の間の構成情報を格納する
品目構成情報記憶手段と、 前記部品表の更新指示に応じて前記品目構成情報記憶手
段の更新を行う部品表更新手段と、外部から与えられる
前記部品表の検索要求に応じて前記品目構成情報記憶手
段に格納されている情報から対応する情報を検索・抽出
する部品表検索手段と、 前記部品表検索手段によって検索・抽出された情報を格
納する抽出情報記憶手段と、 前記抽出情報記憶手段に格納されている情報の格納順序
を入れ替え、かつ前記更新指示を発する抽出情報整列手
段とを含むことを特徴とするローレベルコードメンテナ
ンス方式。
[Scope of Claims] Item configuration information storage means for storing configuration information among a plurality of items constituting a parts list; and a parts list that updates the item configuration information storage unit in response to an instruction to update the parts list. an updating means; a parts list retrieval means for searching and extracting corresponding information from information stored in the item configuration information storage means in response to a search request for the parts list given from the outside; and by the parts list retrieval means. It is characterized by comprising an extracted information storage means for storing searched and extracted information, and an extracted information sorting means for changing the storage order of the information stored in the extracted information storage means and issuing the update instruction. Low-level code maintenance method.
JP63220127A 1988-09-01 1988-09-01 Low level code maintenance system Pending JPH0267677A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP63220127A JPH0267677A (en) 1988-09-01 1988-09-01 Low level code maintenance system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP63220127A JPH0267677A (en) 1988-09-01 1988-09-01 Low level code maintenance system

Publications (1)

Publication Number Publication Date
JPH0267677A true JPH0267677A (en) 1990-03-07

Family

ID=16746333

Family Applications (1)

Application Number Title Priority Date Filing Date
JP63220127A Pending JPH0267677A (en) 1988-09-01 1988-09-01 Low level code maintenance system

Country Status (1)

Country Link
JP (1) JPH0267677A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH04229370A (en) * 1990-04-30 1992-08-18 Internatl Business Mach Corp <Ibm> Method and system for processing received order of knowledge base

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH04229370A (en) * 1990-04-30 1992-08-18 Internatl Business Mach Corp <Ibm> Method and system for processing received order of knowledge base

Similar Documents

Publication Publication Date Title
Hu et al. Supporting RFID-based item tracking applications in Oracle DBMS using a bitmap datatype
USRE40520E1 (en) Easily expandable data processing system and method
US7529726B2 (en) XML sub-document versioning method in XML databases using record storages
US5303367A (en) Computer driven systems and methods for managing data which use two generic data elements and a single ordered file
US4933848A (en) Method for enforcing referential constraints in a database management system
EP1393206B1 (en) Data structure for information systems
JPH05165843A (en) Method and system for controlling product structure in manufacturing system utilizing computer
KR20010012305A (en) System and method for storing and manipulating data in an information handling system
JP2000501861A (en) Apparatus and method for storing and retrieving ordered sets of keys in a compact 0 complete tree
US20110022567A1 (en) Method and apparatus for routing data in an automatic identification system
JP2000076105A (en) Time version data storage device
US7409380B1 (en) Facilitated reuse of K locations in a knowledge store
JP4562749B2 (en) Document compression storage method and apparatus
JPH0267677A (en) Low level code maintenance system
EP1116137B1 (en) Database, and methods of data storage and retrieval
JP2004110327A (en) Time series correlation extracting device
JP4152107B2 (en) Database update information reflection system and program therefor
JPH0194429A (en) Hierarchical retrieving system in relational-type data base
JP3980326B2 (en) Data management method and computer-readable recording medium
JPH0934906A (en) Book management device
JPH05257765A (en) Database management system
JP3245873B2 (en) File processing device
JPH06266591A (en) Document managing method
Hobbs et al. Oracle8i data warehousing
JPH041855A (en) Document/drawing control system