Reducing Relational Database Performance Bottlenecks Using 3D XPoint Storage Technology

Jinfeng Yang, David J. Lilja

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

3 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
CountryUnited States
CityNew York
Period7/31/188/3/18

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

    Yang, J., & Lilja, D. J. (2018). Reducing Relational Database Performance Bottlenecks Using 3D XPoint Storage Technology. In Proceedings - 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 (pp. 1804-1808). [8456140] (Proceedings - 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). Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/TrustCom/BigDataSE.2018.00272