What is Data Model?

Definition:

A data model is a description of the organization of data in a database. It also describes the relationship among data and any constraints that have to be defined on the data.

Data models can be broadly be classified into two categories:

• Object-based logical model

          It focuses on describing the data, the relationship among the data, and any constraints defined.

• Record-base logical model

          It focuses on describing the data structure and the access techniques in a Database Management System.

What is Database Management system (DBMS)?

Definition 1:

A database management system (DBMS) is a software used to store and manage data. A DBMS stores data in databases and uses data models to describe the various ways of organizing data.

Definition 2:

Database Management System  is the task of maintaining databases so that information is readily available.

DBMS's are designed to maintain large volumes of data.Management of data involves:

• Defining structures of data storage.
• Providing mechanisms for data manipulation such as adding, editing, and deleting data.
• Providing data security against unauthorized access.

What is a Database?

Definition:

A database is a collection of logically related information.


Following are the top 10 database engines using by companies around the globe:

• Oracle
• MySQL
• Microsoft SQL Server
• PostgreSQL
• DB2
• MongoDB
• Microsoft Access
• SQLite
• Sybase
• Teradata

What is Relational Database Management System (RDBMS)?

Definition:

A relational database management system (RDBMS) is an advanced version of DBMS that also defines the relationship between the various data values. It helps in organizing and accessing data more efficiently than DBMS.