|
|
|
 |
O8DDIOracle8: Distributed database creation
Students of course study methods of allocation of the data for implementation of the reliable distributed applications and databases. Practical skills on creation of links of databases for configurations a server-server and on usage of snapshots for duplicating tables take root. Elimination of failures and restoring of the distributed databases is discussed also.
By the end of course students will learn:
To connect some systems in distributed network
To manage, customize distributed database Oracle and to debug it
Circle of students:
Managers of databases
Managers of systems
Developers of distributed
Necessary preliminary preparation:
Introduction in Oracle
Oracle8: Administration of databases
Oracle8: Networks management
the Program of course:
- the Browse of the distributed systems (a configuration a client-server and a server-server, characteristics of the environment of the distributed DB, a difference between the remote both distributed inquiries and transactions)
- Creation of the distributed database (definition of location of the data, private and readily available links, a transparency of location of the data, creation and support of duplicated tables, snapshots, option Advanced Replication Oracle7)
- Monitoring of the distributed transactions (two-phase fixing of transactions, system numbers of changes, mechanisms of the locking for the distributed transactions, usage of representations of the data dictionary for monitoring, permission of situations with doubtful transactions)
- Debugging and restoring of the distributed database (complete and incomplete)
- Administration managerial control by the distributed database (access modes to the remote databases, the reporting, Passwords and loading of the data in the distributed database)
For familiarity are recommended courses:
Oracle8: Development of program units on PL/SQL
Oracle8: the Practical work on saving and restoring of databases
Oracle8: the Seminar on customization of productivity
For the further training courses are recommended:
Oracle8: Extended duplicating mode.
Education coast on cource - USD 750
Cource duration (days) - 3
|
|
