Data Warehouse

hybrid cloud

The Real-Time Data Warehouse for Hybrid Cloud

As companies move to the cloud, the ability to span on-premises and cloud deployments remains a critical enterprise enabler. In this post, we’ll review the basics of a hybrid cloud model for MemSQL deployments to fit conventional and future needs. MemSQL Background MemSQL is a real-time data warehouse optimized for hybrid cloud deployments, and excels at operational use cases. MemSQL users are drawn to the ability to load and persist live data at petabyte scale while simultaneously querying...


real-time data warehousing

Real-Time Data Warehousing for the Real-Time Economy

In the age of manual decision making based on predictable data formats, data feeds, and batch processing times, enterprise businesses stayed current with ad hoc analyses and periodic reports. To generate analyses and reports, businesses relied on the traditional data warehouse. Using extraction, transformation, and load batch processes, the traditional data warehouse standardized disparate data into normalized schemas and pre-computed cubes. With the data shaped into pre-configured dimensions...


Database Multi-Tenancy in the Cloud and Beyond

In today’s wave of Enterprise Cloud applications, having trust in a data store behind your software-as-a-service (SaaS) application is a must. Thus, multi-tenancy support is a critical feature for any enterprise-grade database. This blog post will cover the ways to implement multi-tenancy, and best practices for doing so in MemSQL. As customer table sizes grow, you will need to scale out your multi-tenant database across dozens of machines. To support rich analytics about your customers or...


Magic Quadrant

Gartner Magic Quadrant for Data Management Solutions for Analytics

The data warehouse as we know it has changed. Growth in data size and complexity, migration to the cloud, and the rise of real-time use cases are forces pushing enterprise organizations to expect more from their data warehouse. Evidence of this trend can be found in the latest Gartner Magic Quadrant Report, which has dropped data warehouse from its title and graduated to Data Management Solutions for Analytics. This change has resulted in an expansion of types of vendors covered, while also...


Faster Data Warehouse Track at Gartner Data and Analytics Summit

Gartner Data and Analytics Summit kicks off next week in Grapevine, TX where MemSQL CTO Nikita Shamgunov will showcase the power of real-time for Chief Data Officers who are faced with transitioning their data warehouse applications to the cloud. Gartner Data and Analytics Summit features 8 tracks that will address top challenges facing data and analytics leaders. MemSQL executives and Gartner Analysts will deliver sessions on the benefits of a faster data warehouse throughout the summit. Our...


operational data warehouse

The Emergence of Operational Data Warehouses

Last month, we announced that MemSQL received the highest score in the Gartner Critical Capabilities Report for the “Operational Data Warehouse Use Case”. While the findings Gartner shared are gratifying, this deserves a bit of a deeper dive. For starters, let’s examine how Gartner defines an Operational Data Warehouse: “This use case manages structured data that is loaded continuously in support of embedded analytics in applications, real-time data warehousing, and operational data...


Gartner Magic Quadrant Data Warehouse Solutions

Complimentary Report: Gartner Magic Quadrant for Data Warehouse Solutions

Gartner has named MemSQL a Visionary in the Magic Quadrant for Data Warehouse and Management Solutions for Analytics! This marks our debut in Gartner’s report for data warehouse solutions and our second showing on a Gartner Magic Quadrant report in the last six months. The report compares top Data Warehouse solutions, as well as highlights key strengths that distinguish MemSQL from legacy vendors. MemSQL Strengths include: Focus on supporting transactional and analytical use cases with...