@article{ART001032824},
author={장세현 and CHOI IN SOO and Han-Ju Yoo},
title={Design of a Hierarchical Dimension of the Bill of Materials Type},
journal={Journal of The Korea Society of Computer and Information},
issn={1598-849X},
year={2006},
volume={11},
number={4},
pages={243-250}
TY - JOUR
AU - 장세현
AU - CHOI IN SOO
AU - Han-Ju Yoo
TI - Design of a Hierarchical Dimension of the Bill of Materials Type
JO - Journal of The Korea Society of Computer and Information
PY - 2006
VL - 11
IS - 4
PB - The Korean Society Of Computer And Information
SP - 243
EP - 250
SN - 1598-849X
AB - A recursive relationship is a relationship among entities of the same class. N : M recursive relationships can be used to represent bills of materials. A bill of materials is a special data structure that occurs frequently in manufacturing applications. This data structure is a hierarchy. Most business dimensions have a hierarchical structure. In this study, a design of a hierarchical dimension of the bill of materials type is carried out. As with other N : M relationships, an intersection table that shows pairs of related rows is created, and this table is transformed into a dimension in the OLAP(OnLine Analytical Processing) model. This transformation consists of two tasks: (1)replacing the first column of the intersection table with the lowest level of the dimension; and (2)replacing the second column of the table with the only upper level of the dimension. A case multidimensional information system using the hierarchical dimension is also developed.
KW - 多對多 순환관계(N:M Recursive Relationship);자재소요명세서(Bill of Materials);다차원 분석(OLAP Analysis)
DO -
UR -
ER -
장세현, CHOI IN SOO and Han-Ju Yoo. (2006). Design of a Hierarchical Dimension of the Bill of Materials Type. Journal of The Korea Society of Computer and Information, 11(4), 243-250.
장세현, CHOI IN SOO and Han-Ju Yoo. 2006, "Design of a Hierarchical Dimension of the Bill of Materials Type", Journal of The Korea Society of Computer and Information, vol.11, no.4 pp.243-250.
장세현, CHOI IN SOO, Han-Ju Yoo "Design of a Hierarchical Dimension of the Bill of Materials Type" Journal of The Korea Society of Computer and Information 11.4 pp.243-250 (2006) : 243.
장세현, CHOI IN SOO, Han-Ju Yoo. Design of a Hierarchical Dimension of the Bill of Materials Type. 2006; 11(4), 243-250.
장세현, CHOI IN SOO and Han-Ju Yoo. "Design of a Hierarchical Dimension of the Bill of Materials Type" Journal of The Korea Society of Computer and Information 11, no.4 (2006) : 243-250.
장세현; CHOI IN SOO; Han-Ju Yoo. Design of a Hierarchical Dimension of the Bill of Materials Type. Journal of The Korea Society of Computer and Information, 11(4), 243-250.
장세현; CHOI IN SOO; Han-Ju Yoo. Design of a Hierarchical Dimension of the Bill of Materials Type. Journal of The Korea Society of Computer and Information. 2006; 11(4) 243-250.
장세현, CHOI IN SOO, Han-Ju Yoo. Design of a Hierarchical Dimension of the Bill of Materials Type. 2006; 11(4), 243-250.
장세현, CHOI IN SOO and Han-Ju Yoo. "Design of a Hierarchical Dimension of the Bill of Materials Type" Journal of The Korea Society of Computer and Information 11, no.4 (2006) : 243-250.
