Use Case Examples

Graph databases excel at modeling and querying highly connected data. Geode’s implementation of the ISO/IEC 39075:2024 GQL standard makes it straightforward to implement common graph use cases with declarative, readable queries. This guide explores practical examples demonstrating how to leverage Geode for real-world applications. <h3 id="social-network-use-cases" class="position-relative d-flex align-items-center group"> Social Network 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="social-network-use-cases" aria-haspopup="dialog" aria-label="Share link: Social Network Use Cases"> 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>Social networks are the canonical graph database application, with users, connections, content, and interactions forming natural graph structures. <h4 id="friend-network-modeling" class="position-relative d-flex align-items-center group"> Friend Network Modeling <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="friend-network-modeling" aria-haspopup="dialog" aria-label="Share link: Friend Network Modeling"> Share link </button> </h4>Model bidirectional friendships between users: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create users CREATE (:User {id: 'alice', name: 'Alice Smith', joined: date('2024-01-15')}) CREATE (:User {id: 'bob', name: 'Bob Johnson', joined: date('2024-02-20')}) CREATE (:User {id: 'carol', name: 'Carol Williams', joined: date('2024-03-10')}) -- Create friendships (bidirectional) MATCH (a:User {id: 'alice'}), (b:User {id: 'bob'}) CREATE (a)-[:FRIENDS_WITH {since: date('2024-04-01')}]->(b) CREATE (b)-[:FRIENDS_WITH {since: date('2024-04-01')}]->(a) MATCH (b:User {id: 'bob'}), (c:User {id: 'carol'}) CREATE (b)-[:FRIENDS_WITH {since: date('2024-05-15')}]->(c) CREATE (c)-[:FRIENDS_WITH {since: date('2024-05-15')}]->(b) </code></pre></div> <h4 id="friend-recommendations" class="position-relative d-flex align-items-center group"> Friend Recommendations <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="friend-recommendations" aria-haspopup="dialog" aria-label="Share link: Friend Recommendations"> Share link </button> </h4>Find friends-of-friends who aren’t already connected: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find potential friend recommendations for Alice MATCH (user:User {id: 'alice'})-[:FRIENDS_WITH]->(friend) -[:FRIENDS_WITH]->(fof:User) WHERE NOT (user)-[:FRIENDS_WITH]->(fof) AND user <> fof RETURN fof.name, count(friend) as mutual_friends ORDER BY mutual_friends DESC LIMIT 10 </code></pre></div>This query efficiently identifies second-degree connections while excluding existing friends, enabling “People You May Know” features. <h4 id="activity-feeds" class="position-relative d-flex align-items-center group"> Activity Feeds <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="activity-feeds" aria-haspopup="dialog" aria-label="Share link: Activity Feeds"> Share link </button> </h4>Generate personalized activity feeds showing friend posts: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create post activity MATCH (u:User {id: 'bob'}) CREATE (u)-[:POSTED {timestamp: current_timestamp()}]-> (:Post {id: 'post1', content: 'Great day!', likes: 0}) -- Fetch activity feed for user MATCH (user:User {id: 'alice'})-[:FRIENDS_WITH]->(friend) -[posted:POSTED]->(post:Post) RETURN friend.name, post.content, posted.timestamp, post.likes ORDER BY posted.timestamp DESC LIMIT 50 </code></pre></div> <h4 id="mutual-connections" class="position-relative d-flex align-items-center group"> Mutual Connections <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="mutual-connections" aria-haspopup="dialog" aria-label="Share link: Mutual Connections"> Share link </button> </h4>Display mutual friends between two users: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (user1:User {id: 'alice'})-[:FRIENDS_WITH]->(mutual:User) <-[:FRIENDS_WITH]-(user2:User {id: 'carol'}) RETURN mutual.name, mutual.id ORDER BY mutual.name </code></pre></div> <h3 id="recommendation-engine-use-cases" class="position-relative d-flex align-items-center group"> Recommendation Engine 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="recommendation-engine-use-cases" aria-haspopup="dialog" aria-label="Share link: Recommendation Engine Use Cases"> Share link </button> </h3>Graph databases excel at collaborative filtering and recommendation algorithms. <h4 id="product-recommendations" class="position-relative d-flex align-items-center group"> Product Recommendations <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="product-recommendations" aria-haspopup="dialog" aria-label="Share link: Product Recommendations"> Share link </button> </h4>Recommend products based on what similar users purchased: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Model user purchases MATCH (u:User {id: 'alice'}) CREATE (u)-[:PURCHASED {date: date('2024-06-01'), price: 29.99}]-> (:Product {id: 'prod1', name: 'Wireless Mouse', category: 'Electronics'}) -- Find recommendations MATCH (user:User {id: 'alice'})-[:PURCHASED]->(product:Product) <-[:PURCHASED]-(similar:User) -[:PURCHASED]->(recommendation:Product) WHERE NOT (user)-[:PURCHASED]->(recommendation) RETURN recommendation.name, recommendation.category, count(DISTINCT similar) as similar_users, avg(recommendation.rating) as avg_rating ORDER BY similar_users DESC, avg_rating DESC LIMIT 10 </code></pre></div>This collaborative filtering approach identifies products purchased by users with similar purchase history. <h4 id="content-based-filtering" class="position-relative d-flex align-items-center group"> Content-Based Filtering <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="content-based-filtering" aria-haspopup="dialog" aria-label="Share link: Content-Based Filtering"> Share link </button> </h4>Recommend products similar to previously purchased items: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find products in same category MATCH (user:User {id: 'alice'})-[:PURCHASED]->(purchased:Product) MATCH (similar:Product) WHERE similar.category = purchased.category AND NOT (user)-[:PURCHASED]->(similar) AND similar <> purchased RETURN similar.name, similar.category, count(DISTINCT purchased) as category_matches ORDER BY category_matches DESC LIMIT 10 </code></pre></div> <h4 id="trending-products" class="position-relative d-flex align-items-center group"> Trending Products <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="trending-products" aria-haspopup="dialog" aria-label="Share link: Trending Products"> Share link </button> </h4>Identify trending products based on recent purchase velocity: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (u:User)-[p:PURCHASED]->(product:Product) WHERE p.date > date(current_date()) - duration('P7D') RETURN product.name, count(DISTINCT u) as purchasers, sum(p.price) as revenue ORDER BY purchasers DESC LIMIT 20 </code></pre></div> <h3 id="access-control-and-permissions" class="position-relative d-flex align-items-center group"> Access Control and Permissions <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="access-control-and-permissions" aria-haspopup="dialog" aria-label="Share link: Access Control and Permissions"> Share link </button> </h3>Model complex hierarchical and graph-based access control systems. <h4 id="role-based-access-control-rbac" class="position-relative d-flex align-items-center group"> Role-Based Access Control (RBAC) <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="role-based-access-control-rbac" aria-haspopup="dialog" aria-label="Share link: Role-Based Access Control (RBAC)"> Share link </button> </h4>Implement role hierarchy with permission inheritance: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create roles and permissions CREATE (:Role {id: 'admin', name: 'Administrator'}) CREATE (:Role {id: 'editor', name: 'Editor'}) CREATE (:Role {id: 'viewer', name: 'Viewer'}) CREATE (:Permission {id: 'read', name: 'Read Access'}) CREATE (:Permission {id: 'write', name: 'Write Access'}) CREATE (:Permission {id: 'delete', name: 'Delete Access'}) -- Assign permissions to roles MATCH (admin:Role {id: 'admin'}), (read:Permission {id: 'read'}), (write:Permission {id: 'write'}), (del:Permission {id: 'delete'}) CREATE (admin)-[:HAS_PERMISSION]->(read) CREATE (admin)-[:HAS_PERMISSION]->(write) CREATE (admin)-[:HAS_PERMISSION]->(del) MATCH (editor:Role {id: 'editor'}), (read:Permission {id: 'read'}), (write:Permission {id: 'write'}) CREATE (editor)-[:HAS_PERMISSION]->(read) CREATE (editor)-[:HAS_PERMISSION]->(write) MATCH (viewer:Role {id: 'viewer'}), (read:Permission {id: 'read'}) CREATE (viewer)-[:HAS_PERMISSION]->(read) -- Assign user to role MATCH (user:User {id: 'alice'}), (role:Role {id: 'editor'}) CREATE (user)-[:HAS_ROLE]->(role) -- Check user permissions MATCH (user:User {id: 'alice'})-[:HAS_ROLE]->(role:Role) -[:HAS_PERMISSION]->(permission:Permission) RETURN DISTINCT permission.name </code></pre></div> <h4 id="organizational-hierarchy" class="position-relative d-flex align-items-center group"> Organizational Hierarchy <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="organizational-hierarchy" aria-haspopup="dialog" aria-label="Share link: Organizational Hierarchy"> Share link </button> </h4>Model reporting structures and delegated access: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create organizational structure CREATE (:Employee {id: 'ceo', name: 'CEO', level: 1}) CREATE (:Employee {id: 'vp_eng', name: 'VP Engineering', level: 2}) CREATE (:Employee {id: 'eng_mgr', name: 'Engineering Manager', level: 3}) CREATE (:Employee {id: 'dev1', name: 'Developer 1', level: 4}) MATCH (ceo:Employee {id: 'ceo'}), (vp:Employee {id: 'vp_eng'}) CREATE (vp)-[:REPORTS_TO]->(ceo) MATCH (vp:Employee {id: 'vp_eng'}), (mgr:Employee {id: 'eng_mgr'}) CREATE (mgr)-[:REPORTS_TO]->(vp) MATCH (mgr:Employee {id: 'eng_mgr'}), (dev:Employee {id: 'dev1'}) CREATE (dev)-[:REPORTS_TO]->(mgr) -- Find all reports (direct and indirect) MATCH (manager:Employee {id: 'vp_eng'})<-[:REPORTS_TO*1..5]-(report:Employee) RETURN report.name, report.level ORDER BY report.level </code></pre></div> <h4 id="resource-access-control" class="position-relative d-flex align-items-center group"> Resource Access Control <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="resource-access-control" aria-haspopup="dialog" aria-label="Share link: Resource Access Control"> Share link </button> </h4>Implement fine-grained resource permissions: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create resources CREATE (:Document {id: 'doc1', title: 'Q4 Strategy', classification: 'confidential'}) CREATE (:Document {id: 'doc2', title: 'Team Notes', classification: 'internal'}) -- Grant access MATCH (user:User {id: 'alice'}), (doc:Document {id: 'doc1'}) CREATE (user)-[:CAN_READ {granted: current_timestamp()}]->(doc) MATCH (user:User {id: 'alice'}), (doc:Document {id: 'doc1'}) CREATE (user)-[:CAN_EDIT {granted: current_timestamp()}]->(doc) -- Check user access to resource MATCH (user:User {id: 'alice'})-[access]->(doc:Document {id: 'doc1'}) RETURN type(access) as permission, access.granted </code></pre></div> <h3 id="fraud-detection-use-cases" class="position-relative d-flex align-items-center group"> Fraud Detection 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="fraud-detection-use-cases" aria-haspopup="dialog" aria-label="Share link: Fraud Detection Use Cases"> Share link </button> </h3>Graph patterns excel at detecting fraudulent behavior through relationship analysis. <h4 id="account-network-analysis" class="position-relative d-flex align-items-center group"> Account Network Analysis <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="account-network-analysis" aria-haspopup="dialog" aria-label="Share link: Account Network Analysis"> Share link </button> </h4>Detect suspicious account clusters sharing identifying information: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create accounts with shared attributes CREATE (:Account {id: 'acct1', email: 'user1@example.com', ip: '192.168.1.1'}) CREATE (:Account {id: 'acct2', email: 'user2@example.com', ip: '192.168.1.1'}) CREATE (:Account {id: 'acct3', email: 'user3@example.com', ip: '192.168.1.1'}) -- Find accounts sharing IP addresses MATCH (a1:Account)-[:USED_IP]->(ip:IPAddress)<-[:USED_IP]-(a2:Account) WHERE a1 <> a2 RETURN ip.address, count(DISTINCT a1) + count(DISTINCT a2) as account_count, collect(DISTINCT a1.email) + collect(DISTINCT a2.email) as emails HAVING account_count > 5 ORDER BY account_count DESC </code></pre></div> <h4 id="transaction-pattern-detection" class="position-relative d-flex align-items-center group"> Transaction Pattern 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="transaction-pattern-detection" aria-haspopup="dialog" aria-label="Share link: Transaction Pattern Detection"> Share link </button> </h4>Identify circular transaction patterns indicating money laundering: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find circular money flows MATCH path = (a:Account)-[:TRANSFERRED*3..5]->(a) WHERE ALL(rel IN relationships(path) WHERE rel.amount > 1000) RETURN nodes(path) as accounts, [rel IN relationships(path) | rel.amount] as amounts, reduce(total = 0, rel IN relationships(path) | total + rel.amount) as total </code></pre></div> <h4 id="velocity-checks" class="position-relative d-flex align-items-center group"> Velocity Checks <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="velocity-checks" aria-haspopup="dialog" aria-label="Share link: Velocity Checks"> Share link </button> </h4>Detect abnormal transaction velocity: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">MATCH (account:Account {id: 'acct1'})-[tx:TRANSFERRED]->(target:Account) WHERE tx.timestamp > current_timestamp() - duration('PT1H') RETURN account.id, count(tx) as transaction_count, sum(tx.amount) as total_amount, avg(tx.amount) as avg_amount HAVING transaction_count > 20 OR total_amount > 50000 </code></pre></div> <h3 id="knowledge-graph-use-cases" class="position-relative d-flex align-items-center group"> Knowledge Graph 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="knowledge-graph-use-cases" aria-haspopup="dialog" aria-label="Share link: Knowledge Graph Use Cases"> Share link </button> </h3>Organize and query complex interconnected knowledge domains. <h4 id="wikipedia-style-knowledge-base" class="position-relative d-flex align-items-center group"> Wikipedia-Style Knowledge Base <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="wikipedia-style-knowledge-base" aria-haspopup="dialog" aria-label="Share link: Wikipedia-Style Knowledge Base"> Share link </button> </h4>Model entities and their relationships: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create entities CREATE (:Person {id: 'einstein', name: 'Albert Einstein', born: 1879, died: 1955}) CREATE (:Concept {id: 'relativity', name: 'Theory of Relativity'}) CREATE (:Institution {id: 'princeton', name: 'Princeton University'}) -- Create relationships MATCH (person:Person {id: 'einstein'}), (concept:Concept {id: 'relativity'}) CREATE (person)-[:DEVELOPED {year: 1915}]->(concept) MATCH (person:Person {id: 'einstein'}), (inst:Institution {id: 'princeton'}) CREATE (person)-[:WORKED_AT {from: 1933, to: 1955}]->(inst) -- Query related concepts MATCH (start:Person {name: 'Albert Einstein'})-[rel*1..3]-(related) RETURN related, type(rel) as relationship </code></pre></div> <h4 id="citation-networks" class="position-relative d-flex align-items-center group"> Citation Networks <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="citation-networks" aria-haspopup="dialog" aria-label="Share link: Citation Networks"> Share link </button> </h4>Model academic papers and citations: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create papers CREATE (:Paper { id: 'paper1', title: 'Graph Databases: State of the Art', year: 2023, citations: 0 }) -- Create citations MATCH (citing:Paper {id: 'paper2'}), (cited:Paper {id: 'paper1'}) CREATE (citing)-[:CITES {context: 'methodology'}]->(cited) -- Find highly cited papers MATCH (paper:Paper)<-[:CITES]-(citing:Paper) RETURN paper.title, paper.year, count(citing) as citation_count ORDER BY citation_count DESC LIMIT 10 -- Find citation chains MATCH path = (start:Paper {id: 'paper1'})<-[:CITES*1..3]-(citing:Paper) RETURN citing.title, length(path) as degrees_of_separation </code></pre></div> <h4 id="taxonomy-and-classification" class="position-relative d-flex align-items-center group"> Taxonomy and Classification <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="taxonomy-and-classification" aria-haspopup="dialog" aria-label="Share link: Taxonomy and Classification"> Share link </button> </h4>Build hierarchical classification systems: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create taxonomy CREATE (:Category {id: 'electronics', name: 'Electronics'}) CREATE (:Category {id: 'computers', name: 'Computers'}) CREATE (:Category {id: 'laptops', name: 'Laptops'}) MATCH (child:Category {id: 'laptops'}), (parent:Category {id: 'computers'}) CREATE (child)-[:SUBCATEGORY_OF]->(parent) MATCH (child:Category {id: 'computers'}), (parent:Category {id: 'electronics'}) CREATE (child)-[:SUBCATEGORY_OF]->(parent) -- Find all ancestor categories MATCH (item:Category {id: 'laptops'})-[:SUBCATEGORY_OF*]->(ancestor:Category) RETURN ancestor.name ORDER BY length(path) ASC </code></pre></div> <h3 id="supply-chain-and-logistics" class="position-relative d-flex align-items-center group"> Supply Chain and Logistics <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-and-logistics" aria-haspopup="dialog" aria-label="Share link: Supply Chain and Logistics"> Share link </button> </h3>Track complex supply chain relationships and dependencies. <h4 id="product-assembly-tracking" class="position-relative d-flex align-items-center group"> Product Assembly 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="product-assembly-tracking" aria-haspopup="dialog" aria-label="Share link: Product Assembly Tracking"> Share link </button> </h4>Model bill of materials (BOM): <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create components CREATE (:Component {id: 'laptop', name: 'Gaming Laptop', type: 'finished_good'}) CREATE (:Component {id: 'motherboard', name: 'Motherboard', type: 'subassembly'}) CREATE (:Component {id: 'cpu', name: 'CPU', type: 'part'}) CREATE (:Component {id: 'ram', name: 'RAM Module', type: 'part'}) -- Create assembly relationships MATCH (laptop:Component {id: 'laptop'}), (mb:Component {id: 'motherboard'}) CREATE (laptop)-[:CONTAINS {quantity: 1}]->(mb) MATCH (mb:Component {id: 'motherboard'}), (cpu:Component {id: 'cpu'}) CREATE (mb)-[:CONTAINS {quantity: 1}]->(cpu) MATCH (mb:Component {id: 'motherboard'}), (ram:Component {id: 'ram'}) CREATE (mb)-[:CONTAINS {quantity: 2}]->(ram) -- Find all components required for product MATCH (product:Component {id: 'laptop'})-[:CONTAINS*]->(component:Component) RETURN component.name, component.type </code></pre></div> <h4 id="shipment-tracking" class="position-relative d-flex align-items-center group"> Shipment 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="shipment-tracking" aria-haspopup="dialog" aria-label="Share link: Shipment Tracking"> Share link </button> </h4>Track packages through distribution network: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE (:Location {id: 'warehouse', name: 'Main Warehouse', type: 'warehouse'}) CREATE (:Location {id: 'hub1', name: 'Distribution Hub', type: 'hub'}) CREATE (:Location {id: 'customer', name: 'Customer Address', type: 'destination'}) MATCH (shipment:Shipment {id: 'ship123'}), (loc:Location {id: 'warehouse'}) CREATE (shipment)-[:AT_LOCATION {timestamp: current_timestamp(), status: 'picked'}]->(loc) -- Track shipment route MATCH path = (shipment:Shipment {id: 'ship123'}) -[:AT_LOCATION*]->(destination:Location {type: 'destination'}) RETURN [loc IN nodes(path) | loc.name] as route, [rel IN relationships(path) | rel.timestamp] as timestamps </code></pre></div> <h3 id="network-infrastructure" class="position-relative d-flex align-items-center group"> Network Infrastructure <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-infrastructure" aria-haspopup="dialog" aria-label="Share link: Network Infrastructure"> Share link </button> </h3>Model network topology and dependencies. <h4 id="service-dependency-mapping" class="position-relative d-flex align-items-center group"> Service Dependency Mapping <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="service-dependency-mapping" aria-haspopup="dialog" aria-label="Share link: Service Dependency Mapping"> Share link </button> </h4>Map microservice dependencies: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create services CREATE (:Service {id: 'api', name: 'API Gateway', version: '2.1.0'}) CREATE (:Service {id: 'auth', name: 'Auth Service', version: '1.5.0'}) CREATE (:Service {id: 'db', name: 'Database', version: '13.2'}) -- Create dependencies MATCH (api:Service {id: 'api'}), (auth:Service {id: 'auth'}) CREATE (api)-[:DEPENDS_ON {critical: true}]->(auth) MATCH (api:Service {id: 'api'}), (db:Service {id: 'db'}) CREATE (api)-[:DEPENDS_ON {critical: true}]->(db) -- Find all transitive dependencies MATCH (service:Service {id: 'api'})-[:DEPENDS_ON*]->(dependency:Service) RETURN dependency.name, dependency.version -- Impact analysis: what depends on this service? MATCH (dependent:Service)-[:DEPENDS_ON*]->(service:Service {id: 'auth'}) RETURN dependent.name </code></pre></div> <h4 id="network-topology" class="position-relative d-flex align-items-center group"> Network Topology <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-topology" aria-haspopup="dialog" aria-label="Share link: Network Topology"> Share link </button> </h4>Model physical network infrastructure: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE (:Device {id: 'router1', type: 'router', ip: '10.0.0.1'}) CREATE (:Device {id: 'switch1', type: 'switch', ip: '10.0.1.1'}) CREATE (:Device {id: 'server1', type: 'server', ip: '10.0.1.10'}) MATCH (router:Device {id: 'router1'}), (switch:Device {id: 'switch1'}) CREATE (router)-[:CONNECTED_TO {bandwidth: '10Gbps', port: 'eth0'}]->(switch) -- Find path between devices MATCH path = shortestPath( (source:Device {id: 'server1'})-[:CONNECTED_TO*]-(dest:Device {id: 'router1'}) ) RETURN [device IN nodes(path) | device.id] as path, length(path) as hops </code></pre></div> <h3 id="best-practices-for-use-case-implementation" class="position-relative d-flex align-items-center group"> Best Practices for Use Case Implementation <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-for-use-case-implementation" aria-haspopup="dialog" aria-label="Share link: Best Practices for Use Case Implementation"> Share link </button> </h3> <h4 id="start-simple" class="position-relative d-flex align-items-center group"> Start Simple <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="start-simple" aria-haspopup="dialog" aria-label="Share link: Start Simple"> Share link </button> </h4>Begin with core entities and relationships, then add complexity: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Start: basic user-product relationship MATCH (u:User)-[:PURCHASED]->(p:Product) -- Evolve: add temporal and rating dimensions MATCH (u:User)-[purchase:PURCHASED]->(p:Product) WHERE purchase.date > date('2024-01-01') AND purchase.rating >= 4 </code></pre></div> <h4 id="use-appropriate-indexing" class="position-relative d-flex align-items-center group"> Use Appropriate Indexing <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-appropriate-indexing" aria-haspopup="dialog" aria-label="Share link: Use Appropriate Indexing"> Share link </button> </h4>Create indexes on frequently queried properties: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">CREATE INDEX user_email ON User(email) CREATE INDEX product_category ON Product(category) CREATE INDEX transaction_date ON TRANSFERRED(date) </code></pre></div> <h4 id="leverage-parameterized-queries" class="position-relative d-flex align-items-center group"> Leverage Parameterized Queries <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="leverage-parameterized-queries" aria-haspopup="dialog" aria-label="Share link: Leverage Parameterized Queries"> Share link </button> </h4>Use parameters for reusable, secure queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Parameterized recommendation query MATCH (user:User {id: $user_id})-[:PURCHASED]->(p:Product) <-[:PURCHASED]-(similar:User)-[:PURCHASED]->(rec:Product) WHERE NOT (user)-[:PURCHASED]->(rec) RETURN rec LIMIT $limit </code></pre></div> <h4 id="monitor-query-performance" class="position-relative d-flex align-items-center group"> Monitor Query Performance <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="monitor-query-performance" aria-haspopup="dialog" aria-label="Share link: Monitor Query Performance"> Share link </button> </h4>Use PROFILE to optimize complex queries: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">PROFILE MATCH (u:User)-[:FRIENDS_WITH*2..3]->(friend) WHERE u.id = $user_id RETURN friend </code></pre></div>These use case examples demonstrate Geode’s versatility across diverse application domains. The declarative nature of GQL combined with Geode’s performance enables developers to model and query complex connected data efficiently.

Popular

Related Articles

Fraud and Anomaly Detection

Recommendation Systems