Category: Column Stores

Feed: MemSQL Blog. Author: Floyd Smith. MemSQL CEO Nikita Shamgunov was featured recently on the Data Engineering Podcast with host Tobias Macey. Tobias drew out Nikita on MemSQL’s origins, our exciting present, and where we’re going in the future. We share a few highlights here, but we also urge you to listen to the full episode. The podcast covered a wide variety of topics. In this blog post, we’ll highlight Nikita’s comments on MemSQL’s origins; setting up and running the MemSQL database; typical use cases; and the future of MemSQL. How MemSQL Started Nikita grew up and was educated in ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. You can take advantage of a free download of key chapters from the exciting e-book, Designing Data-Intensive Applications. The chapters included in the free download cover two areas of vital concern to most MemSQL users, and indeed most developers and architects: transactions and streaming data. Designing Data-Intensive Applications, as a complete book, is more than 500 pages long. It takes as its premise that data is at the center of many of the challenges in system design today. (This is not a premise that is a surprise to us at MemSQL.) Designing Data-Intensive Applications ... Read More

Feed: MemSQL Blog. Author: Mike Boyarski. AWS re:Invent, which ended yesterday, was a very busy and energetic trade show, with an estimated 50,000-plus people in attendance. There were a few highlights and some new news that I can share from spending the week at the show. AWS spent a lot of time on AI and machine learning. The main focus was on tooling for delivering advanced analytics easily. While most of the tooling is software, Amazon also announced hardware: a new processor, Inferentia, that is promised to run AI applications with high performance and at low cost. This follows a ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. In this webinar, Eric Hanson, Principal Product Manager at MemSQL, describes the key features of MemSQL 6.7, which is focused on usability, compatibility, and (as with every release) performance. View the webinar now, download the slides, or read all about it below. Highlights of MemSQL 6.7 include the new, and very popular free tier for MemSQL, which ZDNet describes as having “full functionality to support real-world use cases”. Also included in MemSQL 6.7 are improved ease of use, faster queries, and new tools for monitoring and monitoring MemSQL. The new release also includes an ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Scaling distributed systems is hard. Scaling a distributed database is really hard. Databases are particularly hard to scale because there are so many different aspects you have to consider. For example, which dimension is growing, and how fast, will dictate what resources you need to increase in order to handle the workload and maintain your service level agreements (SLAs). Some problems require more CPU, some more RAM, and some more storage. Many times, you need a combination. Knowing how much you need up front is tough to determine. In addition, requirements change over time ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Epigen Technology depends heavily on MemSQL as part of its core toolkit. “Without MemSQL, I can’t do what I do,” says Terry Rice, founder of Epigen. Visit MemSQL at AWS re:Invent booth #1905 in Las Vegas, November 27-30. Epigen Technology uses software to innovate in many fast-changing areas of technology, including cybersecurity, analytics, machine learning, artificial intelligence (AI), and the emerging area of cognitive computing. Now, Epigen has developed a framework for facial recognition in the cloud that combines AWS S3, MemSQL, machine learning, AI, and visualization. Terry Rice, founder of Epigen, is a ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Bill Vorhies of Data Science Central and Rick Negrin of MemSQL recently delivered a webinar on data lakes and the use of Hadoop in the age of operational machine learning (ML) and artificial intelligence (AI). In this blog post, we summarize some of the key points from the webinar, as a preview for the webinar. You can also view the recorded webinar at any point. Businesses need flexible access to their data to make the best decisions. Unfortunately, the systems in use today impose complexity and structural delays. MemSQL, a fast, fully scalable relational ... Read More

Feed: MemSQL Blog. Author: Eric Hanson. Performance is in MemSQL’s DNA. Last March, we shattered the trillion-rows-per-second scan barrier for processing a single SQL query on industry-standard Intel servers. That query processed data from a single table, and of course, lots of analytical queries use multiple tables, particularly star schemas. So we’ve broadened our vectorized, single instruction, multiple data (SIMD) query execution technology beyond single-table, group-by aggregate queries to star join group-by aggregate queries. A star join is a common kind of query that operates on what’s known as a star schema, used in most data warehouses and data marts, ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Areeba is an innovator in payments. It was using Hadoop for unstructured data and MariaDB as a relational database. Now, Areeba has added MemSQL to the mix for several projects, including fraud detection, anti-money laundering (AML), and product recommendations. Areeba is a financial services company that was spun out of Bank Audi, a leading Middle Eastern bank, last year. Previously, Areeba was the payment cards and electronic services division for Bank Audi. Now, Areeba has more than half a dozen banks as clients, running credit card loyalty programs and acting as a payment gateway ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Wag! has been called the “Uber for dogs”. The service matches dog owners with dog walkers, tracking and visualizing each walk in real time. The service is now available in more than 100 cities across America. Now, Wag! is using MemSQL to help them meet the demands of rapid growth. Dog owners start with a live map of dog walkers near them. They connect with a walker, set up the walk for their dog, and watch it proceed live, on a map of their neighborhood. Every walk ends with an activity report. The report ... Read More