Method and system for providing a probe array chip design database
View Patent ↗Systems and method for organizing information relating to the design of polymer probe array chips including oligonucleotide array chips. A database model is provided which organizes information interrelating probes on a chip, genomic items investigated by the chip, and sequence information relating to the design of the chip. The model is readily translatable into database languages such as SQL. The database model scales to permit storage of information about large numbers of chips having complex designs.
1. A computer-readable storage medium having stored thereon:
a relational database comprising:
a probe table including a plurality of probe records, each of said probe records specifying a polymer probe for use in one or more polymer probe arrays;
a sequence item table including a plurality of sequence item records, each of said sequence item records specifying a nucleotide sequence to be investigated in said one or more polymer probe arrays; and
wherein there is a many-to-many relationship between said probe records and said sequence item records.
2. The medium of claim 1 wherein said relational database further comprises:
a tiling item table including a plurality of tiling item records, each of said tiling item records having an aggregation relationship with said probe records so that each tiling item record has many associated probe records.
3. The medium of claim 1 wherein said relational database further comprises:
a genomic item table including a plurality of genomic item records, each of said genomic item records specifying a genomic item to be investigated by said one or more polymer probe arrays; and
wherein there is a many to many relationship between genomic item records and sequence item records.
4. The medium of claim 1 wherein said relational database further comprises:
a chip design table including a plurality of chip design records, each of said chip design records specifying a design of a chip including a subset of said plurality of probe records.
5. A computer implemented method for operating a relational database comprising:
creating a probe table including a plurality of probe records, each of said probe records specifying a polymer probe for use in one or more polymer probe arrays;
creating a sequence item table including a plurality of sequence item records, each of said sequence item records specifying a nucleotide sequence to be investigated in said one or more polymer probe arrays;
storing data in said probe table and said sequence item table; and
wherein there is a many-to-many relationship between said probe records and said sequence item records.
6. The method of claim 5 further comprising the step of:
creating a tiling item table including a plurality of tiling item records, each of said tiling item records having an aggregation relationship with said probe records so that each tiling item record has many associated probe records.
7. The method of claim 5 further comprising the step of:
creating a genomic item table including a plurality of genomic item records, each of said genomic item records specifying a genomic item to be investigated by said one or more polymer probe arrays; and
wherein there is a many to many relationship between genomic item records and sequence item records.
8. The method of claim 5 further comprising the step of:
creating a chip design table including a plurality of chip design records, each of said chip design records specifying a design of a chip including a subset of said plurality of probe records.
9. A computer system comprising:
a processor; and
a storage medium storing a relational database accessible by said processor, said storage medium having stored thereon:
a relational database comprising:
a probe table including a plurality of probe records, each of said probe records specifying a polymer probe for use in one or more polymer probe arrays;
a sequence item table including a plurality of sequence item records, each of said sequence item records specifying a nucleotide sequence to be investigated in said one or more polymer probe arrays; and
wherein there is a many-to-many relationship between said probe records and said sequence item records.