Analyzing Enron Data: Bitmap Indexing Outperforms MySQL Queries by Several Orders of Magnitude
Skip to main content
eScholarship
Open Access Publications from the University of California

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

  • Author(s): Stockinger, Kurt
  • Rotem, Doron
  • Shoshani, Arie
  • Wu, Kesheng
  • et al.
Abstract

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.

Main Content
Current View