Friday, April 15, 2011

What are the Disadvantages of Data Dependence in Database Systems?

In database systems, data dependence is undesirable for two reasons:
  1. Different applications will need different views of the same data. Suppose there are two applications, A and B. Let A stores records in decimal and B stores records in binary. If application C using A and B is data dependent then C will not be able to integrate A and B. So, major work of programmers, done in applications A and B will be wasted. But, it will still be possible to integrate the two files and to eliminate the redundancy, provided the DBMS is ready and able to perform all necessary conversions between the stored representations chosen and the form in which each application wishes to see it.
  2. The DBA (Database Administrator) must have the freedom to change the storage structure or access technique in response to changing requirements, without having to modify existing applications. If this doesn't happen then for slight change in the way of accessing data would lead to change the program completely. This is wastage of scarce and valuable resource.

0 comments:

Post a Comment