Beyond Vector Search: What Your Database Can Do with Embeddings

The similarity join: an SQL operator for predictions, analytics, and joining tables that have no foreign keys The typical way to join tables in relational databases is through foreign keys. This relationship is encoded into the database at design time, and then you join on this column. Let’s call this an equi-join. This requires one to place strict designs and to know the relationships a priori. We can easily imagine far relationships we don’t know beforehand, though.