DBMS Concepts

DBMS Tutorial Components of DBMS. Applications of DBMS The difference between file system and DBMS. Types of DBMS DBMS Architecture DBMS Schema Three Schema Architecture. DBMS Languages.

DBMS ER Model

ER model: Entity Relationship Diagram (ERD) Components of ER Model. DBMS Generalization, Specialization and Aggregation.

DBMS Relational Model

Codd’s rule of DBMS Relational DBMS concepts Relational Integrity Constraints DBMS keys Convert ER model into Relational model Difference between DBMS and RDBMS Relational Algebra DBMS Joins

DBMS Normalization

Functional Dependency Inference Rules Multivalued Dependency Normalization in DBMS: 1NF, 2NF, 3NF, BCNF and 4NF

DBMS Transaction

What is Transaction? States of transaction ACID Properties in DBMS Concurrent execution and its problems DBMS schedule DBMS Serializability Conflict Serializability View Serializability Deadlock in DBMS Concurrency control Protocols

Difference

Difference between DFD and ERD

Misc

Advantages of DBMS Disadvantages of DBMS Data Models in DBMS Relational Algebra in DBMS Cardinality in DBMS Entity in DBMS Attributes in DBMS Data Independence in DBMS Primary Key in DBMS Foreign Key in DBMS Candidate Key in DBMS Super Key in DBMS Aggregation in DBMS Hashing in DBMS Generalization in DBMS Specialization in DBMS View in DBMS File Organization in DBMS What Is A Cloud Database What Is A Database Levels Of Locking In DBMS What is RDBMS Fragmentation in Distributed DBMS What is Advanced Database Management System Data Abstraction in DBMS Checkpoint In DBMS B Tree in DBMS BCNF in DBMS Advantages of Threaded Binary Tree in DBMS Advantages of Database Management System in DBMS Enforcing Integrity Constraints in DBMS B-Tree Insertion in DBMS B+ Tree in DBMS Advantages of B-Tree in DBMS Types of Data Abstraction in DBMS Levels of Abstraction in DBMS 3- Tier Architecture in DBMS Anomalies in Database Management System Atomicity in Database Management System Characteristics of DBMS DBMS Examples Difference between Relational and Non-Relational Databases Domain Constraints in DBMS Entity and Entity set in DBMS ER Diagram for Banking System in DBMS ER Diagram for Company Database in DBMS ER Diagram for School Management System in DBMS ER Diagram for Student Management System in DBMS ER Diagram for University Database in DBMS ER Diagram of Company Database in DBMS Er Diagram Symbols and Notations in DBMS How to draw ER-Diagram in DBMS Integrity Constraints in DBMS Red-Black Tree Deletion in DBMS Red-Black Tree Properties in DBMS Red-Black Tree Visualization in DBMS Redundancy in Database Management System Secondary Key in DBMS Structure of DBMS 2-Tier Architecture in DBMS Advantages and Disadvantages of Binary Search Tree Closure of Functional Dependency in DBMS Consistency in Database Management System Durability in Database Management System ER Diagram for Bank Management System in DBMS ER Diagram for College Management System in DBMS ER Diagram for Hotel Management System in DBMS ER Diagram for Online Shopping ER Diagram for Railway Reservation System ER Diagram for Student Management System in DBMS Isolation in DBMS Lossless Join and Dependency Preserving Decomposition in DBMS Non-Key Attributes in DBMS Data Security Requirements in DBMS DBMS functions and Components What is Homogeneous Database? DBMS Functions and Components Advantages and Disadvantages of Distributed Database Relational Database Schema in DBMS Relational Schema Transaction Processing in DBMS Discriminator in DBMS

Difference between File System and DBMS
2019-07-30 11:33:08

Difference between File System and DBMS

What is File Management System?

A file management system is a collection of programs that manage and store data in files and folders in a computer hard disk. A file management system manages the way of reading and writing data to the hard disk. It is also known as conventional file system.
This system actually stores data in the isolated files which have their own physical location on the drive, and users manually go to these locations to access these files. It is the easiest way to store the data like text, videos, images, audios, etc. in general files. Data redundancy is high in file management system, and it cannot be controlled easily. Data consistency is not met, and the integration of data is hard to achieve.

Operating System such as Linux and Windows has its own file system.

For example, NTFS is the Windows file system, and EXT is the Linux file system.

These operating systems provide less security to these files where they have options such as hide files, locks, and sharing on files.

What is Database Management System?

  • The Database Management System or DBMS is an effective or easy way to store the data, mainly when data maintenance and security are the primary concern of the user.
  • The database management system stores the data or information in the form of interrelated tables and files.
  • In this type of system, data security is maximized using encryption/decryption, password protection, granting authorized access and others.
  • DBMS helps users to easily retrieve, insert, and manipulate data in a database.
  • It also helps to perform data recovery, transactions, and many more.
    Handling DBMS is difficult than the file system, but it provides more advantages than a file system.

Difference between File System and Database Management System

There are following differences between file system and DBMS:

File System     Database Management System (DBMS)
1. It is a software system that manages and controls the data files in a computer system. 1. It is a software system used for creating and managing the databases. DBMS provides a systematic way to access, update, and delete data.
2. File system does not support multi-user access. 2. Database Management System supports multi-user access.
3.  Data consistency is less in the file system. 3. Data consistency is more due to the use of normalization.
4. File system is not secured. 4. Database Management System is highly secured.
5. File system is used for storing the unstructured data. 5. Database management system is used for storing the structured data.
6. In the file system, data redundancy is high. 6. In DBMS, Data redundancy is low.
7. No data backup and recovery process is present in a file system. 7. There is a backup recovery for data in DBMS.
8. Handling of a file system is easy. 8. Handling a DBMS is complex. 
9. Cost of a file system is less than the DBMS. 9. Cost of database management system is more than the file system.
10. If one application fails, it does not affect other application in a system. 10. If the database fails, it affects all application which depends on it.
11. In the  file system, data cannot be shared because it is distributed in different files. 11. In DBMS, data can be shared as it is stored at one place in a database.
12. These system does not provide concurrency facility. 12. This system provides concurrency facility.
13. Example: NTFS (New technology file system), EXT (Extended file system), etc. 13. Example: Oracle, MySQL, MS SQL Server, DB2, Microsoft Access, etc.