Abstract
Advancements in speed, volume, and reliability have made solid-state device (SSD) a premium enterprise resource. SSDs are placed between main memory and hard disk devices (HDDs) when compared in terms of speed and cost. SSDs offer latencies lower than hard disk drives but have higher costs. In this paper, we demonstrate how enterprise class data management solutions can effectively use SSDs to manage competing goals of higher throughput and low resource costs. We demonstrate that SSDs can be used as a secondary caching layer between main memory-based buffer cache and HDD-based page store to meet these goals. Intelligent meta-data management ensures most important data or ‘hot data’ resides in RAM, ‘warm data’ resides in SSDs, and ‘cold data’ resides in HDDs. Hotness is measured dynamic and based on access pattern; hence, it needs no user intervention. SAP’s relational database server: SAP Adaptive Server Enterprise (SAP ASE) implements these ideas in its feature named ‘non-volatile cache.’
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Similar content being viewed by others
References
What’s New in SAP Adaptive Server Enterprise 16 SP02. https://www.sap.com/documents/2016/06/02a21e18-767c-0010-82c7-eda71af511fa.html.
Packer, A., Jernigan, K., & Ramanujam, S. Oracle database smart flash cache. http://www.oracle.com/technetwork/articles/systems-hardware-architecture/oracle-db-smart-ash-cache-175588.pdf.
Buffer Pool Extension. https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/buffer-pool-extension.
Canim, M., Mihaila, G. A., Bhattacharjee, B., Ross, K. A., & Lang, C. A. (2010). SSD bufferpool extensions for database systems. In VLDB.
Do, J., Zhang, D., Patel, J. M., DeWitt, D. J., Naughton, J. F., & Halverson, A. (2011). Turbo charging dbms buffer pool using SSDs. In Proceedings of the SIGMOD International Conference on Management of Data.
Prateek, A., & Vaibhav, N. Database caching in a database system. Application number 15/070355. http://appft.uspto.gov.
Acknowledgements
We would like to acknowledge SAP ASE development and server performance engineering teams who have provided valuable feedback.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Nature Singapore Pte Ltd.
About this chapter
Cite this chapter
Agarwal, P., Nalawade, V. (2018). Extending Database Cache Using SSDs. In: Chakraverty, S., Goel, A., Misra, S. (eds) Towards Extensible and Adaptable Methods in Computing. Springer, Singapore. https://doi.org/10.1007/978-981-13-2348-5_7
Download citation
DOI: https://doi.org/10.1007/978-981-13-2348-5_7
Published:
Publisher Name: Springer, Singapore
Print ISBN: 978-981-13-2347-8
Online ISBN: 978-981-13-2348-5
eBook Packages: Computer ScienceComputer Science (R0)