Hi all -
I’m moving to a new lab and have the opportunity to determine a general databasing solution for the lab. I’ve found relatively little to guide me in how to do this online, so I’d thought I’d ask for any leads. The broad remit is:
- manage data from 500+ subjects across multiple studies, sessions
- store demographic, physical, physiologic measurements, plus store/link/(view?) inputs, QC and outputs of imaging analysis pipelines (MRI and EEG)
- generation of forms to be filled out e.g. on tablets/paper by non-academic staff
- easy interface with languages such as Python,R to automate calculation derivatives of raw data
- ease of use such that PhD students could create new data forms for new studies, and compile new datasets via a query engine
- high level of security, flexible access settings, etc
- established software, open source etc.
- flexible and robust data storage and server setup
At the same time, we’ll be reviewing our imaging data analysis flows, e.g. storing raw data BIDS compliantly, standardising analysis outputs and simplifying the storage of results/pipelines and submission to online repositories.
It is challenging to decide on things like backend database, and whether to focus on general database solutions or the various newer projects focused on science/neuroimaging. The preference would be not to have to spend extensive time with the initial setup or maintenance - i.e. use contractors if feasible - but I’m wary of ending up with complex all-in-one solutions from this. I’d be very interested to hear if people have pointers, recommendations, or similar issues in their lab.