@article{ART001315110},
author={Seunghyun Lee and 이덕성 and CHOI IN SOO},
title={Applying an Aggregate Function AVG to OLAP Cubes},
journal={Journal of The Korea Society of Computer and Information},
issn={1598-849X},
year={2009},
volume={14},
number={1},
pages={217-228}
TY - JOUR
AU - Seunghyun Lee
AU - 이덕성
AU - CHOI IN SOO
TI - Applying an Aggregate Function AVG to OLAP Cubes
JO - Journal of The Korea Society of Computer and Information
PY - 2009
VL - 14
IS - 1
PB - The Korean Society Of Computer And Information
SP - 217
EP - 228
SN - 1598-849X
AB - Data analysis applications typically aggregate data across many dimensions looking for unusual patterns in data. Even though such applications are usually possible with standard structured query language (SQL) queries, the queries may become very complex. A complex query may result in many scans of the base table, leading to poor performance. Because online analytical processing (OLAP) queries are usually complex, it is desired to define a new operator for aggregation, called the data cube or simply cube.
Data cube supports OLAP tasks like aggregation and sub-totals. Many aggregate functions can be used to construct a data cube. Those functions can be classified into three categories, the distributive, the algebraic, and the holistic. It has been thought that the distributive functions such as SUM, COUNT, MAX, and MIN can be used to construct a data cube, and also the algebraic function such as AVG can be used if the function is replaced to an intermediate function. It is believed that even though AVG is not distributive, but the intermediate function (SUM, COUNT) is distributive, and AVG can certainly be computed from (SUM, COUNT).
In this paper, however, it is found that the intermediate function (SUM, COUNT) cannot be applied to OLAP cubes, and consequently the function leads to erroneous conclusions and decisions. The objective of this study is to identify some problems in applying aggregate function AVG to OLAP cubes, and to design a process for solving these problems.
KW - Aggrigate Function;AVG;Average;OLAP Cubes;Algebraic;Distributive;Base table
DO -
UR -
ER -
Seunghyun Lee, 이덕성 and CHOI IN SOO. (2009). Applying an Aggregate Function AVG to OLAP Cubes. Journal of The Korea Society of Computer and Information, 14(1), 217-228.
Seunghyun Lee, 이덕성 and CHOI IN SOO. 2009, "Applying an Aggregate Function AVG to OLAP Cubes", Journal of The Korea Society of Computer and Information, vol.14, no.1 pp.217-228.
Seunghyun Lee, 이덕성, CHOI IN SOO "Applying an Aggregate Function AVG to OLAP Cubes" Journal of The Korea Society of Computer and Information 14.1 pp.217-228 (2009) : 217.
Seunghyun Lee, 이덕성, CHOI IN SOO. Applying an Aggregate Function AVG to OLAP Cubes. 2009; 14(1), 217-228.
Seunghyun Lee, 이덕성 and CHOI IN SOO. "Applying an Aggregate Function AVG to OLAP Cubes" Journal of The Korea Society of Computer and Information 14, no.1 (2009) : 217-228.
Seunghyun Lee; 이덕성; CHOI IN SOO. Applying an Aggregate Function AVG to OLAP Cubes. Journal of The Korea Society of Computer and Information, 14(1), 217-228.
Seunghyun Lee; 이덕성; CHOI IN SOO. Applying an Aggregate Function AVG to OLAP Cubes. Journal of The Korea Society of Computer and Information. 2009; 14(1) 217-228.
Seunghyun Lee, 이덕성, CHOI IN SOO. Applying an Aggregate Function AVG to OLAP Cubes. 2009; 14(1), 217-228.
Seunghyun Lee, 이덕성 and CHOI IN SOO. "Applying an Aggregate Function AVG to OLAP Cubes" Journal of The Korea Society of Computer and Information 14, no.1 (2009) : 217-228.