{
  "id": "lib-process:data-engineering-analytics--dimensional-model",
  "_kind": "LibraryProcess",
  "_file": "generated-library/processes.yaml",
  "_cluster": "generated-library",
  "attributes": {
    "displayName": "dimensional-model",
    "description": "Dimensional Model Design - Design comprehensive dimensional data warehouse models including\nbusiness process selection, grain definition, dimension identification, fact table design, star/snowflake\nschema patterns, and Slowly Changing Dimension (SCD) implementation following Kimball methodology.",
    "libraryPath": "library/specializations/data-engineering-analytics/dimensional-model.js",
    "specialization": "data-engineering-analytics",
    "references": [
      "- The Data Warehouse Toolkit (3rd Edition) by Ralph Kimball: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/\n- Kimball Dimensional Modeling Techniques: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/\n- Star Schema: The Complete Reference by Christopher Adamson: https://www.oreilly.com/library/view/star-schema-the/9780071744324/\n- Slowly Changing Dimensions: https://en.wikipedia.org/wiki/Slowly_changing_dimension"
    ],
    "example": "const result = await orchestrate('data-engineering-analytics/dimensional-model', {\n  projectName: 'Sales Analytics DW',\n  businessProcesses: ['order_fulfillment', 'customer_service', 'inventory_management'],\n  dataSource: { type: 'OLTP', database: 'sales_db', schema: 'public' },\n  requirements: { realTimeUpdates: true, historicalTracking: 'full', queryPerformance: 'high' }\n});",
    "usesAgents": [
      "business-analyst",
      "data-engineer",
      "data-architect",
      "data-modeler",
      "fact-designer",
      "schema-designer",
      "scd-architect",
      "validation-architect",
      "ddl-generator",
      "etl-architect",
      "documentation-specialist"
    ]
  },
  "outgoingEdges": [
    {
      "from": "lib-process:data-engineering-analytics--dimensional-model",
      "to": "domain:data-engineering",
      "kind": "lib_applies_to_domain",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--dimensional-model",
      "to": "workflow:data-pipeline-deployment",
      "kind": "lib_implements_workflow",
      "attributes": {
        "weight": 1
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--dimensional-model",
      "to": "specialization:data-engineering-analytics",
      "kind": "lib_belongs_to_specialization",
      "attributes": {
        "weight": 0.9
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--dimensional-model",
      "to": "lib-agent:data-science-ml--data-engineer",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    },
    {
      "from": "lib-process:data-engineering-analytics--dimensional-model",
      "to": "lib-agent:software-architecture--data-architect",
      "kind": "uses_agent",
      "attributes": {
        "weight": 0.8
      }
    }
  ],
  "incomingEdges": []
}