Overview

The Enterprise Configuration Management Database (CMDB) is a highly scalable, event-driven platform built on a reactive architecture (Eclipse Vert.x) and backed by PostgreSQL. It provides a single system of record for IT infrastructure, supporting advanced multi-dataset reconciliation, AI-driven analytics (AIOps), high-availability clustering, and granular multi-tenant access control.

The platform is designed around a Zero-Trust, Multi-Tenant architecture, ensuring that every API request is cryptographically validated and strictly scoped. It transforms a passive database into an active automation orchestrator, utilising a real-time event bus, dynamic rule evaluation, and automated action dispatching.

Architecture

The LIKPI CMDB follows a decoupled, modular design. The backend is a reactive microservice, while the frontend is a modern Single Page Application (SPA).

Backend Core & Platform

The Java/Vert.x backend handles the fundamental operational logic, persistence, and platform security.

  • Reactive HTTP/API Router: A non-blocking API gateway managing all inbound REST requests.
  • PostgreSQL Persistence: Manages database interactions, schema-less JSONB operations, and table partitioning.
  • Activity & Reconciliation Engine: The “brain” of the CMDB, processing merges from staging datasets (SANDBOX) into PRODUCTION by enforcing identification rules, resolving UUIDs, and calculating attribute precedence.
  • RBAC & Multi-Tenant Security: Enforces Row-Level Security (RLS) and JWT-based Role-Based Access Control (RBAC) to separate data between tenants.
  • License & Quota Service: Validates the platform’s license and enforces limits on HA nodes, CI counts, and users.
  • HA Cluster Manager: Manages distributed state and coordinates background job execution via Hazelcast.

Frontend User Interface (UI)

The UI is a responsive SPA built with React, TypeScript, and Vite, styled with Tailwind CSS. Key modules include:

  • Graph Explorer: An interactive canvas (React Flow) for visualising CI dependencies.
  • Data Explorer: A tabular data management interface with an advanced query builder.
  • Dashboard Factory: A no-code, drag-and-drop editor for building analytical dashboards.
  • AIOps Assistant: A chat interface for natural language to SQL (NL2SQL) queries.

High-Level Topology

The system consists of the following tiers:

  • Tier 1 – Frontend: End users and APIs access the React SPA.
  • Tier 2 – Routing: An API Gateway / Load Balancer distributes traffic.
  • Tier 3 – Compute: Multiple Vert.x application nodes form an active-active cluster, synchronised via a Hazelcast Grid.
  • Tier 4 – Intelligence: A local Ollama model and a Cloud AI engine provide cognitive services.
  • Tier 5 – Storage: A PostgreSQL Primary database with read-only replicas ensures data durability and read scalability.