DBMS: Commonly heard term by IT and business students. Main concern is what database really is? Today, we’re going to learn about DBMS. To understand the term DBMS we have to understand how DBMS is formed. The term DBMS stands for Database management System. Let’s separate DBMS into possible pieces. Database, Management and System are the core terms to understand DBMS.
Let’s talk about Database. Database is also the combined term which includes Data & Information. Data is a collection of raw form of facts and figures, unarranged, unorganized unrelated. For eg: L, E, N, I, A are four alphabets, they only mean alphabets only; a single L means character only without any meaning. Now the term information is so much related to the word Data because, information is the advanced and collective form of data. For eg: characters L, E, N, I, A when arranged it gives the word ALIEN, which has a meaning with it. Therefore, scattered pieces of information is data, arranged and collective form of data is information.
After you’ve understood the terms Data and Information, now it’s time to understand about database. Database can be defined simply as, related form of information. In other words, A database is a collection of interrelated data of certain place or things in such a way that it can be easily accessed by programs like DBMS.
Properties of Databse:
- A Database represents some aspects of the real world.
- A Database is a collection of related data with some meaning.
- Database is designed, built and populated with data for a specific purpose.
Now it’s time to actually know about DBMS in reference to above information. A DBMS is a set of programs that manages the database files. The DBMS allows accessing the files, updating the records, and retrieving data as requested. The DBMS acts as an interface between the application program and the data in the database. Example: Microsoft Access, Oracle, MySQL, SQL Server, dBase, DoxPro.
Objectives of DBMS:
- To provide storage area for mass amount of relevant data.
- to make access to the data easy for the end-user.
- To provide prompt response to users request for data.
- To make the latest modification to the database available immediately.
- To eliminate data redundancy. ( Duplication of data )
- To allow multiple users to be active at one time.
Advantages of DBMS:
- Facilitates data sharing.
- Reduced data redundancy.
- Integrity can be maintained.
- Data Independence.
- Availability of data.
- Enforced standards.
- Improved security.
- Inconsistency can be avoided.
- Provides multiple user interface.
- Concurrent access of data.
Disadvantages of DBMS:
- Initial investment is high for implementing DBMS.
- Proper training is required for staffs.
- Fault in one part of database can affect other parts too.
- It is complex to understand.
- Overhead cost for providing security, recovery, and integrity functions.
Thank You for visiting us.
Visit again for daily updates and more tech related information.
You May Also Like: