Well, this database will have data coming from DNA microarray experiments. I
don't know if you have heard something about them. I just will tell you that
one single experiment generates 10000 rows of raw data. Imagine I want to get
the raw data of (just) 10 experiments to make some kind of statistical
analysis with them, this generates the 100000 rows I explained befored. The
field of Computational Biology is one of the most challenging ones, and even
more if we talk about bilogical databases, which must be able to store
enormous amount of data.... and now I begin to face this challenge!!

Regards,

Xavier.

A Divendres 08 Març 2002 10:00, vàreu escriure:

> At 03:25 PM 08-03-02 -0500, you wrote:
> >Well... the database is still under development, so I have only inserted
> > data to test it. Currently, the table "Spot" has over 9000 rows, and the
> > table "RawData" has over 18000. My Stored Procedure returns 18000 rows
> >approximately. In the future, the table "RawData" may contain up to a few
> >million (3 or 4). What will happen if I want to make a query with an ORDER
> > BY which returns 100000 rows or more? Will I allways have the same
> > problem? What do people do when they have tera-databases?
>
> They store, process and retrieve data. Perhaps you could get more specific
> responses to your questions if you explain a few things about the user
> requirements. I'm curious to know what a user is going to do with an
> output set of 100,000 rows of raw data.
>
> Helen
>
> All for Open and Open for All
> Firebird Open SQL Database · http://firebirdsql.org ·
> http://users.tpg.com.au/helebor/
> _______________________________________________________
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
Xavier Solé Acha (mailto:x.sole@...)
Servei d'Epìdemiologia i Registre del Càncer
Institut Català d'Oncologia
Av. Gran Via km. 2,7
08907 L'Hospitalet de Llobregat, Barcelona
Tel: +34 932 607 401
Tel: +34 932 607 787