iTunes database issues

I love iTunes, and I love that it provides me with convenient access to all my music. But I'm beginning to get frustrated with some of the interesting DB issues present in the way iTunes was developed.