Logo des Repositoriums

Auflistung nach Schlagwort "OLTP"

1 - 2 von 2
  • Konferenzbeitrag
    An Experimental Analysis of Different Key-Value Stores and Relational Databases
    (Datenbanksysteme für Business, Technologie und Web (BTW 2017), 2017) Gembalczyk, David; Schuhknecht, Felix Martin; Dittrich, Jens
    Nowadays, databases serve two main workloads: Online Transaction Processing (OLTP) and Online Analytic Processing (OLAP). For decades, relational databases dominated both areas. With the hype on NoSQL databases, the picture has changed. Initially designed as inter-process hash tables handling OLTP requested, some key-value store vendors have started to tackle the area of OLAP as well. Therefore, in this performance study, we compare the relational databases PostgreSQL, MonetDB, and HyPer with the key-value stores Redis and Aerospike in their write, read, and analytical capabilities. Based on the results, we investigate the reasons of the database’s respective advantages and disadvantages.
  • Zeitschriftenartikel
    HyPer Beyond Software: Exploiting Modern Hardware for Main-Memory Database Systems
    (Datenbank-Spektrum: Vol. 14, No. 3, 2014) Funke, Florian; Kemper, Alfons; Mühlbauer, Tobias; Neumann, Thomas; Leis, Viktor
    In this paper, we survey the use of advanced hardware features for optimizing main-memory database systems in the context of our HyPer project. We exploit the virtual memory management for snapshotting the transactional data in order to separate OLAP queries from parallel OLTP transactions. The access behavior of database objects from simultaneous OLTP transactions is monitored using the virtual memory management component in order to compact the database into hot and cold partitions. Utilizing many-core NUMA-organized database servers is facilitated by the morsel-driven adaptive parallelization and partitioning that guarantees data locality w.r.t. the processing core. The most recent Hardware Transactional Memory support of, e.g., Intel’s Haswell processor, can be used as the basis for a lock-free concurrency control scheme for OLTP transactions. Finally, we show how heterogeneous processors of “wimpy” devices such as tablets can be utilized for high-performance and energy-efficient query processing.