Database Management System (DBMS) is a software application that works to create, maintain, and manipulate databases. It aids in organizing, storing, and retrieving databases, while also paying attention to data integrity, security, and concurrency control.
The primary goal of DBMS is to assist in storing and accessing data in a structured manner. Data is organized into tables, rows, and columns. Users can search, retrieve, and manipulate data through queries and commands using DBMS.
- MySQL
- PostgressSQL
- MariaDB
- Microsoft SQL Server
- Oracle RDBMS
- IBM DB2
- MongoDB (NoSQL)
- SQLite
A database is an organized collection of data stored in a format that can be easily accessed. It allows for reading and writing data, storing large amounts of data, better organizing data, providing faster access to data, easier manipulation, and relating data to other data. Databases are not spreadsheets; they can define and traverse relationships between tables and issue commands to interact with the database. Spreadsheets are optimized for adding numbers, whereas databases are optimized for working with data.
- Relational Databases: They organize data into tables, rows, and columns, such as MySQL, PostgreSQL, Oracle.
- NoSQL Databases: They are designed to handle unstructured or semi-structured data, such as MongoDB.