2009 Tenth International Conference on Mobile Data Management: Systems, Services and Middleware DigestJoin: Exploiting Fast Random Reads for Flash-Based Joins Taipei, Taiwan May 18-May 20 ISBN: 978-0-7695-3650-7
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/MDM.2009.26
Flash disks have been an emerging secondary storage media. In particular, there have been portable devices, multimedia players and laptop computers that are configured with no magnetic disks but flash disks.It is envisioned that some RDBMSs will operate on flash disks in the near future. However, the I/O characteristics of flash disks are different from those of magnetic disks. Thus, in this paper,we study the core of query processing in RDBMSs --- join processing --- on flash disks. Specifically, we propose a new join method, called DigestJoin, to exploit fast random reads of flashdisks. DigestJoin consists of two phases: (1) projecting the join attributes followed by a join on the projected attributes; and (2)fetching the full tuples that satisfy the join to produce the final join results. While the problem of tuple/page fetching with minimum I/O cost (in the second phase) is intractable, we propose three heuristic fetching strategies. We have implemented DigestJoin on a real flash disk for performance evaluation.Experiments on TPC-H datasets show that DigestJoin clearly outperforms the traditional sort-merge join under various system configurations.
Index Terms:
database, flash disk, ssd, join
Citation:
Yu Li, Sai Tung On, Jianliang Xu, Byron Choi, Haibo Hu, "DigestJoin: Exploiting Fast Random Reads for Flash-Based Joins," mdm, pp.152-161, 2009 Tenth International Conference on Mobile Data Management: Systems, Services and Middleware, 2009 Usage of this product signifies your acceptance of the Terms of Use. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||