Csc 8711, Databases and the Web (Spring 2019)

Instructional Staff

Instructor: Raj Sunderraman; Room 629, 1 Park Place; raj@cs.gsu.edu; Office hours: Tuesday/Thursday 2.00 pm to 4:00 pm
TA: Ms. Heta Desai; Room 612, 1 Park Place; hdesai1@student.gsu.edu; Office Hours: ???

Course Details

Syllabus
Class Roster
Google Groups for Class
Secure Shell Client for Windows
Homework Submission Guidelines

Course Materials

GRAPH DATABASES: neo4j

neo4j
Download neo4j Community Server
neo4j Get Started
neo4j cypher query language
py2neo (Sample Code)
Project 6 (Due: April 29, 2019 - Monday) (Handin under assignment 6 - counts towards final exam)

---

SEMANTIC WEB

Semantic Web Chapter
Description Logic Interpretations Example
rdflib4.2.2 for Python (Examples)

Readings

1. Scientific American Article
2. Ontology Tutorial
3. Metcalfe's Law, Web 2.0 and Semantic Web

Protege (RDF/OWL Editor...)
SPARQL Tutorial (Example Queries)
Sample Ontologies: nobel.owl, nobeldata.owl, Periodictable.owl
Useful Links
Apache Jena Project
Project 5 (Due: April 14, 2019 - Sunday) (Handin under assignment 5)
DL Wikipedia

---

JSON, JSON Schema, OpenAPI, JSON parsing, jsoniq

JSON Schema Booklet (Notes/Examples from Booklet and Other Examples)
JSON Parsing in Python - Example
OpenAPI
Project 3 (Due: March 13, 2019 - Wednesday) (Handin under assignment 3)
Linked List Instance, Linked List Schema
JSON Editor Online
JSON Schema Validator
jsoniq (jsoniq examples)
MongoDB slides
Project 4 (Due: March 31, 2019 - Sunday) (Handin under assignment 4)

---

XML

XML Basics
DTDs and XML Schema (https://www.w3.org/TR/xmlschema-1/, https://www.w3.org/TR/xmlschema-2/)
Elmasri/Navathe Lab Manual Chapter
XML Querying/Transforms: XPATH XQUERY XSL
PhP program to process XSL, Journals-Volumes-Articles Example

editx
basex.org
xmllint
(example: xmllint --noout --schema bib.xsd bib.xml)
Oracle XML Documents

xquery
let $d:=doc("/public/book/company.xml")
for $p in $d/companyDB/projects/project
return $p
/

Xquery built-in functions
functx functions
Project 2 (Due: February 24, 2019 - Sunday) (Handin under assignment 2)
Transcript Example in basex
XML Parsing in Python
Example: p1.py, mail.xml

---

Modern Web Application Development (REST Web Services, React, HTML5/Javascript, Ajax, Postgres)

Fielding Dissertation (REST Architecture)
Python Flask Tutorial
React
freecodecamp course on React
Postgres Tutorial
Python Postgres SQL
Flask Examples
Graduate Students App (view code)
Project 1 (Due: February 3, 2019 - Sunday) (Handin under assignment 1)
create-react-app
react-router
Sample React code with router