Author: Seth Luersen

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


1.3 Billion NYC Taxi Rows into MemSQL Cloud

Experience teaches us that when loading data into a database, in whatever form ― normalized, denormalized, schema-less, hierarchical, key-value, document, etc ― the devil is always in the data load. For enterprise companies in the real-time economy, every second saved means improved efficiency, productivity, and profitability. Thankfully, MemSQL Cloud makes your enterprise data fast to load and easy to access. You can spin up a cluster in MemSQL Cloud in minutes and load data very quickly...


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


Amazon S3 Real-Time Analytics

Turning Amazon S3 Into a Real-Time Analytics Pipeline

MemSQL 5.7 introduces a new pipeline extractor for Amazon Simple Storage Service (S3). Many modern applications interface with Amazon S3 to store data objects into buckets up to 5TB providing a new modern approach for today’s enterprise data lake. Without analytics, the data is just a bunch of files For modern enterprise data warehouses, the challenge is to harness the unlimited nature of S3 for ad-hoc and real-time analytics. For traditional data warehouse applications, extracting data from...


The State of Real Time for Property Insurers

The State of Real Time for Property and Casualty Insurers

In some industries, a hesitance remains in recognizing the commodification forces of real-time solutions. These industries often rely on orthodox tenets as barriers to marketplace entry, such as regulatory compliance, traditional value propositions, brand recognition, and market penetration. The term “ripe for disruption” often characterizes these industries and their respective leaders. Arguably, an illustrative industry in the midst of responding to commodification, adapting to real-time...


Free MemSQL Resources

A Guide to Free MemSQL Educational Resources

For interested database developers, database administrators, and data scientists, we proudly offer several learning resources. These include YouTube educational videos, Enterprise trial Editions of MemSQL, extensive public product documentation, knowledge base articles, a SlideShare presentation repository, and a public Slack channel. Online Education Videos We have numerous videos available at youtube.com/memsql Ankur Goyal: Database Systems Class, CMU, April 2016 Learn from Ankur Goyal, our...