SPECIALIZATION 2024-2025 Michigan Database Systems
8/8 Specialization Projects · 100% Automated Test Coverage

Relational Architectures & Distributed Data Systems

Data modeling curricula implementation featuring 3NF normalized schemas, GIN inverted indexes, D3.js PageRank force graphs, and analytical SQL pipelines.

8
Core Modules
9/9
Passing Tests
3NF
Schema Norm
D3.js
Graph Traversal
PROJECT 11 REGEX ANALYTICS

Mail Log Analytics

Text processing engine parsing mbox headers with regular expressions to compute sender frequency distributions and hourly messaging activity histograms.

Click above to analyze sample mbox stream
PROJECT 12 WEB SCRAPING

Web Scraper & Geo Ingestion

Automated crawler parsing document DOM structures, resolving relative hyperlink anchors, and parsing geographical coordinate payloads.

Click above to execute crawl test
PROJECT 13 SQL JOINS

Relational Music Catalog

Normalized multi-table schema (Artists, Albums, Genres, Tracks) with primary and foreign key constraints resolving complex analytical SQL JOINs.

Click above to query catalog with JOINs
PROJECT 14 MARKOV D3.JS

PageRank & Graph Visualizer

Directed graph traversal engine implementing the random surfer algorithm with 0.85 damping factor and live D3.js force network animation.

Initializing graph...
PROJECT 15 3NF INTEGRITY

3NF Schema & Cascading Deletion

Strict third normal form relational architecture enforcing foreign key constraints and automated cascading deletions (ON DELETE CASCADE).

Click above to test cascading deletion
PROJECT 16 GIN FULLTEXT

Full-Text Inverted Index Search

PostgreSQL GIN-style full-text search indexing engine with tokenization, stop-word elimination, and multi-word query ranking.

Click Search to query inverted index
PROJECT 17 POSTGRES JSONB

JSONB Semi-Structured Store

Hybrid relational and document modeling engine with deep attribute extraction operators and JSON subset containment queries (@>).

Click above to query JSONB documents
PROJECT 18 SQL NLP

Analytical TF-IDF Engine

In-database Term Frequency - Inverse Document Frequency analytical ranking algorithm isolating distinctive vocabulary across document corpora.

Click above to calculate TF-IDF weights