Don't let the shape of existing (often ugly) data dictate your application architecture. Delete what's not needed, normalize and reshape data into a good form before feeding it back to the app. Your application is the master; data is not.