#197 — March 30, 2018
Database Weekly
ArangoDB Reaping the Fruits Of Its Multi-Modal Labor — ArangoDB is an open source NoSQL database that offers a key/value store, graph database and document database all in one.
Datanami
Chaos Tools and Techniques for Testing the TiDB Distributed NewSQL Database — ‘Chaos’ testing is the idea of simulating random failures and seeing how resilient systems stand up to it. This post looks at how PingCAP uses chaos tools and techniques to test TiDB, its distributed, open source SQL database.
Siddon Tang
Does Graph Database Success Hang on Query Languages? — "Just think what kind of power any vendor could have over the industry if they got to control SQL, and you will begin to see why the battle for graph query language is important."
George Anadiotis (ZDNet)
Go Deep into Today’s Modern Data Tier to See the Root of the Problem Fast — SelectStar’s advanced analytics provide in-depth query metrics such as latency, prepared statements and requests to help you see where stumbling blocks may be lurking so you can quickly and effectively troubleshoot slow queries and improve performance.
SelectStar sponsor
▶ PostgreSQL at 20TB and Beyond: Analytics at a Massive Scale — A talk on how Postgres is being used to do near-real-time analytics on 400TB of high velocity data. 30 minutes.
Chris Travers
CockroachDB 2.0 Performance Makes Significant Strides — Learn which performance metrics matter, why to demand benchmark TPC-C results under serializable isolation, and how CockroachDB 2.0’s performance compares to 1.1.
Andy Woods
KSQL in Action: Enriching CSV Events with Data from RDBMS into AWS — How to use Apache Kafka and KSQL to join data from sources including CSV and RDBMS (such as MySQL) and stream it to targets such as AWS S3.
Robin Moffatt
Oracle Aims to Automate the Data Warehouse — Oracle wants to provide higher-level PaaS services (e.g. for machine learning) on top of its data infrastructure.
George Leopold
Making Hadoop Relatable Again — Is the key to Hadoop’s future to make it look more like a relational database?
Datanami
How to Investigate MongoDB Query Performance — Learn how to find slow-performing, cost-intensive queries and glean important statistics.
Phil Factor
Database Load Balancing for MySQL and MariaDB with ProxySQL — ProxySQL is a lightweight yet complex protocol-aware proxy that sits between MySQL clients and servers.
Severalnines
Behind The Scenes of A Database-as-a-Service Provider — An interview with JawsDB founder and owner John Willman.
David Smooke
Prevent Slow Queries with Smart Indexing Strategies from Studio 3T
Studio 3T sponsor
Data Collection Tools for Events Analytics — A brief look at some top tools you can use to collect event data into an SQL warehouse.
Artyom Keydunov