Notice To All Users:All books of this website are for public. No files are hosted on our server, they are only indexed much like how Google, Yahoo, Bing, ect works. This site merely indexes content that is readily available all over the web. The hosting server or the administrator cannot be held responsible for the contents of any linked sites or any link contained in a linked site, or changes / updates to such sites. All materials on this website is strictly for Educational Purposes ONLY.
File Format | PDF
File Size | 4.83 MB
Pages | 526
Language | English
Category | Database
|
Description: Any organization that uses the Oracle relational database management system (RDBMS) these days needs to use multiple databases. There are many reasons to use more than a single database in a distributed database system:
Different databases may be associated with particular business functions, such as manufacturing or human resources.
Databases may be aligned with geographical boundaries, such as a behemoth database at a headquarters site and smaller databases at regional offices.
Two different databases may be required to access the same data in different ways, such as an order entry database whose transactions are aggregated and analyzed in a data warehouse.
A busy Internet commerce site may create multiple copies of the same database to attain horizontal scalability.
A copy of a production database may be created to serve as a development test bed.
In a distributed database environment, data in two or more databases is accessible as if it were in a single database. Usually, the different databases are on different servers, which may be located at the same site or a continent away. Communication between the servers takes place via SQL*Net (for Oracle7) or Net8 (for Oracle8).
Distributed database environments offer a number of benefits over single- database systems, including:
Tunability
Platform autonomy
Fault tolerance
Scalability
Location transparency
Site autonomy
|
Oracle Distributed Systems
Download | Free
