PGCon2011 - Final (2011.06.11)

PGCon 2011
The PostgreSQL Conference

Tim Child
Day Talks - 1 - 2011-05-19
Room DMS 1160
Start time 15:00
Duration 01:00
ID 352
Event type Lecture
Track Advanced Features
Language used for presentation English

Parallel Image Searching Using PostgreSQL and PgOpenCL

Running PostgreSQL Stored Procedures on a GPU

2D and 3D Image data is increasing important. New 3D scanning devices are being used to map a variety of large and small spaces and objects. Large GIS data sets are being acquired with new scanners. Computation photography allows the manipulation of images for many applications both scientific and social. GPUs are increasingly being used to accelerate image based computations. This presentation illustrates how PostgreSQL can store and process images using GPU hosted stored procedures, written in OpenCL.

This is an outline of my proposed slides

• Title • Speaker’s Bio o Brief biographical details of the speaker. • Talk Outline o Overview the talks topics • Parallel Universe o Provides an over view of what GPU (highly parallel chips) will bring to the DBMS world. • The power of GPU’s o Describes the enormous computing power available from GPUs. • OpenCL GPU/CPU Programming Language o Describes the new OpenCL programming language that can be used for parallel programming for CPUs and GPUs. • PgOpenCL a new PostgeSQL Procedural Language o Describes PgOpenCL a new PostgreSQL procedure language that allows stored procedures to be written in OpenCL. • Image Data Types o Outlines 2D,and 3D image data types that are used to storage and processing of images. • Parallel Image searching o Outlines the type of image filter functions that can be used to process images and extract information as SQL tables from images. • Future Directions o Describes the future direction of parallel processing in databases. • Summary o Summarized the main points of the talk • Q &A o Time to answer question from the audience.