Database System Fundamentals Database Design, ACID Properties, Concurrency Control, Indexes and Query Optimization, NoSQL Databases, CAP Theorem, Sharding and Replication
考察:Quiz, Homework
授课1小时; 学习2小时
2
Implement a single server database service system, which support: Basic data operations (CRUD), Index create and Query, Data partitioning
考察:Coding Assignment
授课2小时; 学习2小时
3
Design a distributed geospatial information system. Implement the indexing and query engine.
考察:Coding Project
授课3小时; 学习4小时
4
Implement the data partitioner. Try different partitioning methods to understand their advantages and disadvantages.
考察:Coding Project
授课2小时; 学习6小时
5
Understand the function of a query router. Implement the query router which directs query to the correct partition and collect results to formalize the final result.
考察:Coding Project
授课2小时; 学习4小时
6
Design and implement a map-based UI, which supports user queries and results visualization on the map.