{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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

Info icon This 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 [email protected]
Image of page 1

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

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

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

View Full Document Right Arrow Icon
Object-Relational Elements in Oracle 10 g ° Object-Oriented Concepts ° Objects ° Methods ° Object Tables ° Type Inheritance 4 C. Shahabi ° Collections ° Object Types and References
Image of page 4
Object-Oriented Concepts ° Abstraction and Encapsulation (Provided by Abstract Data Types (ADT)) square4 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. square4 Encapsulation (or information hiding) provides data independence by separating the external aspects of an object from its internal details, which is hidden from the outside world. 5 C. Shahabi ° Classes square4 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. square4 Attributes (or instance variables) describe the current state of an object (the notation for attribute: object-name.attribute-name).
Image of page 5

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

View Full Document Right Arrow Icon
Object-Oriented Concepts square4 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.
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. ° Ability and support for complex objects and rich data types, 7 C. Shahabi 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
Image of page 7

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

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

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern