12/09/2023
What is the difference between a "Database" and a common "storage device" ?
And
What is the difference between a "Database" and "DBMS" ?
I have consistently encountered challenges when grappling with these intricate concepts, and I suspect that you, too, may have faced similar difficulties. Allow me to offer you an analogy: understanding these concepts is akin to enjoying a delectable piece of cake – once you grasp the essence, everything becomes much sweeter.
To lay the foundation for understanding these concepts, we must begin with a fundamental question: what is Data ?
Data refers to the raw facts and figures which can be processed to extract some useful material / knowledge(information; processed data)
In general, data is the undeniable part of each and everything in the world like your name, age, height, place, time, number, temperature, color or size of anything.
In simple words
where ever you are ,whatever you are doing and whoever you are ? Data is associated with you !
A Database is a collection of related data organized in a way that data can be easily accessed, managed and updated.
A storage device, like hard drives, solid-state drives (SSDs), or network-attached storage (NAS), are primarily designed for storing and accessing purposes.
A DBMS (DataBase Management System) is software for database development and/or management. Specifically, a DBMS is a tool used to perform any kinds of operations on data in a database. DBMS also provides protection and security for relational databases. It also helps maintain data consistency in case of multiple users. Examples of popular DBMSes include MySQL, Oracle, Sybase, Microsoft Access and IBM DB 2.
Difference b/w Database & storage device
1) Database is a storage system not any physical device but databases rely on hardware to run (such as servers or storage devices) while a simple storage device is hardware primarily used for storing data.
2) In a database, data is structured (organized in a format / related data) while in simple storage like your personal PC data is not structured ( not organized in a format / unrelated data).
3) You are the only one who can access the data at a time in a simple storage device while in the database multiple users can.
4) Database is attached to some specific application (for which it store or managed data) while a storage device don't.
5)Storage devices provide basic read/write capabilities. They are not optimized for complex data querying or management tasks like databases.
etc
Difference b/w Database & DBMS
A DBMS is a software system. In other words it is a bunch of software programs running on the computer.
A database is a storage system itself i.e. it is a bunch of files with data.
The specific implementation in the specific DBMS (remember, DBMS is software) is used to access a database (remember, bunch of files) on a computer where DBMS is running.
Think of the DBMS as the tool or platform that facilitates working with databases.
The whole concept is too vast to be explained in just one post. But I hope this makes sense.
