Fundamentals of upgrade

What exactly changes with an SAP version upgrade ? all important tables are in Db and I guess db is not touched during upgrade, so what actually changes here ?

Can somebody give me some simple but clear idea on this. (Not any other URL or guide name as I already have upgrade guide downloaded from SMP login and have ADM326 too).

But need to know the basic changes that happen during upgrade.