Podcast

Why Purpose-built Vector Databases Matter for Your Use Case

Frank Liu, Zilliz, Jiang Chen, Zilliz, Yujian Tang, Zilliz59:01 · Mar 2024 · 283 views
Thumbnail for Why Purpose-built Vector Databases Matter for Your Use Case Watch on YouTube
TL;DR
  1. 1

    Longer context windows do not remove the need for vector databases because sending large contexts to a language model increases cost and compute, while retrieval still helps select relevant information.

  2. 2

    Purpose-built vector databases are designed for efficient vector and filtered search at scale, while general databases with vector support optimize for different workloads.

  3. 3

    Embedding models need to be tested against data from the actual application, and fine-tuning can help when a general model does not capture the distinctions the use case requires.

Summary

Demetrios Brinkmann hosts Frank Liu, Jiang Chen, and Yujian Tang in a discussion about when teams should use a purpose-built vector database instead of adding vector search to an existing database. Frank explains that long-context language models still have cost, latency, compute, and retrieval-quality limits. Jiang describes retrieval as a production system with expensive indexing work performed offline, so online queries can return results quickly. The panel also discusses vector databases as compute engines that can store metadata and source content alongside vectors. They compare purpose-built systems with general databases that add vector capabilities, then cover Milvus, Pinecone, hybrid and multi-vector search, sparse embeddings, reranking, and late-interaction models. On embeddings, the panel recommends evaluating models with a small, high-quality dataset from the target application rather than relying only on public leaderboards. The final section covers keeping retrieved content current through careful updates, upserts, triggers, and data-management practices.

Key ideas
05:25

Long context does not eliminate retrieval because query costs and compute still grow

Frank Liu says that putting an entire book into a language model context can become expensive. He gives a hypothetical cost of one dollar per query, which would make 100,000 questions cost $100,000. Longer contexts also require more computation, and a large collection such as the San Francisco Public Library still cannot fit into one context window. Frank says vector databases remain useful for storing and retrieving the relevant parts of a much larger body of information.

08:28

Needle-in-a-haystack tests are stress tests rather than production designs

Frank Liu describes long-context retrieval tests where a distinctive sentence is placed inside a familiar book. He says the test is easy for a language model because unusual phrases stand out and may not occur elsewhere in the surrounding text. He also says reasoning across a long context becomes worse as the token count grows. Jiang Chen adds that these experiments test model capability, while production systems must account for query latency, cost, and user experience.

12:05

Retrieval moves expensive content analysis offline

Jiang Chen explains that search systems do most of their heavy work before a user submits a query. Understanding content, running machine learning models, and building indexes can be expensive, so those tasks happen during offline indexing. Online serving then uses the prepared indexes to answer quickly. He says the same pattern gives retrieval-augmented generation its value, since analyzing the same content repeatedly at query time would cost far more than processing it once during indexing.

19:16

A vector database can hold source data and metadata alongside embeddings

Yujian Tang describes vector databases as compute engines that keep vectors in memory while much of the data lives in permanent storage such as S3 or MinIO. Applications can store text, image links, video references, and metadata with the vectors. Jiang Chen says keeping source content close to its vector allows the system to retrieve both together, so developers do not need another round trip to a separate data store. The panel also says connectors can bring data from systems better suited to other storage tasks.

20:32

Purpose-built systems optimize vector workloads differently from general databases

Yujian Tang says the difference between a purpose-built vector database and a general database with vector support comes from how each system was designed. Vector databases focus on efficient vector computation, filtered search, and other retrieval patterns at scale. Frank Liu argues that general databases such as MongoDB, DataStax, and Elasticsearch may support structured data well, while vector databases support vector workloads better. The panel does not say a team must use only one database, since connectors can link systems with different strengths.

40:29

Embedding quality depends on the application rather than a single public ranking

Frank Liu says there is no embedding model that fits every use case. He uses the phrases "let's eat" and "let's eat, Yujian" to show that punctuation and context can change what similar text should mean. Jiang Chen recommends building an evaluation set from the application's own data instead of choosing a model only because it has a well-known name or a high public leaderboard position. Frank suggests testing candidate models on tens or hundreds of relevant examples, with thousands providing a stronger basis for evaluation.

43:11

Small, relevant datasets can guide fine-tuning

Yujian Tang gives an image example involving Ferrari, Pony, and Mustang. A general model may return both horses and cars for Mustang, while a car-focused application needs to separate those meanings. He says fine-tuning can shift the model toward the desired results. Frank Liu cites experience suggesting that around 20 to 25 images can help prime an image model, while text evaluation may need roughly 100 to 120 sentences for a useful indication. The panel stresses that the examples must match what the system will see in production.

55:19

Freshness requires ordinary data-management discipline

The panel discusses an HR policy that changes from 20 vacation days to 10. Frank Liu says a vector database should be treated as a living source of semantic information and kept synchronized through real-time data flows. Jiang Chen recommends identifying the affected document or text chunk, then updating it through an upsert or a delete-and-reinsert operation. The speakers also mention triggers and versioning when teams need to preserve how a document changed over time. They say vector data does not remove the need for established data operations practices.

"You will still need vector databases to really retrieve, to store and retrieve all context that you really want."Frank Liu06:55
Who should watch
  • You are deciding whether to add vector search to an existing database or adopt a purpose-built vector database, and you need to compare the workload trade-offs.
  • Your RAG system uses long-context language models, but you still need to control query cost, latency, retrieval quality, and document freshness.
  • You are choosing or fine-tuning an embedding model and want a practical evaluation process based on your own application data.