OpenSearch vs. TiDB
Compare OpenSearch vs. TiDB by the following set of capabilities. We want you to choose the best database for you, even if it’s not us.
OpenSearch vs. TiDB on Scalability
Yes.
Yes.
Both
Both
OpenSearch
OpenSearch supports horizontal scaling, cluster management optimizations, and efficient shard allocation, making it suitable for handling large datasets and high query loads effectively.
TiDB
TiDB is designed with scalability as one of its core features. It offers both horizontal and vertical scaling capabilities to handle growing workloads and data volumes.
OpenSearch vs. TiDB on Functionality
yes, vector search & keyword search & scalar filtered search
Yes, vector search & SQL search
ANN
HNSW
No. HNSW only
OpenSearch
OpenSearch supports:
- Vectors with up to 16,000 dimensions.
- Vector generation through external libraries or directly within OpenSearch.
- Both binary and dense vectors.
- Cosine Similarity, Inner Product, and L2 Distance (Euclidean).
- Integration with multiple engines, including NMSLIB, Faiss, and Lucene, to facilitate vector indexing and searching.
TiDB
TiDB offers vector search through its serverless cluster and supports vectors with a maximum dimension of 16,000. The Vector data type in TiDB is designed to store single-precision floating-point numbers (Float32). It only supports cosine distance and L2 distance for similarity measurement.
OpenSearch vs. TiDB on Purpose-built
No. Vector search is an add-on to OpenSearch.
No, vector search is an add-on to TiDB Cloud serverless.
Java, Python, JavaScript, Go, and .Net
No. TiDB does not provide specific SDKs. Instead, it is designed to be compatible with MySQL, which means TiDB can be used with any language with MySQL client or driver support.
OpenSearch vs. TiDB: what’s right for me?
OpenSearch
OpenSearch is an open-source software suite for search, analytics, security monitoring, and observability applications. It is not purpose-built for vector storage and search workloads but introduces a vector search plugin to provide this capability. Amazon OpenSearch Service is an AWS-managed service for OpenSearch.
Apache 2.0
TiDB
TiDB is an open-source distributed SQL database for OLAP and OLTP workloads. It now offers a vector search capability (in public beta) as an add-on to its SaaS solution, TiDB Cloud Serverless.
Apache 2.0