Data Base Management System or DBMS

 What is a Data Base Management System (DBMS)?

    A database system is an automated system for maintaining records. A DBMS is a software that is for creating and managing a database. DBMS makes it possible for us end user to create, read, update, protect, and delete data in the database. 

The main goal of a DBMS is to make sure that our data is accurate, up-to-date, consistent, and can be accessed easily by different end user if needed.

Through the  years DBMS has gained a lot of features, the Three main feature of it; add, update, and delete data.

What are The Functions of DBMS?

• Data Definition -Data definitions must be accepted in source form by the DBMS and converted to the appropriate object form.
• Data Manipulation -The DBMS needs to be able to handle user requests to access and maybe update already-existing data in the database or to add new data.
• Data Security and Integrity -Any attempts to evade the security and integrity checks set out by the database administrator must be rejected by the DBMS, which must be able to track user requests.
• Data Recovery and Concurrency -The DBMS needs to be able to recover from system crashes or at least lessen their effects.
• Data Dictionary -A system database called the database dictionary must be made available by the DBMS.

Advantages of DBMS

• Reduced Data Redundancy -By maintaining just one duplicate of the data, data redundancy is prevented in database systems.
• Data Integrity -You can be sure that any changes to the data will be reflected in all upcoming uses of that data since just one copy of a specific piece of data is kept in the database.
• Data Independence -Data must be independent of both the software used to access the database and other data in the database due to the nature of the database system.
• Data Security -The database software package for a database system may include additional security features.
• Data Consistency -The database environment maintains data consistency.
• Easier use of Data -Using data is simpler in a database system.
• Less Storage -The database will require less storage space because data redundancy has been reduced, if not completely eliminated.

Disadvantages of DBMS

• Complexity -Both databases and the DBMS that supports them are very complicated.
• Expense -Due to the potential requirement for new hardware, the installation of the DBMS and its databases onto the current system requires careful preparation.
• Vulnerability -Data in a database is centrally located, making it susceptible to partial or whole destruction in the event of a hardware component failure or a software error.
• Size -The average mainframe database is enormous.
• Training Cost -When a business purchases a database product, it must first train one or more people to serve as the new product's database administrator.
• Compatibility -The incompatibility of most database systems with other database systems is one of its drawbacks.
• Lock-in Technology -What if the merchant says they want to stop selling the item? They might need to start from scratch while redesigning their system.