0

I am looking for solutions for a field where I think I don't know the adequate terminology. The problem is that I have a central SQL database in the cloud. Then I have child databases only containing a defined part of the central database. The child database will not always have connection to the main database but as soon as they have they should synchronize the data they have.

What is the terminology for such a system? It is about offline availability of data but also about synchronization of subset of data available in the central database.

Improve this question
3
  • Are you referring to a Distributed database?
    – Nathan Merrill
    Commented Jun 16, 2016 at 15:27
  • Another term that might help is database sharding
    – BobDalgleish
    Commented Jun 16, 2016 at 22:42
  • Sharding usually involves the segregation of readings and writings. Each shard is focused on specific writes and reads. The closer definition of OP's configuration is just "replica". Replica sets usually replicate all the main (Primary) DB. It's mainly for HA and high failure tolerance.
    – Laiv
    Commented Sep 15, 2022 at 15:20

1 Answer 1

Reset to default
1

The general term for having off-line "child" databases is replication. I don't believe there is standard term for those child databases only containing a defined part of the central database. Call it partial replication, if you like.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.