Analytics6 min Read

Everyone remembers their first experience in a Tesla. Mine was in Las Vegas with a good friend and CIO. I was in town for a tech conference…
Read Post
Analytics4 min Read

Infiswift uses AI to help meet real-world challenges, largely through Internet of Things (IoT) deployments. They optimize the operation of physical devices using connectivity and data. The company’s innovative platform makes it easy to connect and manage any number of endpoints at scale, with security, and to build solutions that open new services or improve existing ones. Infiswift empowers its customers to be data-driven in industries such as renewable energy, agriculture, and manufacturing…
Read Post
Analytics2 min Read

A recent Dresner report, the Analytical Data Infrastructure Market Study , includes SingleStore for the first time. The report shows SingleStore 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 SingleStore as an Overall Leader in both major categories of the report: Customer Experience and Vendor Credibility…
Read Post
Analytics13 min Read

There is a trend in industry which says that modern applications need to be built on top of one or more special-purpose databases. That every application benefits from using the best-of-breed technology for each requirement. And that the plethora of special-purpose options available from certain cloud providers is reasonable to manage. That’s all BUNK. The reality is that navigating the choices, figuring out how to use them effectively, and dealing with the ETL and inevitable data sprawl, is so…
Read Post
Analytics6 min Read

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 SingleStore, shows you how to use SingleStore for time series applications. At SingleStore 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…
Read Post
Analytics3 min Read

SME Solutions Group helps institutions manage risks and improve operations, and they’ve chosen SingleStore as a database partner . Their premier services include data analytics and business intelligence (BI) tools integration, areas where SingleStore adds tremendous value. In this webinar , SME Solutions Group describes how they use SingleStore to solve a wide range of problems, including big data and fast data needs for utilities. How SingleStore Fits SME Mike Czabator, a systems engineer…
Read Post
Analytics5 min Read

SSIMWAVE customers – from film producers to network engineers to media business executives – work to some of the highest standards in the world. 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: SingleStore. SSIMWAVE has unique technology…
Read Post
Analytics6 min Read

John Sherwood, a senior engineer at SingleStore on the query optimizer team, presented at SingleStore’s Engineering Open House in our Seattle offices last month. He gave a technical introduction to the SingleStore database, including its support for in-memory rowstore tables and disk-backed columnstore tables, its SQL support and MySQL wire protocol compatibility, and how aggregator and leaf nodes interact to store data and answer queries simultaneously, scalably, and with low latencies. He also…
Read Post
Analytics4 min Read

This case study was presented as part of a webinar session by Rick Negrin, VP of Product Management at SingleStore. In the webinar, which you can view here , and access the slides here , Rick demonstrates how a major financial services company replaced Oracle Exadata with SingleStore to power portfolio analytics, with greatly increased responsiveness for users and the ability to easily incorporate machine learning models into their applications. In this case study, we’ll emphasize the bank’s…
Read Post
Analytics17 min Read

In this webinar Rick Negrin, Product Management VP at SingleStore, describes the importance of portfolio analytics, enhanced by machine learning models, to financial services institutions – helping them to meet customer needs and edge out competitors. He shows how SingleStore speeds up portfolio analytics at scale, with unmatched support for large numbers of simultaneous users – whether connecting via ad hoc SQL queries, business intelligence tools, apps, or machine learning models. You can…
Read Post
Analytics7 min Read

In this webinar, which you can view here , SingleStore’s Mike Boyarski describes how real-time fraud detection represents a major digital initiative for banks. He shows how SingleStore 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…
Read Post
Analytics6 min Read

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 SingleStore was…
Read Post
Analytics4 min Read

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 SingleStore 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…
Read Post
Analytics2 min Read

Since SingleStore became free to use last November – for up to four nodes, and with community support – new, creative uses of SingleStore 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 SingleStore for SingleStore’s ability to handle complex queries with speed, scalability, and native SQL support. SingleStore is…
Read Post
Analytics4 min Read

SingleStore product marketing leader Mike Boyarski led the webinar, describing how SingleStore is well-positioned to power operational analytics . Operational analytics is the ongoing use of live and historical data to drive decision-making by both people and programs, including predictive analytics, machine learning, and AI. To do operational analytics you need to quickly ingest, analyze, and act on both incoming and existing data – all of which is in the wheelhouse of SingleStore. To view the…
Read Post
Analytics3 min Read

A new wave of digital transformation is in progress, and this new wave is powered by the exponential growth in the volume and complexity of data. To make data valuable it must be collected, stored, analyzed, and operationalized so as to drive value. Forrester has conducted a Total Economic Impact (TEI) analysis showing the savings and opportunities made possible for organizations moving to SingleStore. In order to put savings and benefits into context, Forrester conducted case studies with…
Read Post
Analytics8 min Read

A columnstore database takes all the values in a given column – the zip code column in a customer database, for instance – and stores all the zip code values in a single row, with the column number as the first entry. So the start of a columnstore database’s ZIP code record might look like this: 5, 94063, 20474, 38654… The “5” at the beginning means that the ZIP code data is stored in the fifth column in the rowstore database of customer names and addresses that the original data comes from…
Read Post
Analytics4 min Read

SingleStore has reached a benchmarking breakthrough: the ability to run three very different database benchmarks, fast, on a single, scalable database. The leading transactions benchmark, TPC-C, and analytics benchmarks, TPC-H and TPC-DS, don’t usually run on the same scale-out database at all. But SingleStore runs transactional and analytical workloads simultaneously, on the same data, and with excellent performance. As we describe in this webinar write-up, our benchmarking breakthrough…
Read Post
Analytics5 min Read

In this blog post, I’ll focus on new query processing capabilities in SingleStore DB 6.8. The marquee query feature is just-in-time (JIT) compilation, which speeds up query runtimes on the first run of a query – now turned on by default. We have also improved performance of certain right and left outer joins and related operations, and Rollup and Cube. In addition, we add convenience features, including sub-select without an alias, and extended Oracle compatibility for date and time handling…
Read Post
Analytics2 min Read

A SingleStore customer previously ran their business on two databases: the Amazon Web Services Relational Database Service ( AWS RDS ) for transactions and Druid.io for analytics, with a total bill which reached over $93,000 a month. They moved both functions to SingleStore, and their savings have been dramatic – about two-thirds of the total cost. The customer’s new monthly cost is about $31,000, for a savings of $62,000 a month, or 66%. In addition, the customer gains increased performance…
Read Post
Analytics10 min Read

The proliferation of streaming analytics and instant decisions to power dynamic applications, as well as the rise of predictive analytics, machine learning, and operationalized artificial intelligence, have introduced a requirement for a new type of database workload: operational analytics. The two worlds of transactions and analytics, set apart from each other, are a relic of a time before data became an organization’s most valuable asset. Operational analytics is a new set of database…
Read Post
Analytics11 min Read

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…
Read Post
Analytics8 min Read

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. SingleStore 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…
Read Post
Analytics11 min Read

In this case study, we describe how SingleStore powers wealth management dashboards – one of the most demanding financial services applications. SingleStore’s scalability and support for fast, SQL-based analytics, with high concurrency, mean that it’s well-suited to serve as the database behind these highly interactive tools. Dashboards have become a hugely popular technique for monitoring and interacting with a range of disparate data. Like the dashboard in a car or an airplane, an effective…
Read Post
Analytics3 min Read

In this webinar, SingleStore Product Marketing Manager Mike Boyarski describes the growth in popularity of time series data and talks about the best options for a time series database, including a live Q&A. You can view the webinar and download the slides here . Here at SingleStore, we’ve had a lot of interest in our blog posts on time series data and choosing a time series database , as well as our O’Reilly time series ebook download . Additionally, we have a webinar on architecture for…
Read Post
Analytics7 min Read

This case study was first published as a video with a brief description. Noah Zucker, Senior Vice President for Technology at Novus Partners , talks about how they use SingleStore for portfolio intelligence, applied to their $2 trillion – yes, two trillion dollars – in assets under management. The case study has proven popular, and the content is still highly relevant today, so we’re releasing a transcript of the content as a blog post. I’m here today to talk about Novus Partners and how we…
Read Post
Analytics6 min Read

SingleStore is a fast, scalable SQL database. Looker is a fast, scalable analytics platform. You can use SingleStore and Looker to create a fast, scalable – yes, those words again – analytics solution that works well across a wide range of data ingest, transaction processing, and analytics needs. Both SingleStore and Looker are flexible and powerful tools. With the ability to provide full ANSI SQL support, SingleStore has the ability to works with a wide range of analytics tools. For Looker, its…
Read Post
Analytics8 min Read

Storing and analysing larger and larger amounts of data is no longer what drives the decision-making process at successful companies. In today’s world, the key is how fast decision makers are provided with the right information, enabling them to make the right decision before it’s too late. Streaming analytics help you identify perishable insights, which are the subject of their very own Forrester Report . Perishable insights are results “which must be acted on within a given timeframe or else…
Read Post
Analytics5 min Read

In this webinar, SingleStore Product Manager Jacky Liang took a live audience through the process of building an analytics app in just a few minutes. You can view the webinar and download the slides here . In just a few minutes in the middle of the webinar, Jacky created a free SingleStore account; installed SingleStore on AWS; loaded in some data; and created a dashboard using Looker, a popular analytics tool. Jacky also explained some SingleStore basics and gave a quick overview of…
Read Post
Analytics3 min Read

With a real-time dashboard, you can stop problems before they start and seize opportunities that your competition is not aware of yet. SingleStore is a tool uniquely capable of powering real-time dashboards. In this blog post, we give some high points – but to get all the details, you should view our recorded webinar and download the PowerPoint slides here . A doctor can get a good idea of your health just by shining a light in your eyes and seeing if they’re clear or cloudy. Similarly, a…
Read Post