Theory for bioinformatics Flashcards
What are databases
It is a collection of information stored in a computer medium that can be easily accessed and manipulated.
It is an electronic filling system.
What is a biological database
Collection of biological data
What are the uses of database?
Handle, share and manage large volumes of biological data.
Store Maintain Enter Search Sort Retrieve and Analyze Present or Display
What are the 3 general functions of databases?
Support large-scale analysis efforts
Make data access easy and updated
Use knowledge from various fields of biology and medicine.
Fields
A particular data about a person or thing stored in a database. Usually, it is the column of the table.
Field type/attribute
The properties of a data of a particular field such as strings, numeric, date etc
Record and entries
A set of fields within a table that are relevant to a specific entity.
Primary key
Unique identifier of a record or a field unique to the record.
Secondary key
A field used to link up a table with other tables in a database.
Relational database
A complex database with many tables and linked by different secondary keys.
Choose the primary key in a relational database
Choose a key that has items that are not duplicated.
A primary key can also be a secondary key if it links up another key
What are bibliographic databases?
They contain scientific literature
Examples: Pubmed and ScienceDirect
What are taxonomic databases?
They contain classification
Examples: Integration taxonomic information system itis.gov, Biodiversity information standards tdwg.org and ncbi taxonomy.
What are nucleic acid databases?
They contain DNA information
Examples: NDB, EMBL-Bank, GenBank, DDBJ
What are genomic databases?
They contain genome level information
Examples: Ensembl Genome Browser, UCSC Genome Browser, WormBase, AceDB, Comprehensive Microbial Resource and FlyBase