# enriqueiborra/asgbd architecture

> Architecture diagram of the GitHub repository enriqueiborra/asgbd, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-05-14). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/enriqueiborra/asgbd
- Repository: https://github.com/enriqueiborra/asgbd

## Overview

1. This repository is not an application backend or library; it is a course content repository for the ASGBD module, centered on database administration teaching materials and a published static documentation site.

2. The main content layer is the set of PDF units at the repository root (`UD1`–`UD6` and `PLALOE_EXTR`). These files are the canonical learning materials: installation, configuration, users and permissions, automation, optimization, and availability. Each unit also has a `CriterisRA*.txt` file describing assessment criteria for that learning outcome.

3. The `docs/` directory is the delivery layer. It contains prebuilt HTML pages, CSS, images, fonts, sitemap, and JSON question banks. This is the part that is meant to be served directly, most likely through GitHub Pages, as indicated by the README link to the public site.

4. The site structure in `docs/` maps the curriculum into navigable web pages: installation, configuration, SQL review, users/privileges, security, automation, optimization, availability, and ER review. There are both normal and `_p` variants of several pages, which suggests parallel versions of the same content, likely for alternate views or printer-friendly/pedagogical variants.

5. The quiz/assessment subsystem lives under `docs/preguntes/`. The JSON files (`preguntes11.json`, `preguntes21.json`, `preguntes31.json`, etc.) appear to hold structured question sets aligned to units and outcomes. These files are a data source for interactive exercises or self-assessment in the static site.

6. The visual presentation subsystem is fully static: `docs/estilsindex.css`, `docs/estilsunitats.css`, image assets, and font assets control the site layout and branding. There is no evidence of server-side rendering or a runtime framework; browser-side HTML/CSS is the primary delivery mechanism.

7. The repository also includes supporting “source of truth” documents in PDF form, such as installation guides, Oracle setup, Docker deployment notes, and summaries. These are instructional artifacts rather than executable code, but they define the content that the static site exposes.

8. The external dependencies that matter architecturally are minimal: a browser to read the static site, GitHub Pages as the likely hosting mechanism, and an optional Google Translate entry point referenced in the README for multilingual viewing. No database, API server, or build service is visible in the tree.

9. The data flow is essentially one-way: authored course materials and question banks are published into `docs/`, then consumed by students through the static website. The PDFs in the unit folders are separate downloadable reference materials that support the same curriculum.

10. Overall, this repository is best diagrammed as a content publishing system with three boundaries: source materials in PDF/TXT form, a static web presentation layer in `docs/`, and browser-based consumption via a hosted public site. The architecture is documentation-centric, not service-centric.

Main entry points: [`docs/preguntes`](https://github.com/enriqueiborra/asgbd/tree/main/docs/preguntes) (Quizzes), [`docs/index.html`](https://github.com/enriqueiborra/asgbd/blob/main/docs/index.html) (Home), [`UD3`](https://github.com/enriqueiborra/asgbd/tree/main/UD3) (Unit 3), [`docs/instalacio-sgbd.html`](https://github.com/enriqueiborra/asgbd/blob/main/docs/instalacio-sgbd.html) (Installation)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_source["Source materials"]
  node_readme["README<br/>repo guide<br/>[README.md]"]
  node_ud1["Unit 1<br/>pdf unit"]
  node_ud2["Unit 2<br/>pdf unit"]
  node_ud3["Unit 3<br/>pdf unit"]
  node_ud4["Unit 4<br/>pdf unit"]
  node_ud5["Unit 5<br/>pdf unit"]
  node_ud6["Unit 6<br/>pdf unit"]
  node_extra["Extra pack<br/>pdf pack"]
end

subgraph group_site["Static site"]
  node_home["Home<br/>site entry<br/>[index.html]"]
end

subgraph group_content["Curriculum pages"]
  node_instalacio["Installation<br/>topic page"]
  node_configuracio["Configuration<br/>topic page"]
  node_usuaris["Users<br/>topic page"]
  node_seguretat["Security<br/>topic page"]
  node_automatitzacio["Automation<br/>topic page"]
  node_optimitzacio["Optimization<br/>topic page"]
  node_disponibilitat["Availability<br/>topic page"]
  node_review["Review<br/>topic page<br/>[repas-sql.html]"]
end

subgraph group_assets["Presentation assets"]
  node_assets_css["Stylesheets<br/>css assets<br/>[estilsindex.css]"]
  node_assets_media["Media assets<br/>static assets"]
  node_sitemap["Sitemap<br/>site metadata<br/>[sitemap.xml]"]
end

subgraph group_assessment["Question bank"]
  node_questions["Quizzes<br/>json bank"]
end

subgraph group_delivery["Consumption"]
  node_pages(("Browser<br/>client"))
  node_hosting[("GitHub Pages<br/>hosting")]
end

node_readme -->|"points to"| node_home
node_ud1 -->|"publishes"| node_instalacio
node_ud2 -->|"publishes"| node_configuracio
node_ud3 -->|"publishes"| node_usuaris
node_ud3 -->|"publishes"| node_seguretat
node_ud4 -->|"publishes"| node_automatitzacio
node_ud5 -->|"publishes"| node_optimitzacio
node_ud6 -->|"publishes"| node_disponibilitat
node_extra -->|"supplements"| node_review
node_questions -->|"feeds"| node_instalacio
node_questions -->|"feeds"| node_configuracio
node_questions -->|"feeds"| node_usuaris
node_questions -->|"feeds"| node_automatitzacio
node_questions -->|"feeds"| node_optimitzacio
node_questions -->|"feeds"| node_disponibilitat
node_home -->|"uses"| node_assets_css
node_home -->|"uses"| node_assets_media
node_home -->|"indexed by"| node_sitemap
node_home -->|"consumed by"| node_pages
node_hosting -->|"serves"| node_home
node_pages -->|"requests"| node_hosting

click node_readme "https://github.com/enriqueiborra/asgbd/blob/main/README.md"
click node_ud1 "https://github.com/enriqueiborra/asgbd/tree/main/UD1"
click node_ud2 "https://github.com/enriqueiborra/asgbd/tree/main/UD2"
click node_ud3 "https://github.com/enriqueiborra/asgbd/tree/main/UD3"
click node_ud4 "https://github.com/enriqueiborra/asgbd/tree/main/UD4"
click node_ud5 "https://github.com/enriqueiborra/asgbd/tree/main/UD5"
click node_ud6 "https://github.com/enriqueiborra/asgbd/tree/main/UD6"
click node_extra "https://github.com/enriqueiborra/asgbd/tree/main/PLALOE_EXTR"
click node_home "https://github.com/enriqueiborra/asgbd/blob/main/docs/index.html"
click node_instalacio "https://github.com/enriqueiborra/asgbd/blob/main/docs/instalacio-sgbd.html"
click node_configuracio "https://github.com/enriqueiborra/asgbd/blob/main/docs/configuracio-sgbd.html"
click node_usuaris "https://github.com/enriqueiborra/asgbd/blob/main/docs/usuaris-privilegis.html"
click node_seguretat "https://github.com/enriqueiborra/asgbd/blob/main/docs/seguretat-mecanismes.html"
click node_automatitzacio "https://github.com/enriqueiborra/asgbd/blob/main/docs/automatitzacio-tasques.html"
click node_optimitzacio "https://github.com/enriqueiborra/asgbd/blob/main/docs/optimitzacio-sgbd.html"
click node_disponibilitat "https://github.com/enriqueiborra/asgbd/blob/main/docs/disponibilitat-sgbd.html"
click node_review "https://github.com/enriqueiborra/asgbd/blob/main/docs/repas-sql.html"
click node_assets_css "https://github.com/enriqueiborra/asgbd/blob/main/docs/estilsindex.css"
click node_assets_media "https://github.com/enriqueiborra/asgbd/tree/main/docs/imgs"
click node_sitemap "https://github.com/enriqueiborra/asgbd/blob/main/docs/sitemap.xml"
click node_questions "https://github.com/enriqueiborra/asgbd/tree/main/docs/preguntes"

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_readme,node_ud1,node_ud2,node_ud3,node_ud4,node_ud5,node_ud6,node_extra toneBlue
class node_home toneAmber
class node_instalacio,node_configuracio,node_usuaris,node_seguretat,node_automatitzacio,node_optimitzacio,node_disponibilitat,node_review toneMint
class node_assets_css,node_assets_media,node_sitemap toneRose
class node_questions toneIndigo
class node_pages,node_hosting toneTeal
```

## Components

### Source materials

Canonical PDFs and assessment criteria at the repository root.

- [README](https://github.com/enriqueiborra/asgbd/blob/main/README.md): repo guide · Entry point describing the course site and usage. · `README.md`
- [Unit 1](https://github.com/enriqueiborra/asgbd/tree/main/UD1): pdf unit · Installation and environment preparation. · `UD1`
- [Unit 2](https://github.com/enriqueiborra/asgbd/tree/main/UD2): pdf unit · Configuration, SQL review, tablespaces, and tools. · `UD2`
- [Unit 3](https://github.com/enriqueiborra/asgbd/tree/main/UD3): pdf unit · Users, privileges, and security. · `UD3`
- [Unit 4](https://github.com/enriqueiborra/asgbd/tree/main/UD4): pdf unit · Automation and procedural control. · `UD4`
- [Unit 5](https://github.com/enriqueiborra/asgbd/tree/main/UD5): pdf unit · Database optimization and tuning. · `UD5`
- [Unit 6](https://github.com/enriqueiborra/asgbd/tree/main/UD6): pdf unit · Database availability and resilience. · `UD6`
- [Extra pack](https://github.com/enriqueiborra/asgbd/tree/main/PLALOE_EXTR): pdf pack · Supplementary practice and deployment materials. · `PLALOE_EXTR`

### Static site

Prebuilt documentation site served from docs/.

- [Home](https://github.com/enriqueiborra/asgbd/blob/main/docs/index.html): site entry · Main landing page for the published documentation site. · `docs/index.html`

### Curriculum pages

Primary topic pages exposed in the site.

- [Installation](https://github.com/enriqueiborra/asgbd/blob/main/docs/instalacio-sgbd.html): topic page · Installation and setup content. · `docs/instalacio-sgbd.html`
- [Configuration](https://github.com/enriqueiborra/asgbd/blob/main/docs/configuracio-sgbd.html): topic page · Server and database configuration content. · `docs/configuracio-sgbd.html`
- [Users](https://github.com/enriqueiborra/asgbd/blob/main/docs/usuaris-privilegis.html): topic page · Users and privilege management. · `docs/usuaris-privilegis.html`
- [Security](https://github.com/enriqueiborra/asgbd/blob/main/docs/seguretat-mecanismes.html): topic page · Security mechanisms and controls. · `docs/seguretat-mecanismes.html`
- [Automation](https://github.com/enriqueiborra/asgbd/blob/main/docs/automatitzacio-tasques.html): topic page · Task automation and procedural logic. · `docs/automatitzacio-tasques.html`
- [Optimization](https://github.com/enriqueiborra/asgbd/blob/main/docs/optimitzacio-sgbd.html): topic page · Performance and tuning material. · `docs/optimitzacio-sgbd.html`
- [Availability](https://github.com/enriqueiborra/asgbd/blob/main/docs/disponibilitat-sgbd.html): topic page · High availability content. · `docs/disponibilitat-sgbd.html`
- [Review](https://github.com/enriqueiborra/asgbd/blob/main/docs/repas-sql.html): topic page · SQL and ER review pages. · `docs/repas-sql.html`

### Presentation assets

Styles, images, fonts, and site metadata.

- [Stylesheets](https://github.com/enriqueiborra/asgbd/blob/main/docs/estilsindex.css): css assets · Site-wide visual styling for index and unit pages. · `docs/estilsindex.css`
- [Media assets](https://github.com/enriqueiborra/asgbd/tree/main/docs/imgs): static assets · Image and font resources used by the static site. · `docs/imgs`
- [Sitemap](https://github.com/enriqueiborra/asgbd/blob/main/docs/sitemap.xml): site metadata · Search and navigation metadata for the published site. · `docs/sitemap.xml`

### Question bank

JSON datasets for self-assessment and exercises.

- [Quizzes](https://github.com/enriqueiborra/asgbd/tree/main/docs/preguntes): json bank · Structured question sets for unit self-assessment. · `docs/preguntes`

### Consumption

External hosting and browser access boundary.

- **Browser**: client · Students read the published site in a web browser.
- **GitHub Pages**: hosting · Static hosting boundary for the documentation site.

## Connections

- README → Home: points to · README directs readers to the published site.
- Unit 1 → Installation: publishes · Unit 1 content is exposed as installation pages.
- Unit 2 → Configuration: publishes · Unit 2 content is exposed as configuration pages.
- Unit 3 → Users: publishes · Unit 3 content is exposed as user and privilege pages.
- Unit 3 → Security: publishes · Security material is surfaced in the site.
- Unit 4 → Automation: publishes · Unit 4 content is exposed as automation pages.
- Unit 5 → Optimization: publishes · Unit 5 content is exposed as optimization pages.
- Unit 6 → Availability: publishes · Unit 6 content is exposed as availability pages.
- Extra pack → Review: supplements · Extra materials support reviews and applied practice.
- Quizzes → Installation: feeds · Question sets align with the installation curriculum.
- Quizzes → Configuration: feeds · Question sets align with configuration content.
- Quizzes → Users: feeds · Question sets align with users and privileges.
- Quizzes → Automation: feeds · Question sets align with automation content.
- Quizzes → Optimization: feeds · Question sets align with optimization content.
- Quizzes → Availability: feeds · Question sets align with availability content.
- Home → Stylesheets: uses · Landing page uses shared styling.
- Home → Media assets: uses · Landing page pulls media assets.
- Home → Sitemap: indexed by · Site navigation is supported by sitemap metadata.
- Home → Browser: consumed by · Students access the site via browser.
- GitHub Pages → Home: serves · Hosting serves the static site entry point.
- Browser → GitHub Pages: requests · Browsers retrieve the published documentation site.
