Top Posters
Since Sunday
5
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
New Topic  
gopat gopat
wrote...
13 years ago
All,
Earlier this year, I needed to migrate my my tree breeding data and experiments from a collection of spreadsheets to a database application. I could not find an open source application that met my needs so I rolled my own.  It has the following characteristics:

  • PostgreSQL database backend.
  • A database schema that supports relationships from high level Plant Taxa, plant, family and Test Types right down to the nitty gritty Test Detail/Score levels.
  • A database schema that supports the concept of virtual columns that map to custom Test Type database views.  This allows for a variety of custom test types, details and scoring combinations.
  • A PHP database frontend tool that can allow the user to: CRUD changes, display tables/views and execute native SQL, export to various CSV formats and has smart query input boxes (eg. http://www.gosu.pl/dbkiss/ ).
  • The ability to integrate seamlessly with spreadsheets for ease of use and mass import/exports.
  • Built in regression and load test components for rapid application development and later modifications.

The essense of this process is to integrate diverse data from a variety of spreadsheets into a repository (aka database). Then one could export specific data sets for further analysis in a stats package like the R Statistics application, which is widely used in the scientific field. From my standpoint, I think of it as "Business Intelligence for Plant Breeders"...

Here is a graphic of the open4stdb table schema: http://tiny.cc/open4stdb] [url]http://tiny.cc/open4stdb[/url].  The open4stdb system relies on metadata by storing URLs for external content such as web pages for existing protocols or photos (eg. links to Picasa pages).

I think this application may be too specific for high school and even college use.  However, it could be adapted to fit most any science subject (e.g. biology, botany, physics, etc), any subject that relates to experiments.  Would a generic application like this be useful for high school/college?  Or is there an existing application that does this better?
Thanks!
Read 845 times
1 Reply
Replies
wrote...
Educator
Top Poster
13 years ago
This is, in my opinion, far too complex to integrate in a high school program. I think you would have to try much harder to sell your idea because it seems complicated.

Related Topics

New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1282 People Browsing
Related Images
  
 289
  
 152
  
 1648
Your Opinion
Which 'study break' activity do you find most distracting?
Votes: 741

Previous poll results: How often do you eat-out per week?