Principles of Biological Databases

ISBN Number : 978-93-5097-692-0

Student Price : Rs.475

Student Dollar Price : 19$

Library Price : Rs.950

Library Dollar Price : 38$

Book Edition : First

Year of Publication : 2013

No. Of Pages : 348

Book Weight :482

About The Book

This book starts right from the basics with databases and Structured Query Language (SQL). Prior database or SQL knowledge is not necessary, as this book covers everything from database design to creating your first database and understanding how the SQL language is used with databases. You will need to follow its instructions for creating the book’s gene database, as this is used for all the examples in SQL.

The objective of Section I, Chapters 1 to 8 is to understand the basic concepts and practices that can be used during design and development of biological database systems. The course contents put more emphasis on Relational Database Management Systems (RDBMS) as it is an accepted database standard for biological systems and present it in a more detailed manner. Entity Relation Modeling and schema representation have been covered extensively through a case study along with third form normalization with a case study. At the end of the Chapter 8, Centralized Database approach has been described briefly with an illustration. Most of the biological systems present in today’s word are centralized.

The Chapters 9 to 14 will focus on Structured Query Language, or SQL as it is usually abbreviated. SQL is useful to create the biological database and inserting and extracting biological data. Therefore, going through Chapters 1 to 8 is essential to understand the theory and concepts behind database systems. The SQL examples in Chapters 10 and 11 comply with the modern SQL standards set by organizations such as the American National Standards Institute (ANSI) and the International Standards Organization (ISO). The SQL queries in this chapter are supported by most modern database systems.

PL/SQL, DBA and transaction management and performance tuning, etc., are outside the scope of this book. However, Chapters 10 and 11 explains about trigger mechanism, various roles in database and modes of transactions in DBMS. SQL queries that are related to some mathematical functions and string functions, but left and right outer joins (both left and right) have not been addressed in Section I. Therefore, the reader is requested to refer to SQL manuals for any missing content. The database is created and tested using Oracle 8i, 9i and 10g versions. In the appendix, a cursory view of Oracle basics and PL/SQL has been provided as a reference for those who are new to these concepts.

Chapters 14 to 21 explain briefly the basic concepts in data warehouse, approaches to data warehouse building, steps to build a warehouse including dimensional modeling and at the end of the section a case study in plant bioinformatics has been presented with an example to understand the steps involved in warehouse process for building data marts for analysis.

In the second part of the book, many important biological databases and their uses in biology has been described. Since too large number of biological databases exist in literature, only a selected few (those that are often referred by biologists) are described in this book. Types of databases, models of databases, primary nucleic acid and protein databases, secondary protein databases, composite sequence databases, meta-databases, genomic, proteomic and other databases have been described in detail. Search engines for literature have been added for gaining access to the published literature in Journals and Books. Major genome projects (about 19), genomic databases of human, animals, fungi, microorganisms, plant crop genome databases have been described in brief. Finally, organellar and pathway databases have been added.


Contents :

Section I : Database Principles for Biologists
1. Introduction
2. Database Development
3. Data Models
4. The Entity-Relationship Model
5. Integrity Constraints
6. Rules In Relation Model
7. Nornalization and Schema Design
8. Case Study
9. SQL Overview
10. Elements of SQL
11. Advanced Queries
12. SQL*Plus
13. Data Dictionary
14. Transactional Database
15. Data Warehouse
16. Biological Data Warehousing Steps
17. Data Warehousing Lifecycle
18. Data Warehouse Design
19. Dimensional Modeling Types
20. OLAP and OLTP
21. Case Study − Plant Bioinformatics
Section II : Biological Databases
22. Introduction to Biological Databases
23. Types of Databases
24. Models of Databases
25. Primary Nucleic Acid Databases
26. Primary Protein Data Banks
27. Secondary Protein Databases
28. Composite Sequence Databases
29. Meta-Databases
30. Genomic, Proteomic and Other Databases
31. The Search Engines for Literature
32. Genome Projects and Genomic Databases of Human, Animals, Fungi and Microorganisms
33. Plant and Crop Genome Databases
34. Organellar Databases
35. Pathway Databases
36. Glossary
37. Index

About The Author

L.N. Chavali has over two decades of progressive engineering and IT experience. He has contributed to the design and development of leading edge technologies and complex IT applications in different domains for global customers using state-of-the art processes. He is a visiting faculty at Osmania University and other Indian Universities teaching students of bioinformatics. He has publications and also authored the book `Bioprogramming and Bioinformatics in C`.

Prof. P.B. Kavi Kishor: born in Andhra Pradesh, India on 29th March, 1951. Educated from M.S. University, Baroda 1976-1981 (Ph.D.); Center for Biotechnology, Ohio State University, Columbus, Ohio, USA 1992-1994. Currently working as Emeritus Professor, Department of Genetics, Osmania University, Hyderabad, 500 007. Served as Professor of Genetics, 1994 to 2011, Coordinator, UGC-SAP, 1998-2006, Chairman, BOS in Biotechnology 2001-2004, Head, Department of Genetics 2004-2006, Chairman, Board of Studies in Genetics 2006-2008, Coordinator, Biotechnology Course 2010, Member, Academic Senate 2006-2011.

Awards / Honours: Received a Gold Medal in 2012 from the Academy of Plant Sciences, India, Gold Medal from the Association of Biotechnology and Pharmacy, India, received A.P. State Best Teacher Award in 2008; Worked as Visiting Fellow, Linkoping University, Linkoping, Sweden in 2004; Visiting Fellow, Emory University, Atlanta, Georgia, USA, 2000; Rockefeller Foundation Fellowship, Ohio State University, Columbus, Ohio, USA, 1992; ISCA, received Professor Hiralal Chakravarthy Award in 1990. He is a Fellow of the National Academy of Sciences, Allahabad; Fellow of the National Academy of Agricultural Sciences, New Delhi; Fellow of the A.P. Akademi of Sciences; Honorary Fellow of Association of Biotechnology and Pharmacy; Fellow of Indian Botanical Society; Elected Fellow, Plant Tissue Culture Association, India.

Currently concentrating his research on Plant Physiology and Plant Biotechnology.

Book Reviews

Login Form