Would it be fair to say that your question is really "What is a Hibernate dialect?" Because if that's the case, it would have been better to just ask that in the first place. And it seems to me that if you knew what Hibernate dialects were used for, you wouldn't be asking follow-up questions here.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads