Introduction

A database management system (DBMS) is a program software that is used to manage and process data more easily, efficiently, and in a more reliable way (Yadav and Kumari, 2016). DBMS or RDBMS are very important today because they are needed to process queries issued by users and manage objects.

Importance of DBMSs

DBMS are used in retrieving information from the database, updating, and managing the database. DBMS provides users with numerous functionalities that cannot be met by the traditional file system. Secondly, database management systems are used to control inconsistencies and redundancies in the database. In order to avoid duplicates and redundancies, DBMS uses data normalization. Thirdly, these systems are used to efficiently manage memory and indexing. That is, it makes management of complex memory partitions easier to handle. DBMS employs the use of database schema to efficiently undertake object indexing depending on any attribute of data-property or data. This is very helpful in retrieving data faster depending on the attribute that is indexed. Fourthly, DBMS are very essential in managing transactions and concurrency control. This facilitates management of several users accessing the database simultaneously. Moreover, it helps implement database access control or ease of access, integrity constraints, and management (Harshika, 2019). Other factors that makes it necessary to have a DBMS include data expansibility, scalability, and flexibility, security, and multiple user interfaces.

DBMS Experience

I have interacted with several such as Microsoft SQL having been introduced in 2017 and have worked with since then. I have operated in both SQL server 2016 and 2014 including MongoDB. Additionally, experience with on-premise databases. I have a developed a culture to keep up with the latest trends in database administration and management and get relevant and broad knowledge on the same. I have also gained knowledge in identifying various issues and problems affecting the database and determining the cause that may cause the problems affecting the database such as data loss. This include identifying if the problem is recurrent or one-time. Some of the technical knowledge that I have gained over time include database backup and restoration, optimizing and implementing Hadoop solutions and maintaining database servers.

Real-World Scenarios

Many companies and organizations are making use of database management systems. Such organizations include Barclays Bank (including other banks) and Alibaba, Amazon amongst other financial and e-commerce institutions. Such institutions utilize database management systems to manage the various transaction (for Barclays Bank and other banking institutions) such as cash deposits, withdrawals, and transfers to ensure that the correct figure/amount is deducted or added, and it should be (no data redundancy or unsuccessful transactions). Ecommerce companies such as Amazon and Alibaba are using DBMS software to manage many orders made by customers across the globe. The companies cited deals with numerous and vast amount of data which cannot be handled or managed manually and thus the need to have a database management system (Thiru, 2019).

Conclusion

DBMS also improves strategic use of the data collected through analysis to identify new opportunities and trends, reduces complexity, data redundancy and inconsistency, improves data integrity, enhances data security, reduced maintenance and application development costs, increases data availability and accessibility, and facilitates application-data independence.Big data technology is another rapidly growing area. Hadoop helps organizations work with massive data sets by splitting them into smaller sets and then consolidating the results. A willingness to learn Hadoop or existing experience may help your company use your data more efficiently. What to look for:

Reference List

Harshika, V. (2019). Need for DBMS – GeeksforGeeks. [online] GeeksforGeeks. Available at: https://www.geeksforgeeks.org/need-for-dbms/ [Accessed 13 Jan. 2019].

Thiru, N. (2019). Role of Databases in An Organizations. [online] Myreadingroom.co.in. Available at: http://www.myreadingroom.co.in/notes-and-studymaterial/65-dbms/569-role-of-databases-in-an-organizations.html [Accessed 13 Jan. 2019].

Yadav, M. and Kumari, S. (2016). A Paradigm for Active Database Management Systems. International Journal Of Engineering And Computer Science.