CPU vs GPU in OLAP

Databases on GPGPU are still in a very early stage of development. I would even say that, unless it is top secret, it is rather only a field for academic research at the moment – and that is where we can find the most information about it. Recently I got back to looking for something ...

Web Scraping Part I

In my spare time I am creating a web scraping environment. Why is it environment not a script or anything like that? Because those pretty much already exist. The aim of my project is to have a list of websites to monitor, scrape them every now and then, and finally process the data. One of ...

On Column Sizes

If you just started your adventure with databases you may not pay too much attention do data types. Often reading in the data from a flat file will be so troublesome that you just define column types to be VARCHAR(100) just to have everything read in. Maybe after having the data read you convert some ...

Paste with Formatting

Paste with Formatting
Conditional formatting in Excel is one of the things every analyst should know well. When you have to compare loads of data the best way is to plot them, but even better to colorcode the values. That is pretty easy in Excel, as long as you can use conditional formatting (highlight a range, then conditional ...