Course description: CS623 looks at the design of database management systems to obtain consistency, integrity and availability of data and at conceptual models and schemas of data: relational, hierarchical and network. It also discusses transaction processing systems. Topics covered include models of transactions, architectures of transaction processing systems and concurrent transactions.
Students undertake a semester project that includes the design and implementation of a database system and transactions. They will furthermore make some research on what are the fashionable topics in databases research these days.

Goals: By the end of this course, students will be able to design and implement a database system and will have some practice using JDBC to implement a set of transactions. They will also develop independent learning skills and will be aware of the research going on in databases.

Tools: Oracle, SQL, JDBC, XML.

General Information: CS623 is a 3-credit course.Prerequisites are CS 601 and CS 603. Furthermore students must be familiar with JAVA.