National Taiwan Normal University Course Outline
Spring , 2022

@尊重智慧財產權,請同學勿隨意影印教科書 。
Please respect the intellectual property rights, and shall not copy the textbooks arbitrarily.

I.Course information
Serial No. 0482 Course Level Master
Course Code ISM0429 Chinese Course Name 資料庫管理研究
Course Name Studies in Database Management
Department Graduate Institute of Library and Information Studies
Two/one semester 1 Req. / Sel. Sel.
Credits 3.0 Lecturing hours Lecture hours: 3
Prerequisite Course ◎1. This is a cross-level course and is available for junior and senior undergraduate students, master's students and PhD students. 2. If the listed course is a doctroal level course, it is only available for master's students and PhD students.
Comment
Course Description
Time / Location Thur. 2-4 Main 25-01
Curriculum Goals Corresponding to the Departmental Core Goal
1. 資料庫的發展沿革,RDBMS 與XML DB,XML DB 相關技術,效能探討 Master:
 2-2 Ability to manage and utilize digital and Internet technology
 3-1 Learn independently and being innovative and adaptable
 4-1 Develop people-centered thinking and value knowledge. Facilitate the freedom and the usability of knowledge with information technology and innovative services

II. General Syllabus
Instructor(s) SHIEH, Jiann-Cherng/ 謝建成
Schedule

 

一、 教學目標:
1. 資料庫概念
2. 資料分析模式
3. 資料庫管理系統運作
4. 認識data warehouse及data mining概念
5. 瞭解資料整合、資料清理的意義與方法
6. 應用案例實

二、 教材內容:

課程大綱
1.    Introduction
2.    Database Analysis
    Data Modeling
    ER Modeling
3.    SQL
    SQL Practice
4.    Database Management
    Concurrency Control
    Dead Lock
5.    Advanced Databases
    Trigger and Stored Procedures
    Data Warehouse and Data Mining
    Data Warehouse Models
    Concept Hierarchy
    Data Mining Process
    Data Mining Methods
6.    Database Practice
    ACCESS
    SQL Server
    MySql
7.    Bibliomining



三、 實施方式:
課堂報告、討論
成績計算:
期中、期末考試各 25%
報告討論:20%
實作報告:利用SQL Server或 MySql實作一資料倉儲與資料探勘案例 30%

四、 參考書目:
1. Carlos Coronel & Steven Morris, Database Systems: Design, Implementation and Management, 13th ed. Cengage Learning, 2018(上課用教科書)
2. UML系統分析與設計,游峰碩,學貫
3. Data Mining Concepts and Techniques 2nd Edition,Jiawei Han & Micheline Kamber,Morgan Kaufmann Publishers
4. 2018Data Modeling實務 真野 正著 / 博碩文化 譯.
5. 資料探勘,曾憲雄等,旗標
6. SQL Server 2005資料採礦聖經,尹相志,學貫行銷
7. 書目探勘,2009,謝建成,文華圖書

 

 

Lecturing Methodologies
Methods Notes
Formal lecture 課堂上課
Group discussion 課堂報告分享心得
Field work 個案實作分析
Case studies 個案研究發展
Grading assessment
Methods Percentage Notes
Midterm Exam 25 % 考試
Final exam 25 % 考試
Presentation 20 % 課堂報告
Case study reports 30 % 利用SQL Server或 MySql實作一資料倉儲與資料探勘案例
Required and Recommended Texts/Readings with References

參考書目:

1. Carlos Coronel & Steven Morris, Database Systems: Design, Implementation and Management, 13th ed. Cengage Learning, 2018(上課用教科書)
2. UML系統分析與設計,游峰碩,學貫
3. Data Mining Concepts and Techniques 2nd Edition,Jiawei Han & Micheline Kamber,Morgan Kaufmann Publishers
4. 2018Data Modeling實務 真野 正著 / 博碩文化 譯.
5. 資料探勘,曾憲雄等,旗標
6. SQL Server 2005資料採礦聖經,尹相志,學貫行銷
7. 書目探勘,2009,謝建成,文華圖書
8. 相關期刊論文(以圖書館應用為主)