Analyzing Enron Data: Bitmap Indexing Outperforms MySQL Queries bySeveral Orders of Magnitude

Stockinger, Kurt ; Rotem, Doron ; Shoshani, Arie ; Wu, Kesheng

Lawrence Berkeley National Laboratory

关键词: Data Analysis;    99 General And Miscellaneous//Mathematics, Computing, And Information Science;    Computer Networks;    Information Retrieval;    F Codes;   

DOI  :  10.2172/881612
RP-ID  :  LBNL--59437
RP-ID  :  DE-AC02-05CH11231
RP-ID  :  881612

美国|英语

来源: UNT Digital Library

【 摘 要 】

FastBit is an efficient, compressed bitmap indexing technology that was developed in our group. In this report we evaluate the performance of MySQL and FastBit for analyzing the email traffic of the Enron dataset. The first finding shows that materializing the join results of several tables significantly improves the query performance. The second finding shows that FastBit outperforms MySQL by several orders of magnitude.