Abstract
The conception of storing and managing data directly in RAM appeared some time ago but in spite of very good efficiency, it was impossible to massive implementation because of hardware limitations. Currently, it is possible to store whole databases in memory as well as there are some mechanisms to organize pieces of data as in-memory databases. It has been the interesting issue how this type of databases behaves when accessing via JDBC. Hence we decided to test their performance in terms/sense of the time of SQL query execution. For this purpose TPC Benchmark\(^{\mathrm {TM}}\) H (TPC-H) was applied. In our research we focused on the open source systems such as Altibase, H2, HyperSQL, MariaDB, MySQL Memory.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
This mechanism is an unpleasant necessity and is burdened with a large drop in system performance, but allows to maintain the systemâs ability to continue operating in the critical moments.
References
Altibase hybrid database included in Gartnerâs whoâs who for in-memoryDBMSs - 2014. http://www.prweb.com/releases/2014/02/prweb11541753.htm. Accessed Mar 2016
Magic quadrant for operational database management systems. https://www.gartner.com/doc/reprints?id=1-2PMFPEN&ct=151013. Accessed Dec 2015
Active TPC Benchmarks. http://www.tpc.org/information/benchmarks.asp. Accessed Dec 2015
Altibase. http://altibase.com/. Accessed Dec 2015
Amiri, H., AleAhmad, A., Rahgozar, M.: Disk resident databases versus mainmemory databases. https://www.researchgate.net/publication/228363088_Main_Memory_Databases_vs._Disk-Resident_Databases. Accessed Dec 2015
Ammann, A.C., Hanrahan, M., Krishnamurthy, R.: Design of a memory resident DBMS. In: COMPCON, pp. 54â58. IEEE Computer Society (1985)
Bach, M., Duszenko, A., Werner, A.: Koncepcja pamiciowych baz danych oraz weryfikacja podstawowych zaoe tych struktur. Studia Informatica 31(2B(90)), 63â76 (2010)
Bartholomew, D.: MariaDB vs MySQL. https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-features/. Accessed Dec 2015
Charles, C., Zoratti, I.: MariaDB 10 the complete tutorial. http://www.slideshare.net/bytebot/mariadb-10-the-complete-tutorial. Accessed Nov 2015
DeWitt, D., Katz, R., Olken, F., Shapiro, L., Stonebreaker, M., Wood, D.: Implementation techniques for main memory database systems. In: Proceedings of the 1984 ACM SIGMOD International Conference on Management of Data, SIGMOD 1984, vol. 14, no. 2, pp. 1â8 (1984)
Erickson, J.: Oracle database 12c: introducing Oracle database in-memory. http://www.oracle.com/us/corporate/features/database-in-memory-option/index.html. Accessed Dec 2015
Feinberg, D., Adrian, M., Heudecker, N., Ronthal, A.M., Palanca, T.: Magic quadrant for operational database management systems. http://www.gartner.com/technology/reprints.do?id=1-2PO8Z2O&ct=151013&st=sb. Accessed Dec 2015
Garcia-Molina, H., Salem, K.: Main memory database systems: an overview. IEEE Trans. Knowl. Data Eng. 4(6), 509â516 (1992)
H2: H2 database. http://www.h2database.com/. Accessed Dec 2015
H2: H2 database engine documentation. http://www.h2database.com/html/features.html. Accessed Dec 2015
Henschen, D.: In-memory databases: do you need the speed? http://www.informationweek.com/big-data/big-data-analytics/in-memory-databases-do-you-need-the-speed/d/d-id/1114076. Accessed Dec 2015
Hyper SQL: Hyper SQL copyrights and licenses. http://hsqldb.org/web/hsqlLicense.html. Accessed Dec 2015
Hyper SQL: Hyper SQL database. http://hsqldb.org/. Accessed Dec 2015
Hyper SQL: Hyper SQL features summary. http://hsqldb.org/web/hsqlFeatures.html. Accessed Dec 2015
Karnagel, T., Dementiev, R., Rajwar, R., Lai, K., Legler, T., Schlegel, B., Lehner, W.: Improving in-memory database index performance with Intel transactional synchronization extensions. In: 20th International Symposium on High-Performance Computer Architecture (2014)
Lindstrom, J., Raatikka, V., Ruuth, J., Soini, P., Vakkila, K.: IBM solidDB: in-memory database optimized for extreme speed and availability. Bull. Tech. Committee Data Eng. 36(2), 14â20 (2013)
MariaDB: MariaDB server license. https://mariadb.com/kb/en/mariadb/mariadb-license/. Accessed Nov 2015
Meena, J.S., Sze, S.M., Chand, U., Tseng, T.Y.: Overview of emerging nonvolatile memory technologies. Nanoscale Res. Lett. 9, 526 (2014). http://www.nanoscalereslett.com/content/pdf/1556-276X-9-526.pdf. Accessed Dec 2015
Muller, S., Plattner, H.: Aggregates caching in columnar in-memory databases. http://db.disi.unitn.eu/pages/VLDBProgram/pdf/IMDM/paper8.pdf. Accessed Dec 2015
MySQL: the memory storage engine. http://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html. Accessed Dec 2015
Pirk, H., Funke, F., Grund, M., Neumann, T., Leser, U., Manegold, S., Kemper, A., Kerste, M.: CPU and cache effcient management of memory-resident databases. http://oai.cwi.nl/oai/asset/20680/20680D.pdf. Accessed Dec 2015
Simon, E.A.: Evaluation of in-memory database TimesTen. CERN openlab Summer student report 2013 (2013). https://zenodo.org/record/7566/files/CERN_openlab_report_Endre_Andras_Simon.pdf. Accessed Mar 2016
Wust, J., Grund, M., Plattner, H.: Dynamic query prioritization for in-memory databases. http://db.disi.unitn.eu/pages/VLDBProgram/pdf/IMDM/paper7.pdf. Accessed Dec 2015
Yegulalp, S.: SQL server 2014 supercharged with in-memory tables. In: Azure Connectivity, InfoWorld (2014). http://www.infoworld.com/article/2610878/database/sql-server-2014-supercharged-with-in-memory-tables-azure-connectivity.html. Accessed Dec 2015
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2016 Springer International Publishing Switzerland
About this paper
Cite this paper
Kostrzewa, D., Bach, M., Brzeski, R., Werner, A. (2016). Performance Aspect of the In-Memory Databases Accessed via JDBC. In: Kozielski, S., Mrozek, D., Kasprowski, P., MaĆysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. Advanced Technologies for Data Mining and Knowledge Discovery. BDAS BDAS 2015 2016. Communications in Computer and Information Science, vol 613. Springer, Cham. https://doi.org/10.1007/978-3-319-34099-9_18
Download citation
DOI: https://doi.org/10.1007/978-3-319-34099-9_18
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-34098-2
Online ISBN: 978-3-319-34099-9
eBook Packages: Computer ScienceComputer Science (R0)