Introduction of DBMS (Database Management System)
What is Database? What is Database Management System?
The database is a collection of related data which can be used to retrieve, insert and delete the data efficiently. Using the database, you can easily retrieve, insert, and delete the information. For example, the company Database organizes the data about the admin, employees etc.
- Database is a collection of related information that is organized in such a way that supports for easy access, modify and maintain data.
- The contents of a database are obtained by combining data from all the different
sources in an organization. - Generally, the database is managed by some special software packages known as Database Management Systems (DBMSs).
- DBMSs are specially designed applications to create connection between user and program, and to store data in an organized manner.
- The purpose of DBMSs software is to allow the user to create, modify and administration of database.
- Examples of database management systems are: Ms-Access, MySQL, PostgreSQL, SQLite, Microsoft SQL Server, Oracle, SAP, dBASE, FoxPro, etc.
Characteristics of DBMS
- Support ACID Properties
- Concurrent Use of Database
- Provides logical view of the process that manipulates data
- Supports automatic backup and recovery procedures
- Support the manipulation and processing of data
- Provide security of data
- Provides different viewpoints
also read:
HTML | DATA STRUCTURE |
DBMS | REASONING |
C PROGRAM | APTITUDE |
E-LEARNING |