Hi Guys,
I am looking for a tool, a software that enables the fast and easy metadata database management. Our group receives constantly samples' metadata from our biological partners. These data now is all Excel table .csv and I encountered more and more difficulties to manage those heterogenous data, I spent sometimes a whole day to manually clean them.
The main challenge is the multi-omics integration, a subject has more than one sampling location with mutiple technique methods/experimental factor from different partners group == a completely mess.
Excel is no longer suitable for this task, I know that I have to move to a relational database, sql for the data management. The question is, I learned sql when I was a graduated student (7 years ago) and did not practice it anymore. At that time, half of my classmates got their internship for sql management ^^, their job was to enter and commit new data into database, basically it needs a person to do the job.
Sadly for my work now, I need to do the data analysis and project management and research....
So I am thinking about, after all those years past, is there now a good tool for easy data management with relational database and graphic interface for building, modifying, sharing. And convivial for biologist so they can put the data themselves with controlled languages?
Thanks in advance
