Reducing Relational Database Performance Bottlenecks Using 3D XPoint Storage Technology

Jinfeng Yang, David J. Lilja

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

4 Scopus citations

Abstract

Relational database systems are data-intensive applications because of their heavy I/O workload during a query execution. With more and more data being generated, database sizes are increasing significantly. As a result, database systems incur a tremendous latency to return the query results back to the clients. Using the TPC-H benchmark program, this work explores several key issues that degrade database performance, including read amplification, inefficient use of temporary tables, and higher buffer pool cache miss rates. We show that when clients execute database queries on a conventional storage device, such as a solid-state disk (SSD), the extra I/O latency resulting from the above issues leads to bottlenecks that limit overall database performance. The availability of a new generation storage device, the Optane, which uses a new 3D cross-point technology, provides a feasible approach to accelerate the overall database performance. Processing database queries on this new device produces 1.5-8.3X improvement in the I/O response time, and 1.1-6.5X improvement in the total response time, compared to an SSD-based system.

Original languageEnglish (US)
Title of host publicationProceedings - 17th IEEE International Conference on Trust, Security and Privacy in Computing and Communications and 12th IEEE International Conference on Big Data Science and Engineering, Trustcom/BigDataSE 2018
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages1804-1808
Number of pages5
ISBN (Print)9781538643877
DOIs
StatePublished - Sep 5 2018
Event17th IEEE International Conference on Trust, Security and Privacy in Computing and Communications and 12th IEEE International Conference on Big Data Science and Engineering, Trustcom/BigDataSE 2018 - New York, United States
Duration: Jul 31 2018Aug 3 2018

Publication series

NameProceedings - 17th IEEE International Conference on Trust, Security and Privacy in Computing and Communications and 12th IEEE International Conference on Big Data Science and Engineering, Trustcom/BigDataSE 2018

Other

Other17th IEEE International Conference on Trust, Security and Privacy in Computing and Communications and 12th IEEE International Conference on Big Data Science and Engineering, Trustcom/BigDataSE 2018
Country/TerritoryUnited States
CityNew York
Period7/31/188/3/18

Bibliographical note

Funding Information:
This work was supported in part by the Center for Research in Intelligent Storage (CRIS), which is supported by National Science Foundation grant no. IIP-1439622 and member companies. Any opinions, findings and conclusions or recommendations expressed in this material are those of the authors and do not necessarily reflect the views of the NSF. The authors would like to thank Bingzhe Li from the University of Minnesota for his valuable suggestions on this project.

Publisher Copyright:
© 2018 IEEE.

Keywords

  • 3D XPoint Technology
  • Database Systems
  • Optane
  • Performance Evaluation

Fingerprint

Dive into the research topics of 'Reducing Relational Database Performance Bottlenecks Using 3D XPoint Storage Technology'. Together they form a unique fingerprint.

Cite this