nach oben

Erschienen in:

2016 | OriginalPaper | Buchkapitel

Performance Aspect of the In-Memory Databases Accessed via JDBC

verfasst von : Daniel Kostrzewa, Małgorzata Bach, Robert Brzeski, Aleksandra Werner

Erschienen in: Beyond Databases, Architectures and Structures. Advanced Technologies for Data Mining and Knowledge Discovery

Verlag: Springer International Publishing

Einloggen

Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.

search-config

KI-gestützte Suche

Aus

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

über 102.000 Bücher
über 537 Zeitschriften

aus folgenden Fachgebieten:

Automobil + Motoren
Bauwesen + Immobilien
Business IT + Informatik
Elektrotechnik + Elektronik
Energie + Nachhaltigkeit
Finance + Banking
Management + Führung
Marketing + Vertrieb
Maschinenbau + Werkstoffe
Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Jetzt informieren

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

über 67.000 Bücher
über 390 Zeitschriften

aus folgenden Fachgebieten:

Automobil + Motoren
Bauwesen + Immobilien
Business IT + Informatik
Elektrotechnik + Elektronik
Energie + Nachhaltigkeit
Maschinenbau + Werkstoffe

Jetzt Wissensvorsprung sichern!

Jetzt informieren

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

über 67.000 Bücher
über 340 Zeitschriften

aus folgenden Fachgebieten:

Bauwesen + Immobilien
Business IT + Informatik
Finance + Banking
Management + Führung
Marketing + Vertrieb
Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Jetzt informieren

Vorheriges Kapitel Estimating Costs of Materialization Methods for SQL:1999 Recursive Queries

Nächstes Kapitel Comparison of the Behaviour of Local Databases and Databases Located in the Cloud

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.

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

10.

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)

11.

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

12.

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

13.

Garcia-Molina, H., Salem, K.: Main memory database systems: an overview. IEEE Trans. Knowl. Data Eng. 4(6), 509–516 (1992)CrossRef

14.

H2: H2 database. http://www.h2database.com/. Accessed Dec 2015

15.

H2: H2 database engine documentation. http://www.h2database.com/html/features.html. Accessed Dec 2015

16.

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

17.

Hyper SQL: Hyper SQL copyrights and licenses. http://hsqldb.org/web/hsqlLicense.html. Accessed Dec 2015

18.

Hyper SQL: Hyper SQL database. http://hsqldb.org/. Accessed Dec 2015

19.

Hyper SQL: Hyper SQL features summary. http://hsqldb.org/web/hsqlFeatures.html. Accessed Dec 2015

20.

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)

21.

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)

22.

MariaDB: MariaDB server license. https://mariadb.com/kb/en/mariadb/mariadb-license/. Accessed Nov 2015

23.

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

24.

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

25.

MySQL: the memory storage engine. http://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html. Accessed Dec 2015

26.

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

27.

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

28.

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

29.

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

Titel: Performance Aspect of the In-Memory Databases Accessed via JDBC
verfasst von: Daniel Kostrzewa
Małgorzata Bach
Robert Brzeski
Aleksandra Werner
Verlag: Springer International Publishing
Buch: Beyond Databases, Architectures and Structures. Advanced Technologies for Data Mining and Knowledge Discovery
Print ISBN: 978-3-319-34098-2

Electronic ISBN: 978-3-319-34099-9

Copyright-Jahr: 2016
DOI: https://doi.org/10.1007/978-3-319-34099-9_18

Springer Professional

Abstract

Bitte loggen Sie sich ein, um Zugang zu Ihrer Lizenz zu erhalten.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Springer Professional "Technik"

Springer Professional "Wirtschaft"

Premium Partner