Category: Column Stores

Feed: MemSQL Blog. Author: Kristi Lewandowski. On November 6, 2018, we made our then-new production product, MemSQL 6.7, free to use, up to certain limits, described below. To date, we’ve had more than 4,500 sign-ups for this version, with numerous individuals and companies using MemSQL to do some amazing things. To quickly recap, with MemSQL any customer can sign up and start using our full featured product, with all enterprise capabilities, including high availability and security, for free. In talking to customers about their experience and what they’ve built, feedback has been astounding, with folks telling us they can’t believe ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. SSIMWAVE customers work to some of the highest standards in the world – from film producers to network engineers to media business executives. 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 streams, ... Read More

Feed: MemSQL Blog. Author: Rick Negrin. In this blog post, the first in a two-part series, I’m going to describe pre-modern databases: traditional relational databases, which support SQL but don’t scale out, and NoSQL databases, which scale out but don’t support SQL. In the next part, I’m going to talk about modern databases – which scale out, and which do support SQL – and how they are well suited for an important new workload: operational analytics. In the Beginning: OLTP Online transaction processing (OLTP) emerged several decades ago as a way to enable database customers to create an interactive experience ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. MemSQL has been designed and developed as a distributed relational database, bringing the effectiveness of the relational database model into the new world of the cloud, containers, and other software-defined infrastructure – as described in a new report from 451 Research. Today, most of our customers run our software using some combination of the cloud and containers, with many also running it on-premises. Today, we are purveyors of the leading platform-independent NewSQL database. Having recently joined the Cloud Native Computing Federation, we’d like to take this opportunity to answer the question: “What makes a ... Read More

Feed: MemSQL Blog. Author: Peter Guagenti. The most important new skills for business leaders are not what you might think. You’ve read the headlines. Data is the new oil; it’s the new currency; data capital can create competitive advantage. We also hear, over and over again, that machine learning (ML) and artificial intelligence (AI) are the future. Few will dispute that these things are true, but the trite language masks a deeper challenge. Data must be collected, analyzed, and acted upon in the right way and at the right time for a business to create value from it. ML and ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. In this webinar, Mike Boyarski and Eric Hanson of MemSQL describe the promise of machine learning and AI. They show how businesses need to upgrade their data infrastructure for predictive analytics, machine learning, and AI. They then dive deep into using MemSQL to power operational machine learning and AI. In this blog post, we will first describe how MemSQL helps you master the data challenges associated with machine learning (ML) and artificial intelligence (AI). We’ll then show how to implement ML/AI functions in MemSQL. At any point, feel free to view the (excellent) webinar ... Read More

Feed: MemSQL Blog. Author: Eric Hanson. In earlier blog posts we described what time series data is and key characteristics of a time series database. In this blog post, which originally appeared in The New Stack, Eric Hanson, principal product manager at MemSQL, shows you how to use MemSQL for time series applications. At MemSQL we’ve seen strong interest in using our database for time series data. This is especially the case when an organization needs to accommodate the following: (1) a high rate of event ingestion, (2) low-latency queries, and (3) a high rate of concurrent queries. In what ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. A version of this blog post first appeared in the developer-oriented website, The New Stack. It describes how MemSQL works with Apache Kafka to guarantee exactly-once semantics within a data stream. Apache Kafka usage is becoming more and more widespread. As the amount of data that companies deal with explodes, and as demands on data continue to grow, Kafka serves a valuable purpose. This includes its use as a standardized messaging bus due to several key attributes. One of the most important attributes of Kafka is its ability to support exactly-once semantics. With exactly-once ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. In this webinar, MemSQL Product Marketing Manager Mike Boyarski describes trends in data initiatives for banks and other financial services companies. Data is the lifeblood of modern financial services companies, and MemSQL, as the world’s fastest database, is rapidly growing its footprint in financial services. Financial services companies are leaders in digital transformation initiatives, working diligently to wring business value from the latest initiatives. According to Gartner’s 2019 CIO Agenda survey, Digital transformation is the top priority for banks, followed by growth in revenue; operational excellence; customer experience; cost optimization/reduction; and data and analytics ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Risk management is a critical task throughout the world of finance (and increasingly in other disciplines as well). It is a significant area of investment for IT teams across banks, investors, insurers, and other financial institutions. MemSQL has proven to be very well suited to support risk management and decisioning applications and analytics, as well as related areas such as fraud detection and wealth management. In this case study we’ll show how one major financial services provider improved the performance and ease of development of their risk management decisioning by replacing Oracle with MemSQL ... Read More