Samples And Data Database For A Lab
2
1
Entering edit mode
10.3 years ago

Hi everybody,

In my lab we are looking for a solution for a database for the samples and the results. The main purpose of this database is to centralize all the data of the project (so HTS results, µarray, qRTPCR ) and the descriptions of the samples. A user-friendly interface is very important (to consult and fill the DB ).

Any idea ?

Thanks,

N.

database • 5.0k views
ADD COMMENT
2
Entering edit mode
10.3 years ago
Thaman ★ 3.3k

Modern LIMS have implemented extensive configurability as each laboratory's needs for tracking additional data points can vary widely. The LIMS may then import instrument results files to extract data for quality control assessment of the operation on the sample.

Modern targeted assays such as qPCR and deep sequencing can produce tens of thousands of data points per sample. Furthermore, in the case of drug and diagnostic development as many as 12 or more assays may be run for each sample. In order to track this data, a LIMS solution needs to be adaptable to many different assay formats at both the data layer and import creation layer, while maintaining a high level of overall performance. (source :http://en.wikipedia.org/wiki/Laboratory_information_management_system#LIMS_configurability)

Designing database based on the samples and the results depends upon following things/steps:

  • Understanding file (samples or result) properties (name, author, date, location, no of sample)
  • Designing Database Schema (tables) based on the properties of files (sample or result) and relationship
  • Choosing Database Management tool (Mysql, postgresql, oracle, MongoDB etc)
  • Programming language
  • Designing parser to map needed file information into database.
  • After mapping file content to database, Build GUI to query to the database.

These are the basic principles if you want to design database from files (sample or result)

Hope it help

ADD COMMENT
0
Entering edit mode

I've some skills in SQL and mysql. The design of the DB is done. For you which DB management tool is the best (and easiest) ? For the GUI, which one do you recommend ?

Thanks

ADD REPLY
0
Entering edit mode

You are going to build some LIMS so Mysql or postgresql can fit your need

ADD REPLY
0
Entering edit mode

Thanks ! For the Gui, what's the easiest and simpliest one to put in place ?

ADD REPLY
0
Entering edit mode

Obviously web (Django, PHP, web2py, cherryPy) framework

ADD REPLY
1
Entering edit mode
10.3 years ago

Some people at the Bioinformatics Support Facility in my institute have developed a software to manage all the samples and experiment protocols, based on MediaWiki. It is called Lab Service Wiki. Maybe you can ask them if they are going to make their software freely available.

In any case, did you look at the other discussions in Biostar? There are many similar topics.

ADD COMMENT

Login before adding your answer.

Traffic: 2487 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6