Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re^2: Strategy for managing a very large database with Perl

by punkish (Priest)
on Jun 18, 2010 at 12:13 UTC ( #845361=note: print w/ replies, xml ) Need Help??


in reply to Re: Strategy for managing a very large database with Perl
in thread Strategy for managing a very large database with Perl

punkish>> A typical search would be to retrieve all the values 
punkish>> of  for  or <for a set of points> 
punkish>> <for a particular year+yday combination>.

dws> If those are the typical search patterns,
Those are typical search patterns. There are a few other search patterns as well, so I have to find a format that can accommodate *all* of them.

dws> is a relational database the right hammer to reach for? 
Dunno. Hence this thread.
dws> Why not flat files?
Well, the data are already in some kind of flat files. Actually, they are in files, but not flat files. They are in NetCDF format. The format is very compact, and very suitable for storing array of arrays, however, it is not very amenable to spatial searches. Hence, my desire to put the data in a database.

As shown in my original post, the db table is very simple, almost like a flat file (with a little overhead per "line" added by the db). However, it allows me to JOIN this simple table with a location table. I can do a spatial search on the location table, retrieve the value of points that fall within my search, and then retrieve the variables from this simple but mongo table.

--

when small people start casting long shadows, it is time to go to bed
Comment on Re^2: Strategy for managing a very large database with Perl

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://845361]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (5)
As of 2016-05-03 07:49 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?