Unanswered: desigining a db2 research db .. gui questions
hi .. im currently in the design phase of a new database that will someday publicly share a lot of the research data that my lab has been accumulating in the past few years.
the data is representative of 3d-structural information about some hearts
in short, what we want to do is
1. store our huge datasets (multiple files, 30 MB+ each)
2. process and query specific portions of these datasets (e.g., look at this portion of certain/all hearts and do a bunch of calculations)
3. have a good interface that will be able to not only take inputs and give numerical outputs, but also be able to
4. display graphs (e.g., histograms) and allow the person to
5. view (translate, rotate, zoom, etc.) some of our 3d models
6. in the long-term, all of this should be able to be done online, without downloading additional software (or if i do need to d/l an applet, it should be fairly small - no larger than a couple of mb)
ive worked out a table structure for how i want the data to be organized, and i have some of the equations worked out for our analysis. my questions are
1. should i make processing server-side or client-side?
2. i may end up caching some of the processed data somehow .. any recommendations of a good way to do this without 'wasting space'?
4. with respect to (3), are there benchmarks for performance speeds between these different languages? these datasets are huge and do take some good amount of time to process.
5. i plan to query info from the db using sql. should i do my calculations in java, or are there different recommended languages to use?
Installed applications and other software :
Java Application Development and Java Runtime Environment - v.184.108.40.206
DB2 UDB Enterprise Edition - v.220.127.116.11
DB2 Connect Enterprise Edition - v.18.104.22.168
IBM Visual Age C and C++ - v.6.0
IBM XL Fotran Compiler - v.22.214.171.124
Tivoli Storage Manager Backup/Archive Client - v.126.96.36.199
IBM HTTP Server - v.188.8.131.52
OpenSSH - v.3.4p1
Perl - v.5.6.1