Database Management System Vs Relational Database Management System
database management system (DBMS)
A database management system (DBMS) is system software for creating and managing databases. A DBMS makes it possible for end users to create, protect, read, update and delete data in a database. The most prevalent type of data management platform, the DBMS essentially serves as an interface between databases and users or application programs, ensuring that data is consistently organized and remains easily accessible
What does a DBMS do?
The DBMS manages the data; the database engine allows data to be accessed, locked and modified; and the database schema defines the database’s logical structure. These three foundational elements help provide concurrency, security, data integrity and uniform data administration procedures. The DBMS supports many typical database administration tasks, including change management, performance monitoring and tuning, security, and backup and recovery.
What are the components of a DBMS?
A DBMS is a sophisticated piece of system software consisting of multiple integrated components that deliver a consistent, managed environment for creating, accessing and modifying data in databases. These components include the following:
· Storage Engine
The underlying software component that a database management system (DBMS) uses to create, read, update and delete (CRUD) data from a database
· Metadata catalog
A set of relational tables that contain information about how to convert data from non-relational to relational formats.
· Database access language
Database Language is a special type of programming language used to define and manipulate a database
· Optimization engine
The process of selecting the most efficient way to execute a SQL statement
· Query processor
After a query is optimized, the DBMS must provide a means for running the query and returning the results.
· Lock manager
This crucial component of the DBMS manages concurrent access to the same data. Locks are required to ensure multiple users aren’t trying to modify the same data simultaneously.
· Log manager
The log manager allows you to filter, sort and browse query logs from each of your monitored DBMS instances.
· Data utilities
reorganization, backup and copy, recover, integrity check, load data, unload data and repair database.
Types of DBMS Technology ?
Most popular database management systems ?
Advantages of Database Management System ?
Controls database redundancy:- It can control data redundancy because it stores all the data in one single database file and that recorded data is placed in the database.
Data sharing:- In DBMS, the authorized users of an organization can share the data among multiple users.
Easily Maintenance:- It can be easily maintainable due to the centralized nature of the database system.
Reduce time:- It reduces development time and maintenance need.
Backup:- It provides backup and recovery subsystems which create automatic backup of data from Hardware and Software failures and restores the data if required.
Multiple user interface:- It provides different types of user interfaces like graphical user interfaces, application program interfaces
Relational Database Management System
What is Relational Database Management System ?
A relational database management system (RDBMS) is a program that allows you to create, update, and administer a relational database. Most relational database management systems use the SQL language to access the database.
Relational Database Management Systems maintains data integrity by simulating the following features:
Entity Integrity: No two records of the database table can be completely duplicate.
Referential Integrity: Only the rows of those tables can be deleted which are not used by other tables. Otherwise, it may lead to data inconsistency.
User-defined Integrity: Rules defined by the users based on confidentiality and access.
Domain integrity: The columns of the database tables are enclosed within some structured limits, based on default values, type of data or ranges.
Popular Relational Database Management Systems ?
· Oracle.
· MySQL.
· SQL Server.
· PostgreSQL.
· IBM DB2.
· Microsoft Access.
· SQLite.
· MariaDB
Example of RDBMS
Introduction to Relational Database Advantages
· Simple Model
A Relational Database system is the simplest model, as it does not require complex structuring or querying processes. It doesn’t involve tedious architectural processes like hierarchical database structuring or definition. As the structure is simple, it is sufficient to be handled with simple SQL queries and does not require complex queries to be designed.
· Data Accuracy
In the relational database system, multiple tables can be related to one another using a primary key and foreign key concepts. This makes the data to be non-repetitive. There is no chance for duplication of data. Hence, the relational database’s data accuracy is higher than in any other database system
· Easy Access to data
In the Relational Database System, there is no pattern or pathway for accessing the data, as other types of databases can be accessed only by navigating through a tree or a hierarchical model. Anyone who accesses the data can query any table in the relational database.
· Data Integrity
Data integrity refers to the overall accuracy, completeness, and reliability of data.
· Flexibility
Organizes data into separate tables, allowing for flexible access and reassembly according to user-defined relational tables.
· Normalization
Normalization is the process of organizing the data in the database.
· High Security
An RDBMS includes functions that maintain the security, accuracy, integrity and consistency of the data.
· Feasible for Future Modifications
the relational database system makes it straightforward to insert, delete, or update records to meet the latest requirements.
Disadvantages of RDBMS ?
➨Software is expensive.
➨Complex software refers to expensive hardware and hence increases overall cost to avail the RDBMS service.
➨It requires skilled human resources to implement.
➨Certain applications are slow in processing.
➨It is difficult to recover the lost data.