Tutorials Interview Compiler
Advertisement
Home Python Java JavaScript HTML SQL PHP C# C++ DS
← prev next →
DBMS Tutorial
Advertisement
DBMS Tutorial
Lodha Riservo Vikhroli
What is Database
Types of Databases Data Models Lodha Riservo
What is RDBMS Data Model is the modeling of the data description, data
semantics, and consistency constraints of the data. It provides the
DBMS vs RDBMS
conceptual tools for describing the design of a database at each
DBMS vs File System level of data abstraction. Therefore, there are following four data
DBMS Architecture models used for understanding the structure of the database:
Three schema Architecture
Data Models
Learn more
Data model schema
Data Independence
DBMS Language
ACID Properties in DBMS
1) Relational Data Model: This type of model designs the data in
Data modeling
the form of rows and columns within a table. Thus, a relational
model uses tables for representing data and in-between
Relational data Model relationships. Tables are also called relations. This model was
initially described by Edgar F. Codd, in 1969. The relational data
model is the widely used model which is primarily used by
Normalization
commercial data processing applications.
Transaction 2) Entity-Relationship Data Model: An ER model is the logical
representation of data as objects and relationships among them.
These objects are known as entities, and relationship is an
association among these entities. This model was designed by
Peter Chen and published in 1976 papers. It was widely used in
database designing. A set of attributes describe the entities. For
example, student_name, student_id describes the 'student' entity.
A set of the same type of entities is known as an 'Entity set', and
the set of the same type of relationships is known as 'relationship
set'.
3) Object-based Data Model: An extension of the ER model with
notions of functions, encapsulation, and object identity, as well.
This model supports a rich type system that includes structured
and collection types. Thus, in 1980s, various database systems
:
following the object-oriented approach were developed. Here, the
objects are nothing but the data carrying its properties.
ADVERTISEMENT
4) Semistructured Data Model: This type of data model is
different from the other three data models (explained above). The
semistructured data model allows the data specifications at places
where the individual data items of the same type may have
different attributes sets. The Extensible Markup Language, also
known as XML, is widely used for representing the semistructured
data. Although XML was initially designed for including the
markup information to the text document, it gains importance
because of its application in the exchange of data.
Next Topic Data model Schema and Instance
← prev next →
Advertisement
:
:
:
:
:
Latest Courses
:
