What is the DBMS(database management system)?
A database management system (DBMS) is system software for creating and managing databases. It is a software system that uses a standard method of cataloging, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Some DBMS examples are:-
- MySQL
- Microsoft Access
- Oracle
- PostgreSQL
- dBASE
- FoxPro
- SQLite
- IBM DB2
- LibreOffice Base
- MariaDB
- Microsoft SQL Server etc.
- Banking -For customer information, account activities, payments, deposits, loans, etc.
- Airlines -For reservations and schedule information.
- Universities -For student information, course registrations, colleges, and grades.
- Sales -Use for storing customer, product & sales information, etc...
Four Types of DBMS systems are:
- Network Model.
- Object-Oriented Model.
- Hierarchical DBMS.
- Object-Oriented Model.
- Uniform administration procedures for data.
- A DBMS uses various powerful functions to store and retrieve data efficiently.
- DBMS serves as an efficient handler to balance the needs of multiple applications using the same data.
- DBMS offers a variety of techniques to store & retrieve data.
- Reduced Application Development Time.
- Offers Data Integrity and Security.
No comments:
Post a Comment