There aren’t many benchmarks which allow you to test your systems against a hybrid OLTP and OLAP workloads. CH-BenCHmark fills that gap by combining TPC-C and TPC-H. You can download the source from the linked site or you can use something like OLTPBench (a collection of benchmarks). However, the TPC-H… Read More »CH-BenCHmark for MS SQL Server – HTAP benchmarking
If you are trying to visualize a nice graph with NetworkX, you should be exhausted by now. After all, NetworkX only provides basic functionality for graph visualization. The main goal of NetworkX is to enable graph analysis. For everything other than basic visualization, it’s advisable to use a separate specialized… Read More »NetworkX visualization with Graphviz (Example)
This article demonstrates the physical design of a multi-column non-clustered index with include-columns. Many examples on the internet only demonstrate the most simple version of an index with a single column. This article gives a proper view of an index with multiple columns through a simple example. Furthermore, you can… Read More »Index Physical Structure Example; Multi-column Non-Clustered Index with Includes
This is a new project, I’m working on from early last year. The motivation behind this project is to build a programing language that allows users to analyze private data without exposing sensitive information. Many data analysis languages (R, Python, MATLAB etc.) in the current market assume direct access to… Read More »PRIVATE: A Privacy-preserving Data Analysis Language.
Most people got huge water bills after some time due to COVID-19. I wanted to double-check the calculation because the amount was somewhat big. Unlucky I didn’t find any online calculator that get the job done (there was a one in waterboard, but it has a maximum limit of 60… Read More »Water Bill Calculator – Sri Lanka
I recently had to change my car battery. This is after running 4.5 years with my original battery. I replaced the original with an Amaron battery for 13000 rupees (checked the images at the end). I thought someone might find this information helpful. I initially assumed that my battery was… Read More »Suzuki WagonR 12v Car Battery Replacement (Sri Lanka) – Amaron
In times of the recent tragic Easter attacks and the insurgency in our home country Sri Lanka, The Sri Lankan Graduates’ Society, The University of Melbourne, organized a silent candlelight vigil in paying respect to the lives lost and to commemorate the much-needed unity among us to walk through these… Read More »SLGS Candlelight Vigil
Recently I wanted to run the JOB benchmark for an experiment. This benchmark uses an IMDB dataset, published in 2013. Initially, I had some trouble running the benchmark as it was designed for a PostgreSQL database. And the dataset was created in a UNIX system which can create issues when… Read More »Microsoft SQL Server 2016 Database with IMDB 2013 Dataset