Implementation of ObjectRelational DBMSs in a Relational Database

Implementation of Object-Relational DBMSs in a Relational Database Course Ming Wang 2001년 11월 7일 컴퓨터교육 1학기 012 CSE 14 이 지 유

Contents n n n n Abstract Introduction Background of ORDMBS Database Course Design and Implementation Tools Examples of Class Activities Outcomes

Abstract Rapid Changes in DBMS Technology Add on the database curriculum Object-relational DBMS

Introduction n Why Rapid Changes in DBMS Technology? Revolutionary Aspect Heavy Investment Unsolved Problem Object-Oriented Database Management System Can’t Change (OODBMS) Based OOP

Introduction (Cont’d) n Why Rapid Changes in DBMS Technology? Evolutionary Aspect Data Process complex and complex queries Object-Relational Database Management Appropriate Choice!! System(ORDMBS) Extended RDB Tech.

Reasons to bring ORDBMS Include object-oriented features in ISO SQL 3 Prepare for student’s career development HOW? ? Help to understand object-oriented concepts Resolution of Weakness in Relation DB

Five Topics to teach ORDBMS n n n Background of ORDBMS Course Design and Implementation Tools Class Activity Outcomes

Background of ORDBMS Past Decades Combine These Days traditional benefits and RDMBS ability to deal ORDMBS with complex data Can’t support object presentation

Database Course Design n Topic in Object-relational Part Object-relational DBMS Design User-defined object types and methods Type constructors Manipulating composite data types Data inheritance Update-query and Select-query

Database Course Design n Student ability for learning DB Describe ORDBMS, know how to differ. Explain concept of data inheritance Know how to solve problems Explain extended data type and user-defined type Implement update and query rules

Design and Implementation Tools -UML(Unified Modeling Language) n clas s nam Att e rib ut Me es th od Tool for ORDBMS Design Employee Department ENO EName Bdate: Date Salary age chagne_dept Dept_no Dept_name Add_Employee

Design and Implementation Tools -Oracle Database Server n n Tool for ORDBMS Design Reduce application development time and effort SQL Plus PL/SQL JDBC Define data type user-defined object, method application programming

Examples of Class Activities To solve problems in real DB world pick a miniworld scenario relational DB approach draw conclusion by through object relational comparison approach

Examples of Class Activities - Normalization Problem No city etc zipcode 1 seoul. . . 135281 2 seoul. . . 135281 3 seoul. . . 120110 4 5 6 7 seoul jeju . . 120020 120110 1111112 user-defined “Address” No City Zipcode Etc

Examples of Class Activities - Speed up query processing A Table No B Table A-col B-col C Table C-col D Table D-col

Examples of Class Activities - Call stored complied functions defined Server Object I Call Fuction 1 Function 2 Object II Call Fuction 1 Object III Call Fuction 2 Object IV Call Fuction 2

Examples of Class Activities - Ruse User-defined data objects user-defined “Address” No City Zipcode Etc Reused “Address” No City Zipcode Etc

Outcomes RDBMS Don’t solve problem Students understand object-relational DB and object-oriented programming ORDMBS Solve problem Experience with C++, Java and Rose programming