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


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


Video: Delivering Real-Time Feedback Loops for Education

At Strata Data Conference in September, David Mellor, VP and Chief Architect at Curriculum Associates, showed how the company creates real-time feedback loops for students and educators. David covered how to build a real-time application with MemSQL, and how his team architected a combination of data workflows for actively updating data, such as student activity through online lessons and diagnostics. One workflow relies on in-memory processing to serve responses in under 200 milliseconds. The...


Five Sessions to Attend at AWS re:Invent 2017

Amazon will finish an exciting year by bringing together thousands of people to connect, collaborate, and learn at AWS re:Invent from November 27 – December 1 in Las Vegas. Whether you are a cloud beginner or an experienced user, you will learn something new at AWS re:Invent. This event is designed to educate attendees about the AWS platform, and help develop the skills to design, deploy, and operate infrastructure and applications. MemSQL is exhibiting in the Venetian Sands Expo Hall, so...


Data Warehouse in the Age of AI Maturity

The MemSQL maturity framework for data warehousing in the age of artificial intelligence depicts the journey of digital transformation. Caption: Data Warehouse in the Age of AI Maturity Framework by MemSQL. Consisting of three epics and seven maturation stages that symbolize increasing strategic value, the framework outlines the transformation from descriptive analytics to predictive analytics to prescriptive analytics for modern organizations and enterprises.   In this blog post, we...


How Database Convergence Impacts the Coming Decades of Data Management

Within the database industry, there are often paradigm shifts in the market that create opportunities for new types of technology to emerge. When those shifts happen, new technology requirements come up and old technologies do not satisfy those requirements. There have been many shifts in the database market including, NoSQL, big data, in-memory, Internet of Things, cloud computing, and many others. Recently, MemSQL CEO and Co-founder, Nikita Shamgunov, presented to a group of database...


Blog header

Blueshift: Succeeding with Real-Time Analytics

Integrated Business Planning in the Cloud Blueshift ONE combines the complexity of business planning, including commercial planning, sales forecasting and budgeting, along with supply chain planning, into an integrated cloud solution.    The integrated view of data gives Blueshift ONE customers a competitive edge with accurate reliable data that is shared across corporate functions during the business planning process. The integrated platform delivers a single consensus forecast across all...


JSON Streaming And The Future Of Data Ingest

As businesses continue to become technology focused, data is more prevalent than ever. In response, companies have adopted a handful of common formats to help manage this explosive growth in data. Data Formats Today For a long time, XML has been the giant in terms of data interchange formats. Recently, JSON has become popular, catching a wave of interest due to its lightweight streaming support, and general ease of use. JSON is a common format for web applications, logging, and geographical...


Running Stored Procedures on Distributed Systems with MemSQL 6

Today we’re announcing the general availability of MemSQL 6. This is a big milestone for the product, which comes with new features to help customers get even more value out of MemSQL. The latest release includes breakthrough query performance, enhanced online operations, and extensibility. In this blog, we’ll take a deeper look at the new Extensibility features. Why did you add Extensibility to MemSQL 6? The Extensibility feature was built based on market demand, and enables people to move...