Reports based on millions of rows of data

[Java Programming]

I am looking for a solution that helps me to develop reports using Java on data of approx. 20 million rows in one table, that joins with another table of 60 million rows.The queries on these tables take a very long time and so the reports are not viewable. What is the best way to achieve...