CS 505 Intermediate Topics in Databases

University of Kentucky
Department of Computer Science
CS 505 Intermediate Topics in Databases
  

1.  Course Number/Name:  CS 505, Intermediate Topics in Databases

2.  Credits and Contact Hours:  3 credits, 3 contact hours

3.   Instructor:   assigned by the department

4.   Textbook:   none

5.    a.   Catalog Description:  The course introduces a variety of modern techniques in database and distributed database systems. The major topics include, but are not limited to: object-oriented database systems; distributed, heterogeneous and web-based databases; knowledge based systems; physical database design; and security. The course covers a variety of methods that allow for a solution of database problems where the traditional relational database techniques are not viable or not sufficient.

b.  Prerequisites:  CS 405 or consent of instructor.

c.  Required course:  Elective 


6.  a.   Outcomes of InstructionAfter completing this course, the successful student will be able to:

1.   Understand the role of databases in modern society.
2.   Understand the security issues in DBMS, including SQL support for Discretionary Access Control and the issues
      related to Mandatory Access Control  and other security models for databases
3.   Understand the fundamentals of transaction management and concurrency control including theoretical foundations
      of concurrencycontrol, and crash recovery
4.   Understand current architectures of databases, cloud databases, graph databases and basics of parallel and
      distributed databases
5.   Understand issues related to information extraction from data stored in databases, thus so-called Big Data, with
      several examples of applications

b.   Contributions to Student Outcomes from Criterion 3

Outcome

a

b

c

d

e

f

g

h

i

j

k

CS 505

3

 

3

 

 

   

 

 

 

3

3- Strongly supported   2 – Supported   1 – Minimally supported 

 7.   List of Topics Covered:

1.   Modern databases
2.   Security in databases
3.   Transaction management and crash recovery
4.   Big Data and important examples of their applications
5.   Database architectures (cloud databases, paralell and distributed databases, graph databases)
6.   OLAP, Analytics if time permits