SingleStoreDB has supported vector functions since 2017. In this article, we’ll see examples of using Dot Product, Euclidean Distance, and Cosine Similarity in SingleStoreDB to assess vector relationships. New vector capabilities will be available in the next major release of SingleStoreDB – stay tuned.
The Dot Product
The Dot Product is a mathematical procedure combining two numbers lists into a single value. This is achieved by multiplying corresponding numbers from each list and then adding up the products. This operation is useful for tasks like measuring the commonality between two sets of values or assessing the influence of one set on another.