Jump to ContentJump to Main Navigation
Building Bioinformatics Solutions$
Users without a subscription are not able to see the full content.

Conrad Bessant, Darren Oakley, and Ian Shadforth

Print publication date: 2014

Print ISBN-13: 9780199658558

Published to Oxford Scholarship Online: April 2014

DOI: 10.1093/acprof:oso/9780199658558.001.0001

Show Summary Details
Page of

PRINTED FROM OXFORD SCHOLARSHIP ONLINE (www.oxfordscholarship.com). (c) Copyright Oxford University Press, 2019. All Rights Reserved. An individual user may print out a PDF of a single chapter of a monograph in OSO for personal use. date: 11 December 2019

Building biological databases with SQL

Building biological databases with SQL

Chapter:
(p.21) Chapter 2 Building biological databases with SQL
Source:
Building Bioinformatics Solutions
Author(s):

Conrad Bessant

Darren Oakley

Ian Shadforth

Publisher:
Oxford University Press
DOI:10.1093/acprof:oso/9780199658558.003.0002

In this chapter the process of building a relational database is explained, using a real-world biological example as a case study. The entire process is covered, from deciding which information to store and how to design the database schema, through to the implementation of the database using the MySQL relational database management system (RDBMS). Retrieval of information from the database, using increasingly complex queries, is also explained. Alternatives to MySQL are also discussed.

Keywords:   batabases, data modelling, database design, MySQL, SQL, RDBMSs, bioinformatics

Oxford Scholarship Online requires a subscription or purchase to access the full text of books within the service. Public users can however freely search the site and view the abstracts and keywords for each book and chapter.

Please, subscribe or login to access full text content.

If you think you should have access to this title, please contact your librarian.

To troubleshoot, please check our FAQs , and if you can't find the answer there, please contact us .