The operation everything reduces to
A vector database exists to answer one question quickly: given a query vector, which of my stored vectors are closest to it?
That operation, k-nearest-neighbour search, is the retrieval step underneath semantic search, retrieval-augmented generation, recommendation, deduplication and image similarity. Everything else a vector database does, filtering, metadata, persistence, is scaffolding around it.
The reason it needs a specialised system is that the naive implementation is expensive in a specific way. To find the closest vector exactly, you compute the distance from the query to every stored vector and keep the smallest. For N vectors of dimension d, that is N times d multiply-accumulate operations per query.
Put numbers on it. Ten million vectors at 768 dimensions is roughly 7.7 billion operations per query. That is achievable on modern hardware in a fraction of a second, and it is entirely unachievable at a thousand queries per second without a fleet of machines.
So the field is built around a bargain: give up the guarantee of finding the exact nearest neighbours, in exchange for finding almost all of them almost always, orders of magnitude faster. Everything in this cursus is about the shape of that bargain and how to control it.

