Scribd
Upload
3 views3 pages

Data Model

Data models describe the structured organization of data within databases, focusing on elements like associations and entities. Various types of data modeling include flat, hierarchical, network, relational, object-relational, and star schemas, each with distinct structures and purposes. These models facilitate the management and storage of data in relational databases, while unstructured data types are not covered.

Uploaded by

pk4hvgchgf
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views3 pages

Data Model

Data models describe the structured organization of data within databases, focusing on elements like associations and entities. Various types of data modeling include flat, hierarchical, network, relational, object-relational, and star schemas, each with distinct structures and purposes. These models facilitate the management and storage of data in relational databases, while unstructured data types are not covered.

Uploaded by

pk4hvgchgf
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

DATA MODEL

Data Models describe structured data for storage


in data management system such as relational databases.
They do not describe unstructured data such as word
processing documents, email messages, pictures, digital
audio and video.

The term “data model” refers to the way data is organized, documented, and
defined within a database. The data model definition also describes the
elements used to standardize the system, such as associations, entities and
requirements.

TYPES OF DATA MODELLING

Flat Model: The flat Model (or Table) model consists of a


single, two-dimensional array of data elements, where all
members of a given column are assumed to be similar in
values, and all member of row are assumed to be related to
one another.

Flat Model

Rout Mile Activitie


e No. s s

RECOR 1–
12 Overlay
D1 95

RECOR 1- Parchin
05
D2 495 g

RECOR SR – Crack
33
D3 301 Seal
HIERARCHICAL MODEL

In a hierarchical database, data is organized into an upside-


down tree-like structure, implying a single upward link in
each record to describe the nesting, and a sort field to keep
the records in a particular order in each same-level list.
Hierarchical structures were widely used in the early
mainframe database management systems.
Network Model:

This model organizes data using two fundamental construct,


called records and sets. Records contain fields, and sets
define one-to-many relationships between records: one
owner, many members.

Relational Model

The relational model or relational data base model is based


on first-order predicate logic. Its core idea is to describe a
database as a collection of predicates over a finite set of
predicate variables, describing constraints on the possible
values and combinations of values.
Object-Relational Model

The object relational model is similar to relational database


model, but objects, classes and inheritance are directly
supported in database schemas and in the query language.
An object-relational database can be said to provide a
middle ground between relational databases and object-
oriented databases (OODBMS)

Star Schema

The star schema is the simplest style of data warehouse


schema. The star schema consists of a few “fact table”
(possibly only one, justifying the name) referencing any
number of dimension tables”. The star schema is considered
an important special case of the snowflake schema.

You might also like