INFS 740  Section I,  Fall 2012

Database Programming for the World Wide Web

follow updates on GMU blackboard

 

Prof. Alex Brodsky (http://cs.gmu.edu/~brodsky/)

Meeting Times and Place:     Wednesday 7:20 – 10:00  (see schedule below)

                                           Krug Hall 242

 

Instructor’s office hours:       Wednesday 4-5:30 PM, Nguen Engineering Building rm 4418 (please verify before you come in)

Instructor’s Contact Info:    Phone: 703-993-1529,

E-mail: Brodsky@gmu.edu

Fax: 703-993-1710

Teaching Assistant:                      Sharmila Ramamoorthy

TA Contact Info:                           E-mail: sramamoo@masonlive.gmu.edu

TA Office Hours:                           TBD

Purpose of the course:

Information systems accessible through the World Wide Web and the

Internet are becoming prevalent. This class will discuss technologies

for accessing and manipulation of data that is suitable for WWW

applications. Industry standards will be used throughout. Through this

course, students will learn concepts of data manipulation in modern Internet-based applications and acquire skills

in using the data manipulation tools for building such applications.

 

Pre-requisites: INFS foundations requirements (INFS 501, 515, 519 and SWE 510), and INFS 614, or equivalent.

Need to have good grasp of relational database concepts and functional SQL skills

Textbooks:

Required:  None, but a lot of reading materials from the Internet will be assigned by the instructor.

Recommended:

a.       Xquery: The XML Query Language, by Michael Brundage, Addison-Wesley, ISBN 0-321-16581-0

b.       Xquery: the recommended text (see below) or http://www.w3.org/TR/xquery/

    1. XML Schema: http://www.w3.org/TR/xmlschema-0/
    2. BPEL: http://download.boulder.ibm.com/ibmdl/pub/software/dw/specs/ws-bpel/ws-bpel.pdf

 

Course work & Grading Policy:

Students are required to attend all the lectures. The planned structure of this class is a late midterm examination, 3 home assignments, and a choice of either a project or a research term paper.

There will be no final exam.  Late midterm exam - 50%, 3 home assignments – 15%, a project or research term paper – 35%.

Tentative Class Schedule:

Class Meeting #

Date

Topic

Lecture

Homework Assigned

Homework Due

1

Aug. 29

 

Introduction; Java and XML

http://classweb.gmu.edu/brodsky/infs740/lecture1.pdf

 

 

2

Sep. 5

XML Schema and Xpath

http://classweb.gmu.edu/brodsky/infs740/lecture2.pdf

 

 

3

Sep. 12

Xquery

http://classweb.gmu.edu/brodsky/infs740/lecture3.pdf

http://classweb.gmu.edu/brodsky/infs740/lecture5.pdf

http://classweb.gmu.edu/brodsky/infs740/lecture6.pdf

HA1

 

4

Sep. 19

Xquery – cont.

XQueryExamples

 

 

 

Sep. 26

No class

 

 

 

5

Oct. 3

XML relational mapping.

http://classweb.gmu.edu/brodsky/infs740/lecture8.pdf

http://classweb.gmu.edu/brodsky/infs740/XQueryExamples

HA2

HA1 

6

Oct.10

JDBC – transaction managment

http://classweb.gmu.edu/brodsky/infs740/lecture7.pdf

http://classweb.gmu.edu/brodsky/infs740/lecture9.pdf

 

 

7

Oct. 17

XML database design theory

http://www2.ing.puc.cl/~marenas/talks/ibm04-a.ppt

http://www2.ing.puc.cl/~marenas/talks/pods02.ppt

http://www2.ing.puc.cl/~marenas/talks/carleton02.pdf

http://www2.ing.puc.cl/~marenas/talks/dexa02.pdf

http://www2.ing.puc.cl/~marenas/talks/ibm04-w.ppt

HA3

HA2

8

Oct. 24

BPEL – XML Business Process Execution Language

BPEL.ppt

 

 

9

Oct. 31

BPQL – Business Process Query Language

BPQLprofMilo.ppt

 

HA3

10

Nov. 2, 5-7pm

Friday

Catch-up and review; preparation for the  Exam

http://classweb.gmu.edu/brodsky/infs740/sampleMidterm.doc

 

 

11

Nov. 7

Exam

sample exam

The following reference materials can be used at the midterm exam:

o    Xquery: The XML Query Language, by Michael Brundage, Addison-Wesley, ISBN 0-321-16581-0

o     XQuery, by Priscilla Walmsley, O'Reilly, ISBN 978-0-596-00634-1

o    Xquery:  http://www.w3.org/TR/xquery/

o    BPEL: http://download.boulder.ibm.com/ibmdl/pub/software/dw/specs/ws-bpel/ws-bpel.pdf

 

 

 

 

Nov. 14

Students’ project/term paper presentations

 

 

 

---

Nov. 21

No class – Thanksgiving Recess

 

 

 

12

Nov. 28

Students’ project/term paper presentations

 

 

 

13

Dec. 5

Students’ project/term paper presentations