Author: Nikita Shamgunov

MemSQL 5

MemSQL 5 Ships with LLVM-based Code Generation for SQL Queries

We are proud to announce general availability for MemSQL 5 today. A key milestone in this release is a full fledged SQL compiler resulting in faster query processing across the board. Making this happen was a result of several months of hard work, which featured a large uplift of our existing database execution engine. This new SQL compiler is using LLVM for code generation. This modern compilation strategy is capable of supporting dynamic compilation of programming languages. In addition to...


high-speed-counters

Turn Up the Volume With High-Speed Counters

Scaling tends to make even simple things, like counting, seem difficult. In the past, businesses used specialized databases for particular tasks, including high-speed, high-throughput event counters. Due to the constraints of legacy systems, some people still assume that relational databases cannot  handle high-throughput tasks at scale. However, due to advances like in-memory storage, high-throughput counting no longer requires a specialized, single-purpose database. Why do we even need...


MemSQL Does Oracle’s Own Demo Ten Times As Fast, Sixty Times Cheaper

In preparation for Open World, I asked some of our engineers to recreate a demo that Oracle has been using over the last year to show off their “in-memory option.” It’s impressive to look at: the demo shows the database searching through billions of records from Wikipedia search trend data for popular terms in less than a second. The thing about Oracle’s demo is it runs on a gigantically expensive server. In fact it is the biggest one they have at 32TB of RAM and hundreds of CPU cores....


Announcing MemSQL Start[c]up 2.0

MemSQL is excited to announce Start[c]up 2.0 – the second annual programming competition hosted by Codeforces with an onsite at MemSQL HQ in San Francisco, California. Start[c]up 2.0 consists of two rounds. Round 1 is online and takes place on July 27th at 10:00 AM PST. Round 1 follows regular Codeforces rules and consists of 5 problems. For this round, the complexity of the problems will be comparable to a regular Codeforces round. There are no eligibility restrictions to participate in the...


Unsexy Database Features That Matter: Part 2

In the previous post, we talked about how you should focus on how people derive value from your product. Today we will focus on database management — your goal should always be 24/7 100% uptime. How People Manage A Database Product Deployment (time to get the system up and running) How much time does it take to get your product up and running? People have talked about barriers to entry for a long long time. The worst one is, “I couldn’t install your product so I gave up.” This is simply...


Unsexy Database Features That Matter: Part 1

As enterprise customers start to use your product in many different ways, new feature requests will start to flow into the product team. These features aren’t sexy features by any means, but every enterprise customer cares about them deeply, and we try to include as many customer feature requests as possible into every release, sexy or not. To really understand these unsexy features, we must examine two areas: How users derive value out of your product. How users manage a database product....


Oracle Announces an In-Memory Technology, At an Ungodly Speed…And Cost

Oracle OpenWorld started yesterday, and Larry Ellison announced new in-memory options in Oracle 12c. According to PCWeek “The Big Memory Machine costs $3 million, a sum Ellison termed as ‘a fraction’ of what competitors charge.” The core of the newly announced Oracle technology is a columnar store. It is in fact a fascinating technology that leverages compression, vectorized execution using SIMD, and parallel query processing. However, this technology has been on the market for a long...


Celebrating the MemSQL start[c]up Finals

This weekend MemSQL challenged some of the world’s best computer programmers in the finals of the inaugural MemSQL start[c]up competition. Similar to computer programming competitions held by Google and Facebook, MemSQL’s start[c]up showcased the best from around the world in a grueling 3 hour competition. [slideshow_deploy id=’664′] MemSQL Engineers pieguy, nika, exod40, SkidanovAlex and dolphinigle created a complex problem set for contestants. Made up...


Google's Code Jam World Finals - Two Senior MemSQL Engineers Make Top 25

MemSQL is proud to announce that David Stolp (Pieguy) and Nika Jimsheleishvili (nika) are on their way to Google’s London office to compete in the 2013 Code Jam World Finals. Pieguy and Nika will compete in the final competition this August for a chance to win $15,000 and the prestigious title of 2013 Code Jam Champion. To qualify for the chance to become Code Jam Champion, Pieguy and Nika have competed in four online qualifying competitions and finished in the top 25 out of more than...


Announcing start[c]up

MemSQL is excited to announce start[c]up – a programming competition, hosted by Codeforces with an onsite at MemSQL HQ in San Francisco, California. Start[c]up consists of two rounds. Both rounds will be prepared by MemSQL engineers: pieguy, nika,exod40, SkidanovAlex and dolphinigle. Round 1 is online and takes place on July 13. Round 1 follows regular Codeforces rules and consists of 5 problems. For this round, the complexity of the problems will be comparable to a regular Codeforces...