bdfd1m0e | Database Administration |
Because duplicating data can improve retrieval speeds, you may choose to reintroduce some data duplication in the tables you have been working on.
Data duplication can also lead to inconsistent data being held. However, some data fields are more suitable for duplication than others. There is less risk of data inconsistency if you duplicate fields whose values do not change often. For example, a passenger's name is unlikely to change whereas seat availability changes with every seat sold.
You must balance these factors against the potential improvement in retrieval speeds.
In the examples that follow, you can see how selected duplication of data can improve the performance of your database.