Object-Oriented Oracle Technology for Oracle Professionals

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

Click here for on-site course prices

* 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.

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.

• 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.

• Identification of objects - real-world modeling
• Object representation
• Data storage for composite objects
• Differences between existing data storage methods
• Benefits of object-oriented systems

• Comparisons of methodologies
• Retrofitting existing systems into object technology
• Improving on traditional systems design methods

• In-class exercise - object analysis
• In-class exercise - conversion of existing systems
• In-class exercise - Polymorphism
• In-class exercise - Inheritance
• In-class exercise - Encapsulation

• The problem of data aggregation
• Loosely-coupled vs. tightly-coupled relationships
• Declarative data access
• SQL and the relational paradigm

• 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

• The impedance mismatch problem
• DBRM's, database triggers, using relational views
• Distributed Object Models - CORBA, DSOM, DCE, Cairo
• Object extensibility - creating new classes dynamically

• 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

• C++ vs. SmallTalk
• CASE tools for analysis & design
• Implementation tools
• Tools for distributed object systems

• 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

• 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