You are here: Home » NewsFeeds » Alenka: GPU database engine

Alenka: GPU database engine

readme.md

What is this?

This is a GPU based database engine written to use vector based processing and high bandwidth of modern GPUs

Requirements

CUDA (nvcc) + Nvidia GPU
bison
flex
Modern GPU Library (included as submodule)
How to build?

git clone –recursive https://github.com/antonmks/Alenka.git
cd Alenka
make

Features :

Vector-based processingCUDA programming model allows a single operation to be applied to an entire set of data at once.
Smart compressionUltra fast compression and decompression on GPU.
Database operations on compressed data.
Column-based storageMinimizes disk I/O by only accessing the relevant data.
Data skippingBetter performance without indexes.
Fast LoadingGpu based CSV parser loads the data into database at very high speed.
How to use it ?

Create your data files :

Run scripts load_orders.sql, load_lineitem.sql and load_customer.sql to create your database files.

Run your queries from a command prompt or use Alenka JDBC driver from Technica Corporation

Step 1 – Filter data

OFI := FILTER orders BY o_orderdate < 19950315;

CF := FILTER customers BY c_mktsegment == "BUILDING";

LF :=


 

Original article