In the world of technology, Creating, removing, updating, and managing files is an essential approach for those who want to access and maintain their files efficiently in a limited time period. There are many ways to store your files in your system but some easier ways are strong them in the database or in your local storage systems like a local disk, hard drive, or external drive something.
Database Management System
A database management system is like software or a program that is nothing but a medium to store and retrieve the user's data from the system or from the Server. Before jumping into the DBMS world, We must have a piece of prior knowledge about what is a database?
What is Database?
A database is a systemic way of collecting data for easy access and management. This data can be Images, Videos, PDFs, or some files with unique extensions. Since databases are used to manage, retrieve or handle the data in the real-time sites present on the world wide web and they are dynamics. Databases can be made with query languages and some of them are SQL or non-SQL. SQL stands for structured query languages some of the popular databases using SQL are MySql, PostgreSQL, Oracle, or SQL Server. Non- SQL are those which doesn't use SQL protocols and rules and some of them are MongoDB, CouchDB, CouchBase, Cassandra, etc.
Back to our DBMS 😁
DBMS offers protections for files in case an unknown person tries to access your data without your permission. Even if your system crashes or fails, your data can be recovered safely via a database management system.
Let's see how SQL and Non-SQL Databases look like in the real world
SQL
From the picture, one can see our user's data is arranged in tabular form which is very easy to understand and can be modified with our needs. SQL databases are always arranged in the tabular or arranged form.
NON-SQL
Non-SQL offers a non-tabular method that is not arranged in some kind of table or something. Pictures depict all so there is no need to tell anything further about what real-world databases look like.
What is File System?
File System is similar in a few ways and different in many ways. A file system is an approach or technique of managing or arranging our files in a local system storage devices such as Hard drives, Pendrive, CD, DVD's, Floppy disks, or other external drives. It helps you to organize the data or files and allows easy retrieval. These Files can be Mp3, Mp4, Wpe4, doc, ppt, pdf, txt, or some other extension files.
The file system allows users to retrieve the files in their respective systems with the respective operating systems such as Windows, Linux, MacOS, Android, or IOS.
What Files System Looks like in the Linux Operating System
On the left side of the tray, I have my files arranged in the order like my music will be in the music section, the document will be in the document section, pictures in the pictures section, and server files will be in the network section which I moved to another location for security issues so you can't see that section.
That's all for today, See you in the next one. Bye, bye.