DB Weekly Issue 114: July 22, 2016

Is Logical Data Modeling Obsolete? — 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?

3 NoSQL Databases You’ve Never Heard Of — A quick look at MUMPS (a 51 year old database designed for healthcare use), c-treeACE, and FinchDB.

How SmartNews Built a Content Recommendation Engine on AWS — Not solely about databases, but ultimately SmartNews is a heavily data-driven organization and its use of numerous tools and services is striking.

SQL Dashboards in a Flash. — Periscope Data lets you run analyses over billions of rows in seconds.

Charting Neo4j 3.0 — "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."

Using SQL to Monitor a PostgreSQL Database — 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.

Our Journey From Graph Databases to PostgreSQL — 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.

BuntDB: Embeddable, In-Memory Key/Value Database in Go — A low-level, in-memory (but persists to disk), key/value store in pure Go, with geospatial support. Inspired by BoltDB.

Writing More Legible SQL — 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.

Redis Labs Raises 14ドルM for Its In-Memory NoSQL Database Services — 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.

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.

Stop wasting time - know what you'll earn before the interview — 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

9 Ways Retailers Are Using Big Data and Hadoop

Building a Better Pokédex with SQL

How to Know if a Given Index Can be Dropped on an Oracle Database

Inheritance: One More Reason to Love PostgreSQL — A brief look at table inheritance in Postgres, if you’re not already familiar with it.

Tuning MySQL: my.cnf, Avoid This Common Pitfall

Anatomy of an Elasticsearch Cluster: Part II

Distributed Deep Learning on Spark — An overview of tools and frameworks that have been proposed for performing deep learning on Spark.

Supercharging Apache Spark with Flash and NoSQL

OhgodnoSQL: How Not To Do 'NoSQL on SQL'

Migrating Adbrain’s Apache Spark Jobs From HDFS to Amazon S3: How We Did It

Optimizing DISTINCT Performance in Postgres

How Cassandra’s Inner Workings Relate to Performance

Getting Started with MongoDB: How to Turn a Calculated Risk into a Big Success

Battle of Open Source Analytics: Spark vs Drill vs Quasar

Where's the bottleneck? Find out with Datadog — Monitor DB performance alongside CPU, memory, disk, and network metrics to spot resource issues immediately.

PowerUpSQL: A PowerShell Toolkit for Attacking SQL Server — Tools to audit for weak configurations.

JCQL: Java Code Linting with SQL — An interesting idea - querying source code with SQL.