blog header

Just Like IoT, Enterprises Have Been Using AI All Along

Just like IoT, around in various forms for years, AI has been prevalent in nearly every enterprise for decades. The catch? It was hidden inside the databases and data warehouses in use under the banner of Query Optimization. Query optimization is the process where a database or data warehouse takes the input from a user’s question, and reworks that question to deliver a quick response with as few compute resources as possible. The number of query plan choices reach far beyond what a human can...


Shattering the Trillion-Rows-Per-Second Barrier With MemSQL

Last week at the Strata Data Conference in San Jose, I had the privilege of demonstrating MemSQL processing over a trillion rows per second on the latest Intel Skylake servers. It’s well known that having an interactive response time of under a quarter of a second gives people incredible satisfaction. When you deliver response time that drops down to about a quarter of a second, results seem to be instantaneous to users. But with large data sets and concurrency needs, giving all customers...


blog header

Full-Text Search in MemSQL

Today, we are sharing that MemSQL now has Full-Text Search, a highly requested feature, built into the product. Thanks to customer feedback, we are delighted to make it available for all companies building real-time applications. What is Full-Text Search? You might be thinking, “MemSQL is pretty fast at searching things and they already support large strings, so why do they need to add anything?” So let’s start with a description of Full-Text Search (FTS). Full-Text Search is different...


blog header

Recapping An Evening with MemSQL Engineering

Recently, we hosted a special meetup at our headquarters in San Francisco for the community, and shared some great talks. The slides for each talk and the video presentations have been made available below. Drew Paroski, MemSQL VP of Engineering and Adam Prout, MemSQL Chief Architect delivered a fun talk about taking a methodical approach for making a decision, dug into interesting tradeoffs, and gave tips about what to look for under the hood and how to evaluate the tech behind the database,...


blog header

Go Beyond Legacy Data with Change Data Capture, MemSQL, and Real-Time Applications

Data is driving innovative customer experiences, operation optimization, and new revenue streams. Data infrastructure teams are being asked to update their legacy infrastructure to respond to changing business conditions without disrupting existing operations. The future of data management is modernizing legacy systems using real-time data synchronization with modern databases that can accelerate innovation without impacting existing applications. The Challenge of Legacy Systems A constant...


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