Category: Column Stores

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: Raj Verma. Today, Martin Luther King Jr. (MLK) is celebrated, honored and remembered as one of America’s greatest leaders for his transformative ability to move the needle forward in regard to the civil rights movement in the United States and throughout the world. King sought equality and human rights for African Americans, the economically disadvantaged, and all victims of injustice through peaceful protest. Commitment. Determination. Clarity. Vision. Inspiration. Transformational Mindset. These words all describe the attributes of a great leader.  I’ve had a lifelong passion for studying the qualities of great ... Read More

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: Domenic Ravita. On this National Cut your Energy Costs Day, it’s a good time to think about our carbon footprints at home and at work as data professionals. Since the first home was electrified in Manhattan in the 1880s, our home electricity usage has grown dramatically. According to Energy.gov, residential homes now account for 22% of all electricity consumption in the U.S. Roughly 63% of this electricity is still generated by nonrenewable fossil fuel sources in the U.S. according to the Energy Information Administration., but this varies a lot based on ... Read More

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: David Yakobovitch. With the world still recovering and reorganizing from COVID-19 and How the Global Pandemic has reshaped supply chains, infrastructure, and the way that business is processed, 2021 is anticipated to be a year to make big gains for companies that embrace and implement strategic Digital First Strategies. Whether Mobile First, Tablet First, or Laptop First strategies are at the forefront of your organization, data will continue to reign supreme as 5G continues its global roll-out. What strategies can you take to ensure that your enterprise is ready to capture ... Read More

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: Roxanna Pourzand Andrii Khoma. SingleStore introduced an APPROX_PERCENTILE function to estimate percentiles for a distribution of values. This function is faster and near-exact as compared to the analogous functions that calculate exact percentiles. Read more to learn about this feature and see the performance and accuracy comparisons between approximations and precise values on a sample dataset. Please check this demo video to learn more about the approx_percentile function in SingleStore: If you have a sizable numeric dataset that you are analyzing, you likely require the ability to do some standard statistical ... Read More

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: Eric Hanson. SingleStore Universal Storage technology is a dramatic evolution of our columnstore data format that allows it to support both operational and analytical workloads with low total cost of ownership (TCO). People love our rowstores for OLTP-style access patterns because of our great performance based on memory-optimized data structures and compilation of queries to machine code. But for users with large data sets, the cost of providing servers with enough RAM to hold all the data started to be significant. Universal Storage solves this cost problem, while also providing even ... Read More

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: Rick Negrin. SingleStore is proud to announce the general availability of SingleStore DB 7.3 for immediate download. SingleStore DB 7.3 is also available today on SingleStore Managed Service, the company’s elastic cloud database, available on public cloud providers around the world. At SingleStore, we are building the next great database platform. SingleStore DB is a distributed operational database that delivers speed and scale. As the leading NewSQL platform for real-time analytics and augmented transaction processing [Ron19], SingleStore DB can handle all your workloads in the cloud or in your data center ... Read More

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: Sarung Tripathi. Abstract Many organizations today are looking for ways to run Machine Learning (ML) models in operational systems at scale. Data Scientists can now take models that they build in SageMaker and deploy them as user-defined functions within our general purpose, relational database. Read more about how you can accelerate the execution of your models against real time data. You can also find in-depth notebooks detailing how to implement this on GitHub. Setting the Stage AWS SageMaker has quickly become one of the most widely used data science platforms in ... Read More

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: David Gomes. I once heard that a “book worth reading is worth reading twice”, and I’ve found this to be true about other things as well. There’s a documentation page that’s been with me for the majority of my professional career; a page that I keep coming back to and that I’ve read from start to finish, without skipping a word, more than a few times in the last few years. This document is GitLab’s Embracing Asynchronous Communication guide, a section of GitLab’s public handbook that goes over their approach to ... Read More

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: Mike Pickett. When I joined an integration company in late ‘99, I didn’t think data and integration would be my focus and passion. But here I am coming up to 2021, more than 20 years later, in a market that has only gotten more exciting and more relevant to the business. In the early 2000s, it was all about the “connected enterprise”, getting your apps working together. Then it was the “intelligent enterprise” and we saw the rise of the enterprise data warehouse and analytics. In the early 2010s, Big Data ... Read More

Feed: SingleStore Blog – MemSQL is Now SingleStore. Author: Domenic Ravita. Business is about serving the needs of customers. But customer expectations are changing quickly, and most organizations are not truly aware of how fast that’s happening. Most businesses are moving in slow motion relative to their customers. That means they miss out on opportunities to make decisions about and act on the moments that matter. In the past, lag time was accepted. Nielsen called people on the phone to understand their TV viewing habits. Broadcast TV networks set advertising rates and advertisers gauged viewership based on Nielsen ratings. It ... Read More