Homework 4

CSCE 824 – Spring 2019

Due: April 4, 11:55 pm 2019 via Dropbox

Name:

20 points

Question 1: (6) Fill out the following table

	Relational	XML	Stream
Briefly explain the main concepts of the data model
Explain a unique component of the data model over the other data models
Moist suitable for application domain … Because ….

Question 2: (9)

Consider the paper of Barbara Carminati, Elena Ferrari, Jianneng Cao, and Kian Lee Tan. 2010. A framework to enforce access control over data streams. ACM Trans. Inf. Syst. Secur. 13, 3, Article 28 (July 2010), 31 pages. https://dl.acm.org/citation.cfm?id=1805984

· The two data streams of Example 3.1 are: Position (ts, SID, Platoon, Pos) and Health (ts, SID, Platoon, Heart, BPressure). Assume that the streams are converted into relational tables with schemas: Position-R (ts, SID, Platoon, Pos) and Health-R (ts, SID, Platoon, Heart, BPressure). The primary keys are underlined.

· Show how to write the continuous queries presented in Example 3.1 and Example 3.2 using SQL over relations: Position-R and Health-R.

· How can you deploy your relational SQL queries such that you have the same answers as the corresponding continuous queries?

Question 3: (5)

Show an attack against the data stream that is not prevented by the proposed access control model.