When should you split a database?

When should you split a database?

What is meant by distributed database?A distributed database is a database that consists of two or more files located in different sites either on the same network or on entirely different networks. Portions of the database are stored in multiple physical locations and processing is distributed among multiple database nodes.

 When would you use a distributed database?

 Often distributed databases are used by organizations that have numerous offices or storefronts in different geographical locations. Typically an individual branch is interacting primarily with the data that pertain to its own operations, with a much less frequent need for general company data