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

Database Weekly 113   . 

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

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

Featured [Modeling Polymorphic Associations in a Relational Database](https://hashrocket.com/blog/posts/modeling-polymorphic-associations-in-a-relational-database?utm_source=dbweekly&utm_medium=email) — Polymorphic associations can be difficult to correctly represent in a relational database. This post compares four different ways to model these challenging relationships. Jack Christensentutorial [A Beginner's Guide to Thinking in SQL](http://www.sohamkamani.com/blog/2016/07/07/a-beginners-guide-to-sql/?utm_source=dbweekly&utm_medium=email) — At first glance, SQL can look straightforward, but its simple elements can add up to something quite confusing. This primer provides some examples and advice on getting your head around some of SQL’s underlying concepts. Soham Kamani [DBSherlock: A Performance Diagnostic Tool for Transactional Databases](https://blog.acolyer.org/2016/07/14/dbsherlock-a-performance-diagnostic-tool-for-transactional-databases/?utm_source=dbweekly&utm_medium=email) — A nice intro to DBSherlock, a performance explanation framework that helps DBAs diagnose performance problems Adrian Coyiertools [Free t-shirt when you deploy RethinkDB in July](https://www.compose.io/articles/try-rethinkdb/?utm_source=cooper&utm_medium=db-weekly&utm_campaign=rethinkdb-shirt-july) — This month only we're giving away a free limited edition tshirt when you deploy RethinkDB on Compose. All deployments are free for 30-days. Composesponsored [![\](https://copm.s3.amazonaws.com/df7ac7db.png)](https://www.compose.io/articles/try-rethinkdb/?utm_source=cooper&utm_medium=db-weekly&utm_campaign=rethinkdb-shirt-july) [1.1 Billion Taxi Rides with MapD and 4 NVIDIA Titan Xs](http://tech.marksblogg.com/billion-nyc-taxi-rides-nvidia-titan-x-mapd.html?utm_source=dbweekly&utm_medium=email) — GPUs provide a compelling option for higher data processing power, but it’s even possible to make major savings depending on which GPUs you choose. Mark Litwintschikstory [How to Model Human Relationships](http://www.vertabelo.com/blog/technical-articles/how-to-model-relationships?utm_source=dbweekly&utm_medium=email) — A look at a robust but flexible way to model the relationships between people and organizations in a relational database. Vertabelotutorial [Faster PostgreSQL Searches with Trigrams](http://blog.scoutapp.com/articles/2016/07/12/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity?utm_source=dbweekly&utm_medium=email) — pg_trgm is a PostgreSQL extension providing simple fuzzy string matching which, in some circumstances, can be a lot faster to use than full-text search. Greg Navistutorial [How to Build Your Own Semantic Search Engine](http://livestream.com/structure/structuredata2016/videos/114953068?utm_source=dbweekly&utm_medium=email) — Hear how Mattermark, a startup providing data on privately held companies, is making its search engine smarter with deep learning. Structure Eventsvideo [Comparing Data Structures For Storage on Disk](http://blog.omega-prime.co.uk/?p=197&utm_source=dbweekly&utm_medium=email) — A look at various data structures (e.g. B trees and fractal trees) and how ideal they are for disk-based storage scenarios. Max Bolingbrokeopinion Jobs [Stop Applying to Jobs - Let Companies Come To You](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-dbweekly) — On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 4,000+ companies instantly. Hired.​com In brief [Secrets of the Data Whisperer](http://www.datanami.com/2016/07/13/secrets-data-whisperer/?utm_source=dbweekly&utm_medium=email) — ‘Data whisperers’ are people who can connect data and models to actual business problems. Datanaminews [Citus Cloud Now Generally Available](https://www.citusdata.com/blog/2016/07/13/citus-cloud-ga/?utm_source=dbweekly&utm_medium=email) — A managed, hosted version of Citus’s enhanced Postgres, running on top of AWS. Citus Datanews [AWS Database Migration Service Now Supports Continuous Data Replication](https://aws.amazon.com/about-aws/whats-new/2016/07/aws-database-migration-service-now-supports-continuous-data-replication-with-high-availability-enables-ssl-endpoints-and-adds-support-for-sap-ase-formerly-sap-sybase-ase/?utm_source=dbweekly&utm_medium=email) — ..with high-availability, enables SSL endpoints, and adds support for SAP ASE. Amazon Web Servicesnews [MongoDB Security Basics For Your Deployments in AWS](http://blog.cloud.mongodb.com/post/147353604120/mongodb-security-basics-for-your-deployments-in?utm_source=dbweekly&utm_medium=email) — Tips to secure your MongoDB data if running on AWS. Jay Gordontutorial [Understanding Database Multitenancy](http://www.vinta.com.br/blog/2016/understanding-database-multitenancy/?utm_source=dbweekly&utm_medium=email) Filipe Ximenestutorial [A Speed Guide To Redis Lua Scripting](https://www.compose.com/articles/a-quick-guide-to-redis-lua-scripting/?utm_source=dbweekly&utm_medium=email) — Lua is an embeddable language you can use directly from inside Redis. Composetutorial [Is Datomic the Sequel to SQL?](http://blog.mojotech.com/is-datomic-the-sequel-to-sql/?utm_source=dbweekly&utm_medium=email) — The short answer is ‘no’, but Matthew thinks there’s a lot to take from the Datomic approach going forward. Matthew Forsythopinion [SQL Dashboards in a Flash.](http://www.launchbit.com/taz/11159-6330-111) — Periscope Data lets you run analyses over billions of rows in seconds. Periscope Datatools sponsored [SnappyData: A Hybrid Transactional Analytical Store Built On Spark](http://dl.acm.org/citation.cfm?id=2899408&utm_source=dbweekly&utm_medium=email) — An academic paper. ACMtools [aq: Query AWS Resources with SQL](https://github.com/lebinh/aq?utm_source=dbweekly&utm_medium=email) Binh Letools    

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