Distributed Database systems
A distributed database is a database that is composed of two or more files that are situated in different locations either on the same network or on entirely different networks. Precisely, in this type of database, portions of the database are stored in multiple physical locations and processing is distributed among the different database nodes. This type of database has a number of features. The database is not a loosely connected file system, it is hardware independent, has a distributed transaction management, the operating system is independent, and a distributed query process. Additionally, distributed databases can either be homogenous or heterogeneous. In a homogeneous distribution system, all the physical locations run the same operating systems and database applications as well as the same underlying hardware (Elvis & Godbole 361-370). These systems appear to the user as a single system and tend to be easier to manage and design. For a distribution database to be homogenous, the data structures at each location must either be compatible or identical. On the other hand, in a heterogeneous distributed database, the operating system, hardware, and database applications tends to be different at each location. Different sites may use different software and schemas though this difference can make transaction and query processing to be challenging.
How concurrency control is done in a distributed database
Concurrency control is a fundamental aspect in a distributed database system design. Precisely, concurr
Activate subscription to View the Whole Post