6 Distributed Database Transparency Features

main purpose of distribution transparency

• improve UI design

• encrypt data

• treat the database as a single entity

• enable real-time analytics

allows transactions to update data across multiple sites

• Transaction Transparency

• Performance Transparency

• Distribution Transparency

• Heterogeneity Transparency

Why is failure transparency important in a DDBMS

• Simplifies user queries

• Increases data retrieval speed

• Prevents unauthorized access

• Ensures operation despite failures

What does performance transparency enable

• Detailed transaction logs

• Operate like a centralized DBMS

• Automatic data backups

• Function without network connections

Integration of various local DBMSs under a global schema

• Heterogeneity transparency

• Performance transparency

• Transaction transparency

• Distribution transparency

highest level of distribution transparency

• Heterogeneity transparency

• Fragmentation transparency

• Location transparency

• Local mapping transparency

must specify both the fragment names and their locations

• Heterogeneity transparency

• Fragmentation transparency

• Location transparency

• Local mapping transparency

lets a single SQL statement access the data that are to be processed by a single remote DP

• distributed request

• distributed transaction

• remote request

• remote transaction

contains the description of the entire database

• distributed data dictionary (DDD)

• distributed global schema

• distributed data catalog (DDC)

• unique fragment

What does a remote transaction allow

• Automatic data replication

• Access to multiple local databases

• Modification of local data only

• Several requests accessing a single remote DP