/

The SingleStore Query Optimizer: A modern optimizer for real-time analytics in a distributed database

Real-time analytics on massive datasets has become a very common need in many enterprises. These applications require not only rapid data ingest, but also quick answers to analytical queries operating on the latest data.

Cloud-Native Transactions and Analytics in SingleStore

Cloud-Native Transactions and Analytics in SingleStore

The last decade as seen an incredible rise in specialized database systems. Since its inception, SingleStoreDB has emerged as a revolutionary database designed with the versatility to run both operational and analytical workloads for some of the world's largest financial, telecom, high-tech and energy companies.

Query Optimization Time: The New Bottleneck in Real- time Analytics

Query Optimization Time: The New Bottleneck in Real- time Analytics

In the recent past, in-memory distributed database management systems have become increasingly popular to manage and query huge amounts of data. For an in-memory distributed database like MemSQL, it is imperative that the analytical queries run fast.

BIPie: Fast Selection and Aggregation on Encoded Data Using Operator Specialization

BIPie: Fast Selection and Aggregation on Encoded Data Using Operator Specialization

Advances in modern hardware, such as increases in the size of main memory available on computers, have made it possible to analyze data at a much higher rate than before. In this paper, we demonstrate that there is tremendous room for improvement in the processing of analytical queries on modern commodity hardware.