Many Internet businesses usually collect hundreds of megabytes of click-stream data everyday and want to analyze these data efficiently. But it is not easy to perform systematic analysis on such a huge amount of data. OLAP can be used for this purpose. It has to precalculate multidimensional summary results in order to get fast response. But as the number of dimensions and sparse cells increase, data explosion occurs seriously and the performance of OLAP decreases. In this paper, we present why this sparsity of web log data occurs and then what kinds of sparsity patterns are in the two and the three dimensions in OLAP. Based on sparsity patterns found we evaluate the performance of three OLAP systems (MS SQL 2000 Analysis Service, Oracle Express and MOLAP with the chunking method).

雑誌名

お茶の水女子大學自然科學報告

巻

53

号

1

ページ

91 - 96

発行年

2002-06

ISSN

00298190

書誌レコードID

AN00033958

フォーマット

application/pdf

形態

1269121 bytes

日本十進分類法

400

出版者

お茶の水女子大学

資源タイプ

紀要論文

資源タイプ・ローカル

紀要論文

資源タイプ・NII

Departmental Bulletin Paper

資源タイプ・DCMI

text

資源タイプ・ローカル表示コード

03

所属

Department of Computer Science and Engineering Ewha Womans University
Department of Computer Science and Engineering Ewha Womans University