◀ Profile System

Profile System Maturity Scorecard

Evidence-based maturity assessment — what IS

39.9%
Overall Score 39.9%
Overview Phases Roadmap
0 = Missing
1 = Planned
2 = Partial
3 = Production
4 = Hardened
5 = Institutional

Core Engine

89%

Hierarchy ltree, policy resolver, Redis cache, Kafka invalidation, metrics, feature flags, safe logging, subtree tokens

8 capabilities Target: 100%

Market Domain

76.3%

Market hierarchy paths, template resolution, policy attrs, cache invalidation

4 capabilities Target: 100%

Cross-Database

2.7%

Hierarchy on user-sau-main-dev: order, inventory, accounting, finance, agreement schema paths

6 capabilities Target: 100%

Missing Domains

0%

Banking, card, loyalty card schemas; item data population; catalog production integration

5 capabilities Target: 100%

Operational Excellence

31.4%

Provisioning hierarchy step, quality integration, backup GCS upload, dashboard control plane, evidence pack

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