BSC 4434 Lecture Notes - Lecture 2: Query Language, Genbank, Relational Database
Document Summary
Information is stored in records and fields . They must contain data of the same type. Records contain data that is related to one object. A spreadsheet can be considered a database. Can search for a term within just one field or combine searches across several fields. Biological research has changed with daily use of databases. Biological databases - libraries of life sciences information collected from scientific experiments, published literature, high throughput experiment technology and computational analyses. Advantage is that it be queried by structured query language or sql queries. Relational database with a flat file format output. Can be searched in ways that it was designed to be searched. Can search within a specific field in a specific table. Sometimes can combine searches from the different fields. Some fields apply to protein but not dna. Better to create a separate spreadsheet format for protein records. Different tables are linked by key fields. More than just dna and protein sequences.