DBMS and it's advantages and disadvantage

 

Database Management System

Data: 

Data are the collection of raw facts and figure which are unorganized, uninterpreted, and isolated, which doesn’t give any particular sense. They are randomly gathered. So that they can be processed to obtain the desired result. Ram, 17, Pokhara, 18

Information:

Information are the processed form of data. Information gives a meaning full result after data are interpreted. Ram 17 year old and lives in Pokhara 18.

As we know, very organization from the prehistoric time deals with data and information. Data are very necessary for organization to operate. In previous time, data used to be collected randomly and were not organized in any particular order which leads to following drawbacks.

Some information was stored in more than one file. (Data redundancy).

• Difficult to present data from the user’s view.
• Data security was one of the major problem.
• Data processing and manipulation were difficult.
• Data retrieval were very slow.

Hence, concept of database arise in order to overcome the above drawbacks or limitations. Database is collection of interrelated data or entities stored in tabular form. It gives very useful information for an organization during data manipulation and decision making. It provides a base for foundation for managing large volume of data in a well organized manner. Simply database is a systematic and organized form of data so that user can retrieve or access data whenever required within no time. For eg, telephone directory, dictionary, marks ledger, customer records etc. 

File processing

In a file processing system, data needed for each user application was stored in independent data files. File processing consisted of using separate computer program s that independent data files.

Some problems are:

1. Data duplication:
2. Data Dependence
3. Lack of data integration

DBMS (Database Management System) 

DBMS is a software which is used to store the data, process them and provide the useful information to the user. DBMS is a computerized record keeping system. It is a software that defines, manipulates and manage the database. It allows to access the file, update the record and retrieve data as requested. In other word, DBMS is defined as the collection of interrelated data and set of programs to access their data. The collection of data is usually a database which contains the information about any particular organization. The primary goal of DBMS is to provide an effective and efficient environment for both data retrieval and storing data in database. For example, MS Access, Oracle, MY SQL, Fox-Pro, D-base etc.

 Advantages of DBMS

 1.Sharing data: Using DBMS, data stored in database can be shared among multiple users or computer. For example, branches of bank share data from database. 

2. Reduce data redundancy: Data redundancy refer to duplication or repetition of same data over and over. DBMS reduces such type of unnecessary repetition of data. 

3.Data backup and recovery: Using DBMS, we can easily create spare copy of original files and documents that can be later used in case of accidental or intentional loss and damages. 

4) Data security: Using DBMS we can restrict use of database to the unauthorized person. It helps to ensure date security. 

5. Multiple user interface: DBMS facilitates sharing of data which means same data can be accessed from multiple device and location. Hence, user can experience multiple interface to access same set of data. 

6.Data Integrity: Data Integrity refers to consistency of data. Using database we can arrange same sort of data in a like order. We can define and enforce constraints for data integrity.

 Disadvantages of DBMS 

1) Expensive: It may be expensive to run and operate DBMS for any organization. 

2) Changing Technology: It is very much difficult to incorporate latest changing technology in existing system. In order to create and maintain database technical manpower and trainings are required.

3) Backup is needed: Since data maybe damage anytime accidentally or intentionally. So, it is mandatory to create a backup. 

Author Spotlight

Santosh Chapagain
Gmail: chapagainsantoshcs@gmail.com
Phone no: +977-9863512955