Relational database

A relational database keeps data in tables of rows and columns, with defined links between them: a customer row connects to its order rows, an order to its line items. Because the structure is explicit, you can ask precise questions and get exact answers back.

It is the right home for structured, numeric, transactional data, and the counterpart to a vector store. Records and totals live in a relational database and are queried; prose lives in retrieval. Forcing one into the other is how you get wrong answers.