Agentic AI Reference Architecture

Orchestration · Data store

Database State Store

Data storeOrchestrationOrchestration & Toolsarc:DatabaseStateStore

A state checkpoint store that persists workflow state durably in a database.

Responsibility. Durably persists workflow state for long-running workflows.

Also known as: Durable state store, SQLite checkpointer, PostgreSQL checkpointer

Variant of State Checkpoint Store abstract

When to choose. Choose for long-running processes (hours or days) whose state must survive instance failure and be resumable by any instance.

specializesalternative toalternative toState Checkpoint Store: specializesState Checkpoint StoreIn-Memory State Store: alternative toIn-Memory State StoreDistributed Cache State Store: alternative toDistributed Cache State …
Direct neighbourhood (hover for relationship types)

Relationships

alternative to variability

Design guidance

Classification

Technologies
PostgreSQLSQLite
Quality attributes
Reliability (ISO/IEC 25010 | NIST AI RMF: valid and reliable)

Sources

  1. Ch1.5A: T. Nguyen, "Stateful Orchestration - Introduction and Core Concepts," in Mastering Agentic AI Systems: Guide for the NVIDIA NCP-AAI Exam, 1st ed. 2026, ch. 1.5A. ISBN: 9798244538229.
  2. Ch1.6: T. Nguyen, "Stateful Orchestration - Pitfalls, Integration, and Synthesis," in Mastering Agentic AI Systems: Guide for the NVIDIA NCP-AAI Exam, 1st ed. 2026, ch. 1.6. ISBN: 9798244538229.
  3. Ch2.2: T. Nguyen, "LangGraph," in Mastering Agentic AI Systems: Guide for the NVIDIA NCP-AAI Exam, 1st ed. 2026, ch. 2.2. ISBN: 9798244538229.