How to synchronize databases, documents to vector databases

I need a mechanism to synchronize changes in databases, documents, and vector databases. That is, when records in databases and documents change, I need a mechanism to synchronize these changes to the vector database. The purpose of synchronization is to support some AI applications, such as applications that support RAG mode. The specific requirements are as follows: • When a record is added to the database, the information of this record needs to be put into the vector database (stored after encoding) • When a record is modified in the database, the record in the vector database needs to be modified at the same time. • When a record is deleted from the database, the record in the vector database needs to be deleted at the same time. • When a document is added (such as a pdf document), the corresponding record of this document needs to be added to the vector database (through extraction, slicing, vectorization and storage). • When a document…