VLDB – We’ve Moved! Returning To Our Founder’s Roots

Myself and the rest of the Liverpool-based members of VLDB recently moved offices. This move represents a 30-year journey back to where I started. Allow me to explain… ‘Back in the day’ there were two main employers in Old Hall St, the centre of Liverpool’s CBD: Royal Insurance (‘The Royal’) …

Analytical Maturity Models – Machine Learning and Artificial Intelligence

According to a recent Gartner study (Dec ’18), “87% of organisations have low BI and analytics maturity” (Source- ‘Low Bi and Analytical Maturity’) On first impressions, this sounds like ‘shots fired’ by Gartner. So, what can they mean by ‘low BI and analytics maturity’, and can this possibly be true? …

30 Years In IT…You’d get Less for Murder!

A few weeks ago marked 30 years since yours truly started out as a graduate IT trainee at Royal Insurance (now RSA) in 1988. Back then, there were no PCs, just dumb terminals; no mobile phones, just landlines; no email, no internet. But the biggest shock of all: other people …

PostgresConf 2018 Musings

Yours truly attended the Postgres Conf in Jersey City last week with my esteemed colleague Richard Jackson. It was quite a blast, to say the least…apart from not getting home until late Saturday afternoon. Ho hum. PostgresConf 2018, Jersey City, USA PostgreSQL Re-Cap PostgreSQL, or Postgres for short, is an open source …

An Introduction to Primary Indexes and Distribution Keys

It’s All About Data Distribution. As experts in Massively Parallel Processing (MPP), here at VLDB Solutions we talk regularly about ‘Primary Indexes’ (PI) or ‘Distribution Keys’ (DK). They are integral to the architecture of both Teradata and Greenplum respectively, and the correct identification and employment of them is ‘key’ to …