2003年 1月 1日 RECURSIVE BACK >> 目次



● Recursive

　A "recursive" structure is a data cluster where instances (within the same entity) are repeated indefinitely.
　The "recursive" structure is decomposed into a binary format of "a parent-child" combination.

　
(1) An examaple of "resource" entity: BOM (Bill of Material)

　
　ＢＯＭ 　01＿02＿04
　　　　　　　｜　　｜
　　　　　　　｜　　｜＿05
　　　　　　　｜
　　　　　　　｜＿03＿06
　　　　　　　　　　｜
　　　　　　　　　　｜＿07


item
　item-NO 　item-NAME

item. item. as recurring
　item-NO (R)
　item-NO (R)		 　amount
　Low-Level Code





　item. item. as recurring

　　　　　　01-02
　　　　　　01-03
　　　　　　02-04
　　　　　　02-05
　　　　　　03-06
　　　　　　03-07






(2) An examaple of "event" entity:

　If and when the sequence number is quoted to the identifier of "order" entity, and an "order" entity occurring later in historical order cancels a previous one, "recursive" should be applied,



order
　order-NO 　order-DATE
　order-amount

order. order. as recurring
　order-NO (R)
　order-NO (R)		 　


order-NO order-DATE order-amount
001 2002/01/10 　100
002 2002/01/20 　120
003 2002/01/23 −100


　"003" cancelled "001", the data in "order. order. as recurring" is:
　(003, 001).

　Examples (for "recursive" structure) might be multiplied indefinitely;
　which program calls which program,
　who is a mentor for who,
　and etc.

　

　 << もどる HOME すすむ >>
　 Ｔ字形ＥＲ手法の英訳