Relational Databases for Biologists: Efficiently Managing ...
Relational Databases for Biologists: Efficiently Managing
and Manipulating Your Data
Session 1 Data Conceptualization and Database Design
Robert Latek, Ph.D. Sr. Bioinformatics Scientist Whitehead Institute for Biomedical Research
WIBR Bioinformatics and Research Computing, ? Whitehead Institute, 2005
What is a Database?
? A collection of data
? A set of rules to manipulate data
? A method to mold information into knowledge
? Is a phonebook a database?
? Is a phonebook with a human user a database?
Babbitt, S. Baggins, F. Bayford, A.
38 William St., Cambridge 109 Auburn Ct., Boston 1154 William St., Newton
555-1212 555-1234 555-8934
WIBR Bioinformatics and Research Computing, ? Whitehead Institute, 2005
Why are Databases Important?
? Data -> Information -> Knowledge ? Efficient Manipulation of Large Data
Sets ? Integration of Multiple Data Sources ? Cross-Links/References to Other
Resources
WIBR Bioinformatics and Research Computing, ? Whitehead Institute, 2005
Why is a Database Useful?
? If Database Systems Simply Manipulate Data, Why not Use Existing File System and Spreadsheet Mechanisms?
? "Baggins" Telephone No. Lookup:
? Human: Look for B, then A, then G ... ? Unix: grep Baggins boston_directory.txt (or Excel) ? DB: SELECT * FROM directory WHERE
lName="Baggins"
Babbitt, S. Baggins, F. Bayford, A.
38 William St., Cambridge 109 Auburn Ct., Boston 1154 William St., Newton
WIBR Bioinformatics and Research Computing, ? Whitehead Institute, 2005
555-1212 555-1234 555-8934
What is the Advantage of a Database?
? Find All Last Names that Contain "th" but do not have Street Address that Begin with "Th".
? Human: Good Luck! ? UNIX: Write a directory parser and a filter. ? DB: SELECT lName FROM directory
WHERE lName LIKE "%th%" AND street NOT LIKE "Th%"
WIBR Bioinformatics and Research Computing, ? Whitehead Institute, 2005
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- create a relationship to build a pivot table
- migrating and cleaning data using excel
- specifics of the tabular models for the operational data
- relational databases explained using microsoft excel for
- database access ampl
- relational databases for biologists efficiently managing
- using excel to prototype relational database applications
- relational database concepts for beginners
- spreadsheet table transformations from examples
- chapter 1 introducing excel ablest
Related searches
- free research databases for students
- databases for peer reviewed articles
- educational databases for students
- understanding databases for beginners
- databases for dummies pdf
- free databases for students
- free databases for college students
- free donor databases for nonprofits
- scholarly databases for nursing
- best databases for nursing research
- medical databases for research articles
- databases for educational research