Introduction To Database & DBMS systems

Today I will talk about database and DMBS systems. Lets take a look.

Database

The database is a systematic collection of data. Databases support data storage and manipulation. Databases facilitate data management. Let’s discuss some examples.

A Hospital would use a database to store patient’s name, age, diseases, contacts etc.

Consider also facebook & Instagram. You need to store, manipulate and present data related to members, your friends, member activities, messages, announcements and much more.

We can provide countless examples of database usage.

Database management system (DBMS)

The Database Management System (DBMS) is a collection of programs that allow its users to access the database, manipulate data, inform / represent data.

It also helps control access to the database.

Charles Bachmen’s Integrated Data Store (IDS) is said to be the first DBMS in history.

Over time, database technologies evolved a lot, while the expected use and functionality of databases has increased tremendously.

Types of DBMS

Hierarchical

This type of DBMS uses the “parent-child” data storage relationship. This type of DBMS is rarely used today. Its structure is like a tree with nodes that represent records and branches that represent fields. The Windows registry used in Windows XP is an example of a hierarchical database. Configuration settings are stored as tree structures with nodes.

Network DBMS

This type of DBMS supports many to many relationships. This generally results in complex database structures. RDM Server is an example of a database management system that implements the network model.

Relational DBMS

This type of DBMS defines database relationships in the form of tables, also known as relationships. Unlike network DBMS, RDBMS does not support many to many relationships. Relational DBMSs generally have predefined data types that they can support. This is the most popular type of DBMS in the market. Examples of relational database management systems include MariaDB, Oracle and the Microsoft SQL Server database.

Object-oriented relationship DBMS

this type supports the storage of new types of data. The data to be stored are in the form of objects. The objects that will be stored in the database have attributes (i.e. gender, ager) and methods that define what to do with the data. PostgreSQL is an example of an object-oriented relational DBMS.

Summary

• – DBMS stands for Database Management System.
• – We have four major types of DBMSs namely Hierarchical, Network, Relational, Object Oriented.
• – The most widely used DBMS is the relational model that saves data in table formats. It uses SQL as the standard query language.

I will talk about SQL programming next week.

By Yuuma