blog header

MemSQL 201: Tips & Tricks Webcast

In a recent webcast, we shared tips and tricks for understanding MemSQL, best practices for implementation, and demoed MemSQL with a real-world use case. Here are five top tips and tricks we shared: When moving an application to, or creating one on MemSQL, start by thinking about whether rowstore or columnstore storage (or both) is ideal If you have high throughput requirements, consider using MemSQL Pipelines Use EXPLAIN and PROFILE operators to identify query bottlenecks Take advantage of...


2018 Gartner Magic Quadrant for Data Management Solutions for Analytics

The data management solutions for analytics market is evolving. Disruption is accelerating in this market, with more demand for broad solutions that address multiple data types and offer different delivery models. We are hosting complimentary access to the full Gartner Magic Quadrant for Data Management Solutions for Analytics, so you can learn more about what’s happening in this space. Access Here → MemSQL Positioned as Challenger in Gartner Magic Quadrant MemSQL has been positioned in...


2018 Outlook: Machine Learning and Artificial Intelligence

Recently, MemSQL commissioned a survey with O’Reilly Media to learn more about the adoption of artificial intelligence (AI) and machine learning (ML) in the workplace. According to the survey of over 1,600 respondents, 61 percent of respondents, regardless of company size, indicated ML and AI as their companies’ most significant data initiative for next year, when asked to pick from several options likely to be important concerns in today’s climate. With big data and business analytics...


Machine Learning and MemSQL

What is Machine Learning? Machine learning (ML) is a method of analyzing data using an analytical model that is built automatically, or “learned”, from training data. The idea is that the model gets better as you feed it more data points, enabling your algorithm to automatically get better over time.   Machine learning has two distinct steps, training, and operationalization. Training takes a data set you know a lot about (known as a training set), then explores the data set to find...


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...


How Infiswift Supercharged Its Analytics for IoT Applications

About Infiswift Infiswift optimizes the operation of physical things with connectivity and data. Its innovative platform makes it easy to connect and manage any number of endpoints at scale and build solutions that open new services or improve existing ones. Infiswift empowers its customers to be data-driven in industries such as agriculture, renewable energy, and manufacturing. It recently chose MemSQL as the real-time insights engine of its platform to deliver fast, reliable analytics. The...


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...


Data Warehouses and the Flying Car Dilemma

Traditional data warehouses and databases were built for workloads that manifested 20 years ago. They are sufficient for what they were built to do, but these systems are struggling to meet the demands of modern business with the volume, velocity, and user demand of data. IT departments are being challenged from both ends. On one side, companies want to analyze the deluge of data in real time, or near real time. On the other side, on the consumption end, the need to analyze and get value out of...


SELECT 5 from MemSQL Blog in 2017

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...


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...