CPS 116: Introduction to Database Systems
This course, targeting undergraduate students and non-CS graduate students, is designed to give students a solid background in databases. Topics include data modeling, database design theory, data definition and manipulation languages, storage and indexing techniques, query processing and optimization, concurrency control and recovery, and database programming interfaces. Besides traditional topics on relational databases, this course also covers samples of emerging and advanced topics such as XML, Web data management, Internet search engines, data warehousing, and data mining. Programming projects are required.
- Fall 2007, taught by Jun Yang.
- Fall 2006, taught by Jun Yang.
- Fall 2005, taught by Jun Yang.
- Fall 2004, taught by Jun Yang.
- Fall 2003, taught by Jun Yang (as CPS 196.3).
- Fall 2002, taught by Jun Yang (as CPS 196.3).
CPS 216: Advanced Database Systems
This course, targeting CS graduate students and advanced undergraduate students, covers advanced database management system design principles and techniques. The course materials will be drawn from both classic and recent research literature. Possible topics include access methods, query processing and optimization, transaction processing, distributed databases, object-oriented and object-relational databases, data warehousing, data mining, Web and semistructured data, search engines, etc. Programming projects are required.
- Fall 2007, taught by Shivnath Babu.
- Fall 2006, taught by Shivnath Babu.
- Spring 2004, taught by Jun Yang.
- Spring 2003, taught by Jun Yang.
- Fall 2001, taught by Jun Yang.
Other Courses
- CS 399.28, Spring 2008: Research Seminar and Project in Databases, taught by Jun Yang.
- CPS 296.4, Fall 2007: Sensor Networks for Environmental Monitoring, co-taught by others and Jun Yang. Offered through Statistical and Applied Mathematical Sciences Institute, and cross-listed at Duke, North Carolina State, and UNC Chapel Hill.
- CPS 296.1, Spring 2007: Sensor Data Processing, taught by Jun Yang.
- CPS 296.1, Spring 2002: Topics in Database Systems, taught by Jun Yang.