Advantages of DBMS over file processing system
Advantages of DBMS over file system
DBMS
Drawbacks of File system:
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.
Duplication of data – Redundant data
Dependency on application programs – Changing files would lead to change in application programs.
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
Data Consistency and Integrity – data normalization takes care of it too
Secure – Each user has a different set of access
Privacy – Limited access
Easy access to data
Easy recovery
Flexible
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
The principal advantages of DBMS over file processing system:
• Flexibility: Because programs and data are independent, programs do not have to be modified when types of unrelated data are added to or deleted from the database, or when physical storage changes.
• Fast response to information requests: Because data is integrated into a single database, complex requests can be handled much more rapidly than locating data separately. In many businesses, faster response means better customer service.
• Multiple access: Database software allows data to be accessed in a variety of ways (through various key fields), by using several programming languages (both3GL and nonprocedural4GL programs).
• Lower user training costs: Users often find it easier to learn such systems and training costs may be reduced. Also, the total time taken to process requests may be less, which would increase user productivity.
• Less storage: Theoretically, all occurrences of data items need be stored only once, thereby eliminating the storage of redundant data. System developers and database designers often use data normalization to minimize data redundancy.
Here are some disadvantages:
• DBMS subjects business to risk of critical data loss in its electronic format and can be more readily stolen without proper security.
• The cost of a DBMS can be prohibitive for small enterprises as they struggle with cost justification for making investment in the infrastructure.
• Improper use of the DBMS can lead to incorrect decision making as people take presented data for granted as accurate.
• Data can be stolen by weak password security policy.
DBMS
Drawbacks of File system:
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.
Duplication of data – Redundant data
Dependency on application programs – Changing files would lead to change in application programs.
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
Data Consistency and Integrity – data normalization takes care of it too
Secure – Each user has a different set of access
Privacy – Limited access
Easy access to data
Easy recovery
Flexible
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
The principal advantages of DBMS over file processing system:
• Flexibility: Because programs and data are independent, programs do not have to be modified when types of unrelated data are added to or deleted from the database, or when physical storage changes.
• Fast response to information requests: Because data is integrated into a single database, complex requests can be handled much more rapidly than locating data separately. In many businesses, faster response means better customer service.
• Multiple access: Database software allows data to be accessed in a variety of ways (through various key fields), by using several programming languages (both3GL and nonprocedural4GL programs).
• Lower user training costs: Users often find it easier to learn such systems and training costs may be reduced. Also, the total time taken to process requests may be less, which would increase user productivity.
• Less storage: Theoretically, all occurrences of data items need be stored only once, thereby eliminating the storage of redundant data. System developers and database designers often use data normalization to minimize data redundancy.
Here are some disadvantages:
• DBMS subjects business to risk of critical data loss in its electronic format and can be more readily stolen without proper security.
• The cost of a DBMS can be prohibitive for small enterprises as they struggle with cost justification for making investment in the infrastructure.
• Improper use of the DBMS can lead to incorrect decision making as people take presented data for granted as accurate.
• Data can be stolen by weak password security policy.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment