A sensible approach: pick a primary datastore that matches the access patterns (e.g., OLTP relational DB for transactional workloads, document store for flexible records), supplement with caches and search indexes (e.g., Redis, Elasticsearch) where needed, and design clear migration and backup strategies.
Using this search term is generally considered for several reasons: software 94fbr