Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Managing Distributed Databases

© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

 

 

Key Features

* Understand the factors that create distributed database.

* Learn performance and tuning methods.

* Employ solutions to distributed database communication.

* Use distributed object technology and distributed databases.

* See object management architecture.

* Employ cross-database connectivity for IBM mainframes.

* Understand the problem of cohesive updating.

* Use RAID backup technology.

* Avoid common problems with distributed database security plans.

* Design expert systems for distributed performance and tuning.

  

Course Description

At last, a concise and understandable course to guide the IS professional through the labyrinthine world of managing distributed databases. This practical seminar show you how to apply proven techniques to distributed architectures and do it today. You will learn how distributed database system are maintained and controlled, with a focus on incorporating legacy databases into an enterprise database system. This course is indispensable for anyone faced with the challenge of managing distributed databases.

What's Happening?

Due to the volatile nature of corporate computing in the 1990's many corporations are faced with the issue of managing widely distributed database systems, spanning geographical areas, hardware platforms and database architectures. Other shops are embracing "downsizing" and "rightsizing" and have created situations where many diverse "islands" of information are spread across many computer networks.

"Open systems" has become one of the foremost buzzwords of the 1990's but very little has been written about the issues involved with managing a diverse network of databases and how to make disparate database systems behave as a part of an integrated enterprise.

Today’s IS professional must insure that all of the information resources within an organization are able to communicate with each other. This "bridge building" function is very foreign to the traditional manager who is accustomed to the centralized mainframe environment. The recent popularity of client-server tools has also effected the expectations of the end-user community. This type of Inter-database integration presents a challenge to the administrator who must develop a method for the diverse databases to act as if they were a single, integrated system.

This session explains the major issues and looks at tips and methods for creating and managing distributed database applications. Techniques for managing dispersed databases will also be covered with an emphasis on client-server solutions.

What You Will Learn

The first day of this seminar will introduce the concepts of distributed database technology and provide a strong foundation for applying proven management techniques to distributed database systems. Managing distributed client-server databases, managing distributed access control, and managing concurrent updates with be covered with an emphasis on practical solutions to complex problems. Distributed database connectivity, and distributed object technology will also be covered.

Day two will cover the backup and recovery techniques for distributed databases, distributed system security and auditing, performance and tuning for distributed systems, and future trends within distributed systems.

What Makes this Seminar Unique?

Unlike other "overview" seminars, this session will offer practical examples from existing databases and show the student how to immediately manage and control distributed systems.

Numerous in-class exercises guide the students to a complete understanding of the enterprise and federated system management, and the student will leave the course with a practical, not theoretical, understanding of distributed systems. Actual code examples will illustrate the principles and the student will have enough information to immediately apply the principles in their own shops.

Included in the Seminar

Two days of a rigorous, intensive approach that insures a complete understanding of distributed systems issues and management techniques directly from the author who wrote the book on managing distributed databases. Actual code examples that demonstrate how distributed technology is used with existing systems, including UNIX, Oracle, IDMS, and many others.

Book Required

  • N/A

Audience

This seminar is indispensable for IS professionals who are planning a strategy for distributed systems, Database Administrators who must integrate the diverse data sources, and Applications Programmers and Analysts who need to understand how distributed technology will change business.

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Burleson was chosen by Oracle Press to write the authorized edition of Oracle High-Performance SQL tuning.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle distributed systems training.

 



 

Managing Distributed Databases
Syllabus

© 2007-2016 by Donald K. Burleson

Day One:
 
· Overview of distributed architectures
· A historical perspective - organization and economic factors in distributed databases
· The factors that create distributed database
Specialized databases
Rightsizing
Corporate acquisitions
· Essentials of distributed databases
Data integrity management
Transparency features
Location transparency
Domains and location transparency
Performance and tuning methods
Interoperability features
· Replication and reliability
Master-slave replication
Operating system copy replication
Replication advantages
· Types of distributed databases
Architectural distribution
Geographical distribution
· The myth of open systems
· Solutions to distributed database communication
· The impact of client-server on distributed systems
· Distributed database analysis & design
DAY 2
 
· Enterprise and Federated database systems - Incorporating the overall model
· Object technology and distributed computing
 
· The distributed data issue
· Distributed object technology and distributed databases
Historical background
The data duality
The problem of standards
Distributed object-oriented technology
· CORBA - A common architecture for distributed systems
The goals of the object management group
Benefits of object management
Object management architecture
The ODMG object model - overview
 
· DCE - UniSQL
· Distributed database connectivity
 
Database API's
ODBC - an overview
Programming for portability
Intersystem connectivity
A closer look: PowerBuilder
The internals of Oracles SQL*Net
Cross-database connectivity for IBM mainframes
Data communications - Oracle’s SQL*Net
· Distributed database access control
Developing the domain hierarchy

 

 
· Distributed database concurrency management
The problem of cohesive updating
Database locking and granularity
Lock escalation
Alternative integrity mechanisms
Distributed database concurrency
Two-phase commit issues

· Distributed database backup and recovery
Processing modes
Concurrent processing
Transaction logging mechanisms
Centralized backup methods
RAID backup technology
Flying dumps - continuous operations
Developing an overall recovery strategy
 
· Distributed Database Security
 
Data-level security role-based security and non-relational databases
Application-level security - SQL security
Security for distributed databases
Problems with distributed database security
Benefits of distributed database security
Developing a distributed database security plan
Common problems with distributed database security plans
How security is breached
De-encryption methods
Cruising RAM
Shopping and Guessing
Trojan horses
Preventing security breaches
Enhancing encryption methods
Requiring frequent password changes
Removing application-based security
A closer look: Oracle SQL security

· Performance and tuning for distributed databases
Types of performance measurement.
Multi-tasking and multi-threading
I/O-based tuning
Memory-based tuning
System-based tuning
Tuning distributed SQL
Planning for growth
Designing expert systems for distributed performance and tuning
Disk issues with distributed database performance
· The Future of Distributed Systems
New data architectures
Text architectures - Folio, Fulcrum, ConQuest, HTML
New human roles
Object administration

 


 
 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational