Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Object oriented data model ppt

25/11/2021 Client: muhammad11 Deadline: 2 Day

Chapter 9
Object-Oriented Database Management

BLCN-534: Fundamentals of Database Systems

Chapter Objectives

List several limitations in the relational database model.
Describe the object-oriented database concept.
Model data using such complex relationships as generalization and aggregation, and such concepts as inheritance and polymorphism.
Describe the benefits of encapsulation.
Describe the value of developing abstract data types.
Explain what an object/relational database is.
9-*

Object Orientation

An alternative approach to information systems and IS development.
Began during the 1980s.
More data-centric.
9-*

What’s Missing in the Relational Database Concept?

Many people would say that nothing is missing from the relational model.
Others would point out that for certain kinds of complex applications, the relational model is lacking in support for the more complex data model features they need.
9-*

What’s Missing in the Relational Database Concept?

Does not directly provide support for generalization/specialization.
Does not directly provide support for aggregation.
9-*

What’s Missing in the Relational Database Concept?

Does not have a system in which only a limited, controlled set of program segments is allowed to update particular data.
Does not directly support more complex data types such as:
graphic images
photo images
video clips
audio clips
long text documents
mathematical constructs such as matrices
9-*

Terminology: Object-Oriented Data Modeling

Object - describes an advanced data structure that includes an entity’s attributes plus methods or operations or procedures (program code!) that can operate on and modify the object’s attribute values.
(object) class - the objects that describe similar entities.
9-*

More advantages of Object Oriented Database Concept

Each object has an object identifier that is permanent and unique among all objects of all types in the system.
Some OODBMSs are implemented as pointer-based systems. related objects are “connected” by their storage addresses.
OODBMSs are the most natural data storage vehicles when object-oriented programming languages, such as C++, Smalltalk, and Java, are in use.
9-*

Unified Modeling Language

Introduced in 1997 by the Object Management Group (OMG)
Has nine standard diagrams that describe:
the system’s data
the business processes
the intended results
the components of the program code
the hardware and software architectures.
9-*

UML Class Diagram

Describes the system’s data, including attributes of and relationships between the “objects.”
9-*

Generalization

Also known as generalization/specialization
Is a relationship that recognizes that some kinds of entities can be subdivided into smaller, more specialized groups.
9-*

General Hardware Company ERD

General Hardware company E-R diagram.
General Hardware is a wholesaler.
9-*

General Hardware Company Generalization Diagram

Each box represents a class and has three sections separated by horizontal lines.
At the top, in capital letters, is the class name
In the middle are the class attributes
At the bottom are the class operations (not shown)
9-*

General Hardware Company Generalization Diagram

The upward pointing arrows indicate generalizations.
There are three kinds of products
TOOLs
LIGHT FIXTUREs
LUMBER
There are two kinds of tools
POWER TOOLs
NONPOWER TOOLs
9-*

Inheritance of Attributes

The PRODUCT class indicates that all products have three common attributes: Product Number, Product Name, and Unit Price.
All of the classes below PRODUCT inherit the attributes shown in PRODUCT.
9-*

Inheritance of Attributes

The attributes for POWER TOOLs are:
(from Product)
Product Number
Product Name
Unit Price
(from TOOL)
Weight
(from POWER TOOL)
Amperes
9-*

Inheritance of Attributes

The attributes for NONPOWER TOOLs are
(from Product)
Product Number
Product Name
Unit Price
(from TOOL)
Weight
(from NON-POWER TOOL)
Years of Warranty
9-*

Inheritance of Attributes

The attributes for LIGHT FIXTUREs are
(from Product)
Product Number
Product Name
Unit Price
(from LIGHT FIXTURE)
Number of Bulbs
Watts per Bulb
9-*

Inheritance of Attributes

The attributes for LUMBER are
(from Product)
Product Number
Product Name
Unit Price
(from LUMBER)
Type of Wood
Dimensions
9-*

Operations

Operations have now been added to the UML Diagram.
There are three kinds of operations:
Constructor
Query
Update
9-*

Operations: Constructor

Creates a new instance of a class, that is, a new object.
Example: Add Lumber
an operation that will add a new instance of LUMBER, that is, a new object, to the database.
9-*

Operations: Query

Returns data about the values of an object’s attributes but does not update them.
Example: Calculate Discount
calculates a discount for a particular customer buying a particular product and returns the result to the user who issued the query, but does not store the result in the database.
9-*

Operations: Update

Updates an object’s attribute values.
Example: Change Unit Price
a product’s unit price may have to be changed, and the result is stored in the database as the new unit price.
9-*

Polymorphism

Modification or refinement of operations as they are inherited downward.
The operations that are performed differently in the lower level objects can have modified names and will perform differently for the different kinds of objects.
9-*

Polymorphism

Looking at “Calculate Discount”:
Since there is nothing more said about the discount further down the hierarchy, the discount is calculated in the same way for all kinds of products.
Looking at “Calculate Extended Warranty Price”:
polymorphism occurs in the Calculate Extended Warranty Price operation because it is performed differently for power tools and nonpower tools.
9-*

Aggregation

9-*

Aggregation

A class is shown to be composed of other classes.
FRAMEs and BULBS are not kinds of LIGHT FIXTUREs; rather, each is a part of a LIGHT FIXTURE.
9-*

General Hardware Company Class Diagram

9-*

Good Reading Bookstores Class Diagram

A generalization hierarchy has been created under PRODUCT, which indicates that there are four kinds of products: BOOK, PERIODICAL, CD, and VIDEO/DVD.
The PERIODICAL class, and only this class, is associated with the ARTICLE class.
9-*

World Music Association Class Diagram

A generalization hierarchy has been constructed with subordinate classes ORCHESTRA, CHAMBER GROUP, and JAZZ GROUP.
9-*

Lucky Rent-A-Vehicle
Class Diagram

Lucky Rent-A-Car has expanded to become Lucky Rent-A-Vehicle!
A two-level generalization hierarchy under VEHICLE.
The diamond-shaped symbol on the branch under the TRUCK class indicates that there is an aggregation diagram under it.
9-*

Encapsulation

The attributes of a class or even an individual object are “encapsulated,” stored together on the disk, with the operations that will act upon them.
OODBMS will only permit the attributes of the encapsulated objects to be updated by the encapsulated update-type operations, thereby improving data integrity.
9-*

Encapsulation

When an application program requires encapsulated data, it sends a message to one of the object’s encapsulated operations to trigger it into action.

The application program sends along any input data needed for the operation.

9-*

Abstract Data Types

Object-oriented database allows the creation of new, abstract data types and operations that are associated with them.

9-*

Object/Relational Database

OODBMSs were lacking in several areas, including the superior query capabilities of SQL that everyone had become accustomed to.
Relational database and object-oriented database have come together in the form of hybrid relational database management systems with object-oriented features added to them.
9-*

General Hardware Company as an Object/Relational Database

9-*

Polymorphism

• Modification or refinement of operations as they are inherited downward. • The operations that are

performed differently in the lower level objects can have modified names and will perform differently for the different kinds of objects.

9-24

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Phd Writer
Helping Engineer
Solutions Store
Supreme Essay Writer
Coursework Help Online
Accounting & Finance Master
Writer Writer Name Offer Chat
Phd Writer

ONLINE

Phd Writer

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$43 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$39 Chat With Writer
Solutions Store

ONLINE

Solutions Store

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$43 Chat With Writer
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$36 Chat With Writer
Coursework Help Online

ONLINE

Coursework Help Online

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$36 Chat With Writer
Accounting & Finance Master

ONLINE

Accounting & Finance Master

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$23 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Week5 Community Nurse - Shigley's mechanical engineering design 10th edition solutions chapter 1 - Project l has the following cash flows, and its cost of capital is 10%. what is l's mirr? - Need help building code - THE FOUNDATION OF HEALTH CARE LAW AND ETHICS IN THE UNITED STATES - Antibiotic resistance can we ever win key - Blade cutting force calculation - Facebook killings - Leadership in organizations yukl 8th edition pdf - Contract law commentaries cases and perspectives pdf - Business law simulation - The basic measure of mass in the metric system - Hurley gp rota login - Water for elephants chapter 10 summary - St john action plan - Arabian journal for science and engineering - Marketing Strategies - Small assignment - Firms that achieve higher growth rates without seeking external financing - Carl rogers personality test - Beer industry threat of new entrants - Discussion Board Replies - Human Research Paper - Length area and volume worksheets - Medical coding ashworth college - Lifeline sleep center warrendale pa - Baby animals and their mothers worksheet - Zwick valves north america - Form 6 superannuation information kit - Week 5 socioautobiography audio powerpoint - Vaccination persuasive speech - How can you contrast intellectual and physical ability - Sage business care silver plan - Amp capital dynamic markets fund - News Analysis 2 - Not-for-Profit Organizations discussion 2 - Packet tracer projects pdf - Economic forecasting - Igneous rock song lyrics - Kkk cross symbol - Protein synthesis & amino acid worksheet - Weekly Assignment - Structural steel australian standard - Istikhara transliteration and translation - Hyperbole in i have a dream speech - Hr diagram lab answers - Organizational Theory - Discussion - Brian phillipson sacramento ca verdict - Contract law attack outline - The retained earnings statement shows all of the following except - Express as a single fraction in lowest terms - Big data analytics lab exercises - Rsa its history its methodology and where it is used - Liverpool council email address - Finkelman 2016 pp 111 116 - What is word play? - Ministry of road transport and highways sarathi - Career Goal and Plan in 20 years. - Sewer diagram sydney water - Diode iv characteristics equation - Control system engineering ppt - Adf assessment day medical - Discussion 1 - Qualifications needed to teach at tafe - You are mine spencer combs chords - Bransford and johnson 1972 - Books of original entry questions and answers pdf - British museum pompeii bread recipe - Cyclic code generator polynomial example - Management excellence inc - E466 food code meaning - Leadership Portfolio - Requerimiento 1510 worksheet answers - North devon netball league - A 1130 kg car is held in place - SOCW 6103 Wk 5 Assignment Requirements - Assignment: Relapse Prevention - The secret to efficient teamwork is ridiculously simple - Florida nurse practitioner scope of practice - Saddle inc has two types of handbags - Accommodation wanted advertisement example - Labeled map of russia - How is atp resynthesised - Macquarie university windows 10 - Tmmc assessment answers - Assessing Client Families - Net sourceforge jtds jdbcx jtdsdatasource - Medical words ending in ism - Lemon law san diego - Formative assessment examples for science - States of matter word search - Discussion science report example - Y 2x 4 in point slope form - St maurice's high school - A leap into history reading answers - 10 plagues egyptian gods chart - Sample soap note for diabetes - Bdc entrepreneurial potential self-assessment - My name sandra cisneros analysis - Alexander the great quote - John deere industrial revolution