Chapter 16 Data Distribution and Distributed Transaction Management

In this chapter, we focus on the specifics of distributed databases (i.e., systems where the data and DBMS functionality are distributed over different nodes or locations on a network). First, we discuss the general properties of distributed systems and overview some architectural variants of distributed database systems. Then, we tackle the different ways of distributing data over nodes in a network, including the possibility of data replication. We also focus on the degree to which the data distribution can be made transparent to applications and users. Then, we discuss the complexity of query processing and query optimization in a distributed setting. A next section is dedicated to distributed transaction management and concurrency control, focusing both on tightly coupled and more loosely coupled settings. The last section overviews the particularities of transaction management in big data and NoSQL databases, which are often distributed in a cluster set-up, presenting BASE transactions as an alternative to the traditional ACID transaction paradigms.

[tatjanaeason]

Professor Baesens, I have learned more from you than from any Professor I have ever had. I appreciate the time you give in creating such instructional deliveries. The tutorials are consistently motivating most stimulating. Your abilities in choosing invaluable foundational and advanced skills for administering databases are phenomenal. Thank you