What happens if you want to modernize and normalize your database by by
splitting big tables into multiple smaller ones.
If you used a view which originally had the same columns in the same table
the original table, you simply have to modify the view (joining the new
tables together), but you no not have to modify any of your programs.
You do not even have to rework your updates.
Instead of triggers, which can handled inserts, updates or deletes on
files/tables can only be added to views.
triggers (one for insert, one for update and one for delete) ... and voilà
I'd always expect that something like this will happen in the future
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.