Access methods and file systems to facilitate data access. Hierarchical, network, relational, and object-oriented data models. Query languages for models. Embedding query languages in programming languages. Database services including protection, integrity control, and alternative views of data. High-level interfaces including application generators, browsers, and report writers. Introduction to transaction processing. Database system implementation to be done as term project.
| Assignment | Detailed Requirements | Quick Link to My Solution |
|---|---|---|
| Assignment 1 | SQL queries and scalable algorithms | Basic SQL |
| Assignment 2 | B+ Trees | B+ Trees |
| Assignment 3 | Iterators and Join Algorithms | Iterators and Join |
| Assignment 4 | Cost Estimation and Query Optimization | Cost estimation and query optimization |
| Assignment 5 | Lock Manager | Locking |