Home Company Information Consulting Course Catalog Contact Us Request a Quote Government Corporate
 


We are here to help...
Let us answer your questions.
With easy ways to get the answers you need:
Call Me
Or call us at:
      1-888-742-3214


Profile


e-Catalog
Contact
Search
Cart
Database Technologies - Object-Relational DBMSs: Characteristics

Course Status: Released
Course Language: English
Course Duration: 4 Hours
Deployment Options: Online, Interactive CDs, Network, Downloads, Intranet

Audience
System administrators and database developers
Prerequisites
A knowledge of both RDBMS and OODBMS
Course Aim
To introduce the concept of object-relational DBMSs
Learning Objectives
Describe object-relational databases, and how they differ from relational and object-oriented DBMSs.
Explain how an ORDBMS can be used to solve problems associated with complex data.
Explain the use of base datatype extensions and user-defined functions and operators.
Discuss the role of complex objects and how to manipulate composite datatypes.
Explain the concept of data inheritance in an ORDBMS.
Discuss update and query rules, and how to troubleshoot them.
Topics Covered
Datatype extensions
- Object-relational DBMSs
- Base datatype extensions
- User-defined functions and operators
- Fully object-relational type extension
Complex objects
- Type constructors
- Manipulating composite datatypes
- Using references
- Base types and complex objects
Inheritance
- Data inheritance
- Inheriting functions
- Overloading
Rules
- Update-update and query-update
- Update-query
- Query-query
- Troubleshooting rules