Miscellaneous Topics DBMS

Table of Contents hide

A file system is a method of organizing different formats of files with a hard disk or other medium of storage.
The file system arranges the files and helps in retrieving the files when required.
Different formats of file types, such as mp3, doc, txt, mp4, etc.
Files are stored in a hard disk in grouped form into directories.
A file helps in writing and reading data to the hard disk.
Examples of Industry standard File Systems are FAT, exFAT, NTFS, CDFS, etc.

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 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.

Related Posts