Solution Comparison:
┌──────────────────┬───────────┬───────────┬────────────┐
│ Solution         │ Real-time │ Semantics │ Decisions  │
├──────────────────┼───────────┼───────────┼────────────┤
│ Point-to-Point   │ Medium    │ None      │ None       │
│ ESB Integration  │ Med-High  │ Weak      │ None       │
│ Data Warehouse   │ Low (T+1) │ Weak      │ Limited    │
│ Coomia DIP       │ High (sec)│ Strong    │ Built-in   │
└──────────────────┴───────────┴───────────┴────────────┘

ObjectType: Transaction
  description: "Core business entity"
  properties:
    - id: string (PK)
    - name: string
    - type: enum
    - status: enum [Active, Inactive, Pending, Archived]
    - created_at: datetime
    - updated_at: datetime
    - created_by: string
    - priority: enum [Low, Normal, High, Critical]
    - metadata: dict
  computed_properties:
    - risk_score: float
    - health_index: float
    - trend: enum [Improving, Stable, Declining]

ObjectType: RiskScore
  description: "Supporting data entity"
  properties:
    - id: string (PK)
    - source_system: string
    - timestamp: datetime
    - value: float
    - unit: string
    - quality_flag: enum [Good, Suspect, Bad]
    - dimensions: dict
  time_series: true
  retention: "365d"

ObjectType: Rule
  description: "Process/event entity"
  properties:
    - id: string (PK)
    - type: enum
    - status: enum [Draft, Submitted, InReview, Approved, Rejected, Completed]
    - requester: string
    - start_time: datetime
    - end_time: datetime
    - result: string
    - severity: enum [Low, Medium, High, Critical]

ObjectType: AlertQueue
  description: "Analysis/decision entity"
  properties:
    - id: string (PK)
    - analysis_type: string
    - input_data: dict
    - result: dict
    - confidence: float [0-1]
    - model_version: string
    - generated_at: datetime

ObjectType: DecisionNode
  description: "Association/tracking entity"
  properties:
    - id: string (PK)
    - source_id: string
    - target_id: string
    - relation_type: string
    - weight: float
    - evidence: list[string]
    - discovered_at: datetime

Relations:
  - Transaction -> generates -> RiskScore
    cardinality: 1:N
    description: "Core entity generates data records"

  - Transaction -> triggers -> Rule
    cardinality: 1:N
    description: "Core entity triggers processes/events"

  - RiskScore -> analyzedBy -> AlertQueue
    cardinality: N:1
    description: "Data processed by analysis engine"

  - AlertQueue -> impacts -> Transaction
    cardinality: N:M
    description: "Analysis results feed back to core entities"

  - Transaction -> linkedVia -> DecisionNode
    cardinality: N:M
    description: "Inter-entity association tracking"

  - Rule -> resolvedBy -> AlertQueue
    cardinality: N:1
    description: "Events resolved through analysis"

Actions:
  CreateTransaction:
    description: "Create core entity"
    parameters:
      - name: string (required)
      - type: enum (required)
      - priority: enum (default: Normal)
    validation:
      - Name must be unique
      - Type must be within allowed range
    side_effects:
      - Creates associated initial records
      - Triggers notification rules
      - Updates statistical metrics

  UpdateTransactionStatus:
    description: "Update entity status"
    parameters:
      - id: string (required)
      - new_status: enum (required)
      - reason: string (required)
    side_effects:
      - Records status change history
      - Triggers downstream processes
      - Updates related entity statuses

  TriggerRule:
    description: "Trigger process/event handling"
    parameters:
      - source_id: string (required)
      - type: enum (required)
      - severity: enum (default: Medium)
    side_effects:
      - Creates event record
      - Notifies relevant personnel
      - Auto-escalates if severity high

  ExecuteAlertQueue:
    description: "Execute analysis/decision"
    parameters:
      - target_id: string (required)
      - analysis_type: string (required)
      - parameters: dict (optional)
    side_effects:
      - Collects relevant data
      - Invokes D(Reasoning) plane services
      - Generates results linked to source

  Escalate:
    description: "Escalate issue"
    parameters:
      - issue_id: string (required)
      - severity: enum [High, Critical]
      - escalate_to: string
    side_effects:
      - Updates priority
      - Sends urgent notifications
      - Creates escalation tracking

┌───────────────────────────────────────────────────────┐
│                   Application Layer                    │
│  ┌───────────┐  ┌────────────┐  ┌───────────┐        │
│  │ Dashboard  │  │  Reports   │  │  Mobile   │        │
│  └────┬──────┘  └─────┬──────┘  └────┬──────┘        │
│       └───────────────┼──────────────┘                │
│                       │                                │
│  ┌────────────────────┴────────────────────┐          │
│  │          Ontology Semantic Layer          │          │
│  │   Transaction --- RiskScore --- Rule            │
│  │       |           |           |                     │
│  │   AlertQueue ------- DecisionNode                  │
│  │   Unified Model / Query / RBAC            │          │
│  └────────────────────┬────────────────────┘          │
│                       │                                │
│  ┌─────────┐  ┌──────┴───────┐  ┌───────────┐        │
│  │ Plane B │  │   Plane C    │  │  Plane D  │        │
│  │ Control │  │   Data       │  │ Reasoning │        │
│  └─────────┘  └──────────────┘  └───────────┘        │
│                       │                                │
│  ┌────────────────────┴────────────────────┐          │
│  │   Data Ingestion: CDC|API|Stream|Batch   │          │
│  └─────────────────────────────────────────┘          │
└───────────────────────────────────────────────────────┘

sources:
  primary_database:
    type: cdc
    connector: debezium
    config:
      database.hostname: "db-host"
      database.port: 5432
      database.dbname: "production"
      table.include.list: "public.transaction,public.riskscore"
    mapping:
      transaction_table -> Transaction:
        id: record_id
        name: record_name
        status: current_status
      riskscore_table -> RiskScore:
        id: detail_id
        timestamp: created_at
        value: metric_value

  stream_source:
    type: kafka
    config:
      bootstrap.servers: "kafka:9092"
      topic: "finance-events"
      group.id: "mds-finance"
    mapping:
      event -> Rule:
        id: event_id
        timestamp: event_time
        type: event_type

from ontology_sdk import OntoPlatform

platform = OntoPlatform()

# 1. Query high-priority entities with associations
entities = (
    platform.ontology
    .object_type("Transaction")
    .filter(status="Active")
    .filter(priority__in=["High", "Critical"])
    .include("RiskScore")
    .include("Rule")
    .order_by("updated_at", ascending=False)
    .limit(100)
    .execute()
)

for entity in entities:
    print(f"Entity: {entity.name} | Risk: {entity.risk_score}")

    bad_data = [d for d in entity.riskscores
                if d.quality_flag == "Bad"]
    if len(bad_data) > 5:
        platform.actions.execute(
            "ExecuteAlertQueue",
            target_id=entity.id,
            analysis_type="anomaly_detection",
            parameters={"window": "24h"}
        )

# 2. Subscribe to real-time events
def on_event(event):
    if event.severity == "Critical":
        platform.actions.execute(
            "Escalate",
            issue_id=event.entity_id,
            severity="Critical",
            escalate_to="on_call_manager"
        )

platform.subscribe(
    object_type="Rule",
    events=["created", "severity_changed"],
    callback=on_event
)

# 3. What-if scenario analysis
scenario = platform.reasoning.what_if(
    base_state=platform.ontology.snapshot(),
    changes=[
        {"type": "modify", "entity": "Transaction",
          "id": "E001", "field": "status", "value": "Inactive"},
    ],
    evaluate=["impact_on_rule", "cascade_effects"]
)
print(f"Impact scope: {scenario.affected_count} entities")

rules:
  - name: "High Risk Alert"
    trigger: Transaction.risk_score > 80
    actions:
      - alert: critical
      - action: Escalate(severity=Critical)

  - name: "Trend Deterioration"
    trigger: Transaction.trend == "Declining" AND priority in [High, Critical]
    actions:
      - alert: warning
      - action: ExecuteAlertQueue(type=root_cause)

  - name: "Data Quality"
    trigger: RiskScore.quality_flag == "Bad" count > 10/hour
    actions:
      - alert: warning

  - name: "Auto-Escalation"
    trigger: Rule.severity == "Critical"
    actions:
      - action: Escalate(severity=Critical)
      - notification: sms -> on_call

Data Ingestion --> Rule Evaluation --> Decision --> Action Execution --> Feedback
  CDC              Plane D            ML/Rules    Auto/Manual          Tracking
  Stream           Ontology Query                 Notification         Model Update

from intelligence_plane.models import PredictionModel
from datetime import timedelta

class AlertQueueModel(PredictionModel):
    def __init__(self):
        super().__init__(
            name="alertqueue_v2",
            input_type="Transaction",
            output_type="AlertQueue"
        )

    def predict(self, entity, context):
        history = (
            context.ontology.object_type("RiskScore")
            .filter(source_id=entity.id)
            .filter(timestamp__gte=context.now - timedelta(days=90))
            .order_by("timestamp")
            .execute()
        )
        features = self.extract_features(history)
        prediction = self.model.predict(features)
        return {
            "level": prediction["level"],
            "confidence": prediction["confidence"],
            "factors": prediction["contributing_factors"],
            "actions": prediction["recommended_actions"]
        }

Year 1 ROI = (340 - 83) / 83 * 100% = 310%
3-Year ROI = (340*3 - 83 - 20*2) / (83 + 20*2) * 100% = 729%