Query Processing on Smart SSDs: Opportunities and Challenges
Data storage devices are getting \"Smarter.\" Smart flash storage devices (a.k.a. \"Smart SSD\") are on the horizon and will package CPU processing and DRAM storage inside a Smart SSD, and make that available to run user programs inside a Smart SSD. The focus of this paper is on exploring the opportunities and challenges associated with exploiting this functionality of Smart SSDs for relational analytic query processing. The authors have implemented an initial prototype of Microsoft SQL Server running on a Samsung Smart SSD. Their results demonstrate that significant performance and energy gains can be achieved by pushing selected query processing components inside the Smart SSDs.