Visual Overview

Abstraction and Backend Logic

These flowcharts outline how the platform handles startup, connection management, routing, caching, and analysis endpoints.

Abstraction Layer Flow Backend Flow

Frontend Interaction Flow

This diagram shows how users interact with the platform Dash interface, from loading dropdowns to exporting processed results.

Frontend Flow

Front-End Interaction Overview

This annotated screenshot highlights key interactive elements of the Dash interface. Users can select databases, define query ranges, retrieve cached Redis data, and trigger both raw and processed analysis pipelines. The design supports rapid switching between live queries and historical lookups.

Dash Interface with Button Map

Numbered elements correspond to input components, dropdowns, and controls used throughout the analysis workflow

  1. Go to Home Page – Navigate back to NGINX landing page
  2. Clear – Reset frontend interface and clear inputs
  3. Download CSV – Export current analysis output
  4. Config – Open configuration options
  5. Add Database – Add new endpoint credentials to internal system
  6. Database Selector – Select database to query
  7. Table Selector – Choose specific table, view or other from selected DB
  8. Start / End Date – Select time range for raw data query
  9. Get Raw Data – Send query request to backend
  10. Raw Redis Key Input – Manually enter Redis key for past query
  11. Analysis Type Selector – Choose method available from the analysis engine
  12. Process Data – Trigger backend analysis pipeline
  13. Retrieve from Redis – Load previous raw query from cache, container populates session keys here
  14. Retrieve Processed from Redis – Load past analysis result from cache, container populates session keys here
  15. Graph Axis Selectors – System configures variables for X, Y, and plot type

Local Server Deployment

The platform is hosted on a Dell OptiPlex 3050 Micro running Proxmox VE. This setup provides isolated containers for each service and allows full control over system resources, startup routines, and local testing. It also reflects real-world industrial constraints where edge-hosted services are needed.

Dell OptiPlex 3050