Logo des Repositoriums
 

Autonomous Data Ingestion Tuning in Data Warehouse Accelerators

dc.contributor.authorStolze, Knut
dc.contributor.authorBeier, Felix
dc.contributor.authorMüller, Jens
dc.contributor.editorMitschang, Bernhard
dc.contributor.editorNicklas, Daniela
dc.contributor.editorLeymann, Frank
dc.contributor.editorSchöning, Harald
dc.contributor.editorHerschel, Melanie
dc.contributor.editorTeubner, Jens
dc.contributor.editorHärder, Theo
dc.contributor.editorKopp, Oliver
dc.contributor.editorWieland, Matthias
dc.date.accessioned2017-06-20T20:24:37Z
dc.date.available2017-06-20T20:24:37Z
dc.date.issued2017
dc.description.abstractThe IBM DB2 Analytics Accelerator (IDAA) is a state-of-the art hybrid database system that seamlessly extends the strong transactional capabilities of DB2 for z/OS with very fast processing of OLAP and analytical SQL workload in Netezza. IDAA copies the data from DB2 for z/OS into its Netezza backend, and customers can tailor data maintenance according to their needs. This copy process, the data load, can be done on a whole table or just a physical table partition. IDAA also o ers an incremental update feature, which employs replication technologies for low-latency data synchronization. The accelerator targets big relational databases with several TBs of data. Therefore, the data load is performance-critical, not only for the data transfer itself, but the system has to be able to scale up to a large number of tables, i. e., tens of thousands to be loaded at the same time, as well. The administrative overhead for such a number of tables has to be minimized. In this paper, we present our work on a prototype, which is geared towards e ciently loading data for many tables, where each table may store only a comparably small amount of data. A new load scheduler has been introduced for handling all concurrent load requests for disjoint sets of tables. That is not only required for a multi-tenant setup, but also a significant improvement for attaching an accelerator to a single DB2 for z/OS system. In this paper, we present architecture and implementation aspects of the new and improved load mechanism and results of some initial performance evaluations.de
dc.identifier.isbn978-3-88579-659-6
dc.identifier.pissn1617-5468
dc.language.isode
dc.publisherGesellschaft für Informatik, Bonn
dc.relation.ispartofDatenbanksysteme für Business, Technologie und Web (BTW 2017)
dc.relation.ispartofseriesLecture Notes in Informatics (LNI) - Proceedings, Volume P-265
dc.titleAutonomous Data Ingestion Tuning in Data Warehouse Acceleratorsde
dc.typeText/Conference Paper
gi.citation.endPage532
gi.citation.startPage531
gi.conference.date6.-10. März 2017
gi.conference.locationStuttgart
gi.conference.sessiontitleIndustrial Program - Data Lake

Dateien

Originalbündel
1 - 1 von 1
Lade...
Vorschaubild
Name:
paper37.pdf
Größe:
1.19 MB
Format:
Adobe Portable Document Format