Scribd Logo
Upload

Welcome to Scribd!

  • 145 views

    Advantages of DBMS Over File System

    Uploaded by

    Mitali Mathur
    The document compares file processing systems and database management systems (DBMS). File systems can result in data redundancy, inconsistency, isolation, and lack of atomicity in transactions. DBMS addresses these issues through data normalization, which eliminates redundancy and improves consistency. It also provides better security, privacy, accessibility and recovery of data. While more powerful than file systems, DBMS can be more complex and costly to implement.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Advantages of DBMS Over File System

    Uploaded by

    Mitali Mathur
    145 views2 pages
    The document compares file processing systems and database management systems (DBMS). File systems can result in data redundancy, inconsistency, isolation, and lack of atomicity in transactions. DBMS addresses these issues through data normalization, which eliminates redundancy and improves consistency. It also provides better security, privacy, accessibility and recovery of data. While more powerful than file systems, DBMS can be more complex and costly to implement.

    Original Title

    Advantages of DBMS over file system

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document compares file processing systems and database management systems (DBMS). File systems can result in data redundancy, inconsistency, isolation, and lack of atomicity in transactions. DBMS addresses these issues through data normalization, which eliminates redundancy and improves consistency. It also provides better security, privacy, accessibility and recovery of data. While more powerful than file systems, DBMS can be more complex and costly to implement.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    145 views2 pages

    Advantages of DBMS Over File System

    Uploaded by

    Mitali Mathur
    The document compares file processing systems and database management systems (DBMS). File systems can result in data redundancy, inconsistency, isolation, and lack of atomicity in transactions. DBMS addresses these issues through data normalization, which eliminates redundancy and improves consistency. It also provides better security, privacy, accessibility and recovery of data. While more powerful than file systems, DBMS can be more complex and costly to implement.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Advantages of DBMS over file system

    In this guide, we will discuss what is a file processing system and how Database
    management systems are better than file processing systems.

    Drawbacks of File system


     Data redundancy: Data redundancy refers to the duplication of data, lets say
    we are managing the data of a college where a student is enrolled for two
    courses, the same student details in such case will be stored twice, which
    will take more storage than needed. Data redundancy often leads to higher
    storage costs and poor access time.
     Data inconsistency: Data redundancy leads to data inconsistency, lets take
    the same example that we have taken above, a student is enrolled for two
    courses and we have student address stored twice, now lets say student
    requests to change his address, if the address is changed at one place and
    not on all the records then this can lead to data inconsistency.
     Data Isolation: Because data are scattered in various files, and files may be
    in different formats, writing new application programs to retrieve the
    appropriate data is difficult.
     Dependency on application programs: Changing files would lead to change in
    application programs.
     Atomicity issues: Atomicity of a transaction refers to “All or nothing”,
    which means either all the operations in a transaction executes or none.

    For example: Lets say Steve transfers 100$ to Negan’s account. This transaction
    consists multiple operations such as debit 100$ from Steve’s account, credit
    100$ to Negan’s account. Like any other device, a computer system can fail lets
    say it fails after first operation then in that case Steve’s account would have been
    debited by 100$ but the amount was not credited to Negan’s account, in such
    case the rollback of operation should occur to maintain the atomicity of
    transaction. It is difficult to achieve atomicity in file processing systems.

     Data Security: Data should be secured from unauthorised access, for


    example a student in a college should not be able to see the payroll details of
    the teachers, such kind of security constraints are difficult to apply in file
    processing systems.

    Advantage of DBMS over file system


    There are several advantages of Database management system over file system. Few
    of them are as follows:
     No redundant data: Redundancy removed by data normalization. No data
    duplication saves storage and improves access time.
     Data Consistency and Integrity: As we discussed earlier the root cause of data
    inconsistency is data redundancy, since data normalization takes care of the
    data redundancy, data inconsistency also been taken care of as part of it
     Data Security: It is easier to apply access constraints in database systems so
    that only authorized user is able to access the data. Each user has a
    different set of access thus data is secured from the issues such as identity
    theft, data leaks and misuse of data.
     Privacy: Limited access means privacy of data.
     Easy access to data – Database systems manages data in such a way so that
    the data is easily accessible with fast response times.
     Easy recovery: Since database systems keeps the backup of data, it is easier
    to do a full recovery of data in case of a failure.
     Flexible: Database systems are more flexible than file processing systems.

    Disadvantages of DBMS:

     DBMS implementation cost is high compared to the file system


     Complexity: Database systems are complex to understand
     Performance: Database systems are generic, making them suitable for
    various applications. However this feature affect their performance for
    some applications

    You might also like