Category: Column Stores

Feed: MemSQL Blog. Author: Eric Hanson. The limitations of a typical, traditional relational database management system (RDBMS) have forced all sorts of compromises on data processing systems: from limitations on database size, to the separation of transaction processing from analytics. One such compromise has been the “sharding” of various customer accounts into separate database instances, partly so each customer could fit on a single computer server – but, in a typical power law, or Zipf, distribution, the larger database don’t fit. In response, database administrators have had to implement semi-custom sharding schemes. Here, we describe these schemes, discuss their limitations, ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. SSIMWAVE customers – from film producers to network engineers to media business executives – work to some of the highest standards in the world. They demand to work with the best. SSIMWAVE also works at that level, as the company’s 2015 Emmy award for engineering achievement demonstrates. They also ask the same high standards of their technology vendors/partners. For SSIMWAVE’s rather comprehensive analytics needs, only one database makes the grade: MemSQL. SSIMWAVE has unique technology and unique analytics needs. SSIMWAVE mimics the human visual system, enabling the software to quantify the quality of video ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Medaxion has found a solution to the analytics problems that plague companies across the health care sector and beyond. John Toups, CTO of Medaxion, puts it plainly. “By combining the ease of presentation and abstraction of Looker for analytics, with the technical prowess of MemSQL as the database behind Looker, we now have simply the best analytics in healthcare.” Medaxion has changed the working lives of anesthesiologists, its core customers. These highly skilled professionals must deliver absolutely critical medical care, day after day, while also meeting demanding business requirements. These men and women, who ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. MemSQL extends our operational data platform with an on-demand, elastic cloud service, and new features to support Tier 1 workloads. MemSQL is proud to announce two exciting new product releases today: MemSQL Helios, our on-demand, elastic cloud database-as-a-service, and MemSQL 7.0 Beta 2, the next major release of our database engine, featuring MemSQL SingleStore – a breakthrough new way of managing data – and new features to fully support Tier 1, system of record workloads. With MemSQL Helios, you get instant, effortless access to the world’s fastest, most scalable data platform for operational analytics, ... Read More

Feed: MemSQL Blog. Author: Nate Horan. System of record capability is the holy grail for transactional databases. Companies need to run their most trusted workloads on a database that has many ways to ensure that transactions are completed and to back up completed transactions, with fast and efficient restore capability. MemSQL 7.0 includes new features that deliver very fast synchronous replication – including a second copy in the initial write operation, atomically – and incremental backup, which offers increased flexibility and reliability. With these features, MemSQL 7.0 offers a viable alternative for Tier 1 workloads that require system of record ... Read More

Feed: MemSQL Blog. Author: Eric Hanson. MemSQL SingleStore is a new vision for how databases can work – first blurring and then, for most use cases, erasing any apparent difference between today’s rowstore and columnstore tables. In MemSQL SingleStore Phase 1, shipping as part of MemSQL 7.0, rowstore tables get null compression, lowering TCO in many cases by 50%. Columnstore tables get seekable columnstores, which support fast seeks and updates, giving columnstore tables many of the performance and usability features of rowstore tables. The hard choices developers have faced up to now between rowstore and columnstore tables – or between ... Read More

Feed: MemSQL Blog. Author: Manish Pandey. In this webinar, which you can view here, Manish Pandey tells us about the transformative effect real-time data, machine learning, and artificial intelligence will make in helping financial services institutions meet increasing demands from consumers. (You can also see the slides.) Pandey, who is Sr. Director of Business Development and Digital Strategy at MemSQL partner Fiserv, highlights the power of MemSQL, and the smarts that Fiserv can bring to helping companies make the most out if it. – Editor As you know, financial services has always been an exciting world. And to add to ... Read More

Feed: MemSQL Blog. Author: David Gomes. Today is the one-year anniversary of MemSQL Studio and sees the release of MemSQL Studio 1.8.1. To celebrate, we have put together a brief summary of where we’ve taken MemSQL Studio in its first year, a few thoughts on how we will extend the product going forward, and an invitation to you to contribute your feedback. Just over a year ago, we launched the first release, MemSQL Studio 1.0.1. While the release notes detail everything that’s happened since, we want to reflect on the last year of development and give some additional context to ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. In this presentation, recorded shortly after MemSQL introduced MemSQL Pipelines, two MemSQL engineers describe MemSQL’s underlying architecture and how it matches up perfectly to Kafka, including in the areas of scalability and exactly-one updates. The discussion includes specific SQL commands used to interface MemSQL to Kafka, unleashing a great deal of processing power from both technologies. In the video, the MemSQL people go on to describe how to try this on your own laptop, with free-to-use MemSQL software. Introduction to MemSQL: Carl Sverre I want to start with a question. What is MemSQL? It’s ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. The MemSQL Forums are seeing more and more community contributions – not just timely and incisive questions, but answers from the community, and valuable content contributions as well. We have two new community stars for the summer, and some valuable Q&As flying back and forth. What Makes an Online Community Work? Participation in any online community is mostly optional. People always have a lot of ways they can spend their time, so for an online community to take off, it has to offer a lot to people. So it’s notable that the MemSQL Forums ... Read More