Materialized Views System | Geode Database

<h3 id="overview" class="position-relative d-flex align-items-center group"> Overview <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"> Share link </button> </h3><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"> </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"> </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"> Twitter </a> <a id="share-linkedin" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> LinkedIn </a> <a id="share-facebook" class="btn btn-outline-secondary w-100" target="_blank" rel="noopener noreferrer"> 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>The Geode Materialized Views System provides comprehensive view management with intelligent refresh strategies, dependency tracking, and query optimization. This system improves query performance for complex analytical queries by pre-computing and storing query results with enterprise-grade reliability. <h4 id="what-are-materialized-views" class="position-relative d-flex align-items-center group"> What are Materialized Views? <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="what-are-materialized-views" aria-haspopup="dialog" aria-label="Share link: What are Materialized Views?"> Share link </button> </h4>Materialized Views are pre-computed query results stored as physical data structures that can be queried like regular tables. Unlike regular views (which re-execute the query each time), materialized views cache results for instant access. Key Benefits: <ul> <li>Query Acceleration: Faster access to pre-computed results</li> <li>Resource Efficiency: Compute once, query many times</li> <li>Automatic Refresh: Keep data current with configurable strategies</li> <li>Dependency Tracking: Automatic updates when source data changes</li> <li>Query Rewriting: Optimizer automatically uses views when beneficial</li> </ul> <h3 id="architecture" class="position-relative d-flex align-items-center group"> Architecture <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="architecture" aria-haspopup="dialog" aria-label="Share link: Architecture"> Share link </button> </h3> <h4 id="system-components" class="position-relative d-flex align-items-center group"> System Components <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="system-components" aria-haspopup="dialog" aria-label="Share link: System Components"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-fallback" data-lang="fallback">MaterializedViewManager ├── ViewCatalog - Metadata and storage management ├── DependencyTracker - Table-view dependency detection ├── RefreshScheduler - Priority-based refresh scheduling ├── QueryRewriter - Automatic query optimization using views └── ViewMetrics - Performance monitoring and statistics </code></pre></div> <h4 id="data-flow" class="position-relative d-flex align-items-center group"> Data Flow <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-flow" aria-haspopup="dialog" aria-label="Share link: Data Flow"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-plaintext" data-lang="plaintext">1. CREATE MATERIALIZED VIEW → Parse query, extract dependencies 2. ViewCatalog → Store metadata (source query, refresh strategy) 3. Initial Refresh → Execute source query, store results 4. DependencyTracker → Monitor source table changes 5. RefreshScheduler → Trigger refresh based on strategy 6. QueryRewriter → Match incoming queries to compatible views 7. Result → Return cached data (faster than re-computing) </code></pre></div> <h3 id="refresh-strategies" class="position-relative d-flex align-items-center group"> Refresh Strategies <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="refresh-strategies" aria-haspopup="dialog" aria-label="Share link: Refresh Strategies"> Share link </button> </h3> <h4 id="manual-refresh" class="position-relative d-flex align-items-center group"> Manual Refresh <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="manual-refresh" aria-haspopup="dialog" aria-label="Share link: Manual Refresh"> Share link </button> </h4>Use Case: Full control over refresh timing, analytical reports <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create view with manual refresh CREATE MATERIALIZED VIEW quarterly_analytics AS MATCH (s:Sale)-[:CONTAINS]->(p:Product) WHERE s.quarter = 'Q4-2025' RETURN p.category, sum(s.amount) AS total_sales, count(s) AS sale_count WITH REFRESH STRATEGY manual </code></pre></div>Characteristics: <ul> <li>Refresh only on explicit command</li> <li>Lowest resource overhead</li> <li>Best for infrequently changing data</li> <li>Suitable for monthly/quarterly reports</li> </ul> Refresh Command: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Manually refresh view REFRESH MATERIALIZED VIEW quarterly_analytics </code></pre></div> <h4 id="auto-immediate-refresh" class="position-relative d-flex align-items-center group"> Auto-Immediate Refresh <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="auto-immediate-refresh" aria-haspopup="dialog" aria-label="Share link: Auto-Immediate Refresh"> Share link </button> </h4>Use Case: Real-time dashboards, critical metrics <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create view with immediate refresh CREATE MATERIALIZED VIEW real_time_metrics AS MATCH (o:Order) WHERE o.created_date > datetime().subtract(PT1H) RETURN o.status, count(o) AS order_count, sum(o.total) AS revenue WITH REFRESH STRATEGY auto_immediate </code></pre></div>Characteristics: <ul> <li>Refreshes immediately when source data changes</li> <li>Always returns current data</li> <li>Higher resource usage</li> <li>Best for mission-critical dashboards</li> </ul> Behavior: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-plaintext" data-lang="plaintext">1. Transaction commits to Order table 2. DependencyTracker detects change 3. RefreshScheduler queues immediate refresh 4. View refreshes within seconds 5. Next query sees updated data </code></pre></div> <h4 id="auto-scheduled-refresh" class="position-relative d-flex align-items-center group"> Auto-Scheduled Refresh <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="auto-scheduled-refresh" aria-haspopup="dialog" aria-label="Share link: Auto-Scheduled Refresh"> Share link </button> </h4>Use Case: Regular reports, hourly/daily aggregations <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create view with hourly refresh CREATE MATERIALIZED VIEW user_activity_summary AS MATCH (u:User)-[a:ACTION]->(t:Target) WHERE a.timestamp > datetime().subtract(P30D) RETURN u.department, t.type, count(a) AS action_count, avg(a.duration) AS avg_duration WITH REFRESH STRATEGY auto_scheduled INTERVAL 3600 -- Every hour </code></pre></div>Characteristics: <ul> <li>Predictable refresh schedule</li> <li>Balanced resource usage</li> <li>Data freshness within refresh interval</li> <li>Best for periodic analytics</li> </ul> Configuration: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># Default intervals default_refresh_intervals: high_priority: 900 # 15 minutes normal: 3600 # 1 hour low_priority: 86400 # 24 hours </code></pre></div> <h4 id="incremental-refresh" class="position-relative d-flex align-items-center group"> Incremental Refresh <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="incremental-refresh" aria-haspopup="dialog" aria-label="Share link: Incremental Refresh"> Share link </button> </h4>Use Case: Large views with small updates <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create view with incremental refresh CREATE MATERIALIZED VIEW order_summary AS MATCH (o:Order) RETURN o.date, o.region, count(o) AS order_count, sum(o.amount) AS revenue WITH REFRESH STRATEGY incremental </code></pre></div>Characteristics: <ul> <li>Only processes changed rows</li> <li>Dramatically faster for large datasets</li> <li>Requires change tracking</li> <li>Best for append-only or small update patterns</li> </ul> Behavior: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-plaintext" data-lang="plaintext">Initial Refresh: Process all 1M rows → 60 seconds Incremental Refresh: Process 1K changed rows → 0.5 seconds (120x faster) </code></pre></div> <h4 id="streaming-refresh" class="position-relative d-flex align-items-center group"> Streaming Refresh <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="streaming-refresh" aria-haspopup="dialog" aria-label="Share link: Streaming Refresh"> Share link </button> </h4>Use Case: Continuous data feeds, real-time analytics <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create streaming view CREATE MATERIALIZED VIEW live_sensor_data AS MATCH (s:Sensor)-[:REPORTS]->(m:Measurement) WHERE m.timestamp > datetime().subtract(PT5M) RETURN s.id, avg(m.value) AS avg_value, max(m.value) AS max_value WITH REFRESH STRATEGY streaming </code></pre></div>Characteristics: <ul> <li>Continuous incremental updates</li> <li>Sub-second data freshness</li> <li>Integrates with event streams</li> <li>Best for IoT, monitoring, real-time dashboards</li> </ul> <h3 id="creating-materialized-views" class="position-relative d-flex align-items-center group"> Creating Materialized Views <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="creating-materialized-views" aria-haspopup="dialog" aria-label="Share link: Creating Materialized Views"> Share link </button> </h3> <h4 id="basic-syntax" class="position-relative d-flex align-items-center group"> Basic Syntax <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="basic-syntax" aria-haspopup="dialog" aria-label="Share link: Basic Syntax"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE MATERIALIZED VIEW view_name AS <GQL query> [WITH REFRESH STRATEGY <strategy> [INTERVAL <seconds>]] </code></pre></div> <h4 id="simple-aggregation" class="position-relative d-flex align-items-center group"> Simple Aggregation <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="simple-aggregation" aria-haspopup="dialog" aria-label="Share link: Simple Aggregation"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Product sales summary CREATE MATERIALIZED VIEW product_sales AS MATCH (p:Product)<-[:CONTAINS]-(s:Sale) RETURN p.category, count(s) AS sale_count, sum(s.amount) AS total_revenue, avg(s.amount) AS avg_sale WITH REFRESH STRATEGY auto_scheduled INTERVAL 3600 </code></pre></div>Benefit: Returns pre-computed results instead of scanning source data. <h4 id="complex-join" class="position-relative d-flex align-items-center group"> Complex Join <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="complex-join" aria-haspopup="dialog" aria-label="Share link: Complex Join"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Customer behavior analysis CREATE MATERIALIZED VIEW customer_insights AS MATCH (c:Customer)-[:PLACED]->(o:Order)-[:CONTAINS]->(p:Product) WHERE o.created_date > datetime().subtract(P90D) RETURN c.segment, c.region, count(DISTINCT o) AS order_count, count(DISTINCT p) AS unique_products, sum(o.total) AS lifetime_value, avg(o.total) AS avg_order_value WITH REFRESH STRATEGY auto_scheduled INTERVAL 7200 </code></pre></div>Benefits: <ul> <li>Pre-computed joins eliminate join cost</li> <li>Aggregations computed once</li> <li>Perfect for dashboard queries</li> </ul> <h4 id="time-series-data" class="position-relative d-flex align-items-center group"> Time-Series Data <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="time-series-data" aria-haspopup="dialog" aria-label="Share link: Time-Series Data"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Daily metrics rollup CREATE MATERIALIZED VIEW daily_metrics AS MATCH (m:Metric) WHERE m.timestamp > datetime().subtract(P365D) RETURN date(m.timestamp) AS metric_date, m.type, count(m) AS count, avg(m.value) AS avg_value, percentile(m.value, 0.95) AS p95_value, percentile(m.value, 0.99) AS p99_value WITH REFRESH STRATEGY auto_scheduled INTERVAL 86400 -- Daily </code></pre></div>Use Case: Historical trend analysis, SLA reporting <h3 id="querying-materialized-views" class="position-relative d-flex align-items-center group"> Querying Materialized Views <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="querying-materialized-views" aria-haspopup="dialog" aria-label="Share link: Querying Materialized Views"> Share link </button> </h3> <h4 id="direct-query" class="position-relative d-flex align-items-center group"> Direct Query <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="direct-query" aria-haspopup="dialog" aria-label="Share link: Direct Query"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Query the materialized view directly MATCH (v:product_sales) WHERE v.category = 'Electronics' RETURN v.category, v.total_revenue ORDER BY v.total_revenue DESC </code></pre></div>Characteristics: <ul> <li>Instant results from cached data</li> <li>No re-computation</li> <li>Limited to pre-computed columns</li> </ul> <h4 id="automatic-query-rewriting" class="position-relative d-flex align-items-center group"> Automatic Query Rewriting <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="automatic-query-rewriting" aria-haspopup="dialog" aria-label="Share link: Automatic Query Rewriting"> Share link </button> </h4>Geode’s optimizer automatically rewrites queries to use compatible materialized views: Original Query: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (p:Product)<-[:CONTAINS]-(s:Sale) WHERE p.category = 'Electronics' RETURN p.category, sum(s.amount) AS revenue </code></pre></div>Optimizer Rewrite: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Automatically uses product_sales view MATCH (v:product_sales) WHERE v.category = 'Electronics' RETURN v.category, v.total_revenue AS revenue </code></pre></div>Performance Impact: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-plaintext" data-lang="plaintext">Original: 1.8 seconds Rewritten: 0.015 seconds (120x speedup) </code></pre></div> <h4 id="view-compatibility" class="position-relative d-flex align-items-center group"> View Compatibility <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="view-compatibility" aria-haspopup="dialog" aria-label="Share link: View Compatibility"> Share link </button> </h4>Compatible Query (uses view): <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Matches view structure MATCH (p:Product)<-[:CONTAINS]-(s:Sale) RETURN p.category, count(s) -- ✅ Uses product_sales view </code></pre></div>Incompatible Query (doesn’t use view): <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Different aggregation MATCH (p:Product)<-[:CONTAINS]-(s:Sale) RETURN p.brand, count(s) -- Grouped by brand, not category -- ❌ Cannot use product_sales view </code></pre></div> <h3 id="dependency-tracking" class="position-relative d-flex align-items-center group"> Dependency Tracking <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="dependency-tracking" aria-haspopup="dialog" aria-label="Share link: Dependency Tracking"> Share link </button> </h3> <h4 id="automatic-dependency-detection" class="position-relative d-flex align-items-center group"> Automatic Dependency Detection <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="automatic-dependency-detection" aria-haspopup="dialog" aria-label="Share link: Automatic Dependency Detection"> Share link </button> </h4>Geode automatically extracts table and relationship dependencies: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE MATERIALIZED VIEW user_summary AS MATCH (u:User)-[:POSTED]->(p:Post)-[:HAS_TAG]->(t:Tag) RETURN u.name, count(p) AS post_count, collect(DISTINCT t.name) AS tags </code></pre></div>Detected Dependencies: <ul> <li>Tables: User, Post, Tag</li> <li>Relationships: POSTED, HAS_TAG</li> <li>Change to any triggers refresh consideration</li> </ul> <h4 id="cascading-refreshes" class="position-relative d-flex align-items-center group"> Cascading Refreshes <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="cascading-refreshes" aria-haspopup="dialog" aria-label="Share link: Cascading Refreshes"> Share link </button> </h4>Dependency Chain: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Base view CREATE MATERIALIZED VIEW daily_sales AS MATCH (s:Sale) RETURN date(s.created_date) AS sale_date, sum(s.amount) AS revenue -- Dependent view CREATE MATERIALIZED VIEW monthly_sales AS MATCH (d:daily_sales) RETURN year_month(d.sale_date) AS month, sum(d.revenue) AS monthly_revenue </code></pre></div>Refresh Behavior: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-plaintext" data-lang="plaintext">1. Sale table updated 2. daily_sales refresh triggered 3. DependencyTracker detects monthly_sales depends on daily_sales 4. monthly_sales refresh queued after daily_sales completes 5. Cascade preserves consistency </code></pre></div> <h4 id="change-detection" class="position-relative d-flex align-items-center group"> Change Detection <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="change-detection" aria-haspopup="dialog" aria-label="Share link: Change Detection"> Share link </button> </h4>Change Log: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-zig" data-lang="zig">pub const ChangeLogEntry = struct { table_name: []const u8, change_type: ChangeType, // INSERT, UPDATE, DELETE timestamp: i64, row_count: u32, processed: bool, }; </code></pre></div>Incremental Refresh Logic: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-plaintext" data-lang="plaintext">1. Track changes since last refresh 2. Apply only delta changes to view 3. Update view statistics 4. Mark changes as processed </code></pre></div> <h3 id="performance-monitoring" class="position-relative d-flex align-items-center group"> Performance Monitoring <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-monitoring" aria-haspopup="dialog" aria-label="Share link: Performance Monitoring"> Share link </button> </h3> <h4 id="view-statistics" class="position-relative d-flex align-items-center group"> View Statistics <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="view-statistics" aria-haspopup="dialog" aria-label="Share link: View Statistics"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Get view performance metrics CALL db.view.stats('product_sales') </code></pre></div>Output: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "total_refreshes": 240, "successful_refreshes": 238, "failed_refreshes": 2, "average_refresh_time_ms": 1250, "total_query_hits": 15420, "cache_hit_ratio": 0.98, "last_refresh": "2026-01-24T10:30:00Z", "next_refresh": "2026-01-24T11:30:00Z", "storage_mb": 45.2 } </code></pre></div> <h4 id="system-statistics" class="position-relative d-flex align-items-center group"> System Statistics <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="system-statistics" aria-haspopup="dialog" aria-label="Share link: System Statistics"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Get all views overview CALL db.view.list() </code></pre></div>Output: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-json" data-lang="json">{ "total_views": 12, "active_refreshes": 2, "total_storage_gb": 2.4, "average_cache_hit_ratio": 0.95, "refresh_success_rate": 0.992 } </code></pre></div> <h4 id="performance-metrics" class="position-relative d-flex align-items-center group"> Performance Metrics <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-metrics" aria-haspopup="dialog" aria-label="Share link: Performance Metrics"> Share link </button> </h4>Collected Metrics: <ul> <li>total_refreshes: Lifetime refresh count</li> <li>successful_refreshes: Successful refresh operations</li> <li>failed_refreshes: Failed refresh attempts</li> <li>average_refresh_time_ms: Mean refresh duration</li> <li>total_query_hits: View usage count</li> <li>last_query_hit_timestamp: Most recent query</li> <li>cache_hit_ratio: Queries served from view vs re-executed</li> <li>storage_efficiency: Compression ratio vs raw data</li> </ul> <h3 id="configuration" class="position-relative d-flex align-items-center group"> Configuration <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="configuration" aria-haspopup="dialog" aria-label="Share link: Configuration"> Share link </button> </h3> <h4 id="view-manager-settings" class="position-relative d-flex align-items-center group"> View Manager Settings <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="view-manager-settings" aria-haspopup="dialog" aria-label="Share link: View Manager Settings"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># config/views.yaml materialized_views: max_views: 1000 max_view_size_mb: 1024 default_refresh_interval_seconds: 3600 enable_auto_refresh: true enable_incremental_refresh: true max_concurrent_refreshes: 4 refresh_timeout_seconds: 1800 </code></pre></div>Options Explained: <ul> <li>max_views: Maximum concurrent materialized views</li> <li>max_view_size_mb: Per-view storage limit</li> <li>default_refresh_interval_seconds: Default auto-scheduled interval</li> <li>enable_auto_refresh: Global auto-refresh toggle</li> <li>enable_incremental_refresh: Enable incremental refresh capability</li> <li>max_concurrent_refreshes: Parallel refresh limit</li> <li>refresh_timeout_seconds: Refresh operation timeout</li> </ul> <h4 id="refresh-priority" class="position-relative d-flex align-items-center group"> Refresh Priority <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="refresh-priority" aria-haspopup="dialog" aria-label="Share link: Refresh Priority"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-zig" data-lang="zig">pub const RefreshPriority = enum { immediate, // <1 minute high, // <15 minutes normal, // <1 hour low, // <24 hours background, // Best effort }; </code></pre></div>Priority Queue: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-plaintext" data-lang="plaintext">Immediate → High → Normal → Low → Background Scheduling: - Immediate: Pre-empts normal operations - High: Priority over normal queries - Normal: Standard priority - Low: Off-peak hours preferred - Background: Idle time only </code></pre></div> <h3 id="advanced-features" class="position-relative d-flex align-items-center group"> Advanced Features <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-features" aria-haspopup="dialog" aria-label="Share link: Advanced Features"> Share link </button> </h3> <h4 id="partitioned-views" class="position-relative d-flex align-items-center group"> Partitioned Views <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="partitioned-views" aria-haspopup="dialog" aria-label="Share link: Partitioned Views"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create partitioned view by date CREATE MATERIALIZED VIEW sales_by_date PARTITION BY date AS MATCH (s:Sale) RETURN date(s.created_date) AS sale_date, s.region, sum(s.amount) AS revenue WITH REFRESH STRATEGY incremental </code></pre></div>Benefits: <ul> <li>Refresh only affected partitions</li> <li>Parallel partition processing</li> <li>Efficient data pruning</li> <li>Better compression</li> </ul> <h4 id="view-chaining" class="position-relative d-flex align-items-center group"> View Chaining <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="view-chaining" aria-haspopup="dialog" aria-label="Share link: View Chaining"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Base view CREATE MATERIALIZED VIEW hourly_metrics AS ... -- Derived view (uses base view) CREATE MATERIALIZED VIEW daily_summary AS MATCH (h:hourly_metrics) RETURN date(h.timestamp) AS metric_date, avg(h.value) AS avg_daily_value WITH REFRESH STRATEGY auto_scheduled INTERVAL 86400 </code></pre></div>Benefits: <ul> <li>Compose complex analytics pipelines</li> <li>Reuse intermediate results</li> <li>Optimize storage (base view can be pruned)</li> </ul> <h4 id="custom-refresh-logic" class="position-relative d-flex align-items-center group"> Custom Refresh Logic <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="custom-refresh-logic" aria-haspopup="dialog" aria-label="Share link: Custom Refresh Logic"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-zig" data-lang="zig">// Custom refresh trigger pub fn refreshOnThreshold( view_name: []const u8, threshold_rows: u32, ) !void { const change_count = try getChangeCount(view_name); if (change_count >= threshold_rows) { try refreshView(view_name); } } </code></pre></div> <h3 id="use-cases" class="position-relative d-flex align-items-center group"> Use Cases <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-cases" aria-haspopup="dialog" aria-label="Share link: Use Cases"> Share link </button> </h3> <h4 id="real-time-dashboards" class="position-relative d-flex align-items-center group"> Real-Time Dashboards <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="real-time-dashboards" aria-haspopup="dialog" aria-label="Share link: Real-Time Dashboards"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Active users dashboard CREATE MATERIALIZED VIEW active_users_now AS MATCH (u:User)-[:SESSION]->(s:Session) WHERE s.last_seen > datetime().subtract(PT15M) RETURN count(DISTINCT u) AS active_users, count(s) AS total_sessions, avg(s.duration_seconds) AS avg_session_duration WITH REFRESH STRATEGY auto_immediate </code></pre></div>Dashboard Integration: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-javascript" data-lang="javascript">// Frontend refreshes every 30 seconds setInterval(async () => { const metrics = await query('MATCH (v:active_users_now) RETURN v'); updateDashboard(metrics); }, 30000); </code></pre></div> <h4 id="analytical-reporting" class="position-relative d-flex align-items-center group"> Analytical Reporting <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="analytical-reporting" aria-haspopup="dialog" aria-label="Share link: Analytical Reporting"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Monthly sales report CREATE MATERIALIZED VIEW monthly_sales_report AS MATCH (s:Sale)-[:SOLD_BY]->(rep:SalesRep) WHERE s.created_date >= startOfMonth() RETURN rep.name, rep.region, count(s) AS deals_closed, sum(s.amount) AS total_revenue, avg(s.amount) AS avg_deal_size, percentile(s.amount, 0.5) AS median_deal WITH REFRESH STRATEGY auto_scheduled INTERVAL 3600 </code></pre></div> <h4 id="customer-segmentation" class="position-relative d-flex align-items-center group"> Customer Segmentation <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="customer-segmentation" aria-haspopup="dialog" aria-label="Share link: Customer Segmentation"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Customer lifetime value segments CREATE MATERIALIZED VIEW customer_segments AS MATCH (c:Customer)-[:PLACED]->(o:Order) WITH c, sum(o.total) AS ltv, count(o) AS order_count RETURN CASE WHEN ltv > 10000 THEN 'VIP' WHEN ltv > 5000 THEN 'High Value' WHEN ltv > 1000 THEN 'Medium Value' ELSE 'New Customer' END AS segment, count(c) AS customer_count, avg(ltv) AS avg_ltv, avg(order_count) AS avg_orders WITH REFRESH STRATEGY auto_scheduled INTERVAL 86400 </code></pre></div> <h3 id="troubleshooting" class="position-relative d-flex align-items-center group"> Troubleshooting <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="troubleshooting" aria-haspopup="dialog" aria-label="Share link: Troubleshooting"> Share link </button> </h3> <h4 id="refresh-failures" class="position-relative d-flex align-items-center group"> Refresh Failures <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="refresh-failures" aria-haspopup="dialog" aria-label="Share link: Refresh Failures"> Share link </button> </h4>Issue: View refresh fails with timeout Diagnosis: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Check view status CALL db.view.status('slow_view') </code></pre></div>Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-yaml" data-lang="yaml"># Increase refresh timeout materialized_views: refresh_timeout_seconds: 3600 # 1 hour # Or optimize source query # Add indexes on frequently joined columns # Reduce aggregation complexity # Consider partitioning </code></pre></div><hr> Issue: Incremental refresh not working Diagnosis: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Verify change tracking CALL db.view.changes('view_name') </code></pre></div>Solution: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Rebuild view with change tracking DROP MATERIALIZED VIEW old_view CREATE MATERIALIZED VIEW new_view AS ... WITH REFRESH STRATEGY incremental ENABLE_CHANGE_TRACKING true </code></pre></div> <h4 id="performance-issues" class="position-relative d-flex align-items-center group"> Performance Issues <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-issues" aria-haspopup="dialog" aria-label="Share link: Performance Issues"> Share link </button> </h4>Issue: View queries slower than expected Analysis: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">PROFILE MATCH (v:product_sales) WHERE v.category = 'Electronics' RETURN v </code></pre></div>Solutions: <ol> <li> Add indexes on view columns: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE INDEX view_category_idx ON product_sales (category) </code></pre></div></li> <li> Partition large views: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE MATERIALIZED VIEW partitioned_sales PARTITION BY region AS ... </code></pre></div></li> <li> Prune old data: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">ALTER MATERIALIZED VIEW sales_view SET RETENTION P90D </code></pre></div></li> </ol> <h3 id="best-practices" class="position-relative d-flex align-items-center group"> Best Practices <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"> Share link </button> </h3> <h4 id="view-design" class="position-relative d-flex align-items-center group"> View Design <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="view-design" aria-haspopup="dialog" aria-label="Share link: View Design"> Share link </button> </h4><ol> <li> Appropriate Granularity: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- ✅ Good: Aggregate to useful level CREATE MATERIALIZED VIEW daily_sales AS ... -- Daily granularity -- ❌ Bad: Too granular CREATE MATERIALIZED VIEW second_by_second AS ... -- Too detailed </code></pre></div></li> <li> Include Filtering Columns: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- ✅ Good: Include common filter columns RETURN sale_date, region, category, revenue -- ❌ Bad: Missing important dimensions RETURN revenue -- Can't filter by date/region </code></pre></div></li> <li> Balance Freshness vs Cost: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Dashboard: Immediate refresh WITH REFRESH STRATEGY auto_immediate -- Reports: Scheduled refresh WITH REFRESH STRATEGY auto_scheduled INTERVAL 3600 -- Archives: Manual refresh WITH REFRESH STRATEGY manual </code></pre></div></li> </ol> <h4 id="refresh-strategy-selection" class="position-relative d-flex align-items-center group"> Refresh Strategy Selection <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="refresh-strategy-selection" aria-haspopup="dialog" aria-label="Share link: Refresh Strategy Selection"> Share link </button> </h4><table> <thead> <tr> <th>Use Case</th> <th>Strategy</th> <th>Interval</th> <th>Notes</th> </tr> </thead> <tbody> <tr> <td>Live dashboards</td> <td>auto_immediate</td> <td>N/A</td> <td>Always current</td> </tr> <tr> <td>Hourly reports</td> <td>auto_scheduled</td> <td>3600</td> <td>Predictable</td> </tr> <tr> <td>Daily analytics</td> <td>auto_scheduled</td> <td>86400</td> <td>Overnight refresh</td> </tr> <tr> <td>Large aggregations</td> <td>incremental</td> <td>3600</td> <td>Process deltas only</td> </tr> <tr> <td>Archive reports</td> <td>manual</td> <td>N/A</td> <td>On-demand</td> </tr> <tr> <td>Real-time feeds</td> <td>streaming</td> <td>N/A</td> <td>Continuous updates</td> </tr> </tbody> </table> <h4 id="monitoring" class="position-relative d-flex align-items-center group"> Monitoring <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="monitoring" aria-haspopup="dialog" aria-label="Share link: Monitoring"> Share link </button> </h4>Automated Checks: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Cron job: Check view health */15 * * * * geode query "CALL db.view.health_check()" | mail -s "View Status" [email protected] # Alert on refresh failures geode query "CALL db.view.failed_refreshes()" | \ jq 'select(.failed_count > 0)' | \ mail -s "ALERT: View refresh failures" [email protected] </code></pre></div> <h3 id="references" class="position-relative d-flex align-items-center group"> References <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"> Share link </button> </h3> <h4 id="documentation" class="position-relative d-flex align-items-center group"> Documentation <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="documentation" aria-haspopup="dialog" aria-label="Share link: Documentation"> Share link </button> </h4><ul> <li>Implementation: <code>src/query/enhanced_materialized_views.zig</code></li> <li>Tests: <code>tests/test_materialized_views_enhanced.zig</code></li> <li>Integration: <code>tests/test_materialized_views_enhanced_integration.zig</code></li> <li>Source Docs: <code>docs/MATERIALIZED_VIEWS.md</code></li> </ul> <h4 id="related-topics" class="position-relative d-flex align-items-center group"> Related Topics <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="related-topics" aria-haspopup="dialog" aria-label="Share link: Related Topics"> Share link </button> </h4><ul> <li><a href="/docs/query/performance-tuning/" >Query Optimization</a> - EXPLAIN and PROFILE</li> <li><a href="/docs/query/indexing-and-optimization/" >Indexing Guide</a> - Index strategies</li> <li><a href="/docs/analytics/real-time-analytics/" >Real-Time Analytics</a> - Streaming integration</li> <li><a href="/docs/architecture/distributed-architecture/" >Distributed Architecture</a> - Federated views</li> </ul> <h3 id="next-steps" class="position-relative d-flex align-items-center group"> Next Steps <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"> Share link </button> </h3>For New Users: <ul> <li><a href="/docs/query/indexing-and-optimization/" >Indexing Guide</a> - Foundation for view optimization</li> <li><a href="/docs/query/performance-tuning/" >Query Performance</a> - Query optimization basics</li> <li><a href="/docs/gql/guide/" >GQL Guide</a> - Query language fundamentals</li> </ul> For Advanced Users: <ul> <li><a href="/docs/analytics/real-time-analytics/" >Real-Time Analytics</a> - Streaming view integration</li> <li><a href="/docs/architecture/distributed-architecture/" >Distributed Coordination</a> - Cross-shard views</li> <li><a href="/docs/guides/performance-benchmarking/" >Performance Benchmarking</a> - View performance testing</li> </ul> For Administrators: <ul> <li><a href="/docs/ops/observability/" >Monitoring</a> - View health monitoring</li> <li><a href="/docs/configuration/server-configuration/" >Performance Tuning</a> - System optimization</li> <li><a href="/docs/guides/backup-automation/" >Backup & Recovery</a> - View backup strategies</li> </ul> <hr> Document Version: 1.0 Last Updated: January 24, 2026 Status: Production Ready Test Coverage: 23 tests (15 unit + 8 integration) Concurrency: Tested with 50+ concurrent views