1 / 25

Department of Computer Engineering

Department of Computer Engineering. Near East University. OBJECT DATA MODELING AS STRUCTURING APPROACH IN DATABASE DESIGN. MASTER THESIS. Name : Anwar Mahmoud Dawoud Supervisor : Assist. Prof. Dr. Adil Amirjanov. Introduction.

merv
Télécharger la présentation

Department of Computer Engineering

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Department of Computer Engineering Near East University OBJECT DATA MODELING AS STRUCTURING APPROACH IN DATABASE DESIGN MASTER THESIS Name : Anwar Mahmoud DawoudSupervisor : Assist. Prof. Dr. Adil Amirjanov

  2. Introduction • One of the approach for simplification of the database design is to use object modeling of data . • In this thesis the object data modeling is used as structuring approach for database design. • The concept of the Object Relational DB System (ORDBS) as a hybrid of the RDBS and OODBS. • The ORDBMS provide Object Definition Language(ODL), and a Object Query Language(OQL).

  3. Object Data Modeling • Objects • Object-oriented programming. • A Database system. • Object Relational Databases. • Object-Oriented Databases. Some Basic Concepts :

  4. Database Management System (DBMS) Database Application programs End Users Simplified Picture Of A Database System

  5. An Object Oriented Database is the marriage of Object Oriented modeling and Database Technology Makeup of an Object Oriented Database Naming Behaviors Attributes Classes Overriding Inheritance Encapsulation Object Oriented Modeling Object identity Complex objects Persistence Integrity Query Recovery Security Database Capabilities Concurrency Transactions

  6. Basic Object Oriented Modeling • Complex Objects • Object Identity • Classes and Types. • Attributes • Behaviors • Encapsulation • Inheritance. • Overloading, Overriding, and Late Binding • Naming

  7. Requests Application Object Server Object Manager Objects Objects Store Addresses Application DB Manager Object Server Pages Objects Store SQL Application Comms Object Server Tables Client Server Architectures (a) object server (b) page server (c) database server Objects Store

  8. Requests Object Server Application Object Manager Objects Objects Store File 1 File 2 File 3 Request Object Server Application Object Manager Objects Objects Store Strategies For Handling Method (a) Storing method outside database (b) Storing method in database.

  9. Database Capabilities • 1. Integrity • 1.1 Relationships Integrity • 1.2 Nulls Integrity • 1.3 Referential Integrity • 1.4 Entity integrity • Concurrency Control • Recovery • Transactions • 5. Security

  10. Object-Relational DBMS Relational DBMS Search Capabilities multi-user Support Object-Oriented DBMS File Systems Data Complexity Extensibility Classification of DBMSs

  11. Classification of DBMSs The object features proposed in SQL3 covering: • Row types. • User-defined types (distinct types and structured types) • User-defined Routines (procedure, functions). • Polymorphism. • Supertype and subtype relationships. • Persistent stored modules. • Support for large objects.

  12. Union Difference Intersection Product a b c x y a a b b c c x y x y x y Object Relational Algebra

  13. (Normal) Join Project Restrict Divide a b c a a a b c x y z x y x z a a1 a2 a3 b1 b1 b2 a1 a2 a3 b1 b1 b2 a1 a2 a3 b1 b1 b2 a1 a2 a3 Object Relational Algebra

  14. Object Relational SQL 1- DDL (Data Definition Language) These SQL statements define the structure of a database, DDL SQL statements are more part of the DBMS and have large differences between the SQL variations. CREATE; ALTER, DROP are called DDL COMMANDS. DDL transact with tables, views, types, procedures, functions and triggers.

  15. Object Relational SQL 2- DML (Data Manipulation Language) These SQL statements are used to retrieve and manipulate data. • DML SQL commands include the following: • INSERT to add a row. • UPDATE to change data in specified columns. • DELETE to remove rows. • SELECT to retrieve row.

  16. EMPLOYEE Emp_no Emp_name Emp_birth Nationality_id Emp_id Position_id Department_id Emp_sex Emp_marital_status Emp_phone Emp_Email Emp_address NATIONALITY PK Nationality_id Nationality_name CUSTOMER PK Cus_no Cus _name Cus_birth Cus_id Cus_sex Cus_phone Cus_Email Cus_address FK GOODS FK Cus_no Good_serial Good_name Good_price Good_sale_date POSITION FK PK Position_id Position_name FK DEPARTMENT PK Department_id Department_name Database Design With Object Data Modeling The Customer And Employee Entity Relationship Diagrams

  17. New Data Types DOB POB Fname Mname Lname Name_ty Birth_ty Phone_ty City Street Mobile Home Address_ty New Data Types

  18. Emp_no Emp_name Emp_birth Nationality_id Emp_id Position_id Department_id Emp_sex Emp_martial_status Emp_phone Emp_Email Emp_address New Data Types Cus_no Cus _name Cus_birth Cus_id Cus_sex Cus_phone Cus_Email Cus_address Name_ty Birth_ty Customer Table Employee Table Phone_ty Address_ty New DataType that used in Employee & Customer Tables

  19. The Object Definition Language ( ODL ) Create table with Using objects (new defined types) Create table without using objects

  20. Cus_no Fname Mname Lname DOB POB Cus_id Cus_sex Phone Home Cus_Email City Street Cus_name Cus_no Cus _name Cus_birth Cus_id Cus_sex Cus_phone Cus_Email Cus_address Cus_birth Cus_phone Cus_address The Customer Table Before And After Using Objects CUSTOMER BEFORE USING OBJECTS CUSTOMER AFTER USING OBJECTS

  21. The Object Definition Language ( ODL ) Create view with Using objects (new defined types) Create view without using objects

  22. The Object Definition Language ( ODL ) Create procedurewith Using objects (new defined types) Create procedurewithout using objects

  23. Update Statement Without Using Objects Update Statement With Using Objects The Object Query Language ( OQL ) Insert Statement With Using Objects Insert Statement Without Using Objects

  24. Select Statement With Using Objects Select Statement Without Using Objects The Object Query Language ( OQL ) Delete Statement With Using Objects Delete Statement Without Using Objects

  25. Conclusion • The thesis analyzes the features of Object Structured Query Language (OSQL) that includes Object Data Definition Language and Object Query Language. This analysis with discussion of the advantages of OSQL was made by structuring the problem with object data modeling in Trading Company Database Design. • The comparisons of the SQL statements made with and without object • features showed that the implementing object data modeling approach in database design gets the following advantages: • Simplify the design by reduction of the steps of abstractions for mapping • the real life problem to the database structure design; • Simplify the structuring of problem by using object data modeling • Reduce the number of SQL statements in query descriptions;

More Related