Syllabus(教學大綱)

This is the first course in database systems. Therefore we will start with the fundamental concepts and move gradually toward modern database systems. Topics marked with ** will only be covered when time permits.

Introduction (資料庫系統簡介)

• Basic concepts(資料庫系統基本概念)
• History of database systems(資料庫系統發展歷史回顧)
• Applications of database systems(資料庫系統應用)

Relational Models and Languages (關聯式模型和語言)

• Relational data model and constraints(關聯式資料模型與約束條件)
• Relational database architecture(關聯式資料庫架構)
• Relational algebra and calculus(關聯式代數與關聯式計算)**
• Basic SQL(關聯式查詢語言SQL基礎)
• Intermediate SQL(中級SQL)
• Advanced SQL(進階SQL)**

Conceptual Modeling and Database Design (概念模式化與資料庫設計)

• Conceptual modeling(概念模式化)
• Database design process(資料庫設計程序)
• Entity Relationship data modeling(ER資料模型)
• Enhanced Entity Relationship data modeling(EER資料模型)
• ER/EER to relational database mapping(從ER/EER模型到關聯式資料庫設計)

Relational Database Design (關聯式資料庫設計)

• RDB design concepts(關聯式資料庫設計概念)
• Functional dependencies(函數相依)
• Normalization(正規畫)
• Further normalization(進階正規畫)
• Design algorithms(設計演算法)
• Application design(關聯式資料庫應用設計)

Database Application Design (資料庫應用設計)

• Database application architecture(資料庫應用架構)
• Introduction to open source DBMS: MySQL and PostgreSQL(開放式資料庫管理系統簡介: MySQL 與 PostgreSQL)
• Database application design: PHP/MySQL, Python/PostgreSQL(資料庫應用設計: PHP/MySQL, Python/PostgreSQL)

Big Data and Analytics (大數據與資料分析)

• Introduction to big data(大數據簡介)
• Big data storage(大數據儲存系統)
• NoSQL, NewSQL and Distributed SQL databases(NoSQL, NewSQL與Distributed SQL資料庫)
• Big data processing and cloud database(大數據處理與雲端資料庫)
• Big data analytics(大數據分析)

DBMS Technologies (資料庫管理系統技術)

• DBMS architecture(資料庫管理系統架構)
• Storage structure and system(儲存架構與系統)
• Indexing methods(索引方法)
• Query processing(查詢處理)
• Query optimization(查詢最佳化)

Transaction Management (交易管理)

• Transaction concepts and system architecture(交易概念與系統架構)
• Transaction processing(交易處理)
• Concurrency control(並行控制)
• Recovery(交易回復)

Parallel and Distributed Databases (平行與分散式資料庫)**

• High performance database system architecture(高效能資料庫架構)
• Parallel and distributed storage(平行與分散式儲存系統)
• Parallel and distributed query processing(平行與分散式查詢處理)
• Parallel and distributed transaction management(平行與分散式交易管理)

Object-Oriented Databases (物件導向資料庫)**

• Object-oriented concepts(物件導向概念)
• Object data models(物件資料模型)
• Object-oriented databases(物件導向資料庫)
• Object database languages(物件資料庫語言)
• Object relational databases(物件關聯式資料庫)

Semi-structured Data and XML (半結構化資料與XML)**

• Semi-structured data(半結構化資料)
• XML concepts(XML基本概念)
• XML query language XPath(XML查詢語言XPath)
• XML query language XQuery(XML查詢語言XQuery)
• XML databases(XML資料資料庫)

Internet of Things(IoT) and Streaming Data Management (物聯網與串流資料管理)**

• Introduction to Internet of Things(物聯網簡介)
• Characteristics of streaming data(串流資料特性)
• Data stream processing(串流資料處理)
• Data stream management systems DSMS(串流資料管理系統)

Advanced Topics (進階議題)**

• Data mining and data warehousing(資料探勘與資料倉儲)
• Mobile data management(行動資料管理)
• Multimedia databases(多媒體資料庫)
• Blockchain databases(區塊鏈資料庫)