<!-- CANARY: REQ=REQ-DOCS-001; FEATURE="Docs"; ASPECT=Documentation; STATUS=TESTED; OWNER=docs; UPDATED=2026-01-15 -->
<h2 id="supply-chain-optimization" class="position-relative d-flex align-items-center group">
<span>Supply Chain Optimization</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="supply-chain-optimization"
aria-haspopup="dialog"
aria-label="Share link: Supply Chain Optimization">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h2><div id="headingShareModal" class="heading-share-modal" role="dialog" aria-modal="true" aria-labelledby="headingShareTitle" hidden>
<div class="hsm-dialog" role="document">
<div class="hsm-header">
<h2 id="headingShareTitle" class="h6 mb-0 fw-bold">Share this section</h2>
<button type="button" class="hsm-close" aria-label="Close">
<i class="fa-solid fa-xmark"></i>
</button>
</div>
<div class="hsm-body">
<label for="headingShareInput" class="form-label small text-muted mb-1 text-uppercase fw-bold" style="font-size: 0.7rem; letter-spacing: 0.5px;">Permalink</label>
<div class="input-group mb-4 hsm-url-group">
<input id="headingShareInput" type="text" class="form-control font-monospace" readonly aria-readonly="true" style="font-size: 0.85rem;" />
<button class="btn btn-primary hsm-copy" type="button" aria-label="Copy" title="Copy">
<i class="fa-duotone fa-clipboard" aria-hidden="true"></i>
</button>
</div>
<div class="small fw-bold mb-2 text-muted text-uppercase" style="font-size: 0.7rem; letter-spacing: 0.5px;">Share via</div>
<div class="hsm-share-grid">
<a id="share-twitter" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer">
<i class="fa-brands fa-twitter me-2"></i>Twitter
</a>
<a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer">
<i class="fa-brands fa-linkedin me-2"></i>LinkedIn
</a>
<a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer">
<i class="fa-brands fa-facebook me-2"></i>Facebook
</a>
</div>
</div>
</div>
</div>
<style>
.heading-share-modal {
position: fixed;
inset: 0;
display: flex;
justify-content: center;
align-items: center;
background: rgba(0, 0, 0, 0.6);
z-index: 1050;
padding: 1rem;
backdrop-filter: blur(4px);
-webkit-backdrop-filter: blur(4px);
}
.heading-share-modal[hidden] { display: none !important; }
.hsm-dialog {
max-width: 420px;
width: 100%;
background: var(--bs-body-bg, #fff);
color: var(--bs-body-color, #212529);
border: 1px solid var(--bs-border-color, rgba(0,0,0,0.1));
border-radius: 1rem;
box-shadow: 0 25px 50px -12px rgba(0, 0, 0, 0.25);
overflow: hidden;
animation: hsm-fade-in 0.2s ease-out;
}
@keyframes hsm-fade-in {
from { opacity: 0; transform: scale(0.95); }
to { opacity: 1; transform: scale(1); }
}
[data-bs-theme="dark"] .hsm-dialog {
background: #1e293b;
border-color: rgba(255,255,255,0.1);
color: #f8f9fa;
}
.hsm-header {
display: flex;
justify-content: space-between;
align-items: center;
padding: 1rem 1.5rem;
border-bottom: 1px solid var(--bs-border-color, rgba(0,0,0,0.1));
background: rgba(0,0,0,0.02);
}
[data-bs-theme="dark"] .hsm-header {
background: rgba(255,255,255,0.02);
border-color: rgba(255,255,255,0.1);
}
.hsm-close {
background: transparent;
border: none;
color: inherit;
opacity: 0.5;
padding: 0.25rem 0.5rem;
border-radius: 0.25rem;
font-size: 1.2rem;
line-height: 1;
transition: opacity 0.2s;
}
.hsm-close:hover {
opacity: 1;
}
.hsm-body {
padding: 1.5rem;
}
.hsm-url-group {
display: flex !important;
align-items: stretch;
}
.hsm-url-group .form-control {
flex: 1;
min-width: 0;
margin: 0;
background: var(--bs-secondary-bg, #f8f9fa);
border-color: var(--bs-border-color, #dee2e6);
border-top-right-radius: 0;
border-bottom-right-radius: 0;
height: 42px;
}
.hsm-url-group .btn {
flex: 0 0 auto;
margin: 0;
margin-left: -1px;
border-top-left-radius: 0;
border-bottom-left-radius: 0;
height: 42px;
display: flex;
align-items: center;
justify-content: center;
padding: 0 1.25rem;
z-index: 2;
}
[data-bs-theme="dark"] .hsm-url-group .form-control {
background: #0f172a;
border-color: #334155;
color: #e2e8f0;
}
.hsm-share-grid {
display: flex;
flex-direction: column;
gap: 0.5rem;
}
.hsm-share-grid .btn {
display: flex;
align-items: center;
justify-content: center;
font-size: 0.9rem;
padding: 0.6rem;
border-color: var(--bs-border-color);
width: 100%;
}
[data-bs-theme="dark"] .hsm-share-grid .btn {
color: #e2e8f0;
border-color: #475569;
}
[data-bs-theme="dark"] .hsm-share-grid .btn:hover {
background: #334155;
border-color: #cbd5e1;
}
</style>
<script>
(function(){
const modal = document.getElementById('headingShareModal');
if(!modal) return;
const input = modal.querySelector('#headingShareInput');
const copyBtn = modal.querySelector('.hsm-copy');
const twitter = modal.querySelector('#share-twitter');
const linkedin = modal.querySelector('#share-linkedin');
const facebook = modal.querySelector('#share-facebook');
const closeBtn = modal.querySelector('.hsm-close');
let lastFocus=null;
let trapBound=false;
function buildUrl(id){ return window.location.origin + window.location.pathname + '#' + id; }
function isOpen(){ return !modal.hasAttribute('hidden'); }
function hydrate(id){
const url=buildUrl(id);
input.value=url;
const enc=encodeURIComponent(url);
const text=encodeURIComponent(document.title);
if(twitter) twitter.href=`https://twitter.com/intent/tweet?url=${enc}&text=${text}`;
if(linkedin) linkedin.href=`https://www.linkedin.com/sharing/share-offsite/?url=${enc}`;
if(facebook) facebook.href=`https://www.facebook.com/sharer/sharer.php?u=${enc}`;
}
function openModal(id){
lastFocus=document.activeElement;
hydrate(id);
if(!isOpen()){
modal.removeAttribute('hidden');
}
requestAnimationFrame(()=>{ input.focus(); });
trapFocus();
}
function closeModal(){
if(!isOpen()) return;
modal.setAttribute('hidden','');
if(lastFocus && typeof lastFocus.focus==='function') lastFocus.focus();
}
function copyCurrent(){
try{ navigator.clipboard.writeText(input.value).then(()=>feedback(true),()=>fallback()); }
catch(e){ fallback(); }
}
function fallback(){ input.select(); try{ document.execCommand('copy'); feedback(true);}catch(e){ feedback(false);} }
function feedback(ok){ if(!copyBtn) return; const icon=copyBtn.querySelector('i'); if(!icon) return; const prev=copyBtn.getAttribute('data-prev')||icon.className; if(!copyBtn.getAttribute('data-prev')) copyBtn.setAttribute('data-prev',prev); icon.className= ok ? 'fa-duotone fa-clipboard-check':'fa-duotone fa-circle-exclamation'; setTimeout(()=>{ icon.className=prev; },1800); }
function handleShareClick(e){ e.preventDefault(); const btn=e.currentTarget; const id=btn.getAttribute('data-share-target'); if(id) openModal(id); }
function bindShareButtons(){
document.querySelectorAll('.h-share').forEach(btn=>{
if(!btn.dataset.hShareBound){ btn.addEventListener('click', handleShareClick); btn.dataset.hShareBound='1'; }
});
}
bindShareButtons();
if(document.readyState==='loading'){
document.addEventListener('DOMContentLoaded', bindShareButtons);
} else {
requestAnimationFrame(bindShareButtons);
}
document.addEventListener('click', function(e){
const shareBtn=e.target.closest && e.target.closest('.h-share');
if(shareBtn && !shareBtn.dataset.hShareBound){ handleShareClick.call(shareBtn, e); }
}, true);
document.addEventListener('click', e=>{
if(e.target===modal) closeModal();
if(e.target.closest && e.target.closest('.hsm-close')){ e.preventDefault(); closeModal(); }
if(copyBtn && (e.target===copyBtn || (e.target.closest && e.target.closest('.hsm-copy')))) { e.preventDefault(); copyCurrent(); }
});
document.addEventListener('keydown', e=>{ if(e.key==='Escape' && isOpen()) closeModal(); });
function trapFocus(){
if(trapBound) return;
trapBound=true;
modal.addEventListener('keydown', f=>{ if(f.key==='Tab' && isOpen()){ const focusable=[...modal.querySelectorAll('a[href],button,input,textarea,select,[tabindex]:not([tabindex="-1"])')].filter(el=>!el.hasAttribute('disabled')); if(!focusable.length) return; const first=focusable[0]; const last=focusable[focusable.length-1]; if(f.shiftKey && document.activeElement===first){ f.preventDefault(); last.focus(); } else if(!f.shiftKey && document.activeElement===last){ f.preventDefault(); first.focus(); } } });
}
if(closeBtn) closeBtn.addEventListener('click', e=>{ e.preventDefault(); closeModal(); });
})();
</script><p>Optimize supply chain operations with Geode for route planning, inventory tracking, and real-time logistics analytics.</p>
<h3 id="overview" class="position-relative d-flex align-items-center group">
<span>Overview</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="overview"
aria-haspopup="dialog"
aria-label="Share link: Overview">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><p>Supply chain networks are inherently graph-structured with warehouses, distribution centers, suppliers, and customers connected by transportation routes. Geode provides efficient path finding, network analysis, and real-time tracking capabilities.</p>
<h4 id="key-capabilities" class="position-relative d-flex align-items-center group">
<span>Key Capabilities</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="key-capabilities"
aria-haspopup="dialog"
aria-label="Share link: Key Capabilities">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><ul>
<li><strong>Route Optimization</strong>: Find shortest/cheapest paths for deliveries</li>
<li><strong>Inventory Tracking</strong>: Monitor stock levels across network</li>
<li><strong>Supplier Network Analysis</strong>: Identify dependencies and risks</li>
<li><strong>Real-Time Logistics</strong>: Track shipments and update ETAs</li>
<li><strong>Bottleneck Detection</strong>: Find congestion points in network</li>
<li><strong>Multi-Modal Transport</strong>: Optimize across truck/rail/ship/air</li>
</ul>
<h3 id="use-case-scenarios" class="position-relative d-flex align-items-center group">
<span>Use Case Scenarios</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="use-case-scenarios"
aria-haspopup="dialog"
aria-label="Share link: Use Case Scenarios">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="1-last-mile-delivery-optimization" class="position-relative d-flex align-items-center group">
<span>1. Last-Mile Delivery Optimization</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="1-last-mile-delivery-optimization"
aria-haspopup="dialog"
aria-label="Share link: 1. Last-Mile Delivery Optimization">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p><strong>Challenge</strong>: Minimize delivery time and cost for final leg to customers</p>
<p><strong>Solution</strong>: Model delivery network with:</p>
<ul>
<li>Warehouses and distribution centers</li>
<li>Customer locations</li>
<li>Routes with distance, time, traffic</li>
<li>Vehicle capacity constraints</li>
</ul>
<p><strong>Benefits</strong>:</p>
<ul>
<li>Reduced delivery times (15-30%)</li>
<li>Lower fuel costs (10-20%)</li>
<li>Improved customer satisfaction</li>
<li>Dynamic route adjustments</li>
</ul>
<h4 id="2-multi-tier-supplier-network" class="position-relative d-flex align-items-center group">
<span>2. Multi-Tier Supplier Network</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="2-multi-tier-supplier-network"
aria-haspopup="dialog"
aria-label="Share link: 2. Multi-Tier Supplier Network">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p><strong>Challenge</strong>: Manage complex supplier dependencies and risks</p>
<p><strong>Solution</strong>: Build supplier graph with:</p>
<ul>
<li>Suppliers at multiple tiers</li>
<li>Component dependencies</li>
<li>Lead times and capacities</li>
<li>Geographic risks</li>
</ul>
<p><strong>Benefits</strong>:</p>
<ul>
<li>Identify single points of failure</li>
<li>Assess cascade impact</li>
<li>Optimize supplier mix</li>
<li>Plan contingencies</li>
</ul>
<h4 id="3-warehouse-network-optimization" class="position-relative d-flex align-items-center group">
<span>3. Warehouse Network Optimization</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="3-warehouse-network-optimization"
aria-haspopup="dialog"
aria-label="Share link: 3. Warehouse Network Optimization">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><p><strong>Challenge</strong>: Determine optimal warehouse locations and inventory levels</p>
<p><strong>Solution</strong>: Model warehouse network:</p>
<ul>
<li>Warehouse locations and capacities</li>
<li>Customer demand patterns</li>
<li>Transportation costs</li>
<li>Service level requirements</li>
</ul>
<p><strong>Benefits</strong>:</p>
<ul>
<li>Minimize total logistics costs</li>
<li>Reduce inventory holding</li>
<li>Improve service levels</li>
<li>Optimize warehouse placement</li>
</ul>
<h3 id="data-model" class="position-relative d-flex align-items-center group">
<span>Data Model</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="data-model"
aria-haspopup="dialog"
aria-label="Share link: Data Model">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="network-entities" class="position-relative d-flex align-items-center group">
<span>Network Entities</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="network-entities"
aria-haspopup="dialog"
aria-label="Share link: Network Entities">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="py">CREATE</span><span class="w"> </span><span class="py">GRAPH</span><span class="w"> </span><span class="py">SupplyChainNetwork</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">USE</span><span class="w"> </span><span class="py">SupplyChainNetwork</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Facilities</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Seattle</span><span class="w"> </span><span class="py">Distribution</span><span class="w"> </span><span class="py">Center</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">location</span><span class="p">:</span><span class="w"> </span><span class="nc">point</span><span class="p">({</span><span class="py">latitude</span><span class="p">:</span><span class="w"> </span><span class="nc">47</span><span class="mf">.6062</span><span class="p">,</span><span class="w"> </span><span class="py">longitude</span><span class="p">:</span><span class="w"> </span><span class="err">-</span><span class="nc">122</span><span class="mf">.3321</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">capacity</span><span class="p">:</span><span class="w"> </span><span class="nc">100000</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">current_inventory</span><span class="p">:</span><span class="w"> </span><span class="nc">75000</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_2</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Portland</span><span class="w"> </span><span class="py">Hub</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">location</span><span class="p">:</span><span class="w"> </span><span class="nc">point</span><span class="p">({</span><span class="py">latitude</span><span class="p">:</span><span class="w"> </span><span class="nc">45</span><span class="mf">.5152</span><span class="p">,</span><span class="w"> </span><span class="py">longitude</span><span class="p">:</span><span class="w"> </span><span class="err">-</span><span class="nc">122</span><span class="mf">.6784</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">capacity</span><span class="p">:</span><span class="w"> </span><span class="nc">50000</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">current_inventory</span><span class="p">:</span><span class="w"> </span><span class="nc">30000</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Supplier</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">sup_1</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Component</span><span class="w"> </span><span class="py">Manufacturer</span><span class="w"> </span><span class="py">Inc</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">location</span><span class="p">:</span><span class="w"> </span><span class="nc">point</span><span class="p">({</span><span class="py">latitude</span><span class="p">:</span><span class="w"> </span><span class="nc">37</span><span class="mf">.7749</span><span class="p">,</span><span class="w"> </span><span class="py">longitude</span><span class="p">:</span><span class="w"> </span><span class="err">-</span><span class="nc">122</span><span class="mf">.4194</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">lead_time_days</span><span class="p">:</span><span class="w"> </span><span class="nc">7</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reliability</span><span class="p">:</span><span class="w"> </span><span class="nc">0</span><span class="mf">.95</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Customer</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">cust_1</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ABC</span><span class="w"> </span><span class="py">Retail</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">location</span><span class="p">:</span><span class="w"> </span><span class="nc">point</span><span class="p">({</span><span class="py">latitude</span><span class="p">:</span><span class="w"> </span><span class="nc">47</span><span class="mf">.6101</span><span class="p">,</span><span class="w"> </span><span class="py">longitude</span><span class="p">:</span><span class="w"> </span><span class="err">-</span><span class="nc">122</span><span class="mf">.2015</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">demand_weekly</span><span class="p">:</span><span class="w"> </span><span class="nc">500</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="routes-and-costs" class="position-relative d-flex align-items-center group">
<span>Routes and Costs</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="routes-and-costs"
aria-haspopup="dialog"
aria-label="Share link: Routes and Costs">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Transportation</span><span class="w"> </span><span class="py">routes</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh1</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">wh2</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_2</span><span class="err">'</span><span class="p">})</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">wh1</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">distance_km</span><span class="p">:</span><span class="w"> </span><span class="nc">280</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">time_hours</span><span class="p">:</span><span class="w"> </span><span class="nc">3</span><span class="mf">.5</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cost_per_unit</span><span class="p">:</span><span class="w"> </span><span class="nc">0</span><span class="mf">.50</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">mode</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">truck</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">capacity</span><span class="p">:</span><span class="w"> </span><span class="nc">5000</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">}]</span><span class="err">-></span><span class="p">(</span><span class="py">wh2</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">cust_1</span><span class="err">'</span><span class="p">})</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">distance_km</span><span class="p">:</span><span class="w"> </span><span class="nc">15</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">time_hours</span><span class="p">:</span><span class="w"> </span><span class="nc">0</span><span class="mf">.5</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cost_per_unit</span><span class="p">:</span><span class="w"> </span><span class="nc">0</span><span class="mf">.25</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">mode</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">van</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">capacity</span><span class="p">:</span><span class="w"> </span><span class="nc">100</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">}]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Supplier</span><span class="w"> </span><span class="py">relationships</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">sup</span><span class="p">:</span><span class="nc">Supplier</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">sup_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">})</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">sup</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">SUPPLIES</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">lead_time_days</span><span class="p">:</span><span class="w"> </span><span class="nc">7</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">min_order_quantity</span><span class="p">:</span><span class="w"> </span><span class="nc">1000</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cost_per_unit</span><span class="p">:</span><span class="w"> </span><span class="nc">5</span><span class="mf">.00</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reliability</span><span class="p">:</span><span class="w"> </span><span class="nc">0</span><span class="mf">.95</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">}]</span><span class="err">-></span><span class="p">(</span><span class="py">wh</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="inventory-and-products" class="position-relative d-flex align-items-center group">
<span>Inventory and Products</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="inventory-and-products"
aria-haspopup="dialog"
aria-label="Share link: Inventory and Products">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Products</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Product</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">prod_1</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">sku</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">WIDGET</span><span class="err">-</span><span class="py">001</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Standard</span><span class="w"> </span><span class="py">Widget</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">unit_cost</span><span class="p">:</span><span class="w"> </span><span class="nc">5</span><span class="mf">.00</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">unit_price</span><span class="p">:</span><span class="w"> </span><span class="nc">15</span><span class="mf">.00</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">weight_kg</span><span class="p">:</span><span class="w"> </span><span class="nc">0</span><span class="mf">.5</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Product</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">prod_2</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">sku</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">GADGET</span><span class="err">-</span><span class="py">001</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Premium</span><span class="w"> </span><span class="py">Gadget</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">unit_cost</span><span class="p">:</span><span class="w"> </span><span class="nc">20</span><span class="mf">.00</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">unit_price</span><span class="p">:</span><span class="w"> </span><span class="nc">60</span><span class="mf">.00</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">weight_kg</span><span class="p">:</span><span class="w"> </span><span class="nc">2</span><span class="mf">.0</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Inventory</span><span class="w"> </span><span class="py">at</span><span class="w"> </span><span class="py">locations</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">prod</span><span class="p">:</span><span class="nc">Product</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">prod_1</span><span class="err">'</span><span class="p">})</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">STOCKS</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">quantity</span><span class="p">:</span><span class="w"> </span><span class="nc">5000</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reorder_point</span><span class="p">:</span><span class="w"> </span><span class="nc">1000</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reorder_quantity</span><span class="p">:</span><span class="w"> </span><span class="nc">2000</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">last_updated</span><span class="p">:</span><span class="w"> </span><span class="nc">timestamp</span><span class="p">()</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">}]</span><span class="err">-></span><span class="p">(</span><span class="py">prod</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h3 id="implementation-guide" class="position-relative d-flex align-items-center group">
<span>Implementation Guide</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="implementation-guide"
aria-haspopup="dialog"
aria-label="Share link: Implementation Guide">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="step-1-route-optimization" class="position-relative d-flex align-items-center group">
<span>Step 1: Route Optimization</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="step-1-route-optimization"
aria-haspopup="dialog"
aria-label="Share link: Step 1: Route Optimization">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4>
<h5 id="shortest-path-distance" class="position-relative d-flex align-items-center group">
<span>Shortest Path (Distance)</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="shortest-path-distance"
aria-haspopup="dialog"
aria-label="Share link: Shortest Path (Distance)">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">shortest</span><span class="w"> </span><span class="py">route</span><span class="w"> </span><span class="py">from</span><span class="w"> </span><span class="py">warehouse</span><span class="w"> </span><span class="py">to</span><span class="w"> </span><span class="py">customer</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">cust_1</span><span class="err">'</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">path</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">shortestPath</span><span class="p">((</span><span class="py">wh</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="err">*</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">))</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">n</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">nodes</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">route</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">dist</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">dist</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">distance_km</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_distance</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">time</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">time</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">time_hours</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_time</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h5 id="cheapest-path-cost" class="position-relative d-flex align-items-center group">
<span>Cheapest Path (Cost)</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="cheapest-path-cost"
aria-haspopup="dialog"
aria-label="Share link: Cheapest Path (Cost)">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">cheapest</span><span class="w"> </span><span class="py">route</span><span class="w"> </span><span class="py">using</span><span class="w"> </span><span class="py">Dijkstra</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">graph</span><span class="err">.</span><span class="py">dijkstra</span><span class="p">(</span><span class="err">'</span><span class="py">SupplyChainNetwork</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">start_node</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="nc">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">},</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">end_node</span><span class="p">:</span><span class="w"> </span><span class="p">{</span><span class="nc">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">cust_1</span><span class="err">'</span><span class="p">},</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">relationship_type</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ROUTE</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">weight_property</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">cost_per_unit</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">minimize</span><span class="p">:</span><span class="w"> </span><span class="nc">true</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">})</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">YIELD</span><span class="w"> </span><span class="py">path</span><span class="p">,</span><span class="w"> </span><span class="py">cost</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">n</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">nodes</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">route</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cost</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_cost</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">length</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">hops</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h5 id="multi-constraint-optimization" class="position-relative d-flex align-items-center group">
<span>Multi-Constraint Optimization</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="multi-constraint-optimization"
aria-haspopup="dialog"
aria-label="Share link: Multi-Constraint Optimization">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">route</span><span class="w"> </span><span class="py">optimizing</span><span class="w"> </span><span class="py">multiple</span><span class="w"> </span><span class="py">factors</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">cust_1</span><span class="err">'</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">path</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="err">*</span><span class="py">1</span><span class="err">.</span><span class="mf">.5</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">path</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">dist</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">dist</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">distance_km</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">distance</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">cost</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">cost</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">cost_per_unit</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">cost</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">time</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">time</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">time_hours</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">time</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">time</span><span class="w"> </span><span class="err"><</span><span class="p">=</span><span class="w"> </span><span class="py">24</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Delivery</span><span class="w"> </span><span class="py">within</span><span class="w"> </span><span class="py">24</span><span class="w"> </span><span class="py">hours</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">n</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">nodes</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">route</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">distance</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cost</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">time</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(</span><span class="py">cost</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">0</span><span class="mf">.5</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">time</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">0</span><span class="mf">.3</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">distance</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">0</span><span class="mf">.2</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">composite_score</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">composite_score</span><span class="w"> </span><span class="py">ASC</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">LIMIT</span><span class="w"> </span><span class="py">1</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="step-2-inventory-management" class="position-relative d-flex align-items-center group">
<span>Step 2: Inventory Management</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="step-2-inventory-management"
aria-haspopup="dialog"
aria-label="Share link: Step 2: Inventory Management">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4>
<h5 id="stock-level-monitoring" class="position-relative d-flex align-items-center group">
<span>Stock Level Monitoring</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="stock-level-monitoring"
aria-haspopup="dialog"
aria-label="Share link: Stock Level Monitoring">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">low</span><span class="w"> </span><span class="py">inventory</span><span class="w"> </span><span class="py">items</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">loc</span><span class="p">:</span><span class="nc">Warehouse</span><span class="p">)</span><span class="err">-</span><span class="p">[</span><span class="py">stock</span><span class="p">:</span><span class="nc">STOCKS</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">prod</span><span class="p">:</span><span class="nc">Product</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">quantity</span><span class="w"> </span><span class="err"><</span><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">reorder_point</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">loc</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">warehouse</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">prod</span><span class="err">.</span><span class="py">sku</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">prod</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">quantity</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">current_stock</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">reorder_point</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">reorder_quantity</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">suggested_order</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="p">(</span><span class="py">stock</span><span class="err">.</span><span class="py">reorder_point</span><span class="w"> </span><span class="err">-</span><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">quantity</span><span class="p">)</span><span class="w"> </span><span class="py">DESC</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h5 id="inventory-optimization" class="position-relative d-flex align-items-center group">
<span>Inventory Optimization</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="inventory-optimization"
aria-haspopup="dialog"
aria-label="Share link: Inventory Optimization">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Calculate</span><span class="w"> </span><span class="py">optimal</span><span class="w"> </span><span class="py">stock</span><span class="w"> </span><span class="py">distribution</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="p">)</span><span class="err">-</span><span class="p">[</span><span class="py">stock</span><span class="p">:</span><span class="nc">STOCKS</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">prod</span><span class="p">:</span><span class="nc">Product</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">OPTIONAL</span><span class="w"> </span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">wh</span><span class="p">,</span><span class="w"> </span><span class="py">prod</span><span class="p">,</span><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">quantity</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">current_stock</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">sum</span><span class="p">(</span><span class="py">cust</span><span class="err">.</span><span class="py">demand_weekly</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">weekly_demand</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">wh</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">prod</span><span class="err">.</span><span class="py">sku</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">current_stock</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">weekly_demand</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">CASE</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">WHEN</span><span class="w"> </span><span class="py">current_stock</span><span class="w"> </span><span class="err"><</span><span class="w"> </span><span class="py">weekly_demand</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">2</span><span class="w"> </span><span class="py">THEN</span><span class="w"> </span><span class="err">'</span><span class="py">CRITICAL</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">WHEN</span><span class="w"> </span><span class="py">current_stock</span><span class="w"> </span><span class="err"><</span><span class="w"> </span><span class="py">weekly_demand</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">4</span><span class="w"> </span><span class="py">THEN</span><span class="w"> </span><span class="err">'</span><span class="py">LOW</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">ELSE</span><span class="w"> </span><span class="err">'</span><span class="py">ADEQUATE</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">END</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">stock_status</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(</span><span class="py">weekly_demand</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">4</span><span class="w"> </span><span class="err">-</span><span class="w"> </span><span class="py">current_stock</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">recommended_reorder</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="step-3-supplier-network-analysis" class="position-relative d-flex align-items-center group">
<span>Step 3: Supplier Network Analysis</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="step-3-supplier-network-analysis"
aria-haspopup="dialog"
aria-label="Share link: Step 3: Supplier Network Analysis">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4>
<h5 id="identify-critical-suppliers" class="position-relative d-flex align-items-center group">
<span>Identify Critical Suppliers</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="identify-critical-suppliers"
aria-haspopup="dialog"
aria-label="Share link: Identify Critical Suppliers">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">suppliers</span><span class="w"> </span><span class="py">with</span><span class="w"> </span><span class="py">high</span><span class="w"> </span><span class="py">impact</span><span class="w"> </span><span class="p">(</span><span class="py">many</span><span class="w"> </span><span class="py">downstream</span><span class="w"> </span><span class="py">customers</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">sup</span><span class="p">:</span><span class="nc">Supplier</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">SUPPLIES</span><span class="err">*</span><span class="py">1</span><span class="err">.</span><span class="mf">.3</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">node</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">sup</span><span class="p">,</span><span class="w"> </span><span class="py">count</span><span class="p">(</span><span class="py">DISTINCT</span><span class="w"> </span><span class="py">node</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">reach</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">reach</span><span class="w"> </span><span class="py">DESC</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">sup</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">sup</span><span class="err">.</span><span class="py">reliability</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reach</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">network_reach</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">CASE</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">WHEN</span><span class="w"> </span><span class="py">sup</span><span class="err">.</span><span class="py">reliability</span><span class="w"> </span><span class="err"><</span><span class="w"> </span><span class="py">0</span><span class="mf">.8</span><span class="w"> </span><span class="py">THEN</span><span class="w"> </span><span class="err">'</span><span class="py">HIGH_RISK</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">WHEN</span><span class="w"> </span><span class="py">reach</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">10</span><span class="w"> </span><span class="py">THEN</span><span class="w"> </span><span class="err">'</span><span class="py">CRITICAL</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">ELSE</span><span class="w"> </span><span class="err">'</span><span class="py">NORMAL</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">END</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">risk_level</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h5 id="supply-chain-risk-assessment" class="position-relative d-flex align-items-center group">
<span>Supply Chain Risk Assessment</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="supply-chain-risk-assessment"
aria-haspopup="dialog"
aria-label="Share link: Supply Chain Risk Assessment">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">single</span><span class="w"> </span><span class="py">points</span><span class="w"> </span><span class="py">of</span><span class="w"> </span><span class="py">failure</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="py">path</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="p">(</span><span class="py">sup</span><span class="p">:</span><span class="nc">Supplier</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">SUPPLIES</span><span class="err">*</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="err">*</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">sup</span><span class="p">,</span><span class="w"> </span><span class="py">cust</span><span class="p">,</span><span class="w"> </span><span class="py">count</span><span class="p">(</span><span class="py">DISTINCT</span><span class="w"> </span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">alternative_paths</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">alternative_paths</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">1</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">sup</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">critical_supplier</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cust</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">affected_customer</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="err">'</span><span class="py">SINGLE_PATH</span><span class="err">'</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">risk_type</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Geographic</span><span class="w"> </span><span class="py">concentration</span><span class="w"> </span><span class="py">risk</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">sup</span><span class="p">:</span><span class="nc">Supplier</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">sup</span><span class="err">.</span><span class="py">location</span><span class="err">.</span><span class="py">latitude</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">lat</span><span class="p">,</span><span class="w"> </span><span class="py">sup</span><span class="err">.</span><span class="py">location</span><span class="err">.</span><span class="py">longitude</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">lon</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">count</span><span class="p">(</span><span class="py">sup</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">supplier_count</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">supplier_count</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">5</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">point</span><span class="p">({</span><span class="py">latitude</span><span class="p">:</span><span class="w"> </span><span class="nc">lat</span><span class="p">,</span><span class="w"> </span><span class="py">longitude</span><span class="p">:</span><span class="w"> </span><span class="nc">lon</span><span class="p">})</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">concentration_point</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">supplier_count</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="err">'</span><span class="py">GEOGRAPHIC_CONCENTRATION</span><span class="err">'</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">risk_type</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="step-4-real-time-tracking" class="position-relative d-flex align-items-center group">
<span>Step 4: Real-Time Tracking</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="step-4-real-time-tracking"
aria-haspopup="dialog"
aria-label="Share link: Step 4: Real-Time Tracking">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4>
<h5 id="shipment-tracking" class="position-relative d-flex align-items-center group">
<span>Shipment Tracking</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="shipment-tracking"
aria-haspopup="dialog"
aria-label="Share link: Shipment Tracking">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Model</span><span class="w"> </span><span class="py">shipments</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Shipment</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ship_1</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">order_id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ord_12345</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">status</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">in_transit</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">created</span><span class="p">:</span><span class="w"> </span><span class="nc">timestamp</span><span class="p">(),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">estimated_delivery</span><span class="p">:</span><span class="w"> </span><span class="nc">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="p">(</span><span class="py">24</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1000</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Track</span><span class="w"> </span><span class="py">shipment</span><span class="w"> </span><span class="py">location</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">ship</span><span class="p">:</span><span class="nc">Shipment</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ship_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">current_loc</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_2</span><span class="err">'</span><span class="p">})</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">ship</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">CURRENT_LOCATION</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">timestamp</span><span class="p">:</span><span class="w"> </span><span class="nc">timestamp</span><span class="p">(),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">next_hop</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">}]</span><span class="err">-></span><span class="p">(</span><span class="py">current_loc</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Query</span><span class="w"> </span><span class="py">shipment</span><span class="w"> </span><span class="py">status</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">ship</span><span class="p">:</span><span class="nc">Shipment</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ship_1</span><span class="err">'</span><span class="p">})</span><span class="err">-</span><span class="p">[:</span><span class="nc">CURRENT_LOCATION</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">loc</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">OPTIONAL</span><span class="w"> </span><span class="py">MATCH</span><span class="w"> </span><span class="py">path</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="p">(</span><span class="py">loc</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="err">*</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">destination</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">ship</span><span class="err">.</span><span class="py">status</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">loc</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">current_location</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">ship</span><span class="err">.</span><span class="py">estimated_delivery</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">length</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">remaining_hops</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h5 id="eta-calculation" class="position-relative d-flex align-items-center group">
<span>ETA Calculation</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="eta-calculation"
aria-haspopup="dialog"
aria-label="Share link: ETA Calculation">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Calculate</span><span class="w"> </span><span class="py">updated</span><span class="w"> </span><span class="py">ETA</span><span class="w"> </span><span class="py">based</span><span class="w"> </span><span class="kd">on</span><span class="w"> </span><span class="py">current</span><span class="w"> </span><span class="py">location</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">ship</span><span class="p">:</span><span class="nc">Shipment</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ship_1</span><span class="err">'</span><span class="p">})</span><span class="err">-</span><span class="p">[:</span><span class="nc">CURRENT_LOCATION</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">current</span><span class="p">:</span><span class="nc">Warehouse</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">destination</span><span class="p">:</span><span class="nc">Customer</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">cust_1</span><span class="err">'</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">path</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">shortestPath</span><span class="p">((</span><span class="py">current</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="err">*</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">destination</span><span class="p">))</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">ship</span><span class="p">,</span><span class="w"> </span><span class="py">path</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">time</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">time</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">time_hours</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">remaining_hours</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">ship</span><span class="err">.</span><span class="py">id</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">ship</span><span class="err">.</span><span class="py">estimated_delivery</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">original_eta</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="p">(</span><span class="py">remaining_hours</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1000</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">updated_eta</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(</span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="p">(</span><span class="py">remaining_hours</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1000</span><span class="p">)</span><span class="w"> </span><span class="err">-</span><span class="w"> </span><span class="py">ship</span><span class="err">.</span><span class="py">estimated_delivery</span><span class="p">)</span><span class="w"> </span><span class="err">/</span><span class="w"> </span><span class="p">(</span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1000</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">delay_hours</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="step-5-network-optimization" class="position-relative d-flex align-items-center group">
<span>Step 5: Network Optimization</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="step-5-network-optimization"
aria-haspopup="dialog"
aria-label="Share link: Step 5: Network Optimization">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4>
<h5 id="bottleneck-detection" class="position-relative d-flex align-items-center group">
<span>Bottleneck Detection</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="bottleneck-detection"
aria-haspopup="dialog"
aria-label="Share link: Bottleneck Detection">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">routes</span><span class="w"> </span><span class="py">with</span><span class="w"> </span><span class="py">highest</span><span class="w"> </span><span class="py">traffic</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">()</span><span class="err">-</span><span class="p">[</span><span class="py">route</span><span class="p">:</span><span class="nc">ROUTE</span><span class="p">]</span><span class="err">-></span><span class="p">()</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">route</span><span class="p">,</span><span class="w"> </span><span class="py">route</span><span class="err">.</span><span class="py">capacity</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">capacity</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">route</span><span class="err">.</span><span class="py">current_load</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">load</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">load</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">capacity</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">0</span><span class="mf">.8</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">startNode</span><span class="p">(</span><span class="py">route</span><span class="p">)</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">from_location</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">endNode</span><span class="p">(</span><span class="py">route</span><span class="p">)</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">to_location</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">load</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">capacity</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(</span><span class="py">load</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1</span><span class="mf">.0</span><span class="w"> </span><span class="err">/</span><span class="w"> </span><span class="py">capacity</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">utilization</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">utilization</span><span class="w"> </span><span class="py">DESC</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h5 id="betweenness-centrality-critical-nodes" class="position-relative d-flex align-items-center group">
<span>Betweenness Centrality (Critical Nodes)</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="betweenness-centrality-critical-nodes"
aria-haspopup="dialog"
aria-label="Share link: Betweenness Centrality (Critical Nodes)">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h5><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">critical</span><span class="w"> </span><span class="py">warehouses</span><span class="w"> </span><span class="py">in</span><span class="w"> </span><span class="py">network</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CALL</span><span class="w"> </span><span class="py">graph</span><span class="err">.</span><span class="py">betweennessCentrality</span><span class="p">(</span><span class="err">'</span><span class="py">SupplyChainNetwork</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">relationship_type</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ROUTE</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">normalized</span><span class="p">:</span><span class="w"> </span><span class="nc">true</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">})</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">YIELD</span><span class="w"> </span><span class="py">node</span><span class="p">,</span><span class="w"> </span><span class="py">score</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">node</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">node</span><span class="err">.</span><span class="py">name</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">warehouse</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">node</span><span class="err">.</span><span class="py">capacity</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">score</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">criticality_score</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">score</span><span class="w"> </span><span class="py">DESC</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="step-6-demand-forecasting-integration" class="position-relative d-flex align-items-center group">
<span>Step 6: Demand Forecasting Integration</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="step-6-demand-forecasting-integration"
aria-haspopup="dialog"
aria-label="Share link: Step 6: Demand Forecasting Integration">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Update</span><span class="w"> </span><span class="py">demand</span><span class="w"> </span><span class="py">based</span><span class="w"> </span><span class="kd">on</span><span class="w"> </span><span class="py">historical</span><span class="w"> </span><span class="py">patterns</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ORDERED</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">order</span><span class="p">:</span><span class="nc">Order</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">order</span><span class="err">.</span><span class="py">timestamp</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">-</span><span class="w"> </span><span class="p">(</span><span class="py">90</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">24</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1000</span><span class="p">)</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">Last</span><span class="w"> </span><span class="py">90</span><span class="w"> </span><span class="py">days</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">cust</span><span class="p">,</span><span class="w"> </span><span class="py">sum</span><span class="p">(</span><span class="py">order</span><span class="err">.</span><span class="py">quantity</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_ordered</span><span class="p">,</span><span class="w"> </span><span class="py">count</span><span class="p">(</span><span class="py">order</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">order_count</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">SET</span><span class="w"> </span><span class="py">cust</span><span class="err">.</span><span class="py">demand_weekly</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="p">(</span><span class="py">total_ordered</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1</span><span class="mf">.0</span><span class="w"> </span><span class="err">/</span><span class="w"> </span><span class="py">13</span><span class="p">)</span><span class="err">;</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">90</span><span class="w"> </span><span class="py">days</span><span class="w"> </span><span class="err">≈</span><span class="w"> </span><span class="py">13</span><span class="w"> </span><span class="py">weeks</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Adjust</span><span class="w"> </span><span class="py">inventory</span><span class="w"> </span><span class="py">based</span><span class="w"> </span><span class="kd">on</span><span class="w"> </span><span class="py">forecasted</span><span class="w"> </span><span class="py">demand</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="p">)</span><span class="err">-</span><span class="p">[</span><span class="py">stock</span><span class="p">:</span><span class="nc">STOCKS</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">prod</span><span class="p">:</span><span class="nc">Product</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">wh</span><span class="p">,</span><span class="w"> </span><span class="py">prod</span><span class="p">,</span><span class="w"> </span><span class="py">stock</span><span class="p">,</span><span class="w"> </span><span class="py">sum</span><span class="p">(</span><span class="py">cust</span><span class="err">.</span><span class="py">demand_weekly</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">forecast_demand</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">SET</span><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">reorder_point</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">forecast_demand</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">2</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">reorder_quantity</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">forecast_demand</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">4</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h3 id="advanced-patterns" class="position-relative d-flex align-items-center group">
<span>Advanced Patterns</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="advanced-patterns"
aria-haspopup="dialog"
aria-label="Share link: Advanced Patterns">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="multi-modal-transportation" class="position-relative d-flex align-items-center group">
<span>Multi-Modal Transportation</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="multi-modal-transportation"
aria-haspopup="dialog"
aria-label="Share link: Multi-Modal Transportation">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Model</span><span class="w"> </span><span class="py">different</span><span class="w"> </span><span class="py">transport</span><span class="w"> </span><span class="py">modes</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">origin</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">dest</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_3</span><span class="err">'</span><span class="p">})</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">origin</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">mode</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">truck</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">distance_km</span><span class="p">:</span><span class="w"> </span><span class="nc">500</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">time_hours</span><span class="p">:</span><span class="w"> </span><span class="nc">8</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cost_per_unit</span><span class="p">:</span><span class="w"> </span><span class="nc">1</span><span class="mf">.00</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">carbon_kg</span><span class="p">:</span><span class="w"> </span><span class="nc">50</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">}]</span><span class="err">-></span><span class="p">(</span><span class="py">dest</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">origin</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">mode</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">rail</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">distance_km</span><span class="p">:</span><span class="w"> </span><span class="nc">550</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">time_hours</span><span class="p">:</span><span class="w"> </span><span class="nc">12</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cost_per_unit</span><span class="p">:</span><span class="w"> </span><span class="nc">0</span><span class="mf">.60</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">carbon_kg</span><span class="p">:</span><span class="w"> </span><span class="nc">20</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">}]</span><span class="err">-></span><span class="p">(</span><span class="py">dest</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Optimize</span><span class="w"> </span><span class="py">for</span><span class="w"> </span><span class="py">cost</span><span class="w"> </span><span class="py">vs</span><span class="err">.</span><span class="w"> </span><span class="py">speed</span><span class="w"> </span><span class="py">vs</span><span class="err">.</span><span class="w"> </span><span class="py">sustainability</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">origin</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">dest</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_3</span><span class="err">'</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">path</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="p">(</span><span class="py">origin</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="err">*</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">dest</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">path</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">cost</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">cost</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">cost_per_unit</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_cost</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">time</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">time</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">time_hours</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_time</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">carbon</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">carbon</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">carbon_kg</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_carbon</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">mode</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">transport_modes</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">total_cost</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">total_time</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">total_carbon</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(</span><span class="py">total_cost</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">0</span><span class="mf">.4</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">total_time</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">0</span><span class="mf">.3</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">total_carbon</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">0</span><span class="mf">.3</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">sustainability_score</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">sustainability_score</span><span class="w"> </span><span class="py">ASC</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="vehicle-routing-problem-vrp" class="position-relative d-flex align-items-center group">
<span>Vehicle Routing Problem (VRP)</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="vehicle-routing-problem-vrp"
aria-haspopup="dialog"
aria-label="Share link: Vehicle Routing Problem (VRP)">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><!-- CANARY: REQ=REQ-CLIENT-PY-001; FEATURE="PythonClientConnection"; ASPECT=HelloHandshake; STATUS=IMPL; OWNER=clients; UPDATED=2025-02-14 -->
<div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"><span class="line"><span class="cl"><span class="c1"># Python client - Solve VRP with capacity constraints</span>
</span></span><span class="line"><span class="cl"><span class="kn">from</span> <span class="nn">geode_client</span> <span class="kn">import</span> <span class="n">Client</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"><span class="n">client</span> <span class="o">=</span> <span class="n">Client</span><span class="p">(</span><span class="n">host</span><span class="o">=</span><span class="s2">"geode.example.com"</span><span class="p">,</span> <span class="n">port</span><span class="o">=</span><span class="mi">3141</span><span class="p">)</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"><span class="k">async</span> <span class="k">def</span> <span class="nf">solve_vrp</span><span class="p">(</span><span class="n">conn</span><span class="p">,</span> <span class="n">warehouse_id</span><span class="p">,</span> <span class="n">customer_ids</span><span class="p">,</span> <span class="n">vehicle_capacity</span><span class="p">):</span>
</span></span><span class="line"><span class="cl"> <span class="s2">"""Solve VRP for multiple deliveries from one warehouse"""</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="c1"># Get distances between all points</span>
</span></span><span class="line"><span class="cl"> <span class="n">query</span> <span class="o">=</span> <span class="s2">"""
</span></span></span><span class="line"><span class="cl"><span class="s2"> MATCH (wh:Warehouse {id: $wh_id})
</span></span></span><span class="line"><span class="cl"><span class="s2"> UNWIND $cust_ids AS cust_id
</span></span></span><span class="line"><span class="cl"><span class="s2"> MATCH (cust:Customer {id: cust_id})
</span></span></span><span class="line"><span class="cl"><span class="s2"> MATCH path = shortestPath((wh)-[:ROUTE*]->(cust))
</span></span></span><span class="line"><span class="cl"><span class="s2"> RETURN cust_id,
</span></span></span><span class="line"><span class="cl"><span class="s2"> reduce(dist = 0, r IN relationships(path) | dist + r.distance_km) AS distance,
</span></span></span><span class="line"><span class="cl"><span class="s2"> cust.demand_weekly AS demand
</span></span></span><span class="line"><span class="cl"><span class="s2"> """</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="n">page</span><span class="p">,</span> <span class="n">_</span> <span class="o">=</span> <span class="k">await</span> <span class="n">conn</span><span class="o">.</span><span class="n">query</span><span class="p">(</span><span class="n">query</span><span class="p">,</span> <span class="p">{</span>
</span></span><span class="line"><span class="cl"> <span class="s1">'wh_id'</span><span class="p">:</span> <span class="n">warehouse_id</span><span class="p">,</span>
</span></span><span class="line"><span class="cl"> <span class="s1">'cust_ids'</span><span class="p">:</span> <span class="n">customer_ids</span>
</span></span><span class="line"><span class="cl"> <span class="p">})</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="n">distance_map</span> <span class="o">=</span> <span class="p">{</span><span class="n">row</span><span class="p">[</span><span class="s2">"cust_id"</span><span class="p">]</span><span class="o">.</span><span class="n">raw_value</span><span class="p">:</span> <span class="n">row</span><span class="p">[</span><span class="s2">"distance"</span><span class="p">]</span><span class="o">.</span><span class="n">raw_value</span> <span class="k">for</span> <span class="n">row</span> <span class="ow">in</span> <span class="n">page</span><span class="o">.</span><span class="n">rows</span><span class="p">}</span>
</span></span><span class="line"><span class="cl"> <span class="n">demand_map</span> <span class="o">=</span> <span class="p">{</span><span class="n">row</span><span class="p">[</span><span class="s2">"cust_id"</span><span class="p">]</span><span class="o">.</span><span class="n">raw_value</span><span class="p">:</span> <span class="n">row</span><span class="p">[</span><span class="s2">"demand"</span><span class="p">]</span><span class="o">.</span><span class="n">raw_value</span> <span class="k">for</span> <span class="n">row</span> <span class="ow">in</span> <span class="n">page</span><span class="o">.</span><span class="n">rows</span><span class="p">}</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="k">def</span> <span class="nf">get_distance</span><span class="p">(</span><span class="n">_from_id</span><span class="p">,</span> <span class="n">to_id</span><span class="p">):</span>
</span></span><span class="line"><span class="cl"> <span class="k">return</span> <span class="n">distance_map</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="n">to_id</span><span class="p">,</span> <span class="nb">float</span><span class="p">(</span><span class="s2">"inf"</span><span class="p">))</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="k">def</span> <span class="nf">get_demand</span><span class="p">(</span><span class="n">cust_id</span><span class="p">):</span>
</span></span><span class="line"><span class="cl"> <span class="k">return</span> <span class="n">demand_map</span><span class="o">.</span><span class="n">get</span><span class="p">(</span><span class="n">cust_id</span><span class="p">,</span> <span class="mi">0</span><span class="p">)</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="c1"># Greedy nearest neighbor with capacity constraints</span>
</span></span><span class="line"><span class="cl"> <span class="n">routes</span> <span class="o">=</span> <span class="p">[]</span>
</span></span><span class="line"><span class="cl"> <span class="n">current_route</span> <span class="o">=</span> <span class="p">[]</span>
</span></span><span class="line"><span class="cl"> <span class="n">current_capacity</span> <span class="o">=</span> <span class="mi">0</span>
</span></span><span class="line"><span class="cl"> <span class="n">unvisited</span> <span class="o">=</span> <span class="nb">set</span><span class="p">(</span><span class="n">customer_ids</span><span class="p">)</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="k">while</span> <span class="n">unvisited</span><span class="p">:</span>
</span></span><span class="line"><span class="cl"> <span class="k">if</span> <span class="ow">not</span> <span class="n">current_route</span><span class="p">:</span>
</span></span><span class="line"><span class="cl"> <span class="n">next_cust</span> <span class="o">=</span> <span class="nb">min</span><span class="p">(</span><span class="n">unvisited</span><span class="p">,</span> <span class="n">key</span><span class="o">=</span><span class="k">lambda</span> <span class="n">c</span><span class="p">:</span> <span class="n">get_distance</span><span class="p">(</span><span class="n">warehouse_id</span><span class="p">,</span> <span class="n">c</span><span class="p">))</span>
</span></span><span class="line"><span class="cl"> <span class="k">else</span><span class="p">:</span>
</span></span><span class="line"><span class="cl"> <span class="n">last_cust</span> <span class="o">=</span> <span class="n">current_route</span><span class="p">[</span><span class="o">-</span><span class="mi">1</span><span class="p">]</span>
</span></span><span class="line"><span class="cl"> <span class="n">next_cust</span> <span class="o">=</span> <span class="nb">min</span><span class="p">(</span><span class="n">unvisited</span><span class="p">,</span> <span class="n">key</span><span class="o">=</span><span class="k">lambda</span> <span class="n">c</span><span class="p">:</span> <span class="n">get_distance</span><span class="p">(</span><span class="n">last_cust</span><span class="p">,</span> <span class="n">c</span><span class="p">))</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="n">demand</span> <span class="o">=</span> <span class="n">get_demand</span><span class="p">(</span><span class="n">next_cust</span><span class="p">)</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="k">if</span> <span class="n">current_capacity</span> <span class="o">+</span> <span class="n">demand</span> <span class="o"><=</span> <span class="n">vehicle_capacity</span><span class="p">:</span>
</span></span><span class="line"><span class="cl"> <span class="n">current_route</span><span class="o">.</span><span class="n">append</span><span class="p">(</span><span class="n">next_cust</span><span class="p">)</span>
</span></span><span class="line"><span class="cl"> <span class="n">current_capacity</span> <span class="o">+=</span> <span class="n">demand</span>
</span></span><span class="line"><span class="cl"> <span class="n">unvisited</span><span class="o">.</span><span class="n">remove</span><span class="p">(</span><span class="n">next_cust</span><span class="p">)</span>
</span></span><span class="line"><span class="cl"> <span class="k">else</span><span class="p">:</span>
</span></span><span class="line"><span class="cl"> <span class="n">routes</span><span class="o">.</span><span class="n">append</span><span class="p">(</span><span class="n">current_route</span><span class="p">)</span>
</span></span><span class="line"><span class="cl"> <span class="n">current_route</span> <span class="o">=</span> <span class="p">[]</span>
</span></span><span class="line"><span class="cl"> <span class="n">current_capacity</span> <span class="o">=</span> <span class="mi">0</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="k">if</span> <span class="n">current_route</span><span class="p">:</span>
</span></span><span class="line"><span class="cl"> <span class="n">routes</span><span class="o">.</span><span class="n">append</span><span class="p">(</span><span class="n">current_route</span><span class="p">)</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="k">return</span> <span class="n">routes</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"><span class="c1"># async with client.connection() as conn:</span>
</span></span><span class="line"><span class="cl"><span class="c1"># routes = await solve_vrp(conn, "wh_1", ["c1", "c2"], 200)</span>
</span></span></code></pre></div>
<h4 id="dynamic-rerouting" class="position-relative d-flex align-items-center group">
<span>Dynamic Rerouting</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="dynamic-rerouting"
aria-haspopup="dialog"
aria-label="Share link: Dynamic Rerouting">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Handle</span><span class="w"> </span><span class="py">route</span><span class="w"> </span><span class="py">disruption</span><span class="w"> </span><span class="p">(</span><span class="py">e</span><span class="err">.</span><span class="py">g</span><span class="err">.</span><span class="p">,</span><span class="w"> </span><span class="py">road</span><span class="w"> </span><span class="py">closure</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">()</span><span class="err">-</span><span class="p">[</span><span class="py">disrupted</span><span class="p">:</span><span class="nc">ROUTE</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">route_123</span><span class="err">'</span><span class="p">}]</span><span class="err">-></span><span class="p">()</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">SET</span><span class="w"> </span><span class="py">disrupted</span><span class="err">.</span><span class="py">available</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">false</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">disrupted</span><span class="err">.</span><span class="py">reason</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="err">'</span><span class="py">road_closure</span><span class="err">'</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">disrupted</span><span class="err">.</span><span class="py">until</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="p">(</span><span class="py">48</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1000</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">alternative</span><span class="w"> </span><span class="py">routes</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">origin</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">}),</span><span class="w"> </span><span class="p">(</span><span class="py">dest</span><span class="p">:</span><span class="nc">Customer</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">cust_1</span><span class="err">'</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">path</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="p">(</span><span class="py">origin</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">ROUTE</span><span class="err">*</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">dest</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">ALL</span><span class="p">(</span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="py">WHERE</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">available</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">true</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">path</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">dist</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">dist</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">distance_km</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">distance</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">cost</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">relationships</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">cost</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">r</span><span class="err">.</span><span class="py">cost_per_unit</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">cost</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="p">[</span><span class="py">n</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">nodes</span><span class="p">(</span><span class="py">path</span><span class="p">)</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">n</span><span class="err">.</span><span class="py">name</span><span class="p">]</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">alternative_route</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">distance</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cost</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">cost</span><span class="w"> </span><span class="py">ASC</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">LIMIT</span><span class="w"> </span><span class="py">3</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h3 id="performance-optimization" class="position-relative d-flex align-items-center group">
<span>Performance Optimization</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="performance-optimization"
aria-haspopup="dialog"
aria-label="Share link: Performance Optimization">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="spatial-indexing" class="position-relative d-flex align-items-center group">
<span>Spatial Indexing</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="spatial-indexing"
aria-haspopup="dialog"
aria-label="Share link: Spatial Indexing">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Create</span><span class="w"> </span><span class="py">spatial</span><span class="w"> </span><span class="py">index</span><span class="w"> </span><span class="py">for</span><span class="w"> </span><span class="py">location</span><span class="err">-</span><span class="py">based</span><span class="w"> </span><span class="py">queries</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="py">INDEX</span><span class="w"> </span><span class="py">location_spatial_idx</span><span class="w"> </span><span class="py">ON</span><span class="w"> </span><span class="py">Warehouse</span><span class="p">(</span><span class="py">location</span><span class="p">)</span><span class="w"> </span><span class="py">USING</span><span class="w"> </span><span class="py">spatial</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="py">INDEX</span><span class="w"> </span><span class="py">customer_location_idx</span><span class="w"> </span><span class="py">ON</span><span class="w"> </span><span class="py">Customer</span><span class="p">(</span><span class="py">location</span><span class="p">)</span><span class="w"> </span><span class="py">USING</span><span class="w"> </span><span class="py">spatial</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Find</span><span class="w"> </span><span class="py">nearby</span><span class="w"> </span><span class="py">warehouses</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">point</span><span class="err">.</span><span class="py">distance</span><span class="p">(</span><span class="py">wh</span><span class="err">.</span><span class="py">location</span><span class="p">,</span><span class="w"> </span><span class="py">point</span><span class="p">({</span><span class="py">latitude</span><span class="p">:</span><span class="w"> </span><span class="nc">47</span><span class="mf">.6062</span><span class="p">,</span><span class="w"> </span><span class="py">longitude</span><span class="p">:</span><span class="w"> </span><span class="err">-</span><span class="nc">122</span><span class="mf">.3321</span><span class="p">}))</span><span class="w"> </span><span class="err"><</span><span class="w"> </span><span class="py">50000</span><span class="w"> </span><span class="err">--</span><span class="w"> </span><span class="py">50km</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">wh</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w"> </span><span class="py">wh</span><span class="err">.</span><span class="py">location</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="route-caching" class="position-relative d-flex align-items-center group">
<span>Route Caching</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="route-caching"
aria-haspopup="dialog"
aria-label="Share link: Route Caching">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-python" data-lang="python"><span class="line"><span class="cl"><span class="c1"># Cache frequently used routes</span>
</span></span><span class="line"><span class="cl"><span class="kn">from</span> <span class="nn">geode_client</span> <span class="kn">import</span> <span class="n">Client</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"><span class="n">client</span> <span class="o">=</span> <span class="n">Client</span><span class="p">(</span><span class="n">host</span><span class="o">=</span><span class="s2">"geode.example.com"</span><span class="p">,</span> <span class="n">port</span><span class="o">=</span><span class="mi">3141</span><span class="p">)</span>
</span></span><span class="line"><span class="cl"><span class="n">route_cache</span> <span class="o">=</span> <span class="p">{}</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"><span class="k">async</span> <span class="k">def</span> <span class="nf">get_shortest_path</span><span class="p">(</span><span class="n">conn</span><span class="p">,</span> <span class="n">origin_id</span><span class="p">,</span> <span class="n">dest_id</span><span class="p">):</span>
</span></span><span class="line"><span class="cl"> <span class="s2">"""Cache shortest paths between common locations"""</span>
</span></span><span class="line"><span class="cl"> <span class="n">cache_key</span> <span class="o">=</span> <span class="p">(</span><span class="n">origin_id</span><span class="p">,</span> <span class="n">dest_id</span><span class="p">)</span>
</span></span><span class="line"><span class="cl"> <span class="k">if</span> <span class="n">cache_key</span> <span class="ow">in</span> <span class="n">route_cache</span><span class="p">:</span>
</span></span><span class="line"><span class="cl"> <span class="k">return</span> <span class="n">route_cache</span><span class="p">[</span><span class="n">cache_key</span><span class="p">]</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="n">page</span><span class="p">,</span> <span class="n">_</span> <span class="o">=</span> <span class="k">await</span> <span class="n">conn</span><span class="o">.</span><span class="n">query</span><span class="p">(</span><span class="s2">"""
</span></span></span><span class="line"><span class="cl"><span class="s2"> MATCH (o {id: $origin}), (d {id: $dest}),
</span></span></span><span class="line"><span class="cl"><span class="s2"> path = shortestPath((o)-[:ROUTE*]->(d))
</span></span></span><span class="line"><span class="cl"><span class="s2"> RETURN path
</span></span></span><span class="line"><span class="cl"><span class="s2"> """</span><span class="p">,</span> <span class="p">{</span><span class="s1">'origin'</span><span class="p">:</span> <span class="n">origin_id</span><span class="p">,</span> <span class="s1">'dest'</span><span class="p">:</span> <span class="n">dest_id</span><span class="p">})</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"> <span class="n">path</span> <span class="o">=</span> <span class="n">page</span><span class="o">.</span><span class="n">rows</span><span class="p">[</span><span class="mi">0</span><span class="p">][</span><span class="s2">"path"</span><span class="p">]</span><span class="o">.</span><span class="n">raw_value</span> <span class="k">if</span> <span class="n">page</span><span class="o">.</span><span class="n">rows</span> <span class="k">else</span> <span class="kc">None</span>
</span></span><span class="line"><span class="cl"> <span class="n">route_cache</span><span class="p">[</span><span class="n">cache_key</span><span class="p">]</span> <span class="o">=</span> <span class="n">path</span>
</span></span><span class="line"><span class="cl"> <span class="k">return</span> <span class="n">path</span>
</span></span><span class="line"><span class="cl">
</span></span><span class="line"><span class="cl"><span class="c1"># async with client.connection() as conn:</span>
</span></span><span class="line"><span class="cl"><span class="c1"># path = await get_shortest_path(conn, "wh_1", "cust_42")</span>
</span></span></code></pre></div>
<h4 id="materialized-views" class="position-relative d-flex align-items-center group">
<span>Materialized Views</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="materialized-views"
aria-haspopup="dialog"
aria-label="Share link: Materialized Views">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Pre</span><span class="err">-</span><span class="py">compute</span><span class="w"> </span><span class="py">common</span><span class="w"> </span><span class="py">routes</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="p">)</span><span class="err">-</span><span class="p">[</span><span class="py">r</span><span class="p">:</span><span class="nc">ROUTE</span><span class="err">*</span><span class="py">1</span><span class="err">.</span><span class="mf">.3</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">wh</span><span class="p">,</span><span class="w"> </span><span class="py">cust</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">dist</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">rel</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">dist</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">rel</span><span class="err">.</span><span class="py">distance_km</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_distance</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">reduce</span><span class="p">(</span><span class="py">cost</span><span class="w"> </span><span class="p">=</span><span class="w"> </span><span class="py">0</span><span class="p">,</span><span class="w"> </span><span class="py">rel</span><span class="w"> </span><span class="py">IN</span><span class="w"> </span><span class="py">r</span><span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="py">cost</span><span class="w"> </span><span class="err">+</span><span class="w"> </span><span class="py">rel</span><span class="err">.</span><span class="py">cost_per_unit</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_cost</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">PRECOMPUTED_ROUTE</span><span class="w"> </span><span class="p">{</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">distance</span><span class="p">:</span><span class="w"> </span><span class="nc">total_distance</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">cost</span><span class="p">:</span><span class="w"> </span><span class="nc">total_cost</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">updated</span><span class="p">:</span><span class="w"> </span><span class="nc">timestamp</span><span class="p">()</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="p">}]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Query</span><span class="w"> </span><span class="py">precomputed</span><span class="w"> </span><span class="py">routes</span><span class="w"> </span><span class="p">(</span><span class="py">much</span><span class="w"> </span><span class="py">faster</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">wh_1</span><span class="err">'</span><span class="p">})</span><span class="err">-</span><span class="p">[</span><span class="py">route</span><span class="p">:</span><span class="nc">PRECOMPUTED_ROUTE</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">cust</span><span class="err">.</span><span class="py">name</span><span class="p">,</span><span class="w"> </span><span class="py">route</span><span class="err">.</span><span class="py">distance</span><span class="p">,</span><span class="w"> </span><span class="py">route</span><span class="err">.</span><span class="py">cost</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">route</span><span class="err">.</span><span class="py">cost</span><span class="w"> </span><span class="py">ASC</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h3 id="metrics-and-kpis" class="position-relative d-flex align-items-center group">
<span>Metrics and KPIs</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="metrics-and-kpis"
aria-haspopup="dialog"
aria-label="Share link: Metrics and KPIs">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="operational-metrics" class="position-relative d-flex align-items-center group">
<span>Operational Metrics</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="operational-metrics"
aria-haspopup="dialog"
aria-label="Share link: Operational Metrics">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Average</span><span class="w"> </span><span class="py">delivery</span><span class="w"> </span><span class="py">time</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">()</span><span class="err">-</span><span class="p">[</span><span class="py">route</span><span class="p">:</span><span class="nc">ROUTE</span><span class="p">]</span><span class="err">-></span><span class="p">()</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">avg</span><span class="p">(</span><span class="py">route</span><span class="err">.</span><span class="py">time_hours</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">avg_delivery_time</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Network</span><span class="w"> </span><span class="py">utilization</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">()</span><span class="err">-</span><span class="p">[</span><span class="py">route</span><span class="p">:</span><span class="nc">ROUTE</span><span class="p">]</span><span class="err">-></span><span class="p">()</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">route</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">CASE</span><span class="w"> </span><span class="py">WHEN</span><span class="w"> </span><span class="py">route</span><span class="err">.</span><span class="py">current_load</span><span class="w"> </span><span class="py">IS</span><span class="w"> </span><span class="py">NOT</span><span class="w"> </span><span class="py">NULL</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">THEN</span><span class="w"> </span><span class="py">route</span><span class="err">.</span><span class="py">current_load</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1</span><span class="mf">.0</span><span class="w"> </span><span class="err">/</span><span class="w"> </span><span class="py">route</span><span class="err">.</span><span class="py">capacity</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">ELSE</span><span class="w"> </span><span class="py">0</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">END</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">utilization</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">avg</span><span class="p">(</span><span class="py">utilization</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">avg_network_utilization</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">max</span><span class="p">(</span><span class="py">utilization</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">max_utilization</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">count</span><span class="p">(</span><span class="py">CASE</span><span class="w"> </span><span class="py">WHEN</span><span class="w"> </span><span class="py">utilization</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">0</span><span class="mf">.8</span><span class="w"> </span><span class="py">THEN</span><span class="w"> </span><span class="py">1</span><span class="w"> </span><span class="py">END</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">congested_routes</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Inventory</span><span class="w"> </span><span class="py">turnover</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">wh</span><span class="p">:</span><span class="nc">Warehouse</span><span class="p">)</span><span class="err">-</span><span class="p">[</span><span class="py">stock</span><span class="p">:</span><span class="nc">STOCKS</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">prod</span><span class="p">:</span><span class="nc">Product</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">prod</span><span class="p">,</span><span class="w"> </span><span class="py">sum</span><span class="p">(</span><span class="py">stock</span><span class="err">.</span><span class="py">quantity</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">total_stock</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">ord</span><span class="p">:</span><span class="nc">Order</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">CONTAINS</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">prod</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">ord</span><span class="err">.</span><span class="py">timestamp</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">-</span><span class="w"> </span><span class="p">(</span><span class="py">30</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">24</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1000</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">prod</span><span class="p">,</span><span class="w"> </span><span class="py">total_stock</span><span class="p">,</span><span class="w"> </span><span class="py">sum</span><span class="p">(</span><span class="py">ord</span><span class="err">.</span><span class="py">quantity</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">monthly_sales</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">prod</span><span class="err">.</span><span class="py">sku</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">monthly_sales</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">12</span><span class="mf">.0</span><span class="w"> </span><span class="err">/</span><span class="w"> </span><span class="py">total_stock</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">annual_turnover</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h4 id="cost-analysis" class="position-relative d-flex align-items-center group">
<span>Cost Analysis</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="cost-analysis"
aria-haspopup="dialog"
aria-label="Share link: Cost Analysis">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Total</span><span class="w"> </span><span class="py">logistics</span><span class="w"> </span><span class="py">cost</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">order</span><span class="p">:</span><span class="nc">Order</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">SHIPPED_VIA</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">route</span><span class="p">:</span><span class="nc">ROUTE</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">order</span><span class="err">.</span><span class="py">timestamp</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">-</span><span class="w"> </span><span class="p">(</span><span class="py">30</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">24</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1000</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">sum</span><span class="p">(</span><span class="py">order</span><span class="err">.</span><span class="py">quantity</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">route</span><span class="err">.</span><span class="py">cost_per_unit</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">monthly_logistics_cost</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Cost</span><span class="w"> </span><span class="py">per</span><span class="w"> </span><span class="py">delivery</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">order</span><span class="p">:</span><span class="nc">Order</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">DELIVERED_TO</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">cust</span><span class="p">:</span><span class="nc">Customer</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">order</span><span class="err">.</span><span class="py">timestamp</span><span class="w"> </span><span class="err">></span><span class="w"> </span><span class="py">timestamp</span><span class="p">()</span><span class="w"> </span><span class="err">-</span><span class="w"> </span><span class="p">(</span><span class="py">30</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">24</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">60</span><span class="w"> </span><span class="err">*</span><span class="w"> </span><span class="py">1000</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">order</span><span class="p">,</span><span class="w"> </span><span class="py">sum</span><span class="p">(</span><span class="py">order</span><span class="err">.</span><span class="py">logistics_cost</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">delivery_cost</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">avg</span><span class="p">(</span><span class="py">delivery_cost</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">avg_cost_per_delivery</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">percentile_cont</span><span class="p">(</span><span class="py">delivery_cost</span><span class="p">,</span><span class="w"> </span><span class="py">0</span><span class="mf">.5</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">median_cost</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">percentile_cont</span><span class="p">(</span><span class="py">delivery_cost</span><span class="p">,</span><span class="w"> </span><span class="py">0</span><span class="mf">.95</span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">p95_cost</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h3 id="best-practices" class="position-relative d-flex align-items-center group">
<span>Best Practices</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="best-practices"
aria-haspopup="dialog"
aria-label="Share link: Best Practices">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3>
<h4 id="1-model-granularity" class="position-relative d-flex align-items-center group">
<span>1. Model Granularity</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="1-model-granularity"
aria-haspopup="dialog"
aria-label="Share link: 1. Model Granularity">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><ul>
<li><strong>Start coarse, refine as needed</strong>: Begin with major hubs, add detail later</li>
<li><strong>Balance detail vs. performance</strong>: Too many nodes slow queries</li>
<li><strong>Use aggregation</strong>: Group small customers into zones</li>
</ul>
<h4 id="2-weight-selection" class="position-relative d-flex align-items-center group">
<span>2. Weight Selection</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="2-weight-selection"
aria-haspopup="dialog"
aria-label="Share link: 2. Weight Selection">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><ul>
<li><strong>Normalize weights</strong>: Ensure comparable scales (distance vs. cost)</li>
<li><strong>Time-varying weights</strong>: Update traffic patterns by time of day</li>
<li><strong>Multi-objective</strong>: Combine cost, time, reliability, sustainability</li>
</ul>
<h4 id="3-data-quality" class="position-relative d-flex align-items-center group">
<span>3. Data Quality</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="3-data-quality"
aria-haspopup="dialog"
aria-label="Share link: 3. Data Quality">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h4><ul>
<li><strong>Update regularly</strong>: Route conditions change (traffic, weather)</li>
<li><strong>Validate constraints</strong>: Capacity, lead times, availability</li>
<li><strong>Track exceptions</strong>: Monitor deviations from plan</li>
</ul>
<h3 id="complete-example-e-commerce-fulfillment" class="position-relative d-flex align-items-center group">
<span>Complete Example: E-Commerce Fulfillment</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="complete-example-e-commerce-fulfillment"
aria-haspopup="dialog"
aria-label="Share link: Complete Example: E-Commerce Fulfillment">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql"><span class="line"><span class="cl"><span class="err">--</span><span class="w"> </span><span class="py">Create</span><span class="w"> </span><span class="py">fulfillment</span><span class="w"> </span><span class="py">network</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">FulfillmentCenter</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">fc_1</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">East</span><span class="w"> </span><span class="py">Coast</span><span class="w"> </span><span class="py">FC</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">capacity</span><span class="p">:</span><span class="w"> </span><span class="nc">200000</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">FulfillmentCenter</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">fc_2</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">West</span><span class="w"> </span><span class="py">Coast</span><span class="w"> </span><span class="py">FC</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">capacity</span><span class="p">:</span><span class="w"> </span><span class="nc">150000</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">FulfillmentCenter</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">fc_3</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">name</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">Midwest</span><span class="w"> </span><span class="py">FC</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">capacity</span><span class="p">:</span><span class="w"> </span><span class="nc">100000</span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Customer</span><span class="w"> </span><span class="py">orders</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Order</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ord_1</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">customer_zip</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">98101</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">quantity</span><span class="p">:</span><span class="w"> </span><span class="nc">5</span><span class="p">,</span><span class="w"> </span><span class="py">priority</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">standard</span><span class="err">'</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Order</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ord_2</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">customer_zip</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">94102</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">quantity</span><span class="p">:</span><span class="w"> </span><span class="nc">10</span><span class="p">,</span><span class="w"> </span><span class="py">priority</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">express</span><span class="err">'</span><span class="p">}),</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">(:</span><span class="nc">Order</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">ord_3</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">customer_zip</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">60601</span><span class="err">'</span><span class="p">,</span><span class="w"> </span><span class="py">quantity</span><span class="p">:</span><span class="w"> </span><span class="nc">3</span><span class="p">,</span><span class="w"> </span><span class="py">priority</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">standard</span><span class="err">'</span><span class="p">})</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Route</span><span class="w"> </span><span class="py">orders</span><span class="w"> </span><span class="py">to</span><span class="w"> </span><span class="py">optimal</span><span class="w"> </span><span class="py">fulfillment</span><span class="w"> </span><span class="py">center</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">fc</span><span class="p">:</span><span class="nc">FulfillmentCenter</span><span class="p">),</span><span class="w"> </span><span class="p">(</span><span class="py">ord</span><span class="p">:</span><span class="nc">Order</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">fc</span><span class="p">)</span><span class="err">-</span><span class="p">[</span><span class="py">stock</span><span class="p">:</span><span class="nc">STOCKS</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">prod</span><span class="p">:</span><span class="nc">Product</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WHERE</span><span class="w"> </span><span class="py">stock</span><span class="err">.</span><span class="py">quantity</span><span class="w"> </span><span class="err">></span><span class="p">=</span><span class="w"> </span><span class="py">ord</span><span class="err">.</span><span class="py">quantity</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">fc</span><span class="p">,</span><span class="w"> </span><span class="py">ord</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">point</span><span class="err">.</span><span class="py">distance</span><span class="p">(</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">fc</span><span class="err">.</span><span class="py">location</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">geocode</span><span class="p">(</span><span class="py">ord</span><span class="err">.</span><span class="py">customer_zip</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="p">)</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">distance</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">ord</span><span class="err">.</span><span class="py">priority</span><span class="w"> </span><span class="py">DESC</span><span class="p">,</span><span class="w"> </span><span class="py">distance</span><span class="w"> </span><span class="py">ASC</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">WITH</span><span class="w"> </span><span class="py">ord</span><span class="p">,</span><span class="w"> </span><span class="py">head</span><span class="p">(</span><span class="py">collect</span><span class="p">(</span><span class="py">fc</span><span class="p">))</span><span class="w"> </span><span class="py">AS</span><span class="w"> </span><span class="py">optimal_fc</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">CREATE</span><span class="w"> </span><span class="p">(</span><span class="py">ord</span><span class="p">)</span><span class="err">-</span><span class="p">[:</span><span class="nc">FULFILLED_BY</span><span class="p">]</span><span class="err">-></span><span class="p">(</span><span class="py">optimal_fc</span><span class="p">)</span><span class="err">;</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="err">--</span><span class="w"> </span><span class="py">Generate</span><span class="w"> </span><span class="py">pick</span><span class="w"> </span><span class="py">lists</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">MATCH</span><span class="w"> </span><span class="p">(</span><span class="py">fc</span><span class="p">:</span><span class="nc">FulfillmentCenter</span><span class="w"> </span><span class="p">{</span><span class="py">id</span><span class="p">:</span><span class="w"> </span><span class="err">'</span><span class="nc">fc_1</span><span class="err">'</span><span class="p">})</span><span class="err"><-</span><span class="p">[:</span><span class="nc">FULFILLED_BY</span><span class="p">]</span><span class="err">-</span><span class="p">(</span><span class="py">ord</span><span class="p">:</span><span class="nc">Order</span><span class="p">)</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">RETURN</span><span class="w"> </span><span class="py">ord</span><span class="err">.</span><span class="py">id</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">ord</span><span class="err">.</span><span class="py">customer_zip</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">ord</span><span class="err">.</span><span class="py">quantity</span><span class="p">,</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"> </span><span class="py">ord</span><span class="err">.</span><span class="py">priority</span><span class="w">
</span></span></span><span class="line"><span class="cl"><span class="w"></span><span class="py">ORDER</span><span class="w"> </span><span class="py">BY</span><span class="w"> </span><span class="py">ord</span><span class="err">.</span><span class="py">priority</span><span class="w"> </span><span class="py">DESC</span><span class="p">,</span><span class="w"> </span><span class="py">ord</span><span class="err">.</span><span class="py">id</span><span class="err">;</span><span class="w">
</span></span></span></code></pre></div>
<h3 id="next-steps" class="position-relative d-flex align-items-center group">
<span>Next Steps</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="next-steps"
aria-haspopup="dialog"
aria-label="Share link: Next Steps">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><ul>
<li><a
href="/docs/analytics/graph-algorithms/"
>Graph Algorithms</a>
- Shortest path, network flow</li>
<li><a
href="/docs/performance/"
>Performance Tuning</a>
- Optimize large-scale logistics queries</li>
<li><a
href="/docs/analytics/real-time-analytics/"
>Real-Time Analytics</a>
- Live tracking and alerts</li>
<li><a
href="/docs/query/indexing-and-optimization/"
>Spatial Queries</a>
- Geographic search optimization</li>
</ul>
<h3 id="references" class="position-relative d-flex align-items-center group">
<span>References</span>
<button type="button"
class="h-share btn btn-link p-0 text-decoration-none link-secondary opacity-50 hover-opacity-100 transition-all ms-1"
data-share-target="references"
aria-haspopup="dialog"
aria-label="Share link: References">
<i class="fa-sharp-duotone fa-solid fa-share-nodes" aria-hidden="true" style="font-size: 0.8em;"></i>
<span class="visually-hidden">Share link</span>
</button>
</h3><ul>
<li><a
href="/docs/model/data-model-and-types/"
>Data Model Guide</a>
- Modeling transportation networks</li>
<li><a
href="/docs/gql/guide/"
>GQL Guide</a>
- Path queries and aggregations</li>
<li><a
href="/docs/tutorials/graph-algorithms-tutorial/"
>Dijkstra Tutorial</a>
- Weighted shortest paths</li>
</ul>
<hr>
<p><strong>License</strong>: Apache License 2.0
<strong>Copyright</strong>: 2024-2025 CodePros
<strong>Last Updated</strong>: January 2026</p>
Supply Chain Optimization
Optimize supply chain operations with Geode: route planning, inventory tracking, supplier networks, and real-time logistics analytics