Question: How to create a back-end database of gene expression data
gravatar for Javad
12 months ago by
Javad90 wrote:

Dear all,

I have a question regarding database management. I would be really grateful if somebody here can help me. I have a table with 100,000 columns and 30,000 rows that I would like to store it in a back end database like SQLite or mySQL. The problem is that programs like SQLite have a limitation regarding the number of columns and rows that can be stored in a data base. For instance, SQLite only stores data in database if the number of columns doesn't exceed 2000 columns whereas in my own data set I have way more columns. My question is how I can store my data in a database in the most efficient way?

Take into account that I do not have any redundancy in my table. In my table the rows are genes and columns are single cells and each element in the table represents the normalized value of gene expression.

Thank you in advance for your help.

Best regards

rna-seq • 251 views
ADD COMMENTlink written 12 months ago by Javad90
Please log in to add an answer.


Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1640 users visited in the last hour