# kato-001/bolivia-distribucion-sgbdd architecture

> Architecture diagram of the GitHub repository kato-001/bolivia-distribucion-sgbdd, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-20). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/kato-001/bolivia-distribucion-sgbdd
- Repository: https://github.com/kato-001/bolivia-distribucion-sgbdd

## Overview

BoliviaDistribución is a PostgreSQL distributed-database prototype: six regional nodes store partitioned data, with La Paz providing national views and catalog services. Users invoke the PowerShell demo commands or query PostgreSQL directly; the principal cross-region workflow is an inventory transfer coordinated with 2PC. The README documents fragmentation, catalog replication, distributed queries, fault-tolerant reads, and vertical customer fragmentation. Only the coordinator excerpt was sampled, so links among the documented database subsystems are shown as unverified where their implementing SQL is unsampled.

Main entry points: [`docker-compose.yml`](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/docker-compose.yml) (Regional PostgreSQL Nodes), [`scripts/02_nodo_central.sql`](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/02_nodo_central.sql) (Central Catalog), [`coordinador/coordinador_2pc.py`](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/coordinador/coordinador_2pc.py) (2PC Coordinator), [`demo.ps1`](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/demo.ps1) (Demo Commands)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_access["User Access"]
  node_demo_commands["Demo Commands<br/>[demo.ps1]"]
  node_postgres_clients["SQL Clients"]
end

subgraph group_distributed_data["Distributed Data"]
  node_regional_nodes[("Regional PostgreSQL Nodes<br/>[docker-compose.yml]")]
  node_local_fragments[("Local Fragments")]
  node_central_catalog[("Central Catalog")]
  node_catalog_replication["Catalog Replication<br/>[00_init_nodo.sh]"]
  node_distributed_views["Distributed Views<br/>[04_fdw_vistas.sql]"]
  node_customer_finance[("Customer Finance")]
  node_sample_data["Sample Data"]
end

subgraph group_transaction_coordination["Transaction Coordination"]
  node_two_phase_coordinator["2PC Coordinator<br/>[coordinador_2pc.py]"]
  node_transfer_participants[("Transfer Participants<br/>[docker-compose.yml]")]
  node_decision_log[("Decision Log")]
end

node_operator(("Operator"))

node_operator -->|"runs commands"| node_demo_commands
node_operator -->|"queries directly"| node_postgres_clients
node_demo_commands -->|"manages nodes"| node_regional_nodes
node_postgres_clients -->|"connects to"| node_regional_nodes
node_regional_nodes -.->|"stores fragments"| node_local_fragments
node_regional_nodes -.->|"hosts central node"| node_central_catalog
node_central_catalog -.->|"publishes catalog"| node_catalog_replication
node_catalog_replication -.->|"replicates catalog"| node_regional_nodes
node_central_catalog -.->|"provides FDW views"| node_distributed_views
node_distributed_views -.->|"queries remote data"| node_regional_nodes
node_central_catalog -.->|"stores finance fragment"| node_customer_finance
node_sample_data -.->|"loads test data"| node_regional_nodes
node_operator -->|"starts transfer"| node_two_phase_coordinator
node_two_phase_coordinator -->|"coordinates 2PC"| node_transfer_participants
node_two_phase_coordinator -->|"records decisions"| node_decision_log
node_transfer_participants -.->|"runs on nodes"| node_regional_nodes

click node_demo_commands "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/demo.ps1"
click node_regional_nodes "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/docker-compose.yml"
click node_local_fragments "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/01_esquema_local.sql"
click node_central_catalog "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/02_nodo_central.sql"
click node_catalog_replication "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/00_init_nodo.sh"
click node_distributed_views "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/04_fdw_vistas.sql"
click node_customer_finance "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/05_clientes_financiero.sql"
click node_sample_data "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/03_datos_prueba.sql"
click node_two_phase_coordinator "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/coordinador/coordinador_2pc.py"
click node_transfer_participants "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/docker-compose.yml"
click node_decision_log "https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/02_nodo_central.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_demo_commands,node_postgres_clients toneBlue
class node_regional_nodes,node_local_fragments,node_central_catalog,node_catalog_replication,node_distributed_views,node_customer_finance,node_sample_data toneAmber
class node_two_phase_coordinator,node_transfer_participants,node_decision_log toneMint
class node_operator toneIndigo
```

## Components

### User Access

- [Demo Commands](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/demo.ps1): `demo.ps1`
- **SQL Clients**

### Distributed Data

- [Regional PostgreSQL Nodes](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/docker-compose.yml): `docker-compose.yml`
- [Local Fragments](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/01_esquema_local.sql): `scripts/01_esquema_local.sql`
- [Central Catalog](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/02_nodo_central.sql): `scripts/02_nodo_central.sql`
- [Catalog Replication](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/00_init_nodo.sh): `scripts/00_init_nodo.sh`
- [Distributed Views](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/04_fdw_vistas.sql): `scripts/04_fdw_vistas.sql`
- [Customer Finance](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/05_clientes_financiero.sql): `scripts/05_clientes_financiero.sql`
- [Sample Data](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/03_datos_prueba.sql): `scripts/03_datos_prueba.sql`

### Transaction Coordination

- [2PC Coordinator](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/coordinador/coordinador_2pc.py): `coordinador/coordinador_2pc.py`
- [Transfer Participants](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/docker-compose.yml): `docker-compose.yml`
- [Decision Log](https://github.com/kato-001/bolivia-distribucion-sgbdd/blob/main/scripts/02_nodo_central.sql): `scripts/02_nodo_central.sql`

### Other components

- **Operator**

## Connections

- Operator → Demo Commands: runs commands (evidence: `README.md`)
- Operator → SQL Clients: queries directly (evidence: `README.md`)
- Demo Commands → Regional PostgreSQL Nodes: manages nodes (evidence: `README.md`)
- SQL Clients → Regional PostgreSQL Nodes: connects to (evidence: `README.md`)
- Regional PostgreSQL Nodes → Local Fragments: stores fragments
- Regional PostgreSQL Nodes → Central Catalog: hosts central node
- Central Catalog → Catalog Replication: publishes catalog
- Catalog Replication → Regional PostgreSQL Nodes: replicates catalog
- Central Catalog → Distributed Views: provides FDW views
- Distributed Views → Regional PostgreSQL Nodes: queries remote data
- Central Catalog → Customer Finance: stores finance fragment
- Sample Data → Regional PostgreSQL Nodes: loads test data
- Operator → 2PC Coordinator: starts transfer (evidence: `README.md`)
- 2PC Coordinator → Transfer Participants: coordinates 2PC (evidence: `coordinador/coordinador_2pc.py`)
- 2PC Coordinator → Decision Log: records decisions (evidence: `coordinador/coordinador_2pc.py`)
- Transfer Participants → Regional PostgreSQL Nodes: runs on nodes
