# gvenzl/sample-data architecture

> Architecture diagram of the GitHub repository gvenzl/sample-data, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-01-13). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/gvenzl/sample-data
- Repository: https://github.com/gvenzl/sample-data

## Overview

##### Main Components

a. Data Collections Layer
- Countries-Cities-Currencies
- Departments-and-Employees
- National-Parks
- Solar-System

b. Data Source Layer
- External Data Sources:
- National Geographic Atlas
- GeoNames.org
- NPS Data API
- NASA Planetary Fact Sheets

c. Database Installation Layer
- SQL Scripts:
- Standard SQL installations
- Oracle-specific installations
- Uninstallation scripts

- [Data Sources] → [Data Collections] → [Database Installation]

##### Specific Component Details

- Blue: Raw data files (CSV)
- Green: Installation scripts
- Orange: External data sources
- Purple: Utility scripts
- Red: Compressed files

- Rectangles: Data collections
- Clouds: External data sources
- Hexagons: Utility scripts

##### Relationship Representations

- Double lines: Installation paths

##### Additional Details

a. Metadata Annotations:
- License information (Creative Commons Attribution 4.0)
- Data update frequency (if applicable)
- File format specifications

b. Version Information:
- SQL script compatibility
- Data source versions

Remember to include a note about the utility scripts and their role in data acquisition/maintenance, particularly for the National Parks dataset.

- How the data is organized
- Where the data comes from
- How to install the data into different database systems
- Relationships between different data files within each collection

## Diagram (Mermaid)

```mermaid
graph TB
    %% Style Definitions
    classDef source fill:#FFA07A,stroke:#333
    classDef collection fill:#87CEEB,stroke:#333
    classDef installation fill:#98FB98,stroke:#333
    classDef utility fill:#DDA0DD,stroke:#333
    classDef compressed fill:#FF6B6B,stroke:#333
    classDef rawData fill:#87CEEB,stroke:#333

    %% Data Sources
    subgraph Sources
        DS1["National Geographic Atlas"]:::source
        DS2["GeoNames.org"]:::source
        DS3["NPS Data API"]:::source
        DS4["NASA Planetary Facts"]:::source
    end

    %% Data Collections
    subgraph Collections
        %% Countries-Cities-Currencies
        CCC["Countries-Cities-Currencies"]
        click CCC "https://github.com/gvenzl/sample-data/tree/main/countries-cities-currencies/"
        CCCD1["cities.csv"]:::rawData
        click CCCD1 "https://github.com/gvenzl/sample-data/blob/main/countries-cities-currencies/cities.csv"
        CCCD2["countries.csv"]:::rawData
        click CCCD2 "https://github.com/gvenzl/sample-data/blob/main/countries-cities-currencies/countries.csv"
        CCCD3["currencies.csv"]:::rawData
        click CCCD3 "https://github.com/gvenzl/sample-data/blob/main/countries-cities-currencies/currencies.csv"
        CCCD4["currencies_countries.csv"]:::rawData
        click CCCD4 "https://github.com/gvenzl/sample-data/blob/main/countries-cities-currencies/currencies_countries.csv"
        CCCD5["regions.csv"]:::rawData
        click CCCD5 "https://github.com/gvenzl/sample-data/blob/main/countries-cities-currencies/regions.csv"

        %% Departments-Employees
        DE["Departments-Employees"]
        click DE "https://github.com/gvenzl/sample-data/tree/main/departments-and-employees/"
        DED1["departments.csv"]:::rawData
        click DED1 "https://github.com/gvenzl/sample-data/blob/main/departments-and-employees/departments.csv"
        DED2["employees.csv"]:::rawData
        click DED2 "https://github.com/gvenzl/sample-data/blob/main/departments-and-employees/employees.csv"

        %% National Parks
        NP["National Parks"]
        click NP "https://github.com/gvenzl/sample-data/tree/main/national-parks/"
        NPD1["activities.csv"]:::rawData
        click NPD1 "https://github.com/gvenzl/sample-data/blob/main/national-parks/activities.csv"
        NPD2["contacts.csv"]:::rawData
        click NPD2 "https://github.com/gvenzl/sample-data/blob/main/national-parks/contacts.csv"
        NPD3["parks.csv"]:::rawData
        click NPD3 "https://github.com/gvenzl/sample-data/blob/main/national-parks/parks.csv"
        NPD4["parks_activities.csv"]:::rawData
        click NPD4 "https://github.com/gvenzl/sample-data/blob/main/national-parks/parks_activities.csv"
        NPD5["images.csv.gz"]:::compressed
        click NPD5 "https://github.com/gvenzl/sample-data/blob/main/national-parks/images.csv.gz"
        NPU["get_US_NPS_data.py"]:::utility
        click NPU "https://github.com/gvenzl/sample-data/blob/main/national-parks/utils/get_US_NPS_data.py"

        %% Solar System
        SS["Solar System"]
        click SS "https://github.com/gvenzl/sample-data/tree/main/solar-system/"
        SSD1["planets.csv"]:::rawData
        click SSD1 "https://github.com/gvenzl/sample-data/blob/main/solar-system/planets.csv"
        SSD2["stars.csv"]:::rawData
        click SSD2 "https://github.com/gvenzl/sample-data/blob/main/solar-system/stars.csv"
        SSD3["metadata.csv"]:::rawData
        click SSD3 "https://github.com/gvenzl/sample-data/blob/main/solar-system/metadata.csv"
    end

    %% Installation Layer
    subgraph Installation
        %% Standard SQL
        SQL1["install.sql"]:::installation
        click SQL1 "https://github.com/gvenzl/sample-data/blob/main/countries-cities-currencies/install.sql"
        SQL2["install.sql"]:::installation
        click SQL2 "https://github.com/gvenzl/sample-data/blob/main/departments-and-employees/install.sql"
        SQL3["install.sql.gz"]:::compressed
        click SQL3 "https://github.com/gvenzl/sample-data/blob/main/national-parks/install.sql.gz"
        SQL4["install.sql"]:::installation
        click SQL4 "https://github.com/gvenzl/sample-data/blob/main/solar-system/install.sql"

        %% Oracle SQL
        OSQL1["install.oracle.sql"]:::installation
        click OSQL1 "https://github.com/gvenzl/sample-data/blob/main/departments-and-employees/install.oracle.sql"
        OSQL2["install.oracle.sql"]:::installation
        click OSQL2 "https://github.com/gvenzl/sample-data/blob/main/national-parks/install.oracle.sql"
        OSQL3["install.oracle.sql"]:::installation
        click OSQL3 "https://github.com/gvenzl/sample-data/blob/main/solar-system/install.oracle.sql"

        %% Uninstall Scripts
        UN1["uninstall.sql"]:::installation
        click UN1 "https://github.com/gvenzl/sample-data/blob/main/countries-cities-currencies/uninstall.sql"
        UN2["uninstall.sql"]:::installation
        click UN2 "https://github.com/gvenzl/sample-data/blob/main/departments-and-employees/uninstall.sql"
        UN3["uninstall.sql"]:::installation
        click UN3 "https://github.com/gvenzl/sample-data/blob/main/national-parks/uninstall.sql"
        UN4["uninstall.sql"]:::installation
        click UN4 "https://github.com/gvenzl/sample-data/blob/main/solar-system/uninstall.sql"
    end

    %% Relationships
    DS1 & DS2 -.-> CCC
    DS3 -.-> NP
    DS4 -.-> SS

    %% Countries-Cities-Currencies relationships
    CCC --> CCCD1 & CCCD2 & CCCD3 & CCCD4 & CCCD5
    CCCD1 & CCCD2 & CCCD3 & CCCD4 & CCCD5 --> SQL1
    SQL1 --> UN1

    %% Departments-Employees relationships
    DE --> DED1 & DED2
    DED1 & DED2 --> SQL2 & OSQL1
    SQL2 & OSQL1 --> UN2

    %% National Parks relationships
    NP --> NPD1 & NPD2 & NPD3 & NPD4 & NPD5
    NPU --> NP
    NPD1 & NPD2 & NPD3 & NPD4 & NPD5 --> SQL3 & OSQL2
    SQL3 & OSQL2 --> UN3

    %% Solar System relationships
    SS --> SSD1 & SSD2 & SSD3
    SSD1 & SSD2 & SSD3 --> SQL4 & OSQL3
    SQL4 & OSQL3 --> UN4

    %% Legend
    subgraph Legend
        L1["Raw Data"]:::rawData
        L2["Installation Script"]:::installation
        L3["External Source"]:::source
        L4["Utility Script"]:::utility
        L5["Compressed File"]:::compressed
    end
```
