Issue 184 — December 15, 2017
The Case for Learned Index Structures — Get your academic brain in gear with this exploratory research paper from MIT and Google that posits all existing index structures can be replaced with better performing learned indexes that can be built using deep-learning models. This is one of those "lots of databases might be doing this in 10 years" moments.
Kraska, Beutel et al. tutorial
The Three-Valued Logic (3VL) of SQL — Besides true and false, the result of logical expressions in SQL can also be unknown.
Markus Winand tutorial
Performance Analytics for Amazon Redshift. For Data Engineering Heroes — Amazon Redshift is incredibly powerful, but you can spend a lot of time fighting fires. We fix that. intermix.io gives you the tools you need to analyze your Redshift performance and improve the toolchain of everyone downstream from your cluster.
intermix.io sponsored
10 Key Big Data Trends That Drove 2017 — AI, Spark, and graph databases continue to grow, Hadoop’s star has faded slightly, and more.
Alex Woodie opinion
RedFI: A Fault-Injection Redis Proxy — A tool for testing the resiliency of your app against faults in connecting to Redis (e.g. delays, dropped connections).
Khalid Lafi tools
Heroku news
As Data Quality Declines, Costs Soar — Cleaning up and filtering ‘bad data’ is a growing area.
Datanami news
Database Performance Monitoring Buyer’s Guide — This guide is designed to aid when evaluating database monitoring solutions for your unique environment.
VividCortex sponsored
Lena Hall tutorial
Using PopSQL for Collaborative SQL Editing — A commercial tool that’s free for one or two users.
Naomi Slater tutorial
Vertabelo tutorial
Eli Bendersky tutorial
Continuous Delivery: GoCD VS Spinnaker — An overview of GoCD & Spinnaker, why they are different from each other and which problems you should use them to solve.
GoCD sponsored
Advanced Design Patterns for Amazon DynamoDB — A deep dive into design patterns for DynamoDB covering strategies for GSI sharding, index overloading, scalable graph processing and more.
Rick Houlihan video
Ben Snively video
Microsoft tools
github.com tools
Ian Lewis code