Query processing on smart SSDs: Opportunities and challenges

Jaeyoung Do, Yang Suk Kee, Jignesh M. Patel, Chanik Park, Kwanghyun Park, David J. DeWitt

    Research output: Chapter in Book/Report/Conference proceedingConference contribution

    Abstract

    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. We have implemented an initial prototype of Microsoft SQL Server running on a Samsung Smart SSD. Our results demonstrate that significant performance and energy gains can be achieved by pushing selected query processing components inside the Smart SSDs. We also identify various changes that SSD device manufacturers can make to increase the benefits of using Smart SSDs for data processing applications, and also suggest possible research opportunities for the database Community.

    Original languageEnglish
    Title of host publicationSIGMOD 2013 - International Conference on Management of Data
    Pages1221-1230
    Number of pages10
    DOIs
    Publication statusPublished - 2013
    Event2013 ACM SIGMOD Conference on Management of Data, SIGMOD 2013 - New York, NY, United States
    Duration: 2013 Jun 222013 Jun 27

    Publication series

    NameProceedings of the ACM SIGMOD International Conference on Management of Data
    ISSN (Print)0730-8078

    Conference

    Conference2013 ACM SIGMOD Conference on Management of Data, SIGMOD 2013
    Country/TerritoryUnited States
    CityNew York, NY
    Period13/6/2213/6/27

    All Science Journal Classification (ASJC) codes

    • Software
    • Information Systems

    Fingerprint

    Dive into the research topics of 'Query processing on smart SSDs: Opportunities and challenges'. Together they form a unique fingerprint.

    Cite this