Data Governance

Data governance in Geode provides comprehensive capabilities for managing data quality, tracking lineage, enforcing policies, and maintaining compliance across your graph database. This guide covers the tools and practices for implementing effective data governance in enterprise environments. <h3 id="data-governance-overview" class="position-relative d-flex align-items-center group"> Data Governance 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="data-governance-overview" aria-haspopup="dialog" aria-label="Share link: Data Governance 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>Data governance ensures that data is: <ul> <li>Accurate: Data quality meets business requirements</li> <li>Secure: Access is controlled and audited</li> <li>Compliant: Regulatory requirements are met</li> <li>Discoverable: Users can find and understand data</li> <li>Traceable: Data lineage is documented</li> <li>Consistent: Standards are enforced across the organization</li> </ul> Geode provides built-in features to support all aspects of data governance. <h3 id="data-quality-management" class="position-relative d-flex align-items-center group"> Data Quality Management <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-quality-management" aria-haspopup="dialog" aria-label="Share link: Data Quality Management"> Share link </button> </h3> <h4 id="schema-constraints" class="position-relative d-flex align-items-center group"> Schema Constraints <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="schema-constraints" aria-haspopup="dialog" aria-label="Share link: Schema Constraints"> Share link </button> </h4>Define data quality rules using schema constraints: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Ensure email addresses are valid CREATE CONSTRAINT valid_email ON (u:User) ASSERT u.email MATCHES '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$'; -- Ensure phone numbers follow E.164 format CREATE CONSTRAINT valid_phone ON (c:Contact) ASSERT c.phone MATCHES '^\+[1-9]\d{1,14}$'; -- Ensure dates are in the future for events CREATE CONSTRAINT future_event ON (e:Event) ASSERT e.event_date > current_date(); -- Ensure numeric ranges CREATE CONSTRAINT valid_age ON (p:Person) ASSERT p.age >= 0 AND p.age <= 150; -- Ensure required fields are present CREATE CONSTRAINT required_fields ON (p:Product) ASSERT p.name IS NOT NULL AND p.sku IS NOT NULL AND p.price IS NOT NULL; </code></pre></div> <h4 id="data-quality-checks" class="position-relative d-flex align-items-center group"> Data Quality 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="data-quality-checks" aria-haspopup="dialog" aria-label="Share link: Data Quality Checks"> Share link </button> </h4>Implement automated data quality checks: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find records with missing required data MATCH (p:Person) WHERE p.email IS NULL OR p.name IS NULL OR p.created_at IS NULL RETURN count(p) AS incomplete_records; -- Find duplicate records MATCH (p1:Person), (p2:Person) WHERE p1.email = p2.email AND id(p1) < id(p2) RETURN p1.email, count(*) AS duplicates; -- Find orphaned relationships MATCH ()-[r:BELONGS_TO]->() WHERE NOT EXISTS { MATCH (n)-[r]->(m) WHERE n:Entity AND m:Group } RETURN count(r) AS orphaned_relationships; -- Validate referential integrity MATCH (o:Order)-[:ORDERED_BY]->(c:Customer) WHERE NOT EXISTS { MATCH (c) WHERE c:Customer } RETURN count(o) AS orders_without_customers; </code></pre></div> <h4 id="data-quality-metrics" class="position-relative d-flex align-items-center group"> Data Quality 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="data-quality-metrics" aria-haspopup="dialog" aria-label="Share link: Data Quality Metrics"> Share link </button> </h4>Track data quality over time: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create data quality metrics CREATE (:DataQualityMetric { name: 'email_completeness', timestamp: current_timestamp(), total_records: count {MATCH (p:Person) RETURN p}, complete_records: count {MATCH (p:Person) WHERE p.email IS NOT NULL RETURN p}, completeness_pct: 100.0 * count {MATCH (p:Person) WHERE p.email IS NOT NULL RETURN p} / count {MATCH (p:Person) RETURN p} }); -- Query quality trends MATCH (m:DataQualityMetric) WHERE m.name = 'email_completeness' AND m.timestamp > current_timestamp() - duration('P30D') RETURN m.timestamp, m.completeness_pct ORDER BY m.timestamp; </code></pre></div> <h3 id="data-lineage-tracking" class="position-relative d-flex align-items-center group"> Data Lineage 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="data-lineage-tracking" aria-haspopup="dialog" aria-label="Share link: Data Lineage Tracking"> Share link </button> </h3>Track how data flows through your systems and transformations: <h4 id="lineage-model" class="position-relative d-flex align-items-center group"> Lineage Model <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="lineage-model" aria-haspopup="dialog" aria-label="Share link: Lineage Model"> Share link </button> </h4>Model data lineage in the graph: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Source systems CREATE (:DataSource { id: 'crm_system', name: 'Customer CRM', type: 'database', connection: 'postgresql://crm.example.com' }); -- Data transformations CREATE (:DataTransformation { id: 'etl_customer_enrichment', name: 'Customer Data Enrichment', type: 'ETL', script: 'customer_enrichment.py', version: '2.1.0', last_run: current_timestamp() }); -- Data assets CREATE (:DataAsset { id: 'customer_360', name: 'Customer 360 View', type: 'graph', schema: 'Person, Company, Product' }); -- Create lineage relationships MATCH (source:DataSource {id: 'crm_system'}) MATCH (transform:DataTransformation {id: 'etl_customer_enrichment'}) MATCH (asset:DataAsset {id: 'customer_360'}) CREATE (source)-[:FEEDS]->(transform) CREATE (transform)-[:PRODUCES]->(asset); </code></pre></div> <h4 id="automatic-lineage-tracking" class="position-relative d-flex align-items-center group"> Automatic Lineage 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="automatic-lineage-tracking" aria-haspopup="dialog" aria-label="Share link: Automatic Lineage Tracking"> Share link </button> </h4>Enable automatic lineage tracking: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Enable lineage tracking for all queries geode serve --lineage-tracking=enabled \ --lineage-detail=full \ --lineage-storage=graph </code></pre></div>Query lineage information: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find all data sources for a specific asset MATCH (source:DataSource)-[:FEEDS*]->(asset:DataAsset {id: 'customer_360'}) RETURN source.name, source.type; -- Trace downstream impact of a data source MATCH (source:DataSource {id: 'crm_system'})-[:FEEDS*]->(downstream) RETURN downstream.name, labels(downstream); -- Find all transformations applied to data MATCH path = (source)-[:FEEDS*]->(asset:DataAsset {id: 'customer_360'}) WHERE 'DataTransformation' IN labels(nodes(path)) RETURN [n IN nodes(path) WHERE 'DataTransformation' IN labels(n) | n.name] AS transformations; </code></pre></div> <h4 id="impact-analysis" class="position-relative d-flex align-items-center group"> Impact 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="impact-analysis" aria-haspopup="dialog" aria-label="Share link: Impact Analysis"> Share link </button> </h4>Analyze the impact of changes: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Find all assets affected by changing a source MATCH (source:DataSource {id: 'crm_system'})-[:FEEDS*]->(affected) RETURN DISTINCT labels(affected), affected.name ORDER BY labels(affected); -- Find all users affected by data source change MATCH (source:DataSource {id: 'crm_system'})-[:FEEDS*]->(asset:DataAsset) MATCH (user:User)-[:USES]->(asset) RETURN DISTINCT user.name, user.email; </code></pre></div> <h3 id="metadata-management" class="position-relative d-flex align-items-center group"> Metadata Management <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="metadata-management" aria-haspopup="dialog" aria-label="Share link: Metadata Management"> Share link </button> </h3> <h4 id="data-catalog" class="position-relative d-flex align-items-center group"> Data Catalog <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-catalog" aria-haspopup="dialog" aria-label="Share link: Data Catalog"> Share link </button> </h4>Build a searchable data catalog: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create catalog entries CREATE (:CatalogEntry { id: 'customers_table', name: 'Customer Data', type: 'dataset', description: 'Primary customer information including contact details and preferences', owner: 'data-team@example.com', created_at: current_timestamp(), updated_at: current_timestamp(), tags: ['pii', 'customer', 'core'], classification: 'confidential', retention_period: duration('P7Y') }); -- Add schema information CREATE (:SchemaField { name: 'email', type: 'string', description: 'Customer email address', required: true, pii: true, example: 'customer@example.com' }); -- Link catalog entries to schema MATCH (catalog:CatalogEntry {id: 'customers_table'}) MATCH (field:SchemaField {name: 'email'}) CREATE (catalog)-[:HAS_FIELD]->(field); </code></pre></div> <h4 id="searchable-metadata" class="position-relative d-flex align-items-center group"> Searchable Metadata <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="searchable-metadata" aria-haspopup="dialog" aria-label="Share link: Searchable Metadata"> Share link </button> </h4>Search the data catalog: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Search by tag MATCH (entry:CatalogEntry) WHERE 'pii' IN entry.tags RETURN entry.name, entry.description; -- Search by classification MATCH (entry:CatalogEntry) WHERE entry.classification = 'confidential' RETURN entry.name, entry.owner; -- Full-text search MATCH (entry:CatalogEntry) WHERE entry.name CONTAINS 'customer' OR entry.description CONTAINS 'customer' RETURN entry.name, entry.description; </code></pre></div> <h4 id="business-glossary" class="position-relative d-flex align-items-center group"> Business Glossary <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="business-glossary" aria-haspopup="dialog" aria-label="Share link: Business Glossary"> Share link </button> </h4>Define business terms and link to technical assets: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create business terms CREATE (:BusinessTerm { id: 'customer_lifetime_value', name: 'Customer Lifetime Value', abbreviation: 'CLV', definition: 'Predicted net profit attributed to the entire future relationship with a customer', owner: 'finance-team@example.com', approved_by: 'CFO', approved_at: current_timestamp() }); -- Link terms to data assets MATCH (term:BusinessTerm {id: 'customer_lifetime_value'}) MATCH (field:SchemaField {name: 'lifetime_value'}) CREATE (term)-[:DEFINED_BY]->(field); </code></pre></div> <h3 id="access-policies" class="position-relative d-flex align-items-center group"> Access Policies <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-policies" aria-haspopup="dialog" aria-label="Share link: Access Policies"> Share link </button> </h3> <h4 id="policy-based-access-control" class="position-relative d-flex align-items-center group"> Policy-Based 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="policy-based-access-control" aria-haspopup="dialog" aria-label="Share link: Policy-Based Access Control"> Share link </button> </h4>Define and enforce access policies: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create data access policy CREATE (:DataAccessPolicy { id: 'pii_access_policy', name: 'PII Access Control', description: 'Restrict access to personally identifiable information', effective_date: current_timestamp(), created_by: 'security-team@example.com' }); -- Define policy rules CREATE (:PolicyRule { policy_id: 'pii_access_policy', rule_type: 'row_level_security', condition: 'user.has_role("pii_viewer") OR data.owner = current_user()', action: 'allow' }); -- Apply policies to data MATCH (policy:DataAccessPolicy {id: 'pii_access_policy'}) MATCH (entry:CatalogEntry) WHERE 'pii' IN entry.tags CREATE (entry)-[:GOVERNED_BY]->(policy); </code></pre></div> <h4 id="data-classification" class="position-relative d-flex align-items-center group"> Data 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="data-classification" aria-haspopup="dialog" aria-label="Share link: Data Classification"> Share link </button> </h4>Classify data by sensitivity: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Define classification levels CREATE (:ClassificationLevel {name: 'public', level: 1}); CREATE (:ClassificationLevel {name: 'internal', level: 2}); CREATE (:ClassificationLevel {name: 'confidential', level: 3}); CREATE (:ClassificationLevel {name: 'restricted', level: 4}); -- Classify data assets MATCH (entry:CatalogEntry {id: 'customers_table'}) MATCH (level:ClassificationLevel {name: 'confidential'}) CREATE (entry)-[:CLASSIFIED_AS]->(level); -- Enforce classification-based access CREATE POLICY classification_access ON CatalogEntry FOR SELECT USING { MATCH (entry)-[:CLASSIFIED_AS]->(level:ClassificationLevel) MATCH (user:User {id: current_user()}) WHERE user.clearance_level >= level.level RETURN true }; </code></pre></div> <h3 id="data-retention-and-lifecycle" class="position-relative d-flex align-items-center group"> Data Retention and Lifecycle <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-retention-and-lifecycle" aria-haspopup="dialog" aria-label="Share link: Data Retention and Lifecycle"> Share link </button> </h3> <h4 id="retention-policies" class="position-relative d-flex align-items-center group"> Retention Policies <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="retention-policies" aria-haspopup="dialog" aria-label="Share link: Retention Policies"> Share link </button> </h4>Define and enforce data retention: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create retention policy CREATE (:RetentionPolicy { id: 'gdpr_customer_retention', name: 'GDPR Customer Data Retention', retention_period: duration('P7Y'), deletion_method: 'secure_delete', legal_basis: 'GDPR Article 5(1)(e)', approved_by: 'legal-team@example.com' }); -- Apply to data MATCH (policy:RetentionPolicy {id: 'gdpr_customer_retention'}) MATCH (entry:CatalogEntry) WHERE 'customer' IN entry.tags CREATE (entry)-[:GOVERNED_BY]->(policy); -- Find data eligible for deletion MATCH (data)-[:GOVERNED_BY]->(policy:RetentionPolicy) WHERE data.created_at + policy.retention_period < current_timestamp() RETURN data.id, data.name, data.created_at; </code></pre></div> <h4 id="automated-lifecycle-management" class="position-relative d-flex align-items-center group"> Automated Lifecycle Management <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="automated-lifecycle-management" aria-haspopup="dialog" aria-label="Share link: Automated Lifecycle Management"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Enable automated data lifecycle management geode serve --lifecycle-management=enabled \ --lifecycle-check-interval=daily \ --lifecycle-enforcement=true # Run manual lifecycle check geode lifecycle-check --policy=gdpr_customer_retention \ --dry-run=true \ --output=lifecycle-report.json </code></pre></div> <h3 id="data-stewardship" class="position-relative d-flex align-items-center group"> Data Stewardship <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-stewardship" aria-haspopup="dialog" aria-label="Share link: Data Stewardship"> Share link </button> </h3> <h4 id="assign-data-stewards" class="position-relative d-flex align-items-center group"> Assign Data Stewards <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="assign-data-stewards" aria-haspopup="dialog" aria-label="Share link: Assign Data Stewards"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Create stewardship assignments CREATE (:DataSteward { id: 'alice@example.com', name: 'Alice Johnson', title: 'Senior Data Steward', department: 'Data Governance', responsibilities: ['Customer Data', 'Product Data'] }); -- Assign stewards to data MATCH (steward:DataSteward {id: 'alice@example.com'}) MATCH (entry:CatalogEntry) WHERE 'customer' IN entry.tags CREATE (steward)-[:RESPONSIBLE_FOR]->(entry); -- Find steward for specific data MATCH (steward:DataSteward)-[:RESPONSIBLE_FOR]->(entry:CatalogEntry {id: 'customers_table'}) RETURN steward.name, steward.id; </code></pre></div> <h3 id="compliance-reporting" class="position-relative d-flex align-items-center group"> Compliance 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="compliance-reporting" aria-haspopup="dialog" aria-label="Share link: Compliance Reporting"> Share link </button> </h3> <h4 id="generate-compliance-reports" class="position-relative d-flex align-items-center group"> Generate Compliance Reports <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="generate-compliance-reports" aria-haspopup="dialog" aria-label="Share link: Generate Compliance Reports"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-bash" data-lang="bash"># Generate GDPR compliance report geode governance-report --framework=gdpr \ --include=data-inventory,lineage,access-log \ --start-date=2025-01-01 \ --end-date=2025-12-31 \ --output=gdpr-compliance-2025.pdf # Generate data quality report geode governance-report --type=data-quality \ --metrics=completeness,accuracy,consistency \ --output=data-quality-report.json # Generate access report geode governance-report --type=access-audit \ --user=[email protected] \ --include-lineage=true \ --output=access-audit.json </code></pre></div> <h4 id="compliance-dashboards" class="position-relative d-flex align-items-center group"> Compliance 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="compliance-dashboards" aria-haspopup="dialog" aria-label="Share link: Compliance Dashboards"> Share link </button> </h4><div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Data quality dashboard metrics MATCH (m:DataQualityMetric) WHERE m.timestamp > current_timestamp() - duration('P1D') RETURN m.name, avg(m.completeness_pct) AS avg_completeness ORDER BY m.name; -- Policy compliance metrics MATCH (entry:CatalogEntry)-[:GOVERNED_BY]->(policy) MATCH (violation:PolicyViolation)-[:VIOLATED]->(policy) RETURN policy.name, count(DISTINCT entry) AS governed_assets, count(violation) AS violations, 100.0 * (1 - count(violation)::float / count(DISTINCT entry)) AS compliance_pct; </code></pre></div> <h3 id="data-discovery" class="position-relative d-flex align-items-center group"> Data Discovery <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-discovery" aria-haspopup="dialog" aria-label="Share link: Data Discovery"> Share link </button> </h3> <h4 id="self-service-discovery" class="position-relative d-flex align-items-center group"> Self-Service Discovery <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="self-service-discovery" aria-haspopup="dialog" aria-label="Share link: Self-Service Discovery"> Share link </button> </h4>Enable users to discover data: <div class="highlight"><pre tabindex="0" class="chroma"><code class="language-gql" data-lang="gql">-- Search catalog by keyword MATCH (entry:CatalogEntry) WHERE entry.name CONTAINS $keyword OR entry.description CONTAINS $keyword OR ANY(tag IN entry.tags WHERE tag CONTAINS $keyword) RETURN entry.name, entry.description, entry.tags, entry.owner; -- Browse by classification MATCH (entry:CatalogEntry)-[:CLASSIFIED_AS]->(level:ClassificationLevel) WHERE level.name = $classification RETURN entry.name, entry.description; -- Find related datasets MATCH (entry:CatalogEntry {id: $dataset_id})-[:RELATED_TO*1..2]-(related:CatalogEntry) RETURN DISTINCT related.name, related.description; </code></pre></div> <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><ol> <li>Establish Clear Ownership: Assign data stewards for all critical data assets</li> <li>Document Everything: Maintain comprehensive metadata for all data</li> <li>Automate Quality Checks: Run automated data quality checks regularly</li> <li>Track Lineage: Enable automatic lineage tracking for all data flows</li> <li>Classify Appropriately: Classify all data by sensitivity level</li> <li>Enforce Policies: Use automated policy enforcement, not just documentation</li> <li>Regular Audits: Conduct periodic governance audits</li> <li>User Education: Train users on governance policies and tools</li> <li>Measure Effectiveness: Track governance metrics and KPIs</li> <li>Continuous Improvement: Regularly review and update governance policies</li> </ol> <h3 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> </h3><ul> <li><a href="/tags/compliance/" >Compliance</a> - Regulatory compliance frameworks</li> <li><a href="/tags/audit-logging/" >Audit Logging</a> - Comprehensive audit trails</li> <li><a href="/tags/row-level-security/" >Row-Level Security</a> - Fine-grained access control</li> <li><a href="/tags/data-integrity/" >Data Integrity</a> - Data consistency and validation</li> <li><a href="/tags/encryption/" >Encryption</a> - Data protection with encryption</li> <li><a href="/tags/configuration/" >Configuration</a> - Governance configuration settings</li> <li><a href="/tags/schema/" >Schema</a> - Schema design and constraints</li> <li><a href="/docs/security/authorization/" >Authorization</a> - Permission management</li> </ul>

Popular

Related Articles

Development

Governance and Requirements Tracking