SQL

MemSQL Design Principles

Design Principles at MemSQL

At MemSQL, we believe that every company should have the opportunity to become a real-time enterprise. We believe that data drives business, and that data management performance leads to successful business results. Specifically related to our products, we believe in: The Need for Performance To compete in a 24×7 business world, companies must be able to ingest data quickly, execute low latency queries, and support a large number of analytics users and data volume, all at the same time. The...


SQL: The Technology That Never Left Is Back!

The Prelude The history of SQL, or Structured Query Language, dates back to 1970, when E.F. Codd, then of IBM Research, published a seminal paper titled, “A Relational Model of Data for Large Shared Data Banks.” Since then, SQL has remained the lingua franca of data processing, helping build the relational database market into a $36 billion behemoth. The Rise And Fall of NoSQL Starting in 2010, many companies developing datastores tossed SQL out with the bathwater after seeing the challenges...


SQL

Why MemSQL Placed a Bet on SQL

In the technology industry, when products or innovations last for a long period of time, they are often here to stay. SQL is a great example of this – it has been around for over 30 years and is not going away anytime soon. When Eric Frenkiel and Nikita Shamgunov founded MemSQL in 2011, they were confident in choosing the SQL relational model as the foundation for their database. But the database industry during that era was clamoring around NoSQL, lauding it as the next great innovation,...


Incumbents and Contenders in the $33B Database Market

The database market continues to surprise those of us who have been in it for a while. After the initial wave of consolidation in the late 1990s and early 2000s, the market has exploded with new entrants: column-stores, document databases, NoSQL, in-memory, graph databases, and more. But who will truly challenge the incumbents for a position in the Top 5 rankings? Oracle, IBM, Microsoft, SAP, and Teradata dominate the $33B database market. Will it be a NoSQL database? Will it be an open source...


overlap targeting

Boost Conversions with Overlap Ad Targeting

Digital advertising is a numbers game played out over billions of interactions. Advertisers and publishers build predictive models for buying and selling traffic, then apply those models over and over again. Even small changes to a model, changes that alter conversion rates by fractions of a percent, can have a profound impact on revenue over the course of a billion transactions. Serving targeted ads requires a database of users segmented by interests and demographic information. Granular...


SQL Structure

In The End We Seek Structure

In Short: A range of assumptions led to a boom in NoSQL solutions, but in the end, SQL and relational models find their way back as a critical part of data management. In the End We Seek Structure. Why SQL and relational models are back as a critical part of data management – Click to Tweet Background By the mid 2000s, 10 years into the Netscape-inspired mainstream Internet, webscale workloads were pushing the limits of conventional databases. Traditional solutions could not keep up with...


Get in the DeLorean! It’s Time for the Database News Roundup.

Stop it database industry, we’re blushing. Imitation is the sincerest form of flattery and, as the spring conference season gives way to summer vacations, we’ve noticed a flood of announcements from database vendors doing their best MemSQL impressions. Here are a few stories that caught our attention. Oracle and SQL Server Go In-Memory The new Oracle 12c and SQL Server 2014 both feature in-memory storage engines on top of their existing disk-based storage. Seek latency and disk contention...


The Write Stuff

Tell me if this sounds familiar. Once upon a time a company ran its operations on The Database Server, a single machine that talked SQL. It was tricked out with fast hard drives and cool blue lights. As the business grew it became harder for The Database to keep up. So they bought an identical server as a hot spare and set up replication, at first only for backups and failover. That machine was too tempting to leave sitting idle, of course. The business analysts asked for access so they could...


How MemSQL Distributes Data

The world is moving toward highly-parallel, distributed systems up and down the stack. It started with the app servers on the front lines. Now it’s happening at the data layer. This is generally a good thing, but these kinds of systems can sometimes feel like a foreign country. In this article we’ll talk about how MemSQL spreads the work around a cluster of servers without sacrificing ease of use. There are two kinds of machines in a MemSQL cluster: aggregators and leaves. The same...


Through a Table, Sparsely

Take a look at your database. What do you see? An alphabetic list of table names. Is that really the most important thing to know? Surely, other facts about your database are more interesting. Maybe you want to know how big the tables are. Database table sizes, like mountain heights and city populations and book sales, tend to follow a pattern casually called a power-law distribution. A minority of tables hold the majority of data. The rest are a long tail of necessary but small things, a kind...