高等資料庫系統

臺北科技大學 114-2 學期課程，課號 359550。

課程大綱

高等資料庫系統是一門深入探討資料庫設計、開發及管理的課程，旨在提供學生一個全面性的資料庫知識。課程從基本的實體關係模式開始，逐步介紹關聯模式、關聯代數和關聯計算等資料庫設計理論。隨後，課程將深入探討SQL的應用，包括資料定義語言、資料處理語言和資料控制語言，讓學生掌握實際操作資料庫的技能。同時，課程也會涵蓋資料庫正規化、功能相依性等重要概念，以確保學生的資料庫設計能力。在課程中期，課程將引入更進階的主題，如NoSQL資料庫、分散式資料庫和儲存技術，以及複雜的資料類型。此外，課程也會探討其他類型的資料庫系統，如物件導向資料庫、XML資料模型與語言等，並介紹檔案結構和索引技術，與交易管理、並行控制和資料庫回復技術等議題。在課程的最後階段，學生將根據自己的興趣和能力進行一個期末專題的設計和開發，並展示他們的作品。本課程融合理論和實務，讓學生獲得全面的資料庫知識和實際操作能力，為未來的資料庫管理和開發工作做好準備。 Advanced Database System is a course that provides an in-depth exploration of database design, development, and management, aiming to offer students a comprehensive understanding of database systems. The course begins with fundamental concepts such as the Entity-Relationship (ER) Model, and progressively introduces database design theories, including the Relational Model, Relational Algebra, and Relational Calculus. Subsequently, the course delves into the practical use of SQL, covering DDL, DML, and DCL, enabling students to acquire hands-on skills in database operations. Important concepts such as database normalization and functional dependencies are also addressed to strengthen students’ database design capabilities. In the middle stage of the course, more advanced topics are introduced, including NoSQL databases, distributed databases, storage technologies, and complex data types. The course also explores other types of database systems, such as object-oriented databases and XML data model and languages, and covers file structures and indexing techniques, as well as transaction management, concurrency control, and database recovery techniques. In the final stage of the course, students will design and develop a final project based on their individual interests and skill levels, and present their work. By integrating both theoretical foundations and practical experience, this course provides students with a broad database knowledge and practical skills, preparing them for future employment in database management and development.

課程進度

Week 1: Course Introduction Week 2: Entity Relationship Model Week 3: Relational Model & Relational Database Constraints Week 4: Enhanced Entity Relationship Model Week 5: Relational Algebra & Relational Calculus Week 6-7: SQL DDL, DML & DCL Week 8: Functional Dependencies & Database Normalization Week 9: Mid-exam Week (Submit Final Project Proposal) Week 10: Database Frameworks & Web Applications Week 11-12: NoSQL Databases Week 13-14: Distributed Databases Week 15: Complex Data Types & Other Types of Database Systems Week 16: File Structures and Indexing Week 17: Transactions, Concurrency Control & Database Recovery Techniques Week 18: Oral Presentation of Final Projects

評量方式

Assignments Practical exercises Proposal of final projects Final course project Class attendance & involvement

教材

【遵守智慧財產權觀念，請使用正版教科書，不得使用非法影印教科書】 使用外文原文書：是 1. Fundamentals of Database Systems 7/e, Elmasri and Navathe, Pearson. 2. Database System Concepts 7/e, Silberschatz, Korth, and Sudarshan, McGraw-Hill Education. 3. 資料庫的核心理論與實務 8/e, 黃三益, 前程文化 4. 資料庫系統原理與應用 3/e, 顏春煌, 碁〇