---
answer: direct
beat: system-design
source: 1 article · updated: November 15, 2026
---

Why is it an anti-pattern to use a dedicated vector database as the primary system of record?

Vector databases are optimized for approximate nearest neighbor (ANN) similarity search over high-dimensional floating-point arrays. They lack ACID transactional guarantees, relational integrity constraints, and durable write-ahead logging required for primary systems of record.

Answered in

Database Types Guide: Storage Models, Access Patterns, and Polyglot Persistence

A practical guide to modern database types: relational, columnar, key-value, document, time-series, graph, and vector engines matching storage to workloads.

Crashtech Editorial November 15, 2026 System Design & Architecture

Read the full analysis

Other questions this article answers

More system design & architecture questions

Every answer on Crashtech is written by the editor of the article it comes from — never auto-summarised. Browse all answers or the System Design & Architecture beat.