--- title: "#170: JOIN Elimination - An Essential Optimization for Advanced SQL Usage " publication: "DB Weekly" issue: 170 published_at: "2017-09-01" canonical_url: "https://dbweekly.com/issues/170" --- Database Weekly 170 This week's database news -[Read this on the Web](http://dbweekly.com/issues/170) [Database Weekly](http://dbweekly.com) Issue 170 — September 1, 2017 [JOIN Elimination: An Essential Optimization for Advanced SQL Usage](https://blog.jooq.org/2017/09/01/join-elimination-an-essential-optimiser-feature-for-advanced-sql-usage/?utm_source=dbweekly&utm_medium=email) — It’s possible to transform many SQL statements into more optimized ones. This is a deep dive into how that works when joins are involved. Lukas Edertutorial [How Salesforce Is Using AI to 'Democratize' SQL](https://techcrunch.com/2017/08/29/salesforce-is-using-ai-to-democratize-sql-so-anyone-can-query-databases-in-natural-language/?utm_source=dbweekly&utm_medium=email) — ..so anyone can query databases in natural language. It’s explained in detail in [this academic paper](https://einstein.ai/static/images/layouts/research/seq2sql/seq2sql.pdf). TechCrunchnews [Understanding Tricky Joins and Multi-Table Updates](https://build.affinity.co/understanding-tricky-joins-and-multi-table-updates-in-postgresql-using-boolean-algebra-7b329606ca45?utm_source=dbweekly&utm_medium=email) — Writing a proper SQL UPDATE query involving multiple tables in Postgres can be tricky and counterintuitive. Here’s a particularly tricky example and the concepts involved. Paul Martineztutorial [HumongouS.io: A universal admin interface for MongoDB](https://www.humongous.io/) — Generate automatically an enterprise grade admin interface for your MongoDB database with support for joins, custom views, smart forms and charts. HumongouS.​iosponsored [![\](https://copm.s3.amazonaws.com/900899e6.png)](https://www.humongous.io/) [Five Sharding Data Models and Which Is Right](https://www.citusdata.com/blog/2017/08/28/five-data-models-for-sharding/?utm_source=dbweekly&utm_medium=email) — A survey of five sharding approaches and what factors could guide you to each approach. Craig Kerstienstutorial [Deferrable SQL Constraints in Depth](https://begriffs.com/posts/2017-08-27-deferrable-sql-constraints.html?utm_source=dbweekly&utm_medium=email) — Automatic constraint enforcement is a useful and powerful feature, but sometimes there are reasons to defer enforcement, as examined in depth here. Joe Nelsontutorial [How We Designed CrateDB as a Realtime SQL DBMS for IoT](https://thenewstack.io/designed-cratedb-realtime-sql-dbms-internet-things/?utm_source=dbweekly&utm_medium=email) — The DBMS design choices that Crate.io made to support an IoT workload. Jodok Batloggopinion [KSQL: Open Source Streaming SQL for Apache Kafka](https://www.confluent.io/blog/ksql-open-source-streaming-sql-for-apache-kafka/?utm_source=dbweekly&utm_medium=email) — KSQL provides a simple and interactive SQL interface for processing data in Kafka, rather than having to write Python or Java functions. Neha Narkhedenews [Percona Live Europe 2017 - Dublin (25-27 September)](https://hubs.ly/H08sm7l0) — Join the Open Source database community for various talks on MySQL, MongoDB, MariaDB, PostgreSQL, RocksDB & more. Percona Live Europesponsored [PostgreSQL 10 Beta 4 Released](https://www.postgresql.org/about/news/1776/?utm_source=dbweekly&utm_medium=email) postgresql.​orgnews [New Perf Levels and Storage Add-ons for Azure SQL Database](https://azure.microsoft.com/en-us/blog/new-performance-levels-and-storage-add-ons-in-azure-sql-database/?utm_source=dbweekly&utm_medium=email) Morgan Oslakenews [MongoDB Drops Support for Solaris](https://engineering.mongodb.com/post/farewell-solaris?utm_source=dbweekly&utm_medium=email) MongoDB Engineeringnews [A Guide to Data Synchronization in Microsoft SQL Server](https://codeburst.io/guide-to-data-synchronization-in-microsoft-sql-server-5c8d65b606c3?utm_source=dbweekly&utm_medium=email) Brandon Morellitutorial [Using JS for Extending Low-Latency In-Memory Key-Value Stores](https://blog.acolyer.org/2017/08/22/javascript-for-extending-low-latency-in-memory-key-value-stores/?utm_source=dbweekly&utm_medium=email) — A look at the potential for JavaScript in RAMCloud. Adrian Colyerstory [The Hidden Costs of Data Engineering](https://www.vividcortex.com/resources/hidden-costs-of-data-engineering?utm_campaign=DB%20Weekly&utm_source=ppc&utm_medium=Hidden%20Costs%20of%20Data%20Engineering) — Managing databases in today's environments presents many complex problems. See the impact in this 2016 survey. VividCortexsponsored [The 20 Best MySQL GUI Tools as of 2017](https://medium.com/bestoflist/20-best-mysql-gui-tools-2017-e1abe055475e?utm_source=dbweekly&utm_medium=email) Krissanawat​ Kaewsanmuangtools [Honey SQL: Turn Clojure Data Structures Into SQL](https://github.com/jkk/honeysql?utm_source=dbweekly&utm_medium=email) Justin Kramercode Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/170) [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