Planning and execution tracking — what is PLANNED
| Capability | Status | Progress | Est. Hours | Assigned To |
|---|---|---|---|---|
|
PostgreSQL ltree-based hierarchy materialization with GiST index
|
Completed |
0%
|
0h | — |
|
HierarchicalPolicyResolver with leaf-first-first-match-wins algorithm
|
Completed |
0%
|
0h | — |
|
Cache-aside with stampede protection via SET NX EX + tracked key sets
|
Completed |
0%
|
0h | — |
|
PolicyInvalidationProducer emits to policy.invalidation.v1 (log-compacted)
|
Completed |
0%
|
0h | — |
|
PolicyResolverMetrics: latency percentiles, cache hit ratio, invalidation counts
|
Completed |
0%
|
0h | — |
|
PolicyResolverConfig for gradual rollout by tenant/schema
|
Completed |
0%
|
0h | — |
|
No policy values in logs; only ids, keys, hashes, durations
|
Completed |
0%
|
0h | — |
|
Generation-token bump for large subtree invalidation (>1000 descendants)
|
Completed |
0%
|
0h | — |
| Capability | Status | Progress | Est. Hours | Assigned To |
|---|---|---|---|---|
|
Materialized ltree paths for market schema (289 rows)
|
Completed |
0%
|
0h | — |
|
resolveMarket() uses HierarchicalPolicyResolver for template inheritance
|
Completed |
0%
|
0h | — |
|
Policy attributes at market level for tax, pricing, accounting rules
|
In progress |
0%
|
0h | — |
|
Kafka-driven cache invalidation for market schema changes
|
Completed |
0%
|
0h | — |
| Capability | Status | Progress | Est. Hours | Assigned To |
|---|---|---|---|---|
|
Deploy hierarchy.contract_paths + ltree on user-sau-main-dev database
|
Pending |
0%
|
0h | — |
|
Hierarchy paths for order schema contracts
|
Pending |
0%
|
0h | — |
|
Hierarchy paths for inventory schema contracts
|
Pending |
0%
|
0h | — |
|
Hierarchy paths for accounting schema contracts
|
Pending |
0%
|
0h | — |
|
Hierarchy paths for finance schema contracts
|
Pending |
0%
|
0h | — |
|
Hierarchy paths for agreement schema contracts
|
Pending |
0%
|
0h | — |
| Capability | Status | Progress | Est. Hours | Assigned To |
|---|---|---|---|---|
|
Create banking schema with contract pattern + hierarchy paths
|
Pending |
0%
|
0h | — |
|
Create card schema with contract pattern + hierarchy paths
|
Pending |
0%
|
0h | — |
|
Create loyalty_card schema with contract pattern + hierarchy paths
|
Pending |
0%
|
0h | — |
|
Populate item schema with real product data and hierarchy
|
Pending |
0%
|
0h | — |
|
Integrate with production catalog service for item hierarchy
|
Pending |
0%
|
0h | — |
| Capability | Status | Progress | Est. Hours | Assigned To |
|---|---|---|---|---|
|
Include hierarchy rebuild in provisioning pipeline for new schemas
|
In progress |
0%
|
0h | — |
|
Quality gates for hierarchy rebuild + policy resolution correctness
|
In progress |
0%
|
0h | — |
|
Automated hierarchy snapshot backup to Google Cloud Storage
|
In progress |
0%
|
0h | — |
|
Central operational dashboard with hierarchy coverage, resolver health, quick actions
|
In progress |
0%
|
0h | — |
|
Automated evidence collection for governance audit trail
|
In progress |
0%
|
0h | — |