[Database] database domain knowledge

Database principles
Database Systems Design
Advanced Database Technology

I. 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

 

Ii. 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

Iii. 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,201 2
Proceedings of ACM sigmod 2011,2012
Proceedings of icde 2011,201 2
Proceedings of ndbc 2011,201 2

 

Tips,

Buffer Management (LRU, clock)

Index (B + tree, hash)

Query Optimization

Transaction Properties

Lock-Based Concurrency Control

log-based recovery