Database Principles
Database Systems Design
Advanced Database Technology
一、Database principles
Relational data model – relational algebra
SQL – DDL, DML, DCL, ODBC(JDBC)
Database design — Entity-Relationship model
Relation normal forms
XML – DTD, XML Schema, XPath, XQuery
Object data model(*)
Database application development
二、Database System Design
Storage and File Organization
Indexing and Hashing
Query Processing
Query Optimization
Concurrency Control - lock-based protocols
Recovery - log-based mechanisms
Project – MiniSQL
三、Advanced Database Technology
Parallel Databases
Distributed Databases
Information Retrieval and Web Search
Business Intelligence
- OLAP and Data Mining
Advanced Application Development
Advanced Data Types and New Applications
- Temporal and Spatial Databases
- Multimedia Databases
- Graph Data Management
- Cloud Data Management
Others、course reference
Proceedings of VLDB 2011, 2012
Proceedings of ACM SIGMOD 2011,2012
Proceedings of ICDE 2011, 2012
Proceedings of NDBC 2011, 2012
Tips、
Buffer Management(LRU,clock)
Index(B+ tree, hash)
Query optimization
Transaction properties
Lock-based concurrency control
Log-based recovery