{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,5]],"date-time":"2026-06-05T04:10:57Z","timestamp":1780632657858,"version":"3.54.1"},"reference-count":22,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2016,8]]},"abstract":"<jats:p>\n            This paper presents\n            <jats:italic>YourSQL<\/jats:italic>\n            , a database system that accelerates data-intensive queries with the help of additional in-storage computing capabilities. YourSQL realizes very early filtering of data by offloading data scanning of a query to user-programmable solid-state drives. We implement our system on a recent branch of MariaDB (a variant of MySQL). In order to quantify the performance gains of YourSQL, we evaluate SQL queries with varying complexities. Our result shows that YourSQL reduces the execution time of the whole TPC-H queries by 3.6\u00d7, compared to a vanilla system. Moreover, the average speed-up of the five TPC-H queries with the largest performance gains reaches over 15\u00d7. Thanks to this significant reduction of execution time, we observe sizable energy savings. Our study demonstrates that the YourSQL approach, combining the power of early filtering with end-to-end datapath optimization, can accelerate large-scale analytic queries with lower energy consumption.\n          <\/jats:p>","DOI":"10.14778\/2994509.2994512","type":"journal-article","created":{"date-parts":[[2016,9,6]],"date-time":"2016-09-06T15:27:03Z","timestamp":1473175623000},"page":"924-935","source":"Crossref","is-referenced-by-count":98,"title":["YourSQL"],"prefix":"10.14778","volume":"9","author":[{"given":"Insoon","family":"Jo","sequence":"first","affiliation":[{"name":"Samsung Electronics Co."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Duck-Ho","family":"Bae","sequence":"additional","affiliation":[{"name":"Samsung Electronics Co."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Andre S.","family":"Yoon","sequence":"additional","affiliation":[{"name":"Samsung Electronics Co."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jeong-Uk","family":"Kang","sequence":"additional","affiliation":[{"name":"Samsung Electronics Co."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Sangyeun","family":"Cho","sequence":"additional","affiliation":[{"name":"Samsung Electronics Co."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Daniel D. G.","family":"Lee","sequence":"additional","affiliation":[{"name":"Samsung Electronics Co."}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jaeheon","family":"Jeong","sequence":"additional","affiliation":[{"name":"Samsung Electronics Co."}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2016,8]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"Explain output format. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/explain-output.html.  Explain output format. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/explain-output.html."},{"key":"e_1_2_1_2_1","unstructured":"Faster subqueries with materialization. http:\/\/guilhembichot.blogspot.kr\/2012\/04\/faster-subqueries-with-materialization.html.  Faster subqueries with materialization. http:\/\/guilhembichot.blogspot.kr\/2012\/04\/faster-subqueries-with-materialization.html."},{"key":"e_1_2_1_3_1","unstructured":"Index condition pushdown optimization. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/index-condition-pushdown-optimization.html.  Index condition pushdown optimization. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/index-condition-pushdown-optimization.html."},{"key":"e_1_2_1_4_1","unstructured":"Nested-loop join algorithms. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/nested-loop-joins.html.  Nested-loop join algorithms. http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/nested-loop-joins.html."},{"key":"e_1_2_1_5_1","unstructured":"Power manager. http:\/\/www.powermanager.co.kr.  Power manager. http:\/\/www.powermanager.co.kr."},{"key":"e_1_2_1_6_1","unstructured":"Understanding nested loop joins. https:\/\/technet.microsoft.com\/en-us\/library\/ms191318(v=sql.105).aspx.  Understanding nested loop joins. https:\/\/technet.microsoft.com\/en-us\/library\/ms191318(v=sql.105).aspx."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/2505515.2507847"},{"key":"e_1_2_1_8_1","first-page":"36","article-title":"Near-data processing: Insights from a micro-46 workshop","volume":"34","author":"Balasubramonian R.","year":"2014","unstructured":"R. Balasubramonian , J. Chang , T. Manning , J. H. Moreno , R. Murphy , R. Nair , and S. Swanson . Near-data processing: Insights from a micro-46 workshop . Micro , 34 : 36 -- 42 , 2014 . R. Balasubramonian, J. Chang, T. Manning, J. H. Moreno, R. Murphy, R. Nair, and S. Swanson. Near-data processing: Insights from a micro-46 workshop. Micro, 34:36--42, 2014.","journal-title":"Micro"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/2464996.2465003"},{"issue":"9","key":"e_1_2_1_10_1","first-page":"8975","article-title":"Efficient compression techniques for an in memory database system","volume":"3","author":"Desphande H. A.","year":"2015","unstructured":"H. A. Desphande . Efficient compression techniques for an in memory database system . IJIRCCE , 3 ( 9 ): 8975 -- 8983 , 2015 . H. A. Desphande. Efficient compression techniques for an in memory database system. IJIRCCE, 3(9):8975--8983, 2015.","journal-title":"IJIRCCE"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465295"},{"key":"e_1_2_1_12_1","first-page":"1","volume-title":"IBM Redbooks","author":"Francisco P.","year":"2014","unstructured":"P. Francisco . Ibm puredata system for analytics architecture . IBM Redbooks , pages 1 -- 16 , 2014 . P. Francisco. Ibm puredata system for analytics architecture. IBM Redbooks, pages 1--16, 2014."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1109\/ISCA.2016.23"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1109\/MSST.2013.6558444"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/290593.290602"},{"key":"e_1_2_1_16_1","first-page":"36","volume-title":"ADMS","author":"Kim S.","year":"2011","unstructured":"S. Kim , H. Oh , C. Park , S. Cho , and S.-W. Lee . Fast, energy efficient scan inside flash memory . In ADMS , pages 36 -- 43 , 2011 . S. Kim, H. Oh, C. Park, S. Cho, and S.-W. Lee. Fast, energy efficient scan inside flash memory. In ADMS, pages 36--43, 2011."},{"key":"e_1_2_1_17_1","first-page":"14","volume-title":"HotStorage","author":"Lee Y.-S.","year":"2014","unstructured":"Y.-S. Lee , L. C. Quero , Y. Lee , J.-S. Kim , and S. Maeng . Accelerating external sorting via on-the-fly data merge in active SSDs . In HotStorage , pages 14 -- 14 , 2014 . Y.-S. Lee, L. C. Quero, Y. Lee, J.-S. Kim, and S. Maeng. Accelerating external sorting via on-the-fly data merge in active SSDs. In HotStorage, pages 14--14, 2014."},{"key":"e_1_2_1_18_1","first-page":"62","volume-title":"VLDB","author":"Riedel E.","year":"1998","unstructured":"E. Riedel , G. Gibson , and C. Faloutsos . Active storage for large-scale data mining and multimedia . In VLDB , pages 62 -- 73 , 1998 . E. Riedel, G. Gibson, and C. Faloutsos. Active storage for large-scale data mining and multimedia. In VLDB, pages 62--73, 1998."},{"key":"e_1_2_1_19_1","first-page":"1","volume-title":"An Oracle White Paper","author":"Subramaniam M.","year":"2013","unstructured":"M. Subramaniam . A technical overview of the oracle exadata database machine and exadata storage server . An Oracle White Paper , pages 1 -- 43 , 2013 . M. Subramaniam. A technical overview of the oracle exadata database machine and exadata storage server. An Oracle White Paper, pages 1--43, 2013."},{"key":"e_1_2_1_20_1","first-page":"119","volume-title":"FAST","author":"Tiwari D.","year":"2013","unstructured":"D. Tiwari , S. Boboila , S. S. Vazhkudai , Y. Kim , X. Ma , P. J. Desnoyers , and Y. Solihin . Active flash: Towards energy-efficient, in-situ data analytics on extreme-scale machines . In FAST , pages 119 -- 132 , 2013 . D. Tiwari, S. Boboila, S. S. Vazhkudai, Y. Kim, X. Ma, P. J. Desnoyers, and Y. Solihin. Active flash: Towards energy-efficient, in-situ data analytics on extreme-scale machines. In FAST, pages 119--132, 2013."},{"key":"e_1_2_1_21_1","volume-title":"Hadoop: The Definitive Guide","author":"White T.","year":"2009","unstructured":"T. White . Hadoop: The Definitive Guide . O'Reilly Media, Inc. , 1st edition, 2009 . T. White. Hadoop: The Definitive Guide. O'Reilly Media, Inc., 1st edition, 2009."},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732967.2732972"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/2994509.2994512","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,12,28]],"date-time":"2022-12-28T10:51:35Z","timestamp":1672224695000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/2994509.2994512"}},"subtitle":["a high-performance database system leveraging in-storage computing"],"short-title":[],"issued":{"date-parts":[[2016,8]]},"references-count":22,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2016,8]]}},"alternative-id":["10.14778\/2994509.2994512"],"URL":"https:\/\/doi.org\/10.14778\/2994509.2994512","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2016,8]]}}}