CSCE 824 – Secure Database Systems

Course Syllabus

Spring 2019

Professor:            Csilla Farkas

Office:                   Innovation Center Bldg. 2253

E-mail:                  farkas@cec.sc.edu

Class URL:           http://www.cse.sc.edu/~farkas/csce824/csce824.htm

Class hours:         Tuesday, Thursday 1:15 – 2:30 pm

Class location:    Innovation Center Bldg. 1400, and online

Office hours:       Tuesday, Wednesday 3:30 – 5:00 pm or by appointment

Prerequisites:      CSCE 520 and CSCE 522 or permission of instructor

 

Course description:

Most database systems contain sensitive information that need to be protected from unauthorized disclosure and modification while providing availability to the legitimate users.  The objective of this course is to introduce the security challenges and threats in database systems and provide an understanding of the state-of-the art security technologies. In addition to the security issues, the course addresses issues related to distributed databases and current technologies, such as service oriented architecture, cloud computing, etc. 

 

There is NO textbook requirements!  All course reading will be accessible freely online.

 

Recommended reading:

·         T. Ozsu and P. Valduriez, Principles of Distributed Database Systems, Springer; 3rd Edition. edition (March 2, 2011), ISBN-10: 1441988335

·         Proceedings of Secure Data Management Workshop

·         Proceedings of IFIP WG 11.3

·         Proceedings of International Conference of Very Large Databases (VLDB

·         IEEE Transactions on Knowledge and Data Engineering (TKDE)

·         ACM Transactions on Information and System Security (TISSEC)

 

Assignments:

 

 

Grading:

There is no curving!

Research project: 35%, Project presentation: 15%, Homework assignment: 40%, Related work presentation: 10%,

 

Total score that can be achieved: 100

Final grade:           90 < A;   87 < B+ <= 90;     80 < B <= 87;       76 < C+  <=80;

65 < C <= 76;       60 < D+  <= 65;   50 <D <= 60

 

Topics Covered

 

January-February

·         Research workshop

o    Finding research topics

o    Gathering background information

o    Establishing research goals

o    Conducting research

o    Writing research paper

·         Database Management Systems

o    Relational Data Model

o    Distributed Databases

o    Semi-structured Data Model

o    Stream Data Model

o    Data warehousing, data mining, Big Data, Data Lakes

o    Big data Infrastructure: Cloud, Grid, High-Performance Computing

·         Database Security Overview

o    General security issues

o    Security policies

o    Identity management

o    Integrity and availability

o    SOA and Cloud data management

o    Secure stream data management

March

·         Current data management technologies

o    MS Azure Cloud computing platform, https://azure.microsoft.com/en-us/

o    Cybernetica, https://cyber.ee/

·         Other technologies

 

April

·         Upcoming data management needs

·         Case studies

·         Future technologies and start up initiatives