狠狠撸

狠狠撸Share a Scribd company logo
DATABASE MODELS
A database model shows the logical structure of a
database, including the relationships and constraints
that determine how data can be stored and accessed.
Individual database models are designed based on
the rules and concepts of whichever broader data
model the designers adopt. Most data models can
be represented by an accompanying database
diagram.
Types of Database Models
1. Hierarchical database model
2. Relational model
3. Network model
4. Object-oriented database model
5. Entity-relationship model
6. Document model
7. Entity-attribute-value model
8. Star schema
9. The object-relational model, which combines the two that make up its name
Relational Model
? The most common model, the relational model sorts data
into tables, also known as relations, each of which
consists of columns and rows. Each column lists an
attribute of the entity in question, such as price, zip code,
or birth date. Together, the attributes in a relation are
called a domain. A particular attribute or combination of
attributes is chosen as a primary key that can be referred
to in other tables, when it’s called a foreign key.
Lecture 2-DATABASE MODELS lecture 2.pptx
Hierarchical Model
The hierarchical model organizes data into a tree-like
structure, where each record has a single parent or root.
Sibling records are sorted in a particular order. That order
is used as the physical order for storing the database.
This model is good for describing many real-world
relationships.
Lecture 2-DATABASE MODELS lecture 2.pptx
Network Model
The network model builds on the hierarchical model by
allowing many-to-many relationships between linked records,
implying multiple parent records. Based on mathematical set
theory, the model is constructed with sets of related records.
Each set consists of one owner or parent record and one or
more member or child records. A record can be a member or
child in multiple sets, allowing this model to convey complex
relationships.
Lecture 2-DATABASE MODELS lecture 2.pptx
Object Oriented Model
This model defines a database as a
collection of objects, or reusable software
elements, with associated features and
methods. There are several kinds of
object-oriented databases:
Lecture 2-DATABASE MODELS lecture 2.pptx
A multimedia database incorporates media, such as images,
that could not be stored in a relational database.
A hypertext database allows any object to link to any other
object. It’s useful for organizing lots of disparate data, but it’s
not ideal for numerical analysis.
The object-oriented database model is the best known post-
relational database model, since it incorporates tables, but
isn’t limited to tables. Such models are also known as hybrid
database models.
Object Relational Model
This hybrid database model combines the
simplicity of the relational model with some of the
advanced functionality of the object-oriented
database model. In essence, it allows designers to
incorporate objects into the familiar table structure.
Lecture 2-DATABASE MODELS lecture 2.pptx
Languages and call interfaces
include SQL3, vendor languages,
ODBC, JDBC, and proprietary call
interfaces that are extensions of the
languages and interfaces used by the
relational model.
Inverted File Model
A database built with the inverted file structure is
designed to facilitate fast full text searches. In this
model, data content is indexed as a series of keys in a
lookup table, with the values pointing to the location of
the associated files. This structure can provide nearly
instantaneous reporting in big data and analytics, for
instance.
Lecture 2-DATABASE MODELS lecture 2.pptx
This model has been used by the
ADABAS database management
system of Software AG since
1970, and it is still supported
today.
Flat Model
?The flat model is the earliest, simplest data
model. It simply lists all the data in a single
table, consisting of columns and rows. In
order to access or manipulate the data, the
computer has to read the entire flat file into
memory, which makes this model inefficient
for all but the smallest data sets.
Lecture 2-DATABASE MODELS lecture 2.pptx
END
Ad

Recommended

2. Chapter Two.pdf
2. Chapter Two.pdf
fikadumola
?
DIFFERENT MODELS IN DBMS.pptx
DIFFERENT MODELS IN DBMS.pptx
Kavya990096
?
classification of data models and how it
classification of data models and how it
PachaOmkar
?
Student POST ?Database processing models showcase the logical s.docx
Student POST ?Database processing models showcase the logical s.docx
orlandov3
?
data base system to new data science lerne
data base system to new data science lerne
tarunprajapati0t
?
Data models
Data models
Samuel Igbanogu
?
DBMS
DBMS
Rai Saheb Bhanwar Singh College Nasrullaganj
?
DBMS OF DATA MODEL Deepika 2
DBMS OF DATA MODEL Deepika 2
Rai Saheb Bhanwar Singh College Nasrullaganj
?
Data models
Data models
Hira Bukhari
?
Data models
Data models
Hira Bukhari
?
Databases and its representation
Databases and its representation
Ruhull
?
Presentation1
Presentation1
Celso Catacutan Jr.
?
Data models and ro
Data models and ro
Diana Diana
?
database-model group presentation.pptx
database-model group presentation.pptx
RuksanKarki
?
WEB_DATABASE_chapter_4.pptx
WEB_DATABASE_chapter_4.pptx
Koteswari Kasireddy
?
Database systems introduction
Database systems introduction
Balasingham Karthiban
?
Dbms Lec Uog 02
Dbms Lec Uog 02
smelltulip
?
Database System Concepts AND architecture [Autosaved].pptx
Database System Concepts AND architecture [Autosaved].pptx
Koteswari Kasireddy
?
DBMS-Unit-1.pptx
DBMS-Unit-1.pptx
Bhavya304221
?
Basic SQL for Bcom Business Analytics.pptx
Basic SQL for Bcom Business Analytics.pptx
sjcdsdocs
?
Database
Database
Respa Peter
?
DATABASE MANAGEMENT SYSTEM-MRS. LAXMI B PANDYA FOR 25TH AUGUST,2022.pptx
DATABASE MANAGEMENT SYSTEM-MRS. LAXMI B PANDYA FOR 25TH AUGUST,2022.pptx
Laxmi Pandya
?
Dbms database models
Dbms database models
sanjeev kumar suman
?
Data Models in Database Managment System
Data Models in Database Managment System
tehzeebwzr
?
Whitepaper sones GraphDB (eng)
Whitepaper sones GraphDB (eng)
sones GmbH
?
Data models
Data models
Thakshayini Chandramohan
?
Database Concepts & SQL(1).pdf
Database Concepts & SQL(1).pdf
rsujeet169
?
Comprehensive Guide to Effective Data Model Principles
Comprehensive Guide to Effective Data Model Principles
EliasZerabruk
?
Measurecamp Copenhagen - Consent Context
Measurecamp Copenhagen - Consent Context
Human37
?
THE LINEAR REGRESSION MODEL: AN OVERVIEW
THE LINEAR REGRESSION MODEL: AN OVERVIEW
Ameya Patekar
?

More Related Content

Similar to Lecture 2-DATABASE MODELS lecture 2.pptx (20)

Data models
Data models
Hira Bukhari
?
Data models
Data models
Hira Bukhari
?
Databases and its representation
Databases and its representation
Ruhull
?
Presentation1
Presentation1
Celso Catacutan Jr.
?
Data models and ro
Data models and ro
Diana Diana
?
database-model group presentation.pptx
database-model group presentation.pptx
RuksanKarki
?
WEB_DATABASE_chapter_4.pptx
WEB_DATABASE_chapter_4.pptx
Koteswari Kasireddy
?
Database systems introduction
Database systems introduction
Balasingham Karthiban
?
Dbms Lec Uog 02
Dbms Lec Uog 02
smelltulip
?
Database System Concepts AND architecture [Autosaved].pptx
Database System Concepts AND architecture [Autosaved].pptx
Koteswari Kasireddy
?
DBMS-Unit-1.pptx
DBMS-Unit-1.pptx
Bhavya304221
?
Basic SQL for Bcom Business Analytics.pptx
Basic SQL for Bcom Business Analytics.pptx
sjcdsdocs
?
Database
Database
Respa Peter
?
DATABASE MANAGEMENT SYSTEM-MRS. LAXMI B PANDYA FOR 25TH AUGUST,2022.pptx
DATABASE MANAGEMENT SYSTEM-MRS. LAXMI B PANDYA FOR 25TH AUGUST,2022.pptx
Laxmi Pandya
?
Dbms database models
Dbms database models
sanjeev kumar suman
?
Data Models in Database Managment System
Data Models in Database Managment System
tehzeebwzr
?
Whitepaper sones GraphDB (eng)
Whitepaper sones GraphDB (eng)
sones GmbH
?
Data models
Data models
Thakshayini Chandramohan
?
Database Concepts & SQL(1).pdf
Database Concepts & SQL(1).pdf
rsujeet169
?
Comprehensive Guide to Effective Data Model Principles
Comprehensive Guide to Effective Data Model Principles
EliasZerabruk
?
Databases and its representation
Databases and its representation
Ruhull
?
database-model group presentation.pptx
database-model group presentation.pptx
RuksanKarki
?
Database System Concepts AND architecture [Autosaved].pptx
Database System Concepts AND architecture [Autosaved].pptx
Koteswari Kasireddy
?
Basic SQL for Bcom Business Analytics.pptx
Basic SQL for Bcom Business Analytics.pptx
sjcdsdocs
?
DATABASE MANAGEMENT SYSTEM-MRS. LAXMI B PANDYA FOR 25TH AUGUST,2022.pptx
DATABASE MANAGEMENT SYSTEM-MRS. LAXMI B PANDYA FOR 25TH AUGUST,2022.pptx
Laxmi Pandya
?
Data Models in Database Managment System
Data Models in Database Managment System
tehzeebwzr
?
Whitepaper sones GraphDB (eng)
Whitepaper sones GraphDB (eng)
sones GmbH
?
Database Concepts & SQL(1).pdf
Database Concepts & SQL(1).pdf
rsujeet169
?
Comprehensive Guide to Effective Data Model Principles
Comprehensive Guide to Effective Data Model Principles
EliasZerabruk
?

Recently uploaded (20)

Measurecamp Copenhagen - Consent Context
Measurecamp Copenhagen - Consent Context
Human37
?
THE LINEAR REGRESSION MODEL: AN OVERVIEW
THE LINEAR REGRESSION MODEL: AN OVERVIEW
Ameya Patekar
?
Top network design for infrastructure for it
Top network design for infrastructure for it
GUESH8
?
最新版美国加利福尼亚大学旧金山法学院毕业证(鲍颁尝补飞厂贵毕业证书)定制
最新版美国加利福尼亚大学旧金山法学院毕业证(鲍颁尝补飞厂贵毕业证书)定制
taqyea
?
Prescriptive Process Monitoring Under Uncertainty and Resource Constraints: A...
Prescriptive Process Monitoring Under Uncertainty and Resource Constraints: A...
Mahmoud Shoush
?
SUNSSE Engineering Introduction 2021.pdf
SUNSSE Engineering Introduction 2021.pdf
Ongkino
?
25 items quiz for practical research 1 in grade 11
25 items quiz for practical research 1 in grade 11
leamaydayaganon81
?
最新版美国史蒂文斯理工学院毕业证(厂滨罢毕业证书)原版定制
最新版美国史蒂文斯理工学院毕业证(厂滨罢毕业证书)原版定制
Taqyea
?
Residential Zone 4 for industrial village
Residential Zone 4 for industrial village
MdYasinArafat13
?
@Reset-Password.pptx presentakh;kenvtion
@Reset-Password.pptx presentakh;kenvtion
MarkLariosa1
?
Pause Travail 22 Hostiou Girard 12 juin 2025.pdf
Pause Travail 22 Hostiou Girard 12 juin 2025.pdf
Institut de l'Elevage - Idele
?
Untitled presentation xcvxcvxcvxcvx.pptx
Untitled presentation xcvxcvxcvxcvx.pptx
jonathan4241
?
QUALITATIVE EXPLANATORY VARIABLES REGRESSION MODELS
QUALITATIVE EXPLANATORY VARIABLES REGRESSION MODELS
Ameya Patekar
?
Boost Business Efficiency with Professional Data Entry Services
Boost Business Efficiency with Professional Data Entry Services
eloiacs eloiacs
?
lecture12.pdf Introduction to bioinformatics
lecture12.pdf Introduction to bioinformatics
SergeyTsygankov6
?
定制翱颁础顿学生卡加拿大安大略艺术与设计大学成绩单范本,翱颁础顿成绩单复刻
定制翱颁础顿学生卡加拿大安大略艺术与设计大学成绩单范本,翱颁础顿成绩单复刻
taqyed
?
最新版美国佐治亚大学毕业证(鲍骋础毕业证书)原版定制
最新版美国佐治亚大学毕业证(鲍骋础毕业证书)原版定制
Taqyea
?
Advanced_English_Pronunciation_in_Use.pdf
Advanced_English_Pronunciation_in_Use.pdf
leogoemmanguyenthao
?
英国毕业证范本利物浦约翰摩尔斯大学成绩单底纹防伪尝闯惭鲍学生证办理学历认证
英国毕业证范本利物浦约翰摩尔斯大学成绩单底纹防伪尝闯惭鲍学生证办理学历认证
taqyed
?
Data-Driven-Operational--Excellence.pptx
Data-Driven-Operational--Excellence.pptx
NiwanthaThilanjanaGa
?
Measurecamp Copenhagen - Consent Context
Measurecamp Copenhagen - Consent Context
Human37
?
THE LINEAR REGRESSION MODEL: AN OVERVIEW
THE LINEAR REGRESSION MODEL: AN OVERVIEW
Ameya Patekar
?
Top network design for infrastructure for it
Top network design for infrastructure for it
GUESH8
?
最新版美国加利福尼亚大学旧金山法学院毕业证(鲍颁尝补飞厂贵毕业证书)定制
最新版美国加利福尼亚大学旧金山法学院毕业证(鲍颁尝补飞厂贵毕业证书)定制
taqyea
?
Prescriptive Process Monitoring Under Uncertainty and Resource Constraints: A...
Prescriptive Process Monitoring Under Uncertainty and Resource Constraints: A...
Mahmoud Shoush
?
SUNSSE Engineering Introduction 2021.pdf
SUNSSE Engineering Introduction 2021.pdf
Ongkino
?
25 items quiz for practical research 1 in grade 11
25 items quiz for practical research 1 in grade 11
leamaydayaganon81
?
最新版美国史蒂文斯理工学院毕业证(厂滨罢毕业证书)原版定制
最新版美国史蒂文斯理工学院毕业证(厂滨罢毕业证书)原版定制
Taqyea
?
Residential Zone 4 for industrial village
Residential Zone 4 for industrial village
MdYasinArafat13
?
@Reset-Password.pptx presentakh;kenvtion
@Reset-Password.pptx presentakh;kenvtion
MarkLariosa1
?
Untitled presentation xcvxcvxcvxcvx.pptx
Untitled presentation xcvxcvxcvxcvx.pptx
jonathan4241
?
QUALITATIVE EXPLANATORY VARIABLES REGRESSION MODELS
QUALITATIVE EXPLANATORY VARIABLES REGRESSION MODELS
Ameya Patekar
?
Boost Business Efficiency with Professional Data Entry Services
Boost Business Efficiency with Professional Data Entry Services
eloiacs eloiacs
?
lecture12.pdf Introduction to bioinformatics
lecture12.pdf Introduction to bioinformatics
SergeyTsygankov6
?
定制翱颁础顿学生卡加拿大安大略艺术与设计大学成绩单范本,翱颁础顿成绩单复刻
定制翱颁础顿学生卡加拿大安大略艺术与设计大学成绩单范本,翱颁础顿成绩单复刻
taqyed
?
最新版美国佐治亚大学毕业证(鲍骋础毕业证书)原版定制
最新版美国佐治亚大学毕业证(鲍骋础毕业证书)原版定制
Taqyea
?
Advanced_English_Pronunciation_in_Use.pdf
Advanced_English_Pronunciation_in_Use.pdf
leogoemmanguyenthao
?
英国毕业证范本利物浦约翰摩尔斯大学成绩单底纹防伪尝闯惭鲍学生证办理学历认证
英国毕业证范本利物浦约翰摩尔斯大学成绩单底纹防伪尝闯惭鲍学生证办理学历认证
taqyed
?
Data-Driven-Operational--Excellence.pptx
Data-Driven-Operational--Excellence.pptx
NiwanthaThilanjanaGa
?
Ad

Lecture 2-DATABASE MODELS lecture 2.pptx

  • 2. A database model shows the logical structure of a database, including the relationships and constraints that determine how data can be stored and accessed. Individual database models are designed based on the rules and concepts of whichever broader data model the designers adopt. Most data models can be represented by an accompanying database diagram.
  • 3. Types of Database Models 1. Hierarchical database model 2. Relational model 3. Network model 4. Object-oriented database model 5. Entity-relationship model 6. Document model 7. Entity-attribute-value model 8. Star schema 9. The object-relational model, which combines the two that make up its name
  • 4. Relational Model ? The most common model, the relational model sorts data into tables, also known as relations, each of which consists of columns and rows. Each column lists an attribute of the entity in question, such as price, zip code, or birth date. Together, the attributes in a relation are called a domain. A particular attribute or combination of attributes is chosen as a primary key that can be referred to in other tables, when it’s called a foreign key.
  • 6. Hierarchical Model The hierarchical model organizes data into a tree-like structure, where each record has a single parent or root. Sibling records are sorted in a particular order. That order is used as the physical order for storing the database. This model is good for describing many real-world relationships.
  • 8. Network Model The network model builds on the hierarchical model by allowing many-to-many relationships between linked records, implying multiple parent records. Based on mathematical set theory, the model is constructed with sets of related records. Each set consists of one owner or parent record and one or more member or child records. A record can be a member or child in multiple sets, allowing this model to convey complex relationships.
  • 10. Object Oriented Model This model defines a database as a collection of objects, or reusable software elements, with associated features and methods. There are several kinds of object-oriented databases:
  • 12. A multimedia database incorporates media, such as images, that could not be stored in a relational database. A hypertext database allows any object to link to any other object. It’s useful for organizing lots of disparate data, but it’s not ideal for numerical analysis. The object-oriented database model is the best known post- relational database model, since it incorporates tables, but isn’t limited to tables. Such models are also known as hybrid database models.
  • 13. Object Relational Model This hybrid database model combines the simplicity of the relational model with some of the advanced functionality of the object-oriented database model. In essence, it allows designers to incorporate objects into the familiar table structure.
  • 15. Languages and call interfaces include SQL3, vendor languages, ODBC, JDBC, and proprietary call interfaces that are extensions of the languages and interfaces used by the relational model.
  • 16. Inverted File Model A database built with the inverted file structure is designed to facilitate fast full text searches. In this model, data content is indexed as a series of keys in a lookup table, with the values pointing to the location of the associated files. This structure can provide nearly instantaneous reporting in big data and analytics, for instance.
  • 18. This model has been used by the ADABAS database management system of Software AG since 1970, and it is still supported today.
  • 19. Flat Model ?The flat model is the earliest, simplest data model. It simply lists all the data in a single table, consisting of columns and rows. In order to access or manipulate the data, the computer has to read the entire flat file into memory, which makes this model inefficient for all but the smallest data sets.
  • 21. END