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


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


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


Why You Need a Real-Time Data Warehouse for IoT Applications

As always-on devices and sensors proliferate, the data emitted from these devices provides meaningful insights to improve customer experiences, optimize costs, and identify new revenue opportunities. In a recent report, Taking the Pulse of Enterprise IoT from McKinsey & Company, 48 percent of respondents cited “managing data” as a critical capability gap related to their IoT initiatives.1 The data infrastructure behind IoT applications requires a high performing and easy-to-access...


design blog

Designing for a Database: What’s Beyond the Query?

Even the most technically-minded companies need to think about design. Working on a database product at a startup is no different. But this comes with challenges, such as figuring out how to implement the human-centered design methodology at a technical company, but also contribute to building a design process that everyone agrees with across the organization. This blog will detail how product design is done at MemSQL as well as highlight how to design enterprise products at a startup.   How do...