DBMS is a software system that helps users to organize, create and maintain the database easier. As its name implies, the DBMS stands for Database Management System, it is the software that used to manage the database and to help users make a good database. One question arises, without the DBMS, can we still create or set up the database? For sure, the answer is yes you can, yet you have to program everything yourself!!! That is not so fun and takes so much time also. To come across tough work, the DBMS acts as a helper to help users to manipulate the database and all data that will be loaded into the database well. Besides, the means to insert, to update, to modify, to delete and to retrieve data from or into the database are also considered essential functions of database management system. To give you more idea about the DBMS, I would like to introduce you another three things about the DBMS which are the history of the DBMS, what the DBMS is not and both advantages and disadvantages of the DBMS.
The history of the DBMS can be divided into three generations. The first generation was called “Navigational DBMS.” At the beginning of this generation, one approach was introduced by “CODASYL,” which is the group of people responsible for the creation and standardization of COBAL (COBAL is one of the programming languages), and the approach was known as “CODASYL approach.” This approach was based on the “Manual” navigation of a linked data set, which means to find any particular record in the database, the programmer had to step through all records one by one at the time!!! Also, there was no concept of finding or searching in CODASYL approach. Later in 1968, IBM released their own DBMS system called IMS. IMS was generally similar in concept to CODASYL approach, but now IBM added searching feature into IMS, so it was more convenient for users to find where the record is. The second generation of the DBMS was called “Relational DBMS.” In relational approach, related records were linked together with “a key,” this implies that each record must be unique and was identified by its own key. Besides, in this approach, it allowed users to do normalization, which is a technique for organizing data into tables in such a way that redundancy attribute and related attribute are separated so that inconsistence record and duplicated record are to be removed. At the end of 1970s, IBM introduced the third generation of the DBMS which was called “SQL DBMS,” which stands for structure query language. The concept of SQL DBMS is programming-based, that means you need to insert some commands in terms of coding prior to getting access to the database. In addition, this approach became very popular and widely used until today.
Next, to get rid of some confusion about the DBMS, I will tell you what the DBMS is not!!! Most people might think that the DBMS is a database, but in fact it is not!!! Actually, the DBMS itself is absolutely not similar to the database, we do not uses the DBMS to store, to collect or to gather data. Likewise, the DBMS does not refer to a system catalog that provides the description of the data. The misunderstanding of the DBMS is that some people think that it acts as a center place where a lot of data are kept together. Although before data are accessed to the database, they firstly have to pass through the DBMS, yet the DBMS is not captured or stored in any of those passing data. Indeed, the DBMS is not like the database, which is a large repository where plenty of data are resided inside. Furthermore, the tasks to store names, types, name of relationships of sizes of data items are not functions of the DBMS at all. Additionally, the DBMS does not involve activities like keeping the history of data or recording the status of data. All of those things are not the DBMS, so now I think from those details of what the DBMS is not can make you have better and clearer understanding about the DBMS.
Finally, like all software systems, the DBMS has both advantages and disadvantages. For its benefits, the first one is that the DBMS helps users to control data redundancy. That means some duplicated data are to be removed by the DBMS. Although those duplicated data are not entirely eliminated, the amounts of redundancy data are to be controlled. Secondly, the result of the ability to control data redundancy of the DBMS leads to data consistency. Data consistency refers to a data item which is stored only once in the database, any updated to its value has to be performed only once!!! The third advantage of the DBMS is the improvement of security. The meaning of improved security is to protect the database from unauthorized users, which are the one who have no right to access to the database. The last advantage of the DBMS that I would like to share to you is the increased of concurrency. Many people might not be so familiar with the word concurrency which is the synonym of simultaneous. In addition, increased concurrency implies that two or more users are allowed to access the same file at the same time although the accesses may interfere with each other, yet the DBMS can handle this problem. As you can see, the DBMS has many good points!!! On the other hand, it also has some minor points too!!! One minor point is its complexity. The term complexity implies that the structure of the DBMS is somehow quite hard to understand, and failure to understand can lead to bad design decision. Another minor point of the DBMS is its cost. The cost of the DBMS quite varies depending on the environment and functionality. In other word, the DBMS’s cost is not the same for all application. The other minor point is its performance. The DBMS is written to be too general to provide for many applications. In simple words, some applications may not run as fast as they used to. Even though the DBMS has some bad points, it is still applicable and most people prefer to use it.
In conclusion, the DBMS can help users a lot on managing the database. Moreover, it comes to make things easier for users to control their database. The DBMS acts as middle software which resides between computer programs and databases, and also the DBMS interacts with the users’ application program and the database at the same time. Without the DBMS, either programmer or the one who implemented the database will have much more work to do to arrange data not only when inserting data into the database but also when retrieving data out from the database. So now, if you still have no database management system to be your assistant, then go get it!!!