CSE :: Database System 2 - CS
- Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.
- An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites.
- Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network.
- A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.
- Data replication is favored where most process requests are read-only and where the data are relatively static.
- The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex.
- In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.
Whatsapp
Facebook
