| Lesson 6 | Distributed databases |
| Objective | What are the features of a distributed database? |
There is an ongoing debate regarding a standard definition for distributed Oracle databases. To Oracle, a
distributed database is a geographically distributed system composed entirely of Oracle products. To the GUI/tools
vendors, a distributed database is a system that is distributed architecturally, having systems with different
architectures and access methods. To the hardware vendors, a distributed database is a system composed of different
databases, all running on the same hardware platforms.
In fact, each of these descriptions fits the overall distributed model, but there are some distinguishing characteristics that differentiate a real distributed database from a loosely coupled system.
The standard definition of distributed database has been developed by C. J. Date; he lists 12 specifications for an ideal distributed database:
In fact, each of these descriptions fits the overall distributed model, but there are some distinguishing characteristics that differentiate a real distributed database from a loosely coupled system.
The standard definition of distributed database has been developed by C. J. Date; he lists 12 specifications for an ideal distributed database:
- Local autonomy
- No reliance on a central site
- Distributed Continuous operation
- Location independence
- Fragmentation independence
- Replication independence
- Distributed query processing
-
Distributed
transaction management
(update processing) - Hardware independence
- Operating-system independence
- Network independence
- Database independence