Category: Uncategorized
-
Clustering England & Wales House Prices Using MADlib
Want to know how cluster data using MADlib & Greenplum?
-
Give the SQL Query Optimiser A Chance
As already discussed, SQL query optimisation is a non-trivial challenge. SQL code has to quickly be assessed by the optimiser and turned into an efficient query plan that can be executed by the DBMS. Part of the challenge the optimiser faces is that relational databases, unsurprisingly, can contain lots and lots and lots of relations…
-
Why Greenplum Is The Best…Of The Rest
Teradata Is Still The Market Leader When it comes to Data Warehouse databases, there has been a clear market leader for a long, long time. No surprises which technology it is…wait for it…Teradata! Teradata were first to market with their eponymous analytic database way back in the 1980s, when a Terabyte (TB) was a lot…
-
Punching the Numbers
Round One: We’re stepping into the octagon on the front foot with one question: What’s the real value of data in MMA? In this post, we’ll take a closer look at the UFC (Ultimate Fighting Championship) and explore how fight data and analytics are shaping the sport. From breaking down fighter performance stats to showing…
-
For the Love of Data
Recently, on a sunny Easter Sunday, I took the plunge and “put a ring on it” as all of the cool kids say these days. A day that I thought would never come, but after a whirlwind twelve months my partner and I are now engaged! So, of course, you would think my next step…
-
Hybrid Is The New Black
Gartner’s ‘Capabilities for Data Management Solutions for Analytics’ Article What a mouthful ‘Capabilities for Data Management Solutions for Analytics’ is. At least ‘DMSA’ can be used instead. Hang on though – isn’t DMSA an acid used to treat lead, mercury, and arsenic poisoning?!?!? Anyway, a couple of weeks ago said Gartner article caught my eye on LinkedIn.…
-
Red Book Musings
Readings in Database Systems Also known as the ‘Red Book‘, Readings in Database Systems has been published since 1988. The 5th edition was published in 2015 after a 10 year hiatus. Quite ironic really that yours truly started his graduate IT career in 1988 on, you guessed it, database systems! The Red Book contributors are Peter…
-
Data Warehouse Performance Analysis
One of our clients (who shall remain anonymous) recently paid their platform vendor (who shall also remain anonymous) for a data warehouse performance assessment. This is the third time we’ve witnessed this particular client go through this process in the last 15 years. This go me thinking about the whole process… For a performance analysis…
