SQL

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


Modern Database Characteristics

Characteristics of a Modern Database

Many legacy database systems are not equipped for modern applications. Near ubiquitous connectivity drives high-velocity, high-volume data workloads – think smartphones, connected devices, sensors – and a unique set of data management requirements. As the number of connected applications grows, businesses turn to in-memory solutions built to ingest and serve data simultaneously. Bonus Material: Free O’Reilly Ebook – learn how to build real-time data pipelines with modern...


Coinalytics Taps MemSQL to Fuel Blockchain Analytics

Bitcoin has occupied headlines of technology and business publications over the past several years. The concept of digital currency, or cryptocurrency, rocked the financial industry, and public opinion about the applications of Bitcoin continues to ebb and flow. Today, Bitcoin is being overshadowed by another technology: blockchain. Blockchain is a public ledger for Bitcoin and other cryptocurrencies. This is where the real money is, say payment industry experts. Blockchain is a distributed...


Market Making with MemSQL: Simulating Billions of Stock Trades in Real Time

I woke up around 7:30 AM on Monday August 24th, checked my phone while lying in bed, and saw that I had lost thousands of dollars in my sleep. Great way to start the week… I was not alone – few investors escaped “Black Monday” unscathed. The past several months have been full of sudden surges and declines in stock prices, and extreme volatility is apparently the “new normal” for global financial markets. Frequent and dramatic market swings put a high premium on access to...


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


MemSQL Video Training

Introducing the First MemSQL Video Training Series

We are thrilled to have Carlos Bueno, Product Manager at MemSQL and an expert in performance tuning, as the leader of many of our training efforts. Prior to working at MemSQL, Carlos held critical engineering roles at Facebook, Yahoo, and several startups. He is the author of “Lauren Ipsum”, a popular children’s novel that introduces kids to computer science, as well as “Mature Optimization”, Facebook’s manual on performance measurement and optimization. We sat down with Carlos to...


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