Session8

Session8 - Object-Relational Features in Oracle Database...

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Object-Relational Features in Oracle Database 1 C. Shahabi Cyrus Shahabi Computer Science Department University of Southern California shahabi@usc.edu
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
View of the Database World 2 C. Shahabi
Background image of page 2
Oracle Database History of Oracle database s In 1979, Oracle Version 2 introduced An early commercial relational database system. s In 1997, Oracle version 8 released Support for object-oriented development and multimedia applications. Object-Relational DBMS 3 C. Shahabi s In 1999, Oracle 8 i released Tuned with the needs of the Internet/Web s In 2001, Oracle 9 i released Query-intensive data warehouses, and demanding Internet applications (XML, Text ) s In 2003, Oracle 10g released Support for Grid Computing s In 2007, Oracle 11g released Automatic memory disk and memory management Extended features (e.g., 3D capabilities)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Object-Relational Elements in Oracle 10 g Object-Oriented Concepts Objects Methods Object Tables 4 C. Shahabi Type Inheritance Collections Object Types and References
Background image of page 4
Object-Oriented Concepts Abstraction and Encapsulation (Provided by Abstract Data Types (ADT)) s Abstraction is the process of identifying the essential aspects of an entity and ignoring the unimportant properties. Focus on what an object is and what it does, rather than how it should be implemented. s Encapsulation (or information hiding) provides data independence by separating the external aspects of an object from its internal details, which 5 C. Shahabi is hidden from the outside world. Classes s Classes: A class is a blueprint or prototype from which objects are created. A group of objects with the same attributes and methods. Hence, the attributes and the associated methods are defined once for the class rather than separately for each object. s Attributes (or instance variables) describe the current state of an object (the notation for attribute: object-name.attribute-name).
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Object-Oriented Concepts s Methods: define the behavior of the object. They can be used to change the object’s state by modifying its attribute values, or to query the value of the selected attributes. A method consists of a name and a body that performs the behavior associated with the method name (notation: object- name.method-name). Attributes 6 C. Shahabi The instances of a class are those objects belonging to a class.
Background image of page 6
Advantages of ORDBMS Enables reuse and sharing . u Ability to extend the DBMS server to perform standard functionality centrally, rather than have it coded in each application. Example: Embedded Functions, it saves having to define it in each application that needs it. bility and support for complex objects and rich data types, 7 C. Shahabi Ability and support for complex objects and rich data types, termed abstract data types (ADTs) u Complex applications such as Oracle Spatial Support for Inheritance u Inherent attributes and behavior of the pre-existing classes, hence ease of definition and programming
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Oracle Object Types User-Defined data types (classes
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This document was uploaded on 05/16/2010.

Page1 / 28

Session8 - Object-Relational Features in Oracle Database...

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online