Issue 172 — September 15, 2017
The Weight of Relational Databases: Time for Multi-Model?
— A quick thought piece on the increasing role for polyglotism in database systems as needs become more complex.
Postgres's Workings in One Picture
— An interesting ‘infographic’ style image showing the various components of Postgres and how they stack together.
Data Sheet: Database Performance Monitoring
— VividCortex is the best way to improve your database performance, efficiency, and uptime.
Injecting a Chess Engine into Amazon Redshift
— Redshift is an SQL-based database with a Postgres-style frontend and curiously you can integrate compiled C code with it as in this extensive example.
Database Systems Reading List
— Links to a variety of 38 categorized papers on database management systems topics.
Over 4000 ElasticSearch Servers Found Hosting PoS Malware Files
A Sports School Data Model
— The latest in Vertabelo’s relational data modelling series.
A Four-Phased Approach to Building an Optimal Data Warehouse
Partitioning Behavior of DynamoDB
Get an intro to MongoDB with our Accelerator Kit
— For a limited time, we're making our best resources for learning MongoDB available for free & on demand.
How We Optimize Apache Spark Jobs
Enhancing Relational Models with Graph Processing in SQL Server 2017
Bringing DevOps Practices to Database Administrators
The Ultimate Guide to Oracle Indexes: Improve Your SQL Skills
— Learn all about index types, index scans, when to use each index type, and more in this article.
read-mongo-logs: A Tool to Tail Mongo Database Logs
Citus 7: Transactions, Framework Integration, and Postgres 10
— Citus extends Postgres with extra sharding features and now has Postgres 10 support.
Redisq: An Easy, Reliable Java Library for Async Messaging in Redis