Scribd
Upload
24 views3 pages

Types of Data Models in DBMS

Data modeling is used to abstractly represent entities and relationships in a database. There are several common types of data models: 1. Conceptual models show how users view data. Physical models describe how data is stored. Representational models bridge these views. 2. Relational models use tables related through keys. This simplifies data representation and manipulation. 3. Network models link records through pointers, allowing arbitrary relationships. 4. Hierarchical models organize data in tree structures, naturally representing one-to-many relationships. 5. Object-oriented and object-relational models incorporate object-oriented concepts into databases.

Uploaded by

mekuriaw
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
24 views3 pages

Types of Data Models in DBMS

Data modeling is used to abstractly represent entities and relationships in a database. There are several common types of data models: 1. Conceptual models show how users view data. Physical models describe how data is stored. Representational models bridge these views. 2. Relational models use tables related through keys. This simplifies data representation and manipulation. 3. Network models link records through pointers, allowing arbitrary relationships. 4. Hierarchical models organize data in tree structures, naturally representing one-to-many relationships. 5. Object-oriented and object-relational models incorporate object-oriented concepts into databases.

Uploaded by

mekuriaw
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

A model is an abstraction process that hides superfluous details. Data modeling is used for
representing entities of interest and their relationship in the database. Data model is a collection of
concepts that can be used to describe the structure of a database which provides the necessary
means to achieve the abstraction. The structure of a database means that holds the data.
Types of Data Models
1. High Level- Conceptual data model.
2. Low Level – Physical data model.
3. Relational or Representational
4. Object-oriented Data Models:
5. Object-Relational Models:
1. High Level-conceptual data model: User level data model is the high level or conceptual
model. This provides concepts that are close to the way that many users perceive data.
2. Low level-Physical data model: Provides concepts that describe the details of how
data is stored in the computer model. Low level data model is only for Computer specialists
not for end-user.
3. Representation data model: It is between High level & Low-level data model
Which provides concepts that may be understood by end-user but that are not too
far removed from the way data is organized by within the computer.
The most common data models are
1. Relational Model
The Relational Model uses a collection of tables both data and the relationship among those data.
Each table have multiple column and each column has a unique name.
For example: Relational database comprising of two tables
Customer –Table.
Customer-Name Security Number Address City Account Number
Preethi 111-222-3456 Yelhanka Bangalore A-101
Sharan 111-222-3457 Hebbal Bangalore A-125
Preethi 112-123-9878 Jaynagar Bangalore A-456
Arun 123-987-9909 MG road Bangalore A-987
Preethi 111-222-3456 Yelhanka Bangalore A-111
Rocky 222-232-0987 Sanjay Nagar Bangalore A-111
Account –Table
Account-Number Balance
A-101 1000.00
A-125 1200.00
A-456 5000.00
A-987 1234.00
A-111 3000.00
Customer Preethi and Rocky share the same account number A-111
Advantages
The main advantages of relational data model are
1. The main advantage of this model is its ability to represent data in a simplified format.
2. The process of manipulating record is simplified with the use of certain key attributes used
to retrieve data.
3. Representation of different types of relationship is possible with this model.
2. Network Model
The data in the network model are represented by collection of records and relationships among
data are represented by links, which can be viewed as pointers.
For example:

Preethi 111-222-3456 yelhanka Bangalore

A-101 1000.00

A-111 3000.00
The records in the database are organized as collection of arbitrary groups.
Advantages:
1. Representation of relationship between entities is implemented using pointers which allows
the representation of arbitrary relationship
2. Unlike the hierarchical model it is easy.
3. Data manipulation can be done easily with this model.
3. Hierarchical Model
A hierarchical data model is a data model which the data is organized into a tree like structure.
The structure allows repeating information using parent/child relationships: each parent can
have many children but each child only has one parent. All attributes of a specific record are
listed under an entity type.
Advantages:

1. The representation of records is done using an ordered tree, which is natural method of
implementation of one–to-many relationships.
2. Proper ordering of the tree results in easier and faster retrieval of records.
3. Allows the use of virtual records. This result in a stable database especially when
modification of the data base is made.
4. Object-oriented Data Models
In the Object-Oriented Data Model, A data model is a logic organization of the real-world
objects (entities), constraints on them, and the relationships among objects. A DB language is
a concrete syntax for a data model. A DB system implements a data model. In this type of data
models several models have been proposed for implementing in a database system. One set
comprises models of persistent O-O Programming Languages such as C++ (e.g., in
OBJECTSTORE or VERSANT), and Smalltalk (e.g., in GEMSTONE). Additionally, systems
like O2, ORION (at MCC – then ITASCA), IRIS (at H.P.- used in Open OODB).
5. Object-Relational Models
Most Recent Trend. Started with Informix Universal Server. Relational systems incorporate
concepts from object databases leading to object relational. Object Database Standard: ODMG-
93, ODMG-version 2.0, ODMG-version 3.0. Exemplified in the latest versions of Oracle-0i,
DB2, and SQL Server and other DBMSs. Standards included in SQL-99 and expected to be
enhanced in future SQL standards.

Common questions

Powered by AI

High-level conceptual models facilitate user understanding by abstracting complex underlying structures into more intuitive and user-friendly representations. These models align more closely with how users naturally perceive and interact with data, enhancing accessibility, communication, and comprehension, making the systems easier to use without requiring deep technical knowledge .

Relational data models offer significant advantages for data manipulation and relationship representation by simplifying the data structure into tables with unique identifiers. This tabular format facilitates straightforward querying, data consistency, and flexibility in representing various relationship types through joins, which aid in the efficient retrieval and manipulation of data .

High-level conceptual data models are designed for users to understand data structures and relationships as they perceive them, focusing on data abstraction and conceptual representation. In contrast, low-level physical data models describe the specifics of how data is stored in computer systems, which are technical and suited more for computer specialists than end-users .

The hierarchical data model ensures efficient data retrieval by organizing data into a tree structure, which inherently supports ordered traversal. This facilitates rapid searching and retrieval due to the predictable structure, where each child node only has a single parent, simplifying data pathways and reducing retrieval time .

The main motivations for shifting to object-relational database systems include the need to handle complex data types and relationships familiar to object-oriented programming within the context of relational databases. This shift supports enhanced modeling capabilities like user-defined types and inheritance, promoting more robust application development and compatibility with existing relational databases, thereby enabling developers to build more sophisticated and scalable systems .

Hierarchical data models are limited by their strict tree structure, which only supports one-to-many relationships, posing challenges in representing more complex linkages. In contrast, network models use pointers to represent many-to-many relationships, overcoming hierarchical constraints by allowing a more flexible and interconnected structure that can depict more complex real-world relationships .

The ODMG (Object Data Management Group) standard significantly impacted the development and interoperability of object databases by providing a consistent framework and language for object interaction and data manipulation. By establishing guidelines and standard formats, ODMG improved the ability to share and manage data across different systems and applications, fostering innovation and adoption in object-oriented database technology .

The object-oriented data model improves the representation of complex relationships by allowing real-world entities to be modeled as objects that include both data and behavior. This approach supports complex data types and relationships inherent to objects, facilitating more natural data modeling for complex applications. While relational data models require multiple tables to represent these relationships, object-oriented models can encapsulate them within objects, decreasing model complexity and improving data integrity and query performance .

Developers might choose an object-relational data model over a purely relational one to leverage the flexibility and re-usability of object-oriented concepts while maintaining compatibility with existing relational databases. This hybrid approach supports complex data types and inheritance, enabling developers to efficiently manage more complex and varied data structures than is possible with a strictly relational model .

Network data models offer several advantages over hierarchical models. They allow for more complex, many-to-many relationships through the use of pointers rather than strictly parent-child hierarchies. This flexibility eases data manipulation without the restrictions of hierarchical models, and despite the increased logical complexity, it can represent more intricate relationships in data .

You might also like