# codemagic4ever/treble-makers-analytics-capstone architecture

> Architecture diagram of the GitHub repository codemagic4ever/treble-makers-analytics-capstone, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-07-27). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/codemagic4ever/treble-makers-analytics-capstone
- Repository: https://github.com/codemagic4ever/treble-makers-analytics-capstone

## Overview

##### Project type and purpose
- This is a capstone‐style analytics project, not a typical web app. It focuses on building a music recommender system (collaborative filtering, content-based filtering, and a hybrid model) using Python and SQL against a provided music database.

##### File structure
- Top-level artifacts:
- .sql files (BSAN780-…sql) – data extraction, transformation, and model queries
- .py files (BSAN780-…py) – feature engineering, similarity calculations, model implementation, frequency graphing
- README.md – project overview
- PDF/PPTX outputs – final recommendations and presentation
- There is no “frontend” or “backend” folder—this is a batch/data pipeline architecture.
- No deployment or container config implies this runs as local scripts against a database.

##### README for additional insights
- Core models: collaborative, content-based, hybrid
- Tech stack: Python for computations and graphing; SQL for data retrieval and some modeling logic
- End goals: generate ranked music recommendations; produce reports/visualizations

a. Main components:
- Data Store: Relational database containing users, tracks, ratings, metadata
- Data Access Layer: SQL scripts that pull user–item interaction tables and feature tables
- Data Processing & Feature Engineering: Python scripts (BSAN780-…py) that compute item profiles, similarity matrices, frequency graphs
- Model Training & Inference:
– Collaborative Filtering module
– Content-Based Filtering module
– Hybrid Model module (combiner)
- Evaluation & Reporting: generation of performance metrics, visualization graphs, and final reports (PDF/PPTX)
b. Relationships & data flow:
1. SQL scripts query raw tables → produce cleaned datasets
2. Python scripts ingest datasets → compute features or similarity scores
3. Model modules consume features → output ranked recommendation lists
4. Reporting layer collates model outputs → produces recommendation PDFs and presentation slides
c. Architectural patterns & principles:
– Pipeline pattern: sequential ETL (extract, transform, load) and model stages
– Modular design: separate scripts for each filtering strategy and for graphing/visualization
– Reusability: SQL queries can be reused for multiple models; Python functions for similarity calculations
d. Key technologies/frameworks:
– Python ecosystem (NumPy/Pandas for data manipulation, Matplotlib/Seaborn for graphs)
– SQL (e.g., PostgreSQL or SQLite) for querying large datasets
– Custom hybridization logic in Python

##### Essential architectural capture
- Don’t over-fragment the pipeline. Represent each logical stage/component.
- You capture all three recommendation strategies as separate subcomponents under “Modeling.”
- That the hybrid model “combines” outputs from the collaborative and content-based modules before final ranking.

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Data Storage
    DB[(Relational Music Database)]:::storage

    %% Data Extraction Layer
    subgraph "Data Access Layer" 
        SQL1["BSAN780-10Content-Recommendations.sql"]:::processing
        SQL2["BSAN780-FinalProject-CollaborativeScaling.sql"]:::processing
        SQL3["BSAN780-FinalProject-ContentBased.sql"]:::processing
    end

    %% Feature Engineering Layer
    subgraph "Feature Engineering & Processing"
        PY1["BSAN780-FinalProject-MusicSimilarity.py"]:::processing
        PY2["BSAN780-ContentBased-FrequencyGraphs.py"]:::processing
    end

    %% Modeling Layer
    subgraph "Model Training & Inference"
        CF["Collaborative Filtering Module"]:::processing
        CB["Content-Based Filtering Module"]:::processing
        HY["Hybrid Recommendation Module"]:::processing
    end

    %% Reporting & Evaluation
    subgraph "Evaluation & Reporting"
        PDF1["TheTrebleMakers_FinalRecommendations.pdf"]:::output
        PPT["TheTrebleMakers-FinalPresentation-Final.pptx"]:::output
    end

    %% Documentation
    subgraph "Project Documentation"
        README["README.md"]:::doc
        DOCPDF["Analytics-Capstone-Project-ReadMe.pdf"]:::doc
    end

    %% Data Flow
    DB -->|extract| SQL1
    DB -->|extract| SQL2
    DB -->|extract| SQL3
    SQL1 -->|produce cleaned datasets| PY1
    SQL3 -->|produce feature tables| PY2
    PY1 -->|item similarity| CB
    PY2 -->|frequency graphs| CB
    SQL2 -->|collaborative data| CF
    CF -->|recommendations| HY
    CB -->|recommendations| HY
    HY -->|final ranked list| PDF1
    HY -->|final ranked list| PPT

    %% Click Events
    click SQL1 "https://github.com/codemagic4ever/treble-makers-analytics-capstone/blob/main/BSAN780-10Content-Recommendations.sql"
    click SQL2 "https://github.com/codemagic4ever/treble-makers-analytics-capstone/blob/main/BSAN780-FinalProject-CollaborativeScaling.sql"
    click SQL3 "https://github.com/codemagic4ever/treble-makers-analytics-capstone/blob/main/BSAN780-FinalProject-ContentBased.sql"
    click PY1 "https://github.com/codemagic4ever/treble-makers-analytics-capstone/blob/main/BSAN780-FinalProject-MusicSimilarity.py"
    click PY2 "https://github.com/codemagic4ever/treble-makers-analytics-capstone/blob/main/BSAN780-ContentBased-FrequencyGraphs.py"
    click README "https://github.com/codemagic4ever/treble-makers-analytics-capstone/blob/main/README.md"
    click DOCPDF "https://github.com/codemagic4ever/treble-makers-analytics-capstone/blob/main/Analytics-Capstone-Project-ReadMe.pdf"

    %% Styles
    classDef storage fill:#BBDEFB,stroke:#333,stroke-width:1px
    classDef processing fill:#C8E6C9,stroke:#333,stroke-width:1px
    classDef output fill:#FFE0B2,stroke:#333,stroke-width:1px
    classDef doc fill:#E1BEE7,stroke:#333,stroke-width:1px
```
