Redundancy and its Effects

"Om Swastiastu"

In database management, we might find some problems when storing the data on the spreadsheet. One of them is data redudancy. What is redundancy? Redundancy is the duplication of data, or the storing of the same data in more than one place. What problems does redundancy cause? Redundancy wastes space because you're storing the same data in the multiple places. The extra space result in larger sreadsheets that require more space in memory and on disk and that take longer to save and open.

When you need to change data, redundancy also makes your changes more cumbersome and time-consuming. Even if you use the global find-and-replace feature, multiple changes require more computer time than does a single change. Finally, redundandy can lead to inconsistencies. For example, you might enter the same name in the same column, and then not be sure which is the correct spelling. Further, if that names spelled in three different ways and you use the search feature with one of the three values, you'd find a single match instead of three matches.

"Om Santhi, Santhi, Santhi, Om"