본문 바로가기
  • Home

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

  • 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 : Engineering > Computer Science

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

1숭실대학교

Candidate

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.

Citation status

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