Skip to main content

DBMS Database Management System

DBMS Database Management System

DBMS Database Management SystemDefinition of DBMS Database Management System - A Database Management System (DBMS) is a collection of Programs that enable user to store, modify, and extract data or information from a large or small database. The data base management systems are used in small personal computers to huge mainframe computers. DBMS is an intermediate layer between programs and the data. Programs access the DBMS, which then accesses the data. A database management system is a piece of software/ program that enable you to accessing a database, while maintaining all the essential features of the data. The Commercially available DBMS in the market are dbase, MySQL, SQL Servers, FoxPro, IMS and Oracle and DB2 etc.

Some of the important examples of DBMS applications are

  1. Computerized library systems

  2. Flight reservation systems

  3. Computerised inventory machines

  4. Automated teller machines

  5. Railway reservation systems

Major Components involved in DBMS Environment

There are five major components which forms Database Management Systems environment. They are Hardware, Software, Data, Users and Procedures.

Hardware is used for keeping and accessing the database like Secondary Storage Device – Hard disks.

Software also called as DBMS Program which exhibits presence between hardware and users. The DBMS allows the users to communicate with their database. Or say it acts as the mediator between user and database. The DBMS is responsible for accessing and maintaining consistency of the data during operation.

The data involve the operational data, Meta data and data about data.

Users are the person who access data in different ways depending upon their access rights. There are no of users who can access or retrieve data on demand using the applications and interface provided by the DBMS. The different types of users are separated in terms of expertise, use and authorization. The different types of users are –

What are the different types of User in DBMS?

  1. Naïve Users – The naïve users are the end users who are not aware of the presence of the database system and work through a menu driven application program. The user using Automatic Teller Machine (ATM) for withdrawal of money fall under this category.

  2. Online Users – The users who access database through online terminal, user interface or via application program. These type of user know the presence of database system and have certain knowledge about database.

  3. Sophisticated Users – The users who interact with the database without writing any programs.

  4. Specialized Users – Those who write specialized database application that do not fit into the fractional data-processing framework. For example: Computer-aided design systems, knowledge base and expert system, etc.

  5. Database Administrator - The database administrator (DBA) is a person or group of person who implements the database system of an organization. The DBA has all the system privileges and rights which is allowed by the DBMS and can grant, remove levels of access to or from other users. DBA is responsible for the evaluation, selection and implementation of DBMS applications. DBMS Database Management System is a important concept involved during storing any data in computer hard drive. 

Popular posts from this blog

Fix Windows could not find a driver for your network adapter error

Fix Windows could not find a driver for your network adapter error

A Computer run smoothly with the coordination of Software & Hardware. In the absence of any one it will not run at all. Software being the Master utilizes each hardware attached to the System. And each hardware is operated with the help of Device Drivers installed in it. Operating System (OS) uses these device drivers to control & utilize each hardware when needed. Each hardware connected to the system must have their own Device Driver installed. A device driver is a program to initiate a hardware when required by Operating System.

Suppose, you want your PC to connect to the Network, it can only be possible when your PC has network related Device Driver. These Device Drivers are easily downloaded from Manufacturer Websites. In this article we focus on Network related problem. Suppose, your PC not obtaining Network connectivity. And each time you are getting an error message saying "Windows could not find a d…

Fix This Site Can’t Be Loaded from The Cache Chrome Error

Fix This Site Can't Be Loaded from The Cache Chrome Error

This Site Can’t Be Loaded from The Cache - Today, there are several browsers available with extensive features on it. Each browser has its own importance and working principle. Some of the popular browsers available online are Google Chrome, Mozilla Firefox, Opera Mini, Internet Explorer, UC Browser, Safari, Microsoft Edge, Swift fox etc. The popularity of these browsers depends upon the features available in it.

Among them Google Chrome is the newest and mostly used browser around the world. Holding lots of feature make it more complex and hence more prone to errors. The types of error come up with the level of complexity of the program. If you are Chrome user and facing one of such error then read the full article. In this article, we focus on an error saying "This site can't be loaded from the cache". The explanation included with this error will be "The saved (cached) copy of this site was unreadable&qu…

Change Facebook Profile Picture Leaving All Unknown

Change Facebook Profile Picture Leaving All Unknown

Change Facebook Profile Picture Leaving All Unknown - Today, we spend lots of time in Social media platforms such as WhatsApp, Facebook, Instagram, Skype, YouTube, Twitter etc. We love to share Images & Videos with our friends via these platforms. These applications are largely used on Smartphones. We need to download concerned apps from inbuilt software, Play Store in Android Platform.

After downloading the App, we create an ideal account with a profile picture. We join the network by sending friend request. When request is accepted, we are added to such a community. In this article we take a close look on Facebook. Facebook is vastly used all around the world. Two person residing miles away can also share their views easily.

Change Facebook Profile Picture Leaving All Unknown

Whenever we open Facebook, lots of Images & Videos are seen with gentle scroll. In this article we focus on an interesting thing say Profile Picture. In F…