Physical Database

What is a Distributed Database System and What are the Options? - McObject LLC

• Designed by database administrators
– Optimized structure for fast to access
– No redundancy/duplicated information
• Multiple data copies, (or multiple
representations, multiple versions of data), can
lead to inconsistent data values
– Backup copies in case of accidental data
deletion or disk crash.

• Creating specialized versions/views of the
data for different users’ needs
– Creating a new copies of view tables
from the single physical database
each time
– Each user gets to see the data he/she
cares about, and is not cluttered with
data they don’t need.