Database

A Brief Introduction to MemSQL

A Brief Introduction to MemSQL

We know choosing or evaluating a new database technology can be challenging due to the variety of choices available. In a recent webcast, we shared various use cases businesses face with traditional database and data warehouse technologies, key differentiators and architectures of MemSQL, sample applications and customer case studies, and a quick demo of MemSQL. MemSQL provides an adaptable database for real-time applications that unite transactions and analytics in a single high-performance...


Using MemSQL within the AWS Ecosystem

The database market is large and filled with many solutions. In this post, we will take a look at what is happening within AWS, the overall data landscape, and how customers can benefit from using MemSQL within the AWS ecosystem. Understanding the AWS Juggernaut At AWS re:Invent in December 2017, AWS CEO Andy Jassy revealed that the business is at a revenue run rate of $18 billion, growing 42 percent per year. Those numbers are staggering and showcase the importance Amazon Web Services now plays...


An Engineering Approach to Database Evaluations

Whether you’re the CTO of the Rebel Alliance or the Galactic Empire, it could be very difficult to decide on your next database technology with the distraction of both sides constantly at war. In 2018, you’ll need to make a database choice for an existing or new application. Here are the things you need to keep in mind as you shop for your next database. 8 Criteria To Keep In Mind While Looking For Your Next Database 1) Pick the right language: SQL The history of SQL, or Structured...


Scaling Distributed Joins

Most users of SQL databases have a good understanding of the join algorithms single-box databases employ. They understand the trade-offs and uses for nested loop joins, merge joins, and hash joins. Distributed join algorithms, on the other hand, tend not to be as well understood. Distributed databases need to make a different set of tradeoffs to account for table data that is spread around a cluster of machines instead of stored on a single machine, like in a traditional database. Because these...