{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,2,21]],"date-time":"2026-02-21T18:57:16Z","timestamp":1771700236345,"version":"3.50.1"},"reference-count":35,"publisher":"Association for Computing Machinery (ACM)","issue":"2","license":[{"start":{"date-parts":[[2015,8,12]],"date-time":"2015-08-12T00:00:00Z","timestamp":1439337600000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["SIGMOD Rec."],"published-print":{"date-parts":[[2015,8,12]]},"abstract":"<jats:p>The increase in the capacity of main memory coupled with the decrease in cost has fueled research in and development of in-memory databases. In recent years, the emergence of new hardware has further given rise to new challenges which have attracted a lot of attention from the research community. In particular, it is widely accepted that hardware solutions can provide promising alternatives for realizing the full potential of in-memory systems. Here, we argue that naive adoption of hardware solutions does not guarantee superior performance over software solutions, and identify problems in such hardware solutions that limit their performance. We also highlight the primary challenges faced by in-memory databases, and summarize their potential solutions, from both software and hardware perspectives<\/jats:p>","DOI":"10.1145\/2814710.2814717","type":"journal-article","created":{"date-parts":[[2015,8,24]],"date-time":"2015-08-24T14:08:55Z","timestamp":1440425335000},"page":"35-40","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":37,"title":["In-memory Databases"],"prefix":"10.1145","volume":"44","author":[{"given":"Kian-Lee","family":"Tan","sequence":"first","affiliation":[{"name":"National University of Singapore"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Qingchao","family":"Cai","sequence":"additional","affiliation":[{"name":"National University of Singapore"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Beng Chin","family":"Ooi","sequence":"additional","affiliation":[{"name":"National University of Singapore"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Weng-Fai","family":"Wong","sequence":"additional","affiliation":[{"name":"National University of Singapore"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Chang","family":"Yao","sequence":"additional","affiliation":[{"name":"National University of Singapore"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Hao","family":"Zhang","sequence":"additional","affiliation":[{"name":"National University of Singapore"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2015,8,12]]},"reference":[{"key":"e_1_2_1_1_1","first-page":"49","volume-title":"OSDI '14","author":"Belay A.","year":"2014","unstructured":"A. Belay , G. Prekas , A. Klimovic , S. Grossman , C. Kozyrakis , and E. Bugnion . Ix: A protected dataplane operating system for high throughput and low latency . In OSDI '14 , pages 49 -- 65 , 2014 . A. Belay, G. Prekas, A. Klimovic, S. Grossman, C. Kozyrakis, and E. Bugnion. Ix: A protected dataplane operating system for high throughput and low latency. In OSDI '14, pages 49--65, 2014."},{"key":"e_1_2_1_2_1","volume-title":"NUS","author":"Cai Q.","year":"2015","unstructured":"Q. Cai , H. Zhang , G. Chen , B. C. Ooi , and K.-L. Tan . Memepic : Towards a database system architecture without system calls. Technical report , NUS , 2015 . Q. Cai, H. Zhang, G. Chen, B. C. Ooi, and K.-L. Tan. Memepic: Towards a database system architecture without system calls. Technical report, NUS, 2015."},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/1454456.1454466"},{"key":"e_1_2_1_4_1","volume-title":"Roce at a crossroads. Technical report","year":"2014","unstructured":"Chelsio. Roce at a crossroads. Technical report , Chelsio Communications Inc ., 2014 . Chelsio. Roce at a crossroads. Technical report, Chelsio Communications Inc., 2014."},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1109\/ISSCC.2012.6176876"},{"key":"e_1_2_1_6_1","first-page":"57","volume-title":"ADMS '14","author":"DeBrabant J.","year":"2014","unstructured":"J. DeBrabant , A. Joy , A. Pavlo , M. Stonebraker , S. Zdonik , and S. R. Dulloor . A prolegomenon on oltp database systems for non-volatile memory . In ADMS '14 , pages 57 -- 63 , 2014 . J. DeBrabant, A. Joy, A. Pavlo, M. Stonebraker, S. Zdonik, and S. R. Dulloor. A prolegomenon on oltp database systems for non-volatile memory. In ADMS '14, pages 57--63, 2014."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2747642"},{"key":"e_1_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1376616.1376713"},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.14778\/2735703.2735704"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/1807167.1807233"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/2619239.2626299"},{"key":"e_1_2_1_12_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2011.5767867"},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.14778\/2095686.2095689"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2013.6544906"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1109\/VLSIT.2010.5556226"},{"key":"e_1_2_1_16_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2014.6816683"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.1145\/2503009"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1109\/TMAG.2011.2159262"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.14778\/2752939.2752945"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465342"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2014.6816685"},{"key":"e_1_2_1_22_1","first-page":"103","volume-title":"USENIX ATC '13","author":"Mitchell C.","year":"2013","unstructured":"C. Mitchell , Y. Geng , and J. Li . Using one-sided rdma reads to build a fast, cpu-efficient key-value store . In USENIX ATC '13 , pages 103 -- 114 , 2013 . C. Mitchell, Y. Geng, and J. Li. Using one-sided rdma reads to build a fast, cpu-efficient key-value store. In USENIX ATC '13, pages 103--114, 2013."},{"key":"e_1_2_1_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2749436"},{"key":"e_1_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.1145\/2213836.2213844"},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.14778\/2535568.2448947"},{"key":"e_1_2_1_26_1","first-page":"101","volume-title":"USENIX ATC '12","author":"Rizzo L.","year":"2012","unstructured":"L. Rizzo . Netmap : A novel framework for fast packet i\/o . In USENIX ATC '12 , pages 101 -- 112 , 2012 . L. Rizzo. Netmap: A novel framework for fast packet i\/o. In USENIX ATC '12, pages 101--112, 2012."},{"key":"e_1_2_1_27_1","first-page":"1","volume-title":"FAST '14","author":"Rumble S. M.","year":"2014","unstructured":"S. M. Rumble , A. Kejriwal , and J. Ousterhout . Log-structured memory for dram-based storage . In FAST '14 , pages 1 -- 16 , 2014 . S. M. Rumble, A. Kejriwal, and J. Ousterhout. Log-structured memory for dram-based storage. In FAST '14, pages 1--16, 2014."},{"key":"e_1_2_1_28_1","unstructured":"S. Sanfilippo and P. Noordhuis. Redis. http:\/\/redis.io 2009.  S. Sanfilippo and P. Noordhuis. Redis. http:\/\/redis.io 2009."},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/2517349.2522713"},{"key":"e_1_2_1_30_1","doi-asserted-by":"publisher","DOI":"10.14778\/1687627.1687671"},{"key":"e_1_2_1_31_1","volume-title":"Mar.","author":"Yao C.","year":"2015","unstructured":"C. Yao , D. Agrawal , P. Chang , G. Chen , B. C. Ooi , W.-F. Wong , and M. Zhang . Dgcc: A new dependency graph based concurrency control protocol for multicore database systems. ArXiv e-prints , Mar. 2015 . C. Yao, D. Agrawal, P. Chang, G. Chen, B. C. Ooi, W.-F. Wong, and M. Zhang. Dgcc: A new dependency graph based concurrency control protocol for multicore database systems. ArXiv e-prints, Mar. 2015."},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.14778\/2735508.2735511"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.1109\/TKDE.2015.2427795"},{"key":"e_1_2_1_34_1","first-page":"592","volume-title":"ICDE '15","author":"Zhang H.","year":"2014","unstructured":"H. Zhang , G. Chen , W.-F. Wong , B. C. Ooi , S. Wu , and Y. Xia . Anti-caching-based elastic data management for big data . In ICDE '15 , pages 592 -- 603 , 2014 . H. Zhang, G. Chen, W.-F. Wong, B. C. Ooi, S. Wu, and Y. Xia. Anti-caching-based elastic data management for big data. In ICDE '15, pages 592--603, 2014."},{"key":"e_1_2_1_35_1","doi-asserted-by":"publisher","DOI":"10.14778\/2732951.2732956"}],"container-title":["ACM SIGMOD Record"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2814710.2814717","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/2814710.2814717","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T05:48:53Z","timestamp":1750225733000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/2814710.2814717"}},"subtitle":["Challenges and Opportunities From Software and Hardware Perspectives"],"short-title":[],"issued":{"date-parts":[[2015,8,12]]},"references-count":35,"journal-issue":{"issue":"2","published-print":{"date-parts":[[2015,8,12]]}},"alternative-id":["10.1145\/2814710.2814717"],"URL":"https:\/\/doi.org\/10.1145\/2814710.2814717","relation":{},"ISSN":["0163-5808"],"issn-type":[{"value":"0163-5808","type":"print"}],"subject":[],"published":{"date-parts":[[2015,8,12]]},"assertion":[{"value":"2015-08-12","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}