• September 24, 2014
  • SQL
  • Comments Off on Database overview

Database overview

A database is an organized collection of data.

DBMS:

DBMS refers to the Database Management System. It is a set of programs that enables you to store, modify, and retrieve the data from a database.

RDBMS:

RDBMS refers to the Relational Database Management System. It is a database management system that is based on the relational model as introduced by E. F. Codd. All modern database systems like MS SQL Server, Oracle, IBM DB2, MySQL, and Microsoft Access are based on RDBMS.

Difference between DBMS and RDBMS:

                              DBMS                            RDBMS
  1. 1. DBMS does not define any constraints or security to ensure the ACID PROPERTY.
  2. 2. Normalization concept is not present.
  3. 3. In DBMS data is treated as files internally.
  4. 4. DBMS does not support distributed databases.
  5. 5. DBMS supports single user.
  1. 1. RDBMS define the integrity constraint to ensure the ACID PROPERTY.
  2. 2. Normalization concept is present.
  3. 3. In RDBMS data is treated as tables internally.
  4. 4. RDBMS support distributed databases.
  5. 5. RDBMS supports multiple users.

 
Next Topic: SQL Syntax.
Previous Topic: SQL overview.

Related Topics:

How to build java project using ant in eclipse?
JAXB marshalling – convert java object to xml example.
How to create pdf file in java using iText jar?
Generics class example.
OGNL in struts 2.
Hibernate One-to-One Mapping using xml.
Send inline image in email using JavaMail API.
Quartz 2 JobListener example.

 


Comments are closed.