DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. Database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of inter-related data and set of programs to store & access those data in an easy and effective manner.
What is the need of DBMS?
What is the need of DBMS?
Database systems are basically developed for large amount of data. When dealing with huge amount of data, there are two things that require optimization: Storage of data and retrieval of data.
Storage: According to the principles of database systems, the data is stored in such a way that it acquires lot less space as the redundant data (duplicate data) has been removed before storage. Let’s take a layman example to understand this:
In a banking system, suppose a customer is having two accounts, one is saving account and another is salary account. Let’s say bank stores saving account data at one place (these places are called tables we will learn them later) and salary account data at another place, in that case if the customer information such as customer name, address etc. are stored at both places then this is just a wastage of storage (redundancy/ duplication of data), to organize the data in a better way the information should be stored at one place and both the accounts should be linked to that information somehow. The same thing we achieve in DBMS.
In a banking system, suppose a customer is having two accounts, one is saving account and another is salary account. Let’s say bank stores saving account data at one place (these places are called tables we will learn them later) and salary account data at another place, in that case if the customer information such as customer name, address etc. are stored at both places then this is just a wastage of storage (redundancy/ duplication of data), to organize the data in a better way the information should be stored at one place and both the accounts should be linked to that information somehow. The same thing we achieve in DBMS.
Fast Retrieval of data: Along with storing the data in an optimized and systematic manner, it is also important that we retrieve the data quickly when needed. Database systems ensure that the data is retrieved as quickly as possible.
Some Type Of DBMS
Some of the database management system are :
1) Microsoft Access : This is the database management system developed by Microsoft. It stores data in its own format based on the Access Jet Database Engine. It also has the facilities like importing or linking directly to data stored in other databases and applications.
2) MySQL : MySQL is open source database management system, one of the most popular dbms on the web. It is reliable, fast and also flexible.
3) Oracle : Developed by Oracle corporation. It is object relational database management system. The original version of Oracle software was developed by Software Development Laboratories (SDL). Oracle is regarded to be one of the safe DBMS.
4) Microsoft SQL Server : Microsoft developed this relational database server. The primary function of this software is to store and retrieve the data as requested by other applications, whether those applications are on the same computer or running on other computers across the network (including internet).
5) Filemaker : Filemaker began as a MS-DOS based computer program named nutshell. It is a cross platform relational database management system developed by Filemaker Inc. It is one of the most widely used database platform for both windows and mac.
Advertisements