SELECT 5 from MemSQL Blog in 2017

Gary Orenstein
Gary Orenstein

2017 was a good year for the database market as developers, architects, and business leaders explored what is possible with new platforms.

We covered several hot topics on the MemSQL blog including the integration with microservices, recognition by industry analysts, machine learning and image recognition, real-time geospatial analytics, and multi-tenancy in a cloud world.

Here are a few of our favorite posts from 2017.

MemSQL Meets the Microservices Architecture

Link to post

Microservices captured application developer attention in 2017 and our own Dale Deloy shared his take on how MemSQL fits this ecosystem.

Each application service component has its own independent service deployment and flexible data model. The goal is to allow developers to focus on building business logic rather than coordinating with corporate models and infrastructure constraints.

Gartner Magic Quadrant for Data Management Solutions for Analytics

Link to post

This Magic Quadrant showcases leaders in data warehousing, and MemSQL placed as a challenger, recognized in particular for its operational data warehouse capabilities.

Get a full copy of the report at memsql.com/gartner.

Gartner analysts Simon James Walker and Michael Patrick Moran also identified real-time data as a top priority for data and analytics leaders in the report, Three Top Trends in Master Data Management Solutions Through 2017, highlighting the following impacts and recommendations:

Real-time data has emerged as a Master Data Management (MDM) priority for data and analytics leaders, with high availability master data a key capability as data volume, velocity and variety increases

Multidomain and multivector MDM enable digital business to advance from “collecting” data for a single data domain to “connecting” several data domains

Improved packaged industry MDM solutions are accelerating time to value, enabling data and analytics leaders to deliver successful MDM programs

An Engineering View on Real-Time Machine Learning

Link to post

In this post, Eric Boutin, Director of Engineering at MemSQL, answered a few questions including:

What do you see next in terms of new innovations in this arena?

I would like this field to innovate from two different directions. On the one hand, I would like to see databases support more and more algebra primitives to allow expressing more complex machine learning models. For example, supporting matrices, vector/matrix operators, aggregation across multiple vectors, and so on. This would allow expressing a growing number of machine learning algorithms in SQL. Even neural networks can be expressed as a sequence of scalar and vector operations. I would then like to see machine learning framework ‘push down’ algorithms into databases using SQL.

Video: Real-Time Analytics at UBER Scale

Link to post

Catch the details of the video and slides from Strata Data Conference San Jose, Real-Time Analytics at Uber Scale.

Database Multi-Tenancy in the Cloud and Beyond

Link to post

Multi-tenancy is a game changer for software-as-a-service and other applications. Understand the differences between approaches from a database perspective from MemSQL teammate, Alec Powell.

  1. Separated Database
  2. Separate Schema
  3. Shared Schema

Ringing in the New Year

Stay tuned for more from MemSQL in 2018. If you have any topic requests feel free to ping us on Twitter @memsql.