File Management System in DBMS
➺ File System is used to store, Retrieve and update A set of files is called a file system.
➺ File system is managed by the operating system.
➺ File system is best for a small file.
➺ FIle system fails when the file size large.
◆ Advantages of file system:-
➺ Cost-effective:- A file management system is cost-effective thus, a small organization can also afford for managing organizational data or information.
➺ Editing:- In the file management system we can easily edit a piece of information or file on the system.
➺ Remote access:- Data can be accessed remotely on other computer systems.
➺ Backup:- File system provides faster backup of data or information of the file.
➺ Sharing:- In a File system, data or information can be shared with several users at the same time. sharing of data is easy.
◆ Disadvantages of file system:-
➺ Data Redundancy:- Same information is available in many files. ex:- Student addresses in different files for different purposes.
➺ Data access difficulty:- To access the file we need physical information such as filename, location, etc.
➺ No Security:- We can give different levels of access.
➺ Concurrent Execution:- It blocks the currently executing file at the resource level.
➺ I/O Cost:- File management system has a higher I/O cost. It refers to bringing the Block of Secondary Memory into Primary Memory is Called I/O Cost.
You might like this :-
○History of Computer
○Data Model in DBMS
○ER-Model in DBMS
○Codd's 12 Rules