And basically all the songs from Splash, Raaban Inc., Boosterz Inc., all these guys active back in the days. Also a lot of guys here on NG do a lot of tracks in this style.
In these types of song (a mix from hands up, dance and trance?) the main melody is the most important part of the song. Try to listen to Distorted reality: basically there are the melody, the chords, the bells and the bass. And the track still kicks asses!
I know music theory: chords, major and minor scales, dominant and tonic relationship, etc.
What I want to know (and I know it's not easy and can't be explained): how these guys made their melodies? In this type of music, the tempo is usually around 140. The melodies are very powerful, even if you listen them alone. And when you hear the first two notes of the song: ring!, you just remember the song easily. I've even got some MIDIs floating around.
TL;DR: catchy and powerful melodies in dance hands up trance style, any hints?