Category: Column Stores

Feed: MemSQL Blog. Author: Floyd Smith. Analyst firm 451 Research has come up with new research that sees a bright future for HOAP – hybrid operational and analytical processing. The report is titled 451 Perspective: A HOAP-ful future for hybrid operational and analytical processing. This new type of processing has received several different names, from different analyst firms and consultancies: By any of these names, this new style of data processing – which unifies transactions and operational analytics, including many data warehousing-type functions – is widely believed to have a bright future. And MemSQL is right in the middle of ... Read More

Feed: MemSQL Blog. Author: Nikita Shamgunov. In celebration of Pi Day, I asked MemSQL’s Engineering team to come up with clever ways to compute pi in SQL. Because that’s the kind of thing we engineers enjoy! And, given pi’s privileged status in mathematical history – and my own history of earning a bachelor’s degree in Mathematics – I just couldn’t resist. Truth be told, in the early days of MemSQL, my fellow math geeks and I had some fun with Pi Day – yes, including eating actual pies – and we even had a colleague with the nickname of Pieguy ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. A new Trend Report from DZone highlights the move to cloud databases. The report paints a bright picture for cloud database adoption, with roughly half of developers asserting that all of their organization’s data will be stored in the cloud in three years or fewer. You can get a copy of the report by request from MemSQL. DZone has issues a new trend report on cloud databases. In the report, leaders in the database space focus on specific use cases, calling out the factors that help you decide what you need in any database, ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Solutions Engineer Mihir Bhojani presents a 20-minute technical overview of MemSQL Helios. In this webinar recap, we present the key points of the interview, and give you a chance to review them at your leisure. You can also view the MemSQL Helios Technical Overview.  In this webinar, we’ll cover what exactly MemSQL Helios is and how it compares with self-managed MemSQL, which you download yourself, provision, and run in the cloud or on-premises. With MemSQL Helios, MemSQL provisions the hardware in the cloud and runs MemSQL itself; you just set up tables and manage ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. This webinar concludes our three-part series on cloud data migration. In this session, Domenic Ravita actually breaks down the steps of actually doing the migration, including all the key things you have to do to prepare and guard against problems. Domenic then demonstrates part of the actual data migration process, using MemSQL tools to move data into MemSQL Helios.  About This Webinar Series This is the third part of a three-part series. First, we had a session on migration strategies; broad-brush business considerations to think about, beyond just the technical lift and shift strategy ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. This webinar describes what’s needed to successfully migrate your data to the cloud. What does a good cloud data migration look like? What are the strategic decisions you have to make as to priorities, and what are the challenges you’ll face in carrying out your plans? We will describe a tried and tested approach you can use to get your first wave of applications successfully migrated to the cloud.  About This Webinar Series This is the second part of a three-part series. Last week we covered migration strategies; broad-brush business considerations to think about, ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. This webinar describes the benefits and risks of moving operational databases to the cloud. It’s the first webinar in a three part series focused on migrating operational databases to the cloud. Migrating to cloud based operational data infrastructure unlocks a number of key benefits, but it’s also not without risk or complexity. The first session uncovers the motivations and benefits of moving operational data to the cloud and describe the unique challenges of migrating operational databases to the cloud. (Visit here to view all three webinars and download slides.)  About This Webinar Series Today ... Read More

Feed: MemSQL Blog. Author: Peter Guagenti. “Breakup Day” is February 21st. In the spirit of moving on from unhealthy relationships, we decided to write our very own “Dear John” letter to the vendor we hear our customers complain the most about… or in this case, a “Dear Larry” letter. We hope this gives anyone who’s feeling taken advantage of by their behemoth vendor the courage to sever ties. Cheers. Dear Larry, Let’s be honest – this relationship is not working. I’m ditching you for someone who treats me like I matter…  and who doesn’t take all of my money!  You’ve ... Read More

Feed: MemSQL Blog. Author: Rob Richardson. The MEAN stack – MongoDB, Express.js, Angular.js, and Node.js – has served as a pattern for a wide variety of web development. But times have changed, and the components of the MEAN stack have failed to keep up with the times. Let’s take a look at how the MEAN stack superseded the previous stack, the LAMP stack, and at the options developers have now for delivering efficient Web applications. Introduction We reach for software stacks to simplify the endless sea of choices. The MEAN stack is one such simplification that worked very well in ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. A recent Dresner report, the Analytical Data Infrastructure Market Study, includes MemSQL for the first time. The report shows MemSQL as the leader among full-service database providers – ahead of Google, Amazon, Microsoft, IBM, SAP, and Oracle. (A few specialty analytics products also rank highly.) The Dresner report is part of their Wisdom of Crowds series, and rates MemSQL as an Overall Leader in both major categories of the report: Customer Experience and Vendor Credibility, with a perfect Recommend score.  About the Dresner Study Dresner Advisory Services is well-known for their insightful market studies ... Read More