Query response based on a journal database and a backup database

A system comprising:

• a processor;
• and
• a non-transitory storage medium storing instructions executable on the processor to:
• replicate a write event to a journal database, the write event involving a change of a source database comprising data points arranged in a multidimensional space, wherein a location of a data point in the multidimensional space is based on values of attributes contained in the data point, wherein the replicating of the write event adds a journal data point to the journal database, the journal data point comprising write data of the write event and metadata indicating a write operation associated with the write data, and wherein one or more journal data points from the journal database are to be replayed to a backup database that stores copies of the data points of the source database;
• based on receipt of a recovery query associated with recovering data of the source database, obtain, according to a filter in the recovery query, a first result from the journal database and a second result from the backup database;
• and
• merge the first result and the second result to produce a recovered database in response to the recovery query, wherein the merging of the first result and the second result comprises applying a write operation specified by metadata of a journal data point in the journal database.

A method comprising:

• replicating, by a system comprising a hardware processor, a write event to a journal vector database, the write event involving a change of a source vector database comprising vectors arranged in a multidimensional space, wherein a location of a vector in the multidimensional space is based on values of attributes contained in the vector, wherein the replicating of the write event adds a journal entry to the journal vector database, the journal entry comprising write data of the write event and metadata indicating a write operation associated with the write data, and wherein one or more journal entries from the journal vector database are to be replayed to a backup vector database that stores copies of the vectors of the source vector database;
• based on receipt of a recovery query associated with recovering data of the source vector database, obtaining, by the system according to a filter in the recovery query, a first result from the journal vector database and a second result from the backup vector database, wherein the first result comprises a first journal entry from the journal vector database, and the second result comprises a copy of a vector from the backup vector database;
• and
• merging, by the system, the first result and the second result to produce a recovered vector database as a response to the recovery query, wherein the merging of the first result and the second result comprises applying a write operation specified by metadata of the first journal entry.