生物資料庫理論與實作
Biological Databases: Theories and Practice
| 節 | 週二 |
|---|---|
2 09:00–09:50 | 生物資料庫理論與實作 BI304 3 節連堂 |
3 10:10–11:00 | |
4 11:10–12:00 |
* 根據陽明交大上課時間表所列
This course focuses on the design and implementation of biological database systems, it also discusses contemporary concepts and approaches about web interface design for database access and data management. We start from the different natures of biological data, information and knowledge, then study suitable methods and tools for storing and accessing them. Topics such as database management system (DBMS), structured query language (SQL), database design, data warehousing, web programming for accessing database, knowledge mining and management, and big data analytics for biomedical applications are covered.
Basic concepts or knowledge of Molecular Biology, Bioinformatics, and Programming
Lectures, Discussion, and Hands-on Practice
Assignments (20%) + Midterm Exam (30%) + Final Project (50%)
| 週次 | 主題 |
|---|---|
| 第 1 週 | Course Introduction and Biological Databases |
| 第 2 週 | Database System Architectures and Relational Model |
| 第 3 週 | Introduction to SQL I |
| 第 4 週 | SQL Practice (Self-study) |
| 第 5 週 | Natioanl Day Holiday |
| 第 6 週 | Introduction to SQL II |
| 第 7 週 | Database Schema and Entity-Relationship Model |
| 第 8 週 | Midterm Exam |
| 第 9 週 | Application Design and Database Connection |
| 第 10 週 | PHP Programming and Web Interface Design I |
| 第 11 週 | PHP Programming and Web Interface Design II |
| 第 12 週 | Introduction of Biological Databases |
| 第 13 週 | Database Design and Normalizations |
| 第 14 週 | Data Warehousing and Knowledge Mining |
| 第 15 週 | Final Project Presentation |
| 第 16 週 | Final Project Presentation |
1. Abraham Silberschatz, Henry F. Korth, S. Sudarshan, “Database System Concepts”, McGraw Hill, Sixth Edition. 2. WCGs (Web Code Geeks), “PHP Programming Cookbook” 3. Kai Hwang and Min Chen, “Big-Data Analytics for Cloud, IoT and Cognitive Computing”, WILEY, First edition.
- 地點
- Room 317, BioICT Building, Poai Campus (博愛校區賢齊館三樓 BIO317)
- 時間
- Wednesdays 14:00 - 17:30
- 聯絡方式
- leetzongyi@nycu.edu.tw / 03-5712121 #56947