I am developing a java project where I do have to fill database from http://projects.zoho.com.
Zoho provides API for fatching data. I have developed java transformers for fatching data and using hibernate I feel database.
This process, I do, running Main method from transformer. I want there a session to help filling database automatically. What further step I should follow ?
Begin with a good design of your database and then use database normalization techniques. Then use JConnector for your database. If you care about the physical order of data fetched in the disk use some technique to sort the data in main memory before you store it in disk. If the data in disk is not still as sorted as you want use external hashing technique.
The session will be triggered when the limit of fetched data in main memory is up to the limit you specify.