Database Reference
In-Depth Information
Personalized databases are always centralized in one location. If your company
has a centralized computer system, then the database must reside in that central
location. In the client/server architecture, the database resides on a server machine.
The entire database may be kept on a single server machine and placed in a central
location.
When all corporate data is in one place in a centralized database, companies find
it easier to manage and administer the database. You can control concurrent
accesses to the same data in the database easily in a centralized database. You can
maintain security controls easily. However, if your company's operations are spread
across remote locations, these locations must access the centralized database
through communication links. Here, data availability depends on the capacity and
dependability of the communication links.
Distributed
Figure 1-12 shows how fragments of a corporate database are spread across remote
locations.
Global organizations or enterprises with widespread domestic operations can
benefit from distributed databases. In such organizations computer processing
is also distributed, with processing done locally at each location. A distributed
database gets fragmented into smaller data sets. Normally, you would divide the
Fragment
of
Enterprise
Database
Fragment
of
Enterprise
Database
Fragment
of
Enterprise
Database
Fragment
of
Enterprise
Database
Fragment
of
Enterprise
Database
For global and spread-out
organizations, centralized
databases not economical.
Enterprise data distributed
across multiple computer
systems.
Two categories:
Homogeneous databases
Heterogeneous databases
Figure 1-12
Distributed database.
Search WWH ::




Custom Search