DBMS Basics

Data Base Management System:

Data base is nothing but collection of tables.

Table is  collection of rows and columns.

DBMS is the technology of storing and retrieving users’ data with utmost efficiency along with appropriate security measures.

OR

A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

There are four structural types of database management systems:

• Hierarchical databases.
• Network databases.
• Relational databases.
• Object-oriented databases.

Hierarchical Databases (DBMS)

In the Hierarchical Database Model we have to learn about the databases. It is very fast and simple. In a hierarchical database, records contain information about there groups of parent/child relationships, just like as a tree structure. 

Network databases

A network databases are mainly used on a large digital computers. It more connections can be made between different types of data, network databases are considered more efficiency It contains limitations must be considered when we have to use this kind of database. 

Relational databases

Relational databases work on each table has a key field that uniquely indicates each row, and that these key fields can be used to connect one table of data to another.

Object-oriented databases

The object-oriented database derivation is the integrity of object-oriented programming language systems and consistent systems. The power of the object-oriented databases comes from the cyclical treatment of both consistent data, as found in databases, and transient data, as found in executing programs.

Some databases:

Hadoop:
It is an open-source framework that allows to store and process big data in a distributed environment across clusters of computers using simple programming models. It is designed to scale up from single servers to thousands of machines, each offering local computation and storage.


MySQL:

MySQL is the most popular Open Source Relational SQL Database Management System.
MySQL was created by a Swedish company, MySQL AB, founded by David Axmark, Allan Larsson and Michael "Monty" Widenius. Original development of MySQL by Widenius and Axmark began in 1994.

MongoDB:

MongoDB is an open-source document database and leading NoSQL database. MongoDB is written in C++.

SQLite 

it is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. SQLite is the most used database engine in the world. 

1. Thank You So Much................