Database usages model
Two operations can be performed with a database first, ingest data (or write data into the database) and second, retrieve data (or read data from the database). These two operations will always be present.
On the ingestion side, the data will be ingested in two different ways. It will either be data update or brand new data (such as an insert operation). To retrieve data, you will analyze the change data capture (CDC) set, which is changes in existing data or accessing brand new data. But what drives your choice of database is not the fact that these two operations are present but rather the following:
- How often will the data be retrieved?
- How fast should it be accessed?
- Will the data be updated often, or will it be primarily new?
- How often will the data be ingested?
- How fast does ingestion need to be?
- Will the ingested data be sent in batches or in real-time?
- How many users will be consuming the data?
- How many simultaneous processes will there be for ingestion...