XQueryDatalog

Paper presentations

Kevin’s Perst project  instructions

sage oracle path

mini university db

PL/SQL stored procedure, stored function example

chapter 16,         chapter 17,    

chapter 27:    IR systems,  Vector Space Model,     Intro-XML, Semi-structured Data & XML,     XQuery

Introduction to SQL, PL/SQL

Oracle FAQ

Object Oriented Databases

Project

Assignment #1, Due on 5-28-08

Summer 2006 -OLD In class assignments

• Lab #1
• Lab #2
• Lab #3
• Lab #4 (due on 5-30)
• Lab #5 (solve exercise 21.2 from textbook - team work)
• Lab #6 (Statistical DB security)
  • Create a table persons, with id, name and age as attributes
  • Insert 5 valid tuples into table persons
  • Create a view pers1(id, name) over table persons
  • Create a PL/SQL function that returns the average_age of all tuples in table persons except for the individual with id passed as a parameter
  • Work with a classmate give him/her permission to read your view pers1 and execute your pl/sql function average_age . Your classmate can't read your table employees, but he/she needs to determine the age values for all tuples in your table persons.
• Lab #7 (solve exercise 16.1 from textbook - teamwork)
• Lab #8 (solve exercise 27.2 question 5 -only)
• Lab #9 (solve exercises 27.6 & 27.7)