Category: Column Stores

Feed: MemSQL Blog. Author: Rick Negrin. It’s time for us to admit what we have all known is true for a long time; NoSQL is the wrong tool for many of the modern application use cases, and it’s time that we move on. NoSQL came into existence because the databases at the time couldn’t handle the scale required. The rise of this new generation of data services solved many of the problems of web scale and rapidly growing data sets when it was created more than a decade ago. NoSQL also offered a new, cost-effective method for cold storage/occasional batch ... Read More

Feed: MemSQL Blog. Author: Jorge Jaramillo. By Jorge Jaramillo, Managing Partner – handytec Data is constantly being collected and analyzed. In business, we typically analyze that data with charts, graphs, or lists to create actionable insights. However, there is one element missing with traditional data analysis, and that is the “where” element. This is when geoanalytics becomes relevant. Geoanalytics is the correlation between data and its physical location. This means that more insights on the data can be created, such as dynamic pricing and operational efficiency. How handytec Delivers Geoanalytics handytec is an Ecuadorian company specializing in providing customized big ... Read More

Feed: MemSQL Blog. Author: Kristi Lewandowski. Companies are living organisms. As they mature they tend to slow down a bit and align to familiar routines. This pattern has the benefit of keeping the primary corporate economic engine stable and avoiding unintentional disruption. However, that same ‘disruption avoidance’ can cause companies to become so sedentary that they miss the next innovation wave. Conceptually, we understand the desire and need for large companies to stay innovative, and they try many different approaches to avoid this trap, including developing innovation conferences, corporate venture investments, internal skunkworks projects, and adopting technologies outside of their ... Read More

Feed: MemSQL Blog. Author: Mike Boyarski. Spark+AI Conference is in San Francisco June 4-6. It’s the preeminent conference covering all things Spark. Since 2013 the conference has helped developers learn and explore the possibilities of delivering modern data-driven applications at scale. The overarching theme of this years show is the unification of data and AI. New applications that include AI require massive amounts of constantly changing data, and Apache Spark is at the center of this data processing opportunity. Sessions of particular interest include Spark Streaming case studies along with operationalizing Spark for production: A Deep Dive into Stateful Stream ... Read More

Feed: MemSQL Blog. Author: Eric Boutin. On March 13, we published a blog demonstrating the performance of MemSQL in the context of ad hoc analytical queries. Specifically, we showed that the query SELECT stock_symbol, count(*) as c FROM trade GROUP BY stock_symbol ORDER BY c desc LIMIT 10; SELECT stock_symbol, count(*) as cFROM tradeGROUP BY stock_symbolORDER BY c descLIMIT 10; can process 1,280,625,752,550 rows per seconds on a MemSQL cluster containing 448 Intel Skylake cores clocked at 2.5GHz. In this blog post, we drill down into how this was made possible by carefully designing code, exploiting distributed execution, and instruction-level ... Read More

Feed: MemSQL Blog. Author: Nikita Shamgunov. We are thrilled to share that we raised $30 million in our Series D. This round of fundraising was led by GV (formerly Google Ventures) and Glynn Capital, and brings our total fundraising to $110 million. Why are firms continuing to invest in MemSQL?Database technology sets the foundation for business leaders looking to derive value from data. Across the industries and companies we support, MemSQL is driving digital transformation for some of the world’s business giants including companies such as, Comcast, Pandora, Kellogg, Dell/EMC, and Uber. What makes MemSQL different than other databases on ... Read More

Feed: MemSQL Blog. Author: Eric Boutin. On March 13, we published a blog demonstrating the performance of MemSQL in the context of ad hoc analytical queries. Specifically, we showed that the query SELECT stock_symbol, count(*) as c FROM trade GROUP BY stock_symbol ORDER BY c desc LIMIT 10; SELECT stock_symbol, count(*) as cFROM tradeGROUP BY stock_symbolORDER BY c descLIMIT 10; can process 1,280,625,752,550 rows per seconds on a MemSQL cluster containing 448 Intel Skylake cores clocked at 2.5GHz. In this blog post, we drill down into how this was made possible by carefully designing code, exploiting distributed execution, and instruction-level ... Read More

Feed: MemSQL Blog. Author: Gary Orenstein. Introduction Machine Learning (ML) and Artificial Intelligence (AI) have stirred the technology sector into a flurry of activity over the past couple of years. However, it is important to remember that it all comes back to data. As Hilary Mason, a prominent data scientist, noted in Harvard Business Review*, …you can’t do AI without machine learning. You also can’t do machine learning without analytics, and you can’t do analytics without data infrastructure. Over the last year we assembled a number of blogs, videos, and presentations on using ML and AI with MemSQL. MemSQL with ... Read More

Feed: MemSQL Blog. Author: Gene Miguel. Amazon Web Services (AWS) is a juggernaut of a platform, and many of today’s database solutions can run on AWS, including MemSQL. Recently, we held a meetup at our office in San Francisco during AWS Summit 2018 to discuss how customers can benefit from using MemSQL within the AWS ecosystem. In the talk, “Architecting Data in the AWS Ecosystem,” Seth Luersen from MemSQL took a look at the overall data landscape related to the purpose-built databases from Amazon Web Services. He illustrated how the shape, size, and computing needs for data-driven workloads dictate modern ... Read More

Feed: MemSQL Blog. Author: Gary Orenstein. We attended the Gartner Data and Analytics Summit in Grapevine, Texas in early March. This series is part of its global events schedule and similar conferences happen around the world. One fun hallway display was a series of animated summaries with key themes, tracks, and sessions of the conference. They were created by Katherine Torrini at Creative Catalyst. The first display covered the primary show themes of scaling the value of data and analytics: – Establishing Trust in the data foundation – Promote a culture of Diversity – Building the Data Literacy of your ... Read More