advantage and disadvantages of database
Answers
Answered by
4
Advantages:
1. Controlling Data Redundancy
In the conventional file processing system, every user group maintains its own files for handling its data files. This may lead to
• Duplication of same data in different files.
• Wastage of storage space, since duplicated data is stored.
• Errors may be generated due to updation of the same data in different files.
• Time in entering data again and again is wasted.
• Computer Resources are needlessly used.
• It is very difficult to combine information.
2. Elimination of Inconsistency
In the file processing system information is duplicated throughout the system. So changes made in one file may be necessary be carried over to another file. This may lead to inconsistent data. So we need to remove this duplication of data in multiple file to eliminate inconsistency.
To avoid the above problem, there is a need to have a centralize database in order to have this conflicting information.
On centralizing the data base the duplication will be controlled and hence inconsistency will be removed.
3. Better service to the users
A DBMS is often used to provide better services to the users. In conventional system, availability of information is often poor, since it normally difficult to obtain information in a timely manner because our existing systems are not capable to produce the same.
Once several conventional systems are combined to form one centralized database, the availability of information and its updateness is likely to improve since the data can now be shared and DBMS makes it easy to respond to anticipated information requests.
Centralizing the data in the database also means that user can obtain new and combined information easily that would have been impossible to obtain otherwise.
Also use of DBMS should allow users that don’t know programming to interact with the data more easily, unlike file processing system where the programmer may need to write new programs to meet every new demand.
4. Flexibility of the System is Improved
Since changes are often necessary to the contents of the data stored in any system, these changes are made more easily in a centralized database than in a conventional system.
Applications programs need not to be changed on changing the data in the database.
Disadvantages of Database Systems
The following are the disadvantages of Database Systems
1. Database Complexity
The design of the database system is complex, difficult and is very time consuming task to perform.
2. Substantial hardware and software start-up costs Huge amount of investment is needed to setup the required hardware and the softwares needed to run those applications.
3. Damage to database affects virtually all applications programs If one part of the database is corrupted or damaged because of the hardware or software failure, since we don’t have many versions of the file, all the application programs which are dependent on this database are implicitly affected.
4. Extensive conversion costs in moving form a file-based system to a database system If you are currently working on file based system and need to upgrade it to database system, then large amount of cost is incurred in purchasing different tools, adopting different techniques as per the requirement.
I Hope this helps you.
ni
1. Controlling Data Redundancy
In the conventional file processing system, every user group maintains its own files for handling its data files. This may lead to
• Duplication of same data in different files.
• Wastage of storage space, since duplicated data is stored.
• Errors may be generated due to updation of the same data in different files.
• Time in entering data again and again is wasted.
• Computer Resources are needlessly used.
• It is very difficult to combine information.
2. Elimination of Inconsistency
In the file processing system information is duplicated throughout the system. So changes made in one file may be necessary be carried over to another file. This may lead to inconsistent data. So we need to remove this duplication of data in multiple file to eliminate inconsistency.
To avoid the above problem, there is a need to have a centralize database in order to have this conflicting information.
On centralizing the data base the duplication will be controlled and hence inconsistency will be removed.
3. Better service to the users
A DBMS is often used to provide better services to the users. In conventional system, availability of information is often poor, since it normally difficult to obtain information in a timely manner because our existing systems are not capable to produce the same.
Once several conventional systems are combined to form one centralized database, the availability of information and its updateness is likely to improve since the data can now be shared and DBMS makes it easy to respond to anticipated information requests.
Centralizing the data in the database also means that user can obtain new and combined information easily that would have been impossible to obtain otherwise.
Also use of DBMS should allow users that don’t know programming to interact with the data more easily, unlike file processing system where the programmer may need to write new programs to meet every new demand.
4. Flexibility of the System is Improved
Since changes are often necessary to the contents of the data stored in any system, these changes are made more easily in a centralized database than in a conventional system.
Applications programs need not to be changed on changing the data in the database.
Disadvantages of Database Systems
The following are the disadvantages of Database Systems
1. Database Complexity
The design of the database system is complex, difficult and is very time consuming task to perform.
2. Substantial hardware and software start-up costs Huge amount of investment is needed to setup the required hardware and the softwares needed to run those applications.
3. Damage to database affects virtually all applications programs If one part of the database is corrupted or damaged because of the hardware or software failure, since we don’t have many versions of the file, all the application programs which are dependent on this database are implicitly affected.
4. Extensive conversion costs in moving form a file-based system to a database system If you are currently working on file based system and need to upgrade it to database system, then large amount of cost is incurred in purchasing different tools, adopting different techniques as per the requirement.
I Hope this helps you.
ni
vini210:
thanks but i want answer in your own words
i also have internet
if you talk in about my words then i would have written or learnt the headings if advantages and disadvantages
ok
anyother query?
no
thanks
ok bro
Answered by
16
Advantages÷
1÷Better data sharing
2÷Better data security
3÷Improved data integration
4÷Improved desicion making
5÷Increased end user productivity
Disadvantages÷
1÷Increased Costs
2÷Management Intricacies
3÷Maintaing Currency
4÷Frequent Upgrade
I wish that it will help you lot..
1÷Better data sharing
2÷Better data security
3÷Improved data integration
4÷Improved desicion making
5÷Increased end user productivity
Disadvantages÷
1÷Increased Costs
2÷Management Intricacies
3÷Maintaing Currency
4÷Frequent Upgrade
I wish that it will help you lot..
Similar questions