In this article functions of DBMS we give the information about it is used to store customer information, payment, account activities, deposit and loan information in the bank.
Functions of DBMS:-
- Data Redundancy
Every application has its own personal files in the file system and in such a situation, duplicate files of the same data are created at many places. In DBMS, files of the same type are kept at one place, that is, they are not repeated, which reduces the redundancy of data.
- Sharing Of Data
Data is shared by the authorized users of the organization. In this, the data administrator controls the data and gives rights to the user to access the data.
- Data Consistency
Through DBMS, the same type of data can be prevented from being stored repeatedly in the database.
- Integration of Data
In DBMS, all the data is in tables and there is more than one table in a database. Relationships can be created between all these tables making it easy to retrieve and update data.
- Data Security
In DBMS, the data is completely controlled by the data administrator. In this, the administrator ensures which user is to be given data and how much data is to be given. The database administrator controls which part of the database the user is allowed to access and which part is not. This increases the security of the database and the data does not fall into wrong hands.
-
Remove Procedures
You all know that computer is a kind of machine and it can malfunction at any time and hardware or software failure can happen at any time, in such a situation data can be destroyed. Through DBMS you can easily recover data in such conditions.
In simple words, “DBMS is a software that acts as an interface between end users and the database. “With its help, the user can store the data properly in the database and can easily access the data whenever he wants.”
The database management systems used today are:- DBase, FoxPro, IMS, Oracle, MySQL, SQL, and DB2 etc.
Application of DBMS:-
A database application is a software program that interacts with a database to capture, manage, and manipulate data. These applications are used across various industries to enhance efficiency, accuracy, and decision-making.
Key Features of Database Applications
- Efficient data storage and retrieval
- Support for multiple users
- Enhanced data security
- Easy data manipulation (insert, update, delete)
- Querying and report generation
- Integration with other applications and systems
- Business and Finance
Applications:
- Customer Relationship Management (CRM)
- Enterprise Resource Planning (ERP)
- Financial reporting and accounting systems
Example Uses:
- Storing customer profiles and transaction history
- Budgeting and payroll systems
- Tax calculation and compliance records
- Healthcare
Applications:
- Hospital Management Systems (HMS)
- Electronic Health Records (EHR)
- Patient Management Systems
Example Uses:
- Storing patient medical histories
- Appointment scheduling and billing
- Tracking medication and lab reports
- Education
Applications:
- Student Information Systems (SIS)
- Learning Management Systems (LMS)
- Examination and grading systems
Example Uses:
- Maintaining student enrollment, marks, and attendance
- Online course content and test management
- Library database systems
-
E-commerce and Retail
Applications:
- Inventory management systems
- Order processing and billing systems
- Customer feedback and analytics platforms
Example Uses:
- Managing product catalogs
- Tracking orders, returns, and shipping
- Personalizing customer recommendations
- Banking and Insurance
Applications:
- Core banking systems
- Loan and credit management
- Risk analysis and fraud detection systems
Example Uses:
- Account management and fund transfers
- ATM and online banking operations
- Insurance claim processing
- Social Media and Communication
Applications:
- User profile and messaging databases
- Media content storage (images, videos, posts)
- Activity logs and analytics
Example Uses:
- Storing posts, likes, comments, and followers
- Chat history and user preferences
- Data mining for trends and advertising
- Transportation and Logistics
Applications:
- Fleet management systems
- Ticket reservation systems
- Supply chain databases
Example Uses:
- Tracking vehicle movement and fuel usage
- Booking train, bus, or flight tickets
- Managing warehouse inventories
- Government and Public Services
Applications:
- Citizen information systems
- Land and property registration
- Public welfare schemes
Example Uses:
- Issuing ID cards, passports, licenses
- Managing tax records and voter data
- Welfare benefit distribution tracking
- Cloud-Based and Mobile Applications
Applications:
- Online backup systems
- Cloud document storage (Google Drive, Dropbox)
- Mobile apps with remote databases (e.g., food delivery, fitness apps)
Advantages of DBMS
DBMS provides numerous benefits over traditional file-based systems:
- Reduced Data Redundancy
- In traditional systems, the same data may be duplicated in multiple files.
- DBMS eliminates duplication by storing data centrally and using relationships.
- Improved Data Sharing
- Multiple users and applications can access the same data simultaneously.
- Supports both concurrent access and remote access.
- Data Integrity and Consistency
- DBMS enforces data validation rules (constraints, relationships), ensuring that data remains accurate and consistent.
- Data Security
- DBMS provides access controls, authentication, and encryption.
- Only authorized users can view or modify data.
- Backup and Recovery
- Most DBMSs include automated backup and recovery features, which protect against data loss in case of system failure.
- Efficient Data Access
- Powerful query languages like SQL allow quick retrieval and manipulation of data using optimized algorithms.
- Data Independence
- Applications are independent of the data structure.
- Changes to data format or structure don’t require changes in application programs.
- Multi-user Access and Concurrency Control
- Multiple users can access the system without conflict due to built-in locking and transaction control mechanisms.
- Scalability
- Databases can be easily scaled vertically or horizontally to manage large volumes of data.
- Standardization
- DBMS supports standard rules, models (e.g., relational), and languages like SQL, ensuring compatibility and portability.
Disadvantages of DBMS
Despite its benefits, DBMS also has some drawbacks:
- Cost
- High initial cost for hardware, software licenses, and skilled personnel.
- Maintenance and upgrades can also be expensive.
- Complexity
- A DBMS is a complex piece of software requiring professional knowledge for proper design, management, and operation.
- Performance Overhead
- Due to security, integrity checks, and multi-user support, a DBMS might perform slower than simple file-based systems for very small datasets.
- Size
- DBMS software itself consumes large storage space and memory resources.
- Risk of Failure
- If the central DBMS fails, the entire system can become inaccessible until recovery.
- Requires robust disaster recovery plans.
- Vendor Dependence
- Relying heavily on a specific DBMS product may result in vendor lock-in, making it hard to switch later.
- Frequent Updates
- Constant updates to ensure security, compliance, and performance can be disruptive.
Some More:
POP- Introduction to Programming Using ‘C’
OOP – Object Oriented Programming
DBMS – Database Management System
RDBMS – Relational Database Management System
Join Now: Data Warehousing and Data Mining