A columnstore database takes all the values in a given column – the zip code column in a customer database, for instance – and stores all the zip code values in a single row, with the column number as the first entry. So the start of a columnstore database’s ZIP code record might look like this: 5, 94063, 20474, 38654… The “5” at the beginning means that the ZIP code data is stored in the fifth column in the rowstore database of customer names and addresses that the original data comes from. Columnstore databases make it fast and easy to …

The AI Data Science Summit 2019 featured a keynote by MemSQL’s CEO, Nikita Shamgunov, where he was hosted by MemSQL partner Twingo. Nikita, a co-founder of MemSQL and the technical lead from the beginning, has shepherded MemSQL’s development toward a world where cloud, AI, and machine learning are leading trends in information technology. Now that these trends are becoming predominant, MemSQL is playing an increasing role, as Nikita discussed in his keynote. What follows is an abbreviated version of his presentation, which you can view in full here. – Ed. Today I want to talk about the demands of AI …

MemSQL has reached a benchmarking breakthrough: the ability to run three very different database benchmarks, fast, on a single, scalable database. The leading transactions benchmark, TPC-C, and analytics benchmarks, TPC-H and TPC-DS, don’t usually run on the same scale-out database at all. But MemSQL runs transactional and analytical workloads simultaneously, on the same data, and with excellent performance. As we describe in this webinar write-up, our benchmarking breakthrough demonstrates this unusual, and valuable, set of capabilities. You can also read a detailed description of the benchmarks and view the recorded webinar. MemSQL stands out because it is a relational database, …