Instructor: 徐立群 (LihChyun Shu, shulc@mail.ncku.edu.tw)

Office: 63323研究室

The past four decades have witnessed enormous growth in the number and importance of database applications. Databases are used to store, manipulate, and retrieve data in nearly every type of organization. Database technology is routinely used by individuals on personal computers, by workgroups accessing databases on network servers and by all employees using enterprise-wide distributed applications. In the highly competitive environment of the 21^st century there is every indication that database technology will assume even greater importance. In this course, the subjects we will go through include but are not limited to the following:

1. Overview of database systems

2. Database design (ER model, schema refinement, etc.)

3. Relational model, relational algebra

4. SQL

5. Schema refinement and normal forms

6. Data warehousing and data mining

7. Other topics (if time permits)

Text:

R. Ramakrishnan and J. Gehrke. Database Management Systems, 3rd Edition, McGraw Hill, (新月圖書代理) 本書相關資料：http://www.cs.wisc.edu/~dbbook

Slides:

Chapter 1

Chapter 2 (Interview with Peter Chen by M. Winslett, SIGMOD Record, 33(1):110-118;

"English, Chinese, and ER diagrams" by Peter Chen, Data & Knowledge

Engineering, 23, 1997, pages 5-16)

Chapter 3 (A tribute to Edgar F. Codd by C.J. Date, SIGMOD Record, 32(4) :4-13)

Chapter 4 (part A)

Chapter 5

Chapter 19

大數據的理念與應用

Evaluation (subject to change):

Quizzes/attendance: 10%

HWs 30%

Term project: 20%

Midterm: 20%

Final exam: 20%