一、 課程說明 (Course Desc<x>ription) 
<br>
<br>This course provides an overview of the current databa<x>se management 
<br>systems. The goals are 1) to get students familiar with how to use a databa<x>se 
<br>system to solve real problems; 2) the internals of a databa<x>se and some state-
<br>of-
<br>the-art implementations (e.g., MySQL, PostgreSQL etc.).
<br>
<br>Proper understanding of Java/OOP programming and data structure is required.
<br>剛修完作業系統、演算法，對大型程式系統有興趣之學生優先。 
<br>
<br>二、 指定用書 (Textbook) 
<br>Lecture Notes 
<br>
<br>三、 參考書籍 (References) 
<br>[1] Databa<x>se Management Systems, 3ed, by Raghu Ramakrishnan et al., ISBN: 
<br>0072465638
<br>[2] Databa<x>se System Concepts, 6ed, by Abraham Silberschatz et al, ISBN: 
<br>0073523321
<br>[3] Databa<x>se Design and Implementation, by Edward Sciore, ISBN: 0471757160
<br>[4] Principles of Distributed Databa<x>se Systems, 3ed, by M. Tamer Ozsu, iSBN: 
<br>1441988335
<br>
<br>四、 教學方式 (Teaching Method) 
<br>Lecture and Lab 
<br>
<br>五、 教學進度 (Syllabus) 
<br>1.	Introduction to databa<x>se systems
<br>    A.	Relational model, SQL, transactions, and ACID (with quiz)
<br>    B.	Modern databa<x>se systems for scalability, availability, and elasticity 
<br>2.	Query engine
<br>    A.	JDBC and DB server
<br>    B.	Relational algebra
<br>    C.	Query plans, scans, and the storage interface
<br>    D.	Parsing
<br>    E.	Planning 
<br>3.	Storage engine
<br>    A.	Disk and file management
<br>    B.	Memory management
<br>    C.	Transaction management (+OCC)
<br>    D.	Record management
<br>    E.	me<x>tadata management 
<br>4.	Benchmarking with TPC-C
<br>5.	Optimizations
<br>    A.	Indexing
<br>    B.	Materialization and sorting
<br>    C.	Multi-buffer plans
<br>    D.	Query optimization  
<br>6.	Distributed databa<x>se systems and advanced topics
<br>    A. NoSQL databa<x>se systems
<br>    B. NewSQL databa<x>se systems
<br>    C. OLAP and datawarehousing
<br>
<br>六、 成績考核 (Evaluation) 
<br>Midterm Exam 20% 
<br>Homework 60% 
<br>Term Project 20%
<br>