|Instructor:||Andrew L. Mackey|
|Meeting Times:||Mondays/Wednesdays/Fridays at 1:00 - 1:50 pm|
|Meeting Times:||Tuedays/Thursdays at 12:30 - 1:45 pm|
|Lab Assistant:||Cesar Cuevas|
This course provides a comprehensive review of database management architecture, design and implementation issues. Topics include database system architecture, query optimization, buffer management, performance analysis, concurrency control, storage management, recovery, transaction management, and application development. Current trends in academic research and distributed databases are also surveyed. Topics in big data, NoSQL, and high performance databases in Linux/UNIX environments are also covered.
Students are required to have a prior background in object-oriented programming languages (e.g. Java, C++, etc.) and database concepts (e.g. normalization, functional dependencies, SQL, etc.).
The follow list contains courses that I have taught within the past few years.
|2||Database Connectivity: JDBC, ODBC, CLI|
|3||Database Application Development|
|4||Database Systems Architecture|
|5||Memory and Buffer Pools|
|7||Storage and Indexing|
|8||Transactions and Concurrency|
|10||Transactions and Concurrency (cont.)|
|12||Distributed Databases and NoSQL|
|13||Hadoop and MapReduce|
|14||Advanced Topics in Database Systems|
|15||Research and Final Project Presentations|
No reading material has been assigned. However, the following textbooks are optional and may supplement the material in this class:
The following resources are available for students to use.
Review the course website for more information