jackmyers.info

Schedule for Graduate Adv Database Topics

Week of (Thurs) Lecture Week Work Due
1/23 A,R Syllabus Review
Database Concepts

Redis
1/30 I Redis assignment
InfluxDB / Grafana
ASSIGNMENT
Redis - PubSub, PHPRedis and RESP  (Redis, Node.js, PHP)
2/6 Influx assignment with partner(s) ASSIGNMENT
InfluxDB and Grafana
2/13 M MongoDB
Quick intro/review MongoDB
Data Modeling with MongoDB: Embedding vs Linking 1:1, 1:M, M:M, some design patterns (15:46), use case (31:30)
2/20 M MongoDB
Quick intro/review MongoDB
Data Modeling with MongoDB: Embedding vs Linking 1:1, 1:M, M:M, some design patterns (15:46), use case (31:30)
2/27 Advanced (Mongo) Schema Design Patterns: Design Patterns, the Insurance use case
Mongo and R
Mongo and sharding (time permitting) Mongo assignment
ASSIGNMENT
MongoDB: What was up with Enron?  (Mongo and R)
3/6 G Geometry in MySQL
TBD: working period for students
3/13 Geometry/MySQL assignment: Walking in Medford Lakes
TBD: working period for students
ASSIGNMENT
Walking in Medford Lakes  (MySQL)
3/20 Spring Break ASSIGNMENT
30 minute recorded article presentation video  
3/27 J ORM
Python and SQLAlchemy
ORM assignment: Lucy and friends
ASSIGNMENT
Lucy and friends start a buisness
(Python, SQLAlchemy, MySQL)
4/3 E Elasticsearch
Elasticsearch assignment
ASSIGNMENT
Elasticsearch
4/10 11 Neo4J
Neo4J assignment
ASSIGNMENT
Building a Neo4J database from Java
4/17 D Dynamo DB
Dynamo assignment with partner(s)
ASSIGNMENT
Dynamo DB  
4/24 H Heterogeneous Database Systems
- Multi-model databases
- Polyglot persistence

PRESENTATION: Evolution management in multi-model databases - Sushanth Ambati
5/1 Student Presentations
5/8 Oral Final Exam (part 2)