---
title: "This week's database news, issue 90"
publication: "DB Weekly"
issue: 90
published_at: "2016-02-05"
canonical_url: "https://dbweekly.com/issues/90"
---

Database Weekly 90   . 

This week's database news -[Read this on the Web](http://dbweekly.com/issues/90) 

[Database Weekly](http://dbweekly.com) Issue 90 — February 5, 2016     

Featured [SnappyData: OLTP + OLAP Database built on Apache Spark](https://github.com/SnappyDataInc/snappydata?utm_source=dbweekly&utm_medium=email) — A distributed in-memory data store for real-time operational analytics, delivering stream analytics, OLTP (online transaction processing) and OLAP (online analytical processing) in a single integrated cluster. Written in Scala. Snappy Data, Inccode [When Simple SQL Can Be Complex](http://databaseblog.myname.nl/2016/01/when-simple-sql-can-be-complex.html?utm_source=dbweekly&utm_medium=email) — “A simple statement might have more complexity to it than you might think,” says Daniël, before showing us an example in `SELECT FALSE = FALSE = TRUE;` Daniël van Eeden [The Reference Data Pattern: Extensible and Flexible](http://www.vertabelo.com/blog/technical-articles/the-reference-data-pattern-extensible-and-flexible?utm_source=dbweekly&utm_medium=email) — What if you have dozens and dozens of reference tables? Is there an alternative to the one-table-per-type approach? Learn a generic and extensible database design for handling all your reference data. Jean-Marc Reynaudtutorial [How Things Work: Containers and Postgres](http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/webcasts/using-edb-postgres-containers-0?utm_source=cooperpress&utm_medium=nl&utm_campaign=Feb2016PGContainerWebinar) — The use of containers to simplify and speed the deployment and development of applications is taking off. Most container usage is focused around stateless micro-services, but data and transactions are key components of most applications. Register and attend this informational webinar. EnterpriseDBsponsored [![\](https://copm.s3.amazonaws.com/c2904a33.png)](http://www.enterprisedb.com/resources-community/webcasts-podcasts-videos/webcasts/using-edb-postgres-containers-0?utm_source=cooperpress&utm_medium=nl&utm_campaign=Feb2016PGContainerWebinar) [InfluxDB v0.10 GA: Support for 100,000s of Writes Per Second and 98% Better Compression](https://influxdata.com/blog/announcing-influxdb-v0-10-100000s-writes-per-second-better-compression/?utm_source=dbweekly&utm_medium=email) — InfluxDB is an open source time-series database designed for high-perf writes and compact disk storage with built-in clustering. Paul Dixnews tools [How Graph Databases Stop E-Commerce Fraud in Real Time](http://neo4j.com/blog/graph-database-ecommerce-fraud/?utm_source=dbweekly&utm_medium=email) — Graph databases can be used to detect common patterns in data and behavior surrounding fraud. Neo4j [Using PostgreSQL in R: A Quick How-To](http://www.win-vector.com/blog/2016/02/using-postgresql-in-r/?utm_source=dbweekly&utm_medium=email) — R is a great language when it comes to analytics, and Postgres is a great database. How about bringing the two together? Nina Zumel [BigQuery Under The Hood](https://cloud.google.com/blog/big-data/2016/01/bigquery-under-the-hood?utm_source=dbweekly&utm_medium=email) — A look at Google’s large scale data analysis platform. Notably, “it is nearly impossible to starve BigQuery out of resources [..] There is no such thing as one bad query taking down the entire service.” Google Cloud Big Data Blog Jobs [Heroku Data Infrastructure Engineer](https://www.heroku.com/careers/104?utm_source=dbweekly&utm_medium=email) — Join the Heroku Data team and learn about supporting and operating database systems at scale. Heroku [Stop Applying to Jobs - Let Companies Apply to You](https://hired.com/?utm_source=newsletters&utm_medium=dbweekly&utm_term=cat-tech-database&utm_content=stopapplyingtojobs&utm_campaign=q1-16&utm_location=us) — On Hired, sign up in 10 minutes and get offers from top companies like Facebook, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week. Try it today. Hired.​com In brief [Redis Connector Aims to Boost Spark Performance](http://www.datanami.com/2016/02/02/redis-connector-boosts-spark-performance/?utm_source=dbweekly&utm_medium=email) — An attempt to radically boost Spark performance by using Redis as an in-memory backing store. Datanaminews [What's New in Elasticsearch 3.0?](http://jolicode.com/blog/what-s-new-in-elasticsearch-3-0?utm_source=dbweekly&utm_medium=email) Jolicodenews [Redis Performance Dashboard and Autoscaling from RedisGreen](https://dashboard.redisgreen.net/new?utm_source=dbweekly&utm_medium=email&utm_campaign=2016a&utm_content=link&utm_term=findout%20autoscaling%20performance) — Redis auto-scaling and analytics. Backed by support from engineers with years of Redis scaling expertise. RedisGreentools sponsored [Diagnosing and Resolving MySQL Deadlocks](http://techblog.spanning.com/2016/02/02/Diagnosing-and-Resolving-MySQL-deadlocks/?utm_source=dbweekly&utm_medium=email) Brandon Mayestutorial [Summarizing Data in SQL](http://blog.yhat.com/posts/summarizing-data-in-SQL.html?utm_source=dbweekly&utm_medium=email) Matt DeLandtutorial [Running An Elasticsearch Cluster on Docker 1.9 with Swarm and Compose](https://medium.com/@yoanis_gil/running-an-elasticsearch-cluster-on-docker-1-9-with-swarm-and-compose-efabe110c675?utm_source=dbweekly&utm_medium=email) Yoanis Gil Delgadotutorial [How To Back Up, Restore, and Migrate PostgreSQL Databases with Barman on CentOS 7](https://www.digitalocean.com/community/tutorials/how-to-back-up-restore-and-migrate-postgresql-databases-with-barman-on-centos-7?utm_source=dbweekly&utm_medium=email) Sadequl Hussaintutorial [Five Things to Know about Databases that Leverage Partially Homomorphic Encryption](http://www.lab41.org/survey-of-encrypted-databases-that-leverage-partially-homomorphic-encryption/?utm_source=dbweekly&utm_medium=email) David Crookertutorial [If You’re A DB, You Need to Manage CPU, Memory and IO](https://ayende.com/blog/173153/if-youre-a-db-you-need-to-manage-cpu-memory-io?Key=9e988a02-aaf2-4a9d-be51-c9f3710ff3e5&utm_source=dbweekly&utm_medium=email) Oren Einiopinion [Hadoop's Second Decade: Where Do We Go From Here?](http://www.datanami.com/2016/02/02/hadoops-second-decade-where-do-we-go-from-here/?utm_source=dbweekly&utm_medium=email) Datanamiopinion [SQLDust: Complex SQL Generation from Elixir](https://github.com/archan937/sql_dust?utm_source=dbweekly&utm_medium=email) Paul Engelcode [Solve SIEBEL OM Crashes](http://www.launchbit.com/taz/11159-6245-111?utm_source=dbweekly&utm_medium=email) — Automated Siebel CRM Repository Review to solve OM crashes, data corruption, slow transaction, workflow and more for $1K in under 4 hours. Germain Softwaretools sponsored    

Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/90) [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