Database Management System

The process of storing, organizing, retrieving, and controlling data within a database is called database management. It is performed using a Database Management System (DBMS), which ensures data integrity, security, consistency, and availability.

Key Activities of Database Management

Database management includes the following activities:

1. Designing Database Schema

• Defining the structure of the database (tables, fields, data types, constraints).
• Writing schema for creating new data storage.

2. Modifying Database Structure

• Updating or altering existing tables, columns, and constraints.

3. Deleting Database Objects

• Removing tables, schemas, or entire databases when no longer needed.

4. Establishing Relationships

• Setting relationships between tables using keys (primary key, foreign key).

5. Data Manipulation 

• Inserting, updating, and deleting records.
• Querying data using SQL.

6. Managing Metadata (Data Dictionary)

• Maintaining information about data structure, constraints, and relationships.

7. Managing Database Objects

• Creating, modifying, and deleting:
  • Views
  • Indexes
  • Stored Procedures
  • Functions
  • Triggers
  • Synonyms

8. Security Management

• Controlling user access with roles and permissions.
• Authentication and authorization.

9. Backup and Recovery

• Creating backups to prevent data loss.
• Restoring data after failures.

10. Performance Optimization

• Indexing, query optimization, and tuning database performance.

Database Management System

A database management system is a software that manages the database structure and controls access to the data stored in the database.

In other words, a database management system is a generalized software system that manages databases and related objects, such as tables, views, indexes, users, stored procedures, functions, and triggers.

A DBMS acts as an interface between the database and application programs (front-end applications). It allows users to interact with data without needing to understand the underlying hardware or internal implementation.

Types and Availability

Nowadays, many types of database management systems are available in the markets. You can purchase the license of any database from its vendor and start using it.

However, there are also some open-source database management systems that you can download and use without purchasing their license. They are available on the internet. One can download it and use it.

The source code is also available for free, which could be modified by any user and redistributed. MySQL is one of the most popular open-source database management systems. The table contains examples of database management systems along with the companies that provide them.

Notes:

• Some DBMS (like PostgreSQL, SQLite) are open-source and managed by organizations or communities.
• Others (like Oracle, SQL Server) are commercial DBMS provided by companies.

Why Do We Need a Database?

We need a database for the following reasons:

1. Data Storage and Management
   A database is used to store, retrieve, update, and delete data efficiently.
2. Organized Data (Data Integration)
   Interrelated data is stored in a structured and organized manner in a single storage area for easy access. This storage area can be physical or logical within a computer system.
3. Reduction of Data Redundancy
   It helps avoid unnecessary duplication of data, saving storage space and improving efficiency.
4. Data Accuracy and Integrity
   Databases apply validation rules and constraints to ensure correct and consistent data.
5. Fast Data Access
   With database, we can search and retrieve data quickly, saving time and effort.
6. Data Sharing
   Once a database is created, we can share data with many users. Hence, we need a database to share and access data with many applications simultaneously.
7. Security
   It provides controlled access to data through authentication and authorization mechanisms.
8. Flexibility and Scalability
   A database provides the flexibility so that we can connect the database with different front-end applications and handle increasing amounts of data.
9. Handling Large and Complex Data
   Databases can store and manage large volumes of structured and unstructured data such as documents, images, audio, video, and user data.
10. Transaction Management
    Databases ensure reliable transaction processing and maintain consistency of data.
11. Backup and Recovery
    Databases provide mechanisms to recover data in case of system failure or data loss.
12. Concurrency Control
    Multiple users can access data simultaneously without conflicts.

Key Features of Database Systems

There are the following key features of database systems:

• Database systems provide the facility of data sharing, which allows the same data to be accessed and used by multiple applications.
• A database management system reduces data redundancy by minimizing unnecessary duplication of data, so the same data does not need to be entered repeatedly.
• Multiple users can access and modify data at the same time without conflicts.
• DBMS uses SQL to manage data with simple and concise commands instead of writing long programs.
• It is easy to create, modify, and maintain database structures such as tables and schemas.
• Data can be integrated easily using DBMS. A change in one data is reflected automatically in related data.
• DBMS applies rules and constraints to ensure the accuracy and consistency of data.
• It provides controlled access to data through authentication and authorization.
• DBMS provides backup and recovery mechanisms to restore data in case of system failure or data loss.

Limitations of Database Management System

Nothing is 100% perfect. Nothing is 100% perfect. Despite many advantages, a DBMS also has some limitations:

• The cost of a DBMS can be high, including software licenses, maintenance, and training. However, open-source options are available to reduce cost.
• DBMS systems are complex to design, implement, and manage, requiring skilled professionals.
• Large and enterprise-level databases may require powerful hardware and infrastructure, especially for high performance.
• Since data is centralized and shared, there is a risk of unauthorized access if proper security measures (authentication, authorization, encryption) are not implemented.
• If the volume of data is very high or many users access the database simultaneously, performance may slow down if the system is not properly optimized. Increased network traffic can also affect response time.
• If the DBMS fails, it can affect all users and applications dependent on it.