MySQL File System Vs DBMS Tutorial in Hindi | MySQL Tutorial for Beginners - 2

Надежный VDS
4 Просмотры
Поддержите сайт и поделитесь материалом в соц.сетях:

In this video, I've demonstrated the difference between the file system and the DBMS.
There were so many cons of the file system thus we need to overcome those limitations and hence DBMS came into the picture.
Watch this video till the end, and if you found this video helpful then be sure to hit that like button, and please subscribe to my channel if you haven't done.

Please watch the video till the end to get a better understanding. And If you found the video helpful then be sure to hit the like button.

Thanks for watching.
Check Out SQL In MySQL Playlist for the entire videos.

Link for my other Videos:

MySQL Introduction for Beginners


Disadvantages of Traditional File System
1. Data redundancy (Each application has its own data file so, same data may have to be recorded and stored in many times).
2. Data inconsistency (Due to the same data items that appear in more than one file do not get updated simultaneously in each and every file).
3. Data dependence (Program and application in the file processing system are data-dependent but, the problem is incompatible with file format).
4. Limited data sharing.
5. The problem with security.
6. Retrieval (retrieval is not easy).
7. Time-consuming.
8. Inefficient to maintain the record of the big firm having a large number of items.
9. Required Lots of labor work to do.

Uses of DBMS
* Effective and efficient management of data.
* Query processing and management.
* Security and integrity of data.
* Data sharing and storage.

Advantages of DBMS
* Less space consumes.
* Reduction of redundancy.
* Data integrity, security, and continuity.
* Backup and recovery process.
* The data model can be developed.
* Concurrency control.
* Data independence.
* Performance is good.

Disadvantages of DBMS
* Required large size of memory.
* Time-consuming.
* Required a processor with a high speed of data processing.
* Cost of data conversion.
* Database failure (DB corrupted due to power failure or whole system stops).
* Expensive.
* Complex.
* Higher impact of a failure (if any component can bring the operation to a halt).

Functions of DBMS
* Data dictionary management.
* Modify, delete, insert the data.
* Security.
* Control multi-user access management.
* Achieved data integrity.
* Transaction management.
* Data transformation and presentation.

Features of DBMS
* Persistence – permanent data stored.
* Validity – validation of field.
* Consistency – the value of data is the same at all place.
* Security.
* Non-redundancy – no multiple copies.
* Independence.
* Concurrency – multiple users can share a file at same time



#FileSystem_vs_DBMS #Database
Комментариев нет. - услуги фрилансеров от 500 руб.