SingleStore vs kdb+ comparison

Read 7 SingleStore reviews

252 Views
196 Comparison Views

100% willing to recommend

kdb+

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between kdb+ and SingleStore based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools.

To learn more, read our detailed Relational Databases Tools Report (Updated: December 2024).

Relational Databases Tools

December 2024

Download the complete report

Helped 824,053 peers since 2012

Categories and Ranking

kdb+

Average Rating

9.0

Number of Reviews

Ranking in other categories

Relational Databases Tools (23rd)

SingleStore

Average Rating

8.8

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Database as a Service (DBaaS) (7th), Vector Databases (13th)

Mindshare comparison

While both are Databases solutions, they serve different purposes. kdb+ is designed for Relational Databases Tools and holds a mindshare of 0.3%, up 0.2% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 1.3% mindshare, up 0.8% since last year.

Relational Databases Tools

Database as a Service (DBaaS)

Featured Reviews

Nitin Garg

Vice President - Financial Services at Evalueserve

An easy-to-deploy solution that can be used for data ingestion and usage

I work for a fintech company where we create several strategies generally built on finance data, which are like one-time series data. We deal with huge bulk data on a daily basis, and we use kdb+ for data ingestion and usage The most valuable feature of kdb+ is the speed at which it returns the…

Read full review

Hitesh Kunchakuri

Associate Consultant at University of California at Davis

A reasonably priced product that offers good speed and seamless support

Currently, I can't think of any areas that require improvement because SingleStore was recently launched in the market. The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings. The current SingleStore model provides output based on the RANK function. If a user searches for a liquor bottle, then with all the data the product has, it will search for the liquor bottle in the data, and based on a match, the product has an algorithm to rank the product because of which the paragraph that has the best match will be ranked as a 100, the next one as 99, following which the next product will be ranked as 98 and so on. The output from the solution will fetch you all the 100 products that are available in a store, but sometimes a user might require a product with a 97 or 98 percent match from the DB, meaning the product doesn't always work to provide a 100 percent match, an area I feel that can be optimized in the product. Currently, SingleStore's features are excellent as it can read documents, images, and everything. The product works seamlessly for me.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The solution returns data quickly, and data retrieval is fast in kdb+."

"The product can automatically reinstall and reconfigure in case of a shutdown."

"The product's initial setup phase was pretty straightforward, with no complex processes."

"The paramount advantage is the exceptional speed."

"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."

"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."

"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."

"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."

Cons

"The solution should have a more user-friendly user interface."

"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."

"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."

"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."

"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."

"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."

"Having the ability to migrate servers using a single command would be extremely beneficial."

"We don't get good discounts in Pakistan."

Pricing and Cost Advice

Information not available

"SingleStore is a bit expensive."

"The product's licensing is not expensive. It is comparable."

"The price of the product is okay compared to the other available solutions in the market. SingleStore is a reasonably priced product, considering the functions it offers."

"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."

"They have two main options: cloud installation and bare-metal installation, each with different pricing models."

"I would advise users to try the free 128GB version."

See which vendors are best for you

Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.

See recommendations

824,053 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

39%

Computer Software Company

11%

Real Estate/Law Firm

Manufacturing Company

Financial Services Firm

30%

Computer Software Company

14%

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about kdb+?

The solution returns data quickly, and data retrieval is fast in kdb+.

What needs improvement with kdb+?

The solution should have a more user-friendly user interface.

What is your primary use case for kdb+?

What do you like most about SingleStore DB?

The paramount advantage is the exceptional speed.

What is your experience regarding pricing and costs for SingleStore DB?

Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure. While building an on-premise cluster incurs an initial cost for servers with ample RAM...

What needs improvement with SingleStore DB?

There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation...

Oracle Database In-Memory vs kdb+

Comparisons

SQL Server vs kdb+

Compared 38% of the time

Compared 36% of the time

More kdb+ Competitors

ClickHouse vs SingleStore

Compared 11% of the time

Teradata vs SingleStore

Compared 8% of the time

Chroma vs SingleStore

Compared 7% of the time

SQL Server vs SingleStore

Compared 7% of the time

CockroachDB vs SingleStore

Compared 7% of the time

More SingleStore Competitors

Product Reports

Relational Databases Tools

December 2024

Download kdb+ product report

Download SingleStore product report

November 2024

Learn More

Video not available

Kx Systems

Video not available

Overview

Kx is the world leader in high-performance, in-memory computing, streaming analytics and operational intelligence. The company’s focus is on delivering the best possible performance and flexibility for high-volume, data-intensive analytics and applications. Kx software includes the time-series database kdb+ with a built-in programming language called q, and a robust suite of visualization tools built on top of the database platform providing business intelligence for all users.

SingleStore enables organizations to scale from one to one million customers, handling SQL, JSON, full text and vector workloads — all in one unified platform.

Sample Customers

UniCredit, AIRBUS

6Sense, ADNOC, Adobe, Akamai, CARFAX, Cigna, Cisco, Comcast, DBS Bank, Dell, Dentsu, EY, FirstEnergy, GE, Goldman Sachs, Heap, Hulu, IMAX, Kakao, Kroger, LG, LiveRamp, Lumana, NBC, OpenDialog, Outreach, Palo Alto Networks, PicPay, RBC, Samsung, Siemens, SiriusXM, SK Telecom, SKAI, Sony, State Street Financial, STC, SunRun, TATA, Thorn, and ZoomInfo.