Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How will importing microarray data into ArrayTrack™ affect the space increase in the local Oracle database?

0
Posted

How will importing microarray data into ArrayTrack™ affect the space increase in the local Oracle database?

0

The microarray data files vary in size based on the array types and the format of the data file. A data file in .txt format will only occupy a small amount of space in the Oracle database as compared to at the OS level. But if you choose to perform further normalization of this imported .txt file, you need to remember that the normalized data will also occupy space in the database. Affymetrix data is a little different. When Affymetrix data is saved to the database, ArrayTrack™ not only saves the original cell files as BLOB type, but also saves the converted cel files if the user applies MAS5 (default), RMA, Plier, DChip, etc. It parses the data files into individual records and stores them in the RAW intensity table. If the data is normalized then it is also stored separately. There are indexes that will occupy space as well. So the space required in the ArrayTrack™ database to store all this information about an Affymetrix data file will be significantly (about four times) bigger tha

Related Questions

Thanksgiving questions

*Sadly, we had to bring back ads too. Hopefully more targeted.