Monthly Archives: May 2012

Transparencies Issues

If we had to justify the rationale and the aim of the database approach, what would spring to mind?

  • Data Independence: both, Logical data independence, Physical data independence.
  • Data redundancy.

 

"Transparency refers to the separation of the higher-level semantics of a system from lower-level implementation issues."

  • Thus, data independence is a transparency issue.
  • For a distributed database approach there are other issues.

 

We want to choose and use those distributed DBMS that offer the highest level of transparency support.

Operational Difficulties With Distributed Databases

  • Data replication is common in distributed databases. Which site to query? Which site to update first and then the rest (with cascades)?
  • If a site (or a link) fails then, on re-connecting the isolated sites, the relevant data commits done during the interruption must be updated.
  • Transaction scheduling over multiple sites is much harder than the centralised case.

Distributed Databases and DBMSs

  • A distributed database is a collection of a number of logically related databases partitioned over a computer communications network, but whose data is available to all of its end users, irrespective of their physical location.
  • A distributed DBMS maintains distributed databases and attempts to achieve a high level of distribution transparancy.

Distributed and Multidatabase Solutions Introduction

Could a database be made available to a number of users without specifying a "single" computer? – Yes.

 

How?

  • Distributing the data.
  • Distributing the DBMS processing.
  • Distributing the database control etc.

What do we need?

  • More refined database techniques.
  • Better and new DBMS technology.
  • A networking infrastructure that connects all of the databases' end users.