DB Weekly Issue 89: January 29, 2016

19 Resources for Learning About Database Design Errors — A look at numerous online resources for avoiding poor database design that can lead to many problems and cost both time and money.

Using AWS Aurora (Amazon's MySQL-Compatible Database) — Advait Shinde shows how his company uses Amazon Aurora to improve scalability by decreasing replica lag and bypassing limitations inherit in enterprise-grade relational databases like AWS RDS.

Analyzing A Million Songs on AWS Redshift — A look at extracting data from 1 million songs, uploading it to AWS Redshift via S3, and running some analysis via psql.

Unlimited Scalability Unprecedented Speed with the GridGain In-Memory Data Fabric — GridGain enables high-performance transactions, real-time streaming and fast analytics using a distributed, massively parallel architecture which can connect SQL, NoSQL, and Hadoop databases. GridGain is an enterprise-ready solution built on Apache IgniteTM.

Postgres Query Plan Visualization — Understanding query plans and EXPLAIN output can be tricky, even for an experienced user. This is a great tool to help better understand how a query is operating.

KeRF: A Next-generation Time-Series and Tick Database — A columnar tick database and time-series language for Linux/OSX/BSD/iOS/Android. Natively speaks JSON and SQL. Ideal for trading platforms, low-latency networking, high-volume analysis of realtime and historical data, etc.

Binomial Options Pricing in SQL — How to set up a discrete binomial tree using the binomial options pricing model to value derivatives in SQL, and apply this in an example of pricing a 3-period call option.

Gartner Sees Analytics Boom as More Data is Shared — "forecasts greater uptake of emerging analytics technologies like semantic and graph analyses, simulation, complex event processing and neural networks"

Happy Birthday, Hadoop: Celebrating 10 Years of Improbable Growth — "the first Hadoop cluster went into production at Yahoo 10 years ago"

Aerospike Adds GeoSpatial Data to Speedy NoSQL

Get more from Redis: Autoscaling and Analytics from RedisGreen — Redis auto-scaling and analytics. Backed by support from engineers with years of Redis scaling expertise.

Kafka and Elasticsearch, a Perfect Match

Using Redis for PHP Session Storage

Using GraphQL with MongoDB

Categorizing Images with Deep Learning Into Elasticsearch

MySQL in Docker or Native – Performance Benchmarks

Is Spark Replacing Hadoop?

Redis latency — Instantly visible, alertable, and correlated with key evition rates, memory fragmentation ratio, and more.

1.7 Billion Reddit Comments Loaded on Google BigQuery