how to store weather data with JPA

Question

The project is required to sotre large weather data (http://www1.ncdc.noaa.gov/pub/data/igra/) into file system with JPA. I mean disk files.

How to store those data. For example, how to organize the files? So that we can retrieve those files for retrieving.

Thanks very much

Answer 1

I had a quick look at the data, and the description of what they contain, I don't think it's practical to keep those data in disk files if you want to extract information from them. You'd probably be better off to design a couple of simple database tables in which to store these data, and query this database to get the data for your calculations, maybe with JPA.

A library that may help you to parse the data files is JFileHelpers, it makes working with fixed-width and delimited files a lot easier.

Hope this helps to get you started.