--- title: "This week's database news, issue 89" publication: "DB Weekly" issue: 89 published_at: "2016-01-29" canonical_url: "https://dbweekly.com/issues/89" --- Database Weekly 89 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/89) [Database Weekly](http://dbweekly.com) Issue 89 — January 29, 2016 Featured [19 Resources for Learning About Database Design Errors](http://www.vertabelo.com/blog/notes-from-the-lab/19-online-resources-for-learning-about-database-design-errors?utm_source=dbweekly&utm_medium=email) — A look at numerous online resources for avoiding poor database design that can lead to many problems and cost both time and money. Jeffrey Edison [Using AWS Aurora (Amazon's MySQL-Compatible Database)](http://blog.goguardian.com/nerds/using-aws-aurora?utm_source=dbweekly&utm_medium=email) — 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. GoGuardianvideo [Analyzing A Million Songs on AWS Redshift](http://tech.marksblogg.com/importing-data-from-s3-into-redshift.html?utm_source=dbweekly&utm_medium=email) — A look at extracting data from 1 million songs, uploading it to AWS Redshift via S3, and running some analysis via psql. Mark Litwintschiktutorial [Unlimited Scalability Unprecedented Speed with the GridGain In-Memory Data Fabric](http://www.gridgain.com/products/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 Ignite™. GridGain In-Memory Data Fabricsponsored [![\](https://copm.s3.amazonaws.com/4cbb43be.jpg)](http://www.gridgain.com/products/in-memory-data-fabric/) [Postgres Query Plan Visualization](http://tatiyants.com/postgres-query-plan-visualization/?utm_source=dbweekly&utm_medium=email) — 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. Alex Tatiyantstools [KeRF: A Next-generation Time-Series and Tick Database](http://www.kerfsoftware.com/?utm_source=dbweekly&utm_medium=email) — 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. Kerftools [Binomial Options Pricing in SQL](https://www.periscopedata.com/blog/binomial-options-pricing-in-postgres.html?utm_source=dbweekly&utm_medium=email) — 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. Periscopetutorial [Gartner Sees Analytics Boom as More Data is Shared](http://www.datanami.com/2016/01/28/gartner-sees-analytics-boom-as-more-data-is-shared/?utm_source=dbweekly&utm_medium=email) — “forecasts greater uptake of emerging analytics technologies like semantic and graph analyses, simulation, complex event processing and neural networks” Datanaminews In brief [Happy Birthday, Hadoop: Celebrating 10 Years of Improbable Growth](http://www.datanami.com/2016/01/28/happy-birthday-hadoop-celebrating-10-years-of-improbable-growth/?utm_source=dbweekly&utm_medium=email) — “the first Hadoop cluster went into production at Yahoo 10 years ago” Datanaminews [Aerospike Adds GeoSpatial Data to Speedy NoSQL](http://www.datanami.com/2016/01/28/aerospike-adds-geospatial-data-to-speedy-nosql/?utm_source=dbweekly&utm_medium=email) Datanaminews [Get more from Redis: Autoscaling and Analytics from RedisGreen](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2016a&utm_content=link&utm_term=getmore%20autoscaling%20performance) — Redis auto-scaling and analytics. Backed by support from engineers with years of Redis scaling expertise. RedisGreentools sponsored [Kafka and Elasticsearch, a Perfect Match](https://qbox.io/blog/kafka-and-elasticsearch-a-perfect-match-1?utm_source=dbweekly&utm_medium=email) Roland Koflertutorial [Using Redis for PHP Session Storage](http://slaptijack.com/system-administration/using-redis-for-php-session-storage.html?utm_source=dbweekly&utm_medium=email) Slaptijacktutorial [Using GraphQL with MongoDB](https://compose.io/articles/using-graphql-with-mongodb/?utm_source=dbweekly&utm_medium=email) Composetutorial [Categorizing Images with Deep Learning Into Elasticsearch](https://www.elastic.co/blog/categorizing-images-with-deep-learning-into-elasticsearch?utm_source=dbweekly&utm_medium=email) Emmanuel Benazeratutorial [MySQL in Docker or Native – Performance Benchmarks](http://blog.balazspocze.me/2016/01/26/mysql-in-docker-or-native-performance-benchmarks/?utm_source=dbweekly&utm_medium=email) Balázs Pőczeopinion [Is Spark Replacing Hadoop?](http://sdtimes.com/is-spark-replacing-hadoop/?utm_source=dbweekly&utm_medium=email) SD Timesopinion [Redis latency](http://dtdg.co/1PkYlNZ?utm_source=dbweekly&utm_medium=email) — Instantly visible, alertable, and correlated with key evition rates, memory fragmentation ratio, and more. Datadogtools sponsored [1.7 Billion Reddit Comments Loaded on Google BigQuery](https://www.reddit.com/r/bigquery/comments/3cej2b/17_billion_reddit_comments_loaded_on_bigquery/?utm_source=dbweekly&utm_medium=email) Reddit Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/89) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*) [Stop getting this newsletter](*|UNSUB|*) Published by [Cooperpress](https://cooperpress.com/) Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK