How kato-001/bolivia-distribucion-sgbdd works
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 Regional PostgreSQL Nodes · 02_nodo_central.sql Central Catalog · coordinador_2pc.py 2PC Coordinator · demo.ps1 Demo Commands
Components 13
User Access
- Demo Commands
demo.ps1 - SQL Clients
Distributed Data
- Regional PostgreSQL Nodes
docker-compose.yml - Local Fragments
scripts/01_esquema_local.sql - Central Catalog
scripts/02_nodo_central.sql - Catalog Replication
scripts/00_init_nodo.sh - Distributed Views
scripts/04_fdw_vistas.sql - Customer Finance
scripts/05_clientes_financiero.sql - Sample Data
scripts/03_datos_prueba.sql
Transaction Coordination
- 2PC Coordinator
coordinador/coordinador_2pc.py - Transfer Participants
docker-compose.yml - Decision Log
scripts/02_nodo_central.sql
Other components
- Operator
Connections 16
- Operator → Demo Commands: runs commands
README.md - Operator → SQL Clients: queries directly
README.md - Demo Commands → Regional PostgreSQL Nodes: manages nodes
README.md - SQL Clients → Regional PostgreSQL Nodes: connects to
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
README.md - 2PC Coordinator → Transfer Participants: coordinates 2PC
coordinador/coordinador_2pc.py - 2PC Coordinator → Decision Log: records decisions
coordinador/coordinador_2pc.py - Transfer Participants → Regional PostgreSQL Nodes: runs on nodes