TY - CHAP A1 - Bogner, Justus A1 - Dehner, Carolin A1 - Vinçon, Tobias A1 - Petrov, Ilia ED - Anderst-Kotsis, Gabriele T1 - Real time charging database benchmarking T2 - Proceedings of the 17th International Conference on Information Integration and Web-Based Applications & Services, iiWAS 2015, Brussels, Belgium, December 11-13, 2015 N2 - Real Time Charging (RTC) applications that reside in the telecommunications domain have the need for extremely fast database transactions. Today´s providers rely mostly on in-memory databases for this kind of information processing. A flexible and modular benchmark suite specifically designed for this domain provides a valuable framework to test the performance of different DB candidates. Besides a data and a load generator, the suite also includes decoupled database connectors and use case components for convenient customization and extension. Such easily produced test results can be used as guidance for choosing a subset of candidates for further tuning/testing and finally evaluating the database most suited to the chosen use cases. This is why our benchmark suite can be of value for choosing databases for RTC use cases. KW - telecommunications KW - real time charging KW - database benchmarking KW - performance testing KW - application-specific macro-benchmark KW - data generator KW - load generator KW - executable use cases Y1 - 2015 SN - 978-1-4503-3491-4 U6 - http://dx.doi.org/10.1145/2837185.2837258 PB - ACM CY - New York, NY ER - TY - CHAP A1 - Petrov, Ilia A1 - Gottstein, Robert A1 - Hardock, Sergej T1 - DBMS on modern storage hardware T2 - IEEE 31st International Conference on Data Engineering (ICDE), 2015 ; 13. - 17. April 2015, Seoul, Korea N2 - In the present tutorial we perform a cross-cut analysis of database systems from the perspective of modern storage technology, namely Flash memory. We argue that neither the design of modern DBMS, nor the architecture of flash storage technologies are aligned with each other. The result is needlessly suboptimal DBMS performance and inefficient flash utilisation as well as low flash storage endurance and reliability. We showcase new DBMS approaches with improved algorithms and leaner architectures, designed to leverage the properties of modern storage technologies. We cover the area of transaction management and multi-versioning, putting a special emphasis on: (i) version organisation models and invalidation mechanisms in multi-versioning DBMS; (ii) Flash storage management especially on append-based storage in tuple granularity; (iii) Flash-friendly buffer management; as well as (iv) improvements in the searching and indexing models. Furthermore, we present our NoFTL approach to native Flash access that integrates parts of the flash-management functionality into the DBMS yielding significant performance increase and simplification of the I/O stack. In addition, we cover the basics of building large Flash storage for DBMS and revisit some of the RAID techniques and principles. Y1 - 2015 SN - 978-1-4799-7964-6 U6 - http://dx.doi.org/10.1109/ICDE.2015.7113423 SP - 1545 EP - 1548 PB - IEEE CY - Piscataway, NJ ER - TY - CHAP A1 - Hardock, Sergej A1 - Petrov, Ilia A1 - Gottstein, Robert A1 - Buchmann, Alejandro ED - Gustavo, Alonso T1 - NoFTL for real : databases on real native Flash storage T2 - Advances in database technology - EDBT 2015 : 18th International Conference on Extending Database Technology, Brussels, Belgium, March 23 - 27, 2015 : proceedings N2 - Flash SSDs are omnipresent as database storage. HDD replacement is seamless since Flash SSDs implement the same legacy hardware and software interfaces to enable backward compatibility. Yet, the price paid is high as backward compatibility masks the native behaviour, incurs significant complexity and decreases I/O performance, making it non-robust and unpredictable. Flash SSDs are black-boxes. Although DBMS have ample mechanisms to control hardware directly and utilize the performance potential of Flash memory, the legacy interfaces and black-box architecture of Flash devices prevent them from doing so. In this paper we demonstrate NoFTL, an approach that enables native Flash access and integrates parts of the Flashmanagement functionality into the DBMS yielding significant performance increase and simplification of the I/O stack. NoFTL is implemented on real hardware based on the OpenSSD research platform. The contributions of this paper include: (i) a description of the NoFTL native Flash storage architecture; (ii) its integration in Shore-MT and (iii) performance evaluation of NoFTL on a real Flash SSD and on an on-line data-driven Flash emulator under TPCB, C,E and H workloads. The performance evaluation results indicate an improvement of at least 2.4x on real hardware over conventional Flash storage; as well as better utilisation of native Flash parallelism. Y1 - 2015 U6 - http://nbn-resolving.de/urn/resolver.pl?urn:nbn:de:bsz:rt2-opus4-8066 UR - http://openproceedings.org./html/pages/2015_edbt.html SN - 978-3-89318-067-7 SP - 517 EP - 520 PB - University of Konstanz, University Library CY - Konstanz ER -