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

Database Weekly 114   . 

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

[Database Weekly](http://dbweekly.com) Issue 114 — July 22, 2016     

Featured [Is Logical Data Modeling Obsolete?](http://www.vertabelo.com/blog/technical-articles/what-a-concept-is-logical-data-modeling-obsolete?utm_source=dbweekly&utm_medium=email) — When databases were sized in megabytes rather than petabytes, their design was a well-defined discipline of data analysis and implementation, but how have things changed in the modern era? Andrew Wolfeopinion [3 NoSQL Databases You’ve Never Heard Of](http://www.datanami.com/2016/07/15/three-nosql-databases-youve-never-heard/?utm_source=dbweekly&utm_medium=email) — A quick look at MUMPS (a 51 year old database designed for healthcare use), c-treeACE, and FinchDB. Datanamistory [How SmartNews Built a Content Recommendation Engine on AWS](https://blogs.aws.amazon.com/bigdata/post/Tx2V1BSKGITCMTU/How-SmartNews-Built-a-Lambda-Architecture-on-AWS-to-Analyze-Customer-Behavior-an?utm_source=dbweekly&utm_medium=email) — Not solely about databases, but ultimately SmartNews is a heavily data-driven organization and its use of numerous tools and services is striking. Amazonstory [SQL Dashboards in a Flash.](http://www.launchbit.com/taz/11159-6331-111) — Periscope Data lets you run analyses over billions of rows in seconds. Periscope Datasponsored [![\](https://copm.s3.amazonaws.com/bc71e9fe.png)](http://www.launchbit.com/taz/11159-6331-111) [Charting Neo4j 3.0](https://neo4j.com/blog/charting-neo4j-3-0/?utm_source=dbweekly&utm_medium=email) — _“I want to show you how easy it got with Neo4j 3.0 to pull data from the graph into your JavaScript code and, for instance, create pretty charts from it.”_ Michael Hungertutorial [Using SQL to Monitor a PostgreSQL Database](http://www.vertabelo.com/blog/technical-articles/using-sql-to-monitor-a-postgresql-database?utm_source=dbweekly&utm_medium=email) — PostgreSQL provides an activity-tracking module called the statistics collector, which tracks table access and other internal events. If your database is experiencing long wait times, you may be able to use this tool and some simple SQL to find and fix the problem. Maria Alcaraztutorial [Our Journey From Graph Databases to PostgreSQL](http://engineering.hipolabs.com/graphdb-to-postgresql/?utm_source=dbweekly&utm_medium=email) — Graph databases have their time and place but just because you _can_ do something in a graph database doesn’t mean it’s ideal. Here, follow a journey taken from Mongo to Neo4j to Postgres. Engineering at Hipostory [BuntDB: Embeddable, In-Memory Key/Value Database in Go](https://github.com/tidwall/buntdb?utm_source=dbweekly&utm_medium=email) — A low-level, in-memory (but persists to disk), key/value store in pure Go, with geospatial support. Inspired by BoltDB. Josh Bakercode [Writing More Legible SQL](http://www.craigkerstiens.com/2016/01/08/writing-better-sql/?utm_source=dbweekly&utm_medium=email) — Writing SQL is one thing, but when it comes to reading other’s SQL, things can get tricky. These few tips will help to make your SQL much more understandable by others. Craig Kerstienstutorial [Redis Labs Raises $14M for Its In-Memory NoSQL Database Services](https://techcrunch.com/2016/07/21/redis-labs-raises-14m-for-its-in-memory-nosql-database-services/?utm_source=dbweekly&utm_medium=email) — Redis Labs, the company behind the open source Redis data structure store, today announced that it has raised a $14 million Series C round led by Bain Capital. Frederic Lardinoisnews Jobs [Operations Engineer](https://www.getharvest.com/careers/operations-engineer) — We are looking for an experienced Operations Engineer to join our remote team to work on things like AWS deployment, Ansible, MySQL, nginx, unicorn & Sensu. Pacific, Alaska, & Hawaii–Aleutian Time Zones are preferred but this is not a requirement. Harvest [Stop wasting time - know what you'll earn before the interview](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-dbweekly) — On Hired, sign up in 10 minutes and get offers from top companies like GitHub, Uber, & Stripe. Engineers get an average of 5 offers on the platform in 1 week Hired.​com In brief [9 Ways Retailers Are Using Big Data and Hadoop](http://www.datanami.com/2016/07/20/9-ways-retailers-using-big-data-hadoop/?utm_source=dbweekly&utm_medium=email) Datanaminews [Building a Better Pokédex with SQL](https://www.periscopedata.com/blog/pokemon.html?utm_source=dbweekly&utm_medium=email) Periscopetutorial [How to Know if a Given Index Can be Dropped on an Oracle Database](https://blog.jooq.org/2016/07/15/how-to-know-if-a-given-index-can-be-dropped/?utm_source=dbweekly&utm_medium=email) jOOQtutorial [Inheritance: One More Reason to Love PostgreSQL](http://www.cybertec.at/2016/07/inheritance-one-more-reason-to-love-postgresql/?utm_source=dbweekly&utm_medium=email) — A brief look at table inheritance in Postgres, if you’re not already familiar with it. Hans-Juergen Schoenigtutorial [Tuning MySQL: my.cnf, Avoid This Common Pitfall](https://haydenjames.io/my-cnf-tuning-avoid-this-common-pitfall/?utm_source=dbweekly&utm_medium=email) Hayden Jamestutorial [Anatomy of an Elasticsearch Cluster: Part II](http://insightdataengineering.com/blog/elasticsearch-core/?utm_source=dbweekly&utm_medium=email) Ronak Nathanitutorial [Distributed Deep Learning on Spark](https://www.oreilly.com/learning/distributed-deep-learning-on-spark?utm_source=dbweekly&utm_medium=email) — An overview of tools and frameworks that have been proposed for performing deep learning on Spark. Alexander Ulanovvideo [Supercharging Apache Spark with Flash and NoSQL](http://www.datanami.com/2016/07/21/supercharging-apache-spark-flash-nosql/?utm_source=dbweekly&utm_medium=email) datanamistory [OhgodnoSQL: How Not To Do 'NoSQL on SQL'](http://thedailywtf.com/articles/ohgodnosql?utm_source=dbweekly&utm_medium=email) The Daily WTFstory [Migrating Adbrain’s Apache Spark Jobs From HDFS to Amazon S3: How We Did It](http://www.adbrain.com/blog/migrating-adbrains-apache-spark-jobs-from-hdfs-to-amazon-s3-how-we-did-it?utm_source=dbweekly&utm_medium=email) Zoltan Arvaistory [Optimizing DISTINCT Performance in Postgres](https://explainextended.com/2009/05/03/postgresql-optimizing-distinct/?utm_source=dbweekly&utm_medium=email) Explain Extended [How Cassandra’s Inner Workings Relate to Performance](http://manuel.kiessling.net/2016/07/11/how-cassandras-inner-workings-relate-to-performance/?utm_source=dbweekly&utm_medium=email) Manuel Kiessling [Getting Started with MongoDB: How to Turn a Calculated Risk into a Big Success](http://tryupshot.com/stories/8?utm_source=dbweekly&utm_medium=email) Robert Fehrmannopinion [Battle of Open Source Analytics: Spark vs Drill vs Quasar](https://www.linkedin.com/pulse/next-generation-analytics-apocalypse-when-spark-drill-john-de-goes?utm_source=dbweekly&utm_medium=email) John De Goesopinion [Where's the bottleneck? Find out with Datadog](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeekly&utm_content=Databases) — Monitor DB performance alongside CPU, memory, disk, and network metrics to spot resource issues immediately. Datadogtools sponsored [PowerUpSQL: A PowerShell Toolkit for Attacking SQL Server](https://blog.netspi.com/powerupsql-powershell-toolkit-attacking-sql-server/?utm_source=dbweekly&utm_medium=email) — Tools to audit for weak configurations. Scott Sutherlandtools [JCQL: Java Code Linting with SQL](https://github.com/benas/jcql?utm_source=dbweekly&utm_medium=email) — An interesting idea - querying source code with SQL. Mahmoud Ben Hassinecode    

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