Databases and relational database management systems. Data modeling, database design theory, data definition and manipulation languages, storaging and indexing techniques, query processing and optimization, concurrency control and recovery, database programming interfaces. Current research issues including XML, web data management, data integration and dissemination, data mining. Hands-on programming projects and a term project. Prerequisite: CompSci 201, and either CompSci 210D or CompSci 250D.
Prerequisites
Prerequisite: COMPSCI 201 and (COMPSCI 210D or COMPSCI 250D)