Partial Reload of Incrementally Updated Tables in Analytic Database Accelerators
| dc.contributor.author | Stolze, Knut | |
| dc.contributor.author | Beier, Felix | |
| dc.contributor.author | Müller, Jens | |
| dc.contributor.editor | Grust, Torsten | |
| dc.contributor.editor | Naumann, Felix | |
| dc.contributor.editor | Böhm, Alexander | |
| dc.contributor.editor | Lehner, Wolfgang | |
| dc.contributor.editor | Härder, Theo | |
| dc.contributor.editor | Rahm, Erhard | |
| dc.contributor.editor | Heuer, Andreas | |
| dc.contributor.editor | Klettke, Meike | |
| dc.contributor.editor | Meyer, Holger | |
| dc.date.accessioned | 2019-04-11T07:21:25Z | |
| dc.date.available | 2019-04-11T07:21:25Z | |
| dc.date.issued | 2019 | |
| dc.description.abstract | The 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 (Db2z) with very fast column-store processing in Db2 Database for Linux, Unix, and Windows. IDAA maintains a copy of the data from Db2z in its backend database. The data can be synchronized in batch with a granularity of table partitions, or incrementally using replication technology for individual rows. In this paper we present the enablement of combining the batch loading of a true subset of a table’s partitions for replicated tables. The primary goal for such an integration is to ensure data consistency. A specific challenge is that no duplicated rows stemming from the two data transfer paths come into existence. We present a robust and yet simple approach that is based on IDAA’s implementation of multi-version concurrency control. | en |
| dc.identifier.doi | 10.18420/btw2019-27 | |
| dc.identifier.isbn | 978-3-88579-683-1 | |
| dc.identifier.pissn | 1617-5468 | |
| dc.identifier.uri | https://dl.gi.de/handle/20.500.12116/21712 | |
| dc.language.iso | en | |
| dc.publisher | Gesellschaft für Informatik, Bonn | |
| dc.relation.ispartof | BTW 2019 | |
| dc.relation.ispartofseries | Lecture Notes in Informatics (LNI) – Proceedings, Volume P-289 | |
| dc.subject | accelerator | |
| dc.subject | data synchronization | |
| dc.subject | replication | |
| dc.subject | mvcc | |
| dc.title | Partial Reload of Incrementally Updated Tables in Analytic Database Accelerators | en |
| gi.citation.endPage | 463 | |
| gi.citation.startPage | 453 | |
| gi.conference.date | 4.-8. März 2019 | |
| gi.conference.location | Rostock | |
| gi.conference.sessiontitle | Industriebeiträge |
Dateien
Originalbündel
1 - 1 von 1