Oracle Training Oracle Support Development Oracle Apps

 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
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

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

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Object-Oriented Oracle Technology for Oracle Professionals

© 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 data storage for composite objects.

* See comparisons of methodologies.

* Employ conversion of existing systems.

* Understand loosely-coupled vs. tightly-coupled relationships.

* Use internal data structures within object databases.

* Create new classes dynamically.

* Employ normalization and object database design.

* Use tools for distributed object systems.

* Understand artificial intelligence / intelligent databases.

* Resolve the pointer architecture problem.


Course Description

This two-day class is indispensable for anyone who wants to understand a painless way to enter object technology. This very practical seminar shows you how to apply object techniques to relational databases and do it now. Through numerous in-class exercises, the student will internalize the object paradigm and learn practical approaches and constructs that allow legacy databases to function within the scope of an object-oriented framework.

What's Happening?

Many companies recognize the value of Object Technology, but are reluctant to abandon their relational databases. However, the benefits of object technology are so compelling that it is necessary to fully understand polymorphism, encapsulation, overloading and inheritance. When one strips away all of the confusing acronyms and jargon, the object technology approach is nothing more than a method, an approach to systems design which can be implemented without any changes to existing software technology. This seminar outlines the solution.

The object technology method heralds the next generation of database design. Unlike today's architecture of one database with the "logic" buried in hundreds of external programs, tomorrow's object-oriented databases will store data, relationships between data, and the behavior of the data. These "intelligent" databases will revolutionize database systems development.

What You Will Learn

The first day of this seminar will introduce the concepts of Object Technology and give practical examples of how polymorphism, encapsulation, overloading, and inheritance can be applied within traditional business applications. Unlike other seminars, the student will work through in-class exercises and internalize Object Technology concepts. Factual benefits of Object Technology will be described and the student will learn how to separate hype from fact.

Day two will cover the Relational/Object model and describe how the object techniques can be applied to existing databases. The student will understand basic object normalization techniques and the differences from relational database design. This seminar will also demonstrate how a C++ application can be modified to use a relational database.

Unlike other "overview" classes, this session will offer practical examples from existing systems and show the student how object technology can be applied to existing technology. Numerous in-class exercises guide the students to a complete understanding of the entire object paradigm, and the student will leave the course with a practical, not theoretical, understanding of the object paradigm. Actual code examples will show how Object Technology can be applied to relational databases.

Book Required

  • N/A


This course is designed for the working Oracle professional and the amount of previous experience with Oracle is incidental.
Previous experience with relational database management and SQL is helpful, but this class is self-contained and has no formal prerequisites.

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including 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 training.


Day One:
The issue of objects (1 hour)
  • Identification of objects - real-world modeling
  • Object representation
  • Data storage for composite objects
  • Differences between existing data storage methods
  • Benefits of object-oriented systems
Fitting the paradigm - object-oriented data design (2 hours)
  • Comparisons of methodologies
  • Retrofitting existing systems into object technology
  • Improving on traditional systems design methods
Internalizing object technology concepts (2 hours)
  • In-class exercise - object analysis
  • In-class exercise - conversion of existing systems
  • In-class exercise - Polymorphism
  • In-class exercise - Inheritance
  • In-class exercise - Encapsulation
Relational Databases - The primary issues (1 hour)
  • The problem of data aggregation
  • Loosely-coupled vs. tightly-coupled relationships
  • Declarative data access
  • SQL and the relational paradigm
Objects and databases - In-depth (1 hour)
  • The different vendors and their approaches
  • Internal data structures within object databases
  • Navigational data access and vendor databases
  • SQL++ and declarative data access
  • Management of object structures
  • Performance issues with object databases


Day Two:
Melding the Paradigms - Objects and RDBMS (1 hour)
  • The impedance mismatch problem
  • DBRM's, database triggers, using relational views
  • Distributed Object Models - CORBA, DSOM, DCE, Cairo
  • Object extensibility - creating new classes dynamically
A database independent Object-oriented Method (2 hours)
  • Object/Relational Analysis & Design
  • Data flow diagrams and functional decomposition
  • Normalization and object database design
  • Incorporating the data model into the process model
  • Cross-reference diagrams - object-to-behavior and behavior-to-object
  • Managing behaviors that effect multiple classes
The current object development tools (1 hour)
  • C++ vs. SmallTalk
  • CASE tools for analysis & design
  • Implementation tools
  • Tools for distributed object systems
Future issues with object and relational technology (2 hours)
  • Market influences - object operating systems, environments
  • Artificial intelligence / intelligent databases
  • Stretching the market like of relational databases
  • Object mediator tools and products - debugging tools
  • Distributed object environments
Using C++ with Oracle Relational Databases (1 hour)
  • Rationale behind mixing the paradigms
  • In depth coverage of C++ syntax
  • Evolution of a sample system
  • Resolving the pointer architecture problem
  • Bringing it together - working systems




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