Replicated databases create considerable data redundancy, which is in conflict with the database concept. Explain the justification of this approach
The primary justification for a replicated database is to support read-only queries in situations involving a high degree of data sharing, but no primary user exists. With data replicated at every site, data access for query purposes is ensured, and lockouts and delays due to network traffic are minimized. A potential problem arises, however, when replicated databases need to be updated by transactions. Since each site processes only local transactions, the common data attributes that are replicated at each site will be updated by different transactions and thus, at any point in time, will have uniquely different values. System designers need to employ currency control techniques to ensure that transactions processed at different locations are accurately reflected in all the databases copies.
You might also like to view...
According to Truth in Lending Act (TILA), charges on a stolen credit card that exceed $50 would generally:
A. have to be paid by the cardholder. B. not have to be paid by the cardholder. C. have to be recovered from the person who stole the card. D. have to be recovered by the bank.
If a manufacturer decides to use a push policy to promote its products, it is most likely to focus its efforts on
A. business customers. B. ultimate consumers. C. wholesalers. D. other producers. E. institutional users.
Risk analysis is a key part of IT project management
Indicate whether the statement is true or false
Which of the following forms the base of Maslow's hierarchy of needs?
What will be an ideal response?