Difference Between DBMS and File Processing System: DBMS
1. Redundancy is controlled.2.Unauthorised access is restricted. 3. Providing multiple user interfaces.4. Enforcing integrity constraints.5. Providing backup and recovery. File Processing System1. Data redundancy & inconsistency.2. Difficult in accessing data.3. Data isolation.4. Data integrity.5. Concurrent access is not possible.6. Security Problems. Hope you got it
1. Files act locally where as DBMS saves directly in a database 2. Saves in temporary locations where as DBMS in well arranged and permanent data base locations 3. In File Sys., transactions are not possible where as various transactions like insert,delete,view,updating etc r possible in DBMS 4. Data will be accessed through single or various files where as in DBMS, tables (schema) is used to access data 5. A "File manager" is used to store all relationships in directories in File Systems where as a data base manager (administrator) stores the relationship in form of structural tables 6. Last.... But not the least.... Data in data bases are more secure compared to data in files!!
1)recovery and back up can be done in dbms not in fs 2)multiple user interface is allowed in dbms 3)the changes made in one database will be applicable to all tables but not possible in fs 4)data redundancy is removed in dbms not in fs 5)restricting unauthorized access in db 5)enforcing integrity constraint in dbms 6)representing complex relationship among data is possible in dbms 7)provide storage structures for efficient query processing
The Main Advantages of DBMS over File Based System are:
1. Availability of up-to-date information: The entire database is accessible to all the users who are permitted to modify the database. If any one user updates the database the rest of the users will be able to view the modified database immediately. Ex. Reservation Clerks,
2. Controlling Redundancy of data: Since most of the data are stored only once and at one place, there is reduced / controlled redundancy of data. Only some data are stored more than once if it is inevitable to store them more than once. This is called controlled redundancy. In file based system each data item is stored once for each application which leads to wastage of storage space and also inconsistency in their values.
3. Program Data Insulation and Data abstraction. In DBMS the Data Structure definitions are stored separately from the access programs, in the catalog and hence the program need not be modified if the data definitions need to be changed. Also the addition / deletion of a data item does not affect the other data items already stored in the data base. In file Based systems the data definitions will be part of the application programs which implies that any change to the data definitions would need a change in the entire program, in order that the file based system to function properly.
4. Ability to enforce Standards and access permissions: DBMS allows the DBA to enforce standards in the way users access the database in large organisations. The DBA can also set the permissions for the data access and modifications for different users. In file processing systems, there is little scope to enforce these standards and permissions
5.Quick Response to Query Processing. Since all the data is stored in a single place, any complicated query would need very little time to be processed.
