TOCEC
邏輯學,工程
層級: 課程資料
媒體: 影音 講義

10802資料庫系統概論

2020-02-01-2020-06-30

國立清華大學 資訊工程學系 吳尚鴻

關鍵字: 資料庫系統概論 database systems 資料庫系統 Introduction to Database Systems databases sql java programming

This course provides an overview of the current database management systems. The goals are 1) to get students familiar with how to use a database system to solve real problems; 2) the internals of a database and some state-of- the-art implementations (e.g., MySQL, PostgreSQL etc.).


【課程說明】
          Course Description
This course provides an overview of the current database management systems.
The goals

♠ are 1) to get students familiar with how to use a database system to solve  
 real problems; 2)
the internals of a database and some state-of-the-art implementations 
  (e.g.,Google BigTable,
Google MegaStore, and Google Spanner etc.).
Proper understanding of Java/OOP programming and data structure is required.
     剛修完作業系統、演算法,對大型程式系統有興趣之學生優先。
 

【指定用書】
         Textbook
  Lecture Notes
 


【參考書籍】
           References
[1]Database Management Systems, 3ed, by Raghu Ramakrishnan et al., 

ISBN:0072465638
[2] Database System Concepts, 6ed, by Abraham Silberschatz et al,

ISBN:0073523321
[3] Database Design and Implementation, by Edward Sciore,

ISBN: 0471757160
[4] Principles of Distributed Database Systems, 3ed, by M. Tamer Ozsu, 

 iSBN:1441988335
 
 
【教學方式 】 
          Teaching Method
 
 Lecture and Lab
 


【教學進度】
         Syllabus
 
1Introduction to database systems
 A. Relational model, SQL, transactions, and ACID (with quiz)
 B. Modern database systems for scalability, availability, and elasticity
2.Query engine
 
A. JDBC and DB server
B. Relational algebra
C. Query plans, scans, and the storage interface
D. Parsing
E. Planning
3.Storage engine
 
A. Disk and file management
B. Memory management
C. Transaction management (+OCC)
D. Record management
E. metadata management
4.Benchmarking with TPC-C
5.Optimizations
 
A. Indexing
B. Materialization and sorting
C. Multi-buffer plans
D. Query optimization
6.Distributed database systems and advanced topics
 
A. NoSQL database systems
B. NewSQL database systems
C. OLAP and datawarehousing
  

 

前往課程 View Course
http://ocw.nthu.edu.tw/ocw/index.php?page=course&cid=257&
https://www.youtube.com/playlist?list=PLS0SUwlYe8cyln89Srqmmlw42CiCBT6Zn