Category: Column Stores

Feed: MemSQL Blog. Author: JK Kim. GoGuardian is an Education Technology company that specializes in moderating student web activities by using machine learning to facilitate a better learning environment. We combine dynamic data inputs to calibrate student engagement and help educators draw conclusions about their class sessions. This means that there are a large number of events happening from more than 5 million students every single day. As one can imagine, handling all of these events is quite a challenge. This article will detail how we solved our data storage issues and querying challenges with our friends at MemSQL. OUR ENGINEERING CHALLENGES ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Time series data is as old as databases themselves – and also the hot new thing. Interest in the topic has more than doubled during this decade. MemSQL handles time series data effectively. MemSQL has robust support for rapid ingest, stellar analytical and transactional performance, easy manageability, SQL support for queries and analytics tools, and low total cost of ownership. Time series data is at the core of the Internet of Things, with frequent sensor readings coming in from all sorts of devices. Once you decide what readings to track for the servers in ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Time series data is as old as databases themselves – and also the hot new thing. Interest in the topic has more than doubled during this decade. In this blog post, we’ll explain what time series data is, why there’s an increasing focus on it, and how MemSQL handles it. In a companion blog post, we explain the considerations that go into choosing a time series database. Time series data is at the core of the Internet of Things, with frequent sensor readings coming in from all sorts of devices. But what is time ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. A Fortune 50 company tried traditional SQL databases, then Hadoop, to manage financial updates company-wide. They finally found a successful solution by augmenting Hadoop with MemSQL. Many companies today are straining to meet the needs for faster ad hoc analytics, dashboards, reporting, and support for modern applications that depend on fast access to the latest data – in particular, financial data. Facing competitive and customer pressures, IT organizations must respond to a rapid increase in the volume of incoming data and the needs of the business to use this data for rapid decision-making, improving ... Read More

Feed: MemSQL Blog. Author: Saeed Barghi. Storing and analysing larger and larger amounts of data is no longer what drives the decision-making process at successful companies. In today’s world, the key is how fast decision makers are provided with the right information, enabling them to make the right decision before it’s too late. Streaming analytics help you identify perishable insights, which are the subject of their very own Forrester Report. Perishable insights are results “which must be acted on within a given timeframe or else the chance to influence business outcomes will pass,” according to the IBM Cloud Blog. The ... Read More

Feed: MemSQL Blog. Author: Daniel Mittelman. Everything at monday.com starts and ends with data. We’re driven to succeed, and to do that, we must measure everything with precision and accuracy. That’s why we built our own business intelligence (BI) solution from scratch: our beloved BigBrain. It tracks every single KPI we have here at monday.com and in the spirit of transparency, we make these numbers readily accessible to everyone on our team. Our BigBrain team—currently 4 engineers and counting (we’re hiring!)—just wrapped up a big project to supercharge BigBrain as we embark on a new chapter of accelerated growth in our company ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. In this webinar, MemSQL Product Manager Jacky Liang took a live audience through the process of building an analytics app in just a few minutes. You can view the webinar and download the slides here. In just a few minutes in the middle of the webinar, Jacky created a free MemSQL account; installed memSQL on AWS; loaded in some data; and created a dashboard using Looker, a popular analytics tool. Jacky also explained some MemSQL basics and gave a quick overview of MemSQL’s architecture. We encourage you to read about the details here, then ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. What makes MemSQL unique? Its ability to combine the scalability of NoSQL databases and the familiar structure, transaction capabilities, and SQL support of traditional relational databases. MemSQL does all this while offering high performance on ingest, fast query response, and high concurrency – support for many active users at the same time. Because of its SQL support, MemSQL is “plug and play” with existing database systems and with all the people and tools that are part of the SQL ecosystem. The combination of capabilities that are offered in MemSQL are not found together anywhere ... Read More

Feed: MemSQL Blog. Author: David Gomes. We recently ported the 30,000 lines of JavaScript code in MemSQL Studio from Flow to TypeScript. In this article, I describe why we ported our codebase, how we carried out the process, and how it has been working out for us. I’d like to start by saying that my goal with this blog post is not to condemn Flow or usage of Flow. I highly admire the project, and I think that there is enough space in the JavaScript community for both type checkers. At the end of the day, each team should study ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. This blog post is adapted from the webinar, Hadoop Acceleration Strategies for Broader Use and Simplicity, led by Mike Boyarski. In this blog post, we focus on the middle section of the webinar, which describes the architecture of MemSQL You can easily click to view the complete webinar and download the full set of slides. Our recent Hadoop webinar includes a description of MemSQL’s architecture and some of its key benefits. In this blog post, we take you through that description, one step at a time. Introduction to MemSQL MemSQL describes its database software ... Read More