Adverse effect of excessive water on the crop growth

Dear Friends, I have two related question about my new farming project area. 1. I am evaluating the adverse effect of excessive irrigation water provided to the crops at different growth stages. Is there any software to evaluate the correlation between the amount of irrigation water and crop growth? If anyone has worked in this area, share your case studies, documents or experience, please. 2. In my study, area soil has more than 20% clay content so the speed of water moving down the root zone is very slow. Soils easily get waterlog. How can we correct the soil drainage issue here in this area?