Managing denormalized data

Whatever denormalization techniques you use, you need to ensure data integrity by using:

From an integrity point of view, triggers provide the best solution, although they can be costly in terms of performance.