Category: Column Stores

Feed: MemSQL Blog. Author: Oryan Moshe. Thanks to Oryan Moshe for this awesome blog post, which originally appeared on DEV Community. In the blog post, Oryan describes how to achieve the high performance of MemSQL’s columnstore for queries while keeping transaction data in PostgreSQL for updates – Ed. Making the impossible hard I… don’t think this is how it should look like.So it’s this time of the year again, we need to upgrade our MemSQL cluster and expand our contract to fit the new cluster topology. We really outdid ourselves this time. Expanding to a 1TB cluster is impressive, especially ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. In this webinar, which you can view here, MemSQL’s Mike Boyarski describes how real-time fraud detection represents a major digital initiative for banks. He shows how MemSQL gives fraud detection services, along with other real-time analytics, an edge with faster ingest, real-time scoring, and rapid response to a broader set of events. He also describes a major US bank’s implementation of this approach, which is described separately in our case study about fraud detection on the swipe. New Data Initiatives for Banks There’s a great deal of digital transformation occurring around data initiative for ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. If you’ve ever had a web application freeze while it was calculating something, chances are that performing that computation in a JavaScript Web Worker would help. In this blog post, MemSQL’s David Gomes shows how to create a fully client-side application, using the JavaScript libraries React for the view layer and Redux for the application state layer. Introduction In this article, we’re going to explore how we leverage Web Workers, together with React & Redux, to build a fully client-side web application here at MemSQL. My goal with this article is to highlight a ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Wealth management is an intensely competitive offering for banks and other financial services institutions. It requires high concurrency – the ability to serve many users, fast – low latency, and the ability to access vast amounts of current and historical data in real time. Institutions have used in-memory databases and streaming data to try to meet the demand. In this webinar, MemSQL’s Sourabh Mehta shows how MemSQL improves the wealth management experience for users and gives institutions the ability to stand out in this competitive area. You can view the wealth management webinar here ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Real-time analytics is necessary to enable real-time decision making and to deliver enhanced customer experiences (download real-time whitepaper). Building a real-time application starts with connecting the pieces of your data pipeline. To make fast and informed decisions, organizations need to rapidly ingest application data, transform it into a digestible format, store it, and make it easily accessible. All at sub-second speed. In this video, we show how an earlier version of MemSQL was able to serve as the core of a real-time analytics stack. How MemSQL Supports Analytics Let’s briefly review MemSQL’s analytical approach ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Predictive analytics, machine learning, and AI are being used to power interactive queries and outstanding customer experiences in real time, changing how companies do business. MemSQL is widely used to help power these advanced applications, which require fast access to recent data, fast processing to combine new and existing information, and fast query response. In this webinar, Eric Hanson, Principal Product Manager at MemSQL, shows how MemSQL customers are using this fast, scalable SQL database in cutting-edge applications. You can read this summary – then, to get the whole story, read the transcript, view ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. What is real-time analytics? Uber provides a useful answer. Uber is driven by analytics. The fastest-growing company ever, by some accounts, Uber uses up-to-date information to entice customers, direct drivers, and run their business on a database that provides answers with sub-second response times. In this presentation, James Burkhart of Uber explains how MemSQL has helped solve critical latency issues for the company at a critical point in its growth. We encourage you to review the key points listed here, then view the presentation from Strata + Hadoop World 2017 and review the slides ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. MemSQL is featured on business solutions review site G2 Crowd. Customers cite advantages like MySQL-friendliness, data compression of 60-80%, strong training, and excellent support – and that’s just in a single review. What G2 Crowd Does for Users G2 Crowd features frank reviews of business solutions – software and services – across a wide range of categories. For software, categories include: Sales. CRM software, sales acceleration, and a whole range of other sales solutions. Marketing. Tools for A/B testing, content marketing, demand generation, lead management, social media marketing, and more. Analytics. Business intelligence, predictive ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Since MemSQL became free to use last November – for up to four nodes, and with community support – new, creative uses of MemSQL have abounded. One of the most impressive new implementations is from Katoni, an ecommerce hub that offers SEO tools via software as a service (SaaS) to mostly Scandinavian clients. Katoni has replaced Elasticsearch with MemSQL for MemSQL’s ability to handle complex queries with speed, scalability, and native SQL support. MemSQL is currently the primary database powering Katoni’s SaaS suite of SEO tools. MemSQL runs alongside PostgreSQL, which serves as a ... Read More

Feed: MemSQL Blog. Author: Jacky Liang. MemSQL Forums are available anytime you have a question about MemSQL, want to know more about MemSQL, or are willing and able to help others. And now the MemSQL Forums, coming up on their one-year anniversary, have their first Community Star: Ziv Meidav, a big data architect. The community of MemSQL users, developers, and employees gather at the MemSQL Forums to ask questions, offer support, and discuss strategies for leveraging MemSQL. Got a nasty error message? Post it on a Forum. Want to suggest a feature? Same thing. What the MemSQL Forums Do The ... Read More