Logo des Repositoriums
 

Integration of spatial data in database acceleration for analytics

dc.contributor.authorStolze, Knut
dc.contributor.authorRückert, Josephine
dc.contributor.authorButt, Frank
dc.contributor.editorSeidl, Thomas
dc.contributor.editorRitter, Norbert
dc.contributor.editorSchöning, Harald
dc.contributor.editorSattler, Kai-Uwe
dc.contributor.editorHärder, Theo
dc.contributor.editorFriedrich, Steffen
dc.contributor.editorWingerath, Wolfram
dc.date.accessioned2017-06-30T11:40:47Z
dc.date.available2017-06-30T11:40:47Z
dc.date.issued2015
dc.description.abstractThe IBM DB2 Analytics Accelerator (IDAA) integrates the strong OLTP capabilities of DB2 for z/OS with very fast processing of OLAP and analytical SQL workload in Netezza. Today, not all data types supported by DB2 are available for acceleration. One step to narrow this gap is to enable spatial data - in form of polygons, linestrings, and points - for OLAP processing. Since DB2 and Netezza have very different internal architectures and different limitations, a straight-forward mapping from the DB2 data type to Netezza data types is not possible. We developed a prototype geared toward performance and simplicity for spatial data support in IDAA. In particular, all SQL statement that work against DB2 shall work against the accelerator without any changes. In this paper, we describe how the integration with the accelerator is accomplished so that ingestion and access to the spatial data becomes as seamless and transparent as possible for existing applications. The architecture and implementation aspects for spatial data representation in Netezza as well as the access during query processing are discussed in detail.en
dc.identifier.isbn978-3-88579-635-0
dc.identifier.pissn1617-5468
dc.language.isoen
dc.publisherGesellschaft für Informatik e.V.
dc.relation.ispartofDatenbanksysteme für Business, Technologie und Web (BTW 2015)
dc.relation.ispartofseriesLecture Notes in Informatics (LNI) - Proceedings, Volume P-241
dc.titleIntegration of spatial data in database acceleration for analyticsen
dc.typeText/Conference Paper
gi.citation.endPage576
gi.citation.publisherPlaceBonn
gi.citation.startPage565
gi.conference.date2.-3. März 2015
gi.conference.locationHamburg

Dateien

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