Abstract
In this research, we use three Swingbench OLTP benchmark scenarios to examine that three compression algorithm in ZFS file-systems namely LZ4, LZJB and ZLE can improve OLTP database performance. Beside the database performance, we also compare how much storage can be saved, impact to maximum response time, and the increase of CPU utilization from the three compression algorithms. The acquired data were then be analyzed using Analytic Hierarchy Process to find out the highest ranking compression in terms of benefits and benefits to cost ratio. The result indicates that LZJB achieved the highest performance improvement, LZ4 achieved the highest storage saving and ZLE achieved the smallest CPU utilization overhead. The safest algorithm that did not experience any reduction in database performance or increase of maximum response time in this research is LZJB.
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
References
Bassiouni, M.A.: Data compression in scientific and statistical databases. IEEE Trans. Softw. Eng. SE-11(10), 1047–1058 (1985)
Graefe, G., Shapiro, L.D.: Data compression and database performance. In: ACM/IEEE-CS Symposium on Applied Computing, Kansas City (1991)
Westman, T., Kossmann, D., Helmer, S., Moerkotte, G.: The implemmentation and performance of compressed databases. ACM SIGMOD Rec. 29(3), 55–67 (2000)
Habib, A., Hoque, A.S.M.L., Rahman, M.S.: High performance query operations on compressed database. Int. J. Database Theor. Appl. 5(3), 1–14 (2012)
Wenas, A.: Meningkatkan Kinerja Data Warehouse Menggunakan Teknologi Filesystem Dengan Kompresi GZIP, LZJB dan ZLE, Jakarta (2015)
Giles, D.: Swingbench (2015). http://www.dominicgiles.com/Swingbench.pdf. Accessed 2015
IBM, Oracle Database 11g and 12c on IBM Power Systems built with IBM Power8 processor technology and IBM FlashSystem 840, IBM Oracle International Competency Center (2014)
VMware, Oracle Databases on vSphere Workload Characterization Study, VMware, Palo Alto (2010)
Almari, F.N., Zavarsky, P., Ruhl, R., Lindskog, D., Aljaedi, A.: Performance analysis of oracle database in virtual environments. In: 2012 26th International Conference on Advanced Information Networking and Applications Workshops (WAINA), Fukuoka (2012)
Tope, I.E., Zavarsky, P., Ruhl, R., Lindskog, D.: Performance evaluation of oracle VM server virtualization software 64 bit linux environment. In: 2011 Third International Workshop on Security Measurements and Metrics (Metrisec), Banff, AB (2011)
Ye, D., Pavuluri, A., Waldspurger, C., Tsang, B., Rychlik, B., Woo, S.: Prototyping a hybrid main memory using a virtual machine monitor. In: IEEE International Conference on Computer Design, ICCD 2008, Lake Tahoe, CA (2008)
Saaty, T.L.: Decision making with analytic hierarchy process. Int. J. Serv. Sci. 1(1), 83–98 (2008)
Saaty, T.L., Ozdemir, M.: Negative priorities in the analytic hierarchy process. Math. Comput. Model. 37(9), 1063–1075 (2003)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2017 Springer International Publishing AG
About this paper
Cite this paper
Suharjito, Kurnadi, A.B. (2017). Online Transaction Processing (OLTP) Performance Improvement Using File-Systems Layer Transparent Compression. In: Nguyen, N., Tojo, S., Nguyen, L., Trawiński, B. (eds) Intelligent Information and Database Systems. ACIIDS 2017. Lecture Notes in Computer Science(), vol 10191. Springer, Cham. https://doi.org/10.1007/978-3-319-54472-4_29
Download citation
DOI: https://doi.org/10.1007/978-3-319-54472-4_29
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-54471-7
Online ISBN: 978-3-319-54472-4
eBook Packages: Computer ScienceComputer Science (R0)