15-415: Database Applications
| Units | 12 |
|---|---|
| Department | Computer Science |
| Prerequisites | 15-211 and 15-213 |
| Related URLs | http://www.csd.cs.cmu.edu http://www.cs.cmu.edu/~ddash/15415/F07/ |
This course covers the fundamental topics for Database Management Systems: Database System Architectural Principles (ACID properties; data abstraction; external, conceptual, and internal schemata; data independence; data definition and data manipulation languages), Data models (entity-relationship and relational data models; data structures, integrity constraints, and operations for each data model; relational query languages: SQL, algebra, calculus), Theory of database design (functional dependencies; normal forms; dependency preservation; information loss), Query Optimization (equivalence of expressions, algebraic manipulation; optimization of selections and joins), Storage Strategies (indices, B-trees, hashing), Query Processing (execution of sort, join, and aggregation operators), and Transaction Processing (recovery and concurrency control).
Sections
No sections available for Spring 2009
Textbooks
We don’t have textbooks yet. Check back closer to the beginning of Spring 2009.