vix.ing · top · new · best · stats · spec

Density Estimations for Approximate Query Processing on SIMD Architectures

2015/05/08 by Witold Andrzejewski, Andrzejewski, Witold, Artur Gramacki +3
Computer Science · #Advanced Database Systems and Queries #Algorithms and Data Compression #Computational Engineering #Data Management and Algorithms #Distributed #FOS: Computer and information sciences #Finance #Parallel #and Cluster Computing (cs.DC) #and Science (cs.CE)

paper · pdf · doi:10.48550/arxiv.1505.01998

openalex publication_date 2015/05/08 · openalex created_date 2016/06/24 · openalex updated_date 2026/07/28

Abstract

Approximate query processing (AQP) is an interesting alternative for exact query processing. It is a tool for dealing with the huge data volumes where response time is more important than perfect accuracy (this is typically the case during initial phase of data exploration). There are many techniques for AQP, one of them is based on probability density functions (PDF). PDFs are typically calculated using nonparametric data-driven methods. One of the most popular nonparametric method is the kernel density estimator (KDE). However, a very serious drawback of using KDEs is the large number of calculations required to compute them. The shape of final density function is very sensitive to an entity called bandwidth or smoothing parameter. Calculating it's optimal value is not a trivial task and in general is very time consuming. In this paper we investigate the possibility of utilizing two SIMD architectures: SSE CPU extensions and NVIDIA's CUDA architecture to accelerate finding of the bandwidth. Our experiments show orders of magnitude improvements over a simple sequential implementation of classical algorithms used for that task.

Citations

Related