Miscellaneous Topics DBMS

Database

• A database is an organized collection of data, typically stored and accessed electronically from a computer system.
• It’s designed to efficiently manage, store, and retrieve information.
• A database consists of tables, which are sets of data organized into rows (entries or records) and columns (fields or attributes).
• Databases use a specialized language called Structured Query Language (SQL) to interact with the data. SQL enables users and applications to perform various crude operations on the database, such as querying to retrieve specific information, updating existing data, adding new data, and deleting unnecessary information.
• There are various types of databases, including relational databases (like MySQL, PostgreSQL, Oracle, etc.), NoSQL databases (such as MongoDB, Cassandra, etc.), and others, each designed to handle specific data storage and retrieval requirements.

DBMS

• DBMS stands for Database Management System.
• A DBMS serves as an interface between users or applications and the database itself, allowing for efficient and structured handling of data.
• DBMS facilitates the creation, organization, management, and manipulation of databases using related software.
• DBMS helps in Data Storage, Data retrieval, Data Manipulation, Data security, Concurrency Control, Backup and Recovery etc.
• DBMS comes in various types, such as relational database management systems (RDBMS) like MySQL, PostgreSQL, SQL Server, etc., and non-relational or NoSQL databases like MongoDB, Cassandra, etc.