A Data Structuring Technique for Performance Enhancement of Query Processing in the Data Warehouses

이덕근; CHOI IN SOO; 오미화; 조재훈

Journal of The Korea Society of Computer and Information

Abbr : JKSCI
2005, 10(1), pp.7-13
Publisher : The Korean Society Of Computer And Information
Research Area : Computer Science

이덕근 ¹ , CHOI IN SOO ² , 오미화 ³ , 조재훈 ⁴

¹ 숭실대학교
² 숭실대학교
³ 숭실대학교
⁴ 숭실대학교

ABSTRACT

An OLAP(On-Line Analytical Processing) system is the decision support tool with which a user can analyze the information interactively in the various aspects. However, the traditional existing construction of an OLAP system has the inefficiency problem of increasing the processing time and cost caused by the use of complex MDX(Multidimensional Expressions) queries. In an attempt to solve this problem, a new concept of data structuring technique, where a unit column whose elements are all 1 is added to the fact table, was suggested. With the data structuring technique, we can reduce the processing time and cost in OLAP systems.
KEYWORDS

OLAP , MDX , Unit Column
REFERENCES (12)

[journal] / 1998 / “데이터 웨어하우징의 구축과 발전동향 ”제6권 6 : 111~120

[journal] / 1996 / Building the Data Warhouse

[journal] / 1997 / Data Warehousing Concept Paper

[journal] / 1997 / “An Over view of Data Warehousing and OLAP Technology 26 (1) : 65~74

[journal] / 1996 / “On the Computation of Multidimensional Aggregations ” In Proc : 506~521

[journal] / 1998 / “An Alternative Storage Organization for ROLAP Aggregate Views Based on Cubetrees ” In Proc on Management of Data : 249~258

[journal] / 1999 / “Aggregation Algorithms for Very Large Compressed Data Warehouses ” In Proc : 651~662

[journal] / 1997 / “An Array-Based Algorithm for Simultaneous Multidimensional Aggregates ” In Proc on Management of Data : 159~170

[journal] / 2001 / “DW 차원정보 변경에 따른 Historical 데이터 관리 방법 ” 한국통신 통신망연구소 통합망관리 연구팀 / 한국통신 통신망연구소 통합망관리 연구팀

[journal] / “contactolapsolutions+”대림2001 / contact OLAP Solutions +”

[journal] / 2002 / “주관투영도를 활용한 실세계의 추상화 / ” 한국OA학회 제7권 7 : 20~26

[journal] / 2003 / “웹 상에서의 비정형 시스템의 자율적 설계 / ” 한국컴퓨터정보학회 제8권 8 : 64~74
KCI Citation (3)

KJC Korea
Journal Central

Statistics

Tools