본문 바로가기
  • Home

Design of a Hierarchical Dimension of the Bill of Materials Type

  • Journal of The Korea Society of Computer and Information
  • Abbr : JKSCI
  • 2006, 11(4), pp.243-250
  • Publisher : The Korean Society Of Computer And Information
  • Research Area : Engineering > Computer Science

장세현 1 CHOI IN SOO 1 Han-Ju Yoo 1

1숭실대학교

Candidate

ABSTRACT

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.

Citation status

* References for papers published after 2022 are currently being built.