Distributed Databases Questions
Data fragmentation refers to the process of dividing a database into smaller fragments or subsets of data that are distributed across multiple nodes or locations in a distributed database system. This fragmentation can be done based on various criteria such as horizontal fragmentation (dividing the rows of a table), vertical fragmentation (dividing the columns of a table), or hybrid fragmentation (a combination of horizontal and vertical fragmentation).
Concurrency in a distributed database refers to the ability of multiple users or transactions to access and manipulate the data simultaneously without causing conflicts or inconsistencies. It involves managing concurrent access to the shared data across different nodes or locations in the distributed database system. Techniques such as locking, timestamp ordering, and optimistic concurrency control are used to ensure data consistency and prevent conflicts when multiple users or transactions attempt to access or modify the same data simultaneously.