@article{ART001047461},
author={Han-Ju Yoo and 이덕성 and CHOI IN SOO},
title={A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing},
journal={Journal of The Korea Society of Computer and Information},
issn={1598-849X},
year={2007},
volume={12},
number={1},
pages={179-190}
TY - JOUR
AU - Han-Ju Yoo
AU - 이덕성
AU - CHOI IN SOO
TI - A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing
JO - Journal of The Korea Society of Computer and Information
PY - 2007
VL - 12
IS - 1
PB - The Korean Society Of Computer And Information
SP - 179
EP - 190
SN - 1598-849X
AB - A star schema consists of a central fact table, which is surrounded by one or more dimension tables. Each row in the fact table contains a multi-part primary key(or a composite foreign key) along with one or more columns containing various facts about the data stored in the row. Each of the composit foreign key components is related to a dimensional table. The combination of keys in the fact table creates a composite foreign key that is unique to the fact table record. The composite foreign key, however, is rarely unique to the fact table record in real-world applications, particularly in financial applications. In order to make the composite foreign key be the determinant in real-world application, some precalculation might be performed in the SQL relational database, and cached in the OLAP database. However, there are many drawbacks to this approach. In some cases, this approach might give users the wrong results. In this paper, an approach to fact table modeling and related MDX query composing, which can be used in real-world applications without performing any precalculation and gives users the correct results, is proposed.
KW - 1 對 多 관계(1 : N Relationship);금융 애플리케이션(Financial Applications);선처리(Precalculation);다차원 분석(OLAP Analysis);MDX 쿼리 작성법(MDX Query Composing)
DO -
UR -
ER -
Han-Ju Yoo, 이덕성 and CHOI IN SOO. (2007). A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing. Journal of The Korea Society of Computer and Information, 12(1), 179-190.
Han-Ju Yoo, 이덕성 and CHOI IN SOO. 2007, "A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing", Journal of The Korea Society of Computer and Information, vol.12, no.1 pp.179-190.
Han-Ju Yoo, 이덕성, CHOI IN SOO "A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing" Journal of The Korea Society of Computer and Information 12.1 pp.179-190 (2007) : 179.
Han-Ju Yoo, 이덕성, CHOI IN SOO. A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing. 2007; 12(1), 179-190.
Han-Ju Yoo, 이덕성 and CHOI IN SOO. "A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing" Journal of The Korea Society of Computer and Information 12, no.1 (2007) : 179-190.
Han-Ju Yoo; 이덕성; CHOI IN SOO. A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing. Journal of The Korea Society of Computer and Information, 12(1), 179-190.
Han-Ju Yoo; 이덕성; CHOI IN SOO. A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing. Journal of The Korea Society of Computer and Information. 2007; 12(1) 179-190.
Han-Ju Yoo, 이덕성, CHOI IN SOO. A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing. 2007; 12(1), 179-190.
Han-Ju Yoo, 이덕성 and CHOI IN SOO. "A Nonunique Composite Foreign Key-Based Approach to Fact Table Modeling and MDX Query Composing" Journal of The Korea Society of Computer and Information 12, no.1 (2007) : 179-190.
