Dear Jason:

We are using MySQL+PHP (version 4.3) in a Linux box.  We developed a 
custom  interface that is easy enough for any clinicians as well as 
research coordinators to enter data.  I use phpMyadmin when I want to 
export tables and etc. 

As for organizing data, we sort everything by two primary keys: case# 
and visit#.   This may not be very elegant approach but it's been 
working for our needs. 

Hope this helps,

Hedok




Jason Steffener wrote:
> Dear Hedok,
> Thank you for the reference. What interface are you using for the MySQL? I have a Windows PC here running EasyPHP and MySQL to host a simple internal wiki. This allowed me to just play around with the phpMyAdmin frontend software and it works and can do exactly what I would like, I think. The thing is the frontend is rather "complex." I am looking for something that those less geeky than I in the lab will also use and basically find easy to use. We have an Access database setup but most people try NOT to use it because they just dont like it. So that is what I am working against.
>
> Thank you,
> Jason.
>
> ----- Original Message ----
> From: Hedok Lee <[log in to unmask]>
> To: [log in to unmask]
> Sent: Wednesday, January 2, 2008 12:22:31 PM
> Subject: Re: [FSL] Database all MRI and NeuroPsych data
>
> Dear Jason,
>
> This paper may be relevant to what you want to do. 
>
> Improving the analysis, storage and sharing of neuroimaging data using
>  relational databases and distributed computing
> /NeuroImage/, /Volume 39, Issue 2/, /15 January 2008/, /Pages 693-706/
> Uri Hasson, Jeremy I. Skipper, Michael J. Wilde, Howard C. Nusbaum and
>  Steven L. Small
>
> In our lab, we store neuro-psych, neurology exams, demographics,
>  radiology ratings, and all of other clinical information in our database
>  server (Apache+MySQL).
>
> Hope this helps,
>
> Hedok
>
>
> ----- Original Message -----
> From: KC Stegbauer <[log in to unmask]>
> Date: Wednesday, January 2, 2008 11:40 am
> Subject: Re: [FSL] Database all MRI and NeuroPsych data
> To: [log in to unmask]
>
>   
>> Jason,
>>
>>     We've had a wonderful experience with Bioscribe, made by a
>>     
>  company
>   
>> called Vivalog (http://www.vivalog.com/bioscribe.html).  Data can 
>> be sent
>> over a standard DICOM connection to the database, which then 
>> automaticallyimports studies into appropriate "projects." Users 
>> control who has access to
>> data in each project.  The interface is https, so its secure.  
>> Additionaldata, including binary data, scripts, publications, 
>> scanned forms or
>> anything else you can think of, is securely uploaded using your web 
>> browser(also secure) or conveniently over secure WebDav.  
>>
>>     The web interface allows access to secure data upload/download
>>     
>  for
>   
>> single or multisite trials.  The server model makes it easy for us 
>> to meet
>> our other institutional requirements, such as physical security, 
>> offsitebackups and RAID storage. Obviously a single server is far 
>> easier to keep
>> administratively secure than multiple individual storage systems or 
>> CDs that
>> can be easily misplaced or stolen.
>>
>>     Sorry to sound like an advertisement, but the system has saved
>> enormous amounts of time at our site, easily paying for itself many 
>> timesover.  Anyone interested in a demo can feel free to contact me 
>> offline or
>> contact Vivalog directly.
>>
>> Best
>> KC Stegbauer
>>
>> -----Original Message-----
>> From: FSL - FMRIB's Software Library [mailto:[log in to unmask]] On 
>> BehalfOf Jason Steffener
>> Sent: Wednesday, January 02, 2008 6:20 AM
>> To: [log in to unmask]
>> Subject: [FSL] Database all MRI and NeuroPsych data
>>
>> Hello all. 
>> I hope that all have had a safe and great new years.
>>
>> I am looking for advice and maybe to start a conversation on the
>> organization of data. I am wondering what methods other labs use to 
>> organizeand provide an efficient means of searching a large 
>> database which contains:
>> MRIs/Neuropsych/Demographics. 
>>
>> I am just wondering what means people use to organize MRI data, 
>> organize by
>> study, by subject,  etc... Then what means to database the 
>> neuropsych and
>> demographics so that they are easily linked to the MRI data. 
>>
>> We have something in place but as we grow I am looking for a more 
>> efficientsetup.
>>
>> Thank you for any tips and advice.
>>
>> Jason.
>>
>>