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