When it comes to relational databases, I can’t help thinking that something is missing. They’re used everywhere. There are many different databases: from the small and useful SQLite to the powerful Teradata. But, there are only a few articles that explain how a database works. You can google by yourself “how does a relational database […]
Have you ever wondered how Shazam works? I asked myself this question a few years ago and I read a research article written by Avery Li-Chun Wang, the confounder of Shazam, to understand the magic behind Shazam. In this in-depth article I explain all the mechanisms behind Shazam.
A few months ago, I was confronted at work with the following use case: “Analyse the data of some selected clients”. It seems easy, but not if there are billions of data and there can be millions of clients to analyse and it needs to run as fast as possible!
In this post I’ll describe the solution I found but most importantly, how I came to this solution.